deleteaccount.cpp

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

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

#include "stdafx.h"
#include "BankService.h"
#include "DeleteAccount.h"
#include ".\deleteaccount.h"


// CDeleteAccount 对话框

IMPLEMENT_DYNAMIC(CDeleteAccount, CDialog)
CDeleteAccount::CDeleteAccount(CWnd* pParent /*=NULL*/)
	: CDialog(CDeleteAccount::IDD, pParent)
	, m_name(_T(""))
	, m_id(_T(""))
	, m_pwd(_T(""))
{
}

CDeleteAccount::~CDeleteAccount()
{
}

void CDeleteAccount::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_NAME, m_name);
	DDX_Text(pDX, IDC_ID_CARD, m_id);
	DDX_Control(pDX, IDC_UESR_ACCOUNT_LIST, m_AccountList);
	DDX_Text(pDX, IDC_OLD_PWD, m_pwd);
}


BEGIN_MESSAGE_MAP(CDeleteAccount, CDialog)
	ON_BN_CLICKED(IDC_GET_USER_ACCOUNT, OnBnClickedGetUserAccount)
	ON_BN_CLICKED(IDC_DEL_ACCOUNT, OnBnClickedDelAccount)
END_MESSAGE_MAP()


// CDeleteAccount 消息处理程序

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

	//更新输入变量
	UpdateData();
	//以人名和身份证号查询此用户的所有帐户记录
	CString strQuery="SELECT * FROM bankbook WHERE bankbook.uname=\'"+m_name+"\' AND bankbook.uid=\'"+m_id+"\'";

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

	//将查询到的帐户记录加到列表框
	while(!pRst->rsEOF)
	{
		CString str2=" "+(_bstr_t)pRst->GetCollect("accnum")+" "+(_bstr_t)pRst->GetCollect("amount")+" "+(_bstr_t)pRst->GetCollect("fundtype")+" ";
		
		m_AccountList.AddString(str2);
		pRst->MoveNext();
	}
}

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

	//获得列表框中选中的帐号是哪一项
	int index=m_AccountList.GetCurSel();

	//首先要打开pRst,这样才能获得Rst的记录数
	UpdateData();
	CString strQuery="SELECT * FROM bankbook WHERE bankbook.uname=\'"+m_name+"\' AND bankbook.uid=\'"+m_id+"\'";
	pRst.CreateInstance("ADODB.Recordset");
	pRst->Open(_bstr_t(strQuery),_variant_t((IDispatch*)pConn,true),adOpenStatic,adLockOptimistic,adCmdText);

	//在Rst中找出此记录
	pRst->MoveFirst();
	while(index)
	{
		pRst->MoveNext();
		index--;
	}

	//获得该帐号的密码
	CString PWD=pRst->GetCollect("password");
	PWD.TrimRight();
	
	//判断输入的密码是否正确
	if( PWD==m_pwd )
	{
		//删除该帐号
		try
		{
			pRst->Delete(adAffectCurrent);
			pRst->Update();
		}
		catch(_com_error &e)
		{
			MessageBox(e.ErrorMessage()); 
			return ;
		}
		AfxMessageBox("帐号已删除");
	}
	else
	{
		AfxMessageBox("密码有误,请重试");
	}

	//刷新帐号列表
	m_AccountList.DeleteString(index);
}