// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "XieyuyingDB.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("rsgl");
	m_strUser = _T("abc");
	m_strPasswd = _T("");
	//}}AFX_DATA_INIT
	m_hIcon = AfxGetApp()->LoadIcon(IDI_ICON2);
}


void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLoginDlg)
	DDX_Control(pDX, IDOK, m_a);
	DDX_Control(pDX, IDCANCEL, m_b);
	DDX_CBString(pDX, IDC_CMB_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)
	ON_WM_CTLCOLOR()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

BOOL CLoginDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// 改變"登錄人事管理系統"字體大小
	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);

	// 如數據庫為打開狀態，則關閉
	if(db.IsOpen()) db.Close();
    m_brush.CreateSolidBrush(RGB(0,150,200));
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	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,strCount;

	UpdateData(); // 更新數據變量
	if(!db.Open(m_strDSN)) return; // 連接數據庫
//	strPasswd=CCrypt::Encrypt(m_strPasswd, 123); // 加密密碼
    CString strsql;
	CRecordset rs(&db); // 構造記錄集
	
	strsql=	"select COUNT(ID) as COUNT from PERSON where ID='" + m_strUser
		+"'  and AUTHORITY='4'"; // 執行查詢
    rs.Open(CRecordset::forwardOnly,strsql);
	rs.GetFieldValue("COUNT",strCount);
	rs.Close(); // 關閉數據集
	if(strCount=="1") // 判斷認證是否通過
	{
		EndDialog(IDOK); // 結束對話框，返回IDOK
	}
	else
	{
		MessageBox("請確認用戶名和密碼,注意大小寫!","認證失敗");
		db.Close(); // 關閉數據庫
	}
}

//rs.Open(CRecordset::forwardOnly,
//		"select COUNT(ID) as COUNT from PERSON where ID='" + m_strUser
//		+"' and PASSWD='" + strPasswd + "' and AUTHORITY='4'"); // 執行查詢


HBRUSH CLoginDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
		HBRUSH hbr = (HBRUSH)m_brush;
   
	if(nCtlColor==CTLCOLOR_STATIC)
	{   pDC->SetBkMode(TRANSPARENT);
		return hbr;
	}
	if(nCtlColor==CTLCOLOR_EDIT)
	{  
		return NULL;
	}

	return hbr;
}

LRESULT CLoginDlg::WindowProc(UINT message, WPARAM wParam, LPARAM lParam) 
{
	// TODO: Add your specialized code here and/or call the base class
	  switch(message)
 	{
 	case WM_CTLCOLOREDIT:
    SetTextColor((HDC)wParam, RGB(255,51,0));//0x003099
     SetBkColor((HDC)wParam, RGB(0,0,0));//0x000000
     return (LONG)GetStockObject(BLACK_BRUSH);
     break;
 	}
	return CDialog::WindowProc(message, wParam, lParam);
}