// User.cpp: implementation of the CUser class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "學(xué)生選課系統(tǒng).h"
#include "User.h"
#include "ADOConn.h"

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

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

CUser::CUser()
{
	UserName = "";
	Pwd = "";
	User_type = 0;

}

CUser::~CUser()
{

}



CString CUser::GetUserName()
{
	return UserName;
}

void CUser::SetUserName(CString cUserName)
{
	UserName = cUserName;
}

CString CUser::GetPwd()
{
	return Pwd;
}

void CUser::SetPwd(CString cPwd)
{
	Pwd = cPwd;
}

int CUser::GetUser_type()
{
	return User_type;
}

void CUser::SetUser_type(int iUser_type)
{
	User_type = iUser_type;
}

//數(shù)據(jù)庫(kù)操作
int CUser::HaveName(CString cUserName)
{	
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置SELECT語(yǔ)句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM users WHERE UserName='" + cUserName + "'";
	
	//執(zhí)行SELECT語(yǔ)句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;

	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}

	
void CUser::sql_insert()
{	
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置INSERT語(yǔ)句
	CString strType;
	strType.Format("%d", User_type);

	_bstr_t vSQL;
	vSQL = "INSERT INTO users VALUES('" + UserName + "','" + Pwd + "'," 
		+ strType + ")";	
	//執(zhí)行INSERT語(yǔ)句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}

void CUser::sql_updatePwd(CString cUserName)
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置UPDATE語(yǔ)句
	CString strType;
	strType.Format("%d", User_type);

	_bstr_t vSQL;
	vSQL = "UPDATE users SET password='" + Pwd + "' WHERE UserName='" + cUserName + "'";
	//執(zhí)行UPDATE語(yǔ)句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}

void CUser::sql_delete(CString cUserName)
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置DELETE語(yǔ)句
	_bstr_t vSQL;
	vSQL = "DELETE FROM users WHERE UserName='" + cUserName	+ "'";
	//執(zhí)行DELETE語(yǔ)句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}

//根據(jù)員工編號(hào)讀取所有字段值
void CUser::GetData(CString cUserName)
{
	//連接數(shù)據(jù)庫(kù)
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設(shè)置SELECT語(yǔ)句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM users WHERE UserName='" + cUserName + "'";
	//執(zhí)行SELETE語(yǔ)句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		//CUser();
		return;
	else
	{
		//UserName = cUserName;
		UserName=(LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UserName");
		Pwd = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("password");
		User_type = atoi((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("User_type"));
	}
	//斷開(kāi)與數(shù)據(jù)庫(kù)的連接
	m_AdoConn.ExitConnect();
}