rew_rec.cpp

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

// Rew_Rec.cpp: implementation of the CRew_Rec class.
//
//////////////////////////////////////////////////////////////////////

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

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

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

CRew_Rec::CRew_Rec()
{
	Stu_id=0;
	Rew_Type = "";
	Rew_Time = "";
	Rew_Reason = "";
	App_Uni = "";
	Lift_Time = "";
	Lift_Res = "";
	xuehao = "";
}

CRew_Rec::~CRew_Rec()
{

}

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

CString CRew_Rec::getRew_Type()
{
	return Rew_Type;
}
void CRew_Rec::setRew_Type(CString vRew_Type)
{
	Rew_Type = vRew_Type;
}
CString CRew_Rec::getRew_Time()
{
	return Rew_Time;
}
void CRew_Rec::setRew_Time(CString vRew_Time)
{
	Rew_Time = vRew_Time;
}

CString CRew_Rec::GetRew_Reason()
{
	return Rew_Reason;
}
void CRew_Rec::SetRew_Reason(CString cRew_Reason)
{
	Rew_Reason = cRew_Reason;
}

CString CRew_Rec::getApp_Uni()
{
	return App_Uni;
}
void CRew_Rec::setApp_Uni(CString vApp_Uni)
{
	App_Uni = vApp_Uni;
}
CString CRew_Rec::getLift_Time()
{
	return Lift_Time;
}
void CRew_Rec::setLift_Time(CString vLift_Time)
{
	Lift_Time = vLift_Time;
}
CString CRew_Rec::getLift_Res()
{
	return Lift_Res;
}
void CRew_Rec::setLift_Res(CString vLift_Res)
{
	Lift_Res = vLift_Res;
}
CString CRew_Rec::getXuehao()
{
	return xuehao ;
}
void CRew_Rec::setXuehao(CString cXuehao)
{
	xuehao = cXuehao;
}

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

}

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

	_bstr_t vSQL;
	vSQL = "INSERT INTO Rew_Rec VALUES("+cStu_id+",'" + Rew_Type + "','" + Rew_Time + "','"+Rew_Reason+"','" 
		+ App_Uni + "','"+Lift_Time+"','"+Lift_Res+"','"+xuehao+"')";	
	//执行INSERT语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

void CRew_Rec::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 Rew_Rec SET Rew_Type='"+Rew_Type+"',Rew_Time='"+Rew_Time+"',Rew_Reason = '"+Rew_Reason+"',App_Uni='"+App_Uni+"',Lift_Time='"+Lift_Time+"',Lift_Res='"+Lift_Res+"' WHERE xuehao ='" + cEmpId + "' and Rew_Type='"+Rew_Type+"' ";
	//执行UPDATE语句
	m_AdoConn.ExecuteSQL(vSQL);	
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}

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

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CRew_Rec();
	else
	{
		Stu_id = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Stu_id"));
        Rew_Type = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Rew_Type");
		Rew_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Rew_Time");
		Rew_Reason = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Rew_Reason");
		App_Uni = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("App_Uni");
		Lift_Time = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Lift_Time");
        Lift_Res = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Lift_Res");
		xuehao = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("xuehao");
        
	}
	//断开与数据库的连接
	m_AdoConn.ExitConnect();

}