drawmoneydialog.cpp

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

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

#include "stdafx.h"
#include "BankSystem.h"
#include "DrawMoneyDialog.h"
#include ".\drawmoneydialog.h"
#include "BankSystemDlg.h"

// DrawMoneyDialog 对话框

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

DrawMoneyDialog::~DrawMoneyDialog()
{
}

void DrawMoneyDialog::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	DDX_Text(pDX, IDC_EDIT1, m_drawmoneynum);
}


BEGIN_MESSAGE_MAP(DrawMoneyDialog, CDialog)
	ON_BN_CLICKED(IDC_DrawMoneyBUTTON, OnBnClickedDrawmoneybutton)
END_MESSAGE_MAP()


// DrawMoneyDialog 消息处理程序

void DrawMoneyDialog::OnBnClickedDrawmoneybutton()
{
	// 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");

	CString   strCString=pRst->GetCollect("lastmodify");     
	COleVariant   vtime(strCString);   
	vtime.ChangeType(VT_DATE);   
	COleDateTime   time4=vtime;   
	SYSTEMTIME   systime;   
	VariantTimeToSystemTime(time4,   &systime);   
	CTime   t1(systime);     //CString=======>CTime
	CTime t2=CTime::GetCurrentTime();
	CTimeSpan time=t2-t1;   
	int n=time.GetDays();

	CString m_date;
	m_date=t2.Format("%Y-%m-%d");

	CString fundtype=pRst->GetCollect("fundtype");
	CString strQuery2="SELECT * FROM fundtypebook WHERE fundtypebook.type=\'"+fundtype+"\'";
	try{
		pRst2=pConn->Execute(_bstr_t(strQuery2),NULL,adCmdText);
	}
	catch(_com_error &e)
	{
		MessageBox(e.ErrorMessage()); 
		return ;
	}
	pRst2.CreateInstance("ADODB.Recordset");
	pRst2->Open(_bstr_t(strQuery2),_variant_t((IDispatch*)pConn,true),adOpenStatic,adLockOptimistic,adCmdText);
	float interest=pRst2->GetCollect("interest");

	restmoney=restmoney*(1+n/365.*interest);
	if(m_drawmoneynum<restmoney)
	{

		restmoney=restmoney-m_drawmoneynum;
		pRst->put_Collect(_variant_t("amount"),_variant_t(restmoney));
		pRst->put_Collect(_variant_t("lastmodify"),_variant_t(m_date));
		pRst->Update();

		AfxMessageBox("取款成功");
		OnOK();
	}
	else
	{
		AfxMessageBox("卡内存款不足");
		OnOK();
	}

}