// Paints.cpp: implementation of the CPaints class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "VirtualTeacher.h"
#include "Paints.h"
#include "ADOConn.h"

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

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

CPaints::CPaints()
{

}

CPaints::~CPaints()
{
	int Pic_ID=0;
	CString Pic_Name="";
	int Course_ID=0;

}

//讀取和設置成員變量
int CPaints::GetPic_ID()
{
	return Pic_ID;
}

void CPaints::SetPic_ID(int iPic_ID)
{
	Pic_ID = iPic_ID;
}

CString CPaints::GetPic_Name()
{
	return Pic_Name;
}

void CPaints::SetPic_Name(CString cPic_Name)
{
	Pic_Name = cPic_Name;
}

int CPaints::GetCourse_ID()
{
	return Course_ID;
}

void CPaints::SetCourse_ID(int iCourse_ID)
{
	Course_ID = iCourse_ID;
}

//數據庫操作
int CPaints::HaveName(CString cPic_Name)
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Paints WHERE Pic_Name='" + cPic_Name + "'";
	
	//執行SELECT語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

CString CPaints::GetName(CString cPic_id)
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT Pic_Name FROM Paints WHERE Pic_ID=" + cPic_id;
	
	//執行SELECT語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return "";
	else
		return (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Pic_Name");

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

void CPaints::sql_insert()
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置INSERT語句
	CString strCourse_ID;
	strCourse_ID.Format("%d", Course_ID);
	
    _bstr_t vSQL;
	vSQL = "INSERT INTO Paints (Pic_Name, Course_ID) VALUES('"+Pic_Name+"',"+strCourse_ID+")";
	//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CPaints::sql_update(CString cPic_ID)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
    CString strCourse_ID;
	strCourse_ID.Format("%d", Course_ID);
	
	_bstr_t vSQL;
	vSQL = "UPDATE Paints SET Pic_Name='" + Pic_Name + "' WHERE Pic_ID="+cPic_ID+"";
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

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

//根據圖片文件編號讀取所有字段值
void CPaints::GetData(CString cPic_ID)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Paints WHERE Pic_ID=" + cPic_ID;
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CPaints();
	else
	{
		Pic_ID = atoi(cPic_ID);
		Pic_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Pic_Name");
		Course_ID = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Course_ID"));
	}
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}