【正文】 畢業(yè)設(shè)計（論文） 題 目： 基于 C賓館 客房管理系統(tǒng) 的 設(shè)計 與實現(xiàn) I 摘 要 利用先進的管理手段，提高賓館客房的管理水平，已成為賓館酒店業(yè)在越演越烈的競爭中發(fā)展的當務(wù)之急。以前，大多數(shù)賓館客房管理都是通過手工來完成，現(xiàn)在取而代之的則是網(wǎng)絡(luò)管理系統(tǒng)。基于網(wǎng)絡(luò)的計算機應用系統(tǒng)更有利于酒店內(nèi)部管理，為企業(yè)和客戶都帶來了很大便利，節(jié)約客戶訂房時間，方便賓館的管理，而無需受空間距離的限制。 賓館客房管理系統(tǒng)主要包括員工的信息管理、房間類型管理、房 間信息管理、房間經(jīng)營管理、客戶信息查詢及經(jīng)營狀況管理等功能，采用目前流行的 Microsoft Visual studio . 2021 為開發(fā)工具，運用 SQL Server2021 做為后臺數(shù)據(jù)庫的管理。用戶登錄時設(shè)置權(quán)限管理，登錄完畢后，對功能管理的查詢，可以根據(jù)不同的需要進行查詢。界面簡單明了，功能一目了然，操作簡單易學，適用于中小型賓館應用。 關(guān)鍵字： 客房管理 。C.NET。 SQL 數(shù)據(jù)庫 II Abstract The use of advanced management tools to enhance the management level of the hotel rooms, the hotel industry has bee a guesthouse undoubtedly increased petition in the development of the moment. Previously, the majority of hotel rooms are managed by hand to plete, it is now replaced by the work management system. Webbased puter application system more conducive to the hotel management for the enterprise and customers have brought great convenience to facilitate the management of the hotels, save customers order rooms time, and are not subject to restrictions of space distance. Hotel Room Management System consists mainly of staff for information management, room type management, information management room, room management, customer enquiries and operation of information management, and other functions, using the popular Microsoft Visual studio. Net 2021 for the development of tools, use of SQL Server 2021, as a background database management. Uer login set permissions management after registration is pleted, functional management enquiries can be carried out in accordance with the needs of different enquiries. Simple interface, functional clear, simple to learn, apply to small and mediumsized hotels application. Keywords: Guest room management。 C.NET。 Structured Query Language Database III 目 錄 緒 論 ......................................................................................................................................... 1 開發(fā)工具和環(huán)境介紹 ............................................................................................................... 3 開發(fā)軟件技術(shù) ............................................................................................................... 3 Visual C.NET 2021 簡介 .............................................................................. 3 Microsoft SQL Server 2021 簡介 .................................................................. 4 介紹 .............................................................................................. 5 運行環(huán)境及配置 ............................................................................................ 6 系統(tǒng)需求分析 ........................................................................................................................... 7 需求分析 ....................................................................................................................... 7 可行性分析 ................................................................................................................... 7 技術(shù)可行性 .................................................................................................... 8 經(jīng)濟可行性 .................................................................................................... 8 運行可行性 .................................................................................................... 8 系統(tǒng)概要設(shè)計 ........................................................................................................................... 9 設(shè)計目標 ....................................................................................................................... 9 系統(tǒng)功能模塊圖 ........................................................................................................... 9 系統(tǒng)數(shù)據(jù)流圖 ............................................................................................................. 11 顧客入住活動圖 .......................................................................................... 11 系統(tǒng)數(shù)據(jù)庫設(shè)計 ......................................................................................................... 13 數(shù)據(jù)庫設(shè)計原則 .......................................................................................... 13 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計 (ER 圖 ).................................................................... 13 數(shù)據(jù)表的設(shè)計 .............................................................................................. 17 詳細設(shè)計 ................................................................................................................................. 20 系統(tǒng)主要功能流程 ..................................................................................................... 20 顧客入住流程 .............................................................................................. 20 顧客換房流程 .............................................................................................. 20 顧客點菜流程 .............................................................................................. 21 賓館營業(yè)額統(tǒng)計流程 .................................................................................. 21 IV 系統(tǒng)功能界面 ............................................................................................................. 22 系統(tǒng)登錄模塊 .............................................................................................. 22 系統(tǒng)主界面 .................................................................................................. 23 客房預定模塊 .............................................................................................. 24 會員注冊模塊 .............................................................................................. 25 預定管理模塊 .............................................................................................. 26 客房入住模塊 ..........................................................................