【VC开源代码栏目提醒】:网学会员,鉴于大家对VC开源代码十分关注,论文会员在此为大家搜集整理了“EmpInfo.cpp”一文,供大家参考学习!
#include "stdafx.h"
#include "CheckManage.h"
#include "EmpInfo.h"
#include "ADOConn.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
CEmpInfo::CEmpInfo()
{
EmpId = 0;
Name = "";
Sex = "";
Birthday = "";
IdCard = "";
OfficePhone = "";
Mobile = "";
HireDate = "";
DepId = 0;
Mission = "";
Duty = "";
Memo = "";
}
CEmpInfo::~CEmpInfo()
{
}
// 根据员工编号得到其他信息
void CEmpInfo::GetInfo(CString paraId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置SELECT语句
_bstr_t vSQL;
vSQL = "SELECT * FROM EmpInfo WHERE EmpId = " + paraId;
//执行SELETE语句
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
//返回各列的值
if (m_pRecordset->adoEOF)
CEmpInfo();
else
{
EmpId = atol(paraId);
Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Name");
Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
Birthday = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Birthday");
IdCard = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("IdCard");
OfficePhone = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("OfficePhone");
Mobile = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Mobile");
HireDate = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("HireDate");
DepId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DepId"));
Mission = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Mission");
Duty = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Duty");
Memo = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Memo");
}
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
// 插入操作
void CEmpInfo::SqlInsert()
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置INSERT语句
CString strDepId;
strDepId.Format("%d", DepId);
_bstr_t vSQL;
vSQL = "INSERT INTO EmpInfo (Name, Sex, Birthday, "
" IdCard, OfficePhone, Mobile, HireDate, DepId, Mission, Duty, Memo)"
" VALUES ('" + Name + "', '" + Sex + "','" + Birthday + "','"
+ IdCard + "','" + OfficePhone + "','" + Mobile + "','"
+ HireDate + "'," + strDepId + ",'" + Mission + "','" + Duty
+ "', '" + Memo + "')";
//执行INSERT语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
// 修改操作
void CEmpInfo::SqlUpdate(CString paraId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置UPDATE语句
_bstr_t vSQL;
vSQL = "UPDATE EmpInfo SET Name = '" + Name + "', Sex = '" + Sex
+ "', Birthday = '" + Birthday + "', IdCard = '" + IdCard
+ "', OfficePhone = '" + OfficePhone + "', Mobile = '" + Mobile
+ "', HireDate = '" + HireDate + "', Mission = '" + Mission
+ "', Duty = '" + Duty + "', Memo = '" + Memo
+ "' WHERE EmpId = " + paraId;
//执行UPDATE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
// 删除指定员工信息
void CEmpInfo::SqlDelete(CString paraId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置DELETE语句
_bstr_t vSQL;
vSQL = "DELETE FROM EmpInfo WHERE EmpId = " + paraId;
//执行DELETE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}