📄 roomsaledlg.cpp

📁 系统主要包括住宿管理,客房管理,查询统计,报表管理,系统设置五个模块,适用于中小型宾馆酒店。
💻 CPP
📖 第 1 页 / 共 2 页
字号:
12 下一页
// Roomsaledlg.cpp : implementation file
//

#include "stdafx.h"
#include "Myhotel.h"
#include "Roomsaledlg.h"
#include <stdlib.h>
#include <stdio.h>

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


CRoomsaledlg::CRoomsaledlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRoomsaledlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRoomsaledlg)
	m_roomsaleendtime = 0;
	m_roomsaleenddate = 0;
	m_roomsalebegintime = 0;
	m_roomsalebegindate = 0;
	m_show_meetingmoney = 0.0f;
	m_show_backroommoney = 0.0f;
	m_show_mendmoney = 0.0f;
	m_show_mixmoney = 0.0f;
	m_show_parkmoney = 0.0f;
	m_show_pregetroommoney = 0.0f;
	m_show_shouldgetmoney = 0.0f;
	m_show_sumgetmoney = 0.0f;
	m_show_telmoney = 0.0f;
	m_showuser = _T("");
	//}}AFX_DATA_INIT
}


void CRoomsaledlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRoomsaledlg)
	DDX_Control(pDX, IDC_LIST_roomsale, m_roomsale_list);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKERroomsale_endtime, m_roomsaleendtime);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKERroomsale_enddate, m_roomsaleenddate);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKERroomsale_begintime, m_roomsalebegintime);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKERroomsale_begindate, m_roomsalebegindate);
	DDX_Text(pDX, IDC_meetingmoney, m_show_meetingmoney);
	DDX_Text(pDX, IDC_backroommoney, m_show_backroommoney);
	DDX_Text(pDX, IDC_mendmoney, m_show_mendmoney);
	DDX_Text(pDX, IDC_mixmoney, m_show_mixmoney);
	DDX_Text(pDX, IDC_parkmoney, m_show_parkmoney);
	DDX_Text(pDX, IDC_pregetroommoney, m_show_pregetroommoney);
	DDX_Text(pDX, IDC_shouldgetmoney, m_show_shouldgetmoney);
	DDX_Text(pDX, IDC_sumgetmoney, m_show_sumgetmoney);
	DDX_Text(pDX, IDC_telmoney, m_show_telmoney);
	DDX_Text(pDX, IDC_STATICshowuser, m_showuser);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRoomsaledlg, CDialog)
	//{{AFX_MSG_MAP(CRoomsaledlg)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRoomsaledlg message handlers

BOOL CRoomsaledlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	CTime tTime;
 	tTime=tTime.GetCurrentTime(); 
	//设置默认时间
    m_roomsaleenddate=tTime;
	// TODO: Add extra initialization here
	//设置列表框颜色
	m_roomsale_list.SetTextColor(RGB (0, 0, 0));
	m_roomsale_list.SetTextBkColor(RGB (140, 180, 20));
	//初始化列表框
    m_roomsale_list.InsertColumn(1,"凭证号码");
	 m_roomsale_list.InsertColumn(2,"姓名");
	
	 m_roomsale_list.InsertColumn(3,"房间号");
	 	
	 m_roomsale_list.InsertColumn(4,"房价");

	 m_roomsale_list.InsertColumn(5,"天数");
	 m_roomsale_list.InsertColumn(6,"结款方式");

	 m_roomsale_list.InsertColumn(7,"折扣");
	 m_roomsale_list.InsertColumn(8,"应收宿费");

	m_roomsale_list.InsertColumn(9,"杂费");

	 m_roomsale_list.InsertColumn(10,"电话费");

	 m_roomsale_list.InsertColumn(11,"会议费");

	 m_roomsale_list.InsertColumn(12,"存车费");

	 m_roomsale_list.InsertColumn(13,"赔偿费");

	 m_roomsale_list.InsertColumn(14,"实收金额");
	 
	 m_roomsale_list.InsertColumn(15,"预收宿费");
	 m_roomsale_list.InsertColumn(16,"退还宿费");
	 
	
	RECT rect;
	 m_roomsale_list.GetWindowRect(&rect);
	int wid=rect.right-rect.left;
	int i=0;
	 m_roomsale_list.SetColumnWidth(0,wid/16);
	 m_roomsale_list.SetColumnWidth(1,wid/16);
	 m_roomsale_list.SetColumnWidth(2,wid/16);
	 m_roomsale_list.SetColumnWidth(3,wid/20);
	 m_roomsale_list.SetColumnWidth(4,wid/20);
	 m_roomsale_list.SetColumnWidth(5,wid/16);
	 m_roomsale_list.SetColumnWidth(6,wid/16);
	 m_roomsale_list.SetColumnWidth(7,wid/16);
	
	 m_roomsale_list.SetColumnWidth(8,wid/16);
	m_roomsale_list.SetColumnWidth(9,wid/16);
     m_roomsale_list.SetColumnWidth(10,wid/16);
	m_roomsale_list.SetColumnWidth(11,wid/16);
    m_roomsale_list.SetColumnWidth(12,wid/16);
	m_roomsale_list.SetColumnWidth(13,wid/14);
    m_roomsale_list.SetColumnWidth(14,wid/14);
	m_roomsale_list.SetColumnWidth(15,wid/14);

	
     //设置列表框风格
	 m_roomsale_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
				// 使用ADO创建数据库记录集
	m_pRecordset.CreateInstance(__uuidof(Recordset));

		_variant_t var;

	// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
	//
	try
	{//打开数据表
		m_pRecordset->Open("SELECT * FROM checkoutregtable",                // 查询表中所有字段
							theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
							adOpenDynamic,
							adLockOptimistic,
							adCmdText);
	}
	catch(_com_error *e)
	{//抛出异常情况
		AfxMessageBox(e->ErrorMessage());
	}
	try
	{
		if(!m_pRecordset->BOF)//判断指针是否在数据集最后
			m_pRecordset->MoveFirst();
		else
		{
			AfxMessageBox("表内数据为空");
			return false;
		}

		// read data from the database table 
		while(!m_pRecordset->adoEOF)
		{//循环读取数据
			//读取数据表中凭证号码字段数据
			var = m_pRecordset->GetCollect("凭证号码");
			if(var.vt != VT_NULL)
				m_regnumber = (LPCSTR)_bstr_t(var);
             //在列表框内显示该字段内容
			m_roomsale_list.InsertItem(i,m_regnumber.GetBuffer(50));
           //读取数据表中姓名字段数据
			var = m_pRecordset->GetCollect("姓名");
			if(var.vt != VT_NULL)
				m_gustname = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,1,m_gustname.GetBuffer(50));
			
		    //读取数据表中房间号字段数据
			var = m_pRecordset->GetCollect("房间号");
			if(var.vt != VT_NULL)
				m_roomnumber = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,2,m_roomnumber.GetBuffer(50));

			//读取数据表中客房价格字段数据
			var = m_pRecordset->GetCollect("客房价格");
			if(var.vt != VT_NULL)
				m_room_money = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,3,m_room_money.GetBuffer(50));

			//读取数据表中住宿天数字段数据
			var = m_pRecordset->GetCollect("住宿天数");
			if(var.vt != VT_NULL)
				m_checkdays = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,4,m_checkdays.GetBuffer(50));
            //读取数据表中折扣或招待字段数据
			var = m_pRecordset->GetCollect("折扣或招待");
			if(var.vt != VT_NULL)
				m_discount_kind = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,5,m_discount_kind.GetBuffer(50));
            //读取数据表中折扣字段数据
			var = m_pRecordset->GetCollect("折扣");
			if(var.vt != VT_NULL)
				m_discountnumber = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,6,m_discountnumber.GetBuffer(50));
             //读取数据表中应收宿费字段数据
			var = m_pRecordset->GetCollect("应收宿费");
			if(var.vt != VT_NULL)
				m_pre_discount = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,7,m_pre_discount.GetBuffer(50));
               //读取数据表中杂费字段数据
			var = m_pRecordset->GetCollect("杂费");
			if(var.vt != VT_NULL)
				m_mix_money = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,8,m_mix_money.GetBuffer(50));
             //读取数据表中电话费字段数据
			var = m_pRecordset->GetCollect("电话费");
			if(var.vt != VT_NULL)
				m_tel_money = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,9,m_tel_money.GetBuffer(50));
             //读取数据表中会议费字段数据
			var = m_pRecordset->GetCollect("会议费");
			if(var.vt != VT_NULL)
				m_meeting_money = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,10,m_meeting_money.GetBuffer(50));
             //读取数据表中存车费字段数据
			var = m_pRecordset->GetCollect("存车费");
			if(var.vt != VT_NULL)
				m_park_money = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段内容
			m_roomsale_list.SetItemText(i,11,m_park_money.GetBuffer(50));
             //读取数据表中赔偿费字段数据
			var = m_pRecordset->GetCollect("赔偿费");
			if(var.vt != VT_NULL)
12 下一页
💿 文件大小 13269 K
👤 上传用户 abc171abc171
📂 所属分类酒店行业
🏷️ 相关标签

#查询 #报表 #模块
⌨️ 快捷键说明

复制代码 Ctrl + C
搜索代码 Ctrl + F
全屏模式 F11
切换主题 Ctrl + Shift + D
显示快捷键 ?
增大字号 Ctrl + =
减小字号 Ctrl + -