酒店管理系统详细设计报告

1、酒店管理系统详细设计报告酒店管理系统 详细设计 The Program Design Report of Hotel Management System拟制人荧火虫项目组 审核 人批准人二零一零年十一月三十日目目录录1引言引言 INTRODUCTIONS.1 1.1 编写目的 PURPOSES1 1.2 背 景 PROJECT BACKGROUND 21.3 参考资料REFERENCES3 2 系统的结构系统的结构 SYSTEM STRUCTURE/ 2.1 总体结构 GENERAL STRUCTURE/ 2.2 运行环境 RUNNING ENVIRONMENT6 2.2.1 硬件要求 The

2、 hardware requirements6 2.2.2 软 件要求 Software requirements6 2.3 系统架构 SYSTEM ARCHITECTURE .6 3 模块设计模块设计SYSTEM OVERVIEW.7 3.1登录模块LOGIN MODULEM1.7 3.1.1 登陆描述 Login Description.7 3.1.2 处理流程设计 Processing Flow Design.7 3.1.3 输入输由 与算法逻辑 Input/output and Arithmetic Logic8 3.1.4 模块界 面设计 Module Interface Desig

3、n 8 3.1.5 局部数据结构 Local Data Structure 9 3.1.6 用户权 限设计 User Permissions Design9 3.2 客房管理 ROOM MANAGEMENTM2 .103.2.1模 块描述 Module Described.10 3.2.2 处理流 程设计 Processing Flow Design.11 3.2.3 模块界面设计 Module Interface Design 11 3.2.4 局部数据结构 Local Data Structure 13 3.2.5 算法设计说明 Algorithm Design Descriptions

4、14 3.3餐饮管理模块 RESTAURANT MANAGEMENT MODULEM320 3.3.1 模块才苗述 Module Described.20 3.3.2 处 理流程设计 Processing Flow Design.20 3.3.3模块界面设计 Module Interface Design 20 3.3.4 局部数据结构 Local Data Structure 21 3.3.5 算法设计 Algorithm Design21 3.4 查询管 理模块 INQUIRES THE MANAGEMENT MODULEM422 3.4.1模块描述Module Described.22

5、3.4.2处理流程设计Processing Flow Design.23 3.4.3 模块界面设计 Module Interface Design 23 3.4.4 局部数据结构 Local Data Structure 24 3.4.5算法设计 Algorithm Design25 3.5报表管理模块 STATEMENTS MANAGEMENT MODULEM5.26 3.5.1 模块 描述 Module Described.26 3.5.2 处理流程设计 Processing Flow Design.27 3.5.3 模块界面设计 Module Interface Design 27 3.

6、5.4 局部数据结构 Local Data Structure 28 3.5.5 算法设 计 Algorithm Design29 3.6 系统管理 SYSTEM MANAGEMENTM6 31 3.6.1 模块才苗述 Module Described.31 3.6.2处理流程设计Process design32 3.6.3模块界面设计Module interface design .32 3.6.4 局部数据结构 Local data structure34 3.6.5 算法设计说明 Algorithm design descriptions34 4 数据库设计数据库设计 DATABASE

7、DESIGN.37 5 接口接 口 INTERFACE42 5.1 调用级接口CALL LEVEL INTERFACE42 5.2 对象接口 OBJECTINTERFACE .43 5.3 外部接口 EXTERNAL INTERFACE435.4内部接口 INTERNAL INTERFACE .44 6测试计戈测试 计划 TESTING PLAN .44 6.1 测试要点 MAIN POINTS.44 6.2 酒店管理系统测试 SYSTEM TESTING.45 1引言引言 Introductions 1081308113 马晨 1.1编写 目的编写目的 Purposes随着计算机技术的日益成

8、熟、普及，现代的企业管 理的实际运作在很多方面，很大程度上都必须借助于计算机来完成，相应软件的开发也就显得尤为重要。在信息高速发展的今天，时间，效率这样的名词正主导 着众的生活和发展，有必要设计开发一个管理信息系统。通过系统功能解决传统管理模式带来的不足，优化酒店管理。Along with the computer technology matures, popularization, the modern enterprise management of practical operation in many ways, to a great extent, all must use com

9、puter 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 development, it is necessary to design and develop a management information system. Through the system f

10、unctions to solve shortcomings arising from traditional management mode, optimizing the hotel management.设计报告论述了分析、开发、设计一个酒店管理系统的过程。该系统融入 酒店科学、规范的现代管理思想，为提高各 业务部门自身的工作效率，自动完成各业务部门之间的各种营业信息、账务、报表的自动化传输与汇总，使各项 工 作制度化，科学化。结合先进的计算机技术，采用C和SQL 2005开发而成。Design report discusses analysis, development, design

11、 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, from various business units of various business information, between accounting, financial statements

12、of automation transmission and summarizing, make each work institutionalization, and scientific. Combining advanced computer technology, using c and SQL 2005 development and into.设计报告介绍了系统的相关的内容，并通过设计分析， 划分数据库，将系 统划分为5个主要功能模块客房管理， 财务管理，信息查询，系统管理，报 表管理。着重叙述了前台管理和系统维护这两个功能的功能实 现，这些模块基本上满足了用户（酒店）在客房管理方

13、面的需求。如对客房、员工的设置修改，相关的顾客服务等。Design reports introduced the system related to the content, and through the design analysis, classified database, the system is divided into five main functional modules room management, financial management, information query, systems management, statements management. T

14、he 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 management needs. As to the guest room, employees modify Settings, related services to the customers. 1.2 背景背景 Pro

15、ject Background 本项目团队 在经过对市场深入细致的分析和研究后，运用计算机技术， 结 合酒店信息管理模式开发了这套酒店管理系统。一个成熟的酒店管理系统不仅仅是记录酒店客人的信息，提供查询，报表打印等一系列简单的工作，它能让 工 作人员从烦琐的手工操作中解脱，并且酒店管理系统本身就 代表着一种管理方法。随着它的深入，将带动企业的运做，为管理和决策提供 支持。使用该酒店管理系统，将会有以下好处 1电脑收银，打 印账单快速准确，减少宾客等待时间，并可杜绝收银过程中的舞弊现象。2高效的客房管理能有效的提高房率，增加营业收入。3提高决策依据管理者可以随时了解经营情况，以制定相应的经营方针

16、。4减轻员工的工作负担从而使员工把更多的精力放在提 高为宾客服务的质量上。5简单、方便地保存和查询历史资料。6树立良好的酒店形象。待开发系统的名称酒店管理系统；开发者萤火虫项目组；预期用户中小型酒店。This project team after 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 h

17、otel management system is not only records hotel guests'information, provide inquiry, printand so on a series of simple 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 enterpris

18、e operation, management and decision support. Use the hotel management system, will have the following advantages 1Computer cashier, print bill fast and accurate, reduce guests waiting time, and can eliminate the cashier process of fraud phenomenon. 2Efficient room management can effectively improve

19、 the room rate, increase revenues. 3Improve decision basis managers can understand operating situation, to formulate the corresponding management policy. 4Reduce employee s work burden so that employees more focus on improving the quality of the service for the guest.5Simple and easy to preserve and

20、 inquires the historical data. 6Set a good hotel image. For development system name hotel management system, 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, accordi

21、ng to room number, name, time, food and beverage category and the save add records to the database, and print information. 3.3.2处理流程设计Processing Flow Design 录入数据Insert Data餐费入账 Meals Evidencing 消 费入账 Consumption Evidencing p_customerinfor 表 p_customerinfor Table 录入数据InsertData Family member 表 Family

22、 member Table 图 3.19 处理 流程设计图 3.3.3模块界面设计 Module Interface Design Y 选择账单类型Choose bill type查询 Query是否打印 查询Query打印Print N图3.18补打账单算法流程图餐饮管理模块界面如下3.3.4局部数据结构Local Data StructureMySQLConnectionStringString MySQLstring MyConnectionSqlConnection MyAdapter SqlDataAdapter MyRoomTableDataTable MyColumn DataC

23、olumn MyGuestTable DataTable MyRow DataRow MylDlong MyMaxIDString lint 3.3.5 算法 设计 Algorithm Design 1登记旅客用餐信息RegistrationPassenger Dining Information 图3.21登记旅客消费信息界 面 图3.20登记旅客用餐信息界面否no是yes选择信息Select the information 对旅客用餐信息进行添加、打印 Add, print passenger' s dining information 旅客用餐信息添力口 成功 add passe

24、nger s dining information successfully 输入金 额Input amount对旅客用餐信息进行保存Save passengers dining information 是否 要保存 Judge whether building information is legal 2 登记旅客消费信息 Registration Tourist Consumer Information 否 no 是 yes 选择信息Select theinformation对旅客消费信息进行添加、打印 Add, print passenger s consumer information

25、 旅客消费信息添力口成功 add passenger s consumer information successfully 输入名称、 单价、 折扣价格、 数量 Input name, unit price, price, quantity discount对旅客消费信息进行保存 Save passenger' s consumer information 是否要保存Judge whether buildinginformation is legal 3.4查询管理模块查询管理模块Inquiresthe Management ModuleM4 1081308133 姚婷婷 3.4.1

26、 模块 描述Module Described查询管理包括入住旅客信息查询、客房入住状态查询、物品消耗信息查询、物品消耗总汇查询、押金消费信息查询。查看客房、物品、押金信息，是把客 图3.22登记旅客 用餐信息算法设计图图3.23登记旅客用餐信息算法设计图 房、物品、押金的基本信息从数据库中提取由来显示在 界面上并且可以打印信息；修改客房信息，是根据入住客房的客人姓名修改信息，所以除了入住客房的客人姓名以外其它信息均可修改和打印；而物品信息只能查询和打印， 不能进行修改。Enquirymanagement including check-in passengerinformation query

27、, guest room occupancy status query, goods consumptioninformationquery,goods consumptioneleven-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

28、the interface 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 guest s name other than information all can modify and print, And items of information query and print, not only amendment. 3.4.2

29、 处理流程设计 Processing Flow Design 查 询信息 Inquires date 查询信息 Inquires date 录入、查询数据 Entry,inquires the data 入住旅客信息 Check-in passengerinformation 客房入住状态Guest room occupancy state 物品消耗信息Item cost information 物品消耗总汇 Items consumed eleven-headed aspectp_customerinfor 表p_customerinfor Table 查询信 息 Inquires data

30、 查询信 息 Inquires data familymember 表familymember Tablep_customerinfor 表 p_customerinfor Table suiteinfor 表 suiteinfor Table 押金消费信息 Deposit consumer information suiteinfor 表 suiteinfor Table 3.4.3 模块界面设计ModuleInterface Design查询管理模块界面如下图3.24处理流程设计图 3.4.4 局部数据结构 Local Data Structure MyConnectionSqlConne

31、ction MyGoodsTable DataTable 图 3.26查询商品分类消耗信息界面图3.25酒店房态界面 图3.27查询商品分类消耗信息界面图3.28查询商品汇总消耗信息界面 图3.29查询当前未结账旅客押金信息界面MySQLstring MyCommand SqlCommand MyGuestTable DataTableMyRowDataRowMyCellsObject口MyExcelApplicationClassMyWorkBooksWorkbooksMyWorkBookWorkbookMyWorkSheetWorksheetMyColumnschar MyRangeRan

32、ge MyData Object口 MyNewColumnDataColumn MyAdapterSqlDataAdapter Count, i, jint 3.4.5算法设计 Algorithm Design 1查询修改入住旅客 信息 Inquires Modify Check-in Passenger Information 输入客人姓名 Input the guest s name入住旅客信息修改成功 modify Check-in passenger' s information successfully 查询客 人信息 Inquires the guest informati

33、on 修改客人信H、Modifythe guest's information 对客人信息进行保存Save the guest's information 判断客人姓名是否正确Judge the guest s nameis correct 是 yes 是否要保存客人信息Whether to preservethe guest information 是 yes 否 no 否 no 结束 End 2 查询 商 品分类消耗信息 Classification of Goods Consumption Information 选择日期、商品名称Select the date, nam

34、e ofcommodity 打ER商品消耗信息Print commodity consumptioninformation 查询 商品消 耗信息 Inquires the commodity consumption information 判断商品名称是否正确Judge nameof commodity is correct 是 yes 否 no 3 查询商品,总?匚7肖耗信 息 Commodity Eleven-Headed Aspect Consumption Information 图3.30查询修改入住旅客信息算法设计图图3.31查询商品分类消耗信息算法设计图选择日期 Select t

35、he date打E喻品消耗信息Print commodity consumption information查询商 品 7肖耗信 H、 Inquires the commodity consumption information图3.32查询商品总汇消耗信息算法设计图4当前未结账旅客 押金信息 Bill Not Currently Passengers Deposit Information 选择日期 Select the date 查询当前未结 账旅客 押金信 息 Inquires the commodity consumptioninformation图3.33查询当前未结账旅客押金信息算

36、法设 计图 3.5报表管理模块报表管理模块Statements Management ModuleM5 1081308104 陈赛花 3.5.1 模块描述 Module Described报表管理包括客房入住报表、客房餐费报 表、客房消费报表、客房结帐汇总表。客房入住报表模块主要是根据日期把顾客住房消费的信 息从数据库中提取由来显示在界面上并打印由来；客房餐费报表模块主要是根据日期把顾客入住后就餐消费的信息从数据库中提取由来显示在界面上并打印由来；客房消费 报表模块主要是根据日期把顾客入住后的其他物品消费信 息从数据库中提取由来显示在界面上并打印由来；客房结账汇总表模块主要是根据日期把客入住房

37、间及就餐和其他物品的消费信息从数据库中提取由来显示在界面上并打印 由来。Statements consists room occupancy statements, guest room meals statements, guest room consumer reports, guest room checkout summary form. Guest room occupancy statements module mainly is based on the date of the customer housing consumption extracted from databas

38、e information displayed on the screen and printed, Guest room meals statements module mainly is according to the customer check-in date after the information from the database repast consumptionextracted displayed on screen and printed, Guest room consumer reports module mainly is according to the c

39、ustomer check-in date after other items of information from a database of consumption extracted displayed on screen and printed, Guest check summary module mainly is according to the guest room and check-in date repast and other items from a database of consumption information extracted displayed on

40、 screen and printed. 3.5.2 处理流程设计 Processing Flow Design 查询、打 ER数据 Inquires, print the data 查询、 打E3数据 Inquires, print the data查询、打印数据Inquires, print the data 查询、打印数据 Inquires, print the data 客房入住报表Guest roomoccupancy statements 客房餐 费报表 Guest room meals statements 客房消费报表 Guest room consumer reports 客

41、房 结账汇总表 Guest check summary form p_customerinfor 表 p_customerinfor Table familymember 表 familymember Table suiteinfor 表 suiteinfor Table p_customerinfor 表 p_customerinfor Table图3.34处理流程设计图3.5.3模块界面设计 Module Interface Design 报表管理界面设计图如下 Statements management interface design is as follows 子模块 名称 The

42、son module name 界面设计图名称 Interface blueprints name 客房入住报表 Guest room occupancy statements图 3.33 入住旅客登 记信息界面 Figure 3.33check-in passenger registration information interface 客房餐费 报表 Guest room meals statements图3.34入住旅客餐费信 息 界 面 Figure 3.34 check-in passenger meals information interface 客房消费报表 Guest ro

43、om consumer reports 图 3.35 入住旅客店内消费信息界面Figure 3.35 check-in passengerin-store consumer information interface 客 房结帐 汇总表 Guest room checkout summary form 图 3.36 入住旅客结账 信 息 界 面 Figure 3.36 check-in passenger check-out information interface表3-10报表管理界面设计总览表 3.5.4 局部数 据结构 Local Data Structure MySQLConnect

44、ionStringStringMyConnectionSqlConnectionMySQLstringMyAdapterSqlDataAdapterMyExcelApplicationClassMyWorkBooksWorkbooksMyWorkBookWorkbookMyWorkSheetWorksheetMyColumnschar MyRangeRange MyDataObject口图 3.35 入住旅客登记信息界面图3.36入住旅客餐费信息界面图3.37入住旅客店内消费信息界面图3.38入住旅客结账信息界面 MyNewColumnDataColumn Count,i,jint 3.5.5

45、 算法设 计 Algorithm Design 1 入住旅客登记信息 Check-in Passenger' s Registration Information 选择开始和2束日期Select Start and end dates是yes是yes否 No开始日期是否大于结束 日期 Start date is greater than the ending date 查询该时间段内入住旅客信息Check the interval at check-in passenger sinformation 是否打印 Whether print打印该时间段内入住旅 客信息 Print this

46、 period check-in passenger ' s information 结 束End否No图3.39入住旅客登记信息算法设计图2人住旅客餐费信息 Check-in Passenger' s Meals Information 选 择开始和结束日期Select Start and end dates否no开始日期是否大于结束日期Start date is greater than the ending date是yes查询该时间段内入住旅客就餐信息 Check the interval at check-in passenger ' s repast inf

47、ormation 是否打E3 Whether print是yes打印该时间段内入住旅客就餐信息 Print this period check-in passenger' s repast information 否 no 结束End图3.40入住旅客餐费信息算法设计图3入住旅客店内消费信息Check-in passenger' s In-store ConsumerInformation 选择开始和结束日期Select Start and end dates查询该时间段内入住旅客其他物品信息Check the interval atcheck-in passenger'

48、;s other information 否 No 是 yes 开始日 期是否大于结束日期Start date is greater than the ending date是否打印 Whether print是yes打印该时间段内入住旅客其 他物品信息 Print this period check-in passenger' s other information 结束 End否No图3.41入住旅客店内消费信 息算法设计图4入住旅客结账信息Check-in Passenger sCheck-out Information 是yes查询该时间段内入住旅客所有消费信息 Check t

49、he interval at check-in passenger s all information 否no选择开始和结束日期Select Start and enddates开始日期是否大于结束日期Start date is greater thanthe ending date是否打印 Whether print是yes打印该时间 段内 入住旅客所有消 费信息 Print this period check-in passenger s all information 结束 End 否 no 3.6 系统管理系 统管理System ManagementM6图3.42入住旅客结账信息 算法

50、设计图1081308139庄涛 3.6.1模 块描述 Module Described系统管理一共由六个小模块组成操作权限设置, 修改用户密码，酒店信息设置，酒店客房设置，消费物品设置，系统帮助信息。操作权限设置可以设置操作员的权限，入住登记，换房登记，退房登记等等。修改用户密码，提供修改密码的服务，根据旧密码，输入新密码，再确认新密码，然后修改密码。酒店信息设置，可以浏览连锁酒店信息并对其进行添 加，修改，删除，保存操 作。酒店客房设置，可以浏览酒店内所有客房的信息，并对 其房号，类别，楼 层，房价等信息的修改，添加，删除， 保存操作。消费物品设置，可以浏览酒店内所有消费品的信息，并对其名称

51、，单价，单位，类别，产地等信息的修改，添加，删除，保存的操作。系统帮助设置，显示本系统的版权信息，酒店的联 系方 式。System management was by six small modules operating permissions Settings, modify user password, hotel information Settings, hotel rooms Settings, consumption goods Settings, the system helps the information. Operating permission Settings ca

52、n set operator permissions, hotel check-in and check-out, move rooms registration, etc. Modify user password, provide cipher amending the services, according to old password, enter a new password, reconfirm new password, and modify the password. Hotel information Settings, can browse chains tore hot

53、el information and carries on the add, edit, and delete, save operation. Hotel rooms Settings, can browse the hotel in all rooms of information, and the room number, category, floors, prices of the information such as modification, add, delete, save operation. Consumer goods Settings, can browse the

54、 hotel all consumer information, and its name, unit price, the unit, categories, origin of the information such as modification, add, delete, save operation. The system helps Settings, showed the system of copyright information, the hotel s contact information.3.6.2处理流程设计 Process design处理流程如图Process

55、ing flow as shown in figure 3.6.3 模块界面设计 Module interfacedesign 模块界面设计如下Module interface designs are asfollows 子模块名称 The son module name界面设计图名称 Interface blueprints name 操作权限设置 Operating permission Settings (M6.1) 图3.43操作权限设置界面图 Figure 3.43 track operation permission Settings interface diagram 修改用户

56、密码 Modify user password ( M6.2 ) 图 3.44 修改用户密码 界面图 Figure 3.44 rainfall distribution modify user password interface diagram 酒店信息设置Hotel information setM6.3图3.45酒店信息设置界面图 Figure 3.45 hotel information set interface diagram 酒店客房设置Hotel rooms setM6.4 图3.46 酒店客房设置界面图Figure 3.46 radar echoes capturedhote

57、l rooms set interface diagram 消费物品设置 Consumer goods SettingsM6.5 图 3.47消费物品设置界面图 Figure 3.47 consumption items set interface diagram 系统帮助信H、 The system helps informationM6.6 图 3.48 系统帮助信息界 面图 Figure 3.48system help information interface diagram 添 加权限、信息、客房设置 Add Permission > Information Room、 Set

58、tings修改各项设置Modify all Settings更新各项设置Renew all Settings 添加消费物品设置Add Consumer goodsSettings酒店房 间表 Hotel Rooms Table 操作用户表 Operation User Table 消费物品表 Consumption Items Table数据录入Insert Data数据录入Insert Data数据录入Insert Data数据录入Insert Data图3.43系统管理模块处理流程 图表3-11模块界面设计总览表3.6.4局部数据结构Localdata structure MySQLConnectionString String MyConnection SqlConnectionChangeUserPasswordForm.es MyCommand SqlCommand 3.6.5 算法设计说明 Algorithm design descriptions图3.45修改用户密码界面图图 3.44操作权限 设置界面