dlgunpayedbill.cpp

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

// DlgUnpayedBill.cpp : implementation file
//

#include "stdafx.h"
#include "Lhj_cyglxt.h"
#include "DlgUnpayedBill.h"

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

/////////////////////////////////////////////////////////////////////////////
// CDlgUnpayedBill dialog
extern CDatabase m_db;

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


void CDlgUnpayedBill::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CDlgUnpayedBill)
	DDX_Control(pDX, IDC_LIST1, m_billlist);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CDlgUnpayedBill message handlers

BOOL CDlgUnpayedBill::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	
	DWORD dwExStyle = LVS_EX_FULLROWSELECT | LVS_EX_GRIDLINES |
    LVS_EX_HEADERDRAGDROP | LVS_EX_ONECLICKACTIVATE | LVS_EX_UNDERLINEHOT;
	   
  m_billlist.SetExtendedStyle(dwExStyle);
  m_billlist.InsertColumn(0,"桌号",LVCFMT_CENTER,90);
  m_billlist.InsertColumn(1,"未付账单号",LVCFMT_CENTER,180);

  
	if(!m_db.IsOpen())
	{
		MessageBox("数据库未打开");
		return 0;
	}

	TRY{
		CRecordset rs(&m_db);
		CString sql,s;
    	sql.Format("select table_no,bill_id from bill where pay_state='未付'");
		rs.Open(CRecordset::dynaset, sql);
		int i=0;
	   	while (!rs.IsEOF()) 
		{ 
		   CDBVariant var;
		  int table_no,unbillid;
          rs.GetFieldValue((short)0, var, SQL_C_SLONG);
			if (var.m_dwType != DBVT_NULL)	
				table_no= var.m_lVal;
		  s.Format("第%d桌",table_no);
		  m_billlist.InsertItem(i,s);
		  var.Clear();
		  rs.GetFieldValue((short)1, var, SQL_C_SLONG);
			if (var.m_dwType != DBVT_NULL)	
				unbillid= var.m_lVal;
		  s.Format("%d",unbillid);
		  m_billlist.SetItemText(i,1,s);
		  var.Clear();			

		  rs.MoveNext();
		}
		rs.Close();
	}

	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
}