manageclientmodify1.cpp

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

// ManageClientModify1.cpp : implementation file
//

#include "stdafx.h"
#include "CreditCardManagement.h"
#include "ManageClientModify1.h"

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

/////////////////////////////////////////////////////////////////////////////
// CManageClientModify1 dialog


CManageClientModify1::CManageClientModify1(CWnd* pParent /*=NULL*/)
	: CDialog(CManageClientModify1::IDD, pParent)
{
	//{{AFX_DATA_INIT(CManageClientModify1)
	m_wZhanghao = _T("");
	m_wQianshu = 0;
	m_wYonghuming = _T("");
	m_wDizfhi = _T("");
	m_wDianhua = _T("");
	m_wShenfenzhenghao = _T("");
	m_wXinmima = _T("");
	m_wQueren = _T("");
	m_wBeizhu = _T("");
	m_wKaihushijian = COleDateTime::GetCurrentTime();
	m_wXinyongdujibie = 0;
	m_wMima = _T("");
	m_wKehuzhanghao = _T("");
	//}}AFX_DATA_INIT
}


void CManageClientModify1::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CManageClientModify1)
	DDX_Text(pDX, IDC_EDIT1, m_wZhanghao);
	DDV_MaxChars(pDX, m_wZhanghao, 18);
	DDX_Text(pDX, IDC_EDIT2, m_wQianshu);
	DDV_MinMaxLong(pDX, m_wQianshu, -5000, 100000);
	DDX_Text(pDX, IDC_EDIT3, m_wYonghuming);
	DDV_MaxChars(pDX, m_wYonghuming, 20);
	DDX_Text(pDX, IDC_EDIT4, m_wDizfhi);
	DDV_MaxChars(pDX, m_wDizfhi, 20);
	DDX_Text(pDX, IDC_EDIT5, m_wDianhua);
	DDV_MaxChars(pDX, m_wDianhua, 18);
	DDX_Text(pDX, IDC_EDIT6, m_wShenfenzhenghao);
	DDV_MaxChars(pDX, m_wShenfenzhenghao, 18);
	DDX_Text(pDX, IDC_EDIT7, m_wXinmima);
	DDV_MaxChars(pDX, m_wXinmima, 20);
	DDX_Text(pDX, IDC_EDIT8, m_wQueren);
	DDV_MaxChars(pDX, m_wQueren, 20);
	DDX_Text(pDX, IDC_EDIT9, m_wBeizhu);
	DDV_MaxChars(pDX, m_wBeizhu, 100);
	DDX_Text(pDX, IDC_EDIT10, m_wKaihushijian);
	DDX_Text(pDX, IDC_EDIT11, m_wXinyongdujibie);
	DDV_MinMaxInt(pDX, m_wXinyongdujibie, 0, 2);
	DDX_Text(pDX, IDC_EDIT12, m_wMima);
	DDV_MaxChars(pDX, m_wMima, 20);
	DDX_Text(pDX, IDC_EDIT13, m_wKehuzhanghao);
	DDV_MaxChars(pDX, m_wKehuzhanghao, 18);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CManageClientModify1, CDialog)
	//{{AFX_MSG_MAP(CManageClientModify1)
	ON_BN_CLICKED(IDC_MYBUTTON, OnMyButton)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CManageClientModify1 message handlers

void CManageClientModify1::OnOK() 
{
	// TODO: Add extra validation here
	
	char filter[100];
	UpdateData(TRUE);
	m_pCCMS3=&CCMS3;
	m_pCCMS3->m_strFilter="[用户文件].[身份证号]=[账户文件].[身份证号]";
    m_pCCMS3->m_strFilter+="and";
	wsprintf(filter,"[账户文件].[账号]='%s'",m_wKehuzhanghao);
	m_pCCMS3->m_strFilter+=filter;
	m_pCCMS3->m_strFilter+="and";
	wsprintf(filter,"[用户文件].[密码]='%s'",m_wMima);
	m_pCCMS3->m_strFilter+=filter;
	m_pCCMS3->Open();
	if(m_pCCMS3->IsEOF())
	{
		MessageBox("账户密码不匹配");
		m_pCCMS3->Close();
	}else
	{
		 m_wQianshu=m_pCCMS3->m_column10;
         m_wYonghuming=m_pCCMS3->m_column2;
         //m_wKaihushijian=m_pCCMS3->m_column8;
		 //m_wXiaohushijian=m_pCCMS3->m_column9;
		 m_wShenfenzhenghao=m_pCCMS3->m_column1;
         m_wZhanghao=m_pCCMS3->m_column7;
		 if(m_wXinmima!=m_wQueren)
		 {
			 MessageBox("请重新输入新密码");
			 m_pCCMS3->Close();
		 }else
		 {
			 m_pCCMS3->Close();
			 m_pCCMS3y=&CCMS3y;
			 wsprintf(filter,"[用户文件].[身份证号]='%s'",m_wShenfenzhenghao);
			 m_pCCMS3y->m_strFilter=filter;
             
			 m_pCCMS3y->Open();
			 //m_pCCMS3y->MoveLast();
			 m_pCCMS3y->Edit();
			 m_pCCMS3y->m_column3=m_wXinmima;
			 m_pCCMS3y->m_column4=m_wDizfhi;
             m_pCCMS3y->m_column5= m_wDianhua;
			m_pCCMS3y->m_column6=m_wBeizhu;
			//m_pCCMS3->m_column11=m_wXinyongdujibie;
			if(!m_pCCMS3y->Update())
			{
				MessageBox("更新客户信息失败");
				m_pCCMS3y->Close();
			}else
			{
				MessageBox("更新客户信息成功");
				m_pCCMS3y->Close();
			}
			m_pCCMS3z=&CCMS3z;
			// wsprintf(filter,"[帐户文件].[帐号]='%s'",m_wZhanghao);
			 m_pCCMS3z->m_strFilter.Empty();
			 m_pCCMS3z->Open();
			 while(!m_pCCMS3z->IsEOF())
			 {
				 if(m_pCCMS3z->m_column1==m_wZhanghao)
				 {
			 m_pCCMS3z->Edit();
			 m_pCCMS3z->m_column5=m_wXinyongdujibie;
			 if(!m_pCCMS3z->Update())
			{

				//MessageBox("更新帐户信息失败");
			//m_pCCMS3z->Close();
			}else
			{
				MessageBox("更新帐户信息成功");
				//m_pCCMS3z->Close();
			}
				 }
             m_pCCMS3z->MoveNext();
			 }
            m_pCCMS3z->Close();
			UpdateData(FALSE);
		 }
	}
}

void CManageClientModify1::OnMyButton() 
{
   //显示客户信息
	char filter[100];
	UpdateData(TRUE);
	m_pCCMS3=&CCMS3;
	m_pCCMS3->m_strFilter="[用户文件].[身份证号]=[账户文件].[身份证号]";
    m_pCCMS3->m_strFilter+="and";
	wsprintf(filter,"[账户文件].[账号]='%s'",m_wKehuzhanghao);
	m_pCCMS3->m_strFilter+=filter;
	m_pCCMS3->m_strFilter+="and";
	wsprintf(filter,"[用户文件].[密码]='%s'",m_wMima);
	m_pCCMS3->m_strFilter+=filter;
	m_pCCMS3->Open();
	if(m_pCCMS3->IsEOF())
	{
		MessageBox("账户密码不匹配");
		m_pCCMS3->Close();
	}else
	{
		 m_wQianshu=m_pCCMS3->m_column10;
         m_wYonghuming=m_pCCMS3->m_column2;
         time_t tt;
		 tt=m_pCCMS3->m_column8.GetTime();
	     m_wKaihushijian = COleDateTime::COleDateTime(tt);
      /*   if(m_pCCMS3->m_column16)
		 {
		 time_t tt1;
		 tt1=m_pCCMS3->m_column9.GetTime();
         m_wXiaohushijian = COleDateTime::COleDateTime(tt1);
		 }  */
  		 m_wShenfenzhenghao=m_pCCMS3->m_column1;
         m_wZhanghao=m_pCCMS3->m_column7;
		 m_pCCMS3->Close();
		 m_pCCMS3y=&CCMS3y;
		 wsprintf(filter,"[用户文件].[身份证号]='%s'",m_wShenfenzhenghao);
		 m_pCCMS3y->m_strFilter=filter;
		 m_pCCMS3y->Open();
         if (!m_pCCMS3y->IsEOF()) 
		 {
 		   	m_wDizfhi=m_pCCMS3y->m_column4;
            m_wDianhua=m_pCCMS3y->m_column5;
			m_wBeizhu=m_pCCMS3y->m_column6;
		 }
         m_pCCMS3y->Close();
	     m_pCCMS3z=&CCMS3z;
		 m_pCCMS3z->m_strFilter.Empty();
		 m_pCCMS3z->Open();
		 while(!m_pCCMS3z->IsEOF())
		 {
			 if(m_pCCMS3z->m_column1==m_wZhanghao)
			 m_wXinyongdujibie=m_pCCMS3z->m_column5;
             m_pCCMS3z->MoveNext();
		 }
         m_pCCMS3z->Close();
		 UpdateData(FALSE);
	}
}