hrset.cpp

本程序实现了vc++访问DAO数据库的功能,对于操作数据库有很大的启发的.

// hrSet.cpp : implementation of the CHrSet class
//

#include "stdafx.h"
#include "hr.h"
#include "hrSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CHrSet implementation

IMPLEMENT_DYNAMIC(CHrSet, CDaoRecordset)

CHrSet::CHrSet(CDaoDatabase* pdb)
	: CDaoRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CHrSet)
	m_name = _T("");
	m_company = _T("");
	m_department = _T("");
	m_duty = _T("");
//	m_indata = (DATE)0;
    m_indata = _T("");
	m_detail = _T("");
	m_ID = _T("");
	m_nFields = 7;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dbOpenDynaset;
}

CString CHrSet::GetDefaultDBName()
{
	return _T("\\human\\hrs.mdb");
}


CString CHrSet::GetDefaultSQL()
{
	return _T("[human]");
}

void CHrSet::DoFieldExchange(CDaoFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CHrSet)
	pFX->SetFieldType(CDaoFieldExchange::outputColumn);
	DFX_Text(pFX, _T("[name]"), m_name);
	DFX_Text(pFX, _T("[company]"), m_company);
	DFX_Text(pFX, _T("[department]"), m_department);
	DFX_Text(pFX, _T("[duty]"), m_duty);
//	DFX_DateTime(pFX, _T("[indata]"), m_indata);
	DFX_Text(pFX, _T("[indata]"), m_indata);
	DFX_Text(pFX, _T("[detail]"), m_detail);
	DFX_Text(pFX, _T("[ID]"), m_ID);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CHrSet diagnostics

#ifdef _DEBUG
void CHrSet::AssertValid() const
{
	CDaoRecordset::AssertValid();
}

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