checkinfo.cpp

visual c++与sql Server数据库开发考勤管理系统

#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();
}