managesearchclient.cpp

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

// ManageSearchClient.cpp : implementation file
//

#include "stdafx.h"
#include "CreditCardManagement.h"
#include "ManageSearchClient.h"

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

/////////////////////////////////////////////////////////////////////////////
// CManageSearchClient dialog


CManageSearchClient::CManageSearchClient(CWnd* pParent /*=NULL*/)
	: CDialog(CManageSearchClient::IDD, pParent)
{
	//{{AFX_DATA_INIT(CManageSearchClient)
	m_wInZhanghao = _T("");
	m_wYinhangbiaoshi = _T("");
	m_wOutZhanghao = _T("");
	m_wQianshu = 0;
	m_wYonghuming = _T("");
	m_wZhuzhi = _T("");
	m_wDianhua = _T("");
	m_wXinyongdujibie = 0;
	m_wKaihushijian = COleDateTime::GetCurrentTime();

	m_wBeizhu = _T("");
	//}}AFX_DATA_INIT
}


void CManageSearchClient::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CManageSearchClient)
	DDX_Control(pDX, IDC_LIST1, m_wXinyongkahao);
	DDX_Text(pDX, IDC_EDIT1, m_wInZhanghao);
	DDV_MaxChars(pDX, m_wInZhanghao, 18);
	DDX_Text(pDX, IDC_EDIT2, m_wYinhangbiaoshi);
	DDV_MaxChars(pDX, m_wYinhangbiaoshi, 20);
	DDX_Text(pDX, IDC_EDIT3, m_wOutZhanghao);
	DDV_MaxChars(pDX, m_wOutZhanghao, 18);
	DDX_Text(pDX, IDC_EDIT4, m_wQianshu);
	DDV_MinMaxLong(pDX, m_wQianshu, -5000, 100000);
	DDX_Text(pDX, IDC_EDIT5, m_wYonghuming);
	DDV_MaxChars(pDX, m_wYonghuming, 20);
	DDX_Text(pDX, IDC_EDIT6, m_wZhuzhi);
	DDV_MaxChars(pDX, m_wZhuzhi, 20);
	DDX_Text(pDX, IDC_EDIT7, m_wDianhua);
	DDV_MaxChars(pDX, m_wDianhua, 18);
	DDX_Text(pDX, IDC_EDIT9, m_wXinyongdujibie);
	DDV_MinMaxInt(pDX, m_wXinyongdujibie, 0, 2);
	DDX_Text(pDX, IDC_EDIT10, m_wKaihushijian);
	DDX_Text(pDX, IDC_EDIT11, m_wXiaohushijian);
	DDX_Text(pDX, IDC_EDIT8, m_wBeizhu);
	DDV_MaxChars(pDX, m_wBeizhu, 100);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CManageSearchClient, CDialog)
	//{{AFX_MSG_MAP(CManageSearchClient)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CManageSearchClient message handlers

void CManageSearchClient::OnOK() 
{
	// 管理查询客户操作
	
    m_pCMSCS1=&CMSCS1;//指向账户用户信用卡文件的指针
	char filter[100];
	UpdateData(TRUE);//传入查询条件
	m_wXinyongkahao.DeleteAllItems();
    int nItem=0;
	 for(int dc=0;dc<5;dc++){ m_wXinyongkahao.DeleteColumn(0);}
    
	    //显示银行标识+账号+信用卡号+是否透支+是否挂失
		 LV_COLUMN lvcolumn;
	        lvcolumn.mask=LVCF_FMT|LVCF_WIDTH|LVCF_TEXT|LVCF_SUBITEM;
            lvcolumn.fmt=LVCFMT_CENTER;
	        lvcolumn.cx=75;
            lvcolumn.iSubItem=0;
	        lvcolumn.pszText="银行标识";
	        m_wXinyongkahao.InsertColumn(0,&lvcolumn);
            lvcolumn.iSubItem=1;
	        lvcolumn.pszText="帐号";
	        m_wXinyongkahao.InsertColumn(1,&lvcolumn);
	        lvcolumn.iSubItem=2;
	        lvcolumn.pszText="信用卡号";
	        m_wXinyongkahao.InsertColumn(2,&lvcolumn);
	        lvcolumn.iSubItem=3;
	        lvcolumn.pszText="是否透支";
	        m_wXinyongkahao.InsertColumn(3,&lvcolumn);
		    lvcolumn.iSubItem=4;
			lvcolumn.pszText="是否挂失";
			m_wXinyongkahao.InsertColumn(4,&lvcolumn);
	

	m_pCMSCS1->m_strFilter="[账户文件].[身份证号]=[用户文件].[身份证号]";
    m_pCMSCS1->m_strFilter+="and";
    m_pCMSCS1->m_strFilter+="[信用卡文件].[账号]=[账户文件].[账号]";
    m_pCMSCS1->m_strFilter+="and";
	wsprintf(filter,"[账户文件].[账号]='%s'",m_wInZhanghao);
	m_pCMSCS1->m_strFilter+=filter;
	//m_pCMSCS1->m_strFilter+="and";
	//m_pCMSCS1->m_strFilter+="[账户文件].[是否销户]=0";

	m_pCMSCS1->Open();
	if(m_pCMSCS1->IsEOF())//无效账号
	{
		MessageBox("该账号不存在");
		m_pCMSCS1->Close();
	}else//有效账号
	{
		 	m_wInZhanghao = "";//传出值
	m_wYinhangbiaoshi = m_pCMSCS1->m_column1;
	m_wOutZhanghao = m_pCMSCS1->m_column13 ;
	m_wQianshu = m_pCMSCS1->m_column16;
	m_wYonghuming = m_pCMSCS1->m_column8 ;
	m_wZhuzhi =m_pCMSCS1->m_column10 ;
	m_wDianhua =m_pCMSCS1->m_column11 ;
	m_wXinyongdujibie = m_pCMSCS1->m_column17;

	time_t tt= 	m_pCMSCS1->m_column14.GetTime();
	m_wKaihushijian = COleDateTime::COleDateTime(tt);
   if(m_pCMSCS1->m_column22)
	{
	time_t tt1;
		tt1=m_pCMSCS1->m_column15.GetTime();
	m_wXiaohushijian = COleDateTime::COleDateTime(tt1);
	}
	m_wBeizhu =  m_pCMSCS1->m_column6;

     while (!m_pCMSCS1->IsEOF())
	 {
	      //显示
		           LV_ITEM lvitem;
	               lvitem.mask=LVIF_TEXT|LVIF_IMAGE|LVIF_STATE;
	               lvitem.state=0;
	               lvitem.stateMask=0;
				   //插入银行标识
                   nItem=m_wXinyongkahao.InsertItem(0, m_pCMSCS1->m_column1);
				   //插入帐号
                   m_wXinyongkahao.SetItemText(nItem,1, m_pCMSCS1->m_column13);
				   //插入信用卡号
                   m_wXinyongkahao.SetItemText(nItem,2, m_pCMSCS1->m_column2);
				   //插入是否透支
				   CString temp;
	               if (m_pCMSCS1->m_column3==0) temp="否";
				   else temp="是";
                   m_wXinyongkahao.SetItemText(nItem,3,temp);
				   //插入是否挂失
				   if (m_pCMSCS1->m_column4==0) temp="否";
				   else temp="是";
                   m_wXinyongkahao.SetItemText(nItem,4,temp); 
				   m_pCMSCS1->MoveNext();
	 }
	
	
	UpdateData(FALSE);
     m_pCMSCS1->Close();
	}
}