bookborrowquerydlg.cpp

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

// BookBorrowQueryDlg.cpp : implementation file
//

#include "stdafx.h"
#include "图书馆管理系统.h"
#include "BookBorrowQueryDlg.h"
#include "BookBorrowEdit.h"
#include "adodc.h"
#include "column.h"
#include "columns.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookBorrowQueryDlg dialog


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


void CBookBorrowQueryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CBookBorrowQueryDlg)
	DDX_Text(pDX, IDC_BORROWID_EDIT, m_BorrowID);
	DDX_Control(pDX, IDC_ADODC1, m_Adodc);
	DDX_Control(pDX, IDC_DATAGRID1, m_dataGridEm);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CBookBorrowQueryDlg, CDialog)
	//{{AFX_MSG_MAP(CBookBorrowQueryDlg)
	ON_BN_CLICKED(IDC_QUERY, OnQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CBookBorrowQueryDlg message handlers

void CBookBorrowQueryDlg::OnQuery() 
{
	// TODO: Add your control notification handler code here
	UpdateData(TRUE);
	CBookBorrowEdit bookborrowedit;

	if(m_BorrowID=="")
	{
		MessageBox("请输入借阅证号！");
		return;
	}

	bookborrowedit.SetBorrowID(m_BorrowID);

	if (bookborrowedit.HaveBorrowID(m_BorrowID) == 1)
	{
			//更新数据
			CString  cSource="select BookID,BookName,Writer,Press,Price from Book_Info where "
				             "BookID in(select BookID from Borrow_Info where BorrowID in(select "
							 "BorrowID from Proof_Info where BorrowID='"+m_BorrowID+"'))";

			m_Adodc.SetRecordSource(cSource);
			m_Adodc.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 (100);
		

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

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

		   onecol=allCols.GetItem(COleVariant(long(4)));
		   onecol.SetCaption(" 价格");
		   onecol.SetWidth (40);


	}
	else
	{
		MessageBox("借阅证不存在，请重新输入！");
       	return;
	}

	
}