【正文】 畢業(yè)設(shè)計(jì)（論文） 題 目： 基于 C賓館 客房管理系統(tǒng) 的 設(shè)計(jì) 與實(shí)現(xiàn) I 摘 要 利用先進(jìn)的管理手段，提高賓館客房的管理水平，已成為賓館酒店業(yè)在越演越烈的競(jìng)爭(zhēng)中發(fā)展的當(dāng)務(wù)之急。以前，大多數(shù)賓館客房管理都是通過手工來完成，現(xiàn)在取而代之的則是網(wǎng)絡(luò)管理系統(tǒng)?；诰W(wǎng)絡(luò)的計(jì)算機(jī)應(yīng)用系統(tǒng)更有利于酒店內(nèi)部管理，為企業(yè)和客戶都帶來了很大便利，節(jié)約客戶訂房時(shí)間，方便賓館的管理，而無需受空間距離的限制。 賓館客房管理系統(tǒng)主要包括員工的信息管理、房間類型管理、房 間信息管理、房間經(jīng)營管理、客戶信息查詢及經(jīng)營狀況管理等功能，采用目前流行的 Microsoft Visual studio . 2021 為開發(fā)工具，運(yùn)用 SQL Server2021 做為后臺(tái)數(shù)據(jù)庫的管理。用戶登錄時(shí)設(shè)置權(quán)限管理，登錄完畢后，對(duì)功能管理的查詢，可以根據(jù)不同的需要進(jìn)行查詢。界面簡(jiǎn)單明了，功能一目了然，操作簡(jiǎn)單易學(xué)，適用于中小型賓館應(yīng)用。 關(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 簡(jiǎn)介 .............................................................................. 3 Microsoft SQL Server 2021 簡(jiǎn)介 .................................................................. 4 介紹 .............................................................................................. 5 運(yùn)行環(huán)境及配置 ............................................................................................ 6 系統(tǒng)需求分析 ........................................................................................................................... 7 需求分析 ....................................................................................................................... 7 可行性分析 ................................................................................................................... 7 技術(shù)可行性 .................................................................................................... 8 經(jīng)濟(jì)可行性 .................................................................................................... 8 運(yùn)行可行性 .................................................................................................... 8 系統(tǒng)概要設(shè)計(jì) ........................................................................................................................... 9 設(shè)計(jì)目標(biāo) ....................................................................................................................... 9 系統(tǒng)功能模塊圖 ........................................................................................................... 9 系統(tǒng)數(shù)據(jù)流圖 ............................................................................................................. 11 顧客入住活動(dòng)圖 .......................................................................................... 11 系統(tǒng)數(shù)據(jù)庫設(shè)計(jì) ......................................................................................................... 13 數(shù)據(jù)庫設(shè)計(jì)原則 .......................................................................................... 13 數(shù)據(jù)庫概念結(jié)構(gòu)設(shè)計(jì) (ER 圖 ).................................................................... 13 數(shù)據(jù)表的設(shè)計(jì) .............................................................................................. 17 詳細(xì)設(shè)計(jì) ................................................................................................................................. 20 系統(tǒng)主要功能流程 ..................................................................................................... 20 顧客入住流程 .............................................................................................. 20 顧客換房流程 .............................................................................................. 20 顧客點(diǎn)菜流程 .............................................................................................. 21 賓館營業(yè)額統(tǒng)計(jì)流程 .................................................................................. 21 IV 系統(tǒng)功能界面 ............................................................................................................. 22 系統(tǒng)登錄模塊 .............................................................................................. 22 系統(tǒng)主界面 .................................................................................................. 23 客房預(yù)定模塊 .............................................................................................. 24 會(huì)員注冊(cè)模塊 .............................................................................................. 25 預(yù)定管理模塊 .............................................................................................. 26 客房入住模塊 ..........................................................................