// Employees.cpp: implementation of the CEmployees class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Ado.h"
#include "Employees.h"
#include "ADOConn.h"

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

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

CEmployees::CEmployees()
{
	Emp_id = 0;
	Emp_name = "";
	Sex = "";
	Title = "";
	Wage = 0;
	Dep_id = 0;
}

CEmployees::~CEmployees()
{

}

//設置和讀取成員變量值
int CEmployees::GetEmp_id()
{
	return Emp_id;
}

void CEmployees::SetEmp_id(int vEmpId)
{
	Emp_id = vEmpId;
}

CString CEmployees::GetEmp_name()
{
	return Emp_name;
}

void CEmployees::SetEmp_name(CString vEmpName)
{
	Emp_name = vEmpName;
}

CString CEmployees::GetSex()
{
	return Sex;
}

void CEmployees::SetSex(CString vSex)
{
	Sex = vSex;
}

CString CEmployees::GetTitle()
{
	return Title;
}

void CEmployees::SetTitle(CString vTitle)
{
	Title = vTitle;
}

float CEmployees::GetWage()
{
	return Wage;
}

void CEmployees::SetWage(float vWage)
{
	Wage = vWage;
}

int CEmployees::GetDep_id()
{
	return Dep_id;
}

void CEmployees::SetDep_id(int vDepId)
{
	Dep_id = vDepId; 
}

//數據庫操作
void CEmployees::sql_insert()
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置INSERT語句
	CString strWage;
	strWage.Format("%f", Wage);
	_bstr_t vSQL;
	vSQL = "INSERT INTO Employees (Emp_name, Sex, Title, Wage, Dep_id) VALUES('"
		+ Emp_name + "','" + Sex + "','" + Title + "'," + strWage + ", 1)";
	
	//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CEmployees::sql_update(CString cEmpId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strWage;
	strWage.Format("%f", Wage);

	_bstr_t vSQL;
	vSQL = "UPDATE Employees SET Emp_name='" + Emp_name 
		+ "', Sex='" + Sex +"', Title='" + Title + "', Wage=" 
		+ strWage + " WHERE Emp_id=" + cEmpId;
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

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

//根據員工編號讀取所有字段值
void CEmployees::GetData(CString cEmpId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Employees WHERE Emp_id=" + cEmpId;
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF == 1)
		CEmployees();
	else
	{
		Emp_id = atoi(cEmpId);
		Emp_name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Emp_Name");
		Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
		Title = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Title");
		Wage = atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Wage"));
		Dep_id = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Dep_id"));
	}
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}