runinfor.cpp

书店销售管理系统 用c++写的

// RunInfor.cpp : implementation file
//

#include "stdafx.h"
#include "resource.h"
#include "RunInfor.h"

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

/////////////////////////////////////////////////////////////////////////////
// CRunInfor dialog


CRunInfor::CRunInfor(CWnd* pParent /*=NULL*/)
	: CDialog(CRunInfor::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRunInfor)
	m_STime = _T("");
	//}}AFX_DATA_INIT
}


void CRunInfor::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRunInfor)
	DDX_Control(pDX, IDC_RILIST, m_RiList);
	DDX_Text(pDX, IDC_TIME, m_STime);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRunInfor, CDialog)
	//{{AFX_MSG_MAP(CRunInfor)
	ON_BN_CLICKED(IDC_BTSELECT, OnBtselect)
	ON_WM_PAINT()
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRunInfor message handlers
BOOL CRunInfor::OnInitDialog()
{
	CDialog::OnInitDialog();

	m_RiList.SetTextColor(RGB (0, 0, 0));
	m_RiList.SetBkColor(RGB(255,255,255));
	m_RiList.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);	

	m_RiList.InsertColumn(0,_T("时间"),LVCFMT_CENTER,150);
	m_RiList.InsertColumn(1,_T("收入"),LVCFMT_CENTER,100);
	m_RiList.InsertColumn(2,_T("支出"),LVCFMT_CENTER,100);
	m_RiList.InsertColumn(4,_T("备注"),LVCFMT_CENTER,180);
	
	OnRefreshData();
	return TRUE;
}

void CRunInfor::OnRefreshData()
{
	m_RiList.DeleteAllItems();
	_variant_t vt;
	try
	{
		SHOP::_RecordsetPtr pRst = pConn->Execute("select * from BUSINESSINFO",&vt,SHOP::adCmdText);
		while(!pRst->End)
		{
			_variant_t vDATE = pRst->Fields->GetItem("DATES")->Value;
			_variant_t vINCOM = pRst->Fields->GetItem(long(1))->Value; 
			_variant_t vPAYOUT = pRst->Fields->GetItem(long(2))->Value;
			_variant_t vMEMO = pRst->Fields->GetItem(long(3))->Value;
			
			CString date = (char *)_bstr_t(vDATE);
			int		income = vINCOM.iVal;
			int		payout = vPAYOUT.iVal;
			CString memo = vMEMO.bstrVal;

			CString strincom,strpayout,strearn;
			strincom.Format("%d",income);
			strpayout.Format("%d",payout);

			strincom.Insert(strincom.GetLength()-2,".");
			strpayout.Insert(strpayout.GetLength()-2,".");

			m_RiList.InsertItem(0,date);
			m_RiList.SetItemText(0,1,strincom);
			m_RiList.SetItemText(0,2,strpayout);
			m_RiList.SetItemText(0,3,memo);
			
			pRst->MoveNext();
		}
		pRst->Close();
		pRst.Release();
	}
	catch(_com_error& e)
	{
		AfxMessageBox(e.Description());
	}
}

void CRunInfor::OnBtselect() 
{
	int year,mon,day;
	if(selecttime.DoModal() == IDOK)
	{
		year = selecttime.m_Time.GetYear();
		mon = selecttime.m_Time.GetMonth();
		day = selecttime.m_Time.GetDay();
	}
	m_STime.Format("%d年%d月%d日",year,mon,day);
	this->UpdateData(false);
}


void CRunInfor::OnPaint() 
{
	CPaintDC dc(this); // device context for painting
}