📄 managemachineinquireclientcost.cpp
字号:
// ManageMachineInquireClientcost.cpp : implementation file
//
#include "stdafx.h"
#include "CreditCardManagement.h"
#include "ManageMachineInquireClientcost.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
// CManageMachineInquireClientcost dialog
CManageMachineInquireClientcost::CManageMachineInquireClientcost(CWnd* pParent /*=NULL*/)
: CDialog(CManageMachineInquireClientcost::IDD, pParent)
{
//{{AFX_DATA_INIT(CManageMachineInquireClientcost)
m_wYonghuming = _T("");
m_wMima = _T("");
m_wQishishijian = COleDateTime::GetCurrentTime();
m_wZhongzhishijian = COleDateTime::GetCurrentTime();
m_wShuakajibiaoshi = _T("");
//}}AFX_DATA_INIT
}
void CManageMachineInquireClientcost::DoDataExchange(CDataExchange* pDX)
{
CDialog::DoDataExchange(pDX);
//{{AFX_DATA_MAP(CManageMachineInquireClientcost)
DDX_Control(pDX, IDC_LIST1, m_wXiaofeijilu);
DDX_Text(pDX, IDC_EDIT2, m_wYonghuming);
DDV_MaxChars(pDX, m_wYonghuming, 20);
DDX_Text(pDX, IDC_EDIT3, m_wMima);
DDV_MaxChars(pDX, m_wMima, 20);
DDX_Text(pDX, IDC_EDIT4, m_wQishishijian);
DDX_Text(pDX, IDC_EDIT5, m_wZhongzhishijian);
DDX_Text(pDX, IDC_EDIT1, m_wShuakajibiaoshi);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CManageMachineInquireClientcost, CDialog)
//{{AFX_MSG_MAP(CManageMachineInquireClientcost)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
// CManageMachineInquireClientcost message handlers
void CManageMachineInquireClientcost::OnOK()
{
m_pCMMICS=&CMMICS;
char filter[100];
int nItem=0;
UpdateData(TRUE);
//初始化CListCtrl_Begin
m_wXiaofeijilu.DeleteAllItems();
for(int dc=0;dc<4;dc++){ m_wXiaofeijilu.DeleteColumn(0);}
//初始化CListCtrl_End
//显示列
//刷卡机标识+信用卡号+消费额+消费时间
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_wXiaofeijilu.InsertColumn(0,&lvcolumn);
lvcolumn.iSubItem=1;
lvcolumn.pszText="信用卡号";
m_wXiaofeijilu.InsertColumn(1,&lvcolumn);
lvcolumn.iSubItem=2;
lvcolumn.pszText="消费额";
m_wXiaofeijilu.InsertColumn(2,&lvcolumn);
lvcolumn.pszText="消费时间";
m_wXiaofeijilu.InsertColumn(3,&lvcolumn);
if ((m_wShuakajibiaoshi=="")||(m_wYonghuming=="")||(m_wMima==""))
{
MessageBox("请输入完整信息!");
}
else
if (m_wQishishijian>m_wZhongzhishijian)
{
MessageBox("请输入正确的时间段!");
}
else
{
//首先判断刷卡机是否存在
wsprintf(filter,"[刷卡机文件].[刷卡机标识]='%s'",m_wShuakajibiaoshi);
m_pCMMICS->m_strFilter=filter;
//m_pCMMICS->m_strFilter+="and";
//m_pCMMICS->m_strFilter+="[刷卡机文件].[是否拆除]=0";
m_pCMMICS->Open();
if (m_pCMMICS->IsEOF())
{
MessageBox("无此刷卡机!");
}
else
{
//判断用户是否存在
m_pCMMICS->Close();
wsprintf(filter,"[用户名]='%s'",m_wYonghuming);
m_pCMMICS->m_strFilter=filter;
m_pCMMICS->m_strFilter+="and";
wsprintf(filter,"[密码]='%s'",m_wMima);
m_pCMMICS->m_strFilter+=filter;
m_pCMMICS->Open();
if (m_pCMMICS->IsEOF())
MessageBox("不存在此用户!");
else
{
//开始查询
m_pCMMICS->m_strFilter="[刷卡机文件].[刷卡机标识]=[消费文件].[刷卡机标识]";
m_pCMMICS->m_strFilter+="and";
m_pCMMICS->m_strFilter+="[消费文件].[身份证号]=[用户文件].[身份证号]";
m_pCMMICS->m_strFilter+="and";
wsprintf(filter,"[用户名]='%s'",m_wYonghuming);
m_pCMMICS->m_strFilter+=filter;
m_pCMMICS->m_strFilter+="and";
wsprintf(filter,"[密码]='%s'",m_wMima);
m_pCMMICS->m_strFilter+=filter;
m_pCMMICS->m_strFilter+="and";
wsprintf(filter,"[刷卡机文件].[刷卡机标识]='%s'",m_wShuakajibiaoshi);
m_pCMMICS->m_strFilter+=filter;
m_pCMMICS->Requery();
if (m_pCMMICS->IsEOF())
MessageBox("无消费纪录!");
else
{
//显示消费信息 刷卡机标识+信用卡号+消费额+消费时间
//判断时间的范围是否合理,只显示合理用户
int getitem=1;//标记是否有消费信息
while (!m_pCMMICS->IsEOF())
{
time_t hh;
hh=m_pCMMICS->m_column11.GetTime();
COleDateTime *ff;
ff=new COleDateTime(hh);
if ((ff->m_dt>=m_wQishishijian.m_dt)&&(ff->m_dt<=m_wZhongzhishijian.m_dt))
{
getitem=0;
//创建选项
LV_ITEM lvitem;
lvitem.mask=LVIF_TEXT|LVIF_IMAGE|LVIF_STATE;
lvitem.state=0;
lvitem.stateMask=0;
//插入刷卡机标识
nItem=m_wXiaofeijilu.InsertItem(0,m_pCMMICS->m_column13);
//插入信用卡号
m_wXiaofeijilu.SetItemText(nItem,1,m_pCMMICS->m_column7);
//插入消费额
CString temp;
temp.Format("%d",m_pCMMICS->m_column8);
m_wXiaofeijilu.SetItemText(nItem,2,temp);
//插入消费时间
CString s=m_pCMMICS->m_column11.Format("%A,%B%d,%Y");
m_wXiaofeijilu.SetItemText(nItem,3,s);
}
m_pCMMICS->MoveNext();
}if (getitem==1) MessageBox("无此用户消费信息!");
}
}
}
m_pCMMICS->Close();
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -