managesearchaccountset.cpp

模拟银行信用卡的业务流程

// ManageSearchAccountSet.cpp : implementation file
//

#include "stdafx.h"
#include "CreditCardManagement.h"
#include "ManageSearchAccountSet.h"

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

/////////////////////////////////////////////////////////////////////////////
// CManageSearchAccountSet

IMPLEMENT_DYNAMIC(CManageSearchAccountSet, CRecordset)

CManageSearchAccountSet::CManageSearchAccountSet(CDatabase* pdb)
	: CRecordset(pdb)
{
	//{{AFX_FIELD_INIT(CManageSearchAccountSet)
	m_column1 = _T("");
	m_column2 = _T("");
	m_column3 = 0;
	m_column4 = 0;
	m_column5 = 0;
	m_column7 = _T("");
	m_column8 = _T("");
	m_column9 = _T("");
	m_column10 = _T("");
	m_column11 = _T("");
	m_column12 = FALSE;
	m_column13 = FALSE;
	m_column14 = _T("");
	m_column15 = _T("");
	m_column16 = _T("");
	m_column19 = 0;
	m_column20 = 0;
	m_column21 = _T("");
	m_column22 = _T("");
	m_column23 = _T("");
	m_column24 = _T("");
    m_column25 = FALSE;
	m_nFields = 25;
	//}}AFX_FIELD_INIT
	m_nDefaultType = dynaset;
}


CString CManageSearchAccountSet::GetDefaultConnect()
{
	return _T("ODBC;DSN=CreditCardManage");
}

CString CManageSearchAccountSet::GetDefaultSQL()
{
	return _T("[消费文件],[信用卡文件],[账户文件]");
}

void CManageSearchAccountSet::DoFieldExchange(CFieldExchange* pFX)
{
	//{{AFX_FIELD_MAP(CManageSearchAccountSet)
	pFX->SetFieldType(CFieldExchange::outputColumn);
	RFX_Text(pFX, _T("[消费文件].[银行标识]"), m_column1);
	RFX_Text(pFX, _T("[消费文件].[信用卡号]"), m_column2);
	RFX_Long(pFX, _T("[消费额]"), m_column3);
	RFX_Long(pFX, _T("[存款]"), m_column4);
	RFX_Long(pFX, _T("[取款]"), m_column5);
	RFX_Date(pFX, _T("[消费时间]"), m_column6);
	RFX_Text(pFX, _T("[消费文件].[身份证号]"), m_column7);
	RFX_Text(pFX, _T("[刷卡机标识]"), m_column8);
	RFX_Text(pFX, _T("[消费文件].[备注]"), m_column9);
	RFX_Text(pFX, _T("[信用卡文件].[银行标识]"), m_column10);
	RFX_Text(pFX, _T("[信用卡文件].[信用卡号]"), m_column11);
	RFX_Bool(pFX, _T("[透支]"), m_column12);
	RFX_Bool(pFX, _T("[挂失]"), m_column13);
	RFX_Text(pFX, _T("[信用卡文件].[账号]"), m_column14);
	RFX_Text(pFX, _T("[信用卡文件].[备注]"), m_column15);
	RFX_Text(pFX, _T("[账户文件].[账号]"), m_column16);
	RFX_Date(pFX, _T("[开户时间]"), m_column17);
	RFX_Date(pFX, _T("[销户时间]"), m_column18);
	RFX_Long(pFX, _T("[钱数]"), m_column19);
	RFX_Int(pFX, _T("[信用度级别]"), m_column20);
	RFX_Text(pFX, _T("[存款利息]"), m_column21);
	RFX_Text(pFX, _T("[透支利息]"), m_column22);
	RFX_Text(pFX, _T("[账户文件].[身份证号]"), m_column23);
	RFX_Text(pFX, _T("[账户文件].[备注]"), m_column24);
    RFX_Bool(pFX, _T("[账户文件].[是否销户]"), m_column25);
	//}}AFX_FIELD_MAP
}

/////////////////////////////////////////////////////////////////////////////
// CManageSearchAccountSet diagnostics

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

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