querybook.cpp

基于access数据库的图书馆管理系统

// QUERYBOOK.cpp : implementation file
//

#include "stdafx.h"
#include "课程设计.h"
#include "QUERYBOOK.h"

#include "MainFrm.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQUERYBOOK dialog


CQUERYBOOK::CQUERYBOOK(CWnd* pParent /*=NULL*/)
	: CDialog(CQUERYBOOK::IDD, pParent)
{
	//{{AFX_DATA_INIT(CQUERYBOOK)
	m_message = _T("");
	m_check = 0;
	//}}AFX_DATA_INIT
}


void CQUERYBOOK::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQUERYBOOK)
	DDX_Control(pDX, IDC_QUERY_TYPE, m_tpye);
	DDX_Text(pDX, IDC_QUERY, m_message);
	DDX_Radio(pDX, IDC_RADIO1, m_check);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQUERYBOOK, CDialog)
	//{{AFX_MSG_MAP(CQUERYBOOK)
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQUERYBOOK message handlers

BOOL CQUERYBOOK::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_tpye.AddString("书名");
	m_tpye.AddString("图书编号");
	m_tpye.AddString("作者");
	m_tpye.SelectString(-1,"书名");
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CQUERYBOOK::OnButton1() 
{
	// TODO: Add your control notification handler code here
	UpdateData();
	CString type;
	m_tpye.GetLBText(m_tpye.GetCurSel(),type);
    CString sql;
	if(!m_check)//书名,作者,书号,出版社,出版日期,定价
		sql = "select * from 书目信息表,馆藏图书信息表 where "+type+" like"+" '"+m_message+"%"+"'";
	else
		sql = "select * from 书目信息表,馆藏图书信息表 where "+type+" like"+" '"+"%"+m_message+"'";
 
	sql = sql +" and 馆藏图书信息表.图书ID = 书目信息表.书号  and  馆藏图书信息表.是否在库 = '1'";

	CReslut *dlg;
	dlg = new CReslut;
	dlg->Create(IDD_DIALOG_Result,this);
    dlg->sql_query(sql);
	dlg->WSEEN_adjust();
	dlg->m_borrow = 1;                         //表示借书操作
	dlg->SetDlgItemText(IDC_BTN_BORROW,"借书");
	dlg->ShowWindow(SW_SHOW);	

	CMainFrame * pWnd;
	pWnd = (CMainFrame *)AfxGetMainWnd();
	if(pWnd->m_admin)
	{		
		dlg->GetDlgItem(IDC_BTN_BORROW)->EnableWindow(TRUE);
	}
	else
	{
		dlg->GetDlgItem(IDC_BTN_BORROW)->EnableWindow(FALSE);
	}
}



//DEL void CQUERYBOOK::adjust(CDataGrid	m_datagrid)
//DEL {
//DEL     _variant_t vIndex;
//DEL 	vIndex = long(0);
//DEL 	m_datagrid.GetColumns().GetItem(vIndex).SetWidth(0);
//DEL 	for (int i = 1; i<=6; i++)
//DEL 	{
//DEL 		vIndex = long(i);
//DEL 		m_datagrid.GetColumns().GetItem(vIndex).SetWidth(80);
//DEL 	}
//DEL }