// EmpEditDlg.cpp : implementation file
//

#include "stdafx.h"
#include "HrSys.h"
#include "EmpEditDlg.h"
#include "Employees.h"
#include "EmpSelDlg.h"
#include "ADOConn.h"

extern CUsers curUser;

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CEmpEditDlg dialog


CEmpEditDlg::CEmpEditDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CEmpEditDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CEmpEditDlg)
	m_Badge = _T("");
	m_Contract = _T("");
	m_EmpName = _T("");
	m_Culture = _T("");
	m_Family = _T("");
	m_File = _T("");
	m_Fillperson = _T("");
	m_Filltime = _T("");
	m_Hukou = _T("");
	m_Idcard = _T("");
	m_Marital = _T("");
	m_Memo = _T("");
	m_Mobile = _T("");
	m_Nation = _T("");
	m_Office = _T("");
	m_Political = _T("");
	m_Position = _T("");
	m_Title = _T("");
	m_Birth = 0;
	m_HireDate = 0;
	m_Upper = _T("");
	//}}AFX_DATA_INIT
}


void CEmpEditDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CEmpEditDlg)
	DDX_Control(pDX, IDC_STATE_COMBO, m_State);
	DDX_Control(pDX, IDC_SEX_COMBO, m_Sex);
	DDX_Text(pDX, IDC_BADGE_EDIT, m_Badge);
	DDX_Text(pDX, IDC_CONTRACT_EDIT, m_Contract);
	DDX_Text(pDX, IDC_EMPNAME_EDIT, m_EmpName);
	DDX_Text(pDX, IDC_CULTURE_EDIT, m_Culture);
	DDX_Text(pDX, IDC_FAMILY_EDIT, m_Family);
	DDX_Text(pDX, IDC_FILE_EDIT, m_File);
	DDX_Text(pDX, IDC_FILLPERSON_STATIC, m_Fillperson);
	DDX_Text(pDX, IDC_FILLTIME_STATIC, m_Filltime);
	DDX_Text(pDX, IDC_HUKOU_EDIT, m_Hukou);
	DDX_Text(pDX, IDC_ID_EDIT, m_Idcard);
	DDX_Text(pDX, IDC_MARITAL_EDIT, m_Marital);
	DDX_Text(pDX, IDC_MEMO_EDIT, m_Memo);
	DDX_Text(pDX, IDC_MOBILE_EDIT, m_Mobile);
	DDX_Text(pDX, IDC_NATION_EDIT, m_Nation);
	DDX_Text(pDX, IDC_OFFICE_EDIT, m_Office);
	DDX_Text(pDX, IDC_POLITICAL_EDIT, m_Political);
	DDX_Text(pDX, IDC_POSITION, m_Position);
	DDX_Text(pDX, IDC_TITLE_EDIT, m_Title);
	DDX_DateTimeCtrl(pDX, IDC_BIRTH, m_Birth);
	DDX_DateTimeCtrl(pDX, IDC_HIREDATE, m_HireDate);
	DDX_Text(pDX, IDC_UPPER_STATIC, m_Upper);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CEmpEditDlg, CDialog)
	//{{AFX_MSG_MAP(CEmpEditDlg)
	ON_BN_CLICKED(IDC_EMPSEL_BUTTON, OnEmpselButton)
	ON_BN_CLICKED(IDC_SETPHOTO_BUTTON, OnSetphotoButton)
	ON_WM_PAINT()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CEmpEditDlg message handlers

void CEmpEditDlg::OnOK() 
{
	// TODO: Add extra validation here
	UpdateData(TRUE);
	CEmployees emp;
	
	//將用戶輸入的數據賦值到對象dep中，為更新數據庫做準備
	emp.EmpName = m_EmpName;
	int index;
	index = m_Sex.GetCurSel();
	if (index == 0)
		emp.Sex = "男";
	else
		emp.Sex = "女";
	emp.Nationality = m_Nation;
	emp.Birth = m_Birth.Format("%Y-%m-%d");
	emp.Political_Party = m_Political;
	emp.Culture_Level = m_Culture;
	emp.Marital_Condition = m_Marital;
	emp.Family_Place = m_Family;
	emp.Id_Card = m_Idcard;
	emp.BadgeId = m_Badge;
	emp.Office_phone = m_Office;
	emp.Mobile = m_Mobile;
	emp.Files_Keep_Org = m_File;
	emp.Hukou = m_Hukou;
	emp.HireDate = m_HireDate.Format("%Y-%m-%d");
	emp.DepId = DepId;
	emp.Position = m_Position;
	emp.sTitle = m_Title;
	emp.State = m_State.GetCurSel() + 1;
	emp.UpperId = UpperId;
	emp.Memo = m_Memo;
	//自動保存填表人和填表時間
	m_Fillperson = curUser.UserName;
	CTime t = CTime::GetCurrentTime();
	m_Filltime = t.Format("%Y-%m-%d");

	emp.Fillin_Person = m_Fillperson;
	emp.Fillin_Time = m_Filltime;
	
	if (EmpId == 0)  //表示插入數據
		emp.sql_insert();
	else
	{
		//根據DepId的值更新記錄
		CString cEmpId;
		cEmpId.Format("%d", EmpId);
		emp.sql_update(cEmpId);
	}
	
	CDialog::OnOK();
}

void CEmpEditDlg::OnEmpselButton() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	//打開選擇員工對話框
	CEmpSelDlg dlg;
	dlg.DoModal();	
	//根據用戶選擇設置員工信息
	m_Upper = dlg.EmpName;
	UpperId = dlg.EmpId;

	UpdateData(FALSE);
}

BOOL CEmpEditDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//設置性別
	if (cSex == "男")
		m_Sex.SetCurSel(0);
	else
		m_Sex.SetCurSel(1);
	//設置狀態
	m_State.SetCurSel(iState-1);	
	//如果是添加新員工，則將設置和刪除照片的按鈕置灰
	if (EmpId == 0)
		GetDlgItem(IDC_SETPHOTO_BUTTON)->EnableWindow(FALSE);
	else  //讀取照片圖像信息
	{
		//清除原圖像數據
		if(m_hBitmap)
		{
			DeleteObject(m_hBitmap);
			m_hBitmap = NULL;
		}
		//將當前員工記錄讀取到m_pRs對象中
		CString cEmpId;
		cEmpId.Format("%d", EmpId);
		//連接數據庫
		ADOConn m_AdoConn;
		m_AdoConn.OnInitADOConn();
		//設置SELECT語句
		_bstr_t vSQL;
		vSQL = "SELECT * FROM Employees WHERE EmpId=" + cEmpId;
		//執行SELETE語句
		_RecordsetPtr	m_pRs;
		m_pRs = m_AdoConn.GetRecordSet(vSQL);	

		//如果不存在此記錄，則將設置按鈕置灰并返回
		if(m_pRs->adoEOF || m_pRs->adoBOF)  
		{
			GetDlgItem(IDC_SETPHOTO_BUTTON)->EnableWindow(FALSE);
			return FALSE;
		}
		//讀取圖像字段的實際大小
		long lDataSize = m_pRs->GetFields()->GetItem("Photo")->ActualSize;
		char *m_pBuffer;  //定義緩沖變量
		if(lDataSize > 0)
		{
			//從圖像字段中讀取數據到varBLOB中
			_variant_t varBLOB;
			varBLOB = m_pRs->GetFields()->GetItem("Photo")->GetChunk(lDataSize);
			if(varBLOB.vt == (VT_ARRAY | VT_UI1))
			{
				if(m_pBuffer = new char[lDataSize+1])	//分配必要的存儲空間
				{	
					char *pBuf = NULL;
					SafeArrayAccessData(varBLOB.parray,(void **)&pBuf);
					memcpy(m_pBuffer,pBuf,lDataSize); ///復制數據到緩沖區m_pBuffer
					SafeArrayUnaccessData (varBLOB.parray);
					
					//將數據轉換為HBITMAP格式
					LPSTR hDIB;
					LPVOID lpDIBBits;
					BITMAPFILEHEADER bmfHeader;  //用于保存BMP文件頭信息，包括類型、大小、位移量等
					DWORD bmfHeaderLen;  //保存文件頭的長度

					bmfHeaderLen = sizeof(bmfHeader);  //讀取文件頭的長度
					//將m_pBuffer中文件頭復制到bmfHeader中
					strncpy((LPSTR)&bmfHeader, (LPSTR)m_pBuffer, bmfHeaderLen); 	
					if (bmfHeader.bfType != (*(WORD*)"BM"))   //如果文件類型不對，則返回
					{
						MessageBox("BMP文件格式不準確");
						return FALSE;
					}
					hDIB = m_pBuffer + bmfHeaderLen;  //將指針移至文件頭后面
					//讀取BMP文件的圖像數據，包括坐標及顏色格式等信息到BITMAPINFOHEADER對象
					BITMAPINFOHEADER &bmiHeader = *(LPBITMAPINFOHEADER)hDIB;
					//讀取BMP文件的圖像數據，包括坐標及顏色格式等信息到BITMAPINFO對象
					BITMAPINFO &bmInfo = *(LPBITMAPINFO)hDIB ;
					//根據bfOffBits屬性將指針移至文件頭后
					lpDIBBits = (m_pBuffer) + ((BITMAPFILEHEADER *)m_pBuffer)->bfOffBits;
					CClientDC dc(this);  //生成一個與當前窗口相關的CClientDC，用于管理輸出設置
					//生成DIBitmap數據
					m_hBitmap = CreateDIBitmap(dc.m_hDC,&bmiHeader,CBM_INIT,lpDIBBits,&bmInfo,DIB_RGB_COLORS);
				}
			}
		}
	}

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CEmpEditDlg::OnSetphotoButton() 
{
	// TODO: Add your control notification handler code here
	static char BASED_CODE szFilter[] = "BMP Files (*.bmp)|*.bmp|All Files (*.*)|*.*||";
	CFileDialog dlg(TRUE,"BMP",NULL,  OFN_HIDEREADONLY | OFN_OVERWRITEPROMPT,szFilter);
	if(dlg.DoModal() != IDOK)
		return;

	CString pathname = dlg.GetPathName();

	char *m_pBuffer;  //從BMP文件中讀取的數據存放在此變量中
	
	//@@@@@@@@@@   讀取BMP文件到m_pBuffer   @@@@@@@@@@
	CFile file;  //定義文件對象
	if( !file.Open(pathname, CFile::modeRead)) //以只讀方式打開文件
	{
		MessageBox("無法打開BMP文件");
		return;
	}
	DWORD m_filelen;  //用于保存文件長度
	m_filelen = file.GetLength();  //讀取文件長度
	m_pBuffer = new char[m_filelen + 1]; //根據文件長度分配數組空間
	if(!m_pBuffer)  //如果不空間不足則返回
	{
		MessageBox("無法分配足夠的內存空間");
		return;
	}
	if(file.ReadHuge(m_pBuffer, m_filelen) != m_filelen)  //讀取BMP文件到m_pBuffer中
	{
		MessageBox("讀取BMP文件時出現錯誤");
		return;
	}
	
	//@@@@@@@@@@   將BMP文件數據從m_pBuffer中轉換到m_hBitMap位圖句柄中
	LPSTR hDIB;
	LPVOID lpDIBBits;
	BITMAPFILEHEADER bmfHeader;  //用于保存BMP文件頭信息，包括類型、大小、位移量等
	DWORD bmfHeaderLen;  //保存文件頭的長度

	bmfHeaderLen = sizeof(bmfHeader);  //讀取文件頭的長度
	//將m_pBuffer中文件頭復制到bmfHeader中
	strncpy((LPSTR)&bmfHeader, (LPSTR)m_pBuffer, bmfHeaderLen); 	
	if (bmfHeader.bfType != (*(WORD*)"BM"))   //如果文件類型不對，則返回
	{
		MessageBox("BMP文件格式不準確");
		return;
	}
	hDIB = m_pBuffer + bmfHeaderLen;  //將指針移至文件頭后面
	//讀取BMP文件的圖像數據，包括坐標及顏色格式等信息到BITMAPINFOHEADER對象
	BITMAPINFOHEADER &bmiHeader = *(LPBITMAPINFOHEADER)hDIB;
	//讀取BMP文件的圖像數據，包括坐標及顏色格式等信息到BITMAPINFO對象
	BITMAPINFO &bmInfo = *(LPBITMAPINFO)hDIB ;
	//根據bfOffBits屬性將指針移至文件頭后
	lpDIBBits = (m_pBuffer) + ((BITMAPFILEHEADER *)m_pBuffer)->bfOffBits;
	CClientDC dc(this);  //生成一個與當前窗口相關的CClientDC，用于管理輸出設置
	//生成DIBitmap數據
	m_hBitmap = CreateDIBitmap(dc.m_hDC,&bmiHeader,CBM_INIT,lpDIBBits,&bmInfo,DIB_RGB_COLORS);
	
	//激活OnPaint()函數，顯示圖像
	Invalidate();
	//@@@@@@@@@@@  將圖像數據保存到數據庫中  @@@@@@@@@@@@@
	//將當前員工記錄讀取到m_pRs對象中
	CString cEmpId;
	cEmpId.Format("%d", EmpId);
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Employees WHERE EmpId=" + cEmpId;
	//執行SELETE語句
	_RecordsetPtr	m_pRs;
	m_pRs = m_AdoConn.GetRecordSet(vSQL);	

	VARIANT			varBLOB;
	SAFEARRAY		*psa;  //定義數組
    SAFEARRAYBOUND	rgsabound[1];

	rgsabound[0].lLbound = 0;
	rgsabound[0].cElements = m_filelen;
	psa = SafeArrayCreate(VT_UI1, 1, rgsabound);  //創建數組
	for (long i = 0; i < (long)m_filelen; i++)  //將m_pBuffer中的圖像數據寫入數組psa
		SafeArrayPutElement (psa, &i, m_pBuffer++);
	varBLOB.vt = VT_ARRAY | VT_UI1;
	varBLOB.parray = psa;
	//調用AppendChunk()函數將圖像數據寫入Photo字段
	m_pRs->GetFields()->GetItem("Photo")->AppendChunk(varBLOB);
	//更新數據庫
	m_pRs->Update();
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}


void CEmpEditDlg::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
	int x=512, y=24;
	int iWidth=72, iHeight=79;
	// TODO: Add your message handler code here
	if(!m_hBitmap)  //如果內存中沒有BMP數據，則返回
		return;
	HBITMAP tmpBitmap;  //用于保存輸出到屏幕的BMP數據
	CDC MemDC;  //CDC對象，用于輸出到屏幕
	MemDC.CreateCompatibleDC(&dc);
	tmpBitmap = (HBITMAP)MemDC.SelectObject(m_hBitmap);
	dc.BitBlt(x,y,iWidth,iHeight,&MemDC,0,0,SRCCOPY);
	MemDC.SelectObject(tmpBitmap);
	
	// Do not call CDialog::OnPaint() for painting messages
}