【VC开源代码栏目提醒】:网学会员鉴于大家对VC开源代码十分关注,论文会员在此为大家搜集整理了“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
上一篇:
CheckOutFrame.cpp
下一篇:
科研管理杂志简介