【VC开源代码栏目提醒】:文章导读:在新的一年中,各位网友都进入紧张的学习或是工作阶段。网学会员整理了VC开源代码-Employees.cpp的相关内容供大家参考,祝大家在新的一年里工作和学习顺利!
// Employees.cpp: implementation of the CEmployees class.
//
//////////////////////////////////////////////////////////////////////
#include "stdafx.h"
#include "HrSys.h"
#include "Employees.h"
#include "ADOConn.h"
#include "Salary.h"
#include "Users.h"
#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
//////////////////////////////////////////////////////////////////////
// Construction/Destruction
//////////////////////////////////////////////////////////////////////
CEmployees::CEmployees()
{
}
CEmployees::~CEmployees()
{
EmpId = 0;
EmpName = "";
Sex = "";
Nationality = "";
Birth = "";
Political_Party = "";
Culture_Level = "";
Marital_Condition = "";
Family_Place = "";
Id_Card = "";
BadgeId = "";
Office_phone = "";
Mobile = "";
Files_Keep_Org = "";
Hukou = "";
HireDate = "";
DepId = 0;
Position = "";
sTitle = "";
State = 0;
UpperId = 0;
Salary=0;
Memo = "";
Fillin_Person = "";
Fillin_Time = "";
}
//读取指定员工
CString CEmployees::GetName(CString cEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置SELECT语句
_bstr_t vSQL;
vSQL = "SELECT EmpName FROM Employees WHERE EmpId=" + cEmpId;
//执行SELECT语句
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
if (m_pRecordset->adoEOF)
return "";
else
return (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("EmpName");
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
//插入数据库
void CEmployees::sql_insert()
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置INSERT语句
CString strDepId;
strDepId.Format("%d", DepId);
CString strState;
strState.Format("%d", State);
CString strUpperId;
strUpperId.Format("%d", UpperId);
_bstr_t vSQL;
vSQL = "INSERT INTO Employees(EmpName,Sex,Nationality,Birth,"
"Political_Party,Culture_Level,Marital_Condition,Family_Place,"
"Id_Card,BadgeID,Office_phone,Mobile,Files_Keep_Org,HuKou,"
"HireDate,DepId,Position1,Title,State,UpperId,Salary,"
"Memo1,Fillin_Person,Fillin_Time) VALUES('"
+ EmpName + "','" + Sex + "','" + Nationality + "','" + Birth + "','"
+ Political_Party + "','" + Culture_Level + "','" + Marital_Condition
+ "','" + Family_Place + "','" + Id_Card + "','" + BadgeId + "','"
+ Office_phone + "','" + Mobile + "','" + Files_Keep_Org + "','"
+ Hukou + "','" + HireDate + "'," + strDepId + ",'" + Position
+ "','" + sTitle + "'," + strState + "," + strUpperId + ",0,'"
+ Memo + "','" + Fillin_Person + "','"
+ Fillin_Time + "')";
//执行INSERT语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
void CEmployees::sql_update(CString cEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置UPDATE语句
CString strState;
strState.Format("%d", State);
CString strUpperId;
strUpperId.Format("%d", UpperId);
_bstr_t vSQL;
vSQL = "UPDATE Employees SET EmpName='" + EmpName + "', 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 + "', Position1='"
+ Position + "', Title='" + sTitle + "', State=" + strState + ", UpperId="
+ strUpperId + ", Memo1='"
+ Memo + "', Fillin_Person='" + Fillin_Person + "', Fillin_Time='"
+ Fillin_Time + "' WHERE EmpId=" + cEmpId;
//执行UPDATE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
//更改员工部门编号
void CEmployees::sql_updateDep(CString cEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置UPDATE语句
CString strDepId;
strDepId.Format("%d", DepId);
_bstr_t vSQL;
vSQL = "UPDATE Employees SET DepId=" + strDepId + ", Title='"
+ sTitle + "' WHERE EmpId=" + cEmpId;
//执行UPDATE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
//更改员工工资
void CEmployees::sql_updateSalary(CString cEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置UPDATE语句
CString strSalary;
strSalary.Format("%d", Salary);
_bstr_t vSQL;
vSQL = "UPDATE Employees SET Salary=" + strSalary + " WHERE EmpId=" + cEmpId;
//执行UPDATE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
}
//删除指定员工信息
void CEmployees::sql_delete(CString cEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置DELETE语句
_bstr_t vSQL;
vSQL = "DELETE FROM Employees WHERE EmpId=" + cEmpId;
//执行DELETE语句
m_AdoConn.ExecuteSQL(vSQL);
//断开与数据库的连接
m_AdoConn.ExitConnect();
//删除表Salary中的相关员工记录
CSalary sal;
sal.sql_deleteByEmp(cEmpId);
}
//根据员工编号读取所有字段值
void CEmployees::GetData(CString cEmpId)
{
//连接数据库
ADOConn m_AdoConn;
m_AdoConn.OnInitADOConn();
//设置SELECT语句
_bstr_t vSQL;
vSQL = "SELECT * FROM Employees WHERE EmpId=" + cEmpId;
//执行SELETE语句
_RecordsetPtr m_pRecordset;
m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
//返回各列的值
if (m_pRecordset->adoEOF)
CEmployees();
else
{
EmpId = atol(cEmpId);
EmpName = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("EmpName");
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");
DepId = atol((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("DepId"));
Position = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Position1");
sTitle = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Title");
State = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetColl
上一篇:
EmployeeInfoView.cpp
下一篇:
应用数学学报编辑部联系方式