bookquerydlg.cpp

来自「实现基本的图书馆管理系统」· C++ 代码 · 共 115 行

// BookQueryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "图书馆管理系统.h"
#include "BookQueryDlg.h"
#include "column.h"
#include "columns.h"


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

/////////////////////////////////////////////////////////////////////////////
// CBookQueryDlg dialog


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


void CBookQueryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBookQueryDlg)
	DDX_Text(pDX, IDC_BOOKNAME_EDIT, m_BookName);
	DDX_Control(pDX, IDC_ADODC1, m_adoDCEm);
	DDX_Control(pDX, IDC_DATAGRID1, m_dataGridEm);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBookQueryDlg, CDialog)
	//{{AFX_MSG_MAP(CBookQueryDlg)
	ON_BN_CLICKED(IDC_BOOKQUERY, OnBookquery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBookQueryDlg message handlers

void CBookQueryDlg::OnBookquery() 
{
	// TODO: Add your control notification handler code here
	//获得用户输入
	UpdateData(TRUE);
	CString	strSQL;
	if(m_BookName=="")
	{
		MessageBox("请输入要查询的书名");
		return;
	}
	else
	{
		//设置select语句

	    strSQL.Format("select BookID,BookName,writer,Press,Price,InlibraryTime,Total_Amount,"
			          "Now_Amount from Book_Info where BookName='%s'",m_BookName);
	
		m_adoDCEm.SetRecordSource(strSQL);
		//刷新
		m_adoDCEm.Refresh();

		////////////////////////////
		//设置列的宽度
		CColumns allCols;
	    CColumn  onecol;
		///获得dataGrid控件的列集对象
       allCols=m_dataGridEm.GetColumns();
	   //以序号为参数获得某列对象
	   onecol=allCols.GetItem(COleVariant(long(0)));
	   //设置属性
	   onecol.SetCaption(" 图书号");
	   //设置列宽
	   onecol.SetWidth (50);

	   onecol=allCols.GetItem(COleVariant(long(1)));
	   onecol.SetCaption(" 图书名称");
	   onecol.SetWidth (110);

       onecol=allCols.GetItem(COleVariant(long(2)));
	   onecol.SetCaption(" 作者");
	   onecol.SetWidth (80);

       onecol=allCols.GetItem(COleVariant(long(3)));
	   onecol.SetCaption(" 出版社");
	   onecol.SetWidth (110);

	   onecol=allCols.GetItem(COleVariant(long(4)));
	   onecol.SetCaption(" 价格");
	   onecol.SetWidth (40);
	   
	   onecol=allCols.GetItem(COleVariant(long(5)));
	   onecol.SetCaption(" 入库时间");
	   onecol.SetWidth (80);

	   onecol=allCols.GetItem(COleVariant(long(6)));
	   onecol.SetCaption("总量");
	   onecol.SetWidth (40);

	   onecol=allCols.GetItem(COleVariant(long(7)));
	   onecol.SetCaption(" 现存量");
	   onecol.SetWidth (60);

	}
}