// LWorkerSet.cpp : implementation file
//

#include "stdafx.h"
#include "hrm.h"
#include "LWorkerSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CLWorkerSet

IMPLEMENT_DYNAMIC(CLWorkerSet, CRecordset)

CLWorkerSet::CLWorkerSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CLWorkerSet)
	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_wNational = _T("");
	m_wHouseholdAdd = _T("");
	m_wBMarriaged = _T("");
	m_wGraduate = _T("");
	m_wMajor = _T("");
	m_wDegree = _T("");
	m_wLeaveValue = 0;
	m_wLeaveType = _T("");
	m_wPhone = _T("");
	m_wAddress = _T("");
	m_wEmergencyMan = _T("");
	m_wEmergencyCall = _T("");
	m_nFields = 24;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


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

CString CLWorkerSet::GetDefaultSQL()
{
	return _T("[dbo].[hrlworker]");
}

void CLWorkerSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CLWorkerSet)
	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_Date(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_Date(pFX, _T("[wLeaveTime]"), m_wLeaveTime);
	RFX_Long(pFX, _T("[wLeaveValue]"), m_wLeaveValue);
	RFX_Text(pFX, _T("[wLeaveType]"), m_wLeaveType);
	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
}

/////////////////////////////////////////////////////////////////////////////
// CLWorkerSet diagnostics

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

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