sellrecordset.cpp

< SQL SERVER 2000 案例教程>>,冶金工业出版社,这本书的代码

// SellRecordSet.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "SellRecordSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSellRecordSet

IMPLEMENT_DYNAMIC(CSellRecordSet, CRecordset)

CSellRecordSet::CSellRecordSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CSellRecordSet)
	m_column1 = 0;
	m_column2 = _T("");
	m_column3 = _T("");
	m_column4 = 0.0;
	m_column5 = 0;
	m_column6 = _T("");
	m_nFields = 7;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CSellRecordSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=售货系统");
}

CString CSellRecordSet::GetDefaultSQL()
{
	return _T("[dbo].[售货记录表]");
}

void CSellRecordSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CSellRecordSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[记录号]"), m_column1);
	RFX_Text(pFX, _T("[商品编号]"), m_column2);
	RFX_Text(pFX, _T("[商品名称]"), m_column3);
	RFX_Double(pFX, _T("[价格]"), m_column4);
	RFX_Long(pFX, _T("[数量]"), m_column5);
	RFX_Text(pFX, _T("[售货员]"), m_column6);
	RFX_Date(pFX, _T("[日期]"), m_column7);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CSellRecordSet diagnostics

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

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