📄 managestatisticsmachine.cpp
字号:
// ManageStatisticsMachine.cpp : implementation file
//
#include "stdafx.h"
#include "CreditCardManagement.h"
#include "ManageStatisticsMachine.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CManageStatisticsMachine dialog
CManageStatisticsMachine::CManageStatisticsMachine(CWnd* pParent /*=NULL*/)
: CDialog(CManageStatisticsMachine::IDD, pParent)
{
//{{AFX_DATA_INIT(CManageStatisticsMachine)
m_wQishishijian = COleDateTime::GetCurrentTime();
m_wZhongzhishijian = COleDateTime::GetCurrentTime();
//}}AFX_DATA_INIT
}
void CManageStatisticsMachine::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CManageStatisticsMachine)
DDX_Control(pDX, IDC_LIST1, m_wShukajitongji);
DDX_Text(pDX, IDC_EDIT1, m_wQishishijian);
DDX_Text(pDX, IDC_EDIT2, m_wZhongzhishijian);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CManageStatisticsMachine, CDialog)
//{{AFX_MSG_MAP(CManageStatisticsMachine)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CManageStatisticsMachine message handlers
void CManageStatisticsMachine::OnOK()
{
char filter[100];
m_pCMSMS=&CMSMS;
UpdateData(TRUE);
//初始化CListCtrl;
m_wShukajitongji.DeleteAllItems();
for(int dc=0;dc<3;dc++){ m_wShukajitongji.DeleteColumn(0);}
int i=0;//记录消费文件中刷卡机个数
int nItem=0; if((m_wQishishijian.GetStatus()==0)&&(m_wZhongzhishijian.GetStatus()==0))
{
if (m_wQishishijian>m_wZhongzhishijian)
MessageBox("请输入正确的时间!");
else
{
m_pCMSMS->m_strFilter="[刷卡机文件].[刷卡机标识]=[消费文件].[刷卡机标识]";
m_pCMSMS->Open();
CString store[20];
//获取刷卡机标识_Begin
while (!m_pCMSMS->IsEOF())
{
int jj=1;
for(int j=0;j<=i;j++)
{
jj=m_pCMSMS->m_column1.Compare(store[j]);
if (jj==0) break;
}
if (jj!=0)
{
store[i]=m_pCMSMS->m_column1;
i++;
}
m_pCMSMS->MoveNext();
}
//获取刷卡机标识_End
//显示刷卡机消费信息的CListCtrl;
//创建列
LV_COLUMN lvcolumn;
lvcolumn.mask=LVCF_FMT|LVCF_WIDTH|LVCF_TEXT|LVCF_SUBITEM;
lvcolumn.fmt=LVCFMT_CENTER;
lvcolumn.cx=75;
lvcolumn.iSubItem=0;
lvcolumn.pszText="刷卡机标识";
m_wShukajitongji.InsertColumn(0,&lvcolumn);
lvcolumn.iSubItem=1;
lvcolumn.pszText="消费次数";
m_wShukajitongji.InsertColumn(1,&lvcolumn);
lvcolumn.iSubItem=2;
lvcolumn.pszText="消费总额";
m_wShukajitongji.InsertColumn(2,&lvcolumn);
//创建选项
for(int j=0;j<i;j++,nItem++)//对记录刷卡机标识的数组进行循环,
// 一次循环统计出一个刷卡机的信息
//
{
m_pCMSMS->m_strFilter="[刷卡机文件].[刷卡机标识]=[消费文件].[刷卡机标识]";
m_pCMSMS->m_strFilter+="and";
wsprintf(filter,"[消费文件].[刷卡机标识]='%s'",store[j]);
m_pCMSMS->m_strFilter+=filter;
m_pCMSMS->Requery();
int consumetimes=0;//consumetimes记录每一个刷卡机的消费次数
long consumesummoney=0;//consumesummoney记录每一个刷卡机的消费总额
while (!m_pCMSMS->IsEOF())
{
time_t hh;
hh=m_pCMSMS->m_column11.GetTime();
COleDateTime *ff;
ff=new COleDateTime(hh);
if ((ff->m_dt>=m_wQishishijian.m_dt)&&(ff->m_dt<=m_wZhongzhishijian.m_dt))
{
consumetimes++;
consumesummoney+=m_pCMSMS->m_column8;
}
m_pCMSMS->MoveNext();
}
//显示结果
LV_ITEM lvitem;
lvitem.mask=LVIF_TEXT|LVIF_IMAGE|LVIF_STATE;
lvitem.state=0;
lvitem.stateMask=0;
//插入刷卡机标识
nItem=m_wShukajitongji.InsertItem(0,store[j]);
//插入消费次数
CString temp;
temp.Format("%d",consumetimes);
m_wShukajitongji.SetItemText(nItem,1,temp);
//插入消费额
temp.Format("%d",consumesummoney);
m_wShukajitongji.SetItemText(nItem,2,temp);
}
m_pCMMILS=&CMMILS;
m_pCMMILS->m_strFilter.Empty();
m_pCMMILS->Open();
while (!m_pCMMILS->IsEOF())
{
int jj=1;
for(int j=0;j<=i;j++)
{
jj=m_pCMMILS->m_column1.Compare(store[j]);
if (jj==0) break;
}
if (jj!=0)
{
//显示刷卡机信息
//插入刷卡机标识
nItem=m_wShukajitongji.InsertItem(0,m_pCMMILS->m_column1);
//插入消费次数
CString temp;
int consumetimes=0;
temp.Format("%d",consumetimes);
m_wShukajitongji.SetItemText(nItem,1,temp);
//插入消费额
int consumesummoney=0;
temp.Format("%d",consumesummoney);
m_wShukajitongji.SetItemText(nItem,2,temp);
}
m_pCMMILS->MoveNext();
}
m_pCMMILS->Close();
m_pCMSMS->Close();
}
}}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -