宾馆管理系统课程设计报告(8)

来源：网络收集时间：2019-06-11 下载这篇文档手机版

说明：文章内容仅供预览，部分内容可能不全，需要完整文档或者需要复制内容，请下载word后使用。下载word有问题请添加微信号:或QQ：处理（尽可能给您提供完整文档），感谢您的支持与谅解。

宾馆管理系统数据库课程设计报告

)\ theApp.ADOExecute(theApp.m_pADOSet, strQuery); int iCount = theApp.m_pADOSet->GetRecordCount(); theApp.m_pADOSet->MoveFirst(); for (int i=0; iGetCollect(\ ((CComboBox*)GetDlgItem(IDD_CHECKOUT_ROOMNO))->InsertString(i, Holder.vt==VT_NULL?\ if ( 0==i ) { sRoomNo = Holder.vt==VT_NULL?\ // Get RoomType Holder = theApp.m_pADOSet->GetCollect(\ m_sType = Holder.vt==VT_NULL?\ // Get roomposition Holder = theApp.m_pADOSet->GetCollect(\ m_sPosition = Holder.vt==VT_NULL?\ // Get roomprice Holder = theApp.m_pADOSet->GetCollect(\ m_sPrice.Format(\ } theApp.m_pADOSet->MoveNext(); } ((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->SetCurSel(0); // Get customer info strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); // Get name Holder = theApp.m_pADOSet->GetCollect(\ m_sName = Holder.vt==VT_NULL?\ // Get ID

Holder = theApp.m_pADOSet->GetCollect(\ m_sID = Holder.vt==VT_NULL?\ // Get InDate

COleDateTime time; Holder = theApp.m_pADOSet->GetCollect(\ time = Holder; m_sInDate = time.Format(\ // Get ID

Holder = theApp.m_pADOSet->GetCollect(\ m_sDiscount.Format(\ // Get Memo Holder = theApp.m_pADOSet->GetCollect(\

宾馆管理系统数据库课程设计报告

m_sMemo = Holder.vt==VT_NULL?\ } else// Alter CheckOut { ((CComboBox*)GetDlgItem(IDD_CHECKOUT_ROOMNO))->InsertString(0, m_sRoomNo); // Get Room Info strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); int iCount = theApp.m_pADOSet->GetRecordCount(); theApp.m_pADOSet->MoveFirst(); // Get RoomType Holder = theApp.m_pADOSet->GetCollect(\ m_sType = Holder.vt==VT_NULL?\ // Get roomposition Holder = theApp.m_pADOSet->GetCollect(\ m_sPosition = Holder.vt==VT_NULL?\ // Get roomprice Holder = theApp.m_pADOSet->GetCollect(\ m_sPrice.Format(\ ((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->SetCurSel(0); } UpdateData(false); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE }

void CCheckOutDLG::OnCheckoutRoomNoSelChange() { // TODO: Add your control notification handler code here UpdateData(true); _variant_t strQuery, Holder; // Update room info strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); // Get RoomType Holder = theApp.m_pADOSet->GetCollect(\ m_sType = Holder.vt==VT_NULL?\ // Get roomposition Holder = theApp.m_pADOSet->GetCollect(\ m_sPosition = Holder.vt==VT_NULL?\ // Get roomprice Holder = theApp.m_pADOSet->GetCollect(\ m_sPrice.Format(\ // Update customer info

strQuery = \

宾馆管理系统数据库课程设计报告

theApp.ADOExecute(theApp.m_pADOSet, strQuery); // Get name Holder = theApp.m_pADOSet->GetCollect(\ m_sName = Holder.vt==VT_NULL?\ // Get ID

Holder = theApp.m_pADOSet->GetCollect(\ m_sID = Holder.vt==VT_NULL?\ // Get InDate COleDateTime time; Holder = theApp.m_pADOSet->GetCollect(\ time = Holder; m_sInDate = time.Format(\ // Get ID

Holder = theApp.m_pADOSet->GetCollect(\ m_sDiscount.Format(\ // Get Memo Holder = theApp.m_pADOSet->GetCollect(\ m_sMemo = Holder.vt==VT_NULL?\ UpdateData(false); }

void CCheckOutDLG::OnOK() { // TODO: Add extra validation here UpdateData(true); // Get InDate _variant_t strQuery, Holder; COleDateTime tInDate; strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); Holder = theApp.m_pADOSet->GetCollect(\ tInDate = Holder; if ( tInDate>m_tOutDate ) { AfxMessageBox(_T(\结帐日期小于入住日期，请重新输入结帐日期！MB_ICONEXCLAMATION); return; } // Caculate Bill COleDateTimeSpan timeSpan; timeSpan = m_tOutDate - tInDate; int iDays = timeSpan.GetDays()+1; float fPrice = atof(m_sPrice); float fDiscount = atof(m_sDiscount); float fAmmount = fPrice*iDays*fDiscount/100;

\38

宾馆管理系统数据库课程设计报告

CString sAmmount; sAmmount.Format(\ CString sTip = _T(\金额为：\

sTip += sAmmount;

sTip += _T(\ 结算完毕!！\

AfxMessageBox(sTip, MB_ICONINFORMATION); // Update DataBase CString sOutDate; sOutDate = m_tOutDate.Format(\ strQuery = \

where roomno='\

theApp.ADOExecute(theApp.m_pADOSet, strQuery); // Refresh CheckOut List strQuery = \ CHotel_MISView*p=(CHotel_MISView*)(((CMainFrame*)

AfxGetMainWnd())->GetActiveView());

p->RefreshCheckOut(strQuery); CDialog::OnOK(); }

2. 测试和运行

2.1用户登录界面

管理员登陆，设置用户名为“Administrator”，密码为空

2.2 客房标准初始化界面如下：

宾馆管理系统数据库课程设计报告

2.1.1 添加客房标准若标准编号重复，显示已存在记录

2.2 .2修改客房标准

百度搜索“77cn”或“免费范文网”即可找到本站免费阅读全部范文。收藏本站方便下次阅读，免费范文网，提供经典小说综合文库宾馆管理系统课程设计报告(8)在线全文阅读。

宾馆管理系统课程设计报告(8).doc 将本文的Word文档下载到电脑，方便复制、编辑、收藏和打印下载失败或者文档不完整，请联系客服人员解决！

下载这篇word文档

本文链接：https://www.77cn.com.cn/wenku/zonghe/656871.html（转载请注明文章来源）

上一篇：水泵与水泵站课程设计
下一篇：夏季物业管理工作重点