dlginfo.cpp

数据库信息管理——ShopAssistant 代码使用说明 1.创建数据库 SQLServer 2000企业管理器创建数据库方法

// DlgInfo.cpp : implementation file
//

#include "stdafx.h"
#include "Project.h"
#include "DlgInfo.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgInfo dialog


CDlgInfo::CDlgInfo(CWnd* pParent /*=NULL*/)
	: CDialog(CDlgInfo::IDD, pParent)
{
}

void CDlgInfo::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgInfo)
	DDX_Control(pDX, IDC_RILIST, m_InfoList);
	//}}AFX_DATA_MAP
}

BEGIN_MESSAGE_MAP(CDlgInfo, CDialog)
	//{{AFX_MSG_MAP(CDlgInfo)
	ON_WM_PAINT()
	ON_BN_CLICKED(IDC_Cancel, OnCancel)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CDlgInfo message handlers

BOOL CDlgInfo::OnInitDialog() 
{
	CDialog::OnInitDialog();
	//-初始化列表--------
	m_InfoList.SetTextColor(RGB (0, 0, 0));
	m_InfoList.SetBkColor(RGB(255,255,255));
	m_InfoList.SetExtendedStyle(LVS_EX_GRIDLINES|LVS_EX_FULLROWSELECT);	
	m_InfoList.InsertColumn(0,_T("日期"),LVCFMT_CENTER,150);
	m_InfoList.InsertColumn(1,_T("收入"),LVCFMT_CENTER,100);
	m_InfoList.InsertColumn(2,_T("支出"),LVCFMT_CENTER,100);
	m_InfoList.InsertColumn(3,_T("盈利"),LVCFMT_CENTER,100);
	m_InfoList.InsertColumn(4,_T("备注"),LVCFMT_CENTER,180);
	
	OnRefreshData();   //刷新列表	
	return TRUE;  
}

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

//====刷新列表========================================
void CDlgInfo::OnRefreshData()
{
	m_InfoList.DeleteAllItems();    //先删除所有列表项
	_variant_t vt;
	try
	{
		_RecordsetPtr pRst = pConn->Execute("select * from INFOTABLE",&vt,adCmdText);
		while(!pRst->End)
		{
			_variant_t vDATE = pRst->Fields->GetItem("DATE")->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);   //取列表项值
			CString memo =   vMEMO.bstrVal;
			int	income = vINCOM.iVal;
			int	payout = vPAYOUT.iVal;
			int earn   = income-payout;
			CString strincom,strpayout,strearn;
			strincom.Format("%d", income);
			strpayout.Format("%d",payout);
			strearn.Format("%d",  earn);

			m_InfoList.InsertItem(0,date);           //填入列表
			m_InfoList.SetItemText(0,1,strincom);
			m_InfoList.SetItemText(0,2,strpayout);
			m_InfoList.SetItemText(0,3,strearn);
			m_InfoList.SetItemText(0,4,memo);			
			pRst->MoveNext();
		}
		pRst->Close();
		pRst.Release();
	}
	catch(_com_error& e)
	{
		AfxMessageBox(e.Description());
	}
}

void CDlgInfo::OnCancel() 
{
	CDialog::OnCancel();
}