nsrjbxx.cpp

在VC++中对Orcale数据库的数据进行提取,然后分析,是挖掘的基础!

// Nsrjbxx.cpp : implementation file
//

#include "stdafx.h"
#include "Chbhf.h"
#include "Nsrjbxx.h"

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

/////////////////////////////////////////////////////////////////////////////
// CNsrjbxx

IMPLEMENT_DYNAMIC(CNsrjbxx, CRecordset)

CNsrjbxx::CNsrjbxx(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CNsrjbxx)
	m_LSH = _T("");
	m_WJBH = _T("");
	m_WSLB = _T("");
	m_NSRMC = _T("");
	m_NSRSBH = _T("");
	m_LXDH = _T("");
	m_JBR = _T("");
	m_SFDC = _T("");
	m_SFSBSJ = _T("");
	m_DCBM = _T("");
	m_SLBM = _T("");
	m_SLR = _T("");
	m_FS = _T("");
	m_BZ = _T("");
	m_BZ1 = _T("");
	m_SLBZ = _T("");
	m_SLDL = _T("");
	m_nFields = 20;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


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

CString CNsrjbxx::GetDefaultSQL()
{
	return _T("[USER_WSSL].[TBL_NSRJBXX]");
}

void CNsrjbxx::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CNsrjbxx)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[LSH]"), m_LSH);
	RFX_Text(pFX, _T("[WJBH]"), m_WJBH);
	RFX_Text(pFX, _T("[WSLB]"), m_WSLB);
	RFX_Text(pFX, _T("[NSRMC]"), m_NSRMC);
	RFX_Text(pFX, _T("[NSRSBH]"), m_NSRSBH);
	RFX_Text(pFX, _T("[LXDH]"), m_LXDH);
	RFX_Text(pFX, _T("[JBR]"), m_JBR);
	RFX_Text(pFX, _T("[SFDC]"), m_SFDC);
	RFX_Text(pFX, _T("[SFSBSJ]"), m_SFSBSJ);
	RFX_Text(pFX, _T("[DCBM]"), m_DCBM);
	RFX_Date(pFX, _T("[DCRQ]"), m_DCRQ);
	RFX_Text(pFX, _T("[SLBM]"), m_SLBM);
	RFX_Date(pFX, _T("[SLRQ]"), m_SLRQ);
	RFX_Text(pFX, _T("[SLR]"), m_SLR);
	RFX_Date(pFX, _T("[LQWSRQ]"), m_LQWSRQ);
	RFX_Text(pFX, _T("[FS]"), m_FS);
	RFX_Text(pFX, _T("[BZ]"), m_BZ);
	RFX_Text(pFX, _T("[BZ1]"), m_BZ1);
	RFX_Text(pFX, _T("[SLBZ]"), m_SLBZ);
	RFX_Text(pFX, _T("[SLDL]"), m_SLDL);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CNsrjbxx diagnostics

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

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