qurreaderdlg.cpp

此源程序是图书馆管理系统

// QurreaderDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "QurreaderDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQurreaderDlg dialog


CQurreaderDlg::CQurreaderDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CQurreaderDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQurreaderDlg)
	m_ReaderId = _T("");
	m_ReaderName = _T("");
	m_Card = _T("");
	//}}AFX_DATA_INIT
}


void CQurreaderDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQurreaderDlg)
	DDX_Control(pDX, IDC_LIST1, m_List);
	DDX_Text(pDX, IDC_EDIT1, m_ReaderId);
	DDX_Text(pDX, IDC_EDIT2, m_ReaderName);
	DDX_Text(pDX, IDC_EDIT3, m_Card);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQurreaderDlg, CDialog)
	//{{AFX_MSG_MAP(CQurreaderDlg)
	ON_BN_CLICKED(IDC_QUR, OnQur)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQurreaderDlg message handlers

BOOL CQurreaderDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_List.InsertColumn(0,"书名");
	m_List.InsertColumn(1,"借书日期");
	RECT rect;
	m_List.GetWindowRect(&rect);
	int wid=rect.right-rect.left;
	m_List.SetColumnWidth(0,wid/2);
	m_List.SetColumnWidth(1,wid/2);
	m_List.SetExtendedStyle(LVS_EX_FULLROWSELECT);
	
	// TODO: Add extra initialization here
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CQurreaderDlg::OnQur() 
{
	// TODO: Add your control notification handler code here
	if(rdset.IsOpen())
	{
		rdset.Close();
	}
	if(brwSet.IsOpen())
	{
		brwSet.Close();
	}
	UpdateData(true);
	CString sqlStr;
	sqlStr="SELECT * FROM READER WHERE READER_ID='";
	sqlStr+=m_ReaderId;
	sqlStr+="'";
	if(!rdset.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("reader表打开失败!");
	}
	sqlStr="SELECT * FROM BORROW WHERE READER_ID='";
	sqlStr+=m_ReaderId;
	sqlStr+="'";
	if(!brwSet.Open(AFX_DB_USE_DEFAULT_TYPE,sqlStr))
	{
		AfxMessageBox("borrow表打开失败!");
	}
	DisplayRecord();

}
bool CQurreaderDlg::DisplayRecord()
{
	m_ReaderName=rdset.m_NAME;
	m_Card=rdset.m_IDCARD;
	//
	brwSet.MoveFirst();
	CString str;
	CString name;
	CString date;
	int i=0;
	while(!brwSet.IsEOF())
	{
		str=brwSet.m_BOOK_ID;
		//取出书名
		CString sql;
		sql="SELECT * FROM BOOK WHERE BOOK_ID='";
		sql+=str;
		sql+="'";
		MessageBox(sql);
		if(bkSet.IsOpen())
		{
			bkSet.Close();
		}
		if(!bkSet.Open(AFX_DB_USE_DEFAULT_TYPE,sql))
		{
			AfxMessageBox("book表打开失败!");
		}
		name=bkSet.m_BOOK_NAME;
		m_List.InsertItem(i,name.GetBuffer(50));
		MessageBox(str);
		date.Format("%d-%d-%d",brwSet.m_BORROW_DATE.GetYear(),brwSet.m_BORROW_DATE.GetMonth(),
			brwSet.m_BORROW_DATE.GetDay());
		m_List.SetItemText(i,1,date.GetBuffer(50));
		MessageBox(date);
		brwSet.MoveNext();
		i++;
	}
	UpdateData(false);
	return true;
}