// UersData.cpp: implementation of the UersData class.
//
//////////////////////////////////////////////////////////////////////

#include "stdafx.h"
#include "UserData.h"

#ifdef _DEBUG
#undef THIS_FILE
static char THIS_FILE[]=__FILE__;
#define new DEBUG_NEW
#endif
//導入ADO類型庫
#import "c:\Program Files\Common Files\System\ADO\msado15.dll" no_namespace rename("EOF", "ENDOFFILE")

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

CUserData::CUserData()
{

}

CUserData::~CUserData()
{

}

BOOL CUserData::GetPassword(CString *UserName, CString *Password,int *Level)
{
  	//初始化Com對象
	CoInitialize(NULL);

	try
	{
		//初始化數據庫連接對象
		_ConnectionPtr pConn("ADODB.Connection");
		
        //定義數據庫連接字符串     
	    _bstr_t Connection ="Provider=Microsoft.Jet.OLEDB.4.0;Data Source=.\\HotelManageSys.mdb;Persist Security Info=False";
		//打開數據庫連接
		pConn->Open(Connection, "", "", adConnectUnspecified);
		
		//初始化記錄集對象
		_RecordsetPtr pRs("ADODB.Recordset");

		CString strSQL;
		strSQL.Format("%s\"%s\"", "Select * From UserInformation Where Name like ", UserName->GetBuffer(UserName->GetLength()));
		//打開指定記錄集
		pRs->Open(_variant_t(strSQL.GetBuffer(strSQL.GetLength())), 
			      _variant_t(pConn, true), 
				  adOpenStatic, 
				  adLockOptimistic, 
				  adCmdText);

		//訪問記錄集中數據
		if (pRs->BOF)
		{
			//關閉記錄集
			pRs->Close();
			pRs.Release();
			//關閉數據庫連接
			pConn->Close();
			pConn.Release();
		    UserName->ReleaseBuffer();
			Password->ReleaseBuffer();
			return FALSE;
		}
		else
		{
			strcpy(Password->GetBuffer(255), _bstr_t(pRs->GetCollect("Pwd")));

			*Level = pRs->GetCollect("Level").lVal;

			pRs->Close();
			pRs.Release();
			//關閉數據庫連接
			pConn->Close();
			pConn.Release();
			UserName->ReleaseBuffer();
			Password->ReleaseBuffer();
			return TRUE;
		}

	}
	catch(_com_error &e)
	{
		::CoUninitialize();
		::AfxMessageBox(e.ErrorMessage());
		return FALSE;
	}
}