// TakeOut.cpp: implementation of the CTakeOut class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Stock.h"
#include "TakeOut.h"
#include "ADOConn.h"

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

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

CTakeOut::CTakeOut()
{
	Ttype = "";
	Pid = 0;
	Pprice = 0;
	Pnum = 0;
	Cid = 0;
	Sid = 0;
	EmpName = "";
	OptDate = "";
}

CTakeOut::~CTakeOut()
{

}

//設置和讀取成員變量
CString CTakeOut::GetTtype()
{
	return Ttype;
}

void CTakeOut::SetTtype(CString cTtype)
{
	Ttype = cTtype;
}

int CTakeOut::GetPid()
{
	return Pid;
}

void CTakeOut::SetPid(int iPid)
{
	Pid = iPid;
}

float CTakeOut::GetPprice()
{
	return Pprice;
}

void CTakeOut::SetPprice(float fPprice)
{
	Pprice = fPprice;
}

int CTakeOut::GetPnum()
{
	return Pnum;
}

void CTakeOut::SetPnum(int iPnum)
{
	Pnum = iPnum;
}

int CTakeOut::GetCid()
{
	return Cid;
}

void CTakeOut::SetCid(int iCid)
{
	Cid = iCid;
}

int CTakeOut::GetSid()
{
	return Sid;
}

void CTakeOut::SetSid(int iSid)
{
	Sid = iSid;
}

CString CTakeOut::GetEmpName()
{
	return EmpName;
}

void CTakeOut::SetEmpName(CString cEmpName)
{
	EmpName = cEmpName;
}

CString CTakeOut::GetOptDate()
{
	return OptDate;
}

void CTakeOut::SetOptDate(CString cOptDate)
{
	OptDate = cOptDate;
}

//數據庫操作
int CTakeOut::HaveClient(CString cCid)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM TakeOut WHERE Cid=" + cCid;
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

int CTakeOut::HaveProduct(CString cPid)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM TakeOut WHERE Pid=" + cPid;
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

int CTakeOut::HaveStore(CString cSid)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM TakeOut WHERE Sid=" + cSid;
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CTakeOut::sql_insert()
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置INSERT語句
	CString strPid;
	strPid.Format("%d", Pid);
	CString strPprice;
	strPprice.Format("%f", Pprice);
	CString strPnum;
	strPnum.Format("%d", Pnum);
	CString strCid;
	strCid.Format("%d", Cid);
	CString strSid;
	strSid.Format("%d", Sid);

	_bstr_t vSQL;
	vSQL = "INSERT INTO TakeOut VALUES('" + Ttype + "'," + strPid + ","
		+ strPprice + "," + strPnum + "," + strCid + "," + strSid + ",'"
		+ EmpName + "','" + OptDate + "')";
	
	//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}