czgtable.cpp

用数据库ACCESS和VISUAL C++编程

// Czgtable.cpp : implementation file
//

#include "stdafx.h"
#include "new3.h"
#include "Czgtable.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCzgtable

IMPLEMENT_DYNAMIC(CCzgtable, CRecordset)

CCzgtable::CCzgtable(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CCzgtable)
	m_column1 = 0;
	m_bumenID = _T("");
	m_bumenname = _T("");
	m_zhigongID = _T("");
	m_zhigongname = _T("");
	m_gonglinggongzi = 0.0f;
	m_jibengongzi = 0.0f;
	m_kashitimem = 0;
	m_kashitimey = 0;
	m_tifatimem = 0;
	m_tifatimey = 0;
	m_diaochutimem = 0;
	m_diaochutimey = 0;
	m_diaorutimem = 0;
	m_ditorutimey = 0;
	m_sex = _T("");
	m_nFields = 16;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CCzgtable::GetDefaultConnect()
{
	return _T("ODBC;DRIVER=Microsoft Access Driver (*.mdb);DSN='kele';DBQ=gz.mdb"); 
}

CString CCzgtable::GetDefaultSQL()
{
	return _T("[gztable]");
}

void CCzgtable::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CCzgtable)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[编号]"), m_column1);
	RFX_Text(pFX, _T("[bumenID]"), m_bumenID);
	RFX_Text(pFX, _T("[bumenname]"), m_bumenname);
	RFX_Text(pFX, _T("[zhigongID]"), m_zhigongID);
	RFX_Text(pFX, _T("[zhigongname]"), m_zhigongname);
	RFX_Single(pFX, _T("[gonglinggongzi]"), m_gonglinggongzi);
	RFX_Single(pFX, _T("[jibengongzi]"), m_jibengongzi);
	RFX_Long(pFX, _T("[kashitimem]"), m_kashitimem);
	RFX_Long(pFX, _T("[kashitimey]"), m_kashitimey);
	RFX_Long(pFX, _T("[tifatimem]"), m_tifatimem);
	RFX_Long(pFX, _T("[tifatimey]"), m_tifatimey);
	RFX_Long(pFX, _T("[diaochutimem]"), m_diaochutimem);
	RFX_Long(pFX, _T("[diaochutimey]"), m_diaochutimey);
	RFX_Long(pFX, _T("[diaorutimem]"), m_diaorutimem);
	RFX_Long(pFX, _T("[ditorutimey]"), m_ditorutimey);
	RFX_Text(pFX, _T("[sex]"), m_sex);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CCzgtable diagnostics

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

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