www.pudn.com > VC与ORACLE数据的提取.rar > Gzdfb.cpp

// 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