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

#include "stdafx.h"
#include "HrSys.h"
#include "Employees.h"
#include "ADOConn.h"
#include "Salary.h"
#include "Users.h"

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

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

CEmployees::CEmployees()
{

}

CEmployees::~CEmployees()
{
	EmpId = 0;
	EmpName = "";
	Sex = "";
	Nationality = "";
	Birth = "";
	Political_Party = "";
	Culture_Level = "";
	Marital_Condition = "";
	Family_Place = "";
	Id_Card = "";
	BadgeId = "";
	Office_phone = "";
	Mobile = "";
	Files_Keep_Org = "";
	Hukou = "";
	HireDate = "";
	DepId = 0;
	Position = "";
	sTitle = "";
	State = 0;
	UpperId = 0;
	Salary=0;
	Memo = "";
	Fillin_Person = "";
	Fillin_Time = "";
}
//讀取指定員工姓名
CString CEmployees::GetName(CString cEmpId)
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT EmpName FROM Employees WHERE EmpId=" + cEmpId;
	
	//執行SELECT語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return "";
	else
		return (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("EmpName");

	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}
//插入數據庫
void CEmployees::sql_insert()
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置INSERT語句
	CString strDepId;
	strDepId.Format("%d", DepId);
	CString strState;
	strState.Format("%d", State);
	CString strUpperId;
	strUpperId.Format("%d", UpperId);
	_bstr_t vSQL;
	vSQL = "INSERT INTO Employees(EmpName,Sex,Nationality,Birth,"
		"Political_Party,Culture_Level,Marital_Condition,Family_Place,"
		"Id_Card,BadgeID,Office_phone,Mobile,Files_Keep_Org,HuKou,"
		"HireDate,DepId,Position1,Title,State,UpperId,Salary,"
		"Memo1,Fillin_Person,Fillin_Time) VALUES('"
	    + EmpName + "','" + Sex + "','" + Nationality + "','" + Birth + "','"
		+ Political_Party + "','" + Culture_Level + "','" + Marital_Condition
		+ "','" + Family_Place + "','" + Id_Card + "','" + BadgeId + "','"
		+ Office_phone + "','" + Mobile + "','" + Files_Keep_Org + "','"
		+ Hukou + "','" + HireDate + "'," + strDepId + ",'" + Position
		+ "','" + sTitle + "'," + strState + "," + strUpperId + ",0,'"
		+ Memo + "','" + Fillin_Person + "','"
		+ Fillin_Time + "')";
	//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CEmployees::sql_update(CString cEmpId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strState;
	strState.Format("%d", State);
	CString strUpperId;
	strUpperId.Format("%d", UpperId);
	_bstr_t vSQL;
	vSQL = "UPDATE Employees SET EmpName='" + EmpName + "', Sex='" + Sex
		+ "', Nationality='" + Nationality + "', Birth='" + Birth
		+ "', Political_Party='" + Political_Party + "', Culture_Level='"
		+ Culture_Level + "', Marital_Condition='" + Marital_Condition
		+ "', Family_Place='" + Family_Place + "', Id_Card='" + Id_Card
		+ "', BadgeId='" + BadgeId + "', Office_phone='" + Office_phone
		+ "', Mobile='" + Mobile + "', Files_Keep_Org='" + Files_Keep_Org
		+ "', Hukou='" + Hukou + "', HireDate='" + HireDate + "', Position1='" 
		+ Position + "', Title='" + sTitle + "', State=" + strState + ", UpperId="
		+ strUpperId + ", Memo1='" 
		+ Memo + "', Fillin_Person='" + Fillin_Person + "', Fillin_Time='" 
		+ Fillin_Time + "' WHERE EmpId=" + cEmpId;
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}
//更改員工部門編號
void CEmployees::sql_updateDep(CString cEmpId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strDepId;
	strDepId.Format("%d", DepId);

	_bstr_t vSQL;
	vSQL = "UPDATE Employees SET DepId=" + strDepId + ", Title='"
		+ sTitle + "' WHERE EmpId=" + cEmpId;
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

//更改員工工資
void CEmployees::sql_updateSalary(CString cEmpId)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strSalary;
	strSalary.Format("%d", Salary);

	_bstr_t vSQL;
	vSQL = "UPDATE Employees SET Salary=" + strSalary + " WHERE EmpId=" + 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 EmpId=" + cEmpId;
	//執行DELETE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
	//刪除表Salary中的相關員工記錄
	CSalary sal;
	sal.sql_deleteByEmp(cEmpId);
}

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CEmployees();
	else
	{
		EmpId = atol(cEmpId);
		EmpName = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("EmpName");
		Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
		Nationality = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Nationality");
		Birth = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Birth");
		Political_Party = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Political_Party");
		Culture_Level = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Culture_Level");
		Marital_Condition = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Marital_Condition");
		Family_Place = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Family_Place");
		Id_Card = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Id_Card");
		BadgeId = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BadgeID");
		Office_phone = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Office_phone");
		Mobile = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Mobile");
		Files_Keep_Org = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Files_Keep_Org");
		Hukou = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Hukou");
		HireDate = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("HireDate");
		DepId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DepId"));
		Position = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Position1");
		sTitle = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Title");
		State = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("State"));
		UpperId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UpperId"));
		Salary = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Salary"));
		Memo = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Memo1");
		Fillin_Person = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fillin_Person");
		Fillin_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fillin_Time");

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