gzdfb.cpp

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

// Gzdfb.cpp : implementation file
//

#include "stdafx.h"
#include "Chbhf.h"
#include "Gzdfb.h"

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

/////////////////////////////////////////////////////////////////////////////
// CGzdfb

IMPLEMENT_DYNAMIC(CGzdfb, CRecordset)

CGzdfb::CGzdfb(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CGzdfb)
	m_SLBH = _T("");
	m_CBBM1 = _T("");
	m_JSR1 = _T("");
	m_CBNR1 = _T("");
	m_CBJG1 = _T("");
	m_CBR1 = _T("");
	m_CDR1 = _T("");
	m_CSTS1 = _T("");
	m_YSSPR1 = _T("");
	m_BZ1 = _T("");
	m_CBBM2 = _T("");
	m_JSR2 = _T("");
	m_CBNR2 = _T("");
	m_CBJG2 = _T("");
	m_CBR2 = _T("");
	m_CDR2 = _T("");
	m_CSTS2 = _T("");
	m_YSSPR2 = _T("");
	m_BZ2 = _T("");
	m_CBBM3 = _T("");
	m_JSR3 = _T("");
	m_CBNR3 = _T("");
	m_CBJG3 = _T("");
	m_CBR3 = _T("");
	m_CDR3 = _T("");
	m_CSTS3 = _T("");
	m_YSSPR3 = _T("");
	m_BZ3 = _T("");
	m_CBBM4 = _T("");
	m_JSR4 = _T("");
	m_CBNR4 = _T("");
	m_CBJG4 = _T("");
	m_CBR4 = _T("");
	m_CDR4 = _T("");
	m_CSTS4 = _T("");
	m_YSSPR4 = _T("");
	m_BZ4 = _T("");
	m_CBBM5 = _T("");
	m_JSR5 = _T("");
	m_CBNR5 = _T("");
	m_CBJG5 = _T("");
	m_CBR5 = _T("");
	m_CDR5 = _T("");
	m_CSTS5 = _T("");
	m_YSSPR5 = _T("");
	m_BZ5 = _T("");
	m_CBBM6 = _T("");
	m_JSR6 = _T("");
	m_CBNR6 = _T("");
	m_CBJG6 = _T("");
	m_CBR6 = _T("");
	m_CDR6 = _T("");
	m_CSTS6 = _T("");
	m_YSSPR6 = _T("");
	m_BZ6 = _T("");
	m_CBBM7 = _T("");
	m_JSR7 = _T("");
	m_CBNR7 = _T("");
	m_CBJG7 = _T("");
	m_CBR7 = _T("");
	m_CDR7 = _T("");
	m_CSTS7 = _T("");
	m_YSSPR7 = _T("");
	m_BZ7 = _T("");
	m_CBBM8 = _T("");
	m_JSR8 = _T("");
	m_CBNR8 = _T("");
	m_CBJG8 = _T("");
	m_CBR8 = _T("");
	m_CDR8 = _T("");
	m_CSTS8 = _T("");
	m_YSSPR8 = _T("");
	m_BZ8 = _T("");
	m_CBBM9 = _T("");
	m_JSR9 = _T("");
	m_CBNR9 = _T("");
	m_CBJG9 = _T("");
	m_CBR9 = _T("");
	m_CDR9 = _T("");
	m_CSTS9 = _T("");
	m_YSSPR9 = _T("");
	m_BZ9 = _T("");
	m_CBBM10 = _T("");
	m_JSR10 = _T("");
	m_CBNR10 = _T("");
	m_CBJG10 = _T("");
	m_CBR10 = _T("");
	m_CDR10 = _T("");
	m_CSTS10 = _T("");
	m_YSSPR10 = _T("");
	m_BZ10 = _T("");
	m_CBBM11 = _T("");
	m_JSR11 = _T("");
	m_CBNR11 = _T("");
	m_CBJG11 = _T("");
	m_CBR11 = _T("");
	m_CDR11 = _T("");
	m_CSTS11 = _T("");
	m_YSSPR11 = _T("");
	m_BZ11 = _T("");
	m_CBBM12 = _T("");
	m_JSR12 = _T("");
	m_CBNR12 = _T("");
	m_CBJG12 = _T("");
	m_CBR12 = _T("");
	m_CDR12 = _T("");
	m_CSTS12 = _T("");
	m_YSSPR12 = _T("");
	m_BZ12 = _T("");
	m_CBBM13 = _T("");
	m_JSR13 = _T("");
	m_CBNR13 = _T("");
	m_CBJG13 = _T("");
	m_CBR13 = _T("");
	m_CDR13 = _T("");
	m_CSTS13 = _T("");
	m_YSSPR13 = _T("");
	m_BZ13 = _T("");
	m_CBBM14 = _T("");
	m_JSR14 = _T("");
	m_CBNR14 = _T("");
	m_CBJG14 = _T("");
	m_CBR14 = _T("");
	m_CDR14 = _T("");
	m_CSTS14 = _T("");
	m_YSSPR14 = _T("");
	m_BZ14 = _T("");
	m_CBBM15 = _T("");
	m_JSR15 = _T("");
	m_CBNR15 = _T("");
	m_CBJG15 = _T("");
	m_CBR15 = _T("");
	m_CDR15 = _T("");
	m_CSTS15 = _T("");
	m_YSSPR15 = _T("");
	m_BZ15 = _T("");
	m_WCBZ = _T("");
	m_SLBM = _T("");
	m_CBR = _T("");
	m_WCBM = _T("");
	m_CQTS = _T("");
	m_nFields = 203;
	//}}AFX_FIELD_INIT
	m_nDefaultType = snapshot;
}


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

CString CGzdfb::GetDefaultSQL()
{
	return _T("[USER_WSSL].[TBL_GZDFB]");
}

void CGzdfb::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CGzdfb)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[SLBH]"), m_SLBH);
	RFX_Text(pFX, _T("[CBBM1]"), m_CBBM1);
	RFX_Date(pFX, _T("[YDWCSJ1]"), m_YDWCSJ1);
	RFX_Date(pFX, _T("[JSSJ1]"), m_JSSJ1);
	RFX_Text(pFX, _T("[JSR1]"), m_JSR1);
	RFX_Text(pFX, _T("[CBNR1]"), m_CBNR1);
	RFX_Text(pFX, _T("[CBJG1]"), m_CBJG1);
	RFX_Text(pFX, _T("[CBR1]"), m_CBR1);
	RFX_Date(pFX, _T("[WCSJ1]"), m_WCSJ1);
	RFX_Text(pFX, _T("[CDR1]"), m_CDR1);
	RFX_Text(pFX, _T("[CSTS1]"), m_CSTS1);
	RFX_Date(pFX, _T("[CSSJ1]"), m_CSSJ1);
	RFX_Text(pFX, _T("[YSSPR1]"), m_YSSPR1);
	RFX_Text(pFX, _T("[BZ1]"), m_BZ1);
	RFX_Text(pFX, _T("[CBBM2]"), m_CBBM2);
	RFX_Date(pFX, _T("[YDWCSJ2]"), m_YDWCSJ2);
	RFX_Date(pFX, _T("[JSSJ2]"), m_JSSJ2);
	RFX_Text(pFX, _T("[JSR2]"), m_JSR2);
	RFX_Text(pFX, _T("[CBNR2]"), m_CBNR2);
	RFX_Text(pFX, _T("[CBJG2]"), m_CBJG2);
	RFX_Text(pFX, _T("[CBR2]"), m_CBR2);
	RFX_Date(pFX, _T("[WCSJ2]"), m_WCSJ2);
	RFX_Text(pFX, _T("[CDR2]"), m_CDR2);
	RFX_Text(pFX, _T("[CSTS2]"), m_CSTS2);
	RFX_Date(pFX, _T("[CSSJ2]"), m_CSSJ2);
	RFX_Text(pFX, _T("[YSSPR2]"), m_YSSPR2);
	RFX_Text(pFX, _T("[BZ2]"), m_BZ2);
	RFX_Text(pFX, _T("[CBBM3]"), m_CBBM3);
	RFX_Date(pFX, _T("[YDWCSJ3]"), m_YDWCSJ3);
	RFX_Date(pFX, _T("[JSSJ3]"), m_JSSJ3);
	RFX_Text(pFX, _T("[JSR3]"), m_JSR3);
	RFX_Text(pFX, _T("[CBNR3]"), m_CBNR3);
	RFX_Text(pFX, _T("[CBJG3]"), m_CBJG3);
	RFX_Text(pFX, _T("[CBR3]"), m_CBR3);
	RFX_Date(pFX, _T("[WCSJ3]"), m_WCSJ3);
	RFX_Text(pFX, _T("[CDR3]"), m_CDR3);
	RFX_Text(pFX, _T("[CSTS3]"), m_CSTS3);
	RFX_Date(pFX, _T("[CSSJ3]"), m_CSSJ3);
	RFX_Text(pFX, _T("[YSSPR3]"), m_YSSPR3);
	RFX_Text(pFX, _T("[BZ3]"), m_BZ3);
	RFX_Text(pFX, _T("[CBBM4]"), m_CBBM4);
	RFX_Date(pFX, _T("[YDWCSJ4]"), m_YDWCSJ4);
	RFX_Date(pFX, _T("[JSSJ4]"), m_JSSJ4);
	RFX_Text(pFX, _T("[JSR4]"), m_JSR4);
	RFX_Text(pFX, _T("[CBNR4]"), m_CBNR4);
	RFX_Text(pFX, _T("[CBJG4]"), m_CBJG4);
	RFX_Text(pFX, _T("[CBR4]"), m_CBR4);
	RFX_Date(pFX, _T("[WCSJ4]"), m_WCSJ4);
	RFX_Text(pFX, _T("[CDR4]"), m_CDR4);
	RFX_Text(pFX, _T("[CSTS4]"), m_CSTS4);
	RFX_Date(pFX, _T("[CSSJ4]"), m_CSSJ4);
	RFX_Text(pFX, _T("[YSSPR4]"), m_YSSPR4);
	RFX_Text(pFX, _T("[BZ4]"), m_BZ4);
	RFX_Text(pFX, _T("[CBBM5]"), m_CBBM5);
	RFX_Date(pFX, _T("[YDWCSJ5]"), m_YDWCSJ5);
	RFX_Date(pFX, _T("[JSSJ5]"), m_JSSJ5);
	RFX_Text(pFX, _T("[JSR5]"), m_JSR5);
	RFX_Text(pFX, _T("[CBNR5]"), m_CBNR5);
	RFX_Text(pFX, _T("[CBJG5]"), m_CBJG5);
	RFX_Text(pFX, _T("[CBR5]"), m_CBR5);
	RFX_Date(pFX, _T("[WCSJ5]"), m_WCSJ5);
	RFX_Text(pFX, _T("[CDR5]"), m_CDR5);
	RFX_Text(pFX, _T("[CSTS5]"), m_CSTS5);
	RFX_Date(pFX, _T("[CSSJ5]"), m_CSSJ5);
	RFX_Text(pFX, _T("[YSSPR5]"), m_YSSPR5);
	RFX_Text(pFX, _T("[BZ5]"), m_BZ5);
	RFX_Text(pFX, _T("[CBBM6]"), m_CBBM6);
	RFX_Date(pFX, _T("[YDWCSJ6]"), m_YDWCSJ6);
	RFX_Date(pFX, _T("[JSSJ6]"), m_JSSJ6);
	RFX_Text(pFX, _T("[JSR6]"), m_JSR6);
	RFX_Text(pFX, _T("[CBNR6]"), m_CBNR6);
	RFX_Text(pFX, _T("[CBJG6]"), m_CBJG6);
	RFX_Text(pFX, _T("[CBR6]"), m_CBR6);
	RFX_Date(pFX, _T("[WCSJ6]"), m_WCSJ6);
	RFX_Text(pFX, _T("[CDR6]"), m_CDR6);
	RFX_Text(pFX, _T("[CSTS6]"), m_CSTS6);
	RFX_Date(pFX, _T("[CSSJ6]"), m_CSSJ6);
	RFX_Text(pFX, _T("[YSSPR6]"), m_YSSPR6);
	RFX_Text(pFX, _T("[BZ6]"), m_BZ6);
	RFX_Text(pFX, _T("[CBBM7]"), m_CBBM7);
	RFX_Date(pFX, _T("[YDWCSJ7]"), m_YDWCSJ7);
	RFX_Date(pFX, _T("[JSSJ7]"), m_JSSJ7);
	RFX_Text(pFX, _T("[JSR7]"), m_JSR7);
	RFX_Text(pFX, _T("[CBNR7]"), m_CBNR7);
	RFX_Text(pFX, _T("[CBJG7]"), m_CBJG7);
	RFX_Text(pFX, _T("[CBR7]"), m_CBR7);
	RFX_Date(pFX, _T("[WCSJ7]"), m_WCSJ7);
	RFX_Text(pFX, _T("[CDR7]"), m_CDR7);
	RFX_Text(pFX, _T("[CSTS7]"), m_CSTS7);
	RFX_Date(pFX, _T("[CSSJ7]"), m_CSSJ7);
	RFX_Text(pFX, _T("[YSSPR7]"), m_YSSPR7);
	RFX_Text(pFX, _T("[BZ7]"), m_BZ7);
	RFX_Text(pFX, _T("[CBBM8]"), m_CBBM8);
	RFX_Date(pFX, _T("[YDWCSJ8]"), m_YDWCSJ8);
	RFX_Date(pFX, _T("[JSSJ8]"), m_JSSJ8);
	RFX_Text(pFX, _T("[JSR8]"), m_JSR8);
	RFX_Text(pFX, _T("[CBNR8]"), m_CBNR8);
	RFX_Text(pFX, _T("[CBJG8]"), m_CBJG8);
	RFX_Text(pFX, _T("[CBR8]"), m_CBR8);
	RFX_Date(pFX, _T("[WCSJ8]"), m_WCSJ8);
	RFX_Text(pFX, _T("[CDR8]"), m_CDR8);
	RFX_Text(pFX, _T("[CSTS8]"), m_CSTS8);
	RFX_Date(pFX, _T("[CSSJ8]"), m_CSSJ8);
	RFX_Text(pFX, _T("[YSSPR8]"), m_YSSPR8);
	RFX_Text(pFX, _T("[BZ8]"), m_BZ8);
	RFX_Text(pFX, _T("[CBBM9]"), m_CBBM9);
	RFX_Date(pFX, _T("[YDWCSJ9]"), m_YDWCSJ9);
	RFX_Date(pFX, _T("[JSSJ9]"), m_JSSJ9);
	RFX_Text(pFX, _T("[JSR9]"), m_JSR9);
	RFX_Text(pFX, _T("[CBNR9]"), m_CBNR9);
	RFX_Text(pFX, _T("[CBJG9]"), m_CBJG9);
	RFX_Text(pFX, _T("[CBR9]"), m_CBR9);
	RFX_Date(pFX, _T("[WCSJ9]"), m_WCSJ9);
	RFX_Text(pFX, _T("[CDR9]"), m_CDR9);
	RFX_Text(pFX, _T("[CSTS9]"), m_CSTS9);
	RFX_Date(pFX, _T("[CSSJ9]"), m_CSSJ9);
	RFX_Text(pFX, _T("[YSSPR9]"), m_YSSPR9);
	RFX_Text(pFX, _T("[BZ9]"), m_BZ9);
	RFX_Text(pFX, _T("[CBBM10]"), m_CBBM10);
	RFX_Date(pFX, _T("[YDWCSJ10]"), m_YDWCSJ10);
	RFX_Date(pFX, _T("[JSSJ10]"), m_JSSJ10);
	RFX_Text(pFX, _T("[JSR10]"), m_JSR10);
	RFX_Text(pFX, _T("[CBNR10]"), m_CBNR10);
	RFX_Text(pFX, _T("[CBJG10]"), m_CBJG10);
	RFX_Text(pFX, _T("[CBR10]"), m_CBR10);
	RFX_Date(pFX, _T("[WCSJ10]"), m_WCSJ10);
	RFX_Text(pFX, _T("[CDR10]"), m_CDR10);
	RFX_Text(pFX, _T("[CSTS10]"), m_CSTS10);
	RFX_Date(pFX, _T("[CSSJ10]"), m_CSSJ10);
	RFX_Text(pFX, _T("[YSSPR10]"), m_YSSPR10);
	RFX_Text(pFX, _T("[BZ10]"), m_BZ10);
	RFX_Text(pFX, _T("[CBBM11]"), m_CBBM11);
	RFX_Date(pFX, _T("[YDWCSJ11]"), m_YDWCSJ11);
	RFX_Date(pFX, _T("[JSSJ11]"), m_JSSJ11);
	RFX_Text(pFX, _T("[JSR11]"), m_JSR11);
	RFX_Text(pFX, _T("[CBNR11]"), m_CBNR11);
	RFX_Text(pFX, _T("[CBJG11]"), m_CBJG11);
	RFX_Text(pFX, _T("[CBR11]"), m_CBR11);
	RFX_Date(pFX, _T("[WCSJ11]"), m_WCSJ11);
	RFX_Text(pFX, _T("[CDR11]"), m_CDR11);
	RFX_Text(pFX, _T("[CSTS11]"), m_CSTS11);
	RFX_Date(pFX, _T("[CSSJ11]"), m_CSSJ11);
	RFX_Text(pFX, _T("[YSSPR11]"), m_YSSPR11);
	RFX_Text(pFX, _T("[BZ11]"), m_BZ11);
	RFX_Text(pFX, _T("[CBBM12]"), m_CBBM12);
	RFX_Date(pFX, _T("[YDWCSJ12]"), m_YDWCSJ12);
	RFX_Date(pFX, _T("[JSSJ12]"), m_JSSJ12);
	RFX_Text(pFX, _T("[JSR12]"), m_JSR12);
	RFX_Text(pFX, _T("[CBNR12]"), m_CBNR12);
	RFX_Text(pFX, _T("[CBJG12]"), m_CBJG12);
	RFX_Text(pFX, _T("[CBR12]"), m_CBR12);
	RFX_Date(pFX, _T("[WCSJ12]"), m_WCSJ12);
	RFX_Text(pFX, _T("[CDR12]"), m_CDR12);
	RFX_Text(pFX, _T("[CSTS12]"), m_CSTS12);
	RFX_Date(pFX, _T("[CSSJ12]"), m_CSSJ12);
	RFX_Text(pFX, _T("[YSSPR12]"), m_YSSPR12);
	RFX_Text(pFX, _T("[BZ12]"), m_BZ12);
	RFX_Text(pFX, _T("[CBBM13]"), m_CBBM13);
	RFX_Date(pFX, _T("[YDWCSJ13]"), m_YDWCSJ13);
	RFX_Date(pFX, _T("[JSSJ13]"), m_JSSJ13);
	RFX_Text(pFX, _T("[JSR13]"), m_JSR13);
	RFX_Text(pFX, _T("[CBNR13]"), m_CBNR13);
	RFX_Text(pFX, _T("[CBJG13]"), m_CBJG13);
	RFX_Text(pFX, _T("[CBR13]"), m_CBR13);
	RFX_Date(pFX, _T("[WCSJ13]"), m_WCSJ13);
	RFX_Text(pFX, _T("[CDR13]"), m_CDR13);
	RFX_Text(pFX, _T("[CSTS13]"), m_CSTS13);
	RFX_Date(pFX, _T("[CSSJ13]"), m_CSSJ13);
	RFX_Text(pFX, _T("[YSSPR13]"), m_YSSPR13);
	RFX_Text(pFX, _T("[BZ13]"), m_BZ13);
	RFX_Text(pFX, _T("[CBBM14]"), m_CBBM14);
	RFX_Date(pFX, _T("[YDWCSJ14]"), m_YDWCSJ14);
	RFX_Date(pFX, _T("[JSSJ14]"), m_JSSJ14);
	RFX_Text(pFX, _T("[JSR14]"), m_JSR14);
	RFX_Text(pFX, _T("[CBNR14]"), m_CBNR14);
	RFX_Text(pFX, _T("[CBJG14]"), m_CBJG14);
	RFX_Text(pFX, _T("[CBR14]"), m_CBR14);
	RFX_Date(pFX, _T("[WCSJ14]"), m_WCSJ14);
	RFX_Text(pFX, _T("[CDR14]"), m_CDR14);
	RFX_Text(pFX, _T("[CSTS14]"), m_CSTS14);
	RFX_Date(pFX, _T("[CSSJ14]"), m_CSSJ14);
	RFX_Text(pFX, _T("[YSSPR14]"), m_YSSPR14);
	RFX_Text(pFX, _T("[BZ14]"), m_BZ14);
	RFX_Text(pFX, _T("[CBBM15]"), m_CBBM15);
	RFX_Date(pFX, _T("[YDWCSJ15]"), m_YDWCSJ15);
	RFX_Date(pFX, _T("[JSSJ15]"), m_JSSJ15);
	RFX_Text(pFX, _T("[JSR15]"), m_JSR15);
	RFX_Text(pFX, _T("[CBNR15]"), m_CBNR15);
	RFX_Text(pFX, _T("[CBJG15]"), m_CBJG15);
	RFX_Text(pFX, _T("[CBR15]"), m_CBR15);
	RFX_Date(pFX, _T("[WCSJ15]"), m_WCSJ15);
	RFX_Text(pFX, _T("[CDR15]"), m_CDR15);
	RFX_Text(pFX, _T("[CSTS15]"), m_CSTS15);
	RFX_Date(pFX, _T("[CSSJ15]"), m_CSSJ15);
	RFX_Text(pFX, _T("[YSSPR15]"), m_YSSPR15);
	RFX_Text(pFX, _T("[BZ15]"), m_BZ15);
	RFX_Text(pFX, _T("[WCBZ]"), m_WCBZ);
	RFX_Text(pFX, _T("[SLBM]"), m_SLBM);
	RFX_Date(pFX, _T("[SLSJ]"), m_SLSJ);
	RFX_Text(pFX, _T("[CBR]"), m_CBR);
	RFX_Text(pFX, _T("[WCBM]"), m_WCBM);
	RFX_Text(pFX, _T("[CQTS]"), m_CQTS);
	RFX_Date(pFX, _T("[JSSJ]"), m_JSSJ);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CGzdfb diagnostics

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

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