gzdzb.cpp

vc++6.0与orcale的连接及对orcale数据库数据的提取

// Gzdzb.cpp : implementation file
//

#include "stdafx.h"
#include "Chbhf.h"
#include "Gzdzb.h"

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

/////////////////////////////////////////////////////////////////////////////
// CGzdzb

IMPLEMENT_DYNAMIC(CGzdzb, CRecordset)

CGzdzb::CGzdzb(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CGzdzb)
	m_SLBH = _T("");
	m_QYMC = _T("");
	m_NSSBH = _T("");
	m_WJBH = _T("");
	m_CBSX = _T("");
	m_ZLFS = _T("");
	m_SLR = _T("");
	m_CDR = _T("");
	m_JSR = _T("");
	m_SBYSSJ = _T("");
	m_TZFS = _T("");
	m_PTZR = _T("");
	m_JBR = _T("");
	m_LQR = _T("");
	m_JLR = _T("");
	m_BZ = _T("");
	m_YSBZ = _T("");
	m_LXDH = _T("");
	m_nFields = 24;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


CString CGzdzb::GetDefaultConnect()
{
	return _T("ODBC;DSN=wssl");
}

CString CGzdzb::GetDefaultSQL()
{
	return _T("[USER_WSSL].[TBL_GZDZB]");
}

void CGzdzb::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CGzdzb)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[SLBH]"), m_SLBH);
	RFX_Text(pFX, _T("[QYMC]"), m_QYMC);
	RFX_Text(pFX, _T("[NSSBH]"), m_NSSBH);
	RFX_Text(pFX, _T("[WJBH]"), m_WJBH);
	RFX_Text(pFX, _T("[CBSX]"), m_CBSX);
	RFX_Text(pFX, _T("[ZLFS]"), m_ZLFS);
	RFX_Date(pFX, _T("[SLSJ]"), m_SLSJ);
	RFX_Text(pFX, _T("[SLR]"), m_SLR);
	RFX_Date(pFX, _T("[CBJJSJ]"), m_CBJJSJ);
	RFX_Date(pFX, _T("[WCSJ]"), m_WCSJ);
	RFX_Date(pFX, _T("[YJCKSJ]"), m_YJCKSJ);
	RFX_Text(pFX, _T("[CDR]"), m_CDR);
	RFX_Text(pFX, _T("[JSR]"), m_JSR);
	RFX_Text(pFX, _T("[SBYSSJ]"), m_SBYSSJ);
	RFX_Text(pFX, _T("[TZFS]"), m_TZFS);
	RFX_Text(pFX, _T("[PTZR]"), m_PTZR);
	RFX_Date(pFX, _T("[HFWSSJ]"), m_HFWSSJ);
	RFX_Text(pFX, _T("[JBR]"), m_JBR);
	RFX_Text(pFX, _T("[LQR]"), m_LQR);
	RFX_Text(pFX, _T("[JLR]"), m_JLR);
	RFX_Date(pFX, _T("[LRSJ]"), m_LRSJ);
	RFX_Text(pFX, _T("[BZ]"), m_BZ);
	RFX_Text(pFX, _T("[YSBZ]"), m_YSBZ);
	RFX_Text(pFX, _T("[LXDH]"), m_LXDH);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CGzdzb diagnostics

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

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