work_exp.cpp

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

// Work_Exp.cpp: implementation of the CWork_Exp class.
//
//////////////////////////////////////////////////////////////////////

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

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

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


CWork_Exp::CWork_Exp()
{
	Stu_id=0;
	Sta_Time = "";
	End_Time = "";
	Work_Place = "";
	Sec_Name = "";
	Post = "";
	Level = 0;
}

CWork_Exp::~CWork_Exp()
{

}

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

void CWork_Exp::SetStu_id(int iStu_id)
{
	Stu_id=iStu_id;
}

CString CWork_Exp::getSta_Time()
{
	return Sta_Time;
}

void CWork_Exp::setSta_Time(CString vSta_Time)
{
	Sta_Time = vSta_Time;
}

CString CWork_Exp::getEnd_Time()
{
	return End_Time;
}

void CWork_Exp::setEnd_Time(CString vEnd_Time)
{
	End_Time = vEnd_Time;
}

CString CWork_Exp::getWork_Place()
{
	return Work_Place;
}
void CWork_Exp::setWork_Place(CString vWork_Place)
{
	Work_Place = vWork_Place;
}

CString CWork_Exp::getSec_Name()
{
	return Sec_Name;
}
void CWork_Exp::setSec_Name(CString vSec_Name)
{
	Sec_Name = vSec_Name;
}

CString CWork_Exp::getPost()
{
	return Post;
}

void CWork_Exp::setPost(CString vPost)
{
	Post = vPost;
}

int CWork_Exp::getLevel()
{
	return Level;
}

void CWork_Exp::setLevel(int vLevel)
{
	Level = vLevel;
}
CString CWork_Exp::getXuehao()
{
	return xuehao ;
}
void CWork_Exp::setXuehao(CString cXuehao)
{
	xuehao = cXuehao;
}

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

}

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

	_bstr_t vSQL;
	vSQL = "INSERT INTO Work_Exp VALUES("+cStu_id+",'" + Sta_Time + "','" + End_Time + "','" 
		+ Work_Place + "','"+Sec_Name+"','"+Post+"',"+strLevel+",'"+xuehao+"')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

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

	_bstr_t vSQL;
	vSQL = "UPDATE Work_Exp SET Sta_Time='" + Sta_Time + "',End_Time='"+End_Time+"',Work_Place='"+Work_Place+"',Sec_Name='"+Sec_Name+"',Post='"+Post+"',Levels="+strLevel+" WHERE xuehao ='" + cEmpId + "' and Work_Place='"+Work_Place+"'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CWork_Exp();
	else
	{
		Stu_id = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_id"));
		Sta_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sta_Time");
        End_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("End_Time");
		Work_Place = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Work_Place");
		Sec_Name = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sec_Name");
		Post = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Post");
        Level = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Levels"));
		xuehao = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("xuehao");
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}