findbook.cpp

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

#include "stdafx.h"
#include "library.h"
#include "FindBook.h"

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

/////////////////////////////////////////////////////////////////////////////
// CFindBook dialog


CFindBook::CFindBook(CWnd* pParent /*=NULL*/)
	: CDialog(CFindBook::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFindBook)
	m_IsMohu = FALSE;
	m_Input = _T("");
	//}}AFX_DATA_INIT
}


void CFindBook::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFindBook)
	DDX_Control(pDX, IDC_ADODC1, m_Ado);
	DDX_Check(pDX, IDC_CHECK1, m_IsMohu);
	DDX_Text(pDX, IDC_EDIT2, m_Input);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CFindBook message handlers

BOOL CFindBook::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))->SetCurSel(0);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CFindBook::OnButton2() 
{
	CString sqlStr;
	int	index;
	UpdateData(true);
	index = ((CComboBox*)GetDlgItem(IDC_COMBO2))->GetCurSel();

	switch(index)
	{
	case 0:
		if(m_Input.IsEmpty())
		{
			sqlStr = "SELECT BOOK_ID AS 图书编号,BOOK_NAME AS 图书名称,\
			CLASS_NAME AS 类别,AUTHOR AS 作者,PUB_HOUSE AS 出版社,\
			PRICE AS 价格,INTRODUCTION AS 简介 FROM BOOK";
		}
		else
		{
			sqlStr = "SELECT BOOK_ID AS 图书编号,BOOK_NAME AS 图书名称,\
			CLASS_NAME AS 类别,AUTHOR AS 作者,PUB_HOUSE AS 出版社,\
			PRICE AS 价格,INTRODUCTION AS 简介\
			FROM BOOK WHERE BOOK_NAME";
			
			if(m_IsMohu)
			{
				sqlStr += " LIKE '%%";
				sqlStr += m_Input;
				sqlStr += "%%' ";
				sqlStr += "or PUB_HOUSE LIKE'%%";
				sqlStr += m_Input;
				sqlStr += "%%' ";
				sqlStr += "or AUTHOR LIKE'%%";
				sqlStr += m_Input;
				sqlStr += "%%'";
			}
			else
			{
			sqlStr += "='";
			sqlStr += m_Input;
			sqlStr += "' ";
			sqlStr += "or PUB_HOUSE ='";
			sqlStr += m_Input;
			sqlStr += "' ";
			sqlStr += "or AUTHOR ='";
			sqlStr += m_Input;
			sqlStr += "'";
			}
		}
		break;
	case 1:
		sqlStr = "SELECT BOOK_ID AS 图书编号,BOOK_NAME AS 图书名称,\
		CLASS_NAME AS 类别,AUTHOR AS 作者,PUB_HOUSE AS 出版社,\
		PRICE AS 价格,INTRODUCTION AS 简介\
		FROM BOOK WHERE BOOK_NAME ";
		if(m_IsMohu)
		{
			sqlStr += "LIKE '%%";
			sqlStr += m_Input;
			sqlStr += "%%'";
		}
		else
		{
			sqlStr += "='";
			sqlStr += m_Input;
			sqlStr += "'";
		}
		break;
	case 2:
		sqlStr = "SELECT BOOK_ID AS 图书编号,BOOK_NAME AS 图书名称,\
		CLASS_NAME AS 类别,AUTHOR AS 作者,PUB_HOUSE AS 出版社,\
		PRICE AS 价格,INTRODUCTION AS 简介\
		FROM BOOK WHERE AUTHOR ";

		if(m_IsMohu)
		{
			sqlStr += " LIKE'%%";
			sqlStr += m_Input;
			sqlStr += "%%'";
		}
		else
		{
		sqlStr += " ='";
		sqlStr += m_Input;
		sqlStr += "'";
		}
		break;
	case 3:
		sqlStr = "SELECT BOOK_ID AS 图书编号,BOOK_NAME AS 图书名称,\
		CLASS_NAME AS 类别,AUTHOR AS 作者,PUB_HOUSE AS 出版社,\
		PRICE AS 价格,INTRODUCTION AS 简介\
		FROM BOOK WHERE PUB_HOUSE ";
		if(m_IsMohu)
		{
			sqlStr += " LIKE'%%";
			sqlStr += m_Input;
			sqlStr += "%%'";
		}
		else
		{
		sqlStr += " ='";
		sqlStr += m_Input;
		sqlStr += "'";
		}
		break;
	}

	//sqlStr = "SELECT * FROM BOOK WHERE BOOK_NAME = '132'";

	// TODO: Add your control notification handler code here
	m_Ado.SetRecordSource(sqlStr); 
	m_Ado.Refresh();
	sqlStr = _T("");
}

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

void CFindBook::OnButton1() 
{
	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();
	sqlStr = _T("");
	// TODO: Add your control notification handler code here
	
}

BEGIN_EVENTSINK_MAP(CFindBook, CDialog)
    //{{AFX_EVENTSINK_MAP(CFindBook)
	ON_EVENT(CFindBook, IDC_DATAGRID1, -601 /* DblClick */, OnDblClickDatagrid1, VTS_NONE)
	//}}AFX_EVENTSINK_MAP
END_EVENTSINK_MAP()

void CFindBook::OnDblClickDatagrid1() 
{
	// TODO: Add your control notification handler code here
	MessageBox("123");
}