// ShowHistoryReg.cpp : implementation file
//

#include "stdafx.h"
#include "LYFZIPManage.h"
#include "ShowHistoryReg.h"
#include "mysqldata.h"
#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

/////////////////////////////////////////////////////////////////////////////
// ShowHistoryReg dialog


ShowHistoryReg::ShowHistoryReg(CWnd* pParent /*=NULL*/)
	: CDialog(ShowHistoryReg::IDD, pParent)
{
	//{{AFX_DATA_INIT(ShowHistoryReg)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
}


void ShowHistoryReg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(ShowHistoryReg)
	DDX_Control(pDX, IDC_LIST2, m_List1);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// ShowHistoryReg message handlers

BOOL ShowHistoryReg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	m_List1.SetHeadings("账号,60;冲值金额,80;短信数,60;价格,60;日期,90" );
 	m_List1.LoadColumnInfo(_T("115"));


	CRecordset myset(&g_db);
	CString	sql="select count(*) as cot from recharge where account='"+m_account+"'"; 
	myset.Open (CRecordset::forwardOnly, sql);
	myset.GetFieldValue ("cot", sql);
	myset.Close();

	m_List1array.SetSize(atol(sql) , 1 );
	RstReCharge rsSt;
	rsSt.m_strFilter ="account='"+m_account+"'";
	rsSt.Open();
    DWORD ii=0;
	float summoney=0;
	float sumcount=0;
	while(!rsSt.IsEOF())
	{
    	m_List1array.ElementAt (ii).RemoveAll ();
		m_List1array.ElementAt (ii).Add(rsSt.m_account) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_money) ;
		summoney+=atof(rsSt.m_money);
		sumcount+=atof(rsSt.m_count);
		m_List1array.ElementAt (ii).Add(rsSt.m_count) ;
		if(atof(rsSt.m_count))
			sql.Format ("%0.2f", atof(rsSt.m_money)/atof(rsSt.m_count));
		else
			sql="0";
		m_List1array.ElementAt (ii).Add(sql) ;
		m_List1array.ElementAt (ii).Add(rsSt.m_timestamp) ;
		ii++;
		rsSt.MoveNext();if(m_List1array.GetSize ()<=ii)break;
	}
	rsSt.Close();m_List1array.SetSize(ii , 1 );


	
	m_List1.m_arLabels.SetSize( m_List1array.GetSize ()+2, 1 );
     for(ii=0; ii<m_List1array.GetSize (); ii++)
	 {
		m_List1.m_arLabels.ElementAt (ii).Copy (m_List1array.ElementAt (ii));
	 }

	 ii=m_List1array.GetSize ();
	 m_List1.m_arLabels.ElementAt (ii).RemoveAll ();
	 m_List1.m_arLabels.ElementAt (ii).Add ("");
	 m_List1.m_arLabels.ElementAt (ii).Add ("");
	 m_List1.m_arLabels.ElementAt (ii).Add ("");
	 m_List1.m_arLabels.ElementAt (ii).Add ("");
	 m_List1.m_arLabels.ElementAt (ii).Add ("");
	 ii++;



	 CString str;
	 m_List1.m_arLabels.ElementAt (ii).RemoveAll ();
	 m_List1.m_arLabels.ElementAt (ii).Add ("总计:");
	 str.Format ("%0.1f", summoney);
	 m_List1.m_arLabels.ElementAt (ii).Add (str);
	 str.Format ("%0.0f", sumcount);
	 m_List1.m_arLabels.ElementAt (ii).Add (str);
	 if(sumcount)
		str.Format ("%0.4f", summoney/sumcount);
	 else
		str="0";
	 m_List1.m_arLabels.ElementAt (ii).Add (str);
	 m_List1.m_arLabels.ElementAt (ii).Add ("");




//	float summoney=0;
//	float sumcount=0;



	m_List1.m_arLabels.SetSize(m_List1array.GetSize ()+2, 1);
	m_List1.m_LabelCount=m_List1array.GetSize ()+2;
	m_List1.SetItemCountEx (m_List1array.GetSize ()+2);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}