// WorkerSet.cpp : implementation file
//

#include "stdafx.h"
#include "hrm.h"
#include "WorkerSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CWorkerSet

IMPLEMENT_DYNAMIC(CWorkerSet, CRecordset)

CWorkerSet::CWorkerSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CWorkerSet)
	m_wCID = _T("");
	m_wName = _T("");
	m_w1Department = _T("");
	m_w2Department = _T("");
	m_wSex = _T("");
	m_wPosition = _T("");
	m_wMail = _T("");
	m_wID = _T("");
	m_wBorn = _T("");
	m_wNational = _T("");
	m_wHouseholdAdd = _T("");
	m_wBMarriaged = _T("");
	m_wGraduate = _T("");
	m_wMajor = _T("");
	m_wDegree = _T("");
	m_wPhone = _T("");
	m_wAddress = _T("");
	m_wEmergencyMan = _T("");
	m_wEmergencyCall = _T("");
	m_nFields = 21;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CWorkerSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=HRM");
}

CString CWorkerSet::GetDefaultSQL()
{
	return _T("[dbo].[hrworker]");
}

void CWorkerSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CWorkerSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[wCID]"), m_wCID);
	RFX_Text(pFX, _T("[wName]"), m_wName);
	RFX_Text(pFX, _T("[w1Department]"), m_w1Department);
	RFX_Text(pFX, _T("[w2Department]"), m_w2Department);
	RFX_Text(pFX, _T("[wSex]"), m_wSex);
	RFX_Text(pFX, _T("[wPosition]"), m_wPosition);
	RFX_Text(pFX, _T("[wMail]"), m_wMail);
	RFX_Text(pFX, _T("[wID]"), m_wID);
	RFX_Text(pFX, _T("[wBorn]"), m_wBorn);
	RFX_Text(pFX, _T("[wNational]"), m_wNational);
	RFX_Text(pFX, _T("[wHouseholdAdd]"), m_wHouseholdAdd);
	RFX_Text(pFX, _T("[wBMarriaged]"), m_wBMarriaged);
	RFX_Text(pFX, _T("[wGraduate]"), m_wGraduate);
	RFX_Text(pFX, _T("[wMajor]"), m_wMajor);
	RFX_Text(pFX, _T("[wDegree]"), m_wDegree);
	RFX_Date(pFX, _T("[wGraduateTime]"), m_wGraduateTime);
	RFX_Date(pFX, _T("[wEntrantTime]"), m_wEntrantTime);
	RFX_Text(pFX, _T("[wPhone]"), m_wPhone);
	RFX_Text(pFX, _T("[wAddress]"), m_wAddress);
	RFX_Text(pFX, _T("[wEmergencyMan]"), m_wEmergencyMan);
	RFX_Text(pFX, _T("[wEmergencyCall]"), m_wEmergencyCall);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CWorkerSet diagnostics

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

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