findbook1.cpp

图书管理系统,自己编的,希望高手多指教.

// FindBook1.cpp : implementation file
//

#include "stdafx.h"
#include "library.h"
#include "FindBook1.h"

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

/////////////////////////////////////////////////////////////////////////////
// CFindBook1 dialog


CFindBook1::CFindBook1(CWnd* pParent /*=NULL*/)
	: CDialog(CFindBook1::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFindBook1)
	m_BookName = _T("");
	m_Author = _T("");
	m_Publish = _T("");
	m_Mohu = FALSE;
	//}}AFX_DATA_INIT
}


void CFindBook1::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFindBook1)
	DDX_Control(pDX, IDC_COMBO2, m_Combo);
	DDX_Text(pDX, IDC_EDIT2, m_BookName);
	DDX_Text(pDX, IDC_EDIT3, m_Author);
	DDX_Text(pDX, IDC_EDIT4, m_Publish);
	DDX_Control(pDX, IDC_ADODC1, m_Ado);
	DDX_Check(pDX, IDC_CHECK1, m_Mohu);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CFindBook1, CDialog)
	//{{AFX_MSG_MAP(CFindBook1)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON3, OnButton3)
	ON_BN_CLICKED(IDC_BUTTON2, OnButton2)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFindBook1 message handlers

BOOL CFindBook1::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("所有类别");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("经典理论");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("哲学、宗教");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("政治、法律");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("社会科学总论");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("军事");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("经济");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("数理科学和化学");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("医药、卫生");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("文化、科学、教育");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("语言、文字");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("历史、地理");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("艺术");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("自然科学总论");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("生物科学");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("天文学、地球科学");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("综合性图书");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("环境科学、安全学");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("航空、航天");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("交通运输");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("工业技术");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->AddString("农业科学");
	((CComboBox*)GetDlgItem(IDC_COMBO2))->SetCurSel(0);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CFindBook1::OnButton1() 
{
	// TODO: Add your control notification handler code here
	CString sqlStr;
	sqlStr = "select BOOK_ID AS 图书编号,BOOK_NAME AS 图书名称,CLASS_NAME AS 类别,AUTHOR AS 作者,PUB_HOUSE AS 出版社,PRICE AS 价格,INTRODUCTION AS 简介 from BOOK ";
	m_Ado.SetRecordSource(sqlStr);
	m_Ado.Refresh();
}

void CFindBook1::OnButton3() 
{
	// TODO: Add your control notification handler code here
	CDialog::OnCancel();
}

void CFindBook1::OnButton2() 
{
	// TODO: Add your control notification handler code here
	CString sqlStr;
	CString ComboText;
	int index;
	UpdateData();
	index = m_Combo.GetCurSel();
	m_Combo.GetLBText(index,ComboText);
	sqlStr = "select BOOK_ID AS 图书编号,BOOK_NAME AS 图书名称,CLASS_NAME AS 类别,\
		AUTHOR AS 作者,PUB_HOUSE AS 出版社,PRICE AS 价格,INTRODUCTION AS 简介 from BOOK ";
	if(m_Mohu)
	{
		if(!m_BookName.IsEmpty())
		{
			sqlStr += "WHERE BOOK_NAME LIKE '%%";
			sqlStr += m_BookName;
			sqlStr += "%%'";
		}
		if(!m_Author.IsEmpty())
		{
			if(m_BookName.IsEmpty())
			{
				sqlStr += " WHERE AUTHOR LIKE '%%";
			}
			else
			{
				sqlStr += " AND AUTHOR LIKE '%%";
			}
			sqlStr += m_Author;
			sqlStr += "%%'";
		}
		if(!m_Publish.IsEmpty())
		{
			if(m_BookName.IsEmpty() && m_BookName.IsEmpty())
			{
				sqlStr += " WHERE PUB_HOUSE ='%%";
			}
			else 
			{
				sqlStr += " AND PUB_HOUSE LIKE '%%";
			}
			sqlStr += m_Publish;
			sqlStr += "%%'";
		}
		if(index != 0 && !m_BookName.IsEmpty() && !m_BookName.IsEmpty() && !m_BookName.IsEmpty())
		{
			sqlStr += " AND CLASS_NAME LIKE '%%";
			sqlStr += ComboText;
			sqlStr += "%%'";
		}
	}
	else
	{
		if(!m_BookName.IsEmpty())
		{
			sqlStr += "WHERE BOOK_NAME = '";
			sqlStr += m_BookName;
			sqlStr += "'";
		}
		if(!m_Author.IsEmpty())
		{
			if(m_BookName.IsEmpty())
			{
				sqlStr += " WHERE AUTHOR ='";
			}
			else
			{
				sqlStr += " AND AUTHOR = '";
			}
			sqlStr += m_Author;
			sqlStr += "'";
		}
		if(!m_Publish.IsEmpty())
		{
			if(m_BookName.IsEmpty() && m_BookName.IsEmpty())
			{
				sqlStr += " WHERE PUB_HOUSE ='";
			}
			else 
			{
				sqlStr += " AND PUB_HOUSE ='";
			}
			sqlStr += m_Publish;
			sqlStr += "'";
		}
		if(index != 0 && !m_BookName.IsEmpty() && !m_BookName.IsEmpty() && !m_BookName.IsEmpty())
		{
			sqlStr += " AND CLASS_NAME = '";
			sqlStr += ComboText;
			sqlStr += "'";
		}
	}
	m_Ado.SetRecordSource(sqlStr);
	m_Ado.Refresh();
}