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

#include "stdafx.h"
#include "medicine.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()
{

}

CUser::~CUser()
{

}

//數據庫操作
int CUser::HaveLoginName(CString cLoginName)
{	
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL="select * from Users where WorkNo='" + cLoginName + "'";
	
	//執行SELECT語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);
	if (m_pRecordset->adoEOF)
		return -1;
	else
		return 1;

	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}

//根據員工編號讀取所有字段值
void CUser::GetData(CString cLoginName)
{
	//連接數據庫
	ADOConn m_AdoConn;
	m_AdoConn.OnInitADOConn();
	//設置SELECT語句
	_bstr_t vSQL;
	vSQL = "SELECT * FROM Users WHERE WorkNo='" + cLoginName + "'";
	//執行SELETE語句
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_AdoConn.GetRecordSet(vSQL);

	//返回各列的值
	if (m_pRecordset->adoEOF)
		CUser();
	else
	{
		WorkNo = cLoginName;
		LoginPwd = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("LoginPwd");
		Authority = (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Authority");
		UserName= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UserName");
		UserId= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("UserId");
		Pos= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Pos");
		Other= (LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("Other");
	}
	//斷開與數據庫的連接
	m_AdoConn.ExitConnect();
}


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

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