queryka.cpp

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

// QUERYKA.cpp : implementation file
//

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

#include "column.h"
#include "columns.h"
#include "COMDEF.H"
#include "Reslut.h"
#include "TEST.h"
#include "ADOConn.h"
#include "MainFrm.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQUERYKA dialog


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


void CQUERYKA::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQUERYKA)
	DDX_Text(pDX, IDC_Ka_NUM, m_kanum);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQUERYKA, CDialog)
	//{{AFX_MSG_MAP(CQUERYKA)
	ON_BN_CLICKED(IDC_BTN_QUERY, OnBtnQuery)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQUERYKA message handlers

void CQUERYKA::OnBtnQuery() 
{
	// TODO: Add your control notification handler code here
    UpdateData();
	if(WSEEN_Check())
	{		
		CString kanum;
		kanum = "'"+m_kanum+"'";
	    
		m_cSource = "select * from 书目信息表 where 书号 in (select 图书ID from 馆藏图书信息表 where 借书卡ID ="+kanum+")";//   借书卡ID =" + kanum + " and 馆藏图书信息表.图书ID = 书目信息表.书号";
	
		CReslut *dlg;
		dlg = new CReslut;	
		dlg->Create(IDD_DIALOG_Result,this);
		
		_variant_t vIndex;
		vIndex = long(0);
		dlg->m_Result.GetColumns().GetItem(vIndex).SetWidth(0);

		dlg->sql_query(m_cSource);		
		dlg->m_borrow = 0;                     //表示还书操作
		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);
		}
		
		
	}
	
}



BOOL CQUERYKA::WSEEN_Check()
{
    ADOConn m_adoc;
	m_adoc.OnInitDBConnect();
    CString kanum;
	kanum = "'"+m_kanum+"'";
	_bstr_t vSQL;
	vSQL = "select * from 借书卡表  where 卡号 = "+kanum;
	_RecordsetPtr m_pRecordset;
	m_pRecordset = m_adoc.GetRecordSet(vSQL);
	
	if (m_pRecordset->adoEOF < 0)
	{
		AfxMessageBox("卡号不存在！");
		m_adoc.ExitConnect();
		return 0;
	}
	m_adoc.ExitConnect();
	return 1;
}