【正文】
and。s without the consent of theowner。 and the slaves of their own vaunts. LastIndexNext And now having spoken of assaults, let us sum up all acts ofviolence under a single law, which shall be as follows:No one shallta ke or carry away any of his neighbour39。 the admiration of fools。 for he that you mend, is either superior to you, in that you mend, or inferior. If he be inferior, if he be to be mended, you much more。s self hath any perfection. For saith Pliny very wittily。 omnium, quae cHxerat jeceratque, arte quadam ostentator: for that proceeds not of vanity, but of natural magnanimity, and discretion: and in some persons is not only ely, but gracious. For excusations, cessions, modesty itself well governed, are but arts of ostentation. And amongst those arts there is none better, than that which P linius Secundus speaketh of。s memory。 for as iron sharpens iron, so by glory one courage sharpeh another. In cases of great enterprise, upon charge and adventure, a position of glorious natures doth put life into business。 there are sometimes great effects of cross lies。 but according to die French proverb。s night through the air to Amack. They sit backwards on their painting b all lapse of time, and had bee a cipher and a nothing. Then three alone, or moveth upon greater means, if they have never so little hand in it, they think it is they that carry it They that are glorious, must needs be factious。s eve, to the Brocken。s diversion, namely, the wild hunt to Amack. Ah, you don39。s really a pleasure now and then to bee a mere nothing, especially when a man is as highly placed as I am. And then to think that we all, even with patent lacquer, are nothing more than insects of a moment on that anthill the earth, though we may be insects with stars and garters, places and offices! One feels quite a novice beside these venerable millionyearold boulders. On last New Year39。衷心祝愿敬愛的老師們,工作順利!事事如意! 參考文獻 [1]田金蘭 . Visual Basic 6 使 用指南 .電子工業(yè)出版社, 2021 [2]Jeffrey. Visual Basic 6 數(shù)據(jù)庫訪問技 .機械工業(yè)出版社, 2021 [3]潘錦平 . 軟件開發(fā)技術(shù) .西安電子科技大學(xué)出版社, 1999 [4]王珊,薩師宣 .數(shù)據(jù)庫系統(tǒng)概論 .高等教育出版社, 2021 [5]陸麗娜 .軟件工程 .經(jīng)濟科學(xué)出版社, 2021 [6](英) John : 張淮野 ,袁怡等 .數(shù)據(jù)庫設(shè)計與編程實例詳解 ——使用 Access、 SQL與 VB , [ Database Design and Programming—— with Access, SQL and Visual Basic],電子工業(yè)出版社, 2021 [7]周國民 .Visual Basic+Access 數(shù)據(jù)庫項目開發(fā)實踐 ,中國鐵道出版社 ,2021 [8] 何玉潔 .數(shù)據(jù)庫原理與應(yīng)用教程 , 機械工業(yè)出版社 ,2021 [9] Hector GarciaMolina Jeffrey Jennifer Widom,譯者 : 楊冬青 徐其鈞 唐世渭 , Database System Implementation 數(shù)據(jù)庫系統(tǒng)實現(xiàn) ,機械工業(yè)出版社 ,2021 [10]鄭榮貴,黃平, 谷會東 .Visual 數(shù)據(jù)庫開發(fā)與應(yīng)用,中科多媒體電子出版社, 2021 54 Of Vainglory It was prettily devised of Aesop。在這里我要感謝所有曾給予我指導(dǎo)和幫助的學(xué)院的老師們,沒有你們不厭其煩的教誨,就沒有我的今天。沒有老師在百忙之中抽出他寶貴的業(yè)余時間來為我指導(dǎo),我想我是完成不了畢業(yè)設(shè)計與論文的。相信該酒店客房管理系統(tǒng)將是一套酒店客房管理員必不可少的管理軟件。在系統(tǒng)功能上,還有許多細節(jié)問題沒有考慮周到。因此,該系統(tǒng)必然會存在一些缺陷和不足。 結(jié) 束語 在本系統(tǒng)的開發(fā)過程中,由于本人是初次開發(fā)軟件,在知識、經(jīng)驗方面都存在著不足。顯示報表預(yù)覽 .Show End With End Sub 系統(tǒng)為用戶提供了很多的功能。設(shè)置屬性 .Caption = 房間基本情況表 39。先查詢出結(jié)果 OpenTable , select * from Room order by RoomNo,RoomRate With drpRoomRequired Set .DataSource = 39。 39。Private Sub mnuQueryRoomInfo_Click() 39。第三列標題和寬度 .Columns(2).Caption = 付款金額 (元 ) .Columns(2).Width = 80 .Columns(2).AllowSizing = False End With End Sub 報表輸出信息模塊 本模塊主要是把所有房間的情況,規(guī)例成表輸出給管理員打印,方便及時匯報酒店的情況,主要是用于跟上級匯報情況時用到。第一列標題和寬度 .Columns(0).Caption = 登記號 .Columns(0).Width = 80 .Columns(0).AllowSizing = False 39。選擇方式為整行選中 .MarqueeStyle = dbgHighlightRow 39。實施綁定 .AllowRowSizing = False 39??头啃畔⒉樵兗靶б娌樵儯四K功能差不多。窗體標題 .Caption = 修改客人信息 . = !BookNo . = True . = !GuestName . = !CardID .txtRoomNo = !RoomNo . = !BookDate 39。, , adSearchForward, 1 If Not .EOF Then 39。 !RoomNo amp。顯示為模式窗體 .Show vbModal End With End Sub Private Sub cmdDelete_Click() If True And True Then With If MsgBox( 確 認 要 刪 除 當(dāng) 前 記 錄 嗎 ? , vbYesNo + vbQuestion + vbDefaultButton2, 確認框 ) = vbYes Then .Find RoomNo=39。 主要代碼如下所示: Private Sub cmdAddNew_Click() With frmGuestInfoEdit 39。單人間 . = 0 Else 39。標準間 . = 0 Else 39。窗體標題 .Caption = 修改客房信息 39。默認教師為第一項 If . = 0 Then . = 1 Else . = 0 End If .txtRoomRate = 39。清空班級編號并設(shè)為可修改 . = False . = 39。 主要代碼如下所示: Private Sub cmdAddNew_Click() With frmRoomInfoEdit 39。 客房信息模塊 本功能模塊可以查看并修改客房的信息資料,可以對客房的編號,房間的級別,房間類型,房間價格,是否有人住等信息進行隨時更新。重新輸入密碼 SendKeys {HOME}+{END} End If End Sub 系統(tǒng)主界面 當(dāng)輸入用戶名和密碼正確則進入系統(tǒng)主界面,如圖 所示。關(guān)閉數(shù)據(jù)庫中的 Users 表 End 39。用戶名或密碼不對 MsgBox 用戶名或密碼不對! , vbOKOnly + vbInformation, 提示 intLoginTimes = intLoginTimes + 1 If intLoginTimes = 3 Then 39。關(guān)閉窗體 39。沒找到記錄 strUserName = strPassword = End If If strUserName = And strPassword = Then 39。 If Not Then 39。 amp。 = Name=39。, , adSearchForward, 1 39。 amp。查找用戶名 Name=39。如果用戶名為空 MsgBox 用戶名不能為空! , vbOKOnly + vbCritical, 錯誤 Exit Sub End If 39。同時通過登陸信息輸入來確認使用權(quán)限, 管理員通過登陸系統(tǒng)后,便可 進行管理和維護。將客人信息記入數(shù)據(jù)庫備查。 ( 8)離店 表 8:離店收銀數(shù)據(jù)字典 數(shù)據(jù)處理名:退房 簡 述:在客人離店的時候,核實房間的物件等,同時更改 “ 客房占用信息表 ” 輸 入:有客人 ID的 IC卡,來源:外部實體 “ 客人 ” 輸 出: [1] 有問題,去處:外部實體 “ 客人 ” [2] 無問題,退房憑證,去處: 收銀 數(shù)據(jù)流名稱:退房憑證 簡 述:在房間核實無誤后開給客人的允許結(jié)帳憑證 組 成:身份證號 +姓名 +性別 +IC卡 ID號 +客房核實結(jié)果 數(shù)據(jù)處理名:收銀 簡 述:根據(jù)客人的消費進行收取費用、退還押金。 ( 7) 接待個人(已預(yù)