yuangong.cpp

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

// Yuangong.cpp: implementation of the CYuangong class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "../Renshi.h"
#include "Yuangong.h"
#include "jiating.h"
#include "Jingli.h"
#include "Kaoqin.h"
#include "Pingjia.h"
#include "Admin.h"

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


extern CRenshiApp theApp;


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


CYuangong::CYuangong()
{

}

CYuangong::~CYuangong()
{
	yg_ID = 0;
	yg_Name = "";
	Sex = "";
	Nationality = "";
	Birth = "";
	Political_Party = "";
	Culture_Level = "";
	Marital_Condition = "";
	Family_Place = "";
	ID_Card = "";
	BadgeID = "";
	Office_phone = "";
	Mobile = "";
	Files_Keep_Org = "";
	Hukou = "";
	HireDate = "";
	BumenID = 0;
	Position = "";
	Title = "";
	State = 0;
	UpperID = 0;
	Contract_Duration = "";
	Memo = "";
	FillAdmin = "";
	FillDate = "";
}

int CYuangong::Getyg_ID()
{
	return yg_ID;
}

void CYuangong::Setyg_ID(int iyg_ID)
{
	yg_ID = iyg_ID;
}

CString CYuangong::Getyg_Name()
{
	return yg_Name;
}

void CYuangong::Setyg_Name(CString cyg_Name)
{
	yg_Name = cyg_Name;
}

CString CYuangong::GetSex()
{
	return Sex;
}

void CYuangong::SetSex(CString cSex)
{
	Sex = cSex;
}

CString CYuangong::GetNationality()
{
	return Nationality;
}

void CYuangong::SetNationality(CString cNationality)
{
	Nationality = cNationality;
}

CString CYuangong::GetBirth()
{
	return Birth;
}

void CYuangong::SetBirth(CString cBirth)
{
	Birth = cBirth;
}

CString CYuangong::GetPolitical_Party()
{
	return Political_Party;
}

void CYuangong::SetPolitical_Party(CString cParty)
{
	Political_Party = cParty;
}

CString CYuangong::GetCulture_Level()
{
	return Culture_Level;
}

void CYuangong::SetCulture_Level(CString cLevel)
{
	Culture_Level = cLevel;
}

CString CYuangong::GetMarital_Condition()
{
	return Marital_Condition;
}

void CYuangong::SetMarital_Condition(CString cCondition)
{
	Marital_Condition = cCondition;
}

CString CYuangong::GetFamily_Place()
{
	return Family_Place;
}

void CYuangong::SetFamily_Place(CString cPlace)
{
	Family_Place = cPlace;
}

CString CYuangong::GetID_Card()
{
	return ID_Card;
}

void CYuangong::SetID_Card(CString cCard)
{
	ID_Card = cCard;
}

CString CYuangong::GetBadgeID()
{
	return BadgeID;
}

void CYuangong::SetBadgeID(CString cBadgeID)
{
	BadgeID = cBadgeID;
}

CString CYuangong::GetOffice_phone()
{
	return Office_phone;
}

void CYuangong::SetOffice_phone(CString cOffice)
{
	Office_phone = cOffice;
}

CString CYuangong::GetMobile()
{
	return Mobile;
}

void CYuangong::SetMobile(CString cMobile)
{
	Mobile = cMobile;
}

CString CYuangong::GetFiles_Keep_Org()
{
	return Files_Keep_Org;
}

void CYuangong::SetFiles_Keep_Org(CString cOrg)
{
	Files_Keep_Org = cOrg;
}

CString CYuangong::GetHukou()
{
	return Hukou;
}

void CYuangong::SetHukou(CString cHukou)
{
	Hukou = cHukou;
}

CString CYuangong::GetHireDate()
{
	return HireDate;
}

void CYuangong::SetHireDate(CString cHireDate)
{
	HireDate = cHireDate;
}

int CYuangong::GetBumenID()
{
	return BumenID;
}

void CYuangong::SetBumenID(int iBumenID)
{
	BumenID = iBumenID;
}

CString CYuangong::GetPosition()
{
	return Position;
}

void CYuangong::SetPosition(CString cPosition)
{
	Position = cPosition;
}

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

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

int CYuangong::GetState()
{
	return State;
}

void CYuangong::SetState(int iState)
{
	State = iState;
}

int CYuangong::GetUpperID()
{
	return UpperID;
}

void CYuangong::SetUpperID(int iUpperID)
{
	UpperID = iUpperID;
}

CString CYuangong::GetContract_Duration()
{
	return Contract_Duration;
}

void CYuangong::SetContract_Duration(CString cDuration)
{
	Contract_Duration = cDuration;
}

CString CYuangong::GetMemo()
{
	return Memo;
}

void CYuangong::SetMemo(CString cMemo)
{
	Memo = cMemo;
}

CString CYuangong::GetFillAdmin()
{
	return FillAdmin;
}

void CYuangong::SetFillAdmin(CString cPerson)
{
	FillAdmin = cPerson;
}

CString CYuangong::GetFillDate()
{
	return FillDate;
}

void CYuangong::SetFillDate(CString cTime)
{
	FillDate = cTime;
}



/****************************************************************************************/

//根据员工姓名判断该员工是否在数据库中存在
int CYuangong::HaveName(CString cyg_Name)
{	
	_RecordsetPtr m_pRecordset = theApp.m_ado.GetRS( "SELECT * FROM Yuangong WHERE yg_Name='" + cyg_Name + "'");
	
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
}


//根据员工ID获取员工姓名
CString CYuangong::GetName(CString sID)
{	
	_RecordsetPtr m_pRecordset = theApp.m_ado.GetRS("SELECT yg_Name FROM Yuangong WHERE yg_ID=" + sID);

	if (m_pRecordset->adoEOF)
		return "";
	else
		return (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("yg_Name");
}


//插入新的员工信息
void CYuangong::sql_insert()
{	
	CString strBumenID,strState,strUpperID;

	strBumenID.Format("%d", BumenID);
	strState.Format("%d", State);
	strUpperID.Format("%d", UpperID);

	CString vSQL;
	vSQL = "INSERT INTO Yuangong ( yg_Name,					\
								   Sex,						\
								   Nationality,				\
								   Birth,					\
								   Political_Party,			\
								   Culture_Level,			\
								   Marital_Condition,		\
								   Family_Place,			\
								   ID_Card,					\
								   BadgeID,					\
								   Office_phone,			\
								   Mobile,					\
								   Files_Keep_Org,			\
								   Hukou,					\
								   HireDate,				\
								   BumenID,					\
								   Position,				\
								   Title,					\
								   State,					\
								   UpperID,					\
								   Contract_Duration,		\
								   Memo,					\
								   FillAdmin,				\
								   FillDate)				\
			VALUES('" + yg_Name			+ "','" 
					  + Sex					+ "','" 
					  + Nationality			+ "','" 
					  + Birth 				+ "','" 
					  + Political_Party		+ "','" 
					  + Culture_Level		+ "','" 
					  + Marital_Condition	+ "','" 
					  + Family_Place		+ "','" 
					  + ID_Card				+ "','" 
					  + BadgeID				+ "','" 
					  + Office_phone		+ "','" 
					  + Mobile				+ "','" 
					  + Files_Keep_Org		+ "','" 
					  + Hukou				+ "','" 
					  + HireDate			+ "'," 
					  + strBumenID			+ ",'" 
					  + Position			+ "','" 
					  + Title				+ "'," 
					  + strState			+ "," 
					  + strUpperID			+ ",'" 
					  + Contract_Duration	+ "','" 
					  + Memo				+ "','" 
				      + FillAdmin		+ "','" 
					  + FillDate + "')";	

	
	theApp.m_ado.Execute(vSQL);	
}


//根据员工ID更新员工的信息
void CYuangong::sql_update(CString sID)
{
	CString strState ,strUpperID;
	strState.Format("%d", State);
	strUpperID.Format("%d", UpperID);

	CString str("UPDATE Yuangong SET	  yg_Name='" +			yg_Name 
									+ "', 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 
									+ "', Position='"+			Position 
									+ "', Title='" +			Title 
									+ "', State=" +				strState 
									+ ",  UpperID="+			strUpperID 
									+ ",  Contract_Duration='"+ Contract_Duration 
									+ "', Memo='" +				Memo 
									+ "', FillAdmin='" +		FillAdmin 
									+ "', FillDate='"+			FillDate 
				+ "' WHERE yg_ID=" + sID );

	
	theApp.m_ado.Execute(str);	
}



//根据员工ID修改员工所在的部门(用于部门调转功能模块中)
void CYuangong::sql_updateBumen(CString sID)
{
	CString strID;
	strID.Format("%d", BumenID);

	theApp.m_ado.Execute("UPDATE Yuangong SET BumenID=" + strID + " WHERE yg_ID=" + sID);	
}


//根据员工ID删除该员工的相关信息
void CYuangong::sql_delete(CString sID)
{
	theApp.m_ado.Execute( "DELETE FROM Yuangong WHERE yg_ID=" + sID);	

	
	CJiating fam;
	fam.sql_deleteByYg(sID);	//删除表Family中的相关员工记录
	
	CJingli exp;
	exp.sql_deleteByYg(sID);	//删除表Jingli中的相关员工记录

	CKaoqin check;
	check.sql_deleteByYg(sID);	//删除表Kaoqin中的相关员工记录

	CPingjia eva;
	eva.sql_deleteByYg(sID);	//删除表Pingjia中的相关员工记录
}



//根据员工编号读取所有字段值
void CYuangong::GetData(CString sID)
{
	_RecordsetPtr m_pRecordset = theApp.m_ado.GetRS("SELECT * FROM Yuangong WHERE yg_ID=" + sID);

	if (m_pRecordset->adoEOF)
	{
		CYuangong();	//如果查询的结果为空,调用构造函数返回默认的值
	}
	else
	{
		yg_ID				= atoi(sID);
		yg_Name				= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("yg_Name");
		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");
		BumenID		   = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("BumenID"));
		Position			= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Position");
		Title				= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Title");
		State		   = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("State"));
		UpperID		   = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UpperID"));
		Contract_Duration	= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Contract_Duration");
		Memo				= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Memo");
		FillAdmin		    = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("FillAdmin");
		FillDate			= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("FillDate");

	}
}