roommoneyalarmdlg.cpp

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

// Roommoneyalarmdlg.cpp : implementation file
//

#include "stdafx.h"
#include "Myhotel.h"
#include "Roommoneyalarmdlg.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; 
/////////////////////////////////////////////////////////////////////////////
// CRoommoneyalarmdlg dialog


CRoommoneyalarmdlg::CRoommoneyalarmdlg(CWnd* pParent /*=NULL*/)
	: CDialog(CRoommoneyalarmdlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CRoommoneyalarmdlg)
	m_moneyalarm_enddate = 0;
	//}}AFX_DATA_INIT
}


void CRoommoneyalarmdlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CRoommoneyalarmdlg)
	DDX_Control(pDX, IDC_LISTroommoneyalarm_list, m_roommoneyalarm_list);
	DDX_DateTimeCtrl(pDX, IDC_DATETIMEPICKER_moneyalarmdate, m_moneyalarm_enddate);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CRoommoneyalarmdlg, CDialog)
	//{{AFX_MSG_MAP(CRoommoneyalarmdlg)
	ON_BN_CLICKED(ID_BTNoutalarm, OnBTNoutalarm)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CRoommoneyalarmdlg message handlers

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

	 m_roommoneyalarm_list.InsertColumn(5,"客房价格");
	 m_roommoneyalarm_list.InsertColumn(6,"住宿日期");
	 m_roommoneyalarm_list.InsertColumn(7,"住宿时间");
	

	 m_roommoneyalarm_list.InsertColumn(8,"预收金额");
	 m_roommoneyalarm_list.InsertColumn(9,"提醒日期");

	 m_roommoneyalarm_list.InsertColumn(10,"提醒时间");
	
	
	
	RECT rect;
	 m_roommoneyalarm_list.GetWindowRect(&rect);
	int wid=rect.right-rect.left;
	int i=0;
	 m_roommoneyalarm_list.SetColumnWidth(0,wid/10);
	 m_roommoneyalarm_list.SetColumnWidth(1,wid/10);
	 m_roommoneyalarm_list.SetColumnWidth(2,wid/10);
	 m_roommoneyalarm_list.SetColumnWidth(3,wid/10);
	 m_roommoneyalarm_list.SetColumnWidth(4,wid/10);
	 m_roommoneyalarm_list.SetColumnWidth(5,wid/10);
	 m_roommoneyalarm_list.SetColumnWidth(6,wid/10);
	 m_roommoneyalarm_list.SetColumnWidth(7,wid/10);
	
	 m_roommoneyalarm_list.SetColumnWidth(8,wid/10);
	 m_roommoneyalarm_list.SetColumnWidth(9,wid/10);

	
    //设置列表框风格
	 m_roommoneyalarm_list.SetExtendedStyle(LVS_EX_FULLROWSELECT);
				// 使用ADO创建数据库记录集
	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)
		{//循环读取数据，并在列表框内显示
			//读取数据表内姓名字段的内容
			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));
              //读取数据表内姓名字段的内容
			var = m_pRecordset->GetCollect("住宿日期");
			if(var.vt != VT_NULL)
				m_checkindate = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段的值
			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));
            //读取数据表内提醒日期字段的内容
			var = m_pRecordset->GetCollect("提醒日期");
			if(var.vt != VT_NULL)
				m_alarmdate = (LPCSTR)_bstr_t(var);
			//在列表框内显示该字段的值
			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();
		}

		// 
		
	}
	catch(_com_error *e)//抛出异常，提示用户
	{
		AfxMessageBox(e->ErrorMessage());
	}

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

	//更新显示

	UpdateData(false);
	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}

void CRoommoneyalarmdlg::OnBTNoutalarm() 
{
	// TODO: Add your control notification handler code 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);
			CString alarmyear,alarmmonth,alarmday;
            alarmyear=m_alarmdate.Mid(0,4);
			alarmmonth=m_alarmdate.Mid(5,m_alarmdate.Find('-',6)-5);
			alarmday=m_alarmdate.Mid(m_alarmdate.ReverseFind('-')+1,m_alarmdate.GetLength()-m_alarmdate.ReverseFind('-'));