find.cpp

图书管理系统,主要功能有图书的借还,增加,查询等

// find.cpp : implementation file
//

#include "stdafx.h"
#include "图书管理系统.h"
#include "find.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CMyApp theApp;
/////////////////////////////////////////////////////////////////////////////
// Cfind dialog


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


void Cfind::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(Cfind)
	DDX_Control(pDX, IDC_COMBO1, m_combo);
	DDX_Control(pDX, IDC_LIST1, m_list);
	DDX_Control(pDX, IDC_CHECK, m_check);
	DDX_Text(pDX, IDC_ZILIAO, m_ziliao);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(Cfind, CDialog)
	//{{AFX_MSG_MAP(Cfind)
	ON_BN_CLICKED(IDC_CHECK, OnCheck)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// Cfind message handlers

BOOL Cfind::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_list.SetExtendedStyle(LVS_EX_FLATSB
		|LVS_EX_FULLROWSELECT
		|LVS_EX_HEADERDRAGDROP
		|LVS_EX_ONECLICKACTIVATE
		|LVS_EX_GRIDLINES);
	m_list.InsertColumn(0,"图书编号",LVCFMT_CENTER,80,0);
	m_list.InsertColumn(1,"图书类别",LVCFMT_CENTER,80,1);
	m_list.InsertColumn(2,"图书名称",LVCFMT_CENTER,200,2);
	m_list.InsertColumn(3,"作者",LVCFMT_CENTER,80,3);
	m_list.InsertColumn(4,"出版日期",LVCFMT_CENTER,100,4);
	m_list.InsertColumn(5,"出版社",LVCFMT_CENTER,200,5);
	m_list.InsertColumn(6,"是否借出",LVCFMT_CENTER,80,6);

	m_combo.InsertString(0,"按编号");
	m_combo.InsertString(1,"按类别");
	m_combo.InsertString(2,"按名称");
	m_combo.InsertString(3,"按作者");
	m_combo.InsertString(4,"按日期");
	m_combo.InsertString(5,"全部查询");
	m_combo.SetCurSel(5);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void Cfind::connect()
{
	m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{
		m_pRecordset->Open(sql.AllocSysString(),
							theApp.m_pConnection.GetInterfacePtr(),	
							adOpenDynamic,
							adLockOptimistic,
							adCmdText);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
}

void Cfind::read()
{
	connect();
	m_list.DeleteAllItems();
	while(!m_pRecordset->adoEOF)
	{
		m_list.InsertItem(0,"");
		var=m_pRecordset->GetCollect("bookid");
		if(var.vt!=VT_NULL)
			m_list.SetItemText(0,0,_bstr_t(var));
		var=m_pRecordset->GetCollect("booktype");
		if(var.vt!=VT_NULL)
			m_list.SetItemText(0,1,_bstr_t(var));
		var=m_pRecordset->GetCollect("bookname");
		if(var.vt!=VT_NULL)
			m_list.SetItemText(0,2,_bstr_t(var));
		var=m_pRecordset->GetCollect("author");
		if(var.vt!=VT_NULL)
			m_list.SetItemText(0,3,_bstr_t(var));
		var=m_pRecordset->GetCollect("publicdate");
		if(var.vt!=VT_NULL)
			m_list.SetItemText(0,4,_bstr_t(var));
		var=m_pRecordset->GetCollect("publisher");
		if(var.vt!=VT_NULL)
			m_list.SetItemText(0,5,_bstr_t(var));
		var=m_pRecordset->GetCollect("have");
		if(var.vt!=VT_NULL)
			m_list.SetItemText(0,6,_bstr_t(var));
		m_pRecordset->MoveNext();
	}
	m_pRecordset->Close();
	m_pRecordset=NULL;
}

void Cfind::OnCheck() 
{
	m_combo.GetLBText(m_combo.GetCurSel(),sql);
	UpdateData();
	if(!sql.Compare("全部查询"))
		sql.Format("select * from book order by bookid desc");
	else
	{
		if(m_ziliao.IsEmpty())
		{
			m_list.DeleteAllItems();
			MessageBox("请输入要查询的内容");
			return;
		}
		if(!sql.Compare("按编号"))
			sql.Format("select * from book where bookid='%s'",m_ziliao);
		else if(!sql.Compare("按类别"))
			sql.Format("select * from book where booktype like '%%%s%%'order by bookid desc",m_ziliao);
		else if(!sql.Compare("按名称"))
			sql.Format("select * from book where bookname like '%%%s%%'order by bookid desc",m_ziliao);
		else if(!sql.Compare("按作者"))
			sql.Format("select * from book where author like '%%%s%%'order by bookid desc",m_ziliao);
		else if(!sql.Compare("按日期"))
			sql.Format("select * from book where publicdate like '%%%s%%'order by bookid desc",m_ziliao);
	}
	m_ziliao="";
	UpdateData(FALSE);
	read();
}