【VC开源代码栏目提醒】:网学会员为广大网友收集整理了,CheckInfo.cpp,希望对大家有所帮助!
#include "stdafx.h"
#include "CheckManage.h"
#include "CheckInfo.h"
#include "ADOConn.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
CCheckInfo::CCheckInfo()
{
CTime CurrentTime;
CurrentTime = CTime::GetCurrentTime();
CheckDate = CurrentTime.Format("%Y-%m-%d");
EmpId = 0;
QuanQin = "否";
ChuChai = "否";
BingJia = "否";
ShiJia = "否";
KuangGong = "否";
XiuXi = "否";
ChiDao = "否";
ZaoTui = "否";
Memo = "";
}
CCheckInfo::~CCheckInfo()
{
}
// 判断是否存在此员工
bool CCheckInfo::HaveEmp(CString paraCheckDate, CString paraEmpId)
{
// 连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
// 设置Select语句
_bstr_t vSQL;
vSQL = "SELECT * FROM CheckInfo WHERE CheckDate = '" + paraCheckDate
+ "' AND EmpId = " + paraEmpId;
// 执行SQL语句
_RecordsetPtr m_pRecordSet;
m_pRecordSet = m_AdoConn.GetRecordSet(vSQL);
// 判断是否存在此员工
if(m_pRecordSet->adoEOF)
{
return FALSE;
}
else
{
return TRUE;
}
}
// 插入操作
void CCheckInfo::SqlInsert()
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置INSERT语句
CString strEmpId;
strEmpId.Format("%ld", EmpId);
_bstr_t vSQL;
vSQL = "INSERT INTO CheckInfo VALUES('" + CheckDate + "', " + strEmpId
+ ", '" + QuanQin + "', '" + ChuChai + "', '" + BingJia
+ "', '" + ShiJia + "', '" + KuangGong + "', '" + XiuXi
+ "', '" + ChiDao + "', '" + ZaoTui + "', '" + Memo + "')";
//执行INSERT语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
// 修改出勤信息
void CCheckInfo::UpdateOnDuty(CString paraCheckDate, CString paraEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置UPDATE语句
_bstr_t vSQL;
vSQL = "UPDATE CheckInfo SET QuanQin = '" + QuanQin + "', XiuXi = '" + XiuXi
+ "', ChiDao = '" + ChiDao + "', ZaoTui = '" + ZaoTui + "', Kuanggong='" + KuangGong
+ "', Memo = '" + Memo + "' WHERE CheckDate = '" + paraCheckDate
+ "' AND EmpId = " + paraEmpId;
//执行UPDATE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
// 修改事假信息
void CCheckInfo::UpdateLeave(CString paraCheckDate, CString paraEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置UPDATE语句
_bstr_t vSQL;
vSQL = "UPDATE CheckInfo SET ShiJia = '" + ShiJia + "', BingJia = '" + BingJia
+ "', Memo = '" + Memo + "' WHERE CheckDate = '" + paraCheckDate
+ "' AND EmpId = " + paraEmpId;
//执行UPDATE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
// 修改出差信息
void CCheckInfo::UpdateErrand(CString paraCheckDate, CString paraEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置UPDATE语句
_bstr_t vSQL;
vSQL = "UPDATE CheckInfo SET ChuChai = '" + ChuChai + "', Memo = '" + Memo
+ "' WHERE CheckDate = '" + paraCheckDate
+ "' AND EmpId = " + paraEmpId;
//执行UPDATE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
// 删除操作
void CCheckInfo::SqlDelete(CString paraCheckDate, CString paraEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置DELETE语句
_bstr_t vSQL;
vSQL = "DELETE FROM CheckInfo WHERE CheckDate = '"
+ paraCheckDate + "' AND EmpId = " + paraEmpId;
//执行DELETE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}