ycxdlg.cpp

< 项目开发全程实录>>里的餐饮管理系统的源代码

// Ycxdlg.cpp : implementation file
//

#include "stdafx.h"
#include "餐饮管理.h"
#include "Ycxdlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// CYcxdlg dialog

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


void CYcxdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CYcxdlg)
	DDX_Control(pDX, IDC_COMBO_month, m_MonthCombo);
	DDX_Control(pDX, IDC_COMBO_year, m_YearCombo);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CYcxdlg, CDialog)
	//{{AFX_MSG_MAP(CYcxdlg)
	ON_BN_CLICKED(IDC_BUTTON_CHAXUN, OnButtonChaxun)
	ON_BN_CLICKED(IDC_BUTTON_tuichu, OnBUTTONtuichu)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CYcxdlg message handlers

BOOL CYcxdlg::OnInitDialog()
{
	CDialog::OnInitDialog();
	CString sql;
	CString str;
	sql="select distinct Year(时间) as 年份 from shouru ";
	m_pRs=theApp.m_pCon->Execute((_bstr_t)sql,NULL,adCmdText);
	while(m_pRs->adoEOF==0)
	{
		str=(char*)(_bstr_t)m_pRs->GetCollect("年份");
		m_YearCombo.AddString(str);	
		m_pRs->MoveNext();
	}
	
	sql="select distinct Month(时间) as 月份 from shouru ";
	m_pRs=theApp.m_pCon->Execute((_bstr_t)sql,NULL,adCmdText);
	while(m_pRs->adoEOF==0)
	{
		str=(char*)(_bstr_t)m_pRs->GetCollect("月份");
		m_MonthCombo.AddString(str);	
		m_pRs->MoveNext();
	}

	return true;
}

void CYcxdlg::OnButtonChaxun() 
{
	UpdateData();
	CString year,month,day,totle;
	double Mytotle=0;
	if(m_YearCombo.GetCurSel()==-1||m_MonthCombo.GetCurSel()==-1)
	{
		AfxMessageBox("请选择一个时间");
		return;
	}
	m_YearCombo.GetLBText(m_YearCombo.GetCurSel(),year);
	m_MonthCombo.GetLBText(m_MonthCombo.GetCurSel(),month);
	CString sql="select * from shouru where Year(时间)="+year+" and Month(时间)="+month+"";
	m_pRs=theApp.m_pCon->Execute((_bstr_t)sql,NULL,adCmdText);
	while(m_pRs->adoEOF==0)
	{
		totle=(char*)(_bstr_t)m_pRs->GetCollect("日收入");
		Mytotle+=atof(totle);
		m_pRs->MoveNext();
	}
	totle.Format("%.2lf",Mytotle);
	MessageBox(year+"年"+month+"月的收入为："+totle+"元","月收入查询");	
}

void CYcxdlg::OnBUTTONtuichu() 
{
	CDialog::OnCancel();		
}

void CYcxdlg::OnOK()
{
	OnButtonChaxun();

}