department.cpp

毕业生信息管理系统的基本功能是对毕业生的信息进行管理

// Department.cpp: implementation of the CDepartment class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "BySys.h"
#include "Department.h"
#include "ADOConn.h"

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

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

CDepartment::CDepartment()
{
	Stu_id=0;
	Sch_Name="";
	Yard_Name="";
	Dep_Name="";
	Sep_Name="";
	Stu_Name = "";
}

CDepartment::~CDepartment()
{

}

int CDepartment::GetStu_id()
{
	return Stu_id;
}

void CDepartment::SetStu_id(int vStuId)
{
	Stu_id=vStuId;
}

CString CDepartment::GetSch_Name()
{
	return Sch_Name;
}

void CDepartment::SetSch_Name(CString cSch_Name)
{
	Sch_Name=cSch_Name;
}

CString CDepartment::GetYard_Name()
{
	return Yard_Name;
}

void CDepartment::SetYard_Name(CString vYardName)
{
	Yard_Name=vYardName;
}

CString CDepartment::GetDep_Name()
{
	return Dep_Name;
}

void CDepartment::SetDep_Name(CString vDepName)
{
	Dep_Name=vDepName;
}

CString CDepartment::GetSep_Name()
{
	return Sep_Name;
}
void CDepartment::SetSep_Name(CString vSepName)
{
	Sep_Name = vSepName;
}

CString CDepartment::GetStu_Name()
{
	return Stu_Name;
}

void CDepartment::SetStu_Name(CString cStu_Name)
{
	Stu_Name = cStu_Name;
}

void CDepartment::sql_delete(CString cEmpId)
{
		//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置DELETE语句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Department WHERE Stu_id='" + cEmpId	+ "'";
	//执行DELETE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

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

	_bstr_t vSQL;
	vSQL = "INSERT INTO Department VALUES("+cStu_id+",'" + Sch_Name + "','" + Yard_Name + "','" 
		+ Dep_Name + "','"+Sep_Name+"','"+Stu_Name+"')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

void CDepartment::sql_update(CString cEmpId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置UPDATE语句
	CString cStu_id;
	cStu_id.Format("%d", Stu_id);

	_bstr_t vSQL;
	vSQL = "UPDATE Department SET Stu_id="+cStu_id+",Sch_Name='" + Sch_Name + "',Yard_Name='"+Yard_Name+"',Dep_Name='"+Dep_Name+"',Sep_Name='"+Sep_Name+"',Stu_Name = '"+Stu_Name+"' WHERE Sch_id='" + cEmpId + "'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

void CDepartment::GetData(CString cEmpId)
{
	//连接数据库
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//设置SELECT语句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Department WHERE Stu_id='" + cEmpId + "'";
	//执行SELETE语句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CDepartment();
	else
	{
		Stu_id = atoi(cEmpId);
		Sch_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sch_Name");
        Yard_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Yard_Name");
		Dep_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Dep_Name");
		Sep_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sep_Name");
		Stu_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_Name");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}