employees.cpp

Access 在 VC++中的应用

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

#include "stdafx.h"
#include "Ex_ADO.h"
#include "Employees.h"
#include "ADOConn.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="";
	Title="";
	Wage=0;
	Dep_id=0;
}

CEmployees::~CEmployees()
{

}
void CEmployees::SetEmp_id(int vEmpId)
{
	Emp_id=vEmpId;
}
void CEmployees::SetEmp_name(CString vEmpName)
{
	Emp_name=vEmpName;
}
void CEmployees::SetSex(CString vSex)
{
	Sex=vSex;
}
void CEmployees::SetTitle(CString vTitle)
{
	Title=vTitle;
}
void CEmployees::SetWage(float vWage)
{
	Wage=vWage;
}
void CEmployees::SetDep_id(int vDepId)
{
	Dep_id=vDepId;
}
void CEmployees::sql_insert()
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strWage;
	strWage.Format("%f",Wage);
	_bstr_t vSQL;
	vSQL="SELECT * FROM Employees";
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	vSQL="INSERT INTO Employees (Emp_name,Sex,Title,Wage,Dep_id) VALUES('" + Emp_name + "','" + Sex + "','" + Title + "','" + strWage + ",1)";
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}
void CEmployees::sql_update(CString cEmpId)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strWage;
	strWage.Format("%f",Wage);
	_bstr_t vSQL;
	vSQL="UPDATE Employees SET Emp_name='" + Emp_name + "', Sex='" + Sex + "', Title='" + Title + "', Wage=" + strWage + " WHERE Emp_id=" + cEmpId;
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}
void CEmployees::sql_delete(CString cEmpId)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strWage;
	strWage.Format("%f",Wage);
	_bstr_t vSQL;
	vSQL="DELETE FROM Employees WHERE Emp_id=" + cEmpId;
	m_AdoConn.ExecuteSQL(vSQL);
	m_AdoConn.ExitConnect();
}
void CEmployees::GetData(CString cEmpId)
{
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	CString strWage;
	strWage.Format("%f",Wage);
	_bstr_t vSQL;
	vSQL="SELECT * FROM Employees WHERE Emp_id=" + cEmpId;
	_RecordsetPtr m_pRecordset;
	m_pRecordset=m_AdoConn.GetRecordSet(vSQL);
	if(m_pRecordset->adoEOF==1)
		CEmployees();
	else
	{
		Emp_id=atoi(cEmpId);
		Emp_name=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Emp_name");
		Sex=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sex");
		Title=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Title");
		Wage=atof((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Wage"));
		Dep_id=atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Dep_id"));
	}
	m_AdoConn.ExitConnect();
}