depositmoneydialog.cpp

银行管理系统,在VisualC++中操作SQL数据库进行银行帐号的创建,删除,修改,转帐,存款,取款,生成密码卡等操作.

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

#include "stdafx.h"
#include "BankSystem.h"
#include "DepositMoneyDialog.h"
#include ".\depositmoneydialog.h"
#include "BankSystemDlg.h"

// DepositMoneyDialog 对话框

IMPLEMENT_DYNAMIC(DepositMoneyDialog, CDialog)
DepositMoneyDialog::DepositMoneyDialog(CWnd* pParent /*=NULL*/)
	: CDialog(DepositMoneyDialog::IDD, pParent)
	, m_depositmoneynum(0)
{
}

DepositMoneyDialog::~DepositMoneyDialog()
{
}

void DepositMoneyDialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT1, m_depositmoneynum);
}


BEGIN_MESSAGE_MAP(DepositMoneyDialog, CDialog)
	ON_BN_CLICKED(IDC_DepositMoneyBUTTON, OnBnClickedDepositmoneybutton)
END_MESSAGE_MAP()


// DepositMoneyDialog 消息处理程序

void DepositMoneyDialog::OnBnClickedDepositmoneybutton()
{
	// TODO: 在此添加控件通知处理程序代码
		UpdateData();
	CString strQuery="SELECT * FROM bankbook WHERE bankbook.uname=\'"+UserName+"\' AND bankbook.password=\'"+UserPWD+"\'";

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

	pRst.CreateInstance("ADODB.Recordset");
	pRst->Open(_bstr_t(strQuery),_variant_t((IDispatch*)pConn,true),adOpenStatic,adLockOptimistic,adCmdText);

	float restmoney=(float)pRst->GetCollect("amount");

	
	if(m_depositmoneynum>0)
	{

		restmoney=restmoney+m_depositmoneynum;
		pRst->put_Collect(_variant_t("amount"),_variant_t(restmoney));
		
		pRst->Update();

		AfxMessageBox("存款成功");
		OnOK();
	}
	else
	{
		AfxMessageBox("存款失败");
		OnOK();
	}
}