scoreset.cpp

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

// ScoreSet.cpp : implementation file
//

#include "stdafx.h"
#include "train.h"
#include "ScoreSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CScoreSet

IMPLEMENT_DYNAMIC(CScoreSet, CRecordset)

CScoreSet::CScoreSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CScoreSet)
	m_EMP_NO = 0;
	m_COURSE_ID = 0;
	m_S_PLACE = _T("");
	m_TEACHER_ID = 0;
	m_SCORE_1 = 0;
	m_SCORE_2 = 0;
	m_SCORE_NOTES = _T("");
	m_PASS = 0;
	m_nFields = 9;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


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

CString CScoreSet::GetDefaultSQL()
{
	return _T("[SCORE]");
}

void CScoreSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CScoreSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[EMP_NO]"), m_EMP_NO);
	RFX_Int(pFX, _T("[COURSE_ID]"), m_COURSE_ID);
	RFX_Date(pFX, _T("[S_DATE]"), m_S_DATE);
	RFX_Text(pFX, _T("[S_PLACE]"), m_S_PLACE);
	RFX_Long(pFX, _T("[TEACHER_ID]"), m_TEACHER_ID);
	RFX_Int(pFX, _T("[SCORE_1]"), m_SCORE_1);
	RFX_Int(pFX, _T("[SCORE_2]"), m_SCORE_2);
	RFX_Text(pFX, _T("[SCORE_NOTES]"), m_SCORE_NOTES);
	RFX_Byte(pFX, _T("[PASS]"), m_PASS);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CScoreSet diagnostics

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

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