statdlg.cpp

本售货管理系统用vc和sql开发

// StatDlg.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "StatDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CStatDlg dialog


CStatDlg::CStatDlg(CWnd* pParent /*=NULL*/)
	: CDialog(CStatDlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CStatDlg)
	m_stataccount = 0;
	m_statcode = _T("");
	m_statmoney = 0.0;
	m_statname = _T("");
	m_statuser = _T("");
	//}}AFX_DATA_INIT
}


void CStatDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CStatDlg)
	DDX_Control(pDX, IDC_CHECKUSER, m_checkuser);
	DDX_Control(pDX, IDC_CHECKTIME, m_checktime);
	DDX_Control(pDX, IDC_CHECKNAME, m_checkname);
	DDX_Control(pDX, IDC_CHECKCODE, m_checkcode);
	DDX_Text(pDX, IDC_STATACCOUNT, m_stataccount);
	DDX_Text(pDX, IDC_STATCODE, m_statcode);
	DDX_Text(pDX, IDC_STATMONEY, m_statmoney);
	DDX_Text(pDX, IDC_STATNAME, m_statname);
	DDX_Text(pDX, IDC_STATUSER, m_statuser);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CStatDlg, CDialog)
	//{{AFX_MSG_MAP(CStatDlg)
	ON_BN_CLICKED(IDSTAT, OnStat)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CStatDlg message handlers

void CStatDlg::OnStat() 
{
	UpdateData(TRUE);
	m_stataccount=0; //统计结果数量先清零
	m_statmoney=0;//统计结果总金额清零
	CSellRecordSet m_sellset;//售货记录集
	CString sql;
	bool sign=false;
	CString temp;
	sql.Format("select * from 售货记录表");
	if(m_checkcode.GetCheck()){//如果选择用商品编号查询
		sql=sql+" where 商品编号 = '"+m_statcode+"'";
		sign=true;
	}
	if(m_checkname.GetCheck()){//如果选择用商品名称查询
		if(sign){
			sql=sql+" and 商品名称 = '"+m_statname+"'";
		}else{
			sql=sql+" where 商品名称='"+m_statname+"'";
			sign=true;
		}
	}
	if(m_checkuser.GetCheck()){//如果选择用售货员查询
		if(sign){
			sql=sql+" and ";
		}else{
			sql=sql+"  where ";
			sign=true;
		}
		sql=sql+"售货员='"+m_statuser+"'";
	}
	if(m_checktime.GetCheck()){//如果选择用时间段查询
		CString starttime,endtime;
		GetDlgItemText(IDC_STARTTIME,starttime);//获取起始时间
		GetDlgItemText(IDC_ENDTIME,endtime);//获取终结时间
		if(strcmp(starttime,endtime)>0){
			MessageBox("起始时间不能大于终止时间");
		}
		if(sign){
			sql=sql+" and ";
		}else{
			sql=sql+" where ";
			sign=true;
		}
		temp.Format("日期 between '%s' and '%s' order by 日期 desc",starttime,endtime);
		sql=sql+temp;
	}
	m_sellset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	while(!m_sellset.IsEOF()){
		m_stataccount+=m_sellset.m_column5;//叠加数量
		m_statmoney+=m_sellset.m_column4*m_sellset.m_column5;//累加钱额
		m_sellset.MoveNext();
	}
	UpdateData(false);
}