yuangongeditdlg.cpp

人事管理系统VC6

// YuangongEditDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Renshi.h"
#include "YuangongEditDlg.h"
#include "Class\Yuangong.h"
#include "Class\admin.h"

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

/////////////////////////////////////////////////////////////////////////////
// CYuangongEditDlg dialog

extern CAdmin g_curAdmin;
extern CRenshiApp theApp;

CYuangongEditDlg::CYuangongEditDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CYuangongEditDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CYuangongEditDlg)
	m_Badge = _T("");
	m_Contract = _T("");
	m_YgName = _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;
	//}}AFX_DATA_INIT
}


void CYuangongEditDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CYuangongEditDlg)
	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_YgName);
	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);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CYuangongEditDlg, CDialog)
	//{{AFX_MSG_MAP(CYuangongEditDlg)
	ON_BN_CLICKED(IDC_SETPHOTO_BUTTON, OnSetphotoButton)
	ON_WM_PAINT()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CYuangongEditDlg message handlers

BOOL CYuangongEditDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	//设置性别
	if (cSex == "男")
		m_Sex.SetCurSel(0);
	else
		m_Sex.SetCurSel(1);


	//设置状态
	m_State.SetCurSel(iState-1);


	
	//如果是添加新员工，则将设置和删除照片的按钮置灰
	if (YgID == 0)
	{
		//GetDlgItem(IDC_SETPHOTO_BUTTON)->EnableWindow(FALSE);
	}
	else  //读取照片图像信息
	{
		//清除原图像数据
		if(m_hBitmap)
		{
			DeleteObject(m_hBitmap);
			m_hBitmap = NULL;
		}
		//将当前员工记录读取到m_pRs对象中
		CString cYgID;
		cYgID.Format("%d", YgID);
		CString vSQL("SELECT * FROM Yuangong WHERE yg_ID=" + cYgID);
		_RecordsetPtr  m_pRs= theApp.m_ado.GetRS(vSQL);	
		
/*
		if(m_pRs->adoEOF || m_pRs->adoBOF)  
		{
			GetDlgItem(IDC_SETPHOTO_BUTTON)->EnableWindow(FALSE);				//如果不存在此记录，则将设置按钮置灰并返回
			return FALSE;
		}

*/		
		long lPhotoSize = m_pRs->GetFields()->GetItem("Photo")->ActualSize;		//读取图像字段的实际大小
		char *pBuf; 
		if(lPhotoSize > 0)
		{		
			_variant_t varBLOB = m_pRs->GetFields()->GetItem("Photo")->GetChunk(lPhotoSize);		//从图像字段中读取数据到varBLOB中
			if(varBLOB.vt == (VT_ARRAY | VT_UI1))
			{
				if(pBuf = new char[lPhotoSize+1])								//分配必要的存储空间
				{	
					char *pBuf = NULL;
					SafeArrayAccessData(varBLOB.parray,(void **)&pBuf);
					memcpy(pBuf,pBuf,lPhotoSize);								//复制数据到缓冲区pBuf
					SafeArrayUnaccessData (varBLOB.parray);
					
					/*-------------------将数据转换为HBITMAP格式----------------------------*/
					LPSTR hDIB;
					LPVOID lpDIBBits;
					BITMAPFILEHEADER bmfHeader;									//用于保存BMP文件头信息，包括类型、大小、位移量等
					DWORD bmfHeaderLen;											//保存文件头的长度

					bmfHeaderLen = sizeof(bmfHeader);							//读取文件头的长度
					
					strncpy((LPSTR)&bmfHeader, (LPSTR)pBuf, bmfHeaderLen); 		//将pBuf中文件头复制到bmfHeader中
					if (bmfHeader.bfType != (*(WORD*)"BM"))						//如果文件类型不对，则返回
					{
						MessageBox("BMP文件格式不准确");
						return FALSE;
					}
					hDIB = pBuf + bmfHeaderLen;									//将指针移至文件头后面
					BITMAPINFOHEADER &bmiHeader = *(LPBITMAPINFOHEADER)hDIB;	//读取BMP文件的图像数据，包括坐标及颜色格式等信息到BITMAPINFOHEADER对象
					BITMAPINFO &bmInfo = *(LPBITMAPINFO)hDIB ;					//读取BMP文件的图像数据，包括坐标及颜色格式等信息到BITMAPINFO对象
					lpDIBBits = (pBuf) + ((BITMAPFILEHEADER *)pBuf)->bfOffBits;	//根据bfOffBits属性将指针移至文件头后
					CClientDC dc(this);											//生成一个与当前窗口相关的CClientDC，用于管理输出设置
					m_hBitmap = CreateDIBitmap(dc.m_hDC,&bmiHeader,CBM_INIT,lpDIBBits,&bmInfo,DIB_RGB_COLORS); //生成DIBitmap数据
				}
			}
		}
	}	
	return TRUE;  
}

void CYuangongEditDlg::OnSetphotoButton() 
{
	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;

	CFile file; 
	if( !file.Open(dlg.GetPathName(), CFile::modeRead))
	{
		MessageBox("无法打开BMP文件");
		return;
	}

	DWORD nLen = file.GetLength();   //读取文件长度
	char *pBuf = new char[nLen + 1]; //根据文件长度分配数组空间
	if(!pBuf)						 //如果不空间不足则返回
	{
		MessageBox("无法分配足够的内存空间");
		return;
	}
	if(file.ReadHuge(pBuf, nLen) != nLen)  //读取BMP文件到pBuf中
	{
		MessageBox("读取BMP文件时出现错误");
		return;
	}
	
	/*--------------------将BMP文件数据从pBuf中转换到m_hBitMap位图句柄中--------------------*/
	LPSTR hDIB;
	LPVOID lpDIBBits;
	BITMAPFILEHEADER bmfHeader;								    //用于保存BMP文件头信息，包括类型、大小、位移量等
	DWORD bmfHeaderLen= sizeof(bmfHeader);						//读取文件头的长度

	strncpy((LPSTR)&bmfHeader, (LPSTR)pBuf, bmfHeaderLen); 		//将pBuf中文件头复制到bmfHeader中
	if (bmfHeader.bfType != (*(WORD*)"BM"))					    //如果文件类型不对，则返回
	{
		MessageBox("BMP文件格式不准确");
		return;
	}

	hDIB = pBuf + bmfHeaderLen;									//将指针移至文件头后面
	
	BITMAPINFOHEADER &bmiHeader = *(LPBITMAPINFOHEADER)hDIB;	//读取BMP文件的图像数据，包括坐标及颜色格式等信息到BITMAPINFOHEADER对象

	BITMAPINFO &bmInfo = *(LPBITMAPINFO)hDIB ;					//读取BMP文件的图像数据，包括坐标及颜色格式等信息到BITMAPINFO对象
	//根据bfOffBits属性将指针移至文件头后
	lpDIBBits = (pBuf) + ((BITMAPFILEHEADER *)pBuf)->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 cYgID;
	cYgID.Format("%d", YgID);
	//连接数据库
	CADO m_AdoConn;
	//设置SELECT语句
	CString vSQL;
	vSQL = "SELECT * FROM Yuangong WHERE yg_ID=" + cYgID;
	//执行SELETE语句
	_RecordsetPtr	m_pRs;
	m_pRs = m_AdoConn.GetRS(vSQL);	

	VARIANT			varBLOB;
	SAFEARRAY		*psa;  //定义数组
    SAFEARRAYBOUND	rgsabound[1];

	rgsabound[0].lLbound = 0;
	rgsabound[0].cElements = nLen;
	psa = SafeArrayCreate(VT_UI1, 1, rgsabound);  //创建数组
	for (long i = 0; i < (long)nLen; i++)  //将pBuf中的图像数据写入数组psa
		SafeArrayPutElement (psa, &i, pBuf++);
	varBLOB.vt = VT_ARRAY | VT_UI1;
	varBLOB.parray = psa;
	//调用AppendChunk()函数将图像数据写入Photo字段
	m_pRs->GetFields()->GetItem("Photo")->AppendChunk(varBLOB);
	//更新数据库
	m_pRs->Update();
	//断开与数据库的连接
}

void CYuangongEditDlg::OnPaint() 
{	
	CPaintDC dc(this); 
	
	int x=512, y=24;
	int iWidth=72, iHeight=79;

	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
}



void CYuangongEditDlg::OnOK() 
{
	UpdateData(TRUE);
	CYuangong Yg;
	
	//将用户输入的数据赋值到对象Bumen中，为更新数据库做准备
	Yg.Setyg_Name(m_YgName);
	int index;
	index = m_Sex.GetCurSel();
	if (index == 0)
		Yg.SetSex("男");
	else
		Yg.SetSex("女");
	Yg.SetNationality(m_Nation);
	Yg.SetBirth(m_Birth.Format("%Y-%m-%d"));
	Yg.SetPolitical_Party(m_Political);
	Yg.SetCulture_Level(m_Culture);
	Yg.SetMarital_Condition(m_Marital);
	Yg.SetFamily_Place(m_Family);
	Yg.SetID_Card(m_IDcard);
	Yg.SetBadgeID(m_Badge);
	Yg.SetOffice_phone(m_Office);
	Yg.SetMobile(m_Mobile);
	Yg.SetFiles_Keep_Org(m_File);
	Yg.SetHukou(m_Hukou);
	Yg.SetHireDate(m_HireDate.Format("%Y-%m-%d"));
	Yg.SetBumenID(BumenID);
	Yg.SetPosition(m_Position);
	Yg.SetTitle(m_Title);
	Yg.SetState(m_State.GetCurSel() + 1);
	Yg.SetUpperID(UpperID);
	Yg.SetContract_Duration(m_Contract);
	Yg.SetMemo(m_Memo);
	//自动保存填表人和填表时间
	m_Fillperson = g_curAdmin.GetUserName();
	CTime t = CTime::GetCurrentTime();
	m_Filltime = t.Format("%Y-%m-%d");

	Yg.SetFillAdmin(m_Fillperson);
	Yg.SetFillDate(m_Filltime);
	
	if (YgID == 0)  //表示插入数据
		//判断部门名称是否存在
		if (Yg.HaveName(m_YgName) == 1)
		{
			MessageBox("员工姓名已经存在，请重新输入！");
			return;
		}
		else
		//返回插入记录的编号
			Yg.sql_insert();
	else
	{
		//如果用户修改了部门名称，则判断新部门名称是否存在
		if (m_YgName != YgName)
		{
			if (Yg.HaveName(m_YgName) == 1)
			{
				MessageBox("员工姓名已经存在，请重新输入！");
				return;
			}
		}
		//根据BumenID的值更新记录
		CString cYgID;
		cYgID.Format("%d", YgID);
		Yg.sql_update(cYgID);
	}
	
	CDialog::OnOK();	
}