// SalaryItem.cpp: implementation of the CSalaryItem class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CSalaryItem::CSalaryItem()
{
    ItemId=0;
	ItemName="";
	ItemType=0;
	ItemSum=0;
	Formula="";
	IsVisible=0;
	Operation=0;
}

CSalaryItem::~CSalaryItem()
{

}
//數據庫操作
void CSalaryItem::sql_insert()
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置INSERT語句
	CString strType,strSum,strIV,strOper;
	strType.Format("%d", ItemType);
	strSum.Format("%d", ItemSum);
	strIV.Format("%d", IsVisible);
	strOper.Format("%d", Operation);

	_bstr_t vSQL;
	vSQL = "INSERT INTO SalaryItem VALUES('" + ItemName + "',"
		+ strType + "," + strSum + ",'" + Formula + "'," + strIV + "," 
		+ strOper + ")";	
	//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CSalaryItem::sql_update(CString cTId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strType,strSum,strIV,strOper;
	strType.Format("%d", ItemType);
	strSum.Format("%d", ItemSum);
	strIV.Format("%d", IsVisible);
	strOper.Format("%d", Operation);

	_bstr_t vSQL;
	vSQL = "UPDATE SalaryItem SET ItemName='" + ItemName
		+ "',ItemType="+strType+",ItemSum="+strSum
		+",Formula='"+Formula+"',IsVisible="+strIV
		+",Operation="+strOper+" WHERE ItemId=" + cTId;
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CSalaryItem::sql_delete(CString cTId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置DELETE語句
	_bstr_t vSQL;
	vSQL = "DELETE FROM SalaryItem WHERE ItemId=" + cTId;
	//執行DELETE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

//根據工資項目編號讀取所有字段值
void CSalaryItem::GetData(CString cTId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM SalaryItem WHERE ItemId=" + cTId;
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CSalaryItem(); 
	else
	{
		ItemId=atol(cTId);
		ItemName=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemName");
		ItemType=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemType"));
		ItemSum=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ItemSum"));
		Formula=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Formula");
		IsVisible=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("IsVisible"));
		Operation=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Operation"));
	}
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

bool CSalaryItem::HaveRecord(CString cItemName)
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM SalaryItem WHERE ItemName='" + ItemName + "'";
	
	//執行SELECT語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return false;
	else
		return true;

	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}