www.pudn.com > rsdagl.rar > AddDate.cpp

// AddDate.cpp : 实现文件 
// 
 
#include "stdafx.h" 
#include "人事管理系统.h" 
#include "AddDate.h" 
#include ".\adddate.h" 
#include "Picture.h" 
#include "MainFrm.h" 
 
 
// CAddDate 对话框 
 
IMPLEMENT_DYNAMIC(CAddDate, CDialog) 
CAddDate::CAddDate(CWnd* pParent /*=NULL*/) 
	: CDialog(CAddDate::IDD, pParent) 
 
	, m_Records(0) 
	, m_collectnum(0) 
{ 
	//AfxOleInit(); 
} 
 
CAddDate::~CAddDate() 
{ 
} 
 
void CAddDate::DoDataExchange(CDataExchange* pDX) 
{ 
	CDialog::DoDataExchange(pDX); 
} 
 
 
BEGIN_MESSAGE_MAP(CAddDate, CDialog) 
	ON_BN_CLICKED(IDC_ADD, OnBnClickedAdd) 
	ON_BN_CLICKED(IDC_BUTTON1, OnBnClickedButton1) 
	ON_BN_CLICKED(IDC_BACK, OnBnClickedBack) 
	ON_BN_CLICKED(IDC_NEXT2, OnBnClickedNext2) 
	ON_BN_CLICKED(IDC_ADD2, OnBnClickedAdd2) 
	ON_BN_CLICKED(IDC_ADD3, OnBnClickedAdd3) 
	ON_BN_CLICKED(IDC_REWRITE, OnBnClickedRewrite) 
END_MESSAGE_MAP() 
 
 
// CAddDate 消息处理程序 
 
BOOL CAddDate::OnInitDialog() 
{ 
	CDialog::OnInitDialog(); 
 
	// TODO:  在此添加额外的初始化 
 
	//设置始终最上于窗口. 
	CRect rc; 
	GetWindowRect(&rc); 
	SetWindowPos(&wndTopMost,rc.left,rc.top,rc.bottom,rc.right,SWP_NOMOVE|SWP_NOSIZE|SWP_NOACTIVATE); 
	CenterWindow();  
 
	//获取数据库中的记录总数 
	InitDatebase(); 
	int nums=0; 
	while(!m_pRecordset->adoEOF) 
	{ 
		nums++; 
		m_pRecordset->MoveNext(); 
	} 
	m_pRecordset->Close(); 
	m_collectnum=nums; 
 
 
 
	 
 
 
	return TRUE;  // return TRUE unless you set the focus to a control 
	// 异常: OCX 属性页应返回 FALSE 
} 
 
bool CAddDate::InitDatebase(void) 
{ 
     
	m_pRecordset.CreateInstance(_uuidof(Recordset)); 
	try 
	{ 
		m_pRecordset->Open("SELECT * FROM 基本信息 ORDER BY 员工编号",theApp.m_pConnection.GetInterfacePtr(),adOpenDynamic,adLockOptimistic,adCmdText); 
	} 
	catch(_com_error se) 
	{ 
		AfxMessageBox(se.ErrorMessage()); 
		return false; 
	} 
	return true; 
} 
 
void CAddDate::OnBnClickedAdd() //添加记录 
{ 
	//Invalidate(); 
	CString Cygbh,Cygxm,Cxb,Czy,Cxl,Ccsny,Cbyrq,Ctc,Chk,Cbyxx,Cjtdz,Csj,Csfzh,Chyzk; 
	CString Cssbm,Cdqzw,Cxsdj,Cdzyj,Cbz,Czzzk,Cmz; 
	//1员工编号,2员工姓名,3性别,4专业,5学历,6出生年月,7毕业日期,8特长,9户口,10毕业学校,11家庭地址,12手机,13身份证号,14,婚姻状况, 
	//15,js,16,所属部门,17,当前职位,18,薪水等级,19,电子邮件,20,人事备注,21在职状况,22;民族 
	GetDlgItemText(IDC_YGBH,Cygbh);//1 
	GetDlgItemText(IDC_YGXM,Cygxm);//2 
	GetDlgItemText(IDC_XB,Cxb);//3 
	GetDlgItemText(IDC_ZY,Czy);//4 
	GetDlgItemText(IDC_XL,Cxl);//5 
	GetDlgItemText(IDC_CSNY,Ccsny);//6 
	GetDlgItemText(IDC_BYRQ,Cbyrq);//7 
	GetDlgItemText(IDC_TC,Ctc);//8 
	GetDlgItemText(IDC_HK,Chk);//9 
	GetDlgItemText(IDC_BYXX,Cbyxx);//10 
	GetDlgItemText(IDC_JTDZ,Cjtdz);//11 
	GetDlgItemText(IDC_SJHM,Csj);//12 
	GetDlgItemText(IDC_SFZH,Csfzh);//13 
	GetDlgItemText(IDC_HYZK,Chyzk);//14 
		//15,js,16,所属部门,17,当前职位,18,薪水等级,19,电子邮件,20,人事备注 
		//CString Cssbm,Cdqzw,Cxsdj,Cdzyj,Cbz,Czzzk; 
	GetDlgItemText(IDC_SSBM,Cssbm);//16 
	GetDlgItemText(IDC_DQZW,Cdqzw);//17 
	GetDlgItemText(IDC_XSDJ,Cxsdj);//18 
	GetDlgItemText(IDC_DZYJ,Cdzyj);//19 
	GetDlgItemText(IDC_BZ,Cbz);//20 
	GetDlgItemText(IDC_ZZZKD,Czzzk);//21 
	GetDlgItemText(IDC_MZ,Cmz); 
	if(strcmp(Cygbh,"")==0) 
	{ 
		AfxMessageBox("员工编号没有填写!"); 
		GetDlgItem(IDC_YGBH)->SetFocus(); 
		return; 
	} 
	if(strcmp(Cygxm,"")==0) 
	{ 
		AfxMessageBox("员工姓名没有填写!"); 
		GetDlgItem(IDC_YGXM)->SetFocus(); 
		return; 
	} 
	if(strcmp(Cxb,"")==0) //3 
	{ 
		Cxb="男"; 
	} 
	if(strcmp(Czy,"")==0)//4 
	{ 
		Czy="-"; 
	} 
	if(strcmp(Cxl,"")==0)//5 
	{ 
		Cxl="-"; 
	} 
	if(strcmp(Ctc,"")==0)//8 
	{ 
		Ctc="-"; 
	} 
	if(strcmp(Chk,"")==0)//9 
	{ 
		Chk="-"; 
	} 
	if(strcmp(Cbyxx,"")==0)//10 
	{ 
		Cbyxx="-"; 
	} 
	if(strcmp(Cjtdz,"")==0)//11 
	{ 
		Cjtdz="-"; 
	} 
	if(strcmp(Csj,"")==0) //12 
	{ 
		Csj="-"; 
	} 
	if(strcmp(Csfzh,"")==0) //13 
	{ 
		Csfzh="-"; 
	} 
	if(strcmp(Chyzk,"")==0)//14 
	{ 
		Chyzk="-"; 
	} 
	//Cssbm,Cdqzw,Cxsdj,Cdzyj,Cbz,Czzzk; 
	if(strcmp(Cssbm,"")==0)//16 
	{ 
		Cssbm="-"; 
	} 
	if(strcmp(Cdqzw,"")==0)//17 
	{ 
		Cdqzw="-"; 
	} 
	if(strcmp(Cxsdj,"")==0)//18 
	{ 
		Cxsdj="-"; 
	} 
	if(strcmp(Cdzyj,"")==0)//19 
	{ 
		Cdzyj="-"; 
	} 
	if(strcmp(Cbz,"")==0)//20 
	{ 
		Cbz="-"; 
	} 
	if(strcmp(Czzzk,"")==0)//21 
	{ 
		Czzzk="在职"; 
	} 
	if(strcmp(Cmz,"")==0)//21 
	{ 
		Cmz="-"; 
	} 
	if(m_Filename.IsEmpty()) 
		m_Filename="CIBAS.JPG"; 
 
	//////////////////////////////保存////////////////////////////// 
	if(InitDatebase()) 
	{ 
		try 
		{ 
			int number=1; 
			if(!m_pRecordset->adoEOF) 
				m_pRecordset->MoveFirst(); 
			while(!m_pRecordset->adoEOF) 
			{ 
				number++; 
				m_pRecordset->MoveNext(); 
			} 
			m_pRecordset->AddNew(); 
			m_pRecordset->PutCollect("id",_variant_t(number)); 
			m_pRecordset->PutCollect("员工编号",_variant_t(Cygbh));		 
			m_pRecordset->PutCollect("员工姓名",_variant_t(Cygxm));			 
			m_pRecordset->PutCollect("性别",_variant_t(Cxb));			 
			m_pRecordset->PutCollect("专业",_variant_t(Czy));			 
			m_pRecordset->PutCollect("学历",_variant_t(Cxl));			 
			m_pRecordset->PutCollect("出生年月",_variant_t(Ccsny));		 
			m_pRecordset->PutCollect("毕业日期",_variant_t(Cbyrq));		 
			m_pRecordset->PutCollect("特长",_variant_t(Chk));		 
			m_pRecordset->PutCollect("户口",_variant_t(number));		 
			m_pRecordset->PutCollect("毕业学校",_variant_t(Cbyxx));		 
			m_pRecordset->PutCollect("家庭地址",_variant_t(Cjtdz));		 
			m_pRecordset->PutCollect("手机",_variant_t(Csj));		 
			m_pRecordset->PutCollect("身份证号",_variant_t(Csfzh));	 
			m_pRecordset->PutCollect("婚姻状况",_variant_t(Chyzk)); 
		 
			//15,js,16,所属部门,17,当前职位,18,薪水等级,19,电子邮件,20,人事备注21在职状况22民族 
		 
			//CString Cssbm,Cdqzw,Cxsdj,Cdzyj,Cbz,Czzzk,Cmz;	 
			m_pRecordset->PutCollect("所属部门",_variant_t(Cssbm));		 
			m_pRecordset->PutCollect("当前职位",_variant_t(Cdqzw));		 
			m_pRecordset->PutCollect("薪水等级",_variant_t(Cxsdj));		 
			m_pRecordset->PutCollect("电子邮件",_variant_t(Cdzyj));		 
			m_pRecordset->PutCollect("人事备注",_variant_t(Cbz));	 
			m_pRecordset->PutCollect("在职状况",_variant_t(Czzzk));	 
			m_pRecordset->PutCollect("民族",_variant_t(Cmz)); 
			m_pRecordset->PutCollect("照片路径",_variant_t(m_Filename)); 
			m_pRecordset->Update(); 
			MessageBox("添加记录集成功!"); 
			SetDlgItemText(IDC_YGBH,"");//1 
			SetDlgItemText(IDC_YGXM,"");//2 
			SetDlgItemText(IDC_XB,"");//3 
			SetDlgItemText(IDC_ZY,"");//4 
			SetDlgItemText(IDC_XL,"");//5 
			SetDlgItemText(IDC_CSNY,"");//6 
			SetDlgItemText(IDC_BYRQ,"");//7 
			SetDlgItemText(IDC_TC,"");//8 
			SetDlgItemText(IDC_HK,"");//9 
			SetDlgItemText(IDC_BYXX,"");//10 
			SetDlgItemText(IDC_JTDZ,"");//11 
			SetDlgItemText(IDC_SJHM,"");//12 
			SetDlgItemText(IDC_SFZH,"");//13 
			SetDlgItemText(IDC_HYZK,"");//14 
 
			//15,js,16,所属部门,17,当前职位,18,薪水等级,19,电子邮件,20,人事备注21在职状况22民族 
 
			SetDlgItemText(IDC_SSBM,"");//16 
			SetDlgItemText(IDC_DQZW,"");//17 
			SetDlgItemText(IDC_XSDJ,"");//18 
			SetDlgItemText(IDC_DZYJ,"");//19 
			SetDlgItemText(IDC_BZ,"");//20 
			SetDlgItemText(IDC_ZZZKD,"");//21 
			SetDlgItemText(IDC_MZ,"");//22 
 
		} 
		catch(_com_error e) 
		{ 
			AfxMessageBox("该员工编号请填数字或已经存在!请查询"); 
		} 
 
		// ------ 添加信息 ------  
			 
	} 
	if(strcmp(m_Filename,"CIBAS.JPG")!=0) 
	{	 
		CMainFrame * pPath= (CMainFrame *)AfxGetMainWnd();	 
		CString PathName;	 
		PathName=pPath->m_AdminInfo.SystemPath; 
			//	MessageBox(PathName); 
		PathName+=m_Filename;	 
		CopyFile(m_Filename,PathName,false); //复制图象到photo文件夹下面;	 
		m_Filename="";	 
	} 
 	m_Filename="" ; //文件路径设置为空 
 
} 
 
 
 
void CAddDate::OnBnClickedButton1() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	 
	CFileDialog cs(true); 
	cs.m_ofn.lpstrTitle="软件课程设计2 : 人事管理系统 "; 
	cs.m_ofn.lpstrFilter="jpg files(*.jpg)\0*.jpg\0All Files(*.*)\0*.*\0\0"; 
	cs.m_ofn.lpstrDefExt="jpg"; 
	if(IDOK==cs.DoModal()) 
	{ 
		m_Filename=cs.GetFileName(); 
	//	MessageBox(m_Filename); 
		UpdateData(false); 
	} 
	CFile f;			 
	CFileException e;							 
	if(m_Pic.m_IPicture != NULL) 				 
		m_Pic.FreePictureData(); // Important - Avoid Leaks...			 
	if(f.Open(m_Filename, CFile::modeRead | CFile::typeBinary, &e)) //打开了一个jpg文件					 
	{		 
		int nSize = (int)f.GetLength();          //先得到jpg文件长度 
		BYTE * pBuffer = new BYTE [nSize];  //按文件的大小在堆上申请一块内存 
		f.Read(pBuffer, nSize) ;//把jpg文件读到pBuffer(堆上申请一块内存)		 
		m_Pic.LoadPictureData(pBuffer, nSize);//接作调用函数读pBuffer的jpg数据准备显示				 
		delete [] pBuffer;     //删掉堆上申请的那一块内          			 
		f.Close();			 
	}			 
	CClientDC dc(this); 
	CRect rect; 
	GetDlgItem(IDC_PHOTO)->GetClientRect(rect);//154 134  
 
	rect.left=531; 
	rect.right=rect.right+531; 
	rect.top=11; 
	rect.bottom=rect.bottom+11; 
	m_Pic.UpdateSizeOnDC(&dc); // Get Picture Dimentions In Pixels	 
	m_Pic.Show(&dc, rect);//显示出来看看	 
} 
 
void CAddDate::OnBnClickedBack() 
{ 
	try 
	{ 
	 
		if(m_Records>=1) 
		{ 
			GetDlgItem(IDC_NEXT2)->EnableWindow(true); 
			m_Records--; 
			ShowPhoto(m_Records); 
			InitDatebase(); 
			m_pRecordset->MoveFirst(); 
			m_pRecordset->Move(m_Records); 
		 
			CString	Cygbh,Cygxm,Cbm,Cxb,Ccsny,Cmz,Cjg,Chyzk, Cxl,Czw,Csfzh,Csj,Czzzk,Cxsdj; 
			_variant_t vygbh,vygxm,vbm, vxb,vcsny,vmz,vjg,vhyzk,vxl,vzw,vsfzh,vsj,vzzzk,vxsdj;							 
			CString Czy,Cbyrq,Ctc,Cbyxx,Cjtdz,Cdzyj,Crsbz;				 
			_variant_t vzy,vbyrq,vtc,vbyxx,vjtdz,vdzyj,vrsbz;		 
			vygbh=m_pRecordset->GetCollect("员工编号");			//1		 
			if(vygbh.vt!=VT_NULL)	 
				Cygbh=(LPCSTR)_bstr_t(vygbh);		 
			vygxm=m_pRecordset->GetCollect("员工姓名");		//2 
			if(vygxm.vt!=VT_NULL)		 
				Cygxm=(LPCSTR)_bstr_t(vygxm); 
			vbm=m_pRecordset->GetCollect("所属部门");		//3	 
			if(vbm.vt!=VT_NULL) 
				Cbm=(LPCSTR)_bstr_t(vbm); 
			vxb=m_pRecordset->GetCollect("性别");			//4	 
			if(vxb.vt!=VT_NULL) 
				Cxb=(LPCSTR)_bstr_t(vxb);	 
			vcsny=m_pRecordset->GetCollect("出生年月");		//5 
			if(vcsny.vt!=VT_NULL) 
				Ccsny=(LPCSTR)_bstr_t(vcsny); 
			vmz=m_pRecordset->GetCollect("民族");			//6  
			if(vmz.vt!=VT_NULL)	 
				Cmz=(LPCSTR)_bstr_t(vmz); 
			vjg=m_pRecordset->GetCollect("户口");			//7  
			if(vjg.vt!=VT_NULL) 
				Cjg=(LPCSTR)_bstr_t(vjg);	 
			vhyzk=m_pRecordset->GetCollect("婚姻状况");		//8 
			if(vhyzk.vt!=VT_NULL) 
				Chyzk=(LPCSTR)_bstr_t(vhyzk);	 
			vxl=m_pRecordset->GetCollect("学历");			//9 
			if(vxl.vt!=VT_NULL) 
				Cxl=(LPCSTR)_bstr_t(vxl);		 
			vzw=m_pRecordset->GetCollect("当前职位");		//10 
			if(vzw.vt!=VT_NULL) 
				Czw=(LPCSTR)_bstr_t(vzw);		 
			vsfzh=m_pRecordset->GetCollect("身份证号");		//11 
			if(vsfzh.vt!=VT_NULL) 
				Csfzh=(LPCSTR)_bstr_t(vsfzh); 
			vsj=m_pRecordset->GetCollect("手机");			//12 
			if(vsj.vt!=VT_NULL) 
				Csj=(LPCSTR)_bstr_t(vsj); 
			vzzzk=m_pRecordset->GetCollect("在职状况");		//13	 
			if(vzzzk.vt!=VT_NULL)	 
				Czzzk=(LPCSTR)_bstr_t(vzzzk); 
			vxsdj=m_pRecordset->GetCollect("薪水等级");		//14 
			if(vxsdj.vt!=VT_NULL) 
				Cxsdj=(LPCSTR)_bstr_t(vxsdj);				 
			vzy=m_pRecordset->GetCollect("专业");		//14	 
			if(vzy.vt!=VT_NULL)		 
				Czy=(LPCSTR)_bstr_t(vzy);	 
			vbyrq=m_pRecordset->GetCollect("毕业日期");		//14	 
			if(vbyrq.vt!=VT_NULL) 
				Cbyrq=(LPCSTR)_bstr_t(vbyrq);		 
			vtc=m_pRecordset->GetCollect("特长");		//14 
			if(vtc.vt!=VT_NULL)	 
				Ctc=(LPCSTR)_bstr_t(vtc);		 
			vbyxx=m_pRecordset->GetCollect("毕业学校");		//14		 
			if(vbyxx.vt!=VT_NULL) 
				Cbyxx=(LPCSTR)_bstr_t(vbyxx); 
			vjtdz=m_pRecordset->GetCollect("家庭地址");	 
			if(vjtdz.vt!=VT_NULL)		 
				Cjtdz=(LPCSTR)_bstr_t(vjtdz);	 
			vdzyj=m_pRecordset->GetCollect("电子邮件");		//14			 
			if(vdzyj.vt!=VT_NULL)			 
				Cdzyj=(LPCSTR)_bstr_t(vdzyj);				 
			vrsbz=m_pRecordset->GetCollect("人事备注");		//14			 
			if(vrsbz.vt!=VT_NULL) 
				Crsbz=(LPCSTR)_bstr_t(vrsbz);	 
			SetDlgItemText(IDC_YGBH,Cygbh); 
			SetDlgItemText(IDC_YGXM,Cygxm);	 
			SetDlgItemText(IDC_SSBM,Cbm); 
			SetDlgItemText(IDC_XB,Cxb);	 
			SetDlgItemText(IDC_CSNY,Ccsny); 
			SetDlgItemText(IDC_MZ,Cmz);	 
			SetDlgItemText(IDC_HK,Cjg); 
			SetDlgItemText(IDC_HYZK,Chyzk);	 
			SetDlgItemText(IDC_XL,Cxl);	 
			SetDlgItemText(IDC_DQZW,Czw);	 
			SetDlgItemText(IDC_SFZH,Csfzh);	 
			SetDlgItemText(IDC_SJHM,Csj); 
			SetDlgItemText(IDC_ZZZKD,Czzzk); 
			SetDlgItemText(IDC_XSDJ,Cxsdj); 
			SetDlgItemText(IDC_ZY,Czy);	 
			SetDlgItemText(IDC_BYRQ,Cbyrq); 
			SetDlgItemText(IDC_TC,Ctc); 
			SetDlgItemText(IDC_BYXX,Cbyxx); 
			SetDlgItemText(IDC_JTDZ,Cjtdz); 
			SetDlgItemText(IDC_DZYJ,Cdzyj); 
			SetDlgItemText(IDC_BZ,Crsbz); 
 
		} 
		else 
		{ 
			AfxMessageBox("已经到达记录底!"); 
			GetDlgItem(IDC_BACK)->EnableWindow(false); 
		} 
 
	} 
	catch(_com_error e) 
	{ 
		 
	} 
 
} 
 
bool CAddDate::ShowPhoto(int m_Records) 
{ 
	 
	try  //读照片序号:) 
	{ 
		InitDatebase(); 
		CString m_photopath; 
		_variant_t vadmin; 
		m_pRecordset->MoveFirst(); 
		m_pRecordset->Move(m_Records); 
		vadmin=m_pRecordset->GetCollect("照片路径"); 
		if(vadmin.vt!=VT_NULL) 
			m_photopath=(LPCSTR)_bstr_t(vadmin); 
		m_photopath="photo\\"+m_photopath; 
 
	//	MessageBox(m_photopath); 
		CFile f; 
		CFileException e;							 
		if(m_Pic.m_IPicture != NULL) 				 
			m_Pic.FreePictureData(); // Important - Avoid Leaks...			 
		if(f.Open(m_photopath, CFile::modeRead | CFile::typeBinary, &e)) //打开了一个jpg文件					 
		{		 
			int nSize = (int)f.GetLength();          //先得到jpg文件长度 
			BYTE * pBuffer = new BYTE [nSize];  //按文件的大小在堆上申请一块内存 
			f.Read(pBuffer, nSize) ;//把jpg文件读到pBuffer(堆上申请一块内存)		 
			m_Pic.LoadPictureData(pBuffer, nSize);//接作调用函数读pBuffer的jpg数据准备显示				 
			delete [] pBuffer;     //删掉堆上申请的那一块内      
			f.Close();			 
		}			 
		CClientDC dc(this); 
		CRect rect; 
		GetDlgItem(IDC_PHOTO)->GetClientRect(rect);//154 134  
 
		rect.left=531; 
		rect.right=rect.right+531; 
		rect.top=11; 
		rect.bottom=rect.bottom+11; 
		m_Pic.UpdateSizeOnDC(&dc); // Get Picture Dimentions In Pixels	 
		m_Pic.Show(&dc, rect);//显示出来看看		 
		 
				 
		 
		m_pRecordset->Close(); 
	} 
	catch (_com_error e)  
	{ 
	} 
	return false; 
} 
 
void CAddDate::OnBnClickedNext2() 
{ 
	try 
	{ 
		if(m_Records<=m_collectnum-1) 
		{ 
			GetDlgItem(IDC_BACK)->EnableWindow(true); 
			m_Records++; 
			ShowPhoto(m_Records); 
			InitDatebase(); 
			m_pRecordset->MoveFirst(); 
			m_pRecordset->Move(m_Records); 
		 
			CString	Cygbh,Cygxm,Cbm,Cxb,Ccsny,Cmz,Cjg,Chyzk, Cxl,Czw,Csfzh,Csj,Czzzk,Cxsdj; 
			_variant_t vygbh,vygxm,vbm, vxb,vcsny,vmz,vjg,vhyzk,vxl,vzw,vsfzh,vsj,vzzzk,vxsdj;							 
			CString Czy,Cbyrq,Ctc,Cbyxx,Cjtdz,Cdzyj,Crsbz;				 
			_variant_t vzy,vbyrq,vtc,vbyxx,vjtdz,vdzyj,vrsbz;		 
			vygbh=m_pRecordset->GetCollect("员工编号");			//1		 
			if(vygbh.vt!=VT_NULL)	 
				Cygbh=(LPCSTR)_bstr_t(vygbh);		 
			vygxm=m_pRecordset->GetCollect("员工姓名");		//2 
			if(vygxm.vt!=VT_NULL)		 
				Cygxm=(LPCSTR)_bstr_t(vygxm); 
			vbm=m_pRecordset->GetCollect("所属部门");		//3	 
			if(vbm.vt!=VT_NULL) 
				Cbm=(LPCSTR)_bstr_t(vbm); 
			vxb=m_pRecordset->GetCollect("性别");			//4	 
			if(vxb.vt!=VT_NULL) 
				Cxb=(LPCSTR)_bstr_t(vxb);	 
			vcsny=m_pRecordset->GetCollect("出生年月");		//5 
			if(vcsny.vt!=VT_NULL) 
				Ccsny=(LPCSTR)_bstr_t(vcsny); 
			vmz=m_pRecordset->GetCollect("民族");			//6  
			if(vmz.vt!=VT_NULL)	 
				Cmz=(LPCSTR)_bstr_t(vmz); 
			vjg=m_pRecordset->GetCollect("户口");			//7  
			if(vjg.vt!=VT_NULL) 
				Cjg=(LPCSTR)_bstr_t(vjg);	 
			vhyzk=m_pRecordset->GetCollect("婚姻状况");		//8 
			if(vhyzk.vt!=VT_NULL) 
				Chyzk=(LPCSTR)_bstr_t(vhyzk);	 
			vxl=m_pRecordset->GetCollect("学历");			//9 
			if(vxl.vt!=VT_NULL) 
				Cxl=(LPCSTR)_bstr_t(vxl);		 
			vzw=m_pRecordset->GetCollect("当前职位");		//10 
			if(vzw.vt!=VT_NULL) 
				Czw=(LPCSTR)_bstr_t(vzw);		 
			vsfzh=m_pRecordset->GetCollect("身份证号");		//11 
			if(vsfzh.vt!=VT_NULL) 
				Csfzh=(LPCSTR)_bstr_t(vsfzh); 
			vsj=m_pRecordset->GetCollect("手机");			//12 
			if(vsj.vt!=VT_NULL) 
				Csj=(LPCSTR)_bstr_t(vsj); 
			vzzzk=m_pRecordset->GetCollect("在职状况");		//13	 
			if(vzzzk.vt!=VT_NULL)	 
				Czzzk=(LPCSTR)_bstr_t(vzzzk); 
			vxsdj=m_pRecordset->GetCollect("薪水等级");		//14 
			if(vxsdj.vt!=VT_NULL) 
				Cxsdj=(LPCSTR)_bstr_t(vxsdj);				 
			vzy=m_pRecordset->GetCollect("专业");		//14	 
			if(vzy.vt!=VT_NULL)		 
				Czy=(LPCSTR)_bstr_t(vzy);	 
			vbyrq=m_pRecordset->GetCollect("毕业日期");		//14	 
			if(vbyrq.vt!=VT_NULL) 
				Cbyrq=(LPCSTR)_bstr_t(vbyrq);		 
			vtc=m_pRecordset->GetCollect("特长");		//14 
			if(vtc.vt!=VT_NULL)	 
				Ctc=(LPCSTR)_bstr_t(vtc);		 
			vbyxx=m_pRecordset->GetCollect("毕业学校");		//14		 
			if(vbyxx.vt!=VT_NULL) 
				Cbyxx=(LPCSTR)_bstr_t(vbyxx); 
			vjtdz=m_pRecordset->GetCollect("家庭地址");	 
			if(vjtdz.vt!=VT_NULL)		 
				Cjtdz=(LPCSTR)_bstr_t(vjtdz);	 
			vdzyj=m_pRecordset->GetCollect("电子邮件");		//14			 
			if(vdzyj.vt!=VT_NULL)			 
				Cdzyj=(LPCSTR)_bstr_t(vdzyj);				 
			vrsbz=m_pRecordset->GetCollect("人事备注");		//14			 
			if(vrsbz.vt!=VT_NULL) 
				Crsbz=(LPCSTR)_bstr_t(vrsbz);	 
			SetDlgItemText(IDC_YGBH,Cygbh); 
			SetDlgItemText(IDC_YGXM,Cygxm);	 
			SetDlgItemText(IDC_SSBM,Cbm); 
			SetDlgItemText(IDC_XB,Cxb);	 
			SetDlgItemText(IDC_CSNY,Ccsny); 
			SetDlgItemText(IDC_MZ,Cmz);	 
			SetDlgItemText(IDC_HK,Cjg); 
			SetDlgItemText(IDC_HYZK,Chyzk);	 
			SetDlgItemText(IDC_XL,Cxl);	 
			SetDlgItemText(IDC_DQZW,Czw);	 
			SetDlgItemText(IDC_SFZH,Csfzh);	 
			SetDlgItemText(IDC_SJHM,Csj); 
			SetDlgItemText(IDC_ZZZKD,Czzzk); 
			SetDlgItemText(IDC_XSDJ,Cxsdj); 
			SetDlgItemText(IDC_ZY,Czy);	 
			SetDlgItemText(IDC_BYRQ,Cbyrq); 
			SetDlgItemText(IDC_TC,Ctc); 
			SetDlgItemText(IDC_BYXX,Cbyxx); 
			SetDlgItemText(IDC_JTDZ,Cjtdz); 
			SetDlgItemText(IDC_DZYJ,Cdzyj); 
			SetDlgItemText(IDC_BZ,Crsbz); 
 
		} 
	} 
	catch(_com_error e) 
	{ 
		AfxMessageBox("已经到达记录末尾!!!",MB_OK); 
		m_Records--; 
 
	} 
	 
} 
 
void CAddDate::OnBnClickedAdd2() //修改记录:( 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	CString Cygbh,Cygxm,Cxb,Czy,Cxl,Ccsny,Cbyrq,Ctc,Chk,Cbyxx,Cjtdz,Csj,Csfzh,Chyzk; 
	CString Cssbm,Cdqzw,Cxsdj,Cdzyj,Cbz,Czzzk,Cmz; 
	//1员工编号,2员工姓名,3性别,4专业,5学历,6出生年月,7毕业日期,8特长,9户口,10毕业学校,11家庭地址,12手机,13身份证号,14,婚姻状况, 
	//15,js,16,所属部门,17,当前职位,18,薪水等级,19,电子邮件,20,人事备注,21在职状况,22;民族 
    int	iygbh=GetDlgItemInt(IDC_YGBH);//1 
	GetDlgItemText(IDC_YGXM,Cygxm);//2 
	GetDlgItemText(IDC_XB,Cxb);//3 
	GetDlgItemText(IDC_ZY,Czy);//4 
	GetDlgItemText(IDC_XL,Cxl);//5 
	GetDlgItemText(IDC_CSNY,Ccsny);//6 
	GetDlgItemText(IDC_BYRQ,Cbyrq);//7 
	GetDlgItemText(IDC_TC,Ctc);//8 
	GetDlgItemText(IDC_HK,Chk);//9 
	GetDlgItemText(IDC_BYXX,Cbyxx);//10 
	GetDlgItemText(IDC_JTDZ,Cjtdz);//11 
	GetDlgItemText(IDC_SJHM,Csj);//12 
	GetDlgItemText(IDC_SFZH,Csfzh);//13 
	GetDlgItemText(IDC_HYZK,Chyzk);//14 
	//15,js,16,所属部门,17,当前职位,18,薪水等级,19,电子邮件,20,人事备注 
	//CString Cssbm,Cdqzw,Cxsdj,Cdzyj,Cbz,Czzzk; 
	GetDlgItemText(IDC_SSBM,Cssbm);//16 
	GetDlgItemText(IDC_DQZW,Cdqzw);//17 
	GetDlgItemText(IDC_XSDJ,Cxsdj);//18 
	GetDlgItemText(IDC_DZYJ,Cdzyj);//19k 
	GetDlgItemText(IDC_BZ,Cbz);//20 
	GetDlgItemText(IDC_ZZZKD,Czzzk);//21 
	GetDlgItemText(IDC_MZ,Cmz); 
	try 
	{		 
		InitDatebase(); 
		m_pRecordset->Move(m_Records); 
		_variant_t vtemp,vtemp2; 
		CString Ctemp,Ctemp2; 
		vtemp=m_pRecordset->GetCollect("id"); 
		if(vtemp.vt!=VT_NULL) 
			Ctemp=(LPCSTR)_bstr_t(vtemp); 
		vtemp2=m_pRecordset->GetCollect("照片路径"); //处理图片保存路径 
		if(vtemp2.vt!=VT_NULL) 
			Ctemp2=(LPCSTR)_bstr_t(vtemp2); 
		int itemp=atoi(Ctemp);	 
		if(m_Filename.IsEmpty()) 
			m_Filename=Ctemp2; 
		CString Sqlcommand;		 
		_variant_t vadmin;			 
		Sqlcommand.Format("UPDATE 基本信息 SET 员工编号=%d,员工姓名='%s',性别='%s',专业='%s',学历='%s',出生年月='%s',毕业日期='%s',特长='%s',户口='%s',毕业学校='%s',家庭地址='%s',手机='%s',身份证号='%s',婚姻状况='%s',所属部门='%s',当前职位='%s',薪水等级='%s',电子邮件='%s',人事备注='%s',在职状况='%s',民族='%s',照片路径='%s' WHERE id=%d",iygbh,Cygxm,Cxb,Czy,Cxl,Ccsny,Cbyrq,Ctc,Chk,Cbyxx,Cjtdz,Csj,Csfzh,Chyzk,Cssbm,Cdqzw,Cxsdj,Cdzyj,Cbz,Czzzk,Cmz,m_Filename,itemp); 	 
	//	MessageBox(Sqlcommand); 
		theApp.m_pConnection->Execute(_bstr_t(Sqlcommand),&vadmin,adCmdText); 
		 
		AfxMessageBox("员工信息修改成功 !"); 
		m_pRecordset->Close(); 
		m_Filename=""; 
	} 
	catch(_com_error e) 
	{ 
		AfxMessageBox("员工姓名已存在!"); 
	} 
 
} 
 
 
void CAddDate::OnBnClickedAdd3() //删除记录 
{ 
	// TODO: 在此添加控件通知处理程序代码 
 
	int i=GetDlgItemInt(IDC_YGBH); 
	if(AfxMessageBox("确定要删除该记录么?",MB_YESNO)==IDYES) 
	{ 
		try 
		{ 
			InitDatebase(); 
			CString Sqlcommand; 
			Sqlcommand.Format("DELETE * FROM 基本信息 WHERE 员工编号=%d",i); 
			_variant_t vadmin; 
			theApp.m_pConnection->Execute(_bstr_t(Sqlcommand),&vadmin,adCmdText); 
			m_pRecordset->Close(); 
			AfxMessageBox("删除记录成功"); 
			SetDlgItemText(IDC_YGBH,"");//1		 
			SetDlgItemText(IDC_YGXM,"");//2 
			SetDlgItemText(IDC_XB,"");//3 
			SetDlgItemText(IDC_ZY,"");//4 
			SetDlgItemText(IDC_XL,"");//5 
			SetDlgItemText(IDC_CSNY,"");//6 
			SetDlgItemText(IDC_BYRQ,"");//7 
			SetDlgItemText(IDC_TC,"");//8 
			SetDlgItemText(IDC_HK,"");//9 
			SetDlgItemText(IDC_BYXX,"");//10 
			SetDlgItemText(IDC_JTDZ,"");//11	 
			SetDlgItemText(IDC_SJHM,"");//12 
			SetDlgItemText(IDC_SFZH,"");//13 
			SetDlgItemText(IDC_HYZK,"");//14 
			SetDlgItemText(IDC_SSBM,"");//16 
			SetDlgItemText(IDC_DQZW,"");//17 
			SetDlgItemText(IDC_XSDJ,"");//18 
			SetDlgItemText(IDC_DZYJ,"");//19 
			SetDlgItemText(IDC_BZ,"");//20 
			SetDlgItemText(IDC_ZZZKD,"");//21 
			SetDlgItemText(IDC_MZ,"");//22 
		} 
		catch(_com_error e) 
		{			 
		} 
	} 
	GetDlgItem(IDC_YGBH)->EnableWindow(true); 
} 
void CAddDate::OnBnClickedRewrite() 
{ 
	// TODO: 在此添加控件通知处理程序代码 
	m_Filename=""; 
	GetDlgItem(IDC_ADD2)->EnableWindow(false); 
	GetDlgItem(IDC_ADD3)->EnableWindow(false); 
	GetDlgItem(IDC_YGBH)->EnableWindow(true); 
	GetDlgItem(IDC_ADD)->EnableWindow(true); 
	SetDlgItemText(IDC_YGBH,"");//1			 
	SetDlgItemText(IDC_YGXM,"");//2	 
	SetDlgItemText(IDC_XB,"");//3 
	SetDlgItemText(IDC_ZY,"");//4 
	SetDlgItemText(IDC_XL,"");//5	 
	SetDlgItemText(IDC_CSNY,"");//6 
	SetDlgItemText(IDC_BYRQ,"");//7 
	SetDlgItemText(IDC_TC,"");//8 
	SetDlgItemText(IDC_HK,"");//9 
	SetDlgItemText(IDC_BYXX,"");//10 
	SetDlgItemText(IDC_JTDZ,"");//11	 
	SetDlgItemText(IDC_SJHM,"");//12 
	SetDlgItemText(IDC_SFZH,"");//13 
	SetDlgItemText(IDC_HYZK,"");//14 
	SetDlgItemText(IDC_SSBM,"");//16 
	SetDlgItemText(IDC_DQZW,"");//17		 
	SetDlgItemText(IDC_XSDJ,"");//18	 
	SetDlgItemText(IDC_DZYJ,"");//19	 
	SetDlgItemText(IDC_BZ,"");//20 
	SetDlgItemText(IDC_ZZZKD,"");//21 
	SetDlgItemText(IDC_MZ,"");//22 
}