employees.cpp

软件外包人事综合管理系统,对员工的管理,部门管理,以及考勤管理和薪资管理.总得来说功能完全.

// 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 = "";
	Hukou = "";
	HireDate = "";
	DepId = 0;
	Position = "";
	sTitle = "";
	State = 0;
	UpperId = 0;
	Salary=0;
	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,HuKou,"
		"HireDate,DepId,Position1,Title,State,UpperId,Salary,"
		"Fillin_Person,Fillin_Time) VALUES('"
	    + EmpName + "','" + Sex + "','" + Nationality + "','" + Birth + "','"
		+ Political_Party + "','" + Culture_Level + "','" + Marital_Condition
		+ "','" + Family_Place + "','" + Id_Card + "','" + BadgeId + "','"
		+ Office_phone + "','" + Mobile + "','"
		+ Hukou + "','" + HireDate + "'," + strDepId + ",'" + Position
		+ "','" + sTitle + "'," + strState + "," + strUpperId + ",0,'" + 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 + "', Hukou='" + Hukou + "', HireDate='" + HireDate 
		+ "', Position1='" + Position + "', Title='" + sTitle + "', State=" + strState + ", UpperId="
		+ strUpperId + ", 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");
		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"));
		Fillin_Person = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fillin_Person");
		Fillin_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Fillin_Time");

	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}