managesearchaccount.cpp

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

// ManageSearchAccount.cpp : implementation file
//

#include "stdafx.h"
#include "CreditCardManagement.h"
#include "ManageSearchAccount.h"

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

/////////////////////////////////////////////////////////////////////////////
// CManageSearchAccount dialog


CManageSearchAccount::CManageSearchAccount(CWnd* pParent /*=NULL*/)
	: CDialog(CManageSearchAccount::IDD, pParent)
{
	//{{AFX_DATA_INIT(CManageSearchAccount)
	m_wYinhanbiaoshi = _T("");
	m_wKaihushijian = COleDateTime::GetCurrentTime();
//	m_wXiaohushijian = COleDateTime::GetCurrentTime();
	m_wQianshu = 0;
	m_wInqishishijian = COleDateTime::GetCurrentTime();
	m_wInZhongzhishijian = COleDateTime::GetCurrentTime();
	m_wZhanghao = _T("");
	m_wInzhanghao = _T("");
	m_wCunkuanlixi = _T("");
	m_wQukuanlixi = _T("");
	//}}AFX_DATA_INIT
}


void CManageSearchAccount::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CManageSearchAccount)
	DDX_Control(pDX, IDC_LIST3, m_wCunqukuaixinxi);
	DDX_Control(pDX, IDC_LIST1, m_wXinyongkaxiaofeixinxi);
	DDX_Text(pDX, IDC_EDIT2, m_wYinhanbiaoshi);
	DDV_MaxChars(pDX, m_wYinhanbiaoshi, 20);
	DDX_Text(pDX, IDC_EDIT4, m_wKaihushijian);
	DDX_Text(pDX, IDC_EDIT5, m_wXiaohushijian);
	DDX_Text(pDX, IDC_EDIT7, m_wQianshu);
	DDV_MinMaxLong(pDX, m_wQianshu, 0, 100000);
	DDX_Text(pDX, IDC_EDIT10, m_wInqishishijian);
	DDX_Text(pDX, IDC_EDIT11, m_wInZhongzhishijian);
	DDX_Text(pDX, IDC_EDIT3, m_wZhanghao);
	DDV_MaxChars(pDX, m_wZhanghao, 18);
	DDX_Text(pDX, IDC_EDIT1, m_wInzhanghao);
	DDV_MaxChars(pDX, m_wInzhanghao, 18);
	DDX_Text(pDX, IDC_EDIT8, m_wCunkuanlixi);
	DDX_Text(pDX, IDC_EDIT9, m_wQukuanlixi);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CManageSearchAccount message handlers

void CManageSearchAccount::OnOK() 
{
	// 管理查询账户操作
	
	char filter[100];
	m_pCSAS=&CSAS;//指向账户文件指针
	UpdateData(TRUE);//传入输入值
    int nItem=0; 
	//初始化CListCtrl_Begin
   m_wXinyongkaxiaofeixinxi.DeleteAllItems();
   for(int dc=0;dc<4;dc++){ m_wXinyongkaxiaofeixinxi.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_wXinyongkaxiaofeixinxi.InsertColumn(0,&lvcolumn);
	        lvcolumn.iSubItem=1;
	        lvcolumn.pszText="信用卡号";
	        m_wXinyongkaxiaofeixinxi.InsertColumn(1,&lvcolumn);
	        lvcolumn.iSubItem=2;
	        lvcolumn.pszText="消费额";
	        m_wXinyongkaxiaofeixinxi.InsertColumn(2,&lvcolumn);
			lvcolumn.pszText="消费时间";
			m_wXinyongkaxiaofeixinxi.InsertColumn(3,&lvcolumn);
	m_wCunqukuaixinxi.DeleteAllItems();
   for( dc=0;dc<3;dc++){ m_wCunqukuaixinxi.DeleteColumn(0);}
            //显示存款+取款+消费时间
		    
	        lvcolumn.mask=LVCF_FMT|LVCF_WIDTH|LVCF_TEXT|LVCF_SUBITEM;
            lvcolumn.fmt=LVCFMT_CENTER;
	        lvcolumn.cx=75;
            lvcolumn.iSubItem=0;
	        lvcolumn.pszText="存款";
	        m_wCunqukuaixinxi.InsertColumn(0,&lvcolumn);
	        lvcolumn.iSubItem=1;
	        lvcolumn.pszText="取款";
	        m_wCunqukuaixinxi.InsertColumn(1,&lvcolumn);
	        lvcolumn.iSubItem=2;
			lvcolumn.pszText="消费时间";
			m_wCunqukuaixinxi.InsertColumn(2,&lvcolumn);
	
	wsprintf(filter,"[账户文件].[账号]='%s'",m_wInzhanghao);
	m_pCSAS->m_strFilter=filter;
	m_pCSAS->m_strFilter+="and";
	m_pCSAS->m_strFilter+="[账户文件].[是否销户]=0";

	m_pCSAS->Open();
	if(m_pCSAS->IsEOF())
	{
		MessageBox("无此账号");
		m_pCSAS->Close();
	}else
	{//没有有账号但无信用卡情况（不许出现这种情况
			//解决方案：开户时一定要开一信用卡
		m_wYinhanbiaoshi=m_pCSAS->m_column1;
        m_wQianshu=m_pCSAS->m_column19;
        m_wZhanghao=m_wInzhanghao;//m_pCSAS->m_column14;
		m_wCunkuanlixi=m_pCSAS->m_column21;
	    m_wQukuanlixi=m_pCSAS->m_column22;
		m_pCSAS->m_strFilter+="and";
		m_pCSAS->m_strFilter+="[账户文件].[账号]=[信用卡文件].[账号]";
        m_pCSAS->m_strFilter+="and";
		m_pCSAS->m_strFilter+="[消费文件].[银行标识]=[信用卡文件].[银行标识]";
        m_pCSAS->m_strFilter+="and";
		m_pCSAS->m_strFilter+="[消费文件].[信用卡号]=[信用卡文件].[信用卡号]";
       // m_pCSAS->m_strFilter+="and";
		//m_pCSAS->m_strFilter+="[账户文件].[是否销户]=0";
		m_pCSAS->Requery();
		if(m_pCSAS->IsEOF())//该账号上无消费纪录
		{
			MessageBox("该账号上无消费纪录");
            m_pCSAS->Close();
		}else//有消费记录
		{
			m_wInzhanghao="";
			COleDateTime* media;
				time_t xiaofeishijian;
			while(!m_pCSAS->IsEOF())
			{
				
				xiaofeishijian=m_pCSAS->m_column6.GetTime();//判时间条件
                 media=new COleDateTime(xiaofeishijian);
				 if((m_wInqishishijian.m_dt < media->m_dt) &&
					 (media->m_dt < m_wInZhongzhishijian.m_dt))
				 {
					  m_wYinhanbiaoshi=m_pCSAS->m_column10;
					  m_wZhanghao=m_pCSAS->m_column16;
                      time_t ee;
					  ee=m_pCSAS->m_column17.GetTime();
					  m_wKaihushijian=COleDateTime::COleDateTime(ee);
					  if(m_pCSAS->m_column25)
					  {
						  time_t r; 
						  r=m_pCSAS->m_column18.GetTime();
					     m_wXiaohushijian=COleDateTime::COleDateTime(r);
					  }

					 
					   m_wQianshu=m_pCSAS->m_column19;
					   m_wCunkuanlixi=m_pCSAS->m_column21;
					   m_wQukuanlixi=m_pCSAS->m_column22;
				   //以时间为条件显示输出
				     LV_ITEM lvitem;
	               lvitem.mask=LVIF_TEXT|LVIF_IMAGE|LVIF_STATE;
	               lvitem.state=0;
	               lvitem.stateMask=0;
				   //插入刷卡机标识
                   nItem=m_wXinyongkaxiaofeixinxi.InsertItem(0,m_pCSAS->m_column8);
				   //插入信用卡号
                   m_wXinyongkaxiaofeixinxi.SetItemText(nItem,1,m_pCSAS->m_column2);
				   //插入消费额
				   CString temp;
	               temp.Format("%d",m_pCSAS->m_column3);
                   m_wXinyongkaxiaofeixinxi.SetItemText(nItem,2,temp);
				   //插入消费时间
				   CString s=m_pCSAS->m_column6.Format("%A,%B%d,%Y");
                   m_wXinyongkaxiaofeixinxi.SetItemText(nItem,3,s); 
                   
				   //m_wCunqukuaixinxi
	               //插入存款
				   
	               temp.Format("%d",m_pCSAS->m_column4);
                   nItem=m_wCunqukuaixinxi.InsertItem(0,temp);
				   //插入取款
				   temp.Format("%d",m_pCSAS->m_column5);
                   m_wCunqukuaixinxi.SetItemText(nItem,1,temp);
				   //插入消费时间
				   s=m_pCSAS->m_column6.Format("%A,%B%d,%Y");
                   m_wCunqukuaixinxi.SetItemText(nItem,2,s); 



				 }
			   
				 media=NULL;
				m_pCSAS->MoveNext();
			}
           
            m_pCSAS->Close();
		}
		UpdateData(FALSE);
	}

	




}