search.cpp

通过Access数据库实现对个人开支的管理

// Search.cpp : implementation file
//
#include "TotalPayDlg.h"
#include "stdafx.h"
#include "TotalPay.h"
#include "Search.h"
#include "WinXPButtonST.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CSearch dialog

extern CTotalPayApp theApp;
CSearch::CSearch(CWnd* pParent /*=NULL*/)
	: CDialog(CSearch::IDD, pParent)
{
	//{{AFX_DATA_INIT(CSearch)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void CSearch::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CSearch)
	DDX_Control(pDX, IDCANCEL, m_cancel);
	DDX_Control(pDX, ID_OK, m_ok);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CSearch, CDialog)
	//{{AFX_MSG_MAP(CSearch)
	ON_BN_CLICKED(ID_OK, OnOk)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CSearch message handlers



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

void CSearch::OnOk() 
{
	// TODO: Add your control notification handler code here

	CString sql,searchtime;
	GetDlgItemText(IDC_DATETIMEPICKER2,searchtime);
	CTotalPayApp *pApp=(CTotalPayApp *)AfxGetApp();
	CTotalPayDlg *pDlg=(CTotalPayDlg *)pApp->m_pMainWnd;
	sql="SELECT * FROM total where name='"+theApp.name+"' and time ='" + searchtime + "'";
	pDlg->ReadtoList(sql);	
}


BOOL CSearch::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_cancel.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, 30);
	m_cancel.SetBkColor(RGB(162,189,252));
	m_cancel.SetRounded(TRUE);
	m_ok.OffsetColor(CButtonST::BTNST_COLOR_BK_IN, 30);
	m_ok.SetBkColor(RGB(162,189,252));
	m_ok.SetRounded(TRUE);
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}