// Employees.h: interface for the CEmployees class.
//
//////////////////////////////////////////////////////////////////////

#if !defined(AFX_EMPLOYEES_H__B8063B4E_329F_4C28_BE56_5B92252C2935__INCLUDED_)
#define AFX_EMPLOYEES_H__B8063B4E_329F_4C28_BE56_5B92252C2935__INCLUDED_

#if _MSC_VER > 1000
#pragma once
#endif // _MSC_VER > 1000
#include "ADOConn.h"
class CEmployees  
{
public:
	long EmpId;
	CString EmpName;
	CString Sex;
	CString Nationality;
	CString Birth;
	CString Political_Party;
	CString Culture_Level;
	CString Marital_Condition;
	CString Family_Place;
	CString Id_Card;
	CString BadgeId;
	CString Office_phone;
	CString Mobile;
	CString Files_Keep_Org;
	CString Hukou;
	CString HireDate;
	long DepId;
	CString Position;
	CString sTitle;
	int State;
	long UpperId;
	int Salary;
	CString Memo;
	CString Fillin_Person;
	CString Fillin_Time;
public:
	CEmployees();
	virtual ~CEmployees();
public:
	//數據庫操作
	CString GetName(CString cEmpId);  //根據指定的員工編號返回員工姓名
	void sql_insert();
	void sql_update(CString cEmpId);
	void sql_updateDep(CString cEmpId); //更新部門信息，在調轉部門時調用
	void sql_updateSalary(CString cEmpId); // 更新工資信息,在調薪時調用
	void sql_delete(CString cEmpId);
	//根據員工編號讀取所有字段值
	void GetData(CString cEmpId);

};

#endif // !defined(AFX_EMPLOYEES_H__B8063B4E_329F_4C28_BE56_5B92252C2935__INCLUDED_)