queryroomdlg.cpp

这是一个酒店管理系统

// QueryRoomDlg.cpp : implementation file
//

#include "stdafx.h"
#include "Final.h"
#include "QueryRoomDlg.h"

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

/////////////////////////////////////////////////////////////////////////////
// CQueryRoomDlg dialog


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


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


BEGIN_MESSAGE_MAP(CQueryRoomDlg, CDialog)
	//{{AFX_MSG_MAP(CQueryRoomDlg)
	ON_WM_DESTROY()
	ON_BN_CLICKED(IDC_BUTTON1, OnButton1)
	ON_BN_CLICKED(IDC_BUTTON2, OnFresh)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CQueryRoomDlg message handlers

BOOL CQueryRoomDlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CFinalApp *pApp=(CFinalApp *)AfxGetApp();
	m_pConn=pApp->m_pConnection;
	m_ListCtrl.InsertColumn(0,"房间号",LVCFMT_LEFT,60);
	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.InsertColumn(5,"是否空房",LVCFMT_LEFT,60);
	m_ListCtrl.SetExtendedStyle(m_ListCtrl.GetExtendedStyle() | LVS_EX_GRIDLINES | LVS_EX_FULLROWSELECT);
	CQueryRoomDlg::Refresh();
	
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CQueryRoomDlg::OnDestroy() 
{
	CDialog::OnDestroy();
	delete this;
	// TODO: Add your message handler code here
	
}

void CQueryRoomDlg::OnButton1() 
{
	CQueryRoomDlg::OnDestroy();	
}

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

void CQueryRoomDlg::Refresh()
{
	m_ListCtrl.DeleteAllItems();
	_RecordsetPtr m_pRst;
	m_pRst.CreateInstance(__uuidof(Recordset));
	try
	{
		m_pRst->Open("select * from roomTab order by RoomID ASC", //查询用户信息
		m_pConn.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
		adOpenDynamic,
		adLockOptimistic,
		adCmdText);
	}
	catch(_com_error *e)
	{
		AfxMessageBox(e->ErrorMessage());
	}
	_variant_t var1,var2,var3,var4,var5,var6;
	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("orderid");
		var5=m_pRst->GetCollect("orderflag");
		var6=m_pRst->GetCollect("emptyflag");
		if(var4.vt==VT_NULL)var4=_variant_t(_T("无"));
		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_ListCtrl.SetItemText(i, 5, _T((LPCSTR)_bstr_t(var6)));
		m_pRst->MoveNext();
	}
	
}