?? drawmoneydialog.cpp
字號:
// 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();
}
}
?? 快捷鍵說明
復制代碼
Ctrl + C
搜索代碼
Ctrl + F
全屏模式
F11
切換主題
Ctrl + Shift + D
顯示快捷鍵
?
增大字號
Ctrl + =
減小字號
Ctrl + -