booksearchdlg.cpp

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

// BookSearchDlg.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "BookSearchDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookSearchDlg dialog


CBookSearchDlg::CBookSearchDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CBookSearchDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CBookSearchDlg)
	m_BookID = _T("");
	//}}AFX_DATA_INIT
}


void CBookSearchDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBookSearchDlg)
	DDX_Control(pDX, IDC_LIST1, m_ctrList);
	DDX_Text(pDX, IDC_NOOK_ID, m_BookID);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBookSearchDlg, CDialog)
	//{{AFX_MSG_MAP(CBookSearchDlg)
	ON_BN_CLICKED(IDOK, OnSearch)
	ON_BN_CLICKED(IDOK4, OnShowALL)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBookSearchDlg message handlers

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

	if(m_BookID.IsEmpty())
		strSQL="select * from Book";
	else
		strSQL.Format("select * from Book where BookID = '%s'",m_BookID);
	RefreshData(strSQL);
}

BOOL CBookSearchDlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	m_bookSet = new CBookSet(&m_BookDB);
	//设置列表
	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.SetColumnWidth(0,80);
	m_ctrList.SetColumnWidth(1,100);
	m_ctrList.SetColumnWidth(2,80);
	m_ctrList.SetColumnWidth(3,60);
	m_ctrList.SetColumnWidth(4,100);
	m_ctrList.SetColumnWidth(5,80);
	m_ctrList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	return TRUE;
}

void CBookSearchDlg::RefreshData(CString strSQL)
{
	m_ctrList.DeleteAllItems();
	m_ctrList.SetRedraw(FALSE);
	UpdateData(TRUE);
	
	if(!m_bookSet->Open(AFX_DB_USE_DEFAULT_TYPE,strSQL))
	{
		MessageBox("打开数据库失败!","数据库错误",MB_OK);
		return ;
	}	
	int i=0;
	CString time;
	CString price;
	while(!m_bookSet->IsEOF())
	{
		m_ctrList.InsertItem(0,m_bookSet->m_BookID);
		m_ctrList.SetItemText(0,1,m_bookSet->m_BookName);
		m_ctrList.SetItemText(0,2,m_bookSet->m_Auther);
		price.Format("%f",m_bookSet->m_Price);
		m_ctrList.SetItemText(0,3,m_bookSet->m_Price);
		m_ctrList.SetItemText(0,4,m_bookSet->m_Publisher);
		time=m_bookSet->m_LoadInData.Format("%Y-%m-%d");
		m_ctrList.SetItemText(0,5,time);
		i++;
		m_bookSet->MoveNext();
	}
	m_bookSet->Close();
	m_ctrList.SetRedraw(TRUE);		
}

void CBookSearchDlg::OnShowALL() 
{
	// TODO: Add your control notification handler code here
	CString strSQL;
	strSQL.Format( "select * from Book ");
	RefreshData( strSQL);
}