findcheckindlg.cpp

系统将动态实时的住宿登记、客房调整、销售报表等有机地联系在一起

// Findcheckindlg.cpp : implementation file
//

#include "stdafx.h"
#include "Myhotel.h"
#include "Findcheckindlg.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; 
/////////////////////////////////////////////////////////////////////////////
// CFindcheckindlg dialog
CFindcheckindlg::CFindcheckindlg(CString findroomnumber,CWnd* pParent /*=NULL*/)
	: CDialog(CFindcheckindlg::IDD, pParent)
{
	sendfindroomnumber=findroomnumber;
  	
}

CFindcheckindlg::CFindcheckindlg(CWnd* pParent /*=NULL*/)
	: CDialog(CFindcheckindlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CFindcheckindlg)
	m_findcheckin_name = _T("");
	//}}AFX_DATA_INIT
	sendfindroomnumber="";
}


void CFindcheckindlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CFindcheckindlg)
	DDX_Control(pDX, IDC_LIST_findcheckin, m_findcheckin_list);
	DDX_Text(pDX, IDC_findcheckin_name, m_findcheckin_name);
	//}}AFX_DATA_MAP
}


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

/////////////////////////////////////////////////////////////////////////////
// CFindcheckindlg message handlers

void CFindcheckindlg::OnOK() 
{
	// TODO: Add extra validation here

	UpdateData(true);
	
	_variant_t var;
	// 使用ADO创建数据库记录集
	m_pRecordsetfind.CreateInstance(__uuidof(Recordset));

	// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
	// 

	int i=0;
    //删除列表框内所有内容
	m_findcheckin_list.DeleteAllItems();
	CString strsqlfind;
    strsqlfind.Format("SELECT * FROM checkinregtable where 姓名='%s'",m_findcheckin_name);
	try
	{// 打开数据库
		m_pRecordsetfind->Open(_variant_t(strsqlfind),                // 查询 表中所有字段
							theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
							adOpenDynamic,
							adLockOptimistic,
							adCmdText);
	}
	catch(_com_error *e)// 捕获打开数据库时候可能发生的异常
	{
		AfxMessageBox(e->ErrorMessage());
	}
   
	try
	{
		if(!m_pRecordsetfind->BOF)//判断指针是否在数据集最后
			m_pRecordsetfind->MoveFirst();
		else
		{
			MessageBox("表内数据为空","客房管理系统");
			return ;
		}

	while(!m_pRecordsetfind->adoEOF)//循环读取数据，并在列表框内显示
		{  //读取数据表中凭证号码字段数据
			var = m_pRecordsetfind->GetCollect("凭证号码");
			if(var.vt != VT_NULL)
				m_regnumber = (LPCSTR)_bstr_t(var);
			m_findcheckin_list.InsertItem(i,m_regnumber.GetBuffer(50));//在列表框内显示
           //读取数据表中姓名字段数据
			var = m_pRecordsetfind->GetCollect("姓名");
			if(var.vt != VT_NULL)
				m_gustname = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,1,m_gustname.GetBuffer(50));
           //读取数据表中证件名称字段数据
			var = m_pRecordsetfind->GetCollect("证件名称");
			if(var.vt != VT_NULL)
				m_zhengjian = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,2,m_zhengjian.GetBuffer(50));
            //读取数据表中证件号码字段数据
			var = m_pRecordsetfind->GetCollect("证件号码");
			if(var.vt != VT_NULL)
				m_zhengjian_number = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,3,m_zhengjian_number.GetBuffer(50));
           //读取数据表中详细地址字段数据
			var = m_pRecordsetfind->GetCollect("详细地址");
			if(var.vt != VT_NULL)
				m_gustaddr = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,4,m_gustaddr.GetBuffer(50));
            //读取数据表中出差事由字段数据
			var = m_pRecordsetfind->GetCollect("出差事由");
			if(var.vt != VT_NULL)
				m_checkinreg_reason = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,5,m_checkinreg_reason.GetBuffer(50));
           //读取数据表中房间号字段数据
			var = m_pRecordsetfind->GetCollect("房间号");
			if(var.vt != VT_NULL)
				m_roomnumber = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,6,m_roomnumber.GetBuffer(50));
           //读取数据表中客房类型字段数据
			var = m_pRecordsetfind->GetCollect("客房类型");
			if(var.vt != VT_NULL)
				m_roomlevel = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,7,m_roomlevel.GetBuffer(50));
              //读取数据表中客房价格字段数据
			var = m_pRecordsetfind->GetCollect("客房价格");
			if(var.vt != VT_NULL)
				m_room_money = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,8,m_room_money.GetBuffer(50));
          //读取数据表中住宿日期字段数据
			var = m_pRecordsetfind->GetCollect("住宿日期");
			if(var.vt != VT_NULL)
				m_checkindate = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,9,m_checkindate.GetBuffer(50));
           //读取数据表中住宿时间字段数据
			var = m_pRecordsetfind->GetCollect("住宿时间");
			if(var.vt != VT_NULL)
				m_checkintime = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,10,m_checkintime.GetBuffer(50));

			//读取数据表中住宿天数字段数据
			var = m_pRecordsetfind->GetCollect("住宿天数");
			if(var.vt != VT_NULL)
				m_checkdays = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,11,m_checkdays.GetBuffer(50));
            //读取数据表中宿费字段数据
			var = m_pRecordsetfind->GetCollect("宿费");
			if(var.vt != VT_NULL)
				m_pre_discount = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,12,m_gustname.GetBuffer(50));
           //读取数据表中折扣字段数据
			var = m_pRecordsetfind->GetCollect("折扣");
			if(var.vt != VT_NULL)
				m_discountnumber = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,13,m_discountnumber.GetBuffer(50));
            //读取数据表中应收宿费字段数据
			var = m_pRecordsetfind->GetCollect("应收宿费");
			if(var.vt != VT_NULL)
				m_realmoney = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,14,m_realmoney.GetBuffer(50));
            //读取数据表中预收金额字段数据
			var = m_pRecordsetfind->GetCollect("预收金额");
			if(var.vt != VT_NULL)
				m_pre_handinmoney = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,15,m_pre_handinmoney.GetBuffer(50));
            //读取数据表中提醒日期字段数据
			var = m_pRecordsetfind->GetCollect("提醒日期");
			if(var.vt != VT_NULL)
				m_alarmdate = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,16,m_alarmdate.GetBuffer(50));
              //读取数据表中退宿日期字段数据
			var = m_pRecordsetfind->GetCollect("退宿日期");
			if(var.vt != VT_NULL)
				m_checkoutdate = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,17,m_checkoutdate.GetBuffer(50));
              //读取数据表中备注字段数据
			var = m_pRecordsetfind->GetCollect("备注");
			if(var.vt != VT_NULL)
				m_beizhu = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,18,m_beizhu.GetBuffer(50));
           //读取数据表中结款方式字段数据
			var = m_pRecordsetfind->GetCollect("结款方式");
			if(var.vt != VT_NULL)
				m_discount_kind = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,19,m_discount_kind.GetBuffer(50));
            //读取数据表中退宿时间字段数据
			var = m_pRecordsetfind->GetCollect("退宿时间");
			if(var.vt != VT_NULL)
				m_checkouttime = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,20,m_checkouttime.GetBuffer(50));
            //读取数据表中提醒时间字段数据
			var = m_pRecordsetfind->GetCollect("提醒时间");
			if(var.vt != VT_NULL)
				m_alarmtime = (LPCSTR)_bstr_t(var);
			//在列表框内显示
			m_findcheckin_list.SetItemText(i,21,m_alarmtime.GetBuffer(50));

		
			i++;
			m_pRecordsetfind->MoveNext();//移动到下一条记录
		}
		// 
		
	}
	catch(_com_error *e)//捕获异常
	{
		AfxMessageBox(e->ErrorMessage());
	}

		// 关闭记录集
	m_pRecordsetfind->Close();
	m_pRecordsetfind = NULL;
	//更新显示
	UpdateData(false);
//	CDialog::OnOK();
}

BOOL CFindcheckindlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
	//设置列表框的颜色
	m_findcheckin_list.SetTextColor(RGB (0, 0, 0));
	m_findcheckin_list.SetTextBkColor(RGB (140, 180, 20));
	//初始化列表框内容
	m_findcheckin_list.InsertColumn(0,"凭证号码");
	m_findcheckin_list.InsertColumn(1,"姓名");
	m_findcheckin_list.InsertColumn(2,"证件名称");
	m_findcheckin_list.InsertColumn(3,"证件号码");
	m_findcheckin_list.InsertColumn(4,"详细地址");
	m_findcheckin_list.InsertColumn(5,"出差事由");
	m_findcheckin_list.InsertColumn(6,"房间号");
	m_findcheckin_list.InsertColumn(7,"房间类型");
	

	m_findcheckin_list.InsertColumn(8,"客房价格");
	m_findcheckin_list.InsertColumn(9,"住宿日期");
	m_findcheckin_list.InsertColumn(10,"住宿时间");
	m_findcheckin_list.InsertColumn(11,"住宿天数");
	m_findcheckin_list.InsertColumn(12,"宿费");
	m_findcheckin_list.InsertColumn(13,"折扣");
	m_findcheckin_list.InsertColumn(14,"应收宿费");

	m_findcheckin_list.InsertColumn(15,"预收金额");
	m_findcheckin_list.InsertColumn(16,"提醒日期");
	m_findcheckin_list.InsertColumn(17,"退宿日期");
	m_findcheckin_list.InsertColumn(18,"备注");


	m_findcheckin_list.InsertColumn(19,"结款方式");

	m_findcheckin_list.InsertColumn(20,"退宿时间");
	m_findcheckin_list.InsertColumn(21,"提醒时间");
	
	
	
	RECT rect;
	m_findcheckin_list.GetWindowRect(&rect);
	int wid=rect.right-rect.left;
	int i=0;
	m_findcheckin_list.SetColumnWidth(0,wid/12);
	m_findcheckin_list.SetColumnWidth(1,wid/12);
	m_findcheckin_list.SetColumnWidth(2,wid/12);
	m_findcheckin_list.SetColumnWidth(3,wid/12);
	m_findcheckin_list.SetColumnWidth(4,wid/12);
	m_findcheckin_list.SetColumnWidth(5,wid/12);
	m_findcheckin_list.SetColumnWidth(6,wid/12);
	m_findcheckin_list.SetColumnWidth(7,wid/12);
	
	m_findcheckin_list.SetColumnWidth(8,wid/12);
	m_findcheckin_list.SetColumnWidth(9,wid/12);
	m_findcheckin_list.SetColumnWidth(10,wid/12);
	m_findcheckin_list.SetColumnWidth(11,wid/12);
	m_findcheckin_list.SetColumnWidth(12,wid/12);
	m_findcheckin_list.SetColumnWidth(13,wid/12);
	m_findcheckin_list.SetColumnWidth(14,wid/12);
	m_findcheckin_list.SetColumnWidth(15,wid/12);
	
	m_findcheckin_list.SetColumnWidth(16,wid/12);
	m_findcheckin_list.SetColumnWidth(17,wid/12);
	m_findcheckin_list.SetColumnWidth(18,wid/12);
	m_findcheckin_list.SetColumnWidth(19,wid/12);
	m_findcheckin_list.SetColumnWidth(20,wid/12);
	m_findcheckin_list.SetColumnWidth(21,wid/12);
	
	 //设置列表框风格
 
	m_findcheckin_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
				// 使用ADO创建数据库记录集
//    MessageBox(sendfindroomnumber,sendfindroomnumber);
	if(sendfindroomnumber=="")
	{
	m_pRecordset.CreateInstance(__uuidof(Recordset));

		_variant_t var;

	// 在ADO操作中建议语句中要常用try...catch()来捕获错误信息，
	// 
	try//打开数据库
	{
		m_pRecordset->Open("SELECT * FROM checkinregtable",                // 查询 表中所有字段
							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)
		{   //读取数据表中凭证号码字段数据