depositmoney.cpp

银行系统的网上用户操作模块.用户可以以网页的形式注册银行帐号,并进行转帐操作.

// DepositMoney.cpp : 实现文件
//

#include "stdafx.h"
#include "BankService.h"
#include "DepositMoney.h"
#include ".\depositmoney.h"


// CDepositMoney 对话框

IMPLEMENT_DYNAMIC(CDepositMoney, CDialog)
CDepositMoney::CDepositMoney(CWnd* pParent /*=NULL*/)
	: CDialog(CDepositMoney::IDD, pParent)
	, m_accnum(_T(""))
	, m_money(0)
	, m_pwd(_T(""))
{
}

CDepositMoney::~CDepositMoney()
{
}

void CDepositMoney::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_ACCOUNT_NUM, m_accnum);
	DDX_Control(pDX, IDC_ACCOUNT_LIST, m_AccountList);
	DDX_Text(pDX, IDC_MONEY, m_money);
	DDX_Text(pDX, IDC_PWD, m_pwd);
}


BEGIN_MESSAGE_MAP(CDepositMoney, CDialog)
	ON_BN_CLICKED(IDC_QUERY, OnBnClickedQuery)
	ON_BN_CLICKED(IDC_DEPOSIT_MONEY, OnBnClickedDepositMoney)
END_MESSAGE_MAP()


// CDepositMoney 消息处理程序

void CDepositMoney::OnBnClickedQuery()
{
	// TODO: 在此添加控件通知处理程序代码

	//查询此帐户的信息
	UpdateData();
	CString str="SELECT * FROM bankbook WHERE accnum=\'"+m_accnum+"\'";

	try{
		pRst=pConn->Execute(_bstr_t(str),NULL,adCmdText);
	}
	catch(_com_error &e)
	{
		MessageBox(e.ErrorMessage()); 
		return ;
	}

	//清空列表框
	m_AccountList.ResetContent();
	//将此帐号的详细信息加到列表框
	while(!pRst->rsEOF)
	{
		CString accnumstr="帐号:	"" "+(_bstr_t)pRst->GetCollect("accnum")+" ";
		CString namestr="姓名:	"" "+(_bstr_t)pRst->GetCollect("uname")+" ";
		CString idstr="身份证:	"" "+(_bstr_t)pRst->GetCollect("uid")+" ";
		CString moneystr="余额:	"" "+(_bstr_t)pRst->GetCollect("amount")+" ";
		CString fundtypestr="帐户类型:	"" "+(_bstr_t)pRst->GetCollect("fundtype")+" ";
		
		m_AccountList.AddString(accnumstr);
		m_AccountList.AddString(namestr);
		m_AccountList.AddString(idstr);
		m_AccountList.AddString(moneystr);
		m_AccountList.AddString(fundtypestr);
		pRst->MoveNext();
	}
}

void CDepositMoney::OnBnClickedDepositMoney()
{
	// TODO: 在此添加控件通知处理程序代码

	//首先要打开pRst,这样才能获得Rst的记录数
	UpdateData();
	CString strQuery="SELECT * FROM bankbook WHERE accnum=\'"+m_accnum+"\'";
	pRst.CreateInstance("ADODB.Recordset");
	pRst->Open(_bstr_t(strQuery),_variant_t((IDispatch*)pConn,true),adOpenStatic,adLockOptimistic,adCmdText);
	
	//获取余额
	float restmoney=(float)pRst->GetCollect("amount");
	//获得该帐号的密码
	CString PWD=pRst->GetCollect("password");
	PWD.TrimRight();
	//如果存款额为正数,且存款额+余额小于100万,则存款
	if( m_pwd==PWD && m_money>0 && (restmoney+m_money)<1000000 )
	{
		try
		{
			restmoney=restmoney+m_money;
			pRst->put_Collect(_variant_t("amount"),_variant_t(restmoney));
			pRst->Update();
		}
		catch(_com_error &e)
		{
			MessageBox(e.ErrorMessage()); 
			return ;
		}
		AfxMessageBox("存款成功!");
	}
	else
	{
		if(m_pwd!=PWD)
			AfxMessageBox("密码错误");
		if(m_money<=0)
			AfxMessageBox("存款额必须为大于0的正数");
		if((restmoney+m_money)>=1000000)
			AfxMessageBox("存款额加起来大于100万,必须以VIP程序进行");
	}
}