// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "ExMIS.h"
#include "LoginDlg.h"
#include "MyRecordSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLoginDlg dialog


CLoginDlg::CLoginDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLoginDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLoginDlg)
	m_strDataType = _T("");
	m_strPassword = _T("");
	m_strUsername = _T("");
	//}}AFX_DATA_INIT

	//初始權(quán)限為0
	m_nPower=0;
}


void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLoginDlg)
	DDX_CBString(pDX, IDC_COMBO_TYPE, m_strDataType);
	DDX_Text(pDX, IDC_EDIT_PASSWORD, m_strPassword);
	DDX_Text(pDX, IDC_EDIT_USERNAME, m_strUsername);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLoginDlg, CDialog)
	//{{AFX_MSG_MAP(CLoginDlg)
	ON_BN_CLICKED(IDC_BTN_LOGIN, OnBtnLogin)
	ON_WM_CLOSE()
	ON_BN_CLICKED(IDC_BTN_CANCEL, OnBtnCancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLoginDlg message handlers

void CLoginDlg::OnBtnLogin() 
{
	//檢查用戶名是否輸入
	UpdateData(true);
	if(m_strUsername.IsEmpty()||m_strPassword.IsEmpty()||m_strDataType.IsEmpty())
	{
		AfxMessageBox("請(qǐng)將資料填寫完整再登錄！");
		return;
	}

	m_pRS.ADOOpen(m_strDataType);
	m_strSQL="SELECT password,power FROM UserTab WHERE [username]='"+m_strUsername+"' ";
	m_pRS.ADOExcute(m_strSQL);

	if(m_pRS.nFieldRows==1)
	{
		if(m_pRS.GetFieldString(0)==m_strPassword)
		{
			m_nPower=m_pRS.GetFieldNumber(1);

			CDialog::OnOK();
		}else{
			AfxMessageBox("錯(cuò)誤的密碼！");
		}
	}else{
		AfxMessageBox("錯(cuò)誤的用戶名！");
	}
}

void CLoginDlg::OnClose() 
{	// 無權(quán)限返回
	m_nPower=0;
	CDialog::OnCancel();
}

void CLoginDlg::OnBtnCancel() 
{	// 無權(quán)限返回
	m_nPower=0;
	CDialog::OnCancel();
}