xinxidlg.cpp

银行信息查询系统 直接将“银行账户信息查询系统.rar”解压之后

// xinxiDlg.cpp : implementation file
//

#include "stdafx.h"
#include "银行账户信息查询系统.h"
#include "xinxiDlg.h"
#include "jiluRs.h"
#include "newpwdDlg.h"
#include "shortmsgDlg1.h"

#include "shortmsgRs.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
CDatabase db;
/////////////////////////////////////////////////////////////////////////////
// CxinxiDlg dialog


CxinxiDlg::CxinxiDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CxinxiDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CxinxiDlg)
	m_bizhong = _T("");
	m_cunqi = _T("");
	m_daoqiri = _T("");
	m_leixing = _T("");
	m_lilv = _T("");
	m_qixiri = _T("");
	m_yue = _T("");
	m_zhanghao = _T("");
	m_zhuangtai = _T("");
	//}}AFX_DATA_INIT
}


void CxinxiDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CxinxiDlg)
	DDX_Control(pDX, IDC_LIST, m_cList);
	DDX_Text(pDX, IDC_EDIT_bizhong, m_bizhong);
	DDX_Text(pDX, IDC_EDIT_cunqi, m_cunqi);
	DDX_Text(pDX, IDC_EDIT_daoqiri, m_daoqiri);
	DDX_Text(pDX, IDC_EDIT_leixing, m_leixing);
	DDX_Text(pDX, IDC_EDIT_lilv, m_lilv);
	DDX_Text(pDX, IDC_EDIT_qixiri, m_qixiri);
	DDX_Text(pDX, IDC_EDIT_yue, m_yue);
	DDX_Text(pDX, IDC_EDIT_zhanghao, m_zhanghao);
	DDX_Text(pDX, IDC_EDIT_zhuangtai, m_zhuangtai);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CxinxiDlg, CDialog)
	//{{AFX_MSG_MAP(CxinxiDlg)
	ON_BN_CLICKED(IDC_BUTTON_newpwd, OnBUTTONnewpwd)
	ON_BN_CLICKED(IDC_BUTTON_shortmsg, OnBUTTONshortmsg)
	ON_BN_CLICKED(IDC_BUTTON_showjilu, OnBUTTONshowjilu)
	ON_BN_CLICKED(IDC_BUTTON_noshortmsg, OnBUTTONnoshortmsg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CxinxiDlg message handlers

BOOL CxinxiDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
		// 为List添加网格
	m_cList.SetExtendedStyle(LVS_EX_GRIDLINES);
	// 设置List的列
	int nWidth=100;
	m_cList.InsertColumn(0, "帐户名", LVCFMT_LEFT, 100);
	m_cList.InsertColumn(1, "交易日期", LVCFMT_LEFT, 100);
	m_cList.InsertColumn(2, "支出", LVCFMT_LEFT, nWidth);
	m_cList.InsertColumn(3, "存入", LVCFMT_LEFT, nWidth);
	m_cList.InsertColumn(4, "账户余额", LVCFMT_LEFT, nWidth);
	m_cList.InsertColumn(5, "交易类型", LVCFMT_LEFT, nWidth);
	m_cList.InsertColumn(6, "交易备注", LVCFMT_LEFT, nWidth);
	m_cList.InsertColumn(7, "支出交易笔数", LVCFMT_LEFT, nWidth);
	m_cList.InsertColumn(8, "支出金额合计", LVCFMT_LEFT, nWidth);
	m_cList.InsertColumn(9, "存入交易笔数", LVCFMT_LEFT, nWidth);
	m_cList.InsertColumn(10, "存入金额合计", LVCFMT_LEFT, nWidth);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CxinxiDlg::UpdateList(CjiluRs & rs)
{
	int i=0;
	rs.Open(); // 打开统计数据表
	m_cList.DeleteAllItems(); // 清除列表框内容
	while(!rs.IsEOF()) // 对数据表中所有记录进行处理
	{
		m_cList.InsertItem(i, ""); // 添加新Item
		
		
		m_cList.SetItemText(i, 0, rs.m_column1);
		
		m_cList.SetItemText(i, 1, rs.m_column2);
		
		m_cList.SetItemText(i, 2, rs.m_column3);
		
		m_cList.SetItemText(i, 3, rs.m_column4);
		
		m_cList.SetItemText(i, 4, rs.m_column5);
		
		m_cList.SetItemText(i, 5, rs.m_column6);
		
		m_cList.SetItemText(i, 6, rs.m_column7);
		
		m_cList.SetItemText(i, 7, rs.m_column8);
		
		m_cList.SetItemText(i, 8, rs.m_column9);
		
		m_cList.SetItemText(i, 9, rs.m_column10);
		
		m_cList.SetItemText(i, 10, rs.m_column11);
		rs.MoveNext(); // 跳到下一条记录
		i++;
	}
	rs.Close(); // 关闭统计数据表
}

void CxinxiDlg::OnBUTTONnewpwd() 
{
	// TODO: Add your control notification handler code here
	CnewpwdDlg newpwdDlg;
	newpwdDlg.DoModal();
}

void CxinxiDlg::OnBUTTONshortmsg() 
{
	// TODO: Add your control notification handler code here
	CshortmsgDlg shortmsgDlg;
	shortmsgDlg.DoModal();	
}

void CxinxiDlg::OnBUTTONshowjilu() 
{
	// TODO: Add your control notification handler code here
	CString strFilter;
	CjiluRs rs(&db);// 构造统计数据表
	CjiluRs jiluRs;
    strFilter="账户名='" + m_zhanghao + "'";
	rs.m_strFilter=strFilter;
	UpdateList(rs); // 更新List
	m_cList.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);	
}

void CxinxiDlg::OnBUTTONnoshortmsg() 
{
	// TODO: Add your control notification handler code here
		UpdateData(TRUE);
	CshortmsgRs m_shortmsgRs;
	try
	{
		if(m_shortmsgRs.IsOpen())
			m_shortmsgRs.Close();
    	m_shortmsgRs.m_strFilter.Format("用户名='%s' ",m_zhanghao.operator LPCTSTR());
		m_shortmsgRs.Open(CRecordset::snapshot,NULL,CRecordset::none);
		if(m_shortmsgRs.IsEOF())
		{
			m_shortmsgRs.Close();
			AfxMessageBox("您还没有制订过短信通知业务！");
			return;
		}
		
		m_shortmsgRs.Delete();
		
		
			if(m_shortmsgRs.IsOpen())
				m_shortmsgRs.Close();
			AfxMessageBox("您已成功退订短信通知业务！");
	
		

	}
	catch(CDBException*e)
	{
		e->ReportError();
		return;
	}
	
}

void CxinxiDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	CDialog::OnCancel();
}