// srhSet.cpp : implementation of the CSrhSet class
//

#include "stdafx.h"
#include "srh.h"
#include "srhSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CSrhSet implementation

IMPLEMENT_DYNAMIC(CSrhSet, CRecordset)

CSrhSet::CSrhSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CSrhSet)
	m_column1 = 0;
	m_column2 = _T("");
	m_column3 = 0;
	m_column4 = 0;
	m_column5 = _T("");
	m_column6 = _T("");
	m_column7 = _T("");
	m_column8 = _T("");
	m_column9 = _T("");
	m_column10 = 0;
	m_column11 = _T("");
	m_column12 = FALSE;
	m_column13 = 0;
	m_nFields = 13;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CSrhSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=access");
}

CString CSrhSet::GetDefaultSQL()
{
	return _T("[教師表],[課程表],[選課表],[學生表]");
}

void CSrhSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CSrhSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[教師表].[教師號]"), m_column1);
	RFX_Text(pFX, _T("[教師姓名]"), m_column2);
	RFX_Long(pFX, _T("[所授課程號]"), m_column3);
	RFX_Long(pFX, _T("[課程表].[課程號]"), m_column4);
	RFX_Text(pFX, _T("[課程名]"), m_column5);
	RFX_Text(pFX, _T("[課程表].[教師號]"), m_column6);
	RFX_Text(pFX, _T("[選課表].[學號]"), m_column7);
	RFX_Text(pFX, _T("[選課表].[課程號]"), m_column8);
	RFX_Text(pFX, _T("[成績]"), m_column9);
	RFX_Long(pFX, _T("[學生表].[學號]"), m_column10);
	RFX_Text(pFX, _T("[姓名]"), m_column11);
	RFX_Bool(pFX, _T("[性別]"), m_column12);
	RFX_Long(pFX, _T("[年齡]"), m_column13);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CSrhSet diagnostics

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

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