roommoneyalarmdlg.cpp

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

			//构造时间对象
			CTime alarmtime(atoi(alarmyear),atoi(alarmmonth),atoi(alarmday),m_moneyalarm_enddate.GetHour(),m_moneyalarm_enddate.GetMinute(),m_moneyalarm_enddate.GetSecond());
			//读取数据表内住宿日期字段的内容
			var = m_pRecordset->GetCollect("住宿日期");
			if(var.vt != VT_NULL)
				m_checkindate = (LPCSTR)_bstr_t(var);
            CString inyear,inmonth,inday;
            inyear=m_checkindate.Mid(0,4);
			inmonth=m_checkindate.Mid(5,m_checkindate.Find('-',6)-5);
			inday=m_checkindate.Mid(m_checkindate.ReverseFind('-')+1,m_checkindate.GetLength()-m_checkindate.ReverseFind('-'));
			//构造时间对象
			CTime intime(atoi(inyear),atoi(inmonth),atoi(inday),m_moneyalarm_enddate.GetHour(),m_moneyalarm_enddate.GetMinute(),m_moneyalarm_enddate.GetSecond());
			
            //读取数据表内退宿日期字段的内容
			var = m_pRecordset->GetCollect("退宿日期");
			if(var.vt != VT_NULL)
				m_checkoutdate = (LPCSTR)_bstr_t(var);
			CString outyear,outmonth,outday;
            outyear=m_checkoutdate.Mid(0,4);
			outmonth=m_checkoutdate.Mid(5,m_checkoutdate.Find('-',6)-5);
			outday=m_checkoutdate.Mid(m_checkoutdate.ReverseFind('-')+1,m_checkoutdate.GetLength()-m_checkoutdate.ReverseFind('-'));
			//构造时间对象
			CTime outtime(atoi(outyear),atoi(outmonth),atoi(outday),m_moneyalarm_enddate.GetHour(),m_moneyalarm_enddate.GetMinute(),m_moneyalarm_enddate.GetSecond());
			
			if((intime<m_moneyalarm_enddate)&&(outtime==alarmtime))		
			{//如果满足查询条件就读取满足条件的数据在列表框内显示
               //读取数据表内姓名字段的内容
			    var = m_pRecordset->GetCollect("姓名");
			   if(var.vt != VT_NULL)
				m_gustname = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.InsertItem(i,m_gustname.GetBuffer(50));
           
			
			  //读取数据表内证件号码字段的内容
			   var = m_pRecordset->GetCollect("证件号码");
			   if(var.vt != VT_NULL)
				m_zhengjian_number = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,1,m_zhengjian_number.GetBuffer(50));

		       //读取数据表内房间号字段的内容   
			   var = m_pRecordset->GetCollect("房间号");
			   if(var.vt != VT_NULL)
				m_roomnumber = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,2,m_roomnumber.GetBuffer(50));
               //读取数据表内客房类型字段的内容
			   var = m_pRecordset->GetCollect("客房类型");
			  if(var.vt != VT_NULL)
				m_roomlevel = (LPCSTR)_bstr_t(var);
			  //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,3,m_roomlevel.GetBuffer(50));
               //读取数据表内客房价格字段的内容
			   var = m_pRecordset->GetCollect("客房价格");
			   if(var.vt != VT_NULL)
				m_room_money = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,4,m_room_money.GetBuffer(50));

			  //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,5,m_checkindate.GetBuffer(50));
             //读取数据表内住宿时间字段的内容
			  var = m_pRecordset->GetCollect("住宿时间");
			   if(var.vt != VT_NULL)
				m_checkintime = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,6,m_checkintime.GetBuffer(50));

			
			  //读取数据表内预收金额字段的内容
			   var = m_pRecordset->GetCollect("预收金额");
			   if(var.vt != VT_NULL)
				m_pre_handinmoney = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,7,m_pre_handinmoney.GetBuffer(50));

			
			   m_roommoneyalarm_list.SetItemText(i,8,m_alarmdate.GetBuffer(50));

		 
		        //读取数据表内提醒时间字段的内容
			   var = m_pRecordset->GetCollect("提醒时间");
			   if(var.vt != VT_NULL)
				m_alarmtime = (LPCSTR)_bstr_t(var);
			    m_roommoneyalarm_list.SetItemText(i,9,m_alarmtime.GetBuffer(50));

		
			i++;//移动数据指针到下一条记录
			m_pRecordset->MoveNext();
		}

			else
			{//如果不满足查询条件就直接跳过
                m_pRecordset->MoveNext();
				continue;
			}
		}
		// 
		
	}
	catch(_com_error *e)
	{//抛出异常情况，提示用户
		AfxMessageBox(e->ErrorMessage());
	}

	// 关闭记录集
	m_pRecordset->Close();
	m_pRecordset = NULL;

	//更新显示

	UpdateData(false);
}

void CRoommoneyalarmdlg::OnOK() 
{
	// TODO: Add extra validation here
		UpdateData(true);
	m_pRecordset.CreateInstance(__uuidof(Recordset));
    
		_variant_t var;
		//清除列表框内所有内容
    m_roommoneyalarm_list.DeleteAllItems();
		int i=0;
	// 在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
		{
			MessageBox("表内数据为空","客房管理系统");
			return;
		}

		// read data from the database table 
		while(!m_pRecordset->adoEOF)
		{//循环读取数据
			//读取数据表内提醒日期字段的内容
			var = m_pRecordset->GetCollect("提醒日期");
			if(var.vt != VT_NULL)
				m_alarmdate = (LPCSTR)_bstr_t(var);
		    //读取数据表内住宿日期字段的内容   
			var = m_pRecordset->GetCollect("住宿日期");
			if(var.vt != VT_NULL)
				m_checkindate = (LPCSTR)_bstr_t(var);
            CString inyear,inmonth,inday;
            inyear=m_checkindate.Mid(0,4);
			inmonth=m_checkindate.Mid(5,m_checkindate.Find('-',6)-5);
			inday=m_checkindate.Mid(m_checkindate.ReverseFind('-')+1,m_checkindate.GetLength()-m_checkindate.ReverseFind('-'));
			//构造时间对象
			CTime intime(atoi(inyear),atoi(inmonth),atoi(inday),m_moneyalarm_enddate.GetHour(),m_moneyalarm_enddate.GetMinute(),m_moneyalarm_enddate.GetSecond());
			
            //读取数据表内退宿日期字段的内容
			var = m_pRecordset->GetCollect("退宿日期");
			if(var.vt != VT_NULL)
				m_checkoutdate = (LPCSTR)_bstr_t(var);
			
			if((intime<m_moneyalarm_enddate)&&(m_alarmdate!=""))		
			{//如果满足查询条件就读取查询到的数据，并在列表框内显示
               //读取数据表内姓名字段的内容
			    var = m_pRecordset->GetCollect("姓名");
			   if(var.vt != VT_NULL)
				m_gustname = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.InsertItem(i,m_gustname.GetBuffer(50));
           
			
			   //读取数据表内证件号码字段的内容
			   var = m_pRecordset->GetCollect("证件号码");
			   if(var.vt != VT_NULL)
				m_zhengjian_number = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,1,m_zhengjian_number.GetBuffer(50));

		         //读取数据表内房间号字段的内容
			   var = m_pRecordset->GetCollect("房间号");
			   if(var.vt != VT_NULL)
				m_roomnumber = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,2,m_roomnumber.GetBuffer(50));
               //读取数据表内客房类型字段的内容
			   var = m_pRecordset->GetCollect("客房类型");
			  if(var.vt != VT_NULL)
				m_roomlevel = (LPCSTR)_bstr_t(var);
			  //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,3,m_roomlevel.GetBuffer(50));
               //读取数据表内客房价格字段的内容
			   var = m_pRecordset->GetCollect("客房价格");
			   if(var.vt != VT_NULL)
				m_room_money = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,4,m_room_money.GetBuffer(50));

			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,5,m_checkindate.GetBuffer(50));
              //读取数据表内住宿时间字段的内容
			  var = m_pRecordset->GetCollect("住宿时间");
			   if(var.vt != VT_NULL)
				m_checkintime = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,6,m_checkintime.GetBuffer(50));

			
			   //读取数据表内预收金额字段的内容
			   var = m_pRecordset->GetCollect("预收金额");
			   if(var.vt != VT_NULL)
				m_pre_handinmoney = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,7,m_pre_handinmoney.GetBuffer(50));

			   //在列表框内显示该字段的值
			   m_roommoneyalarm_list.SetItemText(i,8,m_alarmdate.GetBuffer(50));

		
		        //读取数据表内提醒时间字段的内容  
			   var = m_pRecordset->GetCollect("提醒时间");
			   if(var.vt != VT_NULL)
				m_alarmtime = (LPCSTR)_bstr_t(var);
			   //在列表框内显示该字段的值
			    m_roommoneyalarm_list.SetItemText(i,9,m_alarmtime.GetBuffer(50));

		
			i++;//移动记录集指针到下一条记录
			m_pRecordset->MoveNext();
		}

			else
			{//如果不满足查询条件就直接跳过该记录
                m_pRecordset->MoveNext();
				continue;
			}
		}
		// 
		
	}
	catch(_com_error *e)//抛出异常
	{
		AfxMessageBox(e->ErrorMessage());
	}

	// 关闭记录集
	m_pRecordset->Close();
	m_pRecordset = NULL;

	//更新显示

	UpdateData(false);
//	CDialog::OnOK();
}