// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Personnel.h"
#include "LoginDlg.h"
#include "crypt.h"

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

extern CDatabase db;
/////////////////////////////////////////////////////////////////////////////
// CLoginDlg dialog


CLoginDlg::CLoginDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLoginDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLoginDlg)
	m_strDSN = _T("MISDB");
	m_strUser = _T("");
	m_strPasswd = _T("");
	//}}AFX_DATA_INIT
}


void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLoginDlg)
	DDX_Control(pDX, IDC_COBBOX1, m_cbSD);
	DDX_CBString(pDX, IDC_CMD_DSN, m_strDSN);
	DDX_Text(pDX, IDC_EDT_USER, m_strUser);
	DDX_Text(pDX, IDC_EDT_PASSWD, m_strPasswd);
	//}}AFX_DATA_MAP
}


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

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

BOOL CLoginDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	// 改變"登錄人事管理系統(tǒng)"字體大小
	LOGFONT LogFont;
	GetFont()->GetLogFont(&LogFont);
	LogFont.lfHeight+=LogFont.lfHeight/2;
	LogFont.lfWidth+=LogFont.lfWidth/2;
	m_font.CreateFontIndirect(&LogFont);
	GetDlgItem(IDC_STATIC_LOGINTEXT)->SetFont(&m_font);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CLoginDlg::OnOK() 
{
	BOOL bLogin=FALSE;
	CString strPasswd, strAuthority;

	UpdateData(); // 更新數(shù)據(jù)變量
	if(!db.Open(m_strDSN)) return; // 連接數(shù)據(jù)庫(kù)
	CRecordset rs(&db);
	rs.Open(CRecordset::forwardOnly,
		"select PASSWD, AUTHORITY from PERSON where ID='"+m_strUser+"'");
	if(!rs.IsEOF())
	{
		rs.GetFieldValue("PASSWD", strPasswd);
		rs.GetFieldValue("AUTHORITY", strAuthority);
		if(strPasswd == CCrypt::Encrypt(m_strPasswd, 123) &&
		   strAuthority == "3")
		{
			bLogin=TRUE; // 已連接
		}
		else
			MessageBox("請(qǐng)重新輸入密碼。\n注意大小寫(xiě)!","密碼錯(cuò)誤");
	}
	else
	{
		MessageBox("請(qǐng)確認(rèn)用戶名大小寫(xiě)是否正確!","無(wú)此用戶");
	}
	rs.Close();
	if(bLogin) EndDialog(IDOK);
	else db.Close(); // 關(guān)閉數(shù)據(jù)庫(kù)
}