queryemptyview.cpp

酒店管理系统 1.先建立数据库HOTEL 2.选中HOTEL数据库

// QueryEmptyView.cpp : implementation file
//

#include "stdafx.h"
#include "Final.h"
#include "QueryEmptyView.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQueryEmptyView

IMPLEMENT_DYNCREATE(CQueryEmptyView, CFormView)

CQueryEmptyView::CQueryEmptyView()
	: CFormView(CQueryEmptyView::IDD)
{
	//{{AFX_DATA_INIT(CQueryEmptyView)
		// NOTE: the ClassWizard will add member initialization here
	//}}AFX_DATA_INIT
	CFinalApp *pApp=(CFinalApp*)AfxGetApp();
	pConn=pApp->m_pConnection;
}

CQueryEmptyView::~CQueryEmptyView()
{
}

void CQueryEmptyView::DoDataExchange(CDataExchange* pDX)
{
	CFormView::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CQueryEmptyView)
	DDX_Control(pDX, IDC_LIST1, m_ListCtrl);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CQueryEmptyView, CFormView)
	//{{AFX_MSG_MAP(CQueryEmptyView)
	ON_BN_CLICKED(IDC_BUTTON1, OnFresh)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQueryEmptyView diagnostics

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

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

/////////////////////////////////////////////////////////////////////////////
// CQueryEmptyView message handlers
void CQueryEmptyView::Refresh()
{
	_CommandPtr m_pCommand;
	m_pCommand.CreateInstance(__uuidof(Command));
	_RecordsetPtr m_pRst;
	m_pRst.CreateInstance(__uuidof(Recordset));
	m_ListCtrl.DeleteAllItems();
	try
	{
		m_pCommand->ActiveConnection=pConn;
		m_pCommand->CommandText=_bstr_t("queryemptyroom");
		m_pCommand->CommandType=adCmdStoredProc;
		m_pRst=m_pCommand->Execute(NULL,NULL,adCmdStoredProc);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	_variant_t var1,var2,var3,var4,var5;
	var3.vt=VT_I4;
	int i=-1;
	while(!m_pRst->adoEOF)
	{
		var1=m_pRst->GetCollect("roomID");
		var2=m_pRst->GetCollect("roomLevel");
		var3=m_pRst->GetCollect("roomPrice");
		var4=m_pRst->GetCollect("orderflag");
		var5=m_pRst->GetCollect("emptyflag");
		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_ListCtrl.InsertItem(&lvitem);
		m_ListCtrl.SetItemText(i, 0, _T((LPCSTR)_bstr_t(var1)));
		m_ListCtrl.SetItemText(i, 1, _T((LPCSTR)_bstr_t(var2)));
		m_ListCtrl.SetItemText(i, 2, _T((LPCSTR)_bstr_t(var3)));
		m_ListCtrl.SetItemText(i, 3, _T((LPCSTR)_bstr_t(var4)));
		m_ListCtrl.SetItemText(i, 4, _T((LPCSTR)_bstr_t(var5)));
		m_pRst->MoveNext();
	}
}


void CQueryEmptyView::OnInitialUpdate() 
{
	CFormView::OnInitialUpdate();
	m_ListCtrl.InsertColumn(0,"房间号",LVCFMT_LEFT,80);
	m_ListCtrl.InsertColumn(1,"房间类型",LVCFMT_LEFT,60);
	m_ListCtrl.InsertColumn(2,"房间价格",LVCFMT_LEFT,60);
	m_ListCtrl.InsertColumn(3,"是否预定",LVCFMT_LEFT,60);
	m_ListCtrl.InsertColumn(4,"是否空房",LVCFMT_LEFT,60);
	m_ListCtrl.SetExtendedStyle(m_ListCtrl.GetExtendedStyle() | LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT);
	CQueryEmptyView::Refresh();
}

void CQueryEmptyView::OnFresh() 
{
	CQueryEmptyView::Refresh();	
}