returnsearchdlg.cpp

一个C++和SQL的图书管理系统 功能不多 大家可以下来

// ReturnSearchDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "ReturnSearchDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CReturnSearchDlg dialog


CReturnSearchDlg::CReturnSearchDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CReturnSearchDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CReturnSearchDlg)
	m_bookid = _T("");
	m_readerid = _T("");
	//}}AFX_DATA_INIT
}


void CReturnSearchDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CReturnSearchDlg)
	DDX_Control(pDX, IDC_LIST1, m_ctrList);
	DDX_Text(pDX, IDC_BOOK_ID, m_bookid);
	DDX_Text(pDX, IDC_READER_ID, m_readerid);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CReturnSearchDlg, CDialog)
	//{{AFX_MSG_MAP(CReturnSearchDlg)
	ON_BN_CLICKED(IDOK, OnSearch)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CReturnSearchDlg message handlers

void CReturnSearchDlg::OnSearch() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CString strSQL;

	if(!m_bookid.IsEmpty()&!m_readerid.IsEmpty())
	{
		strSQL.Format("select * from ReturnTable where CardID = '%s' and BookID = '%s'" ,m_readerid,m_bookid);
	}
	else if(!m_readerid.IsEmpty())
	{
		strSQL.Format("select * from ReturnTable where CardID = '%s' " ,m_readerid);
	}
	else if(!m_bookid.IsEmpty())
	{
		strSQL.Format("select * from ReturnTable where BookID = '%s'" ,m_bookid);
	}
	else 
	{
		strSQL="select * from ReturnTable";
	}

	m_ctrList.DeleteAllItems();
	m_ctrList.SetRedraw(FALSE);
	
	if(!m_ReSeSet.Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}	

	int i=0;
	CString strtime;
	CString OverDay;
	while(!m_ReSeSet.IsEOF())
	{
		m_ctrList.InsertItem(i,m_ReSeSet.m_CardID);
		m_ctrList.SetItemText(i,1,m_ReSeSet.m_Name);
		m_ctrList.SetItemText(i,2,m_ReSeSet.m_BookID);
		m_ctrList.SetItemText(i,3,m_ReSeSet.m_BookName);
		m_ctrList.SetItemText(i,4,m_ReSeSet.m_Price);
		strtime = m_ReSeSet.m_BorrowData.Format("%Y-%m-%d");
		m_ctrList.SetItemText(i,5,strtime);
		strtime = m_ReSeSet.m_ReturnData.Format("%Y-%m-%d");
		m_ctrList.SetItemText(i,6,strtime);
		strtime = m_ReSeSet.m_RealReturnData.Format("%Y-%m-%d");
		m_ctrList.SetItemText(i,7,strtime);
		OverDay.Format("%d",m_ReSeSet.m_RealReturnData-m_ReSeSet.m_ReturnData);
		m_ctrList.SetItemText(i,8,OverDay);
		m_ctrList.SetItemText(i,9,m_ReSeSet.m_Punish_Cost);
		i++;
		m_ReSeSet.MoveNext();
	}
	m_ReSeSet.Close();
	m_ctrList.SetRedraw(TRUE);	

}

BOOL CReturnSearchDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	//设置列表
	m_ctrList.InsertColumn(0,"读者卡号");
	m_ctrList.InsertColumn(1,"读者名称");
	m_ctrList.InsertColumn(2,"图书编号");
	m_ctrList.InsertColumn(3,"图书名称");
	m_ctrList.InsertColumn(4,"图书价格");
	m_ctrList.InsertColumn(5,"借出日期");
	m_ctrList.InsertColumn(6,"应还日期");
	m_ctrList.InsertColumn(7,"实还日期");
	m_ctrList.InsertColumn(8,"超期天数");
	m_ctrList.InsertColumn(9,"罚款金额");
	m_ctrList.SetColumnWidth(0,80);
	m_ctrList.SetColumnWidth(1,60);
	m_ctrList.SetColumnWidth(2,60);
	m_ctrList.SetColumnWidth(3,90);
	m_ctrList.SetColumnWidth(4,60);
	m_ctrList.SetColumnWidth(5,90);
	m_ctrList.SetColumnWidth(6,90);
	m_ctrList.SetColumnWidth(7,90);
	m_ctrList.SetColumnWidth(8,60);
	m_ctrList.SetColumnWidth(9,60);
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	return TRUE;
}