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

#include "stdafx.h"
#include "BySys.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 vUserName)
{
   UserName=vUserName;
}
CString CUser::GetPwd()
{
   return Pwd;
}
void CUser::SetPwd(CString vPwd)
{
  Pwd=vPwd;
}
int CUser::GetUser_type()
{
  return User_type;
}
void CUser::SetUser_type(int vUsertype)
{
    User_type=vUsertype;
}

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

	_bstr_t vSQL;
	vSQL = "INSERT INTO Users VALUES('" + UserName + "','" + Pwd + "'," 
		+ strType + ")";	
	//執行INSERT語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CUser::sql_delete(CString cUserName)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置DELETE語句
	_bstr_t vSQL;
	vSQL = "DELETE FROM Users WHERE UserName='" + cUserName	+ "'";
	//執行DELETE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();

}

void CUser::sql_update(CString cUserName)
{

	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置UPDATE語句
	CString strType;
	strType.Format("%d", User_type);

	_bstr_t vSQL;
	vSQL = "UPDATE Users SET Pwd='" + Pwd + "',User_Type ='"+strType+"' WHERE UserName='" + cUserName + "'";
	//執行UPDATE語句
	m_AdoConn.ExecuteSQL(vSQL);	
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

void CUser::GetData(CString cUserName)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Users WHERE UserName='" + cUserName + "'";
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

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