checkoutview.cpp

这是一个酒店管理系统

// CheckOutView.cpp : implementation file
//

#include "stdafx.h"
#include "Final.h"
#include "CheckOutView.h"

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

/////////////////////////////////////////////////////////////////////////////
// CCheckOutView

IMPLEMENT_DYNCREATE(CCheckOutView, CFormView)

CCheckOutView::CCheckOutView()
	: CFormView(CCheckOutView::IDD)
{
	//{{AFX_DATA_INIT(CCheckOutView)
	m_orderid = _T("");
	m_orderid2 = _T("");
	//}}AFX_DATA_INIT
	CFinalApp *pApp=(CFinalApp*)AfxGetApp();
	m_pConn=pApp->m_pConnection;
}

CCheckOutView::~CCheckOutView()
{
}

void CCheckOutView::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CCheckOutView)
	DDX_Control(pDX, IDC_LIST2, m_ListCtrl2);
	DDX_Control(pDX, IDC_LIST1, m_ListCtrl1);
	DDX_Text(pDX, IDC_EDIT1, m_orderid);
	DDV_MaxChars(pDX, m_orderid, 6);
	DDX_Text(pDX, IDC_EDIT2, m_orderid2);
	DDV_MaxChars(pDX, m_orderid2, 6);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CCheckOutView, CFormView)
	//{{AFX_MSG_MAP(CCheckOutView)
	ON_BN_CLICKED(IDC_BUTTON1, OnCheckOut)
	ON_BN_CLICKED(IDC_BUTTON2, OnQueryList)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CCheckOutView diagnostics

#ifdef _DEBUG
void CCheckOutView::AssertValid() const
{
	CFormView::AssertValid();
}

void CCheckOutView::Dump(CDumpContext& dc) const
{
	CFormView::Dump(dc);
}
#endif //_DEBUG

/////////////////////////////////////////////////////////////////////////////
// CCheckOutView message handlers

void CCheckOutView::OnCheckOut() 
{
	UpdateData(TRUE);
	if(m_orderid=="")AfxMessageBox("请输入流水号!");
	else
	{
		_CommandPtr m_pComm;
	m_pComm.CreateInstance(__uuidof(Command));
	try
	{
		m_pComm->ActiveConnection=m_pConn;
		m_pComm->CommandText=_bstr_t("usercheckout");
		m_pComm->CommandType=adCmdStoredProc;
		_variant_t vvar1;
		vvar1=_variant_t(m_orderid);
		_ParameterPtr mp_var1;
		mp_var1.CreateInstance(__uuidof(Parameter));
		mp_var1=m_pComm->CreateParameter(
			_bstr_t("orderid"),
			adVarChar,
			adParamInput,
			6,
			vvar1);
		m_pComm->Parameters->Append(mp_var1); 

		m_pComm->Execute(NULL,NULL,adCmdStoredProc);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	AfxMessageBox("用户结帐操作完成!");
	GetDlgItem(IDC_EDIT1)->SetWindowText("");
	
	m_ListCtrl1.DeleteAllItems();
	_RecordsetPtr m_pRest;
	m_pRest.CreateInstance(__uuidof(Recordset));
	try
	{
		CString sql1;
		sql1.Format("select * from guestbill where orderid='%s'",m_orderid);

		m_pRest->Open(_variant_t(sql1), //查询用户信息
		m_pConn.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
		adOpenDynamic,
		adLockOptimistic,
		adCmdText);	
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	_variant_t var1,var2,var3,var4,var5,var6,var7,var8;
	int i=-1;
	while(!m_pRest->adoEOF)
	{
		var1=m_pRest->GetCollect("orderid");
		var2=m_pRest->GetCollect("guestName");
		var3=m_pRest->GetCollect("guestID");
		var4=m_pRest->GetCollect("roomfee");
		var5=m_pRest->GetCollect("servfee");
		var6=m_pRest->GetCollect("allfee");
		var7=m_pRest->GetCollect("prepay");
		var8=m_pRest->GetCollect("yingFu");
		LV_ITEM lvitem;
		lvitem.mask = LVIF_TEXT | LVIF_IMAGE | LVIF_STATE;
			lvitem.state = 0;      
			lvitem.stateMask = 0;
			char temp[50];
			lvitem.iItem = ++i;
			lvitem.iSubItem = 0;
			lvitem.pszText =itoa(i, temp, 10);
			m_ListCtrl1.InsertItem(&lvitem);
		m_ListCtrl1.SetItemText(i, 0, _T((LPCSTR)_bstr_t(var1)));
		m_ListCtrl1.SetItemText(i, 1, _T((LPCSTR)_bstr_t(var2)));
		m_ListCtrl1.SetItemText(i, 2, _T((LPCSTR)_bstr_t(var3)));
		m_ListCtrl1.SetItemText(i, 3, _T((LPCSTR)_bstr_t(var4)));
		m_ListCtrl1.SetItemText(i, 4, _T((LPCSTR)_bstr_t(var5)));
		m_ListCtrl1.SetItemText(i, 5, _T((LPCSTR)_bstr_t(var6)));
		m_ListCtrl1.SetItemText(i, 6, _T((LPCSTR)_bstr_t(var7)));
		m_ListCtrl1.SetItemText(i, 7, _T((LPCSTR)_bstr_t(var8)));	
		m_pRest->MoveNext();
	}
	
	
	}// end of else
	
}

void CCheckOutView::OnQueryList() 
{
	UpdateData(TRUE);
	if(m_orderid2=="")AfxMessageBox("请输入流水号!");
	else
	{
	m_ListCtrl2.DeleteAllItems();
	_RecordsetPtr m_pRest;
	m_pRest.CreateInstance(__uuidof(Recordset));
	try
	{
		CString sql1;
		sql1.Format("select * from serviceData where orderid='%s'",m_orderid2);
		m_pRest->Open(_variant_t(sql1), //查询用户信息
		m_pConn.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
		adOpenDynamic,
		adLockOptimistic,
		adCmdText);	
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	_variant_t var1,var2,var3,var4,var5,var6,var7;
	int i=-1;
	while(!m_pRest->adoEOF)
	{
		var1=m_pRest->GetCollect("orderid");
		var2=m_pRest->GetCollect("guestName");
		var3=m_pRest->GetCollect("roomID");
		var4=m_pRest->GetCollect("serviceID");
		var5=m_pRest->GetCollect("serviceName");
		var6=m_pRest->GetCollect("servicePrice");
		var7=m_pRest->GetCollect("serviceTime");
		LV_ITEM lvitem;
		lvitem.mask = LVIF_TEXT | LVIF_IMAGE | LVIF_STATE;
			lvitem.state = 0;      
			lvitem.stateMask = 0;
			char temp[50];
			lvitem.iItem = ++i;
			lvitem.iSubItem = 0;
			lvitem.pszText =itoa(i, temp, 10);
			m_ListCtrl2.InsertItem(&lvitem);
		m_ListCtrl2.SetItemText(i, 0, _T((LPCSTR)_bstr_t(var1)));
		m_ListCtrl2.SetItemText(i, 1, _T((LPCSTR)_bstr_t(var2)));
		m_ListCtrl2.SetItemText(i, 2, _T((LPCSTR)_bstr_t(var3)));
		m_ListCtrl2.SetItemText(i, 3, _T((LPCSTR)_bstr_t(var4)));
		m_ListCtrl2.SetItemText(i, 4, _T((LPCSTR)_bstr_t(var5)));
		m_ListCtrl2.SetItemText(i, 5, _T((LPCSTR)_bstr_t(var6)));
		m_ListCtrl2.SetItemText(i, 6, _T((LPCSTR)_bstr_t(var7)));
			
		m_pRest->MoveNext();
	}
	GetDlgItem(IDC_EDIT2)->SetWindowText("");
	} //end of else
	
}

void CCheckOutView::OnInitialUpdate() 
{
	CFormView::OnInitialUpdate();
	
	m_ListCtrl1.InsertColumn(0,"流水号",LVCFMT_LEFT,80);
	m_ListCtrl1.InsertColumn(1,"用户姓名",LVCFMT_LEFT,80);
	m_ListCtrl1.InsertColumn(2,"身份证号",LVCFMT_LEFT,100);
	m_ListCtrl1.InsertColumn(3,"房费",LVCFMT_LEFT,60);
	m_ListCtrl1.InsertColumn(4,"服务费",LVCFMT_LEFT,60);
	m_ListCtrl1.InsertColumn(5,"总费用",LVCFMT_LEFT,60);
	m_ListCtrl1.InsertColumn(6,"预付费",LVCFMT_LEFT,60);
	m_ListCtrl1.InsertColumn(7,"实际应付费",LVCFMT_LEFT,120);
	m_ListCtrl1.SetExtendedStyle(m_ListCtrl1.GetExtendedStyle() | LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT);
	
	m_ListCtrl2.InsertColumn(0,"流水号",LVCFMT_LEFT,80);
	m_ListCtrl2.InsertColumn(1,"用户姓名",LVCFMT_LEFT,80);
	m_ListCtrl2.InsertColumn(2,"房间号",LVCFMT_LEFT,80);
	m_ListCtrl2.InsertColumn(3,"服务编号",LVCFMT_LEFT,80);
	m_ListCtrl2.InsertColumn(4,"服务名称",LVCFMT_LEFT,80);
	m_ListCtrl2.InsertColumn(5,"服务费",LVCFMT_LEFT,80);
	m_ListCtrl2.InsertColumn(6,"服务时间",LVCFMT_LEFT,80);
	m_ListCtrl2.SetExtendedStyle(m_ListCtrl2.GetExtendedStyle() | LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT);


	
}