findroomstatedlg.cpp

系统主要包括住宿管理,客房管理,查询统计,报表管理,系统设置五个模块,适用于中小型宾馆酒店。

// Findroomstatedlg.cpp : implementation file
//

#include "stdafx.h"
#include "Myhotel.h"
#include "Findroomstatedlg.h"
#include "Findcheckindlg.h"

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif
extern CMyhotelApp theApp; 
/////////////////////////////////////////////////////////////////////////////
// CFindroomstatedlg dialog


CFindroomstatedlg::CFindroomstatedlg(CWnd* pParent /*=NULL*/)
	: CDialog(CFindroomstatedlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFindroomstatedlg)
	m_usenumber = 0;
	m_kongnumber = 0;
	m_mendnumber = 0;
	m_useratio = 0.0f;
	//}}AFX_DATA_INIT
}


void CFindroomstatedlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFindroomstatedlg)
	DDX_Control(pDX, IDC_roomnumber8408, m_btn8408);
	DDX_Control(pDX, IDC_roomnumber8406, m_btn8406);
	DDX_Control(pDX, IDC_roomnumber8404, m_btn8404);
	DDX_Control(pDX, IDC_roomnumber8403, m_btn8403);
	DDX_Control(pDX, IDC_roomnumber8402, m_btn8402);
	DDX_Control(pDX, IDC_roomnumber8401, m_btn8401);
	DDX_Control(pDX, IDC_roomnumber8319, m_btn8319);
	DDX_Control(pDX, IDC_roomnumber8318, m_btn8318);
	DDX_Control(pDX, IDC_roomnumber8317, m_btn8317);
	DDX_Control(pDX, IDC_roomnumber8316, m_btn8316);
	DDX_Control(pDX, IDC_roomnumber8315, m_btn8315);
	DDX_Control(pDX, IDC_roomnumber8314, m_btn8314);
	DDX_Control(pDX, IDC_roomnumber8313, m_btn8313);
	DDX_Control(pDX, IDC_roomnumber8312, m_btn8312);
	DDX_Control(pDX, IDC_roomnumber8311, m_btn8311);
	DDX_Control(pDX, IDC_roomnumber8310, m_btn8310);
	DDX_Control(pDX, IDC_roomnumber8309, m_btn8309);
	DDX_Control(pDX, IDC_roomnumber8308, m_btn8308);
	DDX_Control(pDX, IDC_roomnumber8307, m_btn8307);
	DDX_Control(pDX, IDC_roomnumber8306, m_btn8306);
	DDX_Control(pDX, IDC_roomnumber8305, m_btn8305);
	DDX_Control(pDX, IDC_roomnumber8304, m_btn8304);
	DDX_Control(pDX, IDC_roomnumber8303, m_btn8303);
	DDX_Control(pDX, IDC_roomnumber8302, m_btn8302);
	DDX_Control(pDX, IDC_roomnumber8301, m_btn8301);
	DDX_Text(pDX, IDC_showusenumber, m_usenumber);
	DDX_Text(pDX, IDC_shownullnumber, m_kongnumber);
	DDX_Text(pDX, IDC_showmendnumber, m_mendnumber);
	DDX_Text(pDX, IDC_showuseratio, m_useratio);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CFindroomstatedlg, CDialog)
	//{{AFX_MSG_MAP(CFindroomstatedlg)
	ON_BN_CLICKED(IDC_roomnumber8301, Onroomnumber8301)
	ON_BN_CLICKED(IDC_roomnumber8302, Onroomnumber8302)
	ON_BN_CLICKED(IDC_roomnumber8303, Onroomnumber8303)
	ON_BN_CLICKED(IDC_roomnumber8304, Onroomnumber8304)
	ON_BN_CLICKED(IDC_roomnumber8305, Onroomnumber8305)
	ON_BN_CLICKED(IDC_roomnumber8306, Onroomnumber8306)
	ON_BN_CLICKED(IDC_roomnumber8307, Onroomnumber8307)
	ON_BN_CLICKED(IDC_roomnumber8308, Onroomnumber8308)
	ON_BN_CLICKED(IDC_roomnumber8309, Onroomnumber8309)
	ON_BN_CLICKED(IDC_roomnumber8310, Onroomnumber8310)
	ON_BN_CLICKED(IDC_roomnumber8311, Onroomnumber8311)
	ON_BN_CLICKED(IDC_roomnumber8312, Onroomnumber8312)
	ON_BN_CLICKED(IDC_roomnumber8313, Onroomnumber8313)
	ON_BN_CLICKED(IDC_roomnumber8314, Onroomnumber8314)
	ON_BN_CLICKED(IDC_roomnumber8315, Onroomnumber8315)
	ON_BN_CLICKED(IDC_roomnumber8316, Onroomnumber8316)
	ON_BN_CLICKED(IDC_roomnumber8317, Onroomnumber8317)
	ON_BN_CLICKED(IDC_roomnumber8318, Onroomnumber8318)
	ON_BN_CLICKED(IDC_roomnumber8319, Onroomnumber8319)
	ON_BN_CLICKED(IDC_roomnumber8401, Onroomnumber8401)
	ON_BN_CLICKED(IDC_roomnumber8402, Onroomnumber8402)
	ON_BN_CLICKED(IDC_roomnumber8403, Onroomnumber8403)
	ON_BN_CLICKED(IDC_roomnumber8404, Onroomnumber8404)
	ON_BN_CLICKED(IDC_roomnumber8406, Onroomnumber8406)
	ON_BN_CLICKED(IDC_roomnumber8408, Onroomnumber8408)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CFindroomstatedlg message handlers

BOOL CFindroomstatedlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//变量初始化
    useroomnumber=0;
	kongroomnumber=0;
	mendroomnumber=0;
	useratio=0;
///////////////////////////////////////////
	
	m_pRecordset.CreateInstance(__uuidof(Recordset));

	_variant_t var;
	int i=0;
	// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
	// 
	try
	{
		m_pRecordset->Open("SELECT * FROM roomsetting",                // 查询表中所有字段
							theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
							adOpenDynamic,
							adLockOptimistic,
							adCmdText);
	}
	catch(_com_error *e)
	{//捕获可能出现的异常
		AfxMessageBox(e->ErrorMessage());
	}
	
	try
	{
		if(!m_pRecordset->BOF)//判断指针是否在数据集最后
			m_pRecordset->MoveFirst();
		else
		{
			MessageBox("表内数据为空","客房管理系统");
			return false;
		}

		// read data from the database table 
		while(!m_pRecordset->adoEOF)
		{   //读取数据表内房间号字段内容
			var = m_pRecordset->GetCollect("房间号");
			if(var.vt != VT_NULL)
				findroomstate_roomnumber = (LPCSTR)_bstr_t(var);
			    
			//读取数据表内房间类型字段内容
			var = m_pRecordset->GetCollect("房间类型");
			if(var.vt != VT_NULL)
				findroomstate_roomlevel = (LPCSTR)_bstr_t(var);
			//读取数据表内价格字段内容
			var = m_pRecordset->GetCollect("价格");
			if(var.vt != VT_NULL)
				findroomstate_roommoney = (LPCSTR)_bstr_t(var);
			//读取数据表内房态字段内容
			var = m_pRecordset->GetCollect("房态");
			if(var.vt != VT_NULL)
				findroomstate_roomstate = (LPCSTR)_bstr_t(var);
		       
              //读取数据表内标志字段内容
			var = m_pRecordset->GetCollect("标志");
			if(var.vt != VT_NULL)
				findroomstate_roomsign = (LPCSTR)_bstr_t(var);
		   //读取数据表内备注字段内容
			var = m_pRecordset->GetCollect("备注");
			if(var.vt != VT_NULL)
				findroomstate_roombeizhu = (LPCSTR)_bstr_t(var);
		   //读取数据表内配置字段内容
			var = m_pRecordset->GetCollect("配置");
			if(var.vt != VT_NULL)
				findroomstate_roomsetting = (LPCSTR)_bstr_t(var);
			//读取数据表内使用设置字段内容
			var = m_pRecordset->GetCollect("使用设置");
			if(var.vt != VT_NULL)
				findroomstate_roomusesetting = (LPCSTR)_bstr_t(var);
			//读取数据表内营业日期字段内容
			var = m_pRecordset->GetCollect("营业日期");
			if(var.vt != VT_NULL)
				findroomstate_roomusedate = (LPCSTR)_bstr_t(var);
			
            i++;
		    //判断8301的房间状态，并显示
			 if(findroomstate_roomnumber=="8301")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8301.SubclassDlgItem(IDC_roomnumber8301,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8301.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8301.SetIcon(IDI_ICONmend);	
					   mendroomnumber++;
					}
				}
			 //判断8302的房间状态，并显示
			 if(findroomstate_roomnumber=="8302")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8302.SubclassDlgItem(IDC_roomnumber8302,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8302.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8302.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8303的房间状态，并显示
			 if(findroomstate_roomnumber=="8303")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8303.SubclassDlgItem(IDC_roomnumber8303,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8303.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8303.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8304的房间状态，并显示
			 if(findroomstate_roomnumber=="8304")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8304.SubclassDlgItem(IDC_roomnumber8304,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8304.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8304.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8305的房间状态，并显示
			 if(findroomstate_roomnumber=="8305")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8305.SubclassDlgItem(IDC_roomnumber8305,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8305.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8305.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8306的房间状态，并显示
			 if(findroomstate_roomnumber=="8306")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8306.SubclassDlgItem(IDC_roomnumber8306,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8306.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8306.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8307的房间状态，并显示
			 if(findroomstate_roomnumber=="8307")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8307.SubclassDlgItem(IDC_roomnumber8307,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8307.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8307.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8308的房间状态，并显示
			 if(findroomstate_roomnumber=="8308")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8308.SubclassDlgItem(IDC_roomnumber8308,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8308.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8308.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8309的房间状态，并显示
			 if(findroomstate_roomnumber=="8309")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8309.SubclassDlgItem(IDC_roomnumber8309,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8309.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8309.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8310的房间状态，并显示
			 if(findroomstate_roomnumber=="8310")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8310.SubclassDlgItem(IDC_roomnumber8310,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8310.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8310.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8311的房间状态，并显示
			 if(findroomstate_roomnumber=="8311")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8311.SubclassDlgItem(IDC_roomnumber8311,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8311.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8311.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8312的房间状态，并显示
			 if(findroomstate_roomnumber=="8312")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8301.SubclassDlgItem(IDC_roomnumber8312,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8312.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8312.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8313的房间状态，并显示
			 if(findroomstate_roomnumber=="8313")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8313.SubclassDlgItem(IDC_roomnumber8313,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8313.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8313.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8314的房间状态，并显示
			 if(findroomstate_roomnumber=="8314")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8314.SubclassDlgItem(IDC_roomnumber8314,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8314.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8314.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}
				}
			 //判断8315的房间状态，并显示
			 if(findroomstate_roomnumber=="8315")
				{   COLORREF crStandard=::GetSysColor(COLOR_BTNFACE);
					m_btn8315.SubclassDlgItem(IDC_roomnumber8315,GetOwner());
	                if(findroomstate_roomstate=="入住")
					{//在该按钮上载入入住图标
					   m_btn8315.SetIcon(IDI_ICONuse);
					   useroomnumber++;
					}
					else if(findroomstate_roomstate=="维修")
					{//在该按钮上载入维修图标
					   m_btn8315.SetIcon(IDI_ICONmend);
					   mendroomnumber++;
					}