【正文】 1 圖 7 實(shí)體之間關(guān)系 ER 圖 (3)數(shù)據(jù)庫表結(jié)構(gòu)設(shè)計(jì) 首先將酒店客房管理系統(tǒng)的數(shù)據(jù)庫概念結(jié)構(gòu)轉(zhuǎn)化為 ACCESS 數(shù)據(jù)庫系統(tǒng)所支持的實(shí)際數(shù)據(jù)模型，即：數(shù)據(jù)庫的邏輯結(jié)構(gòu)。 \ End Sub Private Sub Form_Activate() 39。 If And And = (密 碼 ) Then Load main Unload Me Else If TIM = 3 Then 39。查詢客房信 息 = select * from kf where 房間類型 =39。登記 = : = : = = : = = True: = True: = False End Sub Private Sub save_Click() 39。 圖 11 客人信息 客人信息的修改和查詢，包括客房編號(hào)、客房種類、客房位置、客房單價(jià)、顧客姓名、顧客身份證號(hào)碼、入住日期、折扣、結(jié)日期、備注信息等。有就提示，然后退出 !RoomStatus = False End If With .Delete End With End If End With End If End Sub Private Sub cmdEdit_Click() If True And True Then With frmGuestInfoEdit 39。 圖 14 房間基本情況表 主要代碼如下所示： 39。綁定顯示字段 .Sections(Section1).Controls(txtRoomNo).DataField = RoomNo .Sections(Section1).Controls(txtRoomGrade).DataField = RoomGrade .Sections(Section1).Controls(txtRoomGrade). = 5 .Sections(Section1).Controls(txtRoomGrade). = 標(biāo)準(zhǔn)間 .Sections(Section1).Controls(txtRoomGrade). = 豪華間 .Sections(Section1).Controls(txtRoomGrade). = 未知 .Sections(Section1).Controls(txtRoomType).DataField = RoomType .Sections(Section1).Controls(txtRoomType). = 5 .Sections(Section1).Controls(txtRoomType). = 單人間 .Sections(Section1).Controls(txtRoomType). = 雙人間 .Sections(Section1).Controls(txtRoomType). = 未知 .Sections(Section1).Controls(txtRoomRate).DataField = RoomRate .Sections(Section1).Controls(txtRoomStatus).DataField = RoomStatus .Sections(Section1).Controls(txtRoomStatus). = 5 .Sections(Section1).Controls(txtRoomStatus). = 在住 .Sections(Section1).Controls(txtRoomStatus). = 空房 .Sections(Section1).Controls(txtRoomStatus). = 未知 39。 與開發(fā)過程類似，測(cè)試過程也必須分布驟進(jìn)行，每個(gè)步驟在邏輯上是前一個(gè)步驟的繼續(xù)。正式測(cè)試之前必須先通過編譯 程序檢查并且改正所有語法錯(cuò)誤，然后用詳細(xì)設(shè)計(jì)描述作指南，對(duì)重要的執(zhí)行通路進(jìn)行測(cè)試，以便發(fā)現(xiàn)模塊內(nèi)部的錯(cuò)誤。另外，在整個(gè)開發(fā)的過程中，時(shí)間也比較倉促。 （ 3）提高決策依據(jù)：管理者可以隨時(shí)了解經(jīng) 營情況，以制定相應(yīng)的經(jīng)營方針。這是我人生的一大轉(zhuǎn)折點(diǎn)，更是我飛步向前的起跑點(diǎn)。 but we have a wild journey, also which is national and modern, and that is the journey to Amack on the night of the New Year. All indifferent poets and poetesses, musicians, newspaper writers, and artistic notabilities, I mean those who are no good, ride in the New Year39。 and those mat are of solid and sober natures have more of the ballast, than of the sail. In fame of learning, the flight w ill be slow, without some feathers of ostentation. Q ui de contenm enda gloria libros scribunt, nomen suum inscribunt. Socrates, Aristotle, Galen, were men firil of ostentation. Certainly vainglory helpeth to perpetuate a man\39。 if he be superior, if he be not to be mended, you much less. Glorious men are the scorn of wise men。 and in the second degreegreat when they are mitted against private rites and sepulchres,and in the third degree (not to repeat the acts formerly mentioned),when insults are offered to parents。 for these are the offences which are and have been, and willeve r be, the source of all the aforesaid evils. The greatest of themare excesses and insolences of youth, and are offences against thegreatest when they are done against religion。 In mending another, you do your self right。 as if a man that negotiates between two princes, to draw them to join in a war against the third, doth extol the forces of either of them above measure, the one to the other: and sometimes, he that deals between man and man, raiseth his own credit with both by pretending greater interest than he hath in either. And in these, and the like kinds, it often fa lls out that somewhat is produced of nothing: for lies are sufficient to breed opinion, and opinion brings on substance. In military manders and soldiers, vainglory is an essential point。t know what that is! The journey of the witches on broomsticks is well enough known that journey is taken on St. John39。 另外，大學(xué)生活即將結(jié)束，非常懷念在校期間的點(diǎn)點(diǎn)滴滴，特別是與教師們之間的交流與溝通。總之，使用本酒店客房管理系統(tǒng)，將會(huì)有以下優(yōu)點(diǎn)： （ 1）電腦收銀，打印帳單：快速準(zhǔn)確，減少賓客等待時(shí)間，并可杜 絕收銀過程中的舞弊現(xiàn)象。在工資管理系統(tǒng)測(cè)試中，按照前面的“工資管理系統(tǒng)的層次圖”，采用自頂向下的方式進(jìn)行測(cè)試。驗(yàn)收測(cè)試的目的是驗(yàn)證系統(tǒng)確實(shí)能夠滿足用戶的需要。 系統(tǒng)運(yùn)行環(huán)境： 586 以上 PC 機(jī)， 256M 內(nèi)存， WINDOWS 98 操作系統(tǒng)。實(shí)施報(bào)表數(shù)據(jù)源綁定 39。查詢客房信息 = select * from kf where like + Chr(34) + + * + Chr(34) + End Sub Private Sub Command2_Click() 39。 39。設(shè)置控件有效或無效 = False: = False = True: = True End Sub Private Sub cancel_Click() 39。按回車鍵 Combo1獲得焦點(diǎn) End Sub Private Sub Combo2_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyReturn Then End Sub Private Sub texjg_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyReturn Then End Sub Private Sub DTP1_KeyDown(KeyCode As Integer, Shift As Integer) If KeyCode = vbKeyReturn Then 39。 \ 39。 amp。自動(dòng)識(shí)別數(shù)據(jù)庫路徑 = amp。 (2)數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計(jì) 。 （ 4）系統(tǒng)管理：管理員利用自己的用戶名和密碼維護(hù)本系統(tǒng)正常運(yùn)行。 （ 3）訂房信息，包括的數(shù)據(jù)項(xiàng)有：訂房編號(hào)、客房編號(hào)、客房種類、客房備注信息、顧客姓名、顧客身份證號(hào)碼、入住時(shí)間 、折扣、備注等。 系統(tǒng)開發(fā)的總體任務(wù)是實(shí)現(xiàn)酒店客房各種信息的系統(tǒng)化、規(guī)范化和自動(dòng)化。 （ 3） 經(jīng)濟(jì)上的可行性 操作人員只需簡單培訓(xùn)即可上崗。從 操作 、技術(shù)、經(jīng)濟(jì)三方面，結(jié)合當(dāng)前企業(yè)所需的人 力、物力、財(cái)力對(duì)酒店信息管理系統(tǒng)進(jìn)行分析，系統(tǒng)開發(fā)在當(dāng)前環(huán)境條件可行。 傳統(tǒng)的酒店客房管理往往令管理者花大量的時(shí)間來處理顧客投訴，例如錯(cuò)誤查詢、煩瑣的登記和結(jié)帳手續(xù)、旅客費(fèi)用計(jì)算錯(cuò)誤、空余客房資料不能及時(shí)提供等，從而影響出租率，使的管理人員不得不集中精力規(guī)劃 管理運(yùn)行策略和進(jìn)行決策。 （ 2）軟件 本系統(tǒng)在開發(fā)時(shí)選用了穩(wěn)定性較強(qiáng)的 W