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

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

if ( 0==iCount ) { AfxMessageBox(_T(\读取客房价格错误！\ return; } // Get Price and Update Dialog Holder = theApp.m_pADOSet->GetCollect(\ m_sPrice.Format(\ UpdateData(false); }

1.4 订房信息管理模块的实现

BOOL CBookInDLG::OnInitDialog() { CDialog::OnInitDialog(); ((CEdit*)GetDlgItem(IDD_BOOKIN_NAME))->SetLimitText(20); ((CEdit*)GetDlgItem(IDD_BOOKIN_ID))->SetLimitText(18); // TODO: Add extra initialization here if (m_bAppend) { // Update Dialog Caption SetWindowText(_T(\添加订房信息\

// Init Combobox _variant_t strQuery, Holder; strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); int iCount = theApp.m_pADOSet->GetRecordCount(); theApp.m_pADOSet->MoveFirst(); for (int i=0; iGetCollect(\ ((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->InsertString(i, Holder.vt==VT_NULL?\ // Get other onfo to display if ( 0==i ) { // Get RoomType Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomType = Holder.vt==VT_NULL?\ // Get roomposition Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomPosition = Holder.vt==VT_NULL?\ // Get roomprice Holder = theApp.m_pADOSet->GetCollect(\

31

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

m_sRoomPrice.Format(\ // Get roommemo Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomMemo = Holder.vt==VT_NULL?\ } theApp.m_pADOSet->MoveNext(); } ((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->SetCurSel(0); } else { // Get Old ID and RoomNo m_sOldID = m_sID; m_sOldRoomNo = m_sRoomNo; // Update Dialog Caption SetWindowText(_T(\修改订房信息\ // Init Combobox _variant_t strQuery, Holder; CString str; int iSel = 0; strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); int iCount = theApp.m_pADOSet->GetRecordCount(); theApp.m_pADOSet->MoveFirst(); for (int i=0; iGetCollect(\ str = Holder.vt==VT_NULL?\ ((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->InsertString(i, str); // Get other onfo to display if ( str==m_sRoomNo ) { // Get RoomType Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomType = Holder.vt==VT_NULL?\ // Get roomposition Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomPosition = Holder.vt==VT_NULL?\ // Get roomprice Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomPrice.Format(\ // Get roommemo Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomMemo = Holder.vt==VT_NULL?\

32

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

iSel = i; } theApp.m_pADOSet->MoveNext(); } ((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->SetCurSel(iSel); } UpdateData(false); return TRUE; // return TRUE unless you set the focus to a control // EXCEPTION: OCX Property Pages should return FALSE }

void CBookInDLG::OnRoomNoSelChange() { // TODO: Add your control notification handler code here UpdateData(true); _variant_t strQuery, Holder; strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); // Get RoomType Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomType = Holder.vt==VT_NULL?\ // Get roomposition Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomPosition = Holder.vt==VT_NULL?\ // Get roomprice Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomPrice.Format(\ // Get roommemo Holder = theApp.m_pADOSet->GetCollect(\ m_sRoomMemo = Holder.vt==VT_NULL?\ UpdateData(false); }

void CBookInDLG::OnOK() { // TODO: Add extra validation here UpdateData(true); m_sName.TrimRight(\ m_sID.TrimRight(\ m_sDiscount.TrimRight(\ m_sMemo.TrimLeft(\ // Make sure all needed info is available CString sWarning=\ if ( \顾客姓名\ else if ( \身份证号码\ else if ( \折扣\

33

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

if ( \ {

sWarning += _T(\不能为空\

AfxMessageBox(sWarning, MB_ICONEXCLAMATION); return; }

float fDiscount=atof(m_sDiscount); if ( 0==fDiscount ) { AfxMessageBox(_T(\折扣：请输入非零数字\ return; }

m_sDiscount.Format(\if ( fDiscount>100 ) {

AfxMessageBox(_T(\折扣溢出，请不要超过100\

return; } _variant_t strQuery; // Delete Old Record if ( !m_bAppend ) { strQuery = \from bookin where customID='\roomno='\

theApp.ADOExecute(theApp.m_pADOSet, strQuery); } // Check Record Unique

strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); int iCount = theApp.m_pADOSet->GetRecordCount(); if ( 0!=iCount ) { AfxMessageBox(_T(\该房间已经登记入住！\

and

return; } // Generate Serial No. CString sSN; COleDateTime today = COleDateTime::GetCurrentTime(); sSN = today.Format(\ // Get Indate CString sInDate; sInDate = m_tInDAte.Format(\ // Insert Record strQuery = \bookin (bookno, customname, customID, roomno, indate, discount,

34

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

inmemo) \\ values ('\'\ '\'\'\

if ( theApp.ADOExecute(theApp.m_pADOSet, strQuery) ) { if ( m_bAppend ) { AfxMessageBox(_T(\添加记录成功！\ // Clear All Input m_sName=m_sID=m_sDiscount=m_sMemo=\

((CComboBox*)GetDlgItem(IDD_BOOKIN_ROOMNO))->SetCurSel(0); UpdateData(false); //Update Room Info

strQuery = \ theApp.ADOExecute(theApp.m_pADOSet, strQuery); } else AfxMessageBox(_T(\修改记录成功！\

} else { if ( m_bAppend ) AfxMessageBox(_T(\添加记录失败！\ else AfxMessageBox(_T(\修改记录失败！\

} // Refresh BookIn List strQuery = \ CHotel_MISView*p=

(CHotel_MISView*)(((CMainFrame*)AfxGetMainWnd())->GetActiveView()); p->RefreshBookIn(strQuery); if (!m_bAppend) CDialog::OnOK(); }

1.5 结算信息管理模块的实现

BOOL CCheckOutDLG::OnInitDialog() { CDialog::OnInitDialog(); // TODO: Add extra initialization here _variant_t strQuery, Holder; if (m_bAppend)// Add CheckOut { CString sRoomNo; // Init Combobox strQuery = \ ( \\ select roomno from bookin where checkdate is NULL\\

35