【VC开源代码栏目提醒】:网学会员VC开源代码为您提供AccountView.cpp参考,解决您在AccountView.cpp学习中工作中的难题,参考学习。
// AccountView.cpp : implementation file
//
#include "stdafx.h"
#include "FinanceMIS.h"
#include "AccountView.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CAccountView
IMPLEMENT_DYNCREATE(CAccountView, CFormView)
CAccountView::CAccountView()
: CFormView(CAccountView::IDD)
{
//{{AFX_DATA_INIT(CAccountView)
m_strBank = _T("");
m_dtAcc = COleDateTime::GetCurrentTime();
m_dtExch = COleDateTime::GetCurrentTime();
m_dbACMoney = 0.0;
m_strACNum = _T("");
m_strCard = _T("");
m_strDescrip = _T("");
m_strName = _T("");
m_nType = -1;
m_dbExMoney = 0.0;
//}}AFX_DATA_INIT
m_dbCurrMoney = 0;
}
CAccountView::~CAccountView()
{
}
void CAccountView::DoDataExchange(CDataExchange* pDX)
{
CFormView::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CAccountView)
DDX_Control(pDX, IDC_LIST_EXCH, m_listExch);
DDX_Control(pDX, IDC_LIST_ACC, m_listAcc);
DDX_CBString(pDX, IDC_COMBO_BANK, m_strBank);
DDX_DateTimeCtrl(pDX, IDC_DT_ACC, m_dtAcc);
DDX_DateTimeCtrl(pDX, IDC_DT_EXCH, m_dtExch);
DDX_Text(pDX, IDC_EDIT_AC_MONEY, m_dbACMoney);
DDX_Text(pDX, IDC_EDIT_ACCNUM, m_strACNum);
DDX_Text(pDX, IDC_EDIT_CARD, m_strCard);
DDX_Text(pDX, IDC_EDIT_DESCRIP, m_strDescrip);
DDX_Text(pDX, IDC_EDIT_NAME, m_strName);
DDX_Radio(pDX, IDC_RADIO1, m_nType);
DDX_Text(pDX, IDC_EDIT_EX_MONEY, m_dbExMoney);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CAccountView, CFormView)
//{{AFX_MSG_MAP(CAccountView)
ON_BN_CLICKED(IDC_BTN_ACC_ADD, OnBtnAccAdd)
ON_BN_CLICKED(IDC_BTN_ACC_DEL, OnBtnAccDel)
ON_BN_CLICKED(IDC_BTN_EXCH_ADD, OnBtnExchAdd)
ON_BN_CLICKED(IDC_BTN_EXCH_DEL, OnBtnExchDel)
ON_NOTIFY(LVN_ITEMCHANGED, IDC_LIST_ACC, OnItemchangedListAcc)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CAccountView diagnostics
#ifdef _DEBUG
void CAccountView::AssertValid() const
{
CFormView::AssertValid();
}
void CAccountView::Dump(CDumpContext& dc) const
{
CFormView::Dump(dc);
}
#endif //_DEBUG
/////////////////////////////////////////////////////////////////////////////
// CAccountView message handlers
void CAccountView::OnInitialUpdate()
{
CFormView::OnInitialUpdate();
// TODO: Add your specialized code here and/or call the base class
//初始化列表框控件
InitControl();
//加载数据到列表框控件中
InitCtrlData();
}
void CAccountView::InitControl()
{
//设置列表框控件扩展风格
DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES |
LVS_EX_HEADERDRAGDROP | LVS_EX_ONECLICKACTIVATE | LVS_EX_UNDERLINEHOT;
m_listAcc.SetExtendedStyle(dwExStyle);
m_listExch.SetExtendedStyle(dwExStyle);
//初始化账户信息列表框控件
m_listAcc.InsertColumn(0,"账号",LVCFMT_CENTER,100);
m_listAcc.InsertColumn(1,"户名",LVCFMT_CENTER,80);
m_listAcc.InsertColumn(2,"关联卡号",LVCFMT_CENTER,100);
m_listAcc.InsertColumn(3,"开户银行",LVCFMT_CENTER,100);
m_listAcc.InsertColumn(4,"开户日期",LVCFMT_CENTER,120);
m_listAcc.InsertColumn(5,"余额",LVCFMT_CENTER,100);
m_listAcc.InsertColumn(6,"说明",LVCFMT_CENTER,120);
//初始化交易信息列表框控件
m_listExch.InsertColumn(0,"交易ID",LVCFMT_CENTER,60);
m_listExch.InsertColumn(1,"交易日期",LVCFMT_CENTER,100);
m_listExch.InsertColumn(2,"存款或取款",LVCFMT_CENTER,80);
m_listExch.InsertColumn(3,"金额",LVCFMT_CENTER,100);
}
void CAccountView::InsertAcCtrlItem(CString item0,CString item1,CString item2, CString item3,CString item4,CString item5,CString item6)
{
//获取当前的纪录条数.
int nIndex = m_listAcc.GetItemCount();
LV_ITEM lvItem;
lvItem.mask = LVIF_TEXT ;
lvItem.iItem = nIndex; //行数
lvItem.iSubItem = 0;
lvItem.pszText = (char*)(LPCTSTR)item0; //第一列
//在最后一行插入记录值.
m_listAcc.InsertItem(&lvItem);
//设置该行的其他列的值.
m_listAcc.SetItemText(nIndex,1,item1);
m_listAcc.SetItemText(nIndex,2,item2);
m_listAcc.SetItemText(nIndex,3,item3);
m_listAcc.SetItemText(nIndex,4,item4);
m_listAcc.SetItemText(nIndex,5,item5);
m_listAcc.SetItemText(nIndex,6,item6);
//修改当前选择的行
m_nCurrIndex = nIndex;
}
void CAccountView::InsertExCtrlItem(CString item0,CString item1,CString item2,CString item3)
{
//获取当前的纪录条数.
int nIndex = m_listExch.GetItemCount();
LV_ITEM lvItem;
lvItem.mask = LVIF_TEXT ;
lvItem.iItem = nIndex; //行数
lvItem.iSubItem = 0;
lvItem.pszText = (char*)(LPCTSTR)item0; //第一列
//在最后一行插入记录值.
m_listExch.InsertItem(&lvItem);
//设置该行的其他列的值.
m_listExch.SetItemText(nIndex,1,item1);
m_listExch.SetItemText(nIndex,2,item2);
m_listExch.SetItemText(nIndex,3,item3);
}
void CAccountView::OnBtnAccAdd()
{
// TODO: Add your control notification handler code here
if(!g_adoDB.IsOpen()){
AfxMessageBox("数据库未打开");
return;
}
if(!UpdateData())
return;
if(m_strBank.IsEmpty()){
AfxMessageBox("请选择开户的银行名称");
return;
}
//插入新的账户信息
CString strDT = m_dtAcc.Format("%Y-%m-%d");
CString sql ;
sql.Format("Insert into account_info_tab(acc_num,"
"name,card_num,bank,opendate,balance,description)"
" VALUES("
"'%s','%s','%s','%s','%s',%.2f,'%s')",
m_strACNum,m_strName,m_strCard,m_strBank,strDT,m_dbACMoney,m_strDescrip);
g_adoDB.Execute(sql);
//向账户列表框控件中插入信息
InsertAcCtrlItem(m_strACNum,m_strName,m_strCard,
m_strBank,strDT,float2Str(m_dbACMoney),m_strDescrip);
}
void CAccountView::OnBtnAccDel()
{
if(!g_adoDB.IsOpen()){
AfxMessageBox("数据库未打开");
return;
}
int nItem = m_listAcc.GetNextItem(-1, LVNI_SELECTED);
if(nItem == -1){
AfxMessageBox("没有选定要删除的账户信息");
return;
}
//获取选择的账户名称.
CString strACNum = m_listAcc.GetItemText(nItem,0);
CString sql;
//删除该账户下的所有交易记录
sql.Format("delete from exchange_info_tab where acc_num = '%s'",strACNum);
g_adoDB.Execute(sql);
m_listExch.DeleteAllItems();
//删除选择的账户信息
sql.Format("delete from account_info_tab where acc_num = '%s'",strACNum);
g_adoDB.Execute(sql);
//删除账户列表框控件中选择的账户信息
m_listAcc.DeleteItem(nItem);
//删除交易信息列表框控件中的数据
m_listExch.DeleteAllItems();
}
void CAccountView::InitCtrlData()
{
if(!g_adoDB.IsOpen())
return;
m_listAcc.DeleteAllItems();
CDStrs acFields;
上一篇:
AccountFrm.cpp
下一篇:
4种小菜缓解孕妈咪不适