// borrow.cpp: implementation of the Cborrow class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "圖書管理.h"
#include "borrow.h"
#include "ADOConn.h"
	

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

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

Cborrow::Cborrow()
{
 bookno="";
 readno="";
 btime=0;
 htime="";
 money=0;

}

Cborrow::~Cborrow()
{

}

int Cborrow::Havename(CString str,CString str2)
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL,vSQL2;
	vSQL = "SELECT * FROM book WHERE bookno='" + str+"' ";
	vSQL2 = "SELECT * FROM reader WHERE readno='"+str2+"'";
	//執行SELECT語句
	_RecordsetPtr m_pRecordset;
    _RecordsetPtr m_pRecordset2;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
    m_pRecordset2 = m_AdoConn.GetRecordSet(vSQL2);
	if (m_pRecordset->adoEOF||m_pRecordset2->adoEOF)
		return -1;
	else
		return 1;
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}
void Cborrow::sql_insert()
{	
	//連接數據庫
	CString string,string3;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置INSERT語句
//	CString strUpperId;
//	strUpperId.Format("%d", UpperId);
     string.Format("%d",btime);
	 string3.Format("%d",money);
	_bstr_t vSQL;
	vSQL = "INSERT INTO borrow (bookno ,readno, btime, htime,money) VALUES('"+ bookno + "','" + readno + "','" + string + "','" +htime+"','"+ string3+"')";	
	//執行INSERT語句
     m_AdoConn.ExecuteSQL(vSQL);	

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

//	return lDepId;
}

void Cborrow::sql_update(CString bookno,CString readno)
{
	//連接數據庫
	CString string,string3,string2;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語
     string.Format("%d",btime);
	 string3.Format("%d",money);

	_bstr_t vSQL;
	
	vSQL = "UPDATE borrow SET btime='" +string+"',htime='" +htime+ "',money='" +string3+"'WHERE bookno='" + bookno+"'AND readno='"+readno+"'";
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void Cborrow::sql_delete(CString cDepId,CString str)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置DELETE語句
	_bstr_t vSQL;
	if(str=="")
    vSQL = "DELETE FROM borrow WHERE bookno='" + cDepId+"'";
	else
	 if(cDepId=="")
      vSQL = "DELETE FROM borrow WHERE readno='" + str+"'";
	else
      vSQL = "DELETE FROM borrow WHERE bookno='" + cDepId+"'AND readno='"+str+"' ";
	//執行DELETE語句

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

//根據員工編號讀取所有字段值
void Cborrow::GetData(CString cDepId,CString str)
{
	//連接數據庫
	CString string,string3,string2;
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM borrow WHERE bookno='" + cDepId+"'AND readno='"+str+"' ";
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		Cborrow();
	else
	{
		bookno = cDepId;
        readno=str;
		string = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("btime");
		htime = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("htime");
		string3 = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("money");
		btime=atoi(string);
		money=atoi(string3);
	}
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}