📄 staff.cpp

📁 这是一个企业办公管理系统。实现了文件的制作、修改、传递、、保存、销毁、存档等一系列操作。为windows系统认证模式
💻 CPP
字号:
// ClientStaff.cpp: implementation of the CClientStaff class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Office.h"
#include "Staff.h"

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

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

CStaff::CStaff()
{

}

CStaff::~CStaff()
{

}



CString	CStaff::GetStaffID()
{
	return staffID;
}

CString	CStaff::GetStaffName()
{
	return staffName;
}

CString	CStaff::GetSex()
{
	return sex;
}

COleDateTime	CStaff::GetBirthday()
{
	return birthday;
}

CString	CStaff::GetNationality()
{
	return nationality;
}

CString	CStaff::GetMarriageCondition()
{
	return marriageCondition;
}



CString	CStaff::GetEducationLevel()
{
	return educationLevel;
}

CString	CStaff::GetGraduateSchool()
{
	return graduateSchool;
}

CString	CStaff::GetTelephone()
{
	return telephone;
}

CString	CStaff::GetPostCode()
{
	return postCode;
}

CString	CStaff::GetMobile()
{
	return mobile;
}

CString	CStaff::GetQQ()
{
	return QQ;
}

CString	CStaff::GetEMail()
{
	return eMail;
}

CString	CStaff::GetDepartment()
{
	return department;
}



CString	CStaff::GetDuty()
{
	return duty;
}

CString	CStaff::GetAddress()
{
	return address;
}



CString	CStaff::GetRemark()
{
	return remark;
}

CString CStaff::GetContractID()   //合同编号
{
	return contractID;
}
int	CStaff::GetContractTerm() //合同期限
{
	return contractTerm;
}
CString CStaff::GetWorkType()    //工种
{
	return workType;
}
CString CStaff::GetIdentityNO()   //身份证号
{
	return identityNO;
}
CString CStaff::GetMajor()        //专业
{
	return major;
}



void CStaff::SetStaffID(CString vStaffID)
{
	staffID=vStaffID;
}

void CStaff::SetStaffName(CString vStaffName)
{
	staffName=vStaffName;
}

void CStaff::SetSex(CString vSex)
{
	sex=vSex;
}

void CStaff::SetBirthday(COleDateTime vBirthday)
{
	birthday=vBirthday;
}

void CStaff::SetNationality(CString vNationality)
{
	nationality=vNationality;
}

void CStaff::SetMarriageCondition(CString vMarriageCondition)
{
	marriageCondition=vMarriageCondition;
}



void CStaff::SetEducationLevel(CString vEducationLevel)
{
	educationLevel=vEducationLevel;
}

void CStaff::SetGraduateSchool(CString vGraduateSchool)
{
	graduateSchool=vGraduateSchool;
}

void CStaff::SetTelephone(CString vTelephone)
{
	telephone=vTelephone;
}

void CStaff::SetPostCode(CString vPostcode)
{
	postCode=vPostcode;
}

void CStaff::SetMobile(CString vMobile)
{
	mobile=vMobile;
}

void CStaff::SetQQ(CString vQQ)
{
	QQ=vQQ;
}

void CStaff::SetEMail(CString vEMail)
{
	eMail=vEMail;
}

void CStaff::SetDepartment(CString vDepartment)
{
	department=vDepartment;
}


void CStaff::SetDuty(CString vDuty)
{
	duty=vDuty;
}

void CStaff::SetAddress(CString vAddress)
{
	address=vAddress;
}



void CStaff::SetRemark(CString vRemark)
{
	remark=vRemark;
}

void CStaff::GetContractID(CString vContractID)   //合同编号
{
	contractID=vContractID;
}
void CStaff::GetContractTerm(int vContractTerm) //合同期限
{
	contractTerm=vContractTerm;
}
void CStaff::GetWorkType(CString vWorkType)     //工种
{
	workType=vWorkType;
}
void CStaff::GetIdentityNO(CString vIdentityNO)   //身份证号
{
	identityNO=vIdentityNO;
}
void CStaff::GetMajor(CString vMajor)        //专业
{
	major=vMajor;
}

void CStaff::sqlInsert()
{
	CString strSQL;

	strSQL="select * from staff";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(SUCCEEDED(hTRes))
	{
		m_pRecordset->AddNew();

		CString str;
		m_pRecordset->PutCollect("staffID",_variant_t(staffID));
		m_pRecordset->PutCollect("staffName",_variant_t(staffName));
		m_pRecordset->PutCollect("sex",_variant_t(sex));
		m_pRecordset->PutCollect("birthday",_variant_t(birthday));
		m_pRecordset->PutCollect("nationality",_variant_t(nationality));
		m_pRecordset->PutCollect("marriageCondition",_variant_t(marriageCondition));
		m_pRecordset->PutCollect("educationLevel",_variant_t(educationLevel));
		m_pRecordset->PutCollect("graduateSchool",_variant_t(graduateSchool));
		m_pRecordset->PutCollect("telephone",_variant_t(telephone));
		m_pRecordset->PutCollect("postcode",_variant_t(postCode));
		m_pRecordset->PutCollect("mobile",_variant_t(mobile));
		m_pRecordset->PutCollect("QQ",_variant_t(QQ));
		m_pRecordset->PutCollect("eMail",_variant_t(eMail));
		m_pRecordset->PutCollect("department",_variant_t(department));
		m_pRecordset->PutCollect("duty",_variant_t(duty));
		m_pRecordset->PutCollect("address",_variant_t(address));
		m_pRecordset->PutCollect("remark",_variant_t(remark));
		m_pRecordset->PutCollect("contractID",_variant_t(contractID));
		str.Format("%d",contractTerm);
		m_pRecordset->PutCollect("contractTerm",_variant_t(str));
		m_pRecordset->PutCollect("workType",_variant_t(workType));
		m_pRecordset->PutCollect("identityNO",_variant_t(identityNO));
		m_pRecordset->PutCollect("major",_variant_t(major));
	

		
		m_pRecordset->Update();
	}

}

void CStaff::sqlUpdate(CString vStaffID)
{
	CString strSQL;

	strSQL="select * from staff where staffID='";
	strSQL=strSQL+vStaffID+"'";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(SUCCEEDED(hTRes))
	{
		CString str;
		m_pRecordset->PutCollect("staffID",_variant_t(staffID));
		m_pRecordset->PutCollect("staffName",_variant_t(staffName));
		m_pRecordset->PutCollect("sex",_variant_t(sex));
		m_pRecordset->PutCollect("birthday",_variant_t(birthday));
		m_pRecordset->PutCollect("nationality",_variant_t(nationality));
		m_pRecordset->PutCollect("marriageCondition",_variant_t(marriageCondition));
		m_pRecordset->PutCollect("educationLevel",_variant_t(educationLevel));
		m_pRecordset->PutCollect("graduateSchool",_variant_t(graduateSchool));
		m_pRecordset->PutCollect("telephone",_variant_t(telephone));
		m_pRecordset->PutCollect("postcode",_variant_t(postCode));
		m_pRecordset->PutCollect("mobile",_variant_t(mobile));
		m_pRecordset->PutCollect("QQ",_variant_t(QQ));
		m_pRecordset->PutCollect("eMail",_variant_t(eMail));
		m_pRecordset->PutCollect("department",_variant_t(department));
		m_pRecordset->PutCollect("duty",_variant_t(duty));
		m_pRecordset->PutCollect("address",_variant_t(address));
		m_pRecordset->PutCollect("remark",_variant_t(remark));
		m_pRecordset->PutCollect("contractID",_variant_t(contractID));
		str.Format("%d",contractTerm);
		m_pRecordset->PutCollect("contractTerm",_variant_t(str));
		m_pRecordset->PutCollect("workType",_variant_t(workType));
		m_pRecordset->PutCollect("identityNO",_variant_t(identityNO));
		m_pRecordset->PutCollect("major",_variant_t(major));
		
		m_pRecordset->Update();
	}
}

void CStaff::sqlDelete(CString vStaffID)
{
	CString strSQL;
	strSQL="delete from staff where staffID='";
	strSQL=strSQL+vStaffID+"'";
	(((COfficeApp*)AfxGetApp())->m_pConn)->Execute((_bstr_t)strSQL,NULL,adCmdText);
}

void CStaff::GetData(CString vStaffID)
{
	CString strSQL;

	strSQL="select * from staff where staffID='";
	strSQL=strSQL+vStaffID+"'";
	_RecordsetPtr m_pRecordset;
	HRESULT hTRes;
	hTRes = m_pRecordset.CreateInstance(_T("ADODB.Recordset"));				
	hTRes = m_pRecordset->Open((LPTSTR)strSQL.GetBuffer(130),
			((COfficeApp*)AfxGetApp())->m_pConn.GetInterfacePtr(),
			adOpenDynamic,adLockPessimistic,adCmdText);
	if(SUCCEEDED(hTRes))
	{
		CString str;
	
		staffID= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffID"));
		staffName= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("staffName"));
		sex= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("sex"));
		birthday= m_pRecordset->GetCollect("birthday");
		nationality= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("nationality"));
		marriageCondition= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("marriageCondition"));
		educationLevel=((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("educationLevel"));
		graduateSchool= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("graduateSchool"));
		telephone= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("telephone"));
		postCode= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("postcode"));
		mobile= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("mobile"));
		QQ= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("QQ"));
		eMail= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("eMail"));
		department= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("department"));
		duty= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("duty"));
		address= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("address"));
		remark= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("remark"));
		contractID= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("contractID"));   //合同编号
		contractTerm= m_pRecordset->GetCollect("contractTerm").intVal; //合同期限
		workType= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("workType"));     //工种
		identityNO= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("identityNO"));   //身份证号
		major= ((COfficeApp*)AfxGetApp())->GetStringFromVariant(m_pRecordset->GetCollect("major"));        //专业
	}
}
💿 文件大小 4018 K
👤 上传用户 fq335288450
📂 所属分类企业管理
🏷️ 相关标签

#windows #管理系统 #修改 #操作
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -