personset.cpp

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

// PersonSet.cpp : implementation file
//

#include "stdafx.h"
#include "train.h"
#include "PersonSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CPersonSet

IMPLEMENT_DYNAMIC(CPersonSet, CRecordset)

CPersonSet::CPersonSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CPersonSet)
	m_EMP_NO = 0;
	m_EMP_NAME = _T("");
	m_DEPT_ID = 0;
	m_EMP_XL = _T("");
	m_EMP_GENDER = _T("");
	m_EMP_HOMETOWN = _T("");
	m_EMP_COUNTRY = _T("");
	m_EMP_NATION = _T("");
	m_EMP_ID = _T("");
	m_EMP_MARRIAGE = _T("");
	m_EMP_HEALTH = _T("");
	m_EMP_STATE = _T("");
	m_EMP_HOMEADDRESS = _T("");
	m_EMP_TELENO = _T("");
	m_EMP_EMAIL = _T("");
	m_JOB_ID = 0;
	m_nFields = 19;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


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

CString CPersonSet::GetDefaultSQL()
{
	return _T("[PERSONNEL]");
}

void CPersonSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CPersonSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[EMP_NO]"), m_EMP_NO);
	RFX_Text(pFX, _T("[EMP_NAME]"), m_EMP_NAME);
	RFX_Int(pFX, _T("[DEPT_ID]"), m_DEPT_ID);
	RFX_Text(pFX, _T("[EMP_XL]"), m_EMP_XL);
	RFX_Text(pFX, _T("[EMP_GENDER]"), m_EMP_GENDER);
	RFX_Date(pFX, _T("[EMP_BIRTHDAY]"), m_EMP_BIRTHDAY);
	RFX_Text(pFX, _T("[EMP_HOMETOWN]"), m_EMP_HOMETOWN);
	RFX_Text(pFX, _T("[EMP_COUNTRY]"), m_EMP_COUNTRY);
	RFX_Text(pFX, _T("[EMP_NATION]"), m_EMP_NATION);
	RFX_Text(pFX, _T("[EMP_ID]"), m_EMP_ID);
	RFX_Text(pFX, _T("[EMP_MARRIAGE]"), m_EMP_MARRIAGE);
	RFX_Text(pFX, _T("[EMP_HEALTH]"), m_EMP_HEALTH);
	RFX_Date(pFX, _T("[EMP_STARTWORK]"), m_EMP_STARTWORK);
	RFX_Text(pFX, _T("[EMP_STATE]"), m_EMP_STATE);
	RFX_Date(pFX, _T("[EMP_STATE_DATE]"), m_EMP_STATE_DATE);
	RFX_Text(pFX, _T("[EMP_HOMEADDRESS]"), m_EMP_HOMEADDRESS);
	RFX_Text(pFX, _T("[EMP_TELENO]"), m_EMP_TELENO);
	RFX_Text(pFX, _T("[EMP_EMAIL]"), m_EMP_EMAIL);
	RFX_Int(pFX, _T("[JOB_ID]"), m_JOB_ID);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CPersonSet diagnostics

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

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