logindlg.cpp

最后的成品vc考勤ACCSEE数据库做的 还有文档 希望大家多多指点[e-mail]

// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "StudentScore.h"
#include "LoginDlg.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)
	//}}AFX_DATA_INIT
    m_brush.CreateSolidBrush(RGB(0,0,255));
	m_font.CreatePointFont(200,"华文行楷");
}


void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLoginDlg)
	DDX_Control(pDX, IDCANCEL, m_btn1);
	DDX_Control(pDX, IDOK, m_btn);
	DDX_Control(pDX, IDC_USERNAME, m_strUserName);
	DDX_Control(pDX, IDC_PASSWORD, m_strPassword);
	//}}AFX_DATA_MAP
}


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

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


void CLoginDlg::OnOK() 
{
	// TODO: Add extra validation here
	CString username,password;
	m_strUserName.GetWindowText(username);
	m_strPassword.GetWindowText(password);
	if(!m_database.IsOpen())
	{
		if(m_database.Open(_T("studentscore")))
		{
			m_recordSet.m_pDatabase=&m_database;
			CString strSQL;
			strSQL.Format("select * from userinfo where user_name='%s' and user_password='%s' and active_status='Y'",username,password);
			m_recordSet.Open(CRecordset::forwardOnly,strSQL);
			if(m_recordSet.GetRecordCount()==0)
			{
				MessageBox("pass erorr","pass erorr",MB_OK|MB_ICONWARNING);
               m_strPassword.SetWindowText("");
				m_strPassword.SetFocus();

			}
			else 
			{
				m_recordSet.GetFieldValue("user_level",m_userLevel);
				CDialog::OnOK();//进入主窗口
			}
			m_recordSet.Close();
			m_database.Close();
		}
		else 
		{
			MessageBox("unable open database");
		}
	}
//	CDialog::OnOK();
}

void CLoginDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	if(MessageBox("exit ?","exit",MB_OKCANCEL|MB_ICONQUESTION)==IDOK)
      CDialog::OnCancel();
}

HBRUSH CLoginDlg::OnCtlColor(CDC* pDC, CWnd* pWnd, UINT nCtlColor) 
{
	HBRUSH hbr = CDialog::OnCtlColor(pDC, pWnd, nCtlColor);
	
	// TODO: Change any attributes of the DC here
if(pWnd->GetDlgCtrlID()==IDC_USER)
{
	pDC->SelectObject(&m_font);
	pDC->SetTextColor(RGB(255,0,0));
	pDC->SetBkColor(TRANSPARENT); 
	return m_brush;
}

if(pWnd->GetDlgCtrlID()==IDC_USERNAME)
{
	pDC->SetTextColor(RGB(255,0,0));
	//pDC->SetBkColor(TRANSPARENT); 
      pDC->SetBkColor(RGB(0,0,255));
	return m_brush;
}
if(pWnd->GetDlgCtrlID()==IDC_MIMA)
{
	pDC->SelectObject(&m_font);
	pDC->SetTextColor(RGB(255,0,0));
	pDC->SetBkColor(TRANSPARENT); 
	return m_brush;
}

if(pWnd->GetDlgCtrlID()==IDC_PASSWORD)
{
	pDC->SetTextColor(RGB(255,0,0));
	//pDC->SetBkColor(TRANSPARENT); 
      pDC->SetBkColor(RGB(0,0,255));
	return m_brush;
}
	
	// TODO: Return a different brush if the default is not desired
//	return hbr;
	return m_brush;
}