employees.cpp

C++应用编程20例,各种小程序原代码都有

// Employees.cpp: implementation of the CEmployees class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "Classsystem.h"
#include "Employees.h"
#include "ADOConn.h"
//#include "Family.h"
//#include "Experience.h"
//#include "Checkin.h"
//#include "Evaluation.h"
#include "Users.h"

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

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

CEmployees::CEmployees()
{
	Emp_Id = 0;
	Emp_Name = "";
	Sex = "";

	Birth = "";
	Id_Card = "";
	BadgeId = "";
	Dep_Id = 0;
	Position = "";
	Memo = "";

}

CEmployees::~CEmployees()
{

}
int CEmployees::GetEmp_Id()
{
	return Emp_Id;
}

void CEmployees::SetEmp_Id(int iEmp_Id)
{
	Emp_Id = iEmp_Id;
}

CString CEmployees::GetEmp_Name()
{
	return Emp_Name;
}

void CEmployees::SetEmp_Name(CString cEmp_Name)
{
	Emp_Name = cEmp_Name;
}

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

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


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

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


CString CEmployees::GetId_Card()
{
	return Id_Card;
}

void CEmployees::SetId_Card(CString cCard)
{
	Id_Card = cCard;
}

CString CEmployees::GetBadgeId()
{
	return BadgeId;
}

void CEmployees::SetBadgeId(CString cBadgeId)
{
	BadgeId = cBadgeId;
}


int CEmployees::GetDep_Id()
{
	return Dep_Id;
}

void CEmployees::SetDep_Id(int iDep_Id)
{
	Dep_Id = iDep_Id;
}

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

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

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

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


int CEmployees::HaveName(CString cEmp_Name)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM xs WHERE 姓名='" + cEmp_Name + "'";
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

CString CEmployees::GetName(CString cEmp_id)
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT 姓名 FROM xs WHERE 学号=" + cEmp_id;
	
	//执行SELECT语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return "";
	else
		return (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Emp_Name");

	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CEmployees::sql_insert()
{	
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置INSERT语句
	CString strDep_Id;
	strDep_Id.Format("%d", Dep_Id);
	CString strUpperId;


	_bstr_t vSQL;
	vSQL = "INSERT INTO xs (姓名, 性别, 出生时间,总学分, 学号,专业名,备注) VALUES('";
	vSQL = vSQL + Emp_Name + "','" + Sex + "','" + Birth + "','" + Id_Card + "','"; 
	vSQL = vSQL + BadgeId + "','"+ Position+  "','" + Memo + "')";
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

void CEmployees::sql_update(CString cEmp_Id)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();

	_bstr_t vSQL;
	vSQL = "UPDATE xs SET 姓名='" + Emp_Name + "', 性别='" + Sex;
	vSQL = vSQL + "', 出生时间='" + Birth;
	vSQL = vSQL + "', 总学分='" + Id_Card;
	vSQL = vSQL + "', 学号='" + BadgeId ;
	vSQL = vSQL + "', 专业名='"+ Position; 
	vSQL = vSQL +"', 备注='"+ Memo+"'";
	vSQL = vSQL +"where 学号='"+BadgeId+"'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}


void CEmployees::sql_delete(CString cEmp_Id)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM xs WHERE 学号='" + cEmp_Id+"'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
	//删除表Family中的相关员工记录
	//CFamily fam;
	//fam.sql_deleteByEmp(cEmp_Id);
	//删除表Experience中的相关员工记录
	//CExperience exp;
//	exp.sql_deleteByEmp(cEmp_Id);
	//删除表Checkin中的相关员工记录
//	CCheckin check;
//	check.sql_deleteByEmp(cEmp_Id);
	//删除表Evaluation中的相关员工记录
//	CEvaluation eva;
//	eva.sql_deleteByEmp(cEmp_Id);
}

//根据员工编号读取所有字段值
void CEmployees::GetData(CString cEmp_Id)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM xs WHERE 学号='" + cEmp_Id+"'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CEmployees();
	else
	{
	//	Emp_Id = atoi(学号);
		Emp_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("姓名");
		Sex = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("性别");
		Birth = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("出生时间");
		Id_Card = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("总学分");
		BadgeId = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("学号");
		//Dep_Id = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Dep_Id"));
		Position = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("专业名");
		Memo = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("备注");
		
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}