proof_info_querydlg.cpp

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

// Proof_Info_QueryDlg.cpp : implementation file
//

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


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

/////////////////////////////////////////////////////////////////////////////
// CProof_Info_QueryDlg dialog


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


void CProof_Info_QueryDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CProof_Info_QueryDlg)
	DDX_Control(pDX, IDC_ADODC1, m_adoDCEm);
	DDX_Text(pDX, IDC_BORROWID_EDIT, m_BorrowID);
	DDX_Control(pDX, IDC_DATAGRID2, m_dataGridEm);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CProof_Info_QueryDlg, CDialog)
	//{{AFX_MSG_MAP(CProof_Info_QueryDlg)
	ON_BN_CLICKED(IDC_PROOF_INFO_QUERY_BUTTON, OnProofInfoQueryButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CProof_Info_QueryDlg message handlers

void CProof_Info_QueryDlg::OnProofInfoQueryButton() 
{
	// TODO: Add your control notification handler code here
	//获得用户输入
	UpdateData(TRUE);
	CProof_Info proof_info;
	CString	strSQL;
	if(m_BorrowID=="")
	{
		MessageBox("请输入借阅证号！");
	}
	if (proof_info.HaveBorrowID(m_BorrowID) == 1)
	{
		//构造新的查询SQL
		strSQL.Format("select Stu_Name,Class,Sex,ID_Number,Tel_Number,Borrow_Amount from "
			          "Proof_Info where BorrowID='%s'",m_BorrowID);
		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 (80);

	    onecol=allCols.GetItem(COleVariant(long(1)));
	    onecol.SetCaption(" 班级");
	    onecol.SetWidth (80);

	    onecol=allCols.GetItem(COleVariant(long(2)));
	    onecol.SetCaption(" 性别");
	    onecol.SetWidth (40);

        onecol=allCols.GetItem(COleVariant(long(3)));
	    onecol.SetCaption(" 身份证号");
	    onecol.SetWidth (80);

        onecol=allCols.GetItem(COleVariant(long(4)));
	    onecol.SetCaption(" 联系电话");
	    onecol.SetWidth (80);
 
	    onecol=allCols.GetItem(COleVariant(long(5)));
	    onecol.SetCaption(" 借书量");
	    onecol.SetWidth (80);
	
	}
	else
	{
		MessageBox("该借阅证不存在，请重新输入！");
		return;
	}
	
}