// Grade.cpp: implementation of the CGrade class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "student.h"
#include "Grade.h"
#include "ADOConn.h"

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

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

CGrade::CGrade()
{
	Stu_Id=0;
	BadgeID="";
	Chinese=0;
	English=0;
	DataStruct=0;
	ComAlgor=0;
	OS=0;
	Java=0;
}

CGrade::~CGrade()
{

}

//設置和讀取成員變量的值
int CGrade::GetStu_Id()
{
	return Stu_Id;
}

void CGrade::SetSTu_Id(int cStu_Id)
{
	Stu_Id=cStu_Id;
}	

CString CGrade::GetBadgeID()
{
	return BadgeID;
}

void CGrade::SetBadgeID(CString cBadgeID)
{
	BadgeID=cBadgeID;
}
	
float CGrade::GetChinese()
{
	return Chinese;
}

void CGrade::SetChinese(float cChinese)
{
	Chinese=cChinese;
}
	
float CGrade::GetEnglish()
{
	return English;
}

void CGrade::SetEnglish(float cEnglish)
{
	English=cEnglish;
}
	
float CGrade::GetDataStruct()
{
	return DataStruct;
}

void CGrade::SetDataStruct(float cDataStruct)
{
	DataStruct=cDataStruct;
}
	
float CGrade::GetComAlgor()
{
	return ComAlgor;
}

void CGrade::SetComAlgor(float cComAlgor)
{
	ComAlgor=cComAlgor;
}
	
float CGrade::GetOS()
{
	return OS;
}

void CGrade::SetOS(float cOS)
{
	OS=cOS;
}
	
float CGrade::GetJava()
{
	return Java;
}

void CGrade::SetJava(float cJava)
{
	Java=cJava;
}
//數據庫操作
void CGrade::sql_insert()
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	
	//設置INSERT語句
		_bstr_t vSQL;
	vSQL = "INSERT INTO Grade (BadgeId, Chinese, English, DataStruct, ComAlgor, OS, Java) VALUES('"
		+ BadgeID + "',-1,-1,-1,-1,-1,-1)";
		
	//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CGrade::sql_update(CString cStu_Id)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strChinese;
	strChinese.Format("%f", Chinese);
	CString strEnglish;
	strEnglish.Format("%f", English);
	CString strDataStruct;
	strDataStruct.Format("%f", DataStruct);
	CString strComAlgor;
	strComAlgor.Format("%f", ComAlgor);
	CString strOS;
	strOS.Format("%f", OS);
	CString strJava;
	strJava.Format("%f", Java);

	_bstr_t vSQL;
	vSQL = "UPDATE Grade SET Chinese=" + strChinese +", English=" + strEnglish + ", DataStruct=" 
		+ strDataStruct + ",ComAlgor=" + strComAlgor + ",OS=" + strOS + ",Java="
		+ strJava + " WHERE Stu_Id=" + cStu_Id;
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

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

//根據學生編號讀取所有字段的值
void CGrade::GetData(CString cStu_Id)
{
		//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Grade WHERE Stu_Id=" + cStu_Id;
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF == 1)
		CGrade();
	else
	{
		Stu_Id = atoi(cStu_Id);
		BadgeID = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BadgeID");
		Chinese = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Chinese"));
		English = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("English"));
		DataStruct = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DataStruct"));
		ComAlgor = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("ComAlgor"));
		OS = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("OS"));
		Java = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Java"));
	}
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}