1、酒店管理系统详细设计The Program Design Report of Hotel Management System拟 制 人 荧火虫项目组 审 核 人 批 准 人 二零一零年十一月三十日2目 录1 引言(INTRODUCTIONS) .11.1 编写目的(PURPOSES) 11.2 背景(PROJECT B ACKGROUND) 21.3 参考资料(REFERENCES) 32 系统的结构(SYSTEM STRUCTURE) .42.1 总体结构(GENERAL STRUCTURE).42.2 运行环境(RUNNING ENVIRONMENT) 62.2.1 硬件要求 (The h
2、ardware requirements)： 62.2.2 软件要求 (Software requirements)： 62.3 系统架构(SYSTEM ARCHITECTURE) .63 模块设计(SYSTEM OVERVIEW) .73.1 登录模块(LOGIN MODULE)(M1).73.1.1 登陆描述 (Login Description) .73.1.2 处理流程设计 (Processing Flow Design) .73.1.3 输入输出与算法逻辑 (Input/output and Arithmetic Logic)83.1.4 模块界面设计 (Module Interfa
3、ce Design) 83.1.5 局部数据结构 (Local Data Structure) 93.1.6 用户权限设计 (User Permissions Design)93.2 客房管理(ROOM MANAGEMENT)(M2) .103.2.1 模块描述 (Module Described).103.2.2 处理流程设计 (Processing Flow Design) .113.2.3 模块界面设计 (Module Interface Design) 113.2.4 局部数据结构 (Local Data Structure) 133.2.5 算法设计说明 (Algorithm Des
4、ign Descriptions) 143.3 餐饮管理模块(RESTAURANT MANAGEMENT MODULE)(M3) 203.3.1 模块描述 (Module Described).203.3.2 处理流程设计 (Processing Flow Design) .203.3.3 模块界面设计 (Module Interface Design) 203.3.4 局部数据结构 (Local Data Structure) 213.3.5 算法设计 (Algorithm Design)213.4 查询管理模块(INQUIRES THE MANAGEMENT MODULE)(M4) 223
5、.4.1 模块描述 (Module Described).223.4.2 处理流程设计 (Processing Flow Design) .233.4.3 模块界面设计 (Module Interface Design) 233.4.4 局部数据结构 (Local Data Structure) 243.4.5 算法设计 (Algorithm Design)253.5 报表管理模块(STATEMENTS M ANAGEMENT MODULE)(M5).263.5.1 模块描述 (Module Described).263.5.2 处理流程设计 (Processing Flow Design)
6、.273.5.3 模块界面设计 (Module Interface Design) 273.5.4 局部数据结构 (Local Data Structure) 283.5.5 算法设计 (Algorithm Design)293.6 系统管理(SYSTEM M ANAGEMENT)(M6) 313.6.1 模块描述 (Module Described).313.6.2 处理流程设计 (Process design) 323.6.3 模块界面设计 (Module interface design) .323.6.4 局部数据结构 (Local data structure)343.6.5 算法设
7、计说明 (Algorithm design descriptions) 344 数据库设计(DATABASE DESIGN).375 接口(INTERFACE) 425.1 调用级接口(CALL LEVEL INTERFACE)425.2 对象接口(OBJECT INTERFACE) .435.3 外部接口(EXTERNAL INTERFACE) 435.4 内部接口(INTERNAL INTERFACE) .446 测试计划(TESTING PLAN) .446.1 测试要点(MAIN POINTS) .446.2 酒店管理系统测试(SYSTEM TESTING) .45酒店管理系统详细设计
8、The Program Design Report of Hotel Management System11 引言(Introductions)( 马晨)1.1 编写目的(Purposes)随着计算机技术的日益成熟、普及，现代的企业管理的实际运作在很多方面，很大程度上都必须借助于计算机来完成，相应软件的开发也就显得尤为重要。在信息高速发展的今天，时间，效率这样的名词正主导着众的生活和发展，有必要设计开发一个管理信息系统。通过系统功能解决传统管理模式带来的不足，优化酒店管理。Along with the computer technology matures, popularization, t
9、he modern enterprise management of practical operation in many ways, to a great extent, all must use computer to complete, the corresponding software development also are particularly important. In the information high development today, time, the efficiency of such nouns are dominated the life and
10、development, it is necessary to design and develop a management information system. Through the system functions to solve shortcomings arising from traditional management mode, optimizing the hotel management.设计报告论述了分析、开发、设计一个酒店管理系统的过程。该系统融入酒店科学、规范的现代管理思想，为提高各业务部门自身的工作效率，自动完成各业务部门之间的各种营业信息、账务、报表的自动化
11、传输与汇总，使各项工作制度化，科学化。结合先进的计算机技术，采用 C#和 SQL 2005 开发而成。Design report discusses analysis, development, design a hotel management system process. This system into hotel scientific and standard modern management idea, in order to improve the business sector itself automatically complete the work efficiency
12、, from various business units of various business information, between accounting, financial statements of automation transmission and summarizing, make each work institutionalization, and scientific. Combining advanced computer technology, using c # and SQL 2005 development and into. 2设计报告介绍了系统的相关的
13、内容，并通过设计分析，划分数据库，将系统划分为 5 个主要功能模块：客房管理，财务管理，信息查询，系统管理，报表管理。着重叙述了前台管理和系统维护这两个功能的功能实现，这些模块基本上满足了用户（酒店）在客房管理方面的需求。如对客房、员工的设置修改，相关的顾客服务等。Design reports introduced the system related to the content, and through the design analysis, classified database, the system is divided into five main functional modu
14、les: room management, financial management, information query, systems management, statements management. The paper mainly relates the receptionist management and the system to maintain the realization of the function of the two functions, these modules basically meets the user (hotel) in room manag
15、ement needs. As to the guest room, employees modify Settings, related services to the customers. 1.2 背景(Project Background)本项目团队在经过对市场深入细致的分析和研究后，运用计算机技术，结合酒店信息管理模式开发了这套酒店管理系统。一个成熟的酒店管理系统不仅仅是记录酒店客人的信息，提供查询，报表打印等一系列简单的工作，它能让工作人员从烦琐的手工操作中解脱，并且酒店管理系统本身就代表着一种管理方法。随着它的深入，将带动企业的运做，为管理和决策提供支持。使用该酒店管理系统，将会有
16、以下好处：(1)电脑收银，打印账单：快速准确，减少宾客等待时间，并可杜绝收银过程中的舞弊现象。(2)高效的客房管理：能有效的提高房率，增加营业收入。(3)提高决策依据：管理者可以随时了解经营情况，以制定相应的经营方针。(4)减轻员工的工作负担：从而使员工把更多的精力放在提高为宾客服务的质量上。(5)简单、方便地保存和查询历史资料。(6)树立良好的酒店形象。待开发系统的名称：酒店管理系统；酒店管理系统详细设计The Program Design Report of Hotel Management System3开发者：萤火虫项目组；预期用户：中小型酒店。This project team af
17、ter thorough analysis of market research and the use of computer technology, combined with the hotel information management model developed this hotel management system. A mature hotel management system is not only records hotel guests information, provide inquiry, print and so on a series of simple
18、 work, it can make staff from convoluted manual operation, freedom and hotel management system itself represents a kind of management methods. As it deeply, will drive enterprise operation, management and decision support. Use the hotel management system, will have the following advantages: (1)Compu
19、ter cashier, print bill: fast and accurate, reduce guests waiting time, and can eliminate the cashier process of fraud phenomenon. (2)Efficient room management: can effectively improve the room rate, increase revenues. (3)Improve decision basis: managers can understand operating situation, to formul
20、ate the corresponding management policy. (4)Reduce employees work burden: so that employees more focus on improving the quality of the service for the guest. (5)Simple and easy to preserve and inquires the historical data. (6)Set a good hotel image. For development system name: hotel management syst
21、em, Developers: fireflies project, Expected user: small and medium-sized hotel.1.3 参考资料(References)1 Pfleeger，S.L. Consumption entry is in the hotel guests in other articles spending, according to room number, name, time, food and beverage category and the save add records to the database, and print
22、 information. 3.3.2 处理流程设计(Processing Flow Design)录入数据Insert Data餐费入账Meals Evidencing消费入账Consumption Evidencing p_customerinfor 表p_customerinfor Table录入数据Insert DataFamily member 表Family member Table图 3.19 处理流程设计图3.3.3 模块界面设计(Module Interface Design)Y选择账单类型Choose bill type查询Query是否打印查询Query打印PrintN图
23、 3.18 补打账单算法流程图酒店管理系统详细设计The Program Design Report of Hotel Management System21餐饮管理模块界面如下：3.3.4 局部数据结构(Local Data Structure)MySQLConnectionString:StringMySQL:stringMyConnection: SqlConnectionMyAdapter: SqlDataAdapterMyRoomTable: DataTableMyColumn: DataColumnMyGuestTable: DataTableMyRow: DataRowMyID:
24、longMyMaxID:StringI:int3.3.5 算法设计(Algorithm Design)(1)登记旅客用餐信息(Registration Passenger Dining Information)图 3.21 登记旅客消费信息界面图 3.20 登记旅客用餐信息界面22否 no是 yes选择信息Select the information 对旅客用餐信息进行添加、打印Add, print passengers dining information 旅客用餐信息添加成功add passengers dining information successfully 输入金额Input a
25、mount 对旅客用餐信息进行保存Save passengers dining information 是否要保存？Judge whether building information is legal(2)登记旅客消费信息(Registration Tourist Consumer Information)否 no是 yes选择信息Select the information 对旅客消费信息进行添加、打印Add, print passengers consumer information 旅客消费信息添加成功add passengers consumer information succes
26、sfully 输入名称、单价、折扣价格、数量Input name, unit price, price, quantity discount 对旅客消费信息进行保存Save passengers consumer information 是否要保存？Judge whether building information is legal3.4 查询管理模块(Inquires the Management Module)(M4)( 姚婷婷)3.4.1 模块描述(Module Described)查询管理包括入住旅客信息查询、客房入住状态查询、物品消耗信息查询、物品消耗总汇查询、押金消费信息查询。查
27、看客房、物品、押金信息，是把客图 3.22 登记旅客用餐信息算法设计图图 3.23 登记旅客用餐信息算法设计图酒店管理系统详细设计The Program Design Report of Hotel Management System23房、物品、押金的基本信息从数据库中提取出来显示在界面上并且可以打印信息；修改客房信息，是根据入住客房的客人姓名修改信息，所以除了入住客房的客人姓名以外其它信息均可修改和打印；而物品信息只能查询和打印，不能进行修改。Enquiry management including check-in passenger information query, guest r
28、oom occupancy status query, goods consumption information query, goods consumption eleven-headed aspect query, deposit consumption information query. View rooms, items, deposit information, is the guest room, articles, the deposit of the basic information from a database extracted displayed in the i
29、nterface and can print information; Modify rooms information is according to the guest room occupancy name modify information, so in addition to check-in room of the guests name other than information all can modify and print, And items of information query and print, not only amendment. 3.4.2 处理流程设
30、计(Processing Flow Design)查询信息Inquires date查询信息Inquires date录入、查询数据Entry,inquires the data 入住旅客信息Check-in passenger information 客房入住状态Guest room occupancy state 物品消耗信息Item cost information 物品消耗总汇Items consumed eleven-headed aspect p_customerinfor 表p_customerinfor Table查询信息Inquires data查询信息Inquires da
31、tafamilymember 表familymember Tablep_customerinfor 表p_customerinfor Tablesuiteinfor 表suiteinfor Table押金消费信息Deposit consumer information suiteinfor 表suiteinfor Table3.4.3 模块界面设计(Module Interface Design)查询管理模块界面如下：图 3.24 处理流程设计图243.4.4 局部数据结构(Local Data Structure)MyConnection:SqlConnectionMyGoodsTable:
32、 DataTable图 3.26 查询商品分类消耗信息界面图 3.25 酒店房态界面图 3.27 查询商品分类消耗信息界面 图 3.28 查询商品汇总消耗信息界面图 3.29 查询当前未结账旅客押金信息界面酒店管理系统详细设计The Program Design Report of Hotel Management System25MySQL:stringMyCommand: SqlCommandMyGuestTable: DataTableMyRow:DataRowMyCells:ObjectMyExcel:ApplicationClassMyWorkBooks:WorkbooksMyWorkBook:WorkbookMyWorkSheet:WorksheetMyColumns:charMyRange:RangeMyData: Object,MyNewColumn:DataColumnMyAdapter:SqlDataAdapterCount, i, j:int3.4.5 算法设计(Algorithm Design)(1)查询修改入住旅客信息(Inquires Modify Check-in Passenger Information)
