📄 staffinfo.cpp

📁 企业办公管理系统
💻 CPP
字号:
// StaffInfo.cpp: implementation of the CStaffInfo class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "office.h"
#include "StaffInfo.h"

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

//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////

CStaffInfo::CStaffInfo()
{
	m_sex="";
	m_nationality="";
	m_marriage="";
	m_graduateLevel="";
	m_duty="";
	m_department="";
	m_address="";
	m_contractCode="";
	m_graduateSchool="";
	m_identiyID="";
	m_mailAddress="";
	m_mayor="";
	m_mobilephone="";
	m_name="";
	m_note="";
	m_phone="";
	m_postcode="";
	m_qq="";
	m_staffID="";
	m_worktype="";
	/*
	COleDateTime	m_birthday;
	COleDateTime	m_contractDeadline;
	*/
}

CStaffInfo::~CStaffInfo()
{

}

void CStaffInfo::GetData(CString m_ID)
{
    try
	{  
		CString strSQL;
		strSQL="Select*From 人员基本档案 where StaffID='";
		strSQL+=m_ID+"'";
		::CoInitialize(NULL);
		_ConnectionPtr m_pConn("ADODB.Connection");
		m_pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\DataSource\\office1.mdb;Persist Security Info=False","","",adConnectUnspecified);
		_RecordsetPtr m_set("ADODB.Recordset");//记录集
		m_set->Open((_bstr_t)strSQL,_variant_t(m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
        if(!m_set->EndOfFile)
		{   //从数据库中读取相应的数据项目
			m_birthday=(COleDateTime)(m_set->GetCollect("Birthday"));
			m_contractDeadline=(COleDateTime)(m_set->GetCollect("ContractTerm"));
			m_sex=(LPCSTR)((_bstr_t)m_set->GetCollect("Sex"));
			m_nationality=(LPCSTR)((_bstr_t)m_set->GetCollect("Nationality"));
			m_marriage=(LPCSTR)((_bstr_t)m_set->GetCollect("MarriageCondition"));
			m_graduateLevel=(LPCSTR)((_bstr_t)m_set->GetCollect("EducationLevel"));
			m_duty=(LPCSTR)((_bstr_t)m_set->GetCollect("Duty"));
			m_department=(LPCSTR)((_bstr_t)m_set->GetCollect("Department"));
			m_address=(LPCSTR)((_bstr_t)m_set->GetCollect("Address"));
			m_contractCode=(LPCSTR)((_bstr_t)m_set->GetCollect("ContactID"));
			m_graduateSchool=(LPCSTR)((_bstr_t)m_set->GetCollect("GraduateSchool"));
			m_identiyID=(LPCSTR)((_bstr_t)m_set->GetCollect("IdentityNO"));
			m_mailAddress=(LPCSTR)((_bstr_t)m_set->GetCollect("Email"));
			m_mayor=(LPCSTR)((_bstr_t)m_set->GetCollect("Mayor"));
			m_mobilephone=(LPCSTR)((_bstr_t)m_set->GetCollect("MobilePhone"));
			m_name=(LPCSTR)((_bstr_t)m_set->GetCollect("StaffName"));
			m_note=(LPCSTR)((_bstr_t)m_set->GetCollect("Remark"));
			m_phone=(LPCSTR)((_bstr_t)m_set->GetCollect("Telephone"));
			m_postcode=(LPCSTR)((_bstr_t)m_set->GetCollect("Postcode"));
			m_qq=(LPCSTR)((_bstr_t)m_set->GetCollect("QQ"));
			m_staffID=(LPCSTR)((_bstr_t)m_set->GetCollect("StaffID"));
			m_worktype=(LPCSTR)((_bstr_t)m_set->GetCollect("WorkType"));
		}
	}

	//捕获异常
	catch(_com_error&e){}

}

void CStaffInfo::SQLdelete(CString m_staffID)
{
   try
	{  
		CString strSQL;
		strSQL="delete From 人员基本档案 where StaffID='";
		strSQL+=m_staffID+"'";
		::CoInitialize(NULL);
		_ConnectionPtr m_pConn("ADODB.Connection");
		m_pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\DataSource\\office1.mdb;Persist Security Info=False","","",adConnectUnspecified);
		_RecordsetPtr m_set("ADODB.Recordset");//记录集
		m_set->Open((_bstr_t)strSQL,_variant_t(m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
	}

	//捕获异常
	catch(_com_error&e){}
}

void CStaffInfo::SQLinsert()
{
    try
	{  
		CString strSQL;
		strSQL="select* From 人员基本档案 '";
		::CoInitialize(NULL);
		_ConnectionPtr m_pConn("ADODB.Connection");
		m_pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\DataSource\\office1.mdb;Persist Security Info=False","","",adConnectUnspecified);
		_RecordsetPtr m_set("ADODB.Recordset");//记录集
		m_set->Open((_bstr_t)strSQL,_variant_t(m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
	    m_set->AddNew();
		//先用int型获取响应的数字；
		int year=m_birthday.GetYear();
		int month=m_birthday.GetMonth();
		int day=m_birthday.GetDay();
		CString m_convertBirthday;
    	m_convertBirthday.Format("%d-%d-%d",year,month,day);		
		//先用int型获取响应的数字；

		year=m_contractDeadline.GetYear();
		month=m_contractDeadline.GetMonth();
		day=m_contractDeadline.GetDay();

		CString m_convertDeadline;
		m_convertDeadline.Format("%d-%d-%d",year,month,day);

		_variant_t m_variantBirthday=_variant_t(m_convertBirthday);
		_variant_t m_variantDeadline=_variant_t(m_convertDeadline);

		//由于直接将其做为参数输入数据库的数据是不正确的故这里用了CString的转化
	//  m_set->PutCollect("事务日期",_variant_t(transactionDate));


		m_set->PutCollect("ContractTerm",m_variantDeadline);
		m_set->PutCollect("Birthday",m_variantBirthday);
		m_set->PutCollect("StaffID",_variant_t(m_staffID));
		m_set->PutCollect("StaffName",_variant_t(m_name));
		m_set->PutCollect("Duty",_variant_t(m_duty));
		m_set->PutCollect("ContactID",_variant_t(m_contractCode));
		m_set->PutCollect("Department",_variant_t(m_department));
		m_set->PutCollect("Sex",_variant_t(m_sex));
		m_set->PutCollect("Address",_variant_t(m_address));
		m_set->PutCollect("Postcode",_variant_t(m_postcode));
		m_set->PutCollect("MarriageCondition",_variant_t(m_marriage));
		m_set->PutCollect("Telephone",_variant_t(m_phone));
		m_set->PutCollect("Nationality",_variant_t(m_nationality));
		m_set->PutCollect("Email",_variant_t(m_mailAddress));
		m_set->PutCollect("EducationLevel",_variant_t(m_graduateLevel));
		m_set->PutCollect("QQ",_variant_t(m_qq));
		m_set->PutCollect("GraduateSchool",_variant_t(m_graduateSchool));
		m_set->PutCollect("Mayor",_variant_t(m_mayor));
		m_set->PutCollect("IdentityNO",_variant_t(m_identiyID));
		m_set->PutCollect("MobilePhone",_variant_t(m_mobilephone));
		m_set->PutCollect("WorkType",_variant_t(m_worktype));
		m_set->PutCollect("Remark",_variant_t(m_note));
		m_set->Update();
	}

	//捕获异常
	catch(_com_error&e){}
}

void CStaffInfo::SQLupdate(CString ID)
{
		CString strSQL;
		strSQL="select* From 人员基本档案 where StaffID='";
		strSQL+=ID+"'";
    try
	{
		::CoInitialize(NULL);
		_ConnectionPtr m_pConn("ADODB.Connection");
		m_pConn->Open("Provider=Microsoft.Jet.OLEDB.4.0;Data Source=F:\\DataSource\\office1.mdb;Persist Security Info=False","","",adConnectUnspecified);
		_RecordsetPtr m_set("ADODB.Recordset");//记录集
		m_set->Open((_bstr_t)strSQL,_variant_t(m_pConn,true),adOpenDynamic,adLockPessimistic,adCmdText);
		//先用int型获取响应的数字；
		int year=m_birthday.GetYear();
		int month=m_birthday.GetMonth();
		int day=m_birthday.GetDay();

		CString m_convertBirthday;
		m_convertBirthday.Format("%d-%d-%d",year,month,day);
		
		//先用int型获取响应的数字；
		year=m_contractDeadline.GetYear();
		month=m_contractDeadline.GetMonth();
		day=m_contractDeadline.GetDay();
		CString m_convertDeadline;
		m_convertDeadline.Format("%d-%d-%d",year,month,day);

		_variant_t m_variantBirthday=_variant_t(m_convertBirthday);
		_variant_t m_variantDeadline=_variant_t(m_convertDeadline);

		//由于直接将其做为参数输入数据库的数据是不正确的故这里用了CString的转化
	//  m_set->PutCollect("事务日期",_variant_t(transactionDate));
	    m_set->PutCollect("StaffID",_variant_t(m_staffID));
		m_set->PutCollect("StaffName",_variant_t(m_name));
		m_set->PutCollect("Duty",_variant_t(m_duty));
		m_set->PutCollect("ContactID",_variant_t(m_contractCode));
		m_set->PutCollect("Department",_variant_t(m_department));
		m_set->PutCollect("Sex",_variant_t(m_sex));
		m_set->PutCollect("Address",_variant_t(m_address));
		m_set->PutCollect("Postcode",_variant_t(m_postcode));
		m_set->PutCollect("MarriageCondition",_variant_t(m_marriage));
		m_set->PutCollect("Telephone",_variant_t(m_phone));
		m_set->PutCollect("Nationality",_variant_t(m_nationality));
		m_set->PutCollect("Email",_variant_t(m_mailAddress));
		m_set->PutCollect("EducationLevel",_variant_t(m_graduateLevel));
		m_set->PutCollect("QQ",_variant_t(m_qq));
		m_set->PutCollect("GraduateSchool",_variant_t(m_graduateSchool));
		m_set->PutCollect("Mayor",_variant_t(m_mayor));
		m_set->PutCollect("IdentityNO",_variant_t(m_identiyID));
		m_set->PutCollect("MobilePhone",_variant_t(m_mobilephone));
		m_set->PutCollect("WorkType",_variant_t(m_worktype));
		m_set->PutCollect("Remark",_variant_t(m_note));
		m_set->Update();
	}
		catch(_com_error&e){}
}
💿 文件大小 177 K
👤 上传用户 a215290209
📂 所属分类企业管理
🏷️ 相关标签

#管理系统
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -