logindlg.cpp

图书管理系统,自己编的,希望高手多指教.

// LoginDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.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)
{
	m_font.CreatePointFont(350,"华文行楷");
	//{{AFX_DATA_INIT(CLoginDlg)
	m_Password = _T("");
	m_UserID = _T("");
	m_IsAdmin = FALSE;
	//}}AFX_DATA_INIT
}


void CLoginDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLoginDlg)
	DDX_Text(pDX, IDC_EDIT1, m_Password);
	DDV_MaxChars(pDX, m_Password, 16);
	DDX_Text(pDX, IDC_EDIT2, m_UserID);
	DDV_MaxChars(pDX, m_UserID, 16);
	DDX_Check(pDX, IDC_CHECK1, m_IsAdmin);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CLoginDlg, CDialog)
	//{{AFX_MSG_MAP(CLoginDlg)
	ON_WM_CTLCOLOR()
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

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

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_TEXT)
	{
		pDC->SelectObject(&m_font);
	}
	// TODO: Return a different brush if the default is not desired
	return hbr;
}

void CLoginDlg::OnButton1() 
{
	// TODO: Add your control notification handler code here
	ShellExecute(NULL, NULL, "www.jmu.edu.cn", NULL, NULL, SW_SHOWNORMAL);
}

void CLoginDlg::OnButton2() 
{
	// TODO: Add your control notification handler code here
	ShellExecute(NULL, NULL, "www.jmu.edu.cn", NULL, NULL, SW_SHOWNORMAL);
}

void CLoginDlg::OnOK() 
{
	CString sqlStr;
	// TODO: Add extra validation here
	UpdateData();
	if(m_UserID == "")
	{
		MessageBox("请输入用户名");
		return;
	}
	else if(m_Password == "")
	{
		MessageBox("密码不可为空");
		return;
	}
	if(m_IsAdmin == 0)
	{
		sqlStr = "SELECT * FROM READER WHERE READER_ID = '";
		sqlStr += m_UserID;
		sqlStr += "'";
		sqlStr += "AND READER_PASSWORD = '";
		sqlStr += m_Password;
		sqlStr += "'";
		if(!ReadDataSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
		{
			AfxMessageBox("表打开失败");
			return;
		}
		if(!ReadDataSet.IsEOF())
		{
			ReadDataSet.Close();
			CDialog::OnOK();
		}
		else 
		{
			AfxMessageBox("用户名不存在或密码错误");
			m_Password = _T("");
			UpdateData(false);
			ReadDataSet.Close();
			return;
		}
	}
	else
	{
		sqlStr = "SELECT * FROM MANAGER WHERE MANAGE_ID = '";
		sqlStr += m_UserID;
		sqlStr += "'";
		sqlStr += "AND MANAGE_PASSWORD = '";
		sqlStr += m_Password;
		sqlStr += "'";	
		if(!AdminDataSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
		{
			AfxMessageBox("表打开失败");
			return;
		}
		if(!AdminDataSet.IsEOF())
		{
			AdminDataSet.Close();
			CDialog::OnOK();
		}
		else 
		{
			AfxMessageBox("用户名不存在或密码错误");
			m_Password = _T("");
			UpdateData(false);
			AdminDataSet.Close();
			return;
		}
	}

	LoginID = m_UserID;
	

	CDialog::OnOK();
}

void CLoginDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	PostQuitMessage(WM_QUIT);
}