?? 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();
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -