jiating.cpp

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

// Family.cpp
/*********************************************************************/

#include "stdafx.h"
#include "../Renshi.h"
#include "Jiating.h"

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



/*********************************************************************/
extern CRenshiApp theApp;
/*********************************************************************/
CJiating::CJiating()
{
	ID = 0;
	yg_ID = 0;
	Name = "";
	Sex = "";
	Age = 0;
	Relationship = "";
	WorkingOrg = "";
}

CJiating::~CJiating()
{

}


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

int CJiating::GetID()
{
	return ID;
}

void CJiating::SetID(int iID)
{
	ID = iID;
}

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

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

CString CJiating::GetName()
{
	return Name;
}

void CJiating::SetName(CString cName)
{
	Name = cName;
}

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

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

int CJiating::GetAge()
{
	return Age;
}

void CJiating::SetAge(int iAge)
{
	Age = iAge;
}

CString CJiating::GetRelationship()
{
	return Relationship;
}

void CJiating::SetRelationship(CString cRelationship)
{
	Relationship = cRelationship;
}

CString CJiating::GetWorkingOrg()
{
	return WorkingOrg;
}

void CJiating::SetWorkingOrg(CString cWorkingOrg)
{
	WorkingOrg = cWorkingOrg;
}



/*********************************************************************/
void CJiating::sql_insert()
{	
	CString strAge,stryg_ID;
	strAge.Format("%d", Age);
	stryg_ID.Format("%d", yg_ID);

	CString str	;
	str="INSERT INTO Family (yg_ID,	Name,Sex, Age,Relationship,WorkingOrg)	\
				VALUES(" + stryg_ID		+ ",'" 
						 + Name			+ "','" 
						 + Sex			+ "'," 
						 + strAge		+ ",'" 		
						 + Relationship + "','"
						 + WorkingOrg	+ "')" ;	

	theApp.m_ado.Execute(str);	
}


void CJiating::sql_update(CString cID)
{
	CString strAge,stryg_ID;
	strAge.Format("%d", Age);
	stryg_ID.Format("%d", yg_ID);

	CString vSQL;
	vSQL = "UPDATE Family SET		yg_ID=" +			stryg_ID 						
						   + ",		Name='" 	+		Name 
						   + "',	Sex='" +			Sex 
						   + "',	Age=" +				strAge 
						   + ",		Relationship='"	+	Relationship 
						   + "',	WorkingOrg='" +		WorkingOrg 
			+ "' WHERE ID=" + cID;

	
	theApp.m_ado.Execute(vSQL);	
}

void CJiating::sql_delete(CString cID)
{
	theApp.m_ado.Execute("DELETE FROM Family WHERE ID=" + cID);	
}

void CJiating::sql_deleteByYg(CString cyg_ID)
{
	theApp.m_ado.Execute("DELETE FROM Family WHERE yg_ID=" + cyg_ID);	
}