// Kaoqin.cpp
/*********************************************************************/

#include "stdafx.h"
#include "../Renshi.h"
#include "Kaoqin.h"


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


extern CRenshiApp theApp;
/*********************************************************************/

CKaoqin::CKaoqin()
{
	CheckDate = "";
	yg_ID = 0;
	qqDays = 0;
	ccDays = 0;
	bjDays = 0;
	sjDays = 0;
	kgDays = 0;
	fdxjDays = 0;
	nxjDays = 0;
	dxjDays = 0;
	cdMinutes = 0;
	ztMinutes = 0;
	ot1Days = 0;
	ot2Days = 0;
	ot3Days = 0;
	Memo = "";
}

CKaoqin::~CKaoqin()
{

}

CString CKaoqin::GetCheckDate()
{
	return CheckDate;
}


/*********************************************************************/

void CKaoqin::SetCheckDate(CString cDate)
{
	CheckDate = cDate;
}

int CKaoqin::Getyg_ID()
{
	return yg_ID;
}

void CKaoqin::Setyg_ID(int iyg_ID)
{
	yg_ID = iyg_ID;
}

float CKaoqin::GetqqDays()
{
	return qqDays;
}

void CKaoqin::SetqqDays(float fqqDays)
{
	qqDays = fqqDays;
}

float CKaoqin::GetccDays()
{
	return ccDays;
}

void CKaoqin::SetccDays(float fccDays)
{
	ccDays = fccDays;
}

float CKaoqin::GetbjDays()
{
	return bjDays;
}

void CKaoqin::SetbjDays(float fbjDays)
{
	bjDays = fbjDays;
}

float CKaoqin::GetsjDays()
{
	return sjDays;
}

void CKaoqin::SetsjDays(float fsjDays)
{
	sjDays = fsjDays;
}

float CKaoqin::GetkgDays()
{
	return kgDays;
}

void CKaoqin::SetkgDays(float fkgDays)
{
	kgDays = fkgDays;
}

float CKaoqin::GetfdxjDays()
{
	return fdxjDays;
}

void CKaoqin::SetfdxjDays(float ffdxjDays)
{
	fdxjDays = ffdxjDays;
}

float CKaoqin::GetnxjDays()
{
	return nxjDays;
}

void CKaoqin::SetnxjDays(float fnxjDays)
{
	nxjDays = fnxjDays;
}

float CKaoqin::GetdxjDays()
{
	return dxjDays;
}

void CKaoqin::SetdxjDays(float fdxjDays)
{
	dxjDays = fdxjDays;
}

int CKaoqin::GetcdMinutes()
{
	return cdMinutes;
}

void CKaoqin::SetcdMinutes(int icdMinutes)
{
	cdMinutes = icdMinutes;
}

int CKaoqin::GetztMinutes()
{
	return ztMinutes;
}

void CKaoqin::SetztMinutes(int iztMinutes)
{
	ztMinutes = iztMinutes;
}

float CKaoqin::Getot1Days()
{
	return ot1Days;
}

void CKaoqin::Setot1Days(float fot1Days)
{
	ot1Days = fot1Days;
}

float CKaoqin::Getot2Days()
{
	return ot2Days;
}

void CKaoqin::Setot2Days(float fot2Days)
{
	ot2Days = fot2Days;
}

float CKaoqin::Getot3Days()
{
	return ot3Days;
}

void CKaoqin::Setot3Days(float fot3Days)
{
	ot3Days = fot3Days;
}

CString CKaoqin::GetMemo()
{
	return Memo;
}

void CKaoqin::SetMemo(CString cMemo)
{
	Memo = cMemo;
}



/*********************************************************************/
int CKaoqin::HaveRecord(CString cCheckDate, CString cyg_ID)
{	
	_RecordsetPtr m_pRecordset = theApp.m_ado.GetRS("SELECT * FROM Kaoqin WHERE CheckDate='" + cCheckDate + "' AND yg_ID=" + cyg_ID);

	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
}

	
void CKaoqin::sql_insert()
{	
	//設(shè)置INSERT語(yǔ)句
	CString stryg_ID, strqq, strcc,strbj,strsj,strkg,strfdxj,strnxj,strdxj,strcd,strzt,strot1,strot2,strot3;
	stryg_ID.Format("%d", yg_ID);
	strqq.Format("%f", qqDays);
	strcc.Format("%f", ccDays);
	strbj.Format("%f", bjDays);
	strsj.Format("%f", sjDays);
	strkg.Format("%f", kgDays);
	strfdxj.Format("%f", fdxjDays);
	strnxj.Format("%f", nxjDays);
	strdxj.Format("%f", dxjDays);
	strcd.Format("%d", cdMinutes);
	strzt.Format("%f", ztMinutes);
	strot1.Format("%f", ot1Days);
	strot2.Format("%f", ot2Days);
	strot3.Format("%f", ot3Days);

	CString strSQL( "INSERT INTO Kaoqin VALUES('" + CheckDate + "'," 
												   + stryg_ID + "," 
												   + strqq + "," 
												   + strcc + "," 
												   + strbj + ","
												   + strsj + ","
												   + strkg + ","	
												   + strfdxj + "," 
												   + strnxj + "," 
												   + strdxj + ","
												   + strcd + "," 
												   + strzt		+ "," 
												   + strot1 + "," 
												   + strot2 + "," 
												   + strot3 + ",'"
												   + Memo + "')" );	
	theApp.m_ado.Execute(strSQL);	
}


void CKaoqin::sql_update(CString cCheckDate, CString cyg_ID)
{
	CString stryg_ID, strqq, strcc,strbj,strsj,strkg,strfdxj,strnxj,strdxj,strcd,strzt,strot1,strot2,strot3;
	stryg_ID.Format("%d", yg_ID);
	strqq.Format("%f", qqDays);
	strcc.Format("%f", ccDays);
	strbj.Format("%f", bjDays);
	strsj.Format("%f", sjDays);
	strkg.Format("%f", kgDays);
	strfdxj.Format("%f", fdxjDays);
	strnxj.Format("%f", nxjDays);
	strdxj.Format("%f", dxjDays);
	strcd.Format("%d", cdMinutes);
	strzt.Format("%f", ztMinutes);
	strot1.Format("%f", ot1Days);
	strot2.Format("%f", ot2Days);
	strot3.Format("%f", ot3Days);


	CString strSQL("UPDATE Kaoqin SET qqDays=" + strqq 
							+ ", ccDays=" + strcc 
							+ ", bjDays=" + strbj 
							+ ", sjDays=" + strsj 
							+",  kgDays=" + strkg 	
							+ ", fdxjDays=" + strfdxj 
							+ ", nxjDays=" + strnxj 
							+ ", dxjDays=" 		+ strdxj 
							+ ", cdMinutes=" + strcd 
							+ ", ztMinutes=" + strzt	
							+ ", ot1Days=" + strot1 
							+ ", ot2Days=" + strot2 
							+ ", ot3Days=" 		+ strot3 
							+ ", Memo='" + Memo 
							+ "' WHERE CheckDate='" + cCheckDate		
							+ "' AND yg_ID=" + cyg_ID );
	theApp.m_ado.Execute(strSQL);	
}


void CKaoqin::sql_delete(CString cCheckDate, CString cyg_ID)
{
	theApp.m_ado.Execute("DELETE FROM Kaoqin WHERE CheckDate='" + cCheckDate+ "' AND yg_ID=" + cyg_ID);	
}


void CKaoqin::sql_deleteByYg(CString cyg_ID)
{
	theApp.m_ado.Execute("DELETE FROM Kaoqin WHERE yg_ID=" + cyg_ID);	
}