messagedlg.cpp

本售货管理系统用vc和sql开发

// MessageDlg.cpp : implementation file
//

#include "stdafx.h"
#include "售货系统.h"
#include "MessageDlg.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;
/////////////////////////////////////////////////////////////////////////////
// CMessageDlg dialog


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


void CMessageDlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CMessageDlg)
	DDX_Control(pDX, IDC_MESSLIST, m_messlist);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CMessageDlg, CDialog)
	//{{AFX_MSG_MAP(CMessageDlg)
	ON_BN_CLICKED(IDC_ADDMESS, OnAddmess)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CMessageDlg message handlers

void CMessageDlg::OnAddmess() 
{
	// TODO: Add your control notification handler code here
	
}

BOOL CMessageDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	m_messlist.InsertColumn(0,"商品编号");
	m_messlist.InsertColumn(1,"商品名");
	m_messlist.InsertColumn(2,"价格");
	m_messlist.InsertColumn(3,"类型");
	m_messlist.InsertColumn(4,"备注");
	CRect r;
	m_messlist.GetWindowRect(&r);
	int wid=r.Width()/5;
	for(int i=0;i<5;i++){
		m_messlist.SetColumnWidth(i,wid);
	}
	m_messlist.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 CMessageDlg::OnRefreshData(CString sql){
	CString str;
	m_messlist.DeleteAllItems();
	CMessSet m_messset;
	m_messset.m_pDatabase=&m_database;
	m_messset.Open(AFX_DB_USE_DEFAULT_TYPE,sql);
	m_messset.MoveFirst();
	int i=0;
	while(!m_messset.IsEOF()){
		while(m_messset.IsDeleted()){
			m_messset.MoveNext();
		}
		str=m_messset.m_column1;
		str.TrimRight();
		m_messlist.InsertItem(i,str);
		str=m_messset.m_column2;
		str.TrimRight();
		m_messlist.SetItemText(i,1,str);
		str.Format("%f",m_messset.m_column3);
		m_messlist.SetItemText(i,2,str);
		str=m_messset.m_column4;
		str.TrimRight();
		m_messlist.SetItemText(i,3,str);
		str=m_messset.m_column5;
		str.TrimRight();
		m_messlist.SetItemText(i,4,str);
		m_messset.MoveNext();
	}
}