all.cpp

图书管理系统,主要功能有图书的借还,增加,查询等

// ALL.cpp : implementation file
//

#include "stdafx.h"
#include "图书管理系统.h"
#include "ALL.h"
#include "bmanager.h"

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

/////////////////////////////////////////////////////////////////////////////
// CALL dialog


CALL::CALL(CWnd* pParent /*=NULL*/)
	: CDialog(CALL::IDD, pParent)
{
	//{{AFX_DATA_INIT(CALL)
	m_address = _T("");
	m_athor = _T("");
	m_date = _T("");
	m_have = _T("");
	m_id = _T("");
	m_name = _T("");
	m_type = _T("");
	m_people = _T("");
	//}}AFX_DATA_INIT
}


void CALL::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CALL)
	DDX_Text(pDX, IDC_ADDESS, m_address);
	DDX_Text(pDX, IDC_ATHOR, m_athor);
	DDX_Text(pDX, IDC_DATE, m_date);
	DDX_Text(pDX, IDC_HAVE, m_have);
	DDX_Text(pDX, IDC_ID, m_id);
	DDX_Text(pDX, IDC_NAME, m_name);
	DDX_Text(pDX, IDC_TYPE, m_type);
	DDX_Text(pDX, IDC_people, m_people);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CALL, CDialog)
	//{{AFX_MSG_MAP(CALL)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CALL message handlers

BOOL CALL::OnInitDialog() 
{
	CDialog::OnInitDialog();
	UpdateData(FALSE);
	// TODO: Add extra initialization here
	read();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CALL::read()
{
	sql.Format("select * from book where bookid='%s'",mm);
	connect();
	if(!m_pRecordset->adoEOF)
	{
		var=m_pRecordset->GetCollect("bookid");
		if(var.vt!=VT_NULL)
			m_id=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("booktype");
		if(var.vt!=VT_NULL)
			m_type=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("bookname");
		if(var.vt!=VT_NULL)
			m_name=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("author");
		if(var.vt!=VT_NULL)
			m_athor=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("publicdate");
		if(var.vt!=VT_NULL)
			m_date=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("publisher");
		if(var.vt!=VT_NULL)
			m_address=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("have");
		if(var.vt!=VT_NULL)
			m_have=(LPCSTR)_bstr_t(var);
		var=m_pRecordset->GetCollect("people");
		if(var.vt!=VT_NULL)
			m_people=(LPCSTR)_bstr_t(var);
		UpdateData(FALSE);
	}
	m_pRecordset->Close();
	m_pRecordset=NULL;
}

void CALL::connect()
{
	m_pRecordset.CreateInstance(__uuidof(Recordset));
	try
	{
		m_pRecordset->Open(sql.AllocSysString(),
							theApp.m_pConnection.GetInterfacePtr(),	
							adOpenDynamic,
							adLockOptimistic,
							adCmdText);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
}