borrowrs.cpp

连接SQL Server的图书管理系统

// BorrowRS.cpp : implementation file
//

#include "stdafx.h"
#include "MyLibrary.h"
#include "BorrowRS.h"

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

/////////////////////////////////////////////////////////////////////////////
// CBorrowRS

IMPLEMENT_DYNAMIC(CBorrowRS, CRecordset)

CBorrowRS::CBorrowRS(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CBorrowRS)
	m_card_num = _T("");
	m_ISBN = _T("");
	m_managerID = _T("");
	m_nFields = 5;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


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

CString CBorrowRS::GetDefaultSQL()
{
	return _T("[dbo].[borrow]");
}

void CBorrowRS::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CBorrowRS)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[card_num]"), m_card_num);
	RFX_Text(pFX, _T("[ISBN]"), m_ISBN);
	RFX_Date(pFX, _T("[borrow_date]"), m_borrow_date);
	RFX_Date(pFX, _T("[return_date]"), m_return_date);
	RFX_Text(pFX, _T("[managerID]"), m_managerID);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CBorrowRS diagnostics

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

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