家庭/个人应用

开发平台：
Visual C++

MoneyViewDlg.cpp：源码内容
							// MoneyViewDlg.cpp : implementation file
//
#include "stdafx.h"
#include "MyAssistant.h"
#include "MoneyViewDlg.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CMoneyViewDlg dialog
CMoneyViewDlg::CMoneyViewDlg(CWnd* pParent /*=NULL*/) 
	: CDialog(CMoneyViewDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CMoneyViewDlg)
	m_strID = _T("");
	m_nSum = 0;
	m_nYear = 0;
	m_nMonth = 0;
	m_nDay = 0;
	//}}AFX_DATA_INIT
	m_nPage = 0;
}
void CMoneyViewDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMoneyViewDlg)
	DDX_Control(pDX, IDC_TYPE, m_comboType);
	DDX_Control(pDX, IDC_MONEY_LIST, m_listMoney);
	DDX_Text(pDX, IDC_ID, m_strID);
	DDX_Text(pDX, IDC_SUM, m_nSum);
	DDX_Text(pDX, IDC_YEAR, m_nYear);
	DDX_Text(pDX, IDC_MONTH, m_nMonth);
	DDX_Text(pDX, IDC_DAY, m_nDay);
	//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CMoneyViewDlg, CDialog)
	//{{AFX_MSG_MAP(CMoneyViewDlg)
	ON_BN_CLICKED(IDC_QUERY, OnQuery)
	ON_BN_CLICKED(IDC_PREF, OnPref)
	ON_BN_CLICKED(IDC_NEXT, OnNext)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CMoneyViewDlg message handlers
void CMoneyViewDlg::OnOK() 
{
	// TODO: Add extra validation here
	
	// CDialog::OnOK();
}
void CMoneyViewDlg::OnCancel() 
{
	// TODO: Add extra cleanup here
	
	// CDialog::OnCancel();
}
BOOL CMoneyViewDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_comboType.AddString("饮食");
	m_comboType.AddString("住宿");
	m_comboType.AddString("衣服");
	m_comboType.AddString("交通");
	m_comboType.AddString("通信");
	m_comboType.AddString("书籍");
	m_comboType.AddString("培训");
	m_comboType.AddString("其它");
	m_comboType.SetCurSel(0);
	m_nSum = 0;
	CString strYear,strMonth,strDay;
	m_nYear = 2004;
	m_nMonth = CTime::GetCurrentTime().GetMonth();
	m_nDay = CTime::GetCurrentTime().GetDay();
	UpdateData(FALSE);
	
	m_listMoney.InsertColumn(0,"说明",LVCFMT_LEFT,300);
	m_listMoney.InsertColumn(0,"日期",LVCFMT_LEFT,100);
	m_listMoney.InsertColumn(0,"金额",LVCFMT_LEFT,100);
	m_listMoney.InsertColumn(0,"类型",LVCFMT_LEFT,100);
	
	LoadFromDb();
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CMoneyViewDlg::OnPref() 
{
	if(m_nPage > 0) {
		m_nPage --;
	}	
}
void CMoneyViewDlg::OnNext() 
{
	if(m_nPage < 10) {
		m_nPage ++;
	}	
}
void CMoneyViewDlg::OnQuery() 
{
	UpdateData(TRUE);
	m_comboType.GetWindowText(m_strType);
	CTime p_Date(m_nYear,m_nMonth,m_nDay,0,0,0);
	m_Date = p_Date;
	m_strFilter = "";
	if(m_strType.GetLength() != 0) {
		m_strFilter += "Type = '" + m_strType + "'";
	}
	else {
		m_strFilter += "Type = '*'";
	}
	QueryFromDb();
}
BOOL CMoneyViewDlg::LoadFromDb()
{
	p_Database = new CDatabase;
	p_Database->SetLoginTimeout(5);
	BOOL p_Status = FALSE;
	try
	{
		p_Status = p_Database->Open("Assistant");
		if(p_Status)
			TRACE("nDB opened successfullyn");
		else
			TRACE("nOpen DSN failed.n");
	}
	catch(CMemoryException* pEx)
	{
		pEx->ReportError();
	}
	catch(CDBException*	pDBEx)
	{
		pDBEx->ReportError();
		TRACE("RetCOde:%d strError:[%d] strState: [%d]n",
			pDBEx->m_nRetCode,
			pDBEx->m_strError,
			pDBEx->m_strStateNativeOrigin);
	}
	if(!p_Status)
	{
		MessageBox("Open DSN Failed.");
		if(p_Database->IsOpen())	p_Database->Close();
		if(p_Database	!=	NULL)	delete	p_Database;
		return	FALSE;
	}
	p_Record = new	CMoneyRecord(p_Database);
	if(!p_Record->Open(AFX_DB_USE_DEFAULT_TYPE,(LPCTSTR)"Account"))
	{
		MessageBox("Open Table SiteData Failed.");
		if(p_Record->IsOpen())		p_Record->Close();
		if(p_Database->IsOpen())	p_Database->Close();
		delete	p_Record;
		delete	p_Database;
		return FALSE;
	}
	CString str;
	if(!p_Record->IsBOF())
	{
		m_listMoney.DeleteAllItems();
		while(!p_Record->IsEOF())
		{
			int i = m_listMoney.InsertItem(0,p_Record->m_Type);
			str.Format("%d",p_Record->m_Sum);
			m_listMoney.SetItemText(i,1,str);
			m_listMoney.SetItemText(i,2,p_Record->m_Date.Format("%Y-%b-%d"));
			m_listMoney.SetItemText(i,3,p_Record->m_Comments);
			p_Record->MoveNext();
		}
		m_listMoney.UpdateWindow();
	}
//
	if(p_Record->IsOpen())		p_Record->Close();
	if(p_Database->IsOpen())	p_Database->Close();
	delete	p_Record;
	delete	p_Database;	
	return TRUE;
}
BOOL CMoneyViewDlg::QueryFromDb()
{
	p_Database = new CDatabase;
	p_Database->SetLoginTimeout(5);
	BOOL p_Status = FALSE;
	try
	{
		p_Status = p_Database->Open("Assistant");
		if(p_Status)
			TRACE("nDB opened successfullyn");
		else
			TRACE("nOpen DSN failed.n");
	}
	catch(CMemoryException* pEx)
	{
		pEx->ReportError();
	}
	catch(CDBException*	pDBEx)
	{
		pDBEx->ReportError();
		TRACE("RetCOde:%d strError:[%d] strState: [%d]n",
			pDBEx->m_nRetCode,
			pDBEx->m_strError,
			pDBEx->m_strStateNativeOrigin);
	}
	if(!p_Status)
	{
		MessageBox("Open DSN Failed.");
		if(p_Database->IsOpen())	p_Database->Close();
		if(p_Database	!=	NULL)	delete	p_Database;
		return	FALSE;
	}
	p_Record = new	CMoneyRecord(p_Database);
	p_Record->m_strFilter = m_strFilter;
	if(!p_Record->Open(AFX_DB_USE_DEFAULT_TYPE,(LPCTSTR)"Account"))
	{
		MessageBox("Open Table SiteData Failed.");
		if(p_Record->IsOpen())		p_Record->Close();
		if(p_Database->IsOpen())	p_Database->Close();
		delete	p_Record;
		delete	p_Database;
		return FALSE;
	}
	m_listMoney.DeleteAllItems();
	CString str;
	if(!p_Record->IsBOF())
	{
		while(!p_Record->IsEOF())
		{
			int i = m_listMoney.InsertItem(0,p_Record->m_Type);
			str.Format("%d",p_Record->m_Sum);
			m_listMoney.SetItemText(i,1,str);
			m_listMoney.SetItemText(i,2,p_Record->m_Date.Format("%Y-%b-%d"));
			m_listMoney.SetItemText(i,3,p_Record->m_Comments);
			p_Record->MoveNext();
		}
		m_listMoney.UpdateWindow();
	}
//
	if(p_Record->IsOpen())		p_Record->Close();
	if(p_Database->IsOpen())	p_Database->Close();
	delete	p_Record;
	delete	p_Database;	
	return TRUE;
}

						