recorddlg.cpp

< SQL SERVER 2000 案例教程>>,冶金工业出版社,这本书的代码

// RecordDlg.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "RecordDlg.h"

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

extern CDatabase m_database;
extern CString username;
extern CString userpower;

/////////////////////////////////////////////////////////////////////////////
// CRecordDlg dialog


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


void CRecordDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRecordDlg)
	DDX_Control(pDX, IDC_RECORDLIST, m_recordlist);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRecordDlg, CDialog)
	//{{AFX_MSG_MAP(CRecordDlg)
	ON_BN_CLICKED(IDC_SEARCHRECORD, OnSearchrecord)
	ON_BN_CLICKED(IDC_STATRECORD, OnStatrecord)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRecordDlg message handlers

BOOL CRecordDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	m_recordlist.InsertColumn(0,"商品编号");
	m_recordlist.InsertColumn(1,"商品名称");
	m_recordlist.InsertColumn(2,"价格");
	m_recordlist.InsertColumn(3,"数量");
	m_recordlist.InsertColumn(4,"售货员");
	m_recordlist.InsertColumn(5,"日期");
	CRect r;
	m_recordlist.GetWindowRect(&r);
	int wid=r.Width()/6;
    for(int i=0;i<6;i++){
		m_recordlist.SetColumnWidth(i,wid);
	}
	m_recordlist.SetExtendedStyle(LVS_EX_FULLROWSELECT|LVS_EX_GRIDLINES);
	CString sql;
//	sql.Format("select * from 售货记录表");
//	OnRefreshData(sql);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CRecordDlg::OnSearchrecord() 
{
	CString sql;
	sql.Format("select * from 售货记录表");
	OnRefreshData(sql);
	
}
void CRecordDlg::OnRefreshData(CString sql){
	m_recordlist.DeleteAllItems();
	CSellRecordSet m_sellset;
	m_sellset.m_pDatabase=&m_database;
	m_sellset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	m_sellset.MoveFirst();
	CString str;
	int i=0;
	while(!m_sellset.IsEOF()){
		while(m_sellset.IsDeleted()){
			m_sellset.MoveNext();
		}
		str=m_sellset.m_column2;
		str.TrimRight();
		m_recordlist.InsertItem(i,str);
		str=m_sellset.m_column3;
		str.TrimRight();
		m_recordlist.SetItemText(i,1,str);
		str.Format("%.2f",m_sellset.m_column4);
		m_recordlist.SetItemText(i,2,str);
		str.Format("%d",m_sellset.m_column5);
		m_recordlist.SetItemText(i,3,str);
		str=m_sellset.m_column6;
		str.TrimRight();
		m_recordlist.SetItemText(i,4,str);
		str.Format("%d-%d-%d %d:%d:%d",
		    m_sellset.m_column7.GetYear(),m_sellset.m_column7.GetMonth(),m_sellset.m_column7.GetDay(),
			m_sellset.m_column7.GetHour(),m_sellset.m_column7.GetMinute(),m_sellset.m_column7.GetSecond());
		m_recordlist.SetItemText(i,5,str);
		m_sellset.MoveNext();
	}
}

void CRecordDlg::OnStatrecord() 
{
	CStatDlg statdlg;
	statdlg.DoModal();
	
}