managestatisticsconsume.cpp

模拟银行信用卡的业务流程

// ManageStatisticsConsume.cpp : implementation file
//

#include "stdafx.h"
#include "CreditCardManagement.h"
#include "ManageStatisticsConsume.h"

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

/////////////////////////////////////////////////////////////////////////////
// CManageStatisticsConsume dialog


CManageStatisticsConsume::CManageStatisticsConsume(CWnd* pParent /*=NULL*/)
	: CDialog(CManageStatisticsConsume::IDD, pParent)
{
	//{{AFX_DATA_INIT(CManageStatisticsConsume)
	m_wQishishijian = COleDateTime::GetCurrentTime();
	m_wZhongzhishijian = COleDateTime::GetCurrentTime();
	m_wXinyongdu0 = 0;
	m_wXinyongdu1 = 0;
	m_wXinyongdu2 = 0;
	//}}AFX_DATA_INIT
}


void CManageStatisticsConsume::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CManageStatisticsConsume)
	DDX_Text(pDX, IDC_EDIT1, m_wQishishijian);
	DDX_Text(pDX, IDC_EDIT2, m_wZhongzhishijian);
	DDX_Text(pDX, IDC_EDIT3, m_wXinyongdu0);
	DDX_Text(pDX, IDC_EDIT4, m_wXinyongdu1);
	DDX_Text(pDX, IDC_EDIT5, m_wXinyongdu2);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CManageStatisticsConsume, CDialog)
	//{{AFX_MSG_MAP(CManageStatisticsConsume)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CManageStatisticsConsume message handlers

void CManageStatisticsConsume::OnOK() 
{
	m_pCMSCS=&CMSCS;
	UpdateData(TRUE);
    //初始化变量
    m_wXinyongdu0=0;
    m_wXinyongdu1=0;
    m_wXinyongdu2=0;
	if((m_wQishishijian.GetStatus()==0)&&(m_wZhongzhishijian.GetStatus()==0))
	{//首先判断起始时间和终止时间的有效性
	//若有效则进行如下操作
    if (m_wQishishijian>m_wZhongzhishijian) 
		MessageBox("请输入正确的时间!");
	else
	{
	
	//统计信用度为 0 的用户的总的消费额
	m_pCMSCS->m_strFilter="[消费文件].[身份证号]=[账户文件].[身份证号]";
    m_pCMSCS->m_strFilter+="and";
	m_pCMSCS->m_strFilter+="[信用度级别]=0";
	m_pCMSCS->Open();
	int getitem=1;
	while (!m_pCMSCS->IsEOF())
	{
  	  //对在起始时间和终止时间范围内的记录进行操作
      time_t hh;
	  hh=m_pCMSCS->m_column6.GetTime();
	  COleDateTime *ff;
	  ff=new COleDateTime(hh);
	  if ((ff->m_dt>=m_wQishishijian.m_dt)&&(ff->m_dt<=m_wZhongzhishijian.m_dt))
	  {
		  m_wXinyongdu0+=m_pCMSCS->m_column3;
		  getitem=0;
	  }
		  m_pCMSCS->MoveNext();	
	}
//	if (getitem==1) MessageBox("无此时间段的信用度为 0 的用户!");
	//统计信用度为 1 的用户的总的消费额
    getitem=1;
	m_pCMSCS->m_strFilter="[消费文件].[身份证号]=[账户文件].[身份证号]";
    m_pCMSCS->m_strFilter+="and";
	m_pCMSCS->m_strFilter+="[信用度级别]=1";
	m_pCMSCS->Requery();
	while (!m_pCMSCS->IsEOF())
	{
  	  //对在起始时间和终止时间范围内的记录进行操作
      time_t hh;
	  hh=m_pCMSCS->m_column6.GetTime();
	  COleDateTime *ff;
	  ff=new COleDateTime(hh);
	  if ((ff->m_dt>=m_wQishishijian.m_dt)&&(ff->m_dt<=m_wZhongzhishijian.m_dt))
      {
		  m_wXinyongdu1+=m_pCMSCS->m_column3;
	      getitem=0;
	  }
	  m_pCMSCS->MoveNext();	
	}
//	if(getitem==1) MessageBox("无此时间段的信用度为 1 的用户!");
	//统计信用度为 2 的用户的总的消费额
	getitem=1;
	m_pCMSCS->m_strFilter="[消费文件].[身份证号]=[账户文件].[身份证号]";
    m_pCMSCS->m_strFilter+="and";
	m_pCMSCS->m_strFilter+="[信用度级别]=2";
	m_pCMSCS->Requery();
	while (!m_pCMSCS->IsEOF())
	{
  	  //对在起始时间和终止时间范围内的记录进行操作
      time_t hh;
	  hh=m_pCMSCS->m_column6.GetTime();
	  COleDateTime *ff;
	  ff=new COleDateTime(hh);
	  if ((ff->m_dt>=m_wQishishijian.m_dt)&&(ff->m_dt<=m_wZhongzhishijian.m_dt))
	  {
		  m_wXinyongdu2+=m_pCMSCS->m_column3;
	      getitem=0;
	  }
	  m_pCMSCS->MoveNext();	
	}
  // if(getitem==1) MessageBox("无此时间段的信用度为 2 的用户!");
   m_pCMSCS->Close();
	}
   UpdateData(FALSE);
}}