resourceset.cpp

< Visual C+++SQL Server数据库开发与实例>>一书中的实例核心源程序提供了几个案例的编程源代码。

// ResourceSet.cpp : implementation file
//

#include "stdafx.h"
#include "train.h"
#include "ResourceSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CResourceSet

IMPLEMENT_DYNAMIC(CResourceSet, CRecordset)

CResourceSet::CResourceSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CResourceSet)
	m_RESOURCE_ID = 0;
	m_RESOURCE_NAME = _T("");
	m_RESOURCE_MARK = 0;
	m_RESOURCE_PRICE = 0.0;
	m_RESOURCE_QUANTITY = 0;
	m_RESOURCE_REM = _T("");
	m_nFields = 6;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CResourceSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=Train");
}

CString CResourceSet::GetDefaultSQL()
{
	return _T("[TM_RESOURCE]");
}

void CResourceSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CResourceSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Int(pFX, _T("[RESOURCE_ID]"), m_RESOURCE_ID);
	RFX_Text(pFX, _T("[RESOURCE_NAME]"), m_RESOURCE_NAME);
	RFX_Byte(pFX, _T("[RESOURCE_MARK]"), m_RESOURCE_MARK);
	RFX_Double(pFX, _T("[RESOURCE_PRICE]"), m_RESOURCE_PRICE);
	RFX_Int(pFX, _T("[RESOURCE_QUANTITY]"), m_RESOURCE_QUANTITY);
	RFX_Text(pFX, _T("[RESOURCE_REM]"), m_RESOURCE_REM);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CResourceSet diagnostics

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

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