mkjcset.cpp

ado封装类,adoconn,用法有具体实例,包括查询数据库,列表显示等

// MKJCSet.cpp : implementation of the CMKJCSet class
//

#include "stdafx.h"
#include "MKJC.h"
#include "MKJCSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CMKJCSet implementation

IMPLEMENT_DYNAMIC(CMKJCSet, CRecordset)

CMKJCSet::CMKJCSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CMKJCSet)
	m_ID = 0;
	m_GDID = _T("");
	m_GDWS = 0.0f;
	m_GDHS = 0.0f;
	m_GDWD = 0.0f;
	m_GDWZ = _T("");
	m_GDSJ = 0;
	m_ID2 = 0;
	m_YDID = _T("");
	m_YDXM = _T("");
	m_YDTW = 0.0f;
	m_YDMB = 0;
	m_YDWZ = _T("");
	m_YDWZ_X = 0.0f;
	m_YDWZ_Y = 0.0f;
	m_YDSJ = 0;
	m_number = _T("");
	m_name = _T("");
	m_password = _T("");
	m_level = 0;
	m_nFields = 20;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}

CString CMKJCSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=MKJC");
}

CString CMKJCSet::GetDefaultSQL()
{
	return _T("[GDJD],[YDJD],[登陆]");
}

void CMKJCSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CMKJCSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Long(pFX, _T("[GDJD].[ID]"), m_ID);
	RFX_Text(pFX, _T("[GDID]"), m_GDID);
	RFX_Single(pFX, _T("[GDWS]"), m_GDWS);
	RFX_Single(pFX, _T("[GDHS]"), m_GDHS);
	RFX_Single(pFX, _T("[GDWD]"), m_GDWD);
	RFX_Text(pFX, _T("[GDWZ]"), m_GDWZ);
	RFX_Date(pFX, _T("[GDSJ]"), m_GDSJ);
	RFX_Long(pFX, _T("[YDJD].[ID]"), m_ID2);
	RFX_Text(pFX, _T("[YDID]"), m_YDID);
	RFX_Text(pFX, _T("[YDXM]"), m_YDXM);
	RFX_Single(pFX, _T("[YDTW]"), m_YDTW);
	RFX_Long(pFX, _T("[YDMB]"), m_YDMB);
	RFX_Text(pFX, _T("[YDWZ]"), m_YDWZ);
	RFX_Single(pFX, _T("[YDWZ_X]"), m_YDWZ_X);
	RFX_Single(pFX, _T("[YDWZ_Y]"), m_YDWZ_Y);
	RFX_Date(pFX, _T("[YDSJ]"), m_YDSJ);
	RFX_Text(pFX, _T("[number]"), m_number);
	RFX_Text(pFX, _T("[name]"), m_name);
	RFX_Text(pFX, _T("[password]"), m_password);
	RFX_Long(pFX, _T("[level]"), m_level);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CMKJCSet diagnostics

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

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