// Experience.cpp: implementation of the CExperience class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "HrSys.h"
#include "Experience.h"
#include "ADOConn.h"

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

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

CExperience::CExperience()
{
	Id = 0;
	Emp_Id = 0;
	Start_Date = "";
	End_Date = "";
	School_Org = "";
	Title = ""; 
}

CExperience::~CExperience()
{

}

int CExperience::GetId()
{
	return Id;
}

void CExperience::SetId(int iId)
{
	Id = iId;
}

int CExperience::GetEmp_Id()
{
	return Emp_Id;
}

void CExperience::SetEmp_Id(int iEmp_Id)
{
	Emp_Id = iEmp_Id;
}

CString CExperience::GetStart_Date()
{
	return Start_Date;
}

void CExperience::SetStart_Date(CString cDate)
{
	Start_Date = cDate;
}

CString CExperience::GetEnd_Date()
{
	return End_Date;
}

void CExperience::SetEnd_Date(CString cDate)
{
	End_Date = cDate;
}

CString CExperience::GetSchool_Org()
{
	return School_Org;
}

void CExperience::SetSchool_Org(CString cOrg)
{
	School_Org = cOrg;
}

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

void CExperience::SetTitle(CString cTitle)
{
	Title = cTitle;
}

	//數據庫操作
	void sql_insert();
	void sql_update(CString cId);
	void sql_delete(CString cId);
	void sql_deleteByEmp(CString cEmp_Id);

void CExperience::sql_insert()
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置INSERT語句
	CString strEmp_Id;
	strEmp_Id.Format("%d", Emp_Id);

	_bstr_t vSQL;
	vSQL = "INSERT INTO Experience (Emp_Id, Start_Date, End_Date, School_Org, Title) VALUES(" 
		+ strEmp_Id + ",'" + Start_Date + "','" + End_Date + "','" + School_Org + "','" 
		+ Title + "')";	
	//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CExperience::sql_update(CString cId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strEmp_Id;
	strEmp_Id.Format("%d", Emp_Id);

	_bstr_t vSQL;
	vSQL = "UPDATE Experience SET Emp_Id=" + strEmp_Id + ", Start_Date='" 
		+ Start_Date +"', End_Date='" + End_Date + "', School_Org='" + School_Org
		+ "', Title='" + Title + "' WHERE Id=" + cId;
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

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

void CExperience::sql_deleteByEmp(CString cEmp_Id)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置DELETE語句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Experience WHERE Emp_Id=" + cEmp_Id;
	//執行DELETE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}