librarydlg.cpp

多张数据表 含有SQL语句

// LibraryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "LibraryDlg.h"
#include "MainDlg.h"
#include "LoginSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLibraryDlg dialog

CLibraryDlg::CLibraryDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CLibraryDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CLibraryDlg)
	m_strPassword = _T("");
	m_strUsername = _T("");
	//}}AFX_DATA_INIT
	// Note that LoadIcon does not require a subsequent DestroyIcon in Win32
	m_hIcon = AfxGetApp()->LoadIcon(IDR_MAINFRAME);
}

void CLibraryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CLibraryDlg)
	DDX_Text(pDX, IDC_EDIT_PASSWD, m_strPassword);
	DDX_Text(pDX, IDC_EDIT_USER, m_strUsername);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CLibraryDlg, CDialog)
	//{{AFX_MSG_MAP(CLibraryDlg)
	ON_WM_QUERYDRAGICON()
	ON_BN_CLICKED(IDC_BUTTON_OK, OnButtonOk)
	ON_BN_CLICKED(IDC_BUTTON_CANCEL, OnButtonCancel)
	ON_WM_CLOSE()
	ON_WM_LBUTTONDBLCLK()
	ON_WM_CREATE()
	ON_MESSAGE(DM_GETDEFID, OnGetDefID)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CLibraryDlg message handlers

BOOL CLibraryDlg::OnInitDialog()
{
	CDialog::OnInitDialog();

	// Set the icon for this dialog.  The framework does this automatically
	//  when the application's main window is not a dialog
	SetIcon(m_hIcon, TRUE);			// Set big icon
	SetIcon(m_hIcon, FALSE);		// Set small icon
	
	// TODO: Add extra initialization here
	count=0;

	return TRUE;  // return TRUE  unless you set the focus to a control
}

// If you add a minimize button to your dialog, you will need the code below
//  to draw the icon.  For MFC applications using the document/view model,
//  this is automatically done for you by the framework.



HCURSOR CLibraryDlg::OnQueryDragIcon()
{
	return (HCURSOR) m_hIcon;
}

void CLibraryDlg::OnButtonOk() 
{
	UpdateData();
	if(m_strUsername.IsEmpty())
	{
		MessageBox("请输入用户名!","登录系统",MB_OK|MB_ICONEXCLAMATION);
		m_strUsername.Empty();
		UpdateData(FALSE);
		return;
	}

	if(!m_database.IsOpen())
	{
		//连接数据源
		if(!m_database.Open(_T("Library")))
		{
			MessageBox("无法连接数据库!","图书管理系统",MB_OK|MB_ICONINFORMATION);
			return;
		}
	}
	
	CLoginSet *m_pLogset=new CLoginSet(&m_database);

	//编写SQL语句
	CString strSQL;
	strSQL.Format("select * from Admin_Info where User_Name='%s' AND Password='%s'",m_strUsername,m_strPassword);
	//编写SQL语句结束

	m_pLogset->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL);
	
	if(m_pLogset->GetRecordCount()==0)
	{
		if(count<5)
		{
			MessageBox("错误!","图书管理系统",MB_OK|MB_ICONERROR);
			count++;
			m_strPassword.Empty();
			m_strUsername.Empty();
			UpdateData(FALSE);
		}
		else
		{
			m_database.Close();
			MessageBox("错误!","图书管理系统");
			OnOK();
		}
	}
	else
	{
		m_database.Close();
		CMainDlg m_Main;
		m_Main.m_user=m_strUsername;
		MessageBox("欢迎使用~_~!","图书管理系统");
		m_Main.DoModal();
		OnOK();			
	}
}

void CLibraryDlg::OnButtonCancel() 
{
	
	int iResult=MessageBox("确定要退出?","图书管理系统",MB_YESNO|MB_ICONQUESTION);
	if(iResult==IDYES)
	{
		if(m_database.IsOpen())
			m_database.Close();
		OnOK();
	}
}

void CLibraryDlg::OnClose() 
{
	OnButtonCancel();	
}

void CLibraryDlg::OnLButtonDblClk(UINT nFlags, CPoint point) 
{
	MessageBox("你需要做什么?","图书管理系统",MB_ICONQUESTION);	
	CDialog::OnLButtonDblClk(nFlags, point);
}

int CLibraryDlg::OnCreate(LPCREATESTRUCT lpCreateStruct) 
{
	if (CDialog::OnCreate(lpCreateStruct) == -1)
		return -1;	
	return 0;
}
LRESULT CLibraryDlg::OnGetDefID(WPARAM wp, LPARAM lp) 
{
    return MAKELONG(0,DC_HASDEFID); 
}