train_rec.cpp

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

// Train_Rec.cpp: implementation of the CTrain_Rec class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CTrain_Rec::CTrain_Rec()
{
	Stu_id = 0;            
	Train_Way = " ";     
	Sta_Time = " ";       
	End_Time = " ";       
	Train_Date = " ";     
	Study_Major = " ";    
	Train_Post = " ";     
	Train_Text = " ";    
	Train_Money = " ";    
	Train_Result = " ";  
	xuehao = "" ;

}

CTrain_Rec::~CTrain_Rec()
{

}

int CTrain_Rec::GetStu_id()
{
	return Stu_id;
}
void CTrain_Rec::SetStu_id(int iStu_id)
{
	Stu_id = iStu_id;
}

CString CTrain_Rec::GetTrain_Way()
{
	return Train_Way;
}
void CTrain_Rec::SetTrain_Way(CString cTrain_Way)
{
	Train_Way = cTrain_Way;
}

CString CTrain_Rec::GetSta_Time()
{
	return Sta_Time;
}
void CTrain_Rec::SetSta_Time(CString cSta_Time)
{
	Sta_Time = cSta_Time;
}

CString CTrain_Rec::GetEnd_Time()
{
	return End_Time;
}
void CTrain_Rec::SetEnd_Time(CString cEnd_Time)
{
	End_Time = cEnd_Time;
}

CString CTrain_Rec::GetTrain_Date()
{
	return Train_Date;
}
void CTrain_Rec::SetTrain_Date(CString cTrain_Date)
{
	Train_Date = cTrain_Date;
}

CString CTrain_Rec::GetStudy_Major()
{
	return Study_Major;
}
void CTrain_Rec::SetStudy_Major(CString cStudy_Major)
{
	Study_Major = cStudy_Major;
}

CString CTrain_Rec::GetTrain_Post()
{
	return Train_Post;
}
void CTrain_Rec::SetTrain_Post(CString cTrain_Post)
{
	Train_Post = cTrain_Post;
}

CString CTrain_Rec::GetTrain_Text()
{
	return Train_Text;
}
void CTrain_Rec::SetTrain_Text(CString cTrain_Text)
{
	Train_Text = cTrain_Text;
}

CString CTrain_Rec::GetTrain_Money()
{
	return Train_Money;
}
void CTrain_Rec::SetTrain_Money(CString cTrain_Money)
{
	Train_Money = cTrain_Money;
}

CString CTrain_Rec::GetTrain_Result()
{
	return Train_Result;
}
void CTrain_Rec::SetTrain_Result(CString cTrain_Result)
{
	Train_Result = cTrain_Result;
}
CString CTrain_Rec::getXuehao()
{
	return xuehao ;
}
void CTrain_Rec::setXuehao(CString cXuehao)
{
	xuehao = cXuehao;
}

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


}

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


	_bstr_t vSQL;
	vSQL = "INSERT INTO Train_Rec VALUES(" + cStuid + ",'"+Train_Way+"','"+Sta_Time +"','"+End_Time+"','"+Train_Date+"','"+Study_Major+"','"+Train_Post+"','"+Train_Text+"','"+Train_Money+"','"+Train_Result+"','"+xuehao+"' )";
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();
}

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

	_bstr_t vSQL;
	vSQL = "UPDATE Train_Rec SET Train_Way ='"+Train_Way+"',Sta_Time ='"+Sta_Time +"',End_Time='"+End_Time+"',Train_Date='"+Train_Date+"',Study_Major='"+Study_Major+"',Train_Post='"+Train_Post+"',Train_Text='"+Train_Text+"',Train_Money='"+Train_Money+"',Train_Result='"+Train_Result+"' WHERE xuehao ='" + cEmpId + "' and Train_Post='"+Train_Post+"'";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();


}

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CTrain_Rec();
	else
	{
		Stu_id = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_id "));
		Train_Way = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Train_Way ");
        Sta_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Sta_Time ");
		End_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("End_Time ");
		Train_Date = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Train_Date");
		Study_Major = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Study_Major ");
        Train_Post = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Train_Post"));
		Train_Text = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Train_Text "));
		Train_Money = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Train_Money "));
		Train_Result = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Train_Result "));
		xuehao = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("xuehao ");

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


}