// film.cpp: implementation of the Cfilm class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "課程設計.h"
#include "film.h"
#include "ADOConn.h"
#include "rage.h"

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

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

Cfilm::Cfilm()
{

}

Cfilm::~Cfilm()
{

}
void Cfilm::sql_seek(CString Id)
{
	CString  str;
    //連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM FILM WHERE ID="+ Id;
    	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	
	//返回各列的值
	if (m_pRecordset->adoEOF)
	{
	   AfxMessageBox("沒有這項記錄");
	   id=0;
	}
	else
	{
	 name=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("NAME");
     id=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ID"));
	 type=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("TYPE");
     author=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AUTHOR");
	 str=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LEND");
	 if(str=="0")
		lend=false;
	 else 
		lend=true;
	 }
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}
void Cfilm::sql_insert()
{
		//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置INSERT語句
	CString Id,Lend;
	Id.Format("%d",id);
	Lend.Format("%d",lend);
   	_bstr_t vSQL;
   vSQL = "INSERT INTO FILM values(" + Id + ",'" + name + "','" + type + "','" + author + "'," + Lend + ")";
   //執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();

}
void Cfilm::sql_delete(CString Id)
{
   //連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置DELETE語句
	_bstr_t vSQL;
	vSQL = "DELETE FROM FILM WHERE ID=" + Id;
    m_AdoConn.ExecuteSQL(vSQL);
	/*_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
    if (m_pRecordset->adoEOF)
		Cfilm();
	else
		{
	 name=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("NAME");
     id=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ID"));
	 type=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("TYPE");
     author=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AUTHOR");
	 if(atoi((_bstr_t)m_pRecordset->GetCollect("LEND"))>0)
		 lend=1;
	 else lend=0;
	}*/
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();

}
void Cfilm::sql_update(CString Id)
{
    	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strlend;
    strlend.Format("%d",lend);
	_bstr_t vSQL;
	vSQL = "UPDATE FILM SET  LEND="
		+ strlend + " WHERE ID=" + Id;
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}
bool Cfilm::sql_getlend(CString Id)
{
	CString str;
   	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT LEND FROM FILM WHERE ID="+ Id;
    	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	
	//返回各列的值
	if (m_pRecordset->adoEOF)
	{
	   AfxMessageBox("沒有這項記錄");
	}
	else
	{
	str=(LPCTSTR)((_bstr_t)m_pRecordset->GetCollect("LEND"));
	 if(str=="0")
		lend=false;
	 else 
		 lend=true;
	 }
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
	return lend;
}