prize.cpp

软件外包人事综合管理系统,对员工的管理,部门管理,以及考勤管理和薪资管理.总得来说功能完全.

// Prize.cpp: implementation of the CPrize class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "HrSys.h"
#include "Prize.h"
#include "ADOConn.h"

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

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

CPrize::CPrize()
{
	EmpId=0;
	TypeId=0;
	PDate="";
	PReason="";
	PDetail="";
}

CPrize::~CPrize()
{

}
//数据库操作
void CPrize::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString strEmpId,strTId;
	strEmpId.Format("%d", EmpId);
	strTId.Format("%d", TypeId);

	_bstr_t vSQL;
	vSQL = "INSERT INTO Prize VALUES(" + strEmpId + ","
		+strTId+",'"+PDate+ "','"+PReason+"','"+PDetail+"')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CPrize::sql_update(CString cTmpId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
	CString strEmpId,strTId;
	strEmpId.Format("%d", EmpId);
	strTId.Format("%d", TypeId);

	_bstr_t vSQL;
	vSQL = "UPDATE Prize SET EmpId=" + strEmpId
		+ ",TypeId="+strTId+",PDate='"+PDate
		+"',PReason='"+PReason+"',PDetail='"
		+PDetail+"' WHERE Id=" + cTmpId;
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CPrize::sql_delete(CString cTmpId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Prize WHERE Id=" + cTmpId;
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

//根据工资项目编号读取所有字段值
void CPrize::GetData(CString cTmpId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Prize WHERE Id=" + cTmpId;
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CPrize();
	else
	{
		Id=atol(cTmpId);
		EmpId=atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("EmpId"));
		TypeId=atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("TypeId"));
		PDate=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PDate");
		PReason=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PReason");
		PDetail=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("PDetail");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}