researchbookdlg.cpp

一个图书管理系统

// ResearchBookDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Library.h"
#include "ResearchBookDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CResearchBookDlg dialog


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


void CResearchBookDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CResearchBookDlg)
	DDX_Control(pDX, IDC_LIST_SHOW, m_ctrlist);
	DDX_Text(pDX, IDC_EDIT_BOOK_NAME, m_strbookname);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CResearchBookDlg, CDialog)
	//{{AFX_MSG_MAP(CResearchBookDlg)
	ON_BN_CLICKED(IDC_BUTTON_RESEARCH, OnButtonResearch)
	ON_BN_CLICKED(IDC_BUTTON_CHECK_ALL, OnButtonCheckAll)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CResearchBookDlg message handlers

void CResearchBookDlg::OnButtonResearch() 
{
  UpdateData();
  CString strSQL;
  if(m_strbookname.IsEmpty())
	  strSQL="select * from bookinfo";
  else
	  strSQL.Format("select * from bookinfo where Book_Name like '%%%s%%'",m_strbookname);
  RefreshData(strSQL);
}

BOOL CResearchBookDlg::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.SetColumnWidth(0,80);
	m_ctrlist.SetColumnWidth(1,120);
	m_ctrlist.SetColumnWidth(2,80);
	m_ctrlist.SetColumnWidth(3,80);
	m_ctrlist.SetColumnWidth(4,80);
	m_ctrlist.SetColumnWidth(5,80);
	m_ctrlist.SetColumnWidth(6,80);
	m_ctrlist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CResearchBookDlg::RefreshData(CString str)
{
	//清空列表
	m_ctrlist.DeleteAllItems();
	m_ctrlist.SetRedraw(FALSE);
	UpdateData(TRUE);
	if(!m_bookset.Open(AFX_DB_USE_DEFAULT_TYPE,str))
	{
		MessageBox("数据库打开错误!","数据库错误",MB_OK);
		return;
	}
	int i=0;
	CString strTime,strprice,strcount;
	if(m_bookset.GetRecordCount()==0)
	{
		AfxMessageBox("没有搜索到与题目相关的书籍");
		return;
	}
	//在列表中显示图书信息
	while(!m_bookset.IsEOF())
	{
		m_ctrlist.InsertItem(i,m_bookset.m_Book_ID);
		m_ctrlist.SetItemText(i,1,m_bookset.m_Book_Name);
		m_ctrlist.SetItemText(i,2,m_bookset.m_Writer);
		m_ctrlist.SetItemText(i,3,m_bookset.m_Press);
		strprice.Format("%f",m_bookset.m_Price);
		m_ctrlist.SetItemText(i,4,strprice);
		strcount.Format("%d",m_bookset.m_Total_Amount);
		m_ctrlist.SetItemText(i,5,strcount);
		strTime.Format("%d-%d-%d",m_bookset.m_Into_Date.GetYear(),m_bookset.m_Into_Date.GetMonth(),m_bookset.m_Into_Date.GetDay());
		m_ctrlist.SetItemText(i,6,strTime);
		i++;
		m_bookset.MoveNext();
	}
	m_bookset.Close();
	m_ctrlist.SetRedraw(TRUE);
}

void CResearchBookDlg::OnButtonCheckAll() 
{
    CString strSQL;
	strSQL="select * from bookinfo";
	//更新列表显示
	RefreshData(strSQL);
}