addmoneydlg.cpp

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

// Addmoneydlg.cpp : implementation file
//

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

#ifdef _DEBUG
#define new DEBUG_NEW
#undef THIS_FILE
static char THIS_FILE[] = __FILE__;
#endif

extern CString loguserid;
extern CMyhotelApp theApp; 
/////////////////////////////////////////////////////////////////////////////
// CAddmoneydlg dialog


CAddmoneydlg::CAddmoneydlg(CWnd* pParent /*=NULL*/)
	: CDialog(CAddmoneydlg::IDD, pParent)
{
	//{{AFX_DATA_INIT(CAddmoneydlg)
	m_addmoney_regnumber = _T("");
	m_addmoney_name = _T("");
	m_addmoney_outdate = _T("");
	m_addmoney_outtime = _T("");
	m_addmoney_prehandmoney = _T("");
	m_addmoney_roomlevel = _T("");
	m_addmoney_roommoney = _T("");
	m_addmoney_roomnumber = _T("");
	m_addmoney_alarmdate = _T("");
	m_addmoney_alarmtime = _T("");
	m_addmoney_checkdays = 0.0f;
	m_addmoney_indate = _T("");
	m_addmoney_intime = _T("");
	m_addmoney = _T("");
	m_showuser = _T("");
	//}}AFX_DATA_INIT
}


void CAddmoneydlg::DoDataExchange(CDataExchange* pDX)
{
	CDialog::DoDataExchange(pDX);
	//{{AFX_DATA_MAP(CAddmoneydlg)
	DDX_Control(pDX, IDC_COMBO_regnumber, m_addmoney_regnumberctr);
	DDX_CBString(pDX, IDC_COMBO_regnumber, m_addmoney_regnumber);
	DDX_Text(pDX, IDC_EDIT_name, m_addmoney_name);
	DDX_Text(pDX, IDC_EDIT_outdate, m_addmoney_outdate);
	DDX_Text(pDX, IDC_EDIT_outtime, m_addmoney_outtime);
	DDX_Text(pDX, IDC_EDIT_prehandmoney, m_addmoney_prehandmoney);
	DDX_Text(pDX, IDC_EDIT_roomlevel, m_addmoney_roomlevel);
	DDX_Text(pDX, IDC_EDIT_roommoney, m_addmoney_roommoney);
	DDX_Text(pDX, IDC_EDIT_roomnumber, m_addmoney_roomnumber);
	DDX_Text(pDX, IDC_EDIT_alarmdate, m_addmoney_alarmdate);
	DDX_Text(pDX, IDC_EDIT_alarmtime, m_addmoney_alarmtime);
	DDX_Text(pDX, IDC_EDIT_checkdays, m_addmoney_checkdays);
	DDX_Text(pDX, IDC_EDIT_indate, m_addmoney_indate);
	DDX_Text(pDX, IDC_EDIT_intime, m_addmoney_intime);
	DDX_Text(pDX, IDC_addmoney, m_addmoney);
	DDX_Text(pDX, IDC_STATICshowuser, m_showuser);
	//}}AFX_DATA_MAP
}


BEGIN_MESSAGE_MAP(CAddmoneydlg, CDialog)
	//{{AFX_MSG_MAP(CAddmoneydlg)
	ON_BN_CLICKED(ID_addmoneydlg_check, Onaddmoneydlgcheck)
	ON_CBN_CLOSEUP(IDC_COMBO_regnumber, OnCloseupCOMBOregnumber)
	ON_BN_CLICKED(IDCANCEL_addmoney, Onaddmoney)
	//}}AFX_MSG_MAP
END_MESSAGE_MAP()

/////////////////////////////////////////////////////////////////////////////
// CAddmoneydlg message handlers

BOOL CAddmoneydlg::OnInitDialog() 
{
	CDialog::OnInitDialog();
	
	// TODO: Add extra initialization here
			// 使用ADO创建数据库记录集
	m_pRecordset.CreateInstance(__uuidof(Recordset));

		_variant_t var;
		CString strregnumber;
	// 在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)
				strregnumber = (LPCSTR)_bstr_t(var);
			m_addmoney_regnumberctr.AddString(strregnumber);
			m_pRecordset->MoveNext();// 移动记录指针到下一条记录
		}

		// 
		
	}
	catch(_com_error *e) //如果读数异常，给出提示
	{
		AfxMessageBox(e->ErrorMessage());
	}

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

	m_showuser=loguserid;

	//更新显示

	UpdateData(false);
	enable(0);

	return TRUE;  // return TRUE unless you set the focus to a control
	              // EXCEPTION: OCX Property Pages should return FALSE
}
void CAddmoneydlg::enable(bool bEnabled)
{
   // m_ComYSFS.EnableWindow(bEnabled);
	//改变输入框状态
	GetDlgItem(IDC_COMBO_regnumber)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_name)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_outdate)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_outtime)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_prehandmoney)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_roomlevel)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_roommoney)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_roomnumber)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_alarmdate)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_alarmtime)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_checkdays)->EnableWindow(bEnabled);
	GetDlgItem(IDC_EDIT_indate)->EnableWindow(bEnabled);
    GetDlgItem(IDC_EDIT_intime)->EnableWindow(bEnabled);
	GetDlgItem(IDC_addmoney)->EnableWindow(bEnabled);
	GetDlgItem(IDOK)->EnableWindow(bEnabled);
}

void CAddmoneydlg::Onaddmoneydlgcheck() 
{
	// TODO: Add your control notification handler code here
	enable(1);
}

void CAddmoneydlg::OnCloseupCOMBOregnumber() 
{
	// TODO: Add your control notification handler code here
		_variant_t var;
	// 使用ADO创建数据库记录集
	m_pRecordset.CreateInstance(__uuidof(Recordset));

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

	UpdateData(true);
    
    m_addmoney_regnumberctr.GetWindowText(m_addmoney_regnumber);
	
	CString strsql;
    strsql.Format("SELECT * FROM checkinregtable where 凭证号码='%s'",m_addmoney_regnumber);
	try
	{// 打开数据表
		m_pRecordset->Open(_variant_t(strsql),                // 查询表中所有字段
							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 ;
		}

		// read data from the database table 
		    // 读取姓名
			var = m_pRecordset->GetCollect("姓名");
			if(var.vt != VT_NULL)
		     	m_addmoney_name = (LPCSTR)_bstr_t(var);
       

            // 读取房间号
			var = m_pRecordset->GetCollect("房间号");
			if(var.vt != VT_NULL)
		     	m_addmoney_roomnumber = (LPCSTR)_bstr_t(var);
           // 读取客房类型
			var = m_pRecordset->GetCollect("客房类型");
			if(var.vt != VT_NULL)
		     	m_addmoney_roomlevel = (LPCSTR)_bstr_t(var);
           // 读取客房价格
			var = m_pRecordset->GetCollect("客房价格");
			if(var.vt != VT_NULL)
		     	m_addmoney_roommoney = (LPCSTR)_bstr_t(var);

           // 读取住宿天数
			var = m_pRecordset->GetCollect("住宿天数");
			if(var.vt != VT_NULL)
		     	m_addmoney_checkdays = atof((LPCSTR)_bstr_t(var));

		//	CString checkindate;// 读取住宿日期
			var = m_pRecordset->GetCollect("住宿日期");
			if(var.vt != VT_NULL)
		     	m_addmoney_indate = (LPCSTR)_bstr_t(var);

	        // 读取住宿时间
			var = m_pRecordset->GetCollect("住宿时间");
			if(var.vt != VT_NULL)
		     	m_addmoney_intime = (LPCSTR)_bstr_t(var);
			

             // 读取预收金额
			var = m_pRecordset->GetCollect("预收金额");
			if(var.vt != VT_NULL)
		     	m_addmoney_prehandmoney = (LPCSTR)_bstr_t(var);
             else
                m_addmoney_prehandmoney="000";
             // 读取退宿日期
			
			 var = m_pRecordset->GetCollect("退宿日期");
			if(var.vt != VT_NULL)
		     	m_addmoney_outdate = (LPCSTR)_bstr_t(var);
              // 读取退宿时间
			var = m_pRecordset->GetCollect("退宿时间");
			if(var.vt != VT_NULL)
		     	m_addmoney_outtime = (LPCSTR)_bstr_t(var);
           // 读取提醒日期
			var = m_pRecordset->GetCollect("提醒日期");
			if(var.vt != VT_NULL)
		     	m_addmoney_alarmdate = (LPCSTR)_bstr_t(var);
           // 读取提醒时间
			var = m_pRecordset->GetCollect("提醒时间");
			if(var.vt != VT_NULL)
		     	m_addmoney_alarmtime  = (LPCSTR)_bstr_t(var);
          // 更新显示
           UpdateData(false);
    
		// 从数据库内读取数据完毕
		
	}
	catch(_com_error *e)
	{//如果读数异常，给出提示
		AfxMessageBox(e->ErrorMessage());
	}

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

void CAddmoneydlg::OnOK() 
{
	// TODO: Add extra validation here
		
	UpdateData(true);
//获得输入框内的输入数据
	m_pRecordsetout.CreateInstance(__uuidof(Recordset));

	CString strsqlstore;
   strsqlstore.Format("SELECT * FROM checkinregtable where 凭证号码='%s'",m_addmoney_regnumber);
	
   try//连接数据库
	{
		m_pRecordsetout->Open(_variant_t(strsqlstore),                // 查询表中所有字段
							theApp.m_pConnection.GetInterfacePtr(),	 // 获取库接库的IDispatch指针
							adOpenDynamic,
							adLockOptimistic,
							adCmdText);
	}
	catch(_com_error *e)//捕获连接数据库异常
	{
		AfxMessageBox(e->ErrorMessage());
	}

	try//更新数据库
	{
	    
			float  theaddedmoney=atof(m_addmoney_prehandmoney)+atof(m_addmoney);//theaddedmoney
			char strtheaddedmoney[50]; 
	        _gcvt(theaddedmoney, 4, strtheaddedmoney );// 格式转换
            //写入数据表
			m_pRecordsetout->PutCollect("预收金额", _variant_t(strtheaddedmoney));
       			
        	m_pRecordsetout->Update();
              //更新数据库完毕
		MessageBox("追加成功!","客房管理系统");
		//	UpdateData(false);
	}
	catch(_com_error *e)//捕获连接数据库异常
	{
		AfxMessageBox(e->ErrorMessage());
	}
//	CDialog::OnOK();
}

void CAddmoneydlg::Onaddmoney() 
{
	// TODO: Add your control notification handler code here
	//初始化输入框内容
	m_addmoney_regnumber = _T("");
	m_addmoney_name = _T("");
	m_addmoney_outdate = _T("");
	m_addmoney_outtime = _T("");
	m_addmoney_prehandmoney = _T("");
	m_addmoney_roomlevel = _T("");
	m_addmoney_roommoney = _T("");
	m_addmoney_roomnumber = _T("");
	m_addmoney_alarmdate = _T("");
	m_addmoney_alarmtime = _T("");
	m_addmoney_checkdays = 0.0f;
	m_addmoney_indate = _T("");
	m_addmoney_intime = _T("");
	m_addmoney = _T("");
	UpdateData(false);

}