bookrs.cpp

连接SQL Server的图书管理系统

// BookRS.cpp : implementation file
//

#include "stdafx.h"
#include "MyLibrary.h"
#include "BookRS.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBookRS

IMPLEMENT_DYNAMIC(CBookRS, CRecordset)

CBookRS::CBookRS(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CBookRS)
	m_ISBN = _T("");
	m_category = _T("");
	m_title = _T("");
	m_press = _T("");
	m_author = _T("");
	m_price = 0.0f;
	m_total_num = 0;
	m_present_num = 0;
//	m_flag = _T("");
	m_nFields = 9;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CBookRS::GetDefaultConnect()
{
	return _T("ODBC;DSN=MyLibrary");
}

CString CBookRS::GetDefaultSQL()
{
	return _T("[dbo].[book]");
}

void CBookRS::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CBookRS)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[ISBN]"), m_ISBN);
	RFX_Text(pFX, _T("[category]"), m_category);
	RFX_Text(pFX, _T("[title]"), m_title);
	RFX_Text(pFX, _T("[press]"), m_press);
	RFX_Date(pFX, _T("[press_date]"), m_press_date);
	RFX_Text(pFX, _T("[author]"), m_author);
	RFX_Single(pFX, _T("[price]"), m_price);
	RFX_Long(pFX, _T("[total_num]"), m_total_num);
	RFX_Long(pFX, _T("[present_num]"), m_present_num);
//	RFX_Text(pFX, _T("[flag]"), m_flag);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CBookRS diagnostics

#ifdef _DEBUG
void CBookRS::AssertValid() const
{
	CRecordset::AssertValid();
}

void CBookRS::Dump(CDumpContext& dc) const
{
	CRecordset::Dump(dc);
}
#endif //_DEBUG