#include "stdafx.h"
#include "cc.h"
#include "LogonDlg.h"
#include"ccdlg.h"

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

/////////////////////////////////////////////////////////////////////////////

extern CCcApp theApp;

CLogonDlg::CLogonDlg(CWnd* pParent /*=NULL*/): CDialog(CLogonDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLogonDlg)
	m_strPass = _T("");
	m_strAdmin = _T("");
	//}}AFX_DATA_INIT
}


void CLogonDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLogonDlg)
	DDX_Text(pDX, IDC_EDIT1, m_strPass);
	DDX_Text(pDX, IDC_ADMIN_NAME, m_strAdmin);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLogonDlg, CDialog)
//{{AFX_MSG_MAP(CLogonDlg)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////

void CLogonDlg::OnOK() 
{
	UpdateData();	
	if(m_strAdmin.IsEmpty() || m_strPass.IsEmpty())  
	{
		AfxMessageBox("請輸入用戶名和密碼！");
	}
	else
	{
		CString sql="SELECT * FROM Admin where AdminName='"+theApp.g_Admin+"' and pwd='"+m_strPass+"'";
		try
		{			
			m_pRecordset.CreateInstance("ADODB.Recordset");  	//查詢數據庫，看是否有此用戶和密碼
			m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
			
			if(m_pRecordset->adoEOF)	 //如果沒有此用戶和密碼
			{
				MessageBox("請輸入正確的用戶名和密碼!","錯誤",MB_ICONEXCLAMATION);
				SetDlgItemText(IDC_EDIT1,"");
				GetDlgItem(IDC_EDIT1)->SetFocus();
			}
			else
			{
				theApp.g_Admin=m_strAdmin;
				theApp.g_Pass=m_strPass;
				CDialog::OnOK();
			}
		}
		catch (_com_error e)								
		{													
			CATCH_ERROR;
			return;
		}
	}	
	
}

void CLogonDlg::OnCancel() 
{

	((CCcDlg*)AfxGetMainWnd())->EndDialog(IDOK);
	
	CDialog::OnCancel();
}

BOOL CLogonDlg::OnInitDialog()   //讀出用戶名顯示
{
	CDialog::OnInitDialog();
	try
	{
		m_pRecordset.CreateInstance("ADODB.Recordset");
		m_pRecordset->Open((_variant_t)"SELECT * FROM Admin",_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
	
		if(!m_pRecordset->adoEOF)
		{
			theApp.g_Admin=((LPCTSTR)(_bstr_t)m_pRecordset->GetCollect("AdminName"));
			SetDlgItemText(IDC_ADMIN_NAME,theApp.g_Admin);
		}	
		m_pRecordset->Close();
	}

	catch (_com_error e)								
	{	
		CATCH_ERROR;		
		return false;
	}
	return TRUE;  
}