宾馆管理系统.docx
《宾馆管理系统.docx》由会员分享,可在线阅读,更多相关《宾馆管理系统.docx(113页珍藏版)》请在冰豆网上搜索。
宾馆管理系统
//AppendAccountDLG.cpp:
implementationfile
//
#include"stdafx.h"
#include"hotel_mis.h"
#include"AppendAccountDLG.h"
#ifdef_DEBUG
#definenewDEBUG_NEW
#undefTHIS_FILE
staticcharTHIS_FILE[]=__FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
//CAppendAccountDLGdialog
CAppendAccountDLG:
:
CAppendAccountDLG(CWnd*pParent/*=NULL*/)
:
CDialog(CAppendAccountDLG:
:
IDD,pParent)
{
//{{AFX_DATA_INIT(CAppendAccountDLG)
m_sPWD1=_T("");
m_sPWD2=_T("");
m_sUSER=_T("");
//}}AFX_DATA_INIT
}
voidCAppendAccountDLG:
:
DoDataExchange(CDataExchange*pDX)
{
CDialog:
:
DoDataExchange(pDX);
//{{AFX_DATA_MAP(CAppendAccountDLG)
DDX_Text(pDX,IDD_APPEDNACCOUNT_PWD1,m_sPWD1);
DDX_Text(pDX,IDD_APPEDNACCOUNT_PWD2,m_sPWD2);
DDX_Text(pDX,IDD_APPEDNACCOUNT_USER,m_sUSER);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CAppendAccountDLG,CDialog)
//{{AFX_MSG_MAP(CAppendAccountDLG)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
//CAppendAccountDLGmessagehandlers
voidCAppendAccountDLG:
:
OnOK()
{
//TODO:
Addextravalidationhere
UpdateData(true);
m_sUSER.TrimRight("");
//Judgewhetherusernameisnull
if(""==m_sUSER)
{
AfxMessageBox(_T("请输入用户名称"),MB_ICONEXCLAMATION);
return;
}
//Judgewhethertheuserexsists
_variant_tHolder,strQuery;
strQuery="select*fromuser_Infowhereuser_ID='"+m_sUSER+"'";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
intiCount=theApp.m_pADOSet->GetRecordCount();
if(0!
=iCount)
{
AfxMessageBox(_T("用户名已经存在,请重新输入用户名"),MB_ICONEXCLAMATION);
return;
}
//Makesurepwd1isnotnull
if(""==m_sPWD1)
{
AfxMessageBox(_T("密码不能未空"),MB_ICONEXCLAMATION);
return;
}
//Judgewhetherpwd1==pwd2
if(0!
=m_sPWD1.Compare(m_sPWD2))
{
AfxMessageBox(_T("两次输入密码不一样,请确认"),MB_ICONEXCLAMATION);
return;
}
CDialog:
:
OnOK();
}
BOOLCAppendAccountDLG:
:
OnInitDialog()
{
CDialog:
:
OnInitDialog();
//TODO:
Addextrainitializationhere
((CEdit*)GetDlgItem(IDD_APPEDNACCOUNT_USER))->SetLimitText(15);
((CEdit*)GetDlgItem(IDD_APPEDNACCOUNT_PWD1))->SetLimitText(10);
((CEdit*)GetDlgItem(IDD_APPEDNACCOUNT_PWD2))->SetLimitText(10);
returnTRUE;//returnTRUEunlessyousetthefocustoacontrol
//EXCEPTION:
OCXPropertyPagesshouldreturnFALSE
}
//BookInDLG.cpp:
implementationfile
//Downloadby
#include"stdafx.h"
#include"hotel_mis.h"
#include"BookInDLG.h"
#include"Hotel_MISView.h"
#ifdef_DEBUG
#definenewDEBUG_NEW
#undefTHIS_FILE
staticcharTHIS_FILE[]=__FILE__;
#endif
/////////////////////////////////////////////////////////////////////////////
//CBookInDLGdialog
CBookInDLG:
:
CBookInDLG(CWnd*pParent/*=NULL*/)
:
CDialog(CBookInDLG:
:
IDD,pParent)
{
//{{AFX_DATA_INIT(CBookInDLG)
m_sRoomNo=_T("");
m_sRoomType=_T("");
m_sRoomPosition=_T("");
m_sRoomPrice=_T("");
m_sRoomMemo=_T("");
m_sName=_T("");
m_sID=_T("");
m_tInDAte=COleDateTime:
:
GetCurrentTime();
m_sDiscount=_T("");
m_sMemo=_T("");
//}}AFX_DATA_INIT
}
voidCBookInDLG:
:
DoDataExchange(CDataExchange*pDX)
{
CDialog:
:
DoDataExchange(pDX);
//{{AFX_DATA_MAP(CBookInDLG)
DDX_CBString(pDX,IDD_BOOKIN_ROOMNO,m_sRoomNo);
DDX_Text(pDX,IDD_BOOKIN_ROOMTYPE,m_sRoomType);
DDX_Text(pDX,IDD_BOOKIN_ROOMPOSITION,m_sRoomPosition);
DDX_Text(pDX,IDD_BOOKIN_ROOMPRICE,m_sRoomPrice);
DDX_Text(pDX,IDD_BOOKIN_ROOMMEMO,m_sRoomMemo);
DDX_Text(pDX,IDD_BOOKIN_NAME,m_sName);
DDX_Text(pDX,IDD_BOOKIN_ID,m_sID);
DDX_DateTimeCtrl(pDX,IDD_BOOKIN_INDATE,m_tInDAte);
DDX_Text(pDX,IDD_BOOKIN_DISCOUNT,m_sDiscount);
DDX_Text(pDX,IDD_BOOKIN_MEMO,m_sMemo);
//}}AFX_DATA_MAP
}
BEGIN_MESSAGE_MAP(CBookInDLG,CDialog)
//{{AFX_MSG_MAP(CBookInDLG)
ON_CBN_SELCHANGE(IDD_BOOKIN_ROOMNO,OnRoomNoSelChange)
//}}AFX_MSG_MAP
END_MESSAGE_MAP()
/////////////////////////////////////////////////////////////////////////////
//CBookInDLGmessagehandlers
BOOLCBookInDLG:
:
OnInitDialog()
{
CDialog:
:
OnInitDialog();
((CEdit*)GetDlgItem(IDD_BOOKIN_NAME))->SetLimitText(20);
((CEdit*)GetDlgItem(IDD_BOOKIN_ID))->SetLimitText(18);
//TODO:
Addextrainitializationhere
if(m_bAppend)
{
//UpdateDialogCaption
SetWindowText(_T("添加订房信息"));
//InitCombobox
_variant_tstrQuery,Holder;
strQuery="select*fromroomswhereputup=0orputupisNULL";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
intiCount=theApp.m_pADOSet->GetRecordCount();
theApp.m_pADOSet->MoveFirst();
for(inti=0;i{
Holder=theApp.m_pADOSet->GetCollect("roomNo");
((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->InsertString(i,Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder);
//Getotheronfotodisplay
if(0==i)
{
//GetRoomType
Holder=theApp.m_pADOSet->GetCollect("roomtype");
m_sRoomType=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
//Getroomposition
Holder=theApp.m_pADOSet->GetCollect("roomposition");
m_sRoomPosition=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
//Getroomprice
Holder=theApp.m_pADOSet->GetCollect("roomprice");
m_sRoomPrice.Format("%.2f",Holder.dblVal);
//Getroommemo
Holder=theApp.m_pADOSet->GetCollect("roommemo");
m_sRoomMemo=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
}
theApp.m_pADOSet->MoveNext();
}
((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->SetCurSel(0);
}
else
{
//GetOldIDandRoomNo
m_sOldID=m_sID;
m_sOldRoomNo=m_sRoomNo;
//UpdateDialogCaption
SetWindowText(_T("修改订房信息"));
//InitCombobox
_variant_tstrQuery,Holder;
CStringstr;
intiSel=0;
strQuery="select*fromroomswhereputup=0orputupisNULL";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
intiCount=theApp.m_pADOSet->GetRecordCount();
theApp.m_pADOSet->MoveFirst();
for(inti=0;i{
Holder=theApp.m_pADOSet->GetCollect("roomNo");
str=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->InsertString(i,str);
//Getotheronfotodisplay
if(str==m_sRoomNo)
{
//GetRoomType
Holder=theApp.m_pADOSet->GetCollect("roomtype");
m_sRoomType=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
//Getroomposition
Holder=theApp.m_pADOSet->GetCollect("roomposition");
m_sRoomPosition=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
//Getroomprice
Holder=theApp.m_pADOSet->GetCollect("roomprice");
m_sRoomPrice.Format("%.2f",Holder.dblVal);
//Getroommemo
Holder=theApp.m_pADOSet->GetCollect("roommemo");
m_sRoomMemo=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
iSel=i;
}
theApp.m_pADOSet->MoveNext();
}
((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->SetCurSel(iSel);
}
UpdateData(false);
returnTRUE;//returnTRUEunlessyousetthefocustoacontrol
//EXCEPTION:
OCXPropertyPagesshouldreturnFALSE
}
voidCBookInDLG:
:
OnRoomNoSelChange()
{
//TODO:
Addyourcontrolnotificationhandlercodehere
UpdateData(true);
_variant_tstrQuery,Holder;
strQuery="select*fromroomswhereroomNO='"+m_sRoomNo+"'";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
//GetRoomType
Holder=theApp.m_pADOSet->GetCollect("roomtype");
m_sRoomType=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
//Getroomposition
Holder=theApp.m_pADOSet->GetCollect("roomposition");
m_sRoomPosition=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
//Getroomprice
Holder=theApp.m_pADOSet->GetCollect("roomprice");
m_sRoomPrice.Format("%.2f",Holder.dblVal);
//Getroommemo
Holder=theApp.m_pADOSet->GetCollect("roommemo");
m_sRoomMemo=Holder.vt==VT_NULL?
"":
(char*)(_bstr_t)Holder;
UpdateData(false);
}
voidCBookInDLG:
:
OnOK()
{
//TODO:
Addextravalidationhere
UpdateData(true);
m_sName.TrimRight("");
m_sID.TrimRight("");
m_sDiscount.TrimRight("");
m_sMemo.TrimLeft("");
//Makesureallneededinfoisavailable
CStringsWarning="";
if(""==m_sName)sWarning=_T("顾客姓名");
elseif(""==m_sID)sWarning=_T("身份证号码");
elseif(""==m_sDiscount)sWarning=_T("折扣");
if(""!
=sWarning)
{
sWarning+=_T("不能为空");
AfxMessageBox(sWarning,MB_ICONEXCLAMATION);
return;
}
floatfDiscount=atof(m_sDiscount);
if(0==fDiscount)
{
AfxMessageBox(_T("折扣:
请输入非零数字"),MB_ICONEXCLAMATION);
return;
}
m_sDiscount.Format("%.2f",fDiscount);
if(fDiscount>100)
{
AfxMessageBox(_T("折扣溢出,请不要超过100"),MB_ICONEXCLAMATION);
return;
}
_variant_tstrQuery;
//DeleteOldRecord
if(!
m_bAppend)
{
strQuery="deletefrombookinwherecustomID='"+m_sOldID+"'androomno='"+m_sOldRoomNo+"'";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
}
//CheckRecordUnique
strQuery="select*frombookinwhereroomno='"+m_sRoomNo+"'";
theApp.ADOExecute(theApp.m_pADOSet,strQuery);
intiCount=theApp.m_pADOSet->GetRecordCount();
if(0!
=iCount)
{
AfxMessageBox(_T("该房间已经登记入住!
"),MB_ICONEXCLAMATION);
return;
}
//GenerateSerialNo.
CStringsSN;
COleDateTimetoday=COleDateTime:
:
GetCurrentTime();
sSN=today.Format("%y%m%d%H%M%S");
//GetIndate
CStringsInDate;
sInDate=m_tInDAte.Format("%Y-%m-%d");
//InsertRecord
strQuery="insertbookin(bookno,customname,customID,roomno,indate,discount,inmemo)\
values('"+sSN+"','"+m_sName+"','"+m_sID+"','"+m_sRoomNo+"','"+sInDate+"',"+m_sDiscount+",'"+m_sMemo+"')";
if(theApp.ADOExecute(theApp.m_pADOSet,strQuery))
{
if(m_bAppend)
{
AfxMessageBox(_T("添加记录成功!
"),MB_ICONINFORMATION);
//ClearAllInput
m_sName=m_sID=m_sDiscount=m_sMemo="";
((CComboBox*)GetDlgItem(IDD_