qryrecorddlg.cpp

自己编写的迷你图书馆的完整程序.VC6MFC编写的,Windows界面.数据采用了Sqlserver2000.压缩包中已包括了数据库.先附加数据库再运行.

// QryRecordDlg.cpp : implementation file
//

#include "stdafx.h"
#include "BookLib.h"
#include "QryRecordDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQryRecordDlg dialog


CQryRecordDlg::CQryRecordDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQryRecordDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQryRecordDlg)
	m_bookid = -1;
	m_readerid = -1;
	//}}AFX_DATA_INIT
}


void CQryRecordDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQryRecordDlg)
	DDX_Control(pDX, IDC_CMB_READERID, m_cmb_readerid);
	DDX_Control(pDX, IDC_CMB_BOOKID, m_cmb_bookid);
	DDX_Control(pDX, IDC_DATAGRID1, m_dg);
	DDX_CBIndex(pDX, IDC_CMB_BOOKID, m_bookid);
	DDX_CBIndex(pDX, IDC_CMB_READERID, m_readerid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQryRecordDlg, CDialog)
	//{{AFX_MSG_MAP(CQryRecordDlg)
	ON_BN_CLICKED(IDC_BTN_QRY, OnBtnQry)
	ON_BN_CLICKED(IDC_BTN_RESET, OnBtnReset)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQryRecordDlg message handlers

void CQryRecordDlg::OnBtnQry() 
{
	if(!UpdateData()) return;
	
	CString sql;
	sql="Select * from 借阅记录表 where ";
	if(m_readerid!=-1)
	{
		CString strReaderid;
		m_cmb_readerid.GetLBText(m_cmb_readerid.GetCurSel(),strReaderid);
		sql=sql+" readerID="+strReaderid+" and ";
	}
	if(m_bookid!=-1)
	{
		CString strBookid;
		m_cmb_bookid.GetLBText(m_cmb_bookid.GetCurSel(),strBookid);
		sql=sql+" bookid='"+strBookid+"'";
	}

	if(sql.Right(6)=="where ")
	{
		MessageBox("必须至少选择一个条件!","提示");
		return;
	}
	if(sql.Right(4)=="and ")
		sql=sql.Left(sql.GetLength()-4);

	m_pRecordset=g_adoDB.ExecuteQuery(sql);
	m_dg.SetRefDataSource(NULL);   
	m_dg.SetRefDataSource((LPUNKNOWN)m_pRecordset);   
	m_dg.Refresh(); 
	
}

void CQryRecordDlg::InitCmb()
{
	m_cmb_bookid.ResetContent();
	m_cmb_readerid.ResetContent();

	CDStrs bidFields;
	g_adoDB.ExecuteQuery("Select bookID from 书籍编号表",bidFields);
	for(int i=0;i<bidFields.size();i++)//书籍编号数据
	{
		CStrs strs=bidFields[i];
		m_cmb_bookid.AddString(strs[0]);
	}

	CDStrs ridFields;
	g_adoDB.ExecuteQuery("Select readerID from 读者表",ridFields);
	for(i=0;i<ridFields.size();i++)//读者编号数据
	{
		CStrs strs=ridFields[i];
		m_cmb_readerid.AddString(strs[0]);
	}

}

BOOL CQryRecordDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	InitCmb();	
	return TRUE; 
}

void CQryRecordDlg::OnBtnReset() 
{
	m_cmb_bookid.SetCurSel(-1);
	m_cmb_readerid.SetCurSel(-1);

}