dlgfooddetail.cpp

本系统功能主要有两大块组成：前台销售管理功能和后台数据管理功能。 前台销售管理系统,包括：开单

// DlgFoodDetail.cpp : implementation file
//

#include "stdafx.h"
#include "Lhj_cyglxt.h"
#include "DlgFoodDetail.h"
#include "Lhj_cyglxtDlg.h"
#include "DlgPos.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgFoodDetail dialog
extern CString ShowFoodId;
extern CDatabase m_db;

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


void CDlgFoodDetail::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgFoodDetail)
	DDX_Control(pDX, IDC_LIST_fooddetail, m_fooddetail);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CDlgFoodDetail message handlers

BOOL CDlgFoodDetail::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	if(!UpdateData())
		return 0;
	if(!m_db.IsOpen())
	{
		MessageBox("数据库未打开");
		return 0;
	}
TRY
{
		CRecordset rs(&m_db);
		CString sql;
		DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES |
    LVS_EX_HEADERDRAGDROP | LVS_EX_ONECLICKACTIVATE | LVS_EX_UNDERLINEHOT;
		m_fooddetail.SetExtendedStyle(dwExStyle);
		m_fooddetail.InsertColumn(0,"菜类别",LVCFMT_CENTER,80);
		m_fooddetail.InsertColumn(1,"菜编号",LVCFMT_CENTER,100);
		m_fooddetail.InsertColumn(2,"菜名",LVCFMT_CENTER,120);
		m_fooddetail.InsertColumn(3,"价格",LVCFMT_CENTER,60);
		m_fooddetail.InsertColumn(4,"口味",LVCFMT_CENTER,60);
		m_fooddetail.InsertColumn(5,"菜肴介绍",LVCFMT_CENTER,290);
		sql.Format("select class_name,food_id,food_name,food_price,food_taste,food_infor from menu_infor,food_class where food_id='%s' and food_class.food_class=menu_infor.food_class ",ShowFoodId);
     	rs.Open(CRecordset::dynaset, sql);
		CString classname,foodid,foodname,price,food_taste,food_infor;int i=0;
		while (!rs.IsEOF()) 
		{ 
		   rs.GetFieldValue((short)0,classname);
		   m_fooddetail.InsertItem(i,classname);
		   rs.GetFieldValue(1,foodid);
		   m_fooddetail.SetItemText(i,1,foodid);
		   rs.GetFieldValue(2,foodname);
		   m_fooddetail.SetItemText(i,2,foodname);
		   rs.GetFieldValue(3,price);
		   m_fooddetail.SetItemText(i,3,price);
		   rs.GetFieldValue(4,food_taste);
		   m_fooddetail.SetItemText(i,4,food_taste);
		   rs.GetFieldValue(5,food_infor);
		   m_fooddetail.SetItemText(i,5,food_infor);
		   rs.MoveNext();
		}
		rs.Close();
		UpdateData(FALSE);
}
CATCH(CDBException,ex)
	{
		AfxMessageBox (ex->m_strError);
		AfxMessageBox (ex->m_strStateNativeOrigin);		
	}
	AND_CATCH(CMemoryException,pEx)
	{
		pEx->ReportError();
		AfxMessageBox ("memory exception");
	}
	AND_CATCH(CException,e)
	{
		TCHAR szError[100];
		e->GetErrorMessage(szError,100);
		AfxMessageBox (szError);
	}
	END_CATCH   
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}