yuangong.h

企业之间的竞争主要体现在三个方面：产品市场的竞争、资金市场的竞争和人才市场的竞争。在网络经济的环境下

// Yuangong.h: interface for the CYuangong class.
//////////////////////////////////////////////////////////////////////

#if !defined _EMPLOYEES_H__
#define _EMPLOYEES_H__

#pragma once


//////////////////////////////////////////////////////////////////////
class CYuangong  
{
private: //员工的属性
	int		yg_ID;
	CString yg_Name;
	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;
	int		BumenID;
	CString Position;
	CString Title;
	int		State;
	int		UpperID;
	CString Contract_Duration;
	CString Memo;
	CString FillAdmin;
	CString FillDate;
public:
	CYuangong();
	virtual ~CYuangong();


public:	//对员工属性的操作函数
	int		Getyg_ID();
	void	Setyg_ID(int iyg_ID);
	CString Getyg_Name();
	void	Setyg_Name(CString cyg_Name);
	CString GetSex();
	void	SetSex(CString cSex);
	CString GetNationality();
	void	SetNationality(CString cNationality);
	CString GetBirth();
	void	SetBirth(CString cBirth);
	CString GetPolitical_Party();
	void	SetPolitical_Party(CString cParty);
	CString GetCulture_Level();
	void	SetCulture_Level(CString cLevel);
	CString GetMarital_Condition();
	void	SetMarital_Condition(CString cCondition);
	CString GetFamily_Place();
	void	SetFamily_Place(CString cPlace);
	CString GetID_Card();
	void	SetID_Card(CString cCard);
	CString GetBadgeID();
	void	SetBadgeID(CString cBadgeID);
	CString GetOffice_phone();
	void	SetOffice_phone(CString cOffice);
	CString GetMobile();
	void	SetMobile(CString cMobile);
	CString GetFiles_Keep_Org();
	void	SetFiles_Keep_Org(CString cOrg);
	CString GetHukou();
	void	SetHukou(CString cHukou);
	CString GetHireDate();
	void	SetHireDate(CString cHireDate);
	int		GetBumenID();
	void	SetBumenID(int iBumenID);
	CString GetPosition();
	void	SetPosition(CString cPosition);
	CString GetTitle();
	void	SetTitle(CString cTitle);
	int		GetState();
	void	SetState(int iState);
	int		GetUpperID();
	void	SetUpperID(int iUpperID);
	CString GetContract_Duration();
	void	SetContract_Duration(CString cDuration);
	CString GetMemo();
	void	SetMemo(CString cMemo);
	CString GetFillAdmin();
	void	SetFillAdmin(CString cPerson);
	CString GetFillDate();
	void	SetFillDate(CString cTime);


public:  //数据库操作函数
	int		HaveName(CString cyg_Name);			//判断指定的员工姓名是否存在
	CString GetName(CString sID);				//根据指定的员工编号返回员工姓名
	void	GetData(CString sID);				//根据员工编号读取所有字段值

	void	sql_insert();
	void	sql_update(CString sID);
	void	sql_updateBumen(CString sID);		//更新部门信息，在调转部门时调用
	void	sql_delete(CString sID);	

};


//////////////////////////////////////////////////////////////////////
#endif