proppagesearchreaderdlg.cpp

用Visual c++.net开发的图书管理系统

// PropPageSearchReaderDlg.cpp : 实现文件
//

#include "stdafx.h"
#include "myBook.h"
#include "PropPageSearchReaderDlg.h"
#include ".\proppagesearchreaderdlg.h"
#include "readermsgdlg.h"


// CPropPageSearchReaderDlg 对话框

IMPLEMENT_DYNAMIC(CPropPageSearchReaderDlg, CPropertyPage)
CPropPageSearchReaderDlg::CPropPageSearchReaderDlg()
	: CPropertyPage(CPropPageSearchReaderDlg::IDD)
	, m_strReaderID(_T(""))
{
}

CPropPageSearchReaderDlg::~CPropPageSearchReaderDlg()
{
}

void CPropPageSearchReaderDlg::DoDataExchange(CDataExchange* pDX)
{
	CPropertyPage::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT_READER_ID, m_strReaderID);
}


BEGIN_MESSAGE_MAP(CPropPageSearchReaderDlg, CPropertyPage)
	ON_BN_CLICKED(IDC_BUTTON_LOGIN, OnBnClickedButtonLogin)
END_MESSAGE_MAP()


// CPropPageSearchReaderDlg 消息处理程序

void CPropPageSearchReaderDlg::OnBnClickedButtonLogin()
{
	UpdateData(TRUE);
	CString strSQL;
	strSQL.Format( _T("SELECT RecorderBookID FROM my_recorder WHERE RecorderReaderID='%s'"), m_strReaderID );
	TRACE0( strSQL );
	try
	{
		CDatabase db;
		db.OpenEx(_T("DSN=myLib;UID=sa;PWD='';"), CDatabase::noOdbcDialog);
		CRecordset rset(&db);
		rset.Open(CRecordset::dynaset,strSQL);
		CReaderMsgDlg dlg;
		dlg.SetRecordSet( &rset );
		dlg.DoModal();
		rset.Close();
		db.Close();
	}
	catch ( CDBException *e )
	{
		e->ReportError();
		e->Delete();
	}
}