1、酒店管理系统概要设计The System Design Report of Hotel Management System拟 制 人 荧火虫项目组 审 核 人 批 准 人 二零一零年十一月三十日目 录1 引言(INTRODUCTION) .11.1 编写的目的(THE GOAL OF WRITING) .11.2 背景说明(BACKGROUND) .11.3 定义(D EFINITION)21.4 参考文献(REFERENCE MATERIAL)： .22 总体设计(THE OVERALL DESIGN) 32.1 系统说明(SYSTEM INSTRUCTIONS) .32.2 系统任务(SY
2、STEM TASKS) 32.2.1 系统目标 (System Target) 32.2.2 运行环境 (Running Environment).32.3 需求规定(DEMAND REQUIREMENTS) 42.3.1 功能需求 (Functional Requirements) .42.3.2 性能需求（ Performance Requirements） 52.4 模块结构框图(MODULE STRUCTURE DIAGRAM) 62.4.1 登录模块 72.4.2 客房管理模块 (Room Management Module) 72.4.3 餐饮管理模块(RESTAURANT MAN
3、AGEMENT MODULE) .72.4.4 查询管理模块(ENQUIRY MANAGEMENT MODULE ) 72.4.5 报表管理模块(STATEMENTS M ANAGEMENT MODULE)82.4.6 系统管理模块(SYSTEM MANAGEMENT MODULE) 83 模块功能描述（MODULE FUNCTIONAL DESCRIPTION） .83.1 主界面(MAIN I NTERFACE) 83.2 登录模块(LOGIN MODULE).93.2.1 登陆概述 (Login Overview).93.2.2 登陆权限 (Login Permission) 93.3
4、餐饮管理模块(RESTAURANT MANAGEMENT MODULE) 93.4 客房管理模块(ROOM MANAGEMENT MODULE) 113.5 查询管理模块(QUERY M ANAGEMENT MODULE).143.6 报表管理模块(REPORT MANAGEMENT MODULE) .153.7 系统管理模块(SYSTEM MANAGEMENT MODULE) .174 接口设计（INTERFACE DESIGN） 194.1 用户接口（USER INTERFACE） 194.2 外部接口(EXTERNAL INTERFACE) 194.3 内部接口(INTERNAL INT
5、ERFACE) .205 运行设计(OPERATING DESIGN) .205.1 运行模块组合(RUN MODULE COMBINATION) 205.2 运行控制(RUNNING CONTROL).205.3 运行时间(RUNNING TIME)216 数据库结构设计(DATABASE STRUCTURE DESIGN) .216.1 数据库管理模块(DATABASE MANAGEMENT MODULE) .216.2 表的定义(TABLE DEFINITIONS) 227 系统出错设计（SYSTEM ERROR DESIGN） 277.1 出错信息（ERROR MESSAGES） 27
6、7.2 补救措施(REMEDIAL MEASURES).28酒店管理系统概要设计The System Design Report of Hotel Management System11 引言(Introduction)( 陈赛花)1.1 编写的目的(The Goal of Writing)酒店管理系统是为提高酒店各部门管理人员的工作效率而开发的。系统让各部门管理人员能够更方便地处理酒店事务的进程，达到更高的效率。Hotel Management System is developed to improve the working efficiency of the hotel staff o
7、f various departments. System allows management of various departments can more easily deal with the process of hotel services, to achieve higher efficiency.概要设计说明书是在需求分析的基础上，对系统的设计考虑进行概要说明，包括系统的基本处理流程，总体设计，各模块的功能描述及数据库结构设计，为系统的详细设计奠定基础。编写概要设计说明书的目的是能准确无误地用计算机处理过程来表达用户的各项要求，以此作为详细设计的纲领性的文件。其主要任务是通过对
8、用户需求进行综合、归纳与抽象。System design instruction is based on the requirement analysis, system design considerations for an overview, including the systems basic processing flow, total design, and functional description of each module and database structure design, make the basic for the systems detailed des
9、ign. The purpose of making the system design instruction is able to express the users requirements process with the computer accurately, as detailed design of the programmatic document. Its main task is having comprehensive, induction and abstraction through user needs. 1.2 背景说明(Background)a. 系统名称：酒
10、店管理系统System Name: Hotel Management System 显示对应的拉丁字符的拼 字典 - 查看字典详细内容b. 系统提出者：萤火虫项目小组 System proponent：Fire Fly Project Teamc. 系统开发者：萤火虫项目小组The developer of the system: Fire Fly Project Teamd. 系统用户：酒店各部门人员System User: various departments management1.3 定义(Definition)用于存取数据以及查询、更新和管理关系数据库系统。SQL (Structu
11、red Query Language): is a database query and programming language ,is used to access the data and query, update and manage a relational database system.数据库结构设计(Database Structure Design)：指数据库中各个表结构的关系，包括信息保存在哪些表格中、各个表的结构如何以及各个表之间的关系。Database design (Database Structure Design): refers to the structur
12、e of each table in the database relations, including what form that information stored in, how the structure of each table, and the relationship between the various tables.1.4 参考文献(Reference Material)：1 张海藩软件工程（第五版） 北京：清华大学出版社，20082 刘金岭，冯万利，张有东等编著数据库原理及应用北京：清华大学出版社，20093 肖汉软件工程理论与实践第一版北京：科学出版社，20064
13、 周涛，吕伟臣，廉颖SQL Server 2000 数据库企业级应用北京：清华大学出版社20085 J.C.Mackin，Mike Hotek(美)SQL Server 2000 数据库服务器架构设计北京：清华大学出版社20076 肖金秀，何鹏，周柏伟，黄元隆ASP.NET 程序设计北京：冶金工业出版社，2004.4酒店管理系统概要设计The System Design Report of Hotel Management System32 总体设计(The Overall Design)2.1 系统说明(System Instructions)任务提出单位：淮阴工学院计算机工程学院计算机 1
14、084-FF 项目组Task put forward unit: Computer 1084-FF project team of Computer Engineering College of Huaiyin Institute of Technology.开发单位：淮阴工学院计算机工程学院计算机 1084FF 项目组Development unit: Computer 1084-FF project team of Computer Engineering College of Huaiyin Institute of Technology.预期用户：酒店管理员Expected users
15、: hotel managers.2.2 系统任务(System Tasks)2.2.1 系统目标(System Target)（1）各部门通过自己不同权限来登陆个人界面；Each department through their own individual rights to land personal interface;（2）对客户信息进行全面管理；Comprehensive management of customer information;（3）通过系统管理员对原有数据进行添加、修改和删除；The original data through the system administ
16、rator to add, modify and delete;（4）各部门管理员登录后能对其界面进行管理各种信息。Each department manager can manage all kinds of information after registering for its interface.2.2.2 运行环境(Running Environment)服务器端(Server-side)：数据库(Database) ：SQL Server 2005；操作系统(Operating System)：Microsoft Windows XP 及以上操作系统。其它：根据用户数量和计算机安
17、装情况配置一定数量的打印机。Other: according to the number of users and computer installation configuration a certain number of printers.2.3 需求规定(Demand Requirements)2.3.1 功能需求(Functional Requirements)系统具有如下基本功能：System has the following basic functions:登录模块：各部门管理员可以通过系统管理员所分配的账号和密码登陆，从而进入到不同的界面，但系统管理员可以进入主界面。若各部门
18、管理员想要修改密码或忘记密码，应找系统管理员来处理。Login module: each department administrator can be assigned account and password by the system administrator, and enter into the different interface, but the system administrator can enter the main interface. If each department manager wants to modify the password or forgot
19、ten passwords, should find the system administrator to handle.客房管理模块：客房管理包括五小块，预订房间，开/退房间，调房，消费记账和续收/退还预付款。Room management including five small pieces, reservations, check in/out, adjustable room, consumption charge and renewal charge/return the deposit.餐饮管理模块：由于在高档次的酒店内，餐饮管理方面还是比较小的，主要是客户在住宿时吃早餐、中餐
20、、晚餐。Catering management module: catering management is still relatively smaller, is mainly to eat breakfast, lunch and dinner when the customer in accommodation.查询管理模块：查询管理子系统，是对餐饮、客房等项目情况的查询，是酒店业务日常管理功能。Query management subsystem, is a food and beverage, rooms, etc. check the status of projects, da
21、ily management of hotel operations.报表管理模块：财务管理主要是处理酒店的日常的账务报表，有收入报表、消费报表、酒店总表、人事工资报表，Financial management mainly deal with daily accounting statements hotel, income statement, consumer reports, hotel overall table, personnel salary statements,系统管理模块：系统应该在用户应有的权限下，尽量提供操作的灵活性，酒店管理系统概要设计The System Desi
22、gn Report of Hotel Management System5应该让录入/修改人员方便地对整个酒店员工的数据库信息进行管理，让领导层能完成员工的考勤审批操作。System should be under the authority of the user should try to provide operational flexibility should be allowed to input / modify the staff of the hotel staff to easily manage the information database to allow the
23、leadership to complete the staff attendance approval operation.2.3.2 性能需求（Performance Requirements ）在给定成本、进度的前提下，开发出的软件具有可修改性、有效性、可靠性、可理解性、可维护性并满足用户需求的软件产品。以提高软件产品的质量和开发效率，减少维护的困难。At a given cost, under the premise of progress, the developed software has modify, validity, reliability, understandabil
24、ity, maintainability and software products to meet customer needs. To improve the quality of software and develop the efficiency, reduce maintenance difficulties.(1) 可靠性。能够防止因概念、设计和结构等方面的不完善造成的软件系统失效，具有挽回因操作不当造成软件系统失效的能力。在软件开发、编码和测试过程中，必须将可靠性放在首要地位。Reliability: it can prevent the software system fai
25、lure caused by concept, design and structure of the imperfect, has the ability of saving software system failure caused by improper operation of salvage. In software development, code, and test process, must put reliability first.(2) 可修改性。容许对系统进行修改而不增加原系统的复杂性。它支持软件的调试与维护。Modifiability: allowed to mo
26、dify the system without increasing the complexity of the original system. It supports software debugging and maintenance.(3) 有效性。软件系统能最有效地利用计算机的时间资源和空间资源。Effectiveness: Software system can make the most efficient use of computer time resources and spatial resources.(4)可理解性。系统具有清晰的结构，能直接反映问题的需求。可理解性有
27、助于控制软件系统的复杂性，并支持软件的维护、移植或重用。Understandability: system has a clear structure, can directly reflect problems needs. Understandability can control the complexity of software system, and support the software maintenance, transplantation or reuse.(5)可维护性。软件产品交付用户使用后，能够对它进行修改，以便改正潜伏的错误，改进性能和其他属性，使软件产品适应环境
28、的变化。Maintainability: after delivery of software products, users can modify it in order to correct latent errors, improve performance and other attributes, so that software product to adapt to environmental changes.( 姚婷婷)2.4 模块结构框图(Module structure diagram)图 2.1 酒店管理系统主模块图酒店管理系统Hotel Management Syste
29、m客房管理Room Management餐饮管理Restaurant Management查询管理Enquiry Management报表管理Statements Management系统管理System Management入住登记 Registration换房登记 Move rooms Registration退房登记 Check-out Registration预订房间 Booking Rooms预订入住 Reservation Check-in补交押金 Fill the Deposit补打帐单 Fill the Bill餐费入帐 Meal charge in account话费入帐 T
30、elephone charge in account消费入帐 Consume in account入住旅客信息 Check-in passenger Information客房入住状态 Guest room occupancy State物品消耗信息 Item cost Information物品消耗汇总 Items consumed Summary押金消费信息 Deposit consumer Information客房入住报表 Guest room occupancy Statements客房餐费报表 Guest room meals Statements客房话费报表 Guest room
31、 fee Statements客房结帐汇总表 Guest room checkout Summary form操作权限设置 Operating permission Settings修改用户密码 Modify user Password酒店信息设置 Hotel information Set酒店客房设置 Hotel rooms Set消费物品设置 Consumer goods Settings系统帮助信息 The system helps Information酒店管理系统概要设计The System Design Report of Hotel Management System72.4.1
32、 登录模块登陆模块的结构图如下图 2.2 所示。Login management module structure diagram as shown in Figure 2.2.图 2.2 登陆模块结构图2.4.2 客房管理模块(Room Management Module)客房管理模块的结构图如下图 2.3 所示。Room management module structure diagram as shown in Figure 2.3.图 2.3 客房管理模块结构图2.4.3 餐饮管理模块(Restaurant Management Module)餐饮管理模块结构框图如下图 2.4 所示
33、。Restaurant management module structure diagram as shown in Figure 2.4.图 2.4 餐饮管理模块结构图2.4.4 查询管理模块(Enquiry Management Module)查询管理模块结构框图如下图 2.5 所示。Enquiry management module structure diagram as shown in Figure 2.5.图 2.5 查询管理模块结构图入住登记 Registration换房登记 Move rooms Registration退房登记 Check-out Registration
34、预订房间 Booking Rooms预订入住 Reservation Check-in补交押金 Fill the Deposit补打帐单 Fill the Bill客房管理Room Management餐费入帐 Meal charge in account话费入帐 Telephone charge in account消费入帐 Consume in account餐饮管理RestaurantManagement入住旅客信息 Check-in passenger Information客房入住状态 Guest room occupancy State物品消耗信息 Item cost Inform
35、ation物品消耗汇总 Items consumed Summary押金消费信息 Deposit consumer Information查询管理Enquiry Management登录Login用户名User name密码Password2.4.5 报表管理模块(Statements Management Module)报表管理模块结构框图如下图 2.6 所示。Statements management module structure diagram as shown in Figure 2.6.图 2.6 报表管理模块结构图2.4.6 系统管理模块(System Management M
36、odule)系统管理模块结构框图如下图 2.7 所示。System management module structure diagram as shown in Figure 2.7.图 2.7 系统管理模块结构图3 模块功能描述（Module Functional Description）( 张小娟)3.1 主界面(Main Interface)除了系统管理员所进入的主界面是一个完整的主界面，其它各部门管理员所进入的界面仅是自己管理部分的界面，这是由于系统管理员设置好了的权限。主界面是：In addition to the system administrator to enter the
37、 main interface is a complete main interface, and other departments into the administrator interface is only part of their management interface, which is good because the system administrator to set permissions. The main interface is:报表管理Statements Management客房入住报表 Guest room occupancy Statements客房餐
38、费报表 Guest room meals Statements客房话费报表 Guest room fee Statements客房结帐汇总表 Guest room checkout Summary form系统管理System Management操作权限设置 Operating permission Settings修改用户密码 Modify user Password酒店信息设置 Hotel information Set酒店客房设置 Hotel rooms Set消费物品设置 Consumer goods Settings系统帮助信息 The system helps Informati
39、on酒店管理系统概要设计The System Design Report of Hotel Management System9图 2.8 酒店管理系统主界面3.2 登录模块(Login Module)3.2.1 登陆概述(Login Overview)此模块分为系统管理员登陆和各部门管理员登陆。系统管理员的账号、姓名和密码由系统初始化，各部门管理员的登陆信息由系统管理员添加、修改和删除。This module divides into administrator login and owner login. Administrator login divides into super adm
40、inistrator login and normal administrator login, the account number, name and password are received by system initialization, and the normal administrators information of login is added, modified, deleted by super administrator. The owner login must be login after register by owner according to the
41、information of the owner.3.2.2 登陆权限(Login Permission)系统管理员登陆成功后，可对系统的所有后台进行管理。各部门管理员登录成功后，除去系统管理权限，可管理其它所分配管理员端的后台模块。After super administrator login, super administrator could manager the background of the system. And after normal administrator login, they can manager the background of administrator
42、 but the permission of system management.3.3 餐饮管理模块(Restaurant Management Module)餐饮模块主要实现以下功能：Restaurant module achieves the following functions:(1) 餐饮管理人员只需根据系统管理员所分配的账号和密码来登陆。餐饮模块内只包括一个餐饮入账。Restaurant management staff only according to the system administrator account and password. Restaurant modu
43、le only includes the food accounted.(2) 在餐费登记列表中会显示旅客的用餐信息，如：所住酒店房号、姓名、用餐时间、用餐类别、所用金额及相关说明。Dining information will display in the list of meals and dining, such as: living in a hotel by the number, name, meal time, meal type, amount and used in the instructions. (3) 新增旅客用餐信息，并且保存后，旅客用餐信息将出现在下方的列表框内。
44、Add new passenger dining information, and saved, the passenger dining information will appear below the list box.登记(Registration)：输入(Input)：酒店房号（用户通过下拉列表选择）Hotel Room Number (user selected drop-down list)旅客姓名（自动显示） Passenger Name (automatic display)用餐时间 Dining Time 用餐类别 Dining Types用餐金额 Dining Amoun
45、t相关说明 Referent Instruction处理(Treatment) ：新增 add保存 save打印 print输出(Output) ：将会提示：检查登记是否正确，是否确定保存，一旦保存将无法修改。Will be prompted to: Check the registration is correct, whether to save, if saved 酒店管理系统概要设计The System Design Report of Hotel Management System11will not be modified3.4 客房管理模块(Room Management Mod
46、ule)客房实现的主要功能如下：Room module achieves the following functions:（1）客房管理人员只需根据系统管理员所分配的帐号和密码来登陆。客房模块内包括入住登记、结账登记、预订登记、预订入住、补交押金、打印帐单。Room managers simply assigned according to the system administrator account and password to login. Rooms included in the registration module, check out the registration, t
47、he registration book, check book, and pay the deposit, print bills.（2）登录之后进入客房界面，可以选择各不同的操作。After logging into the room interface, you can choose the different actions入住登记(Check-in) ：输入(Input)：房号、折扣价格、预收押金、入住日期、离开日期、客人姓名、证件名称、证件号码、证件地址、住宿人数、客人性别、联系电话、操作人员、入住编号。Room number, discount prices, advance d
48、eposits, arrival date, departure date, guest name, document name, document number, document addresses, the number of stay, guests of gender, telephone number, the operator, check number.处理(Treatment) ：可选择房间类别 select room categories新增、保存、打印 add, save, print 输出(Output) ：将会提示：检查登记是否正确，是否确定保存，一旦保存将无法修改。
49、Will be prompted to: Check the registration is correct, whether to save, if saved will not be modified.结账登记(Checkout Register)：输入(Input)：结账日期、房号、旅客姓名、入住日期、折扣价格、已发生的费用、结算信息。Closing date, room number, passenger name, arrival date, discount price, the cost has occurred, billing information.处理(Treatment) ：打印 print保存 save输出(Output) ：结账信息保存 Save the checkout information.预定登记(Booking Register)：输入(Input)：房号、预收押金、入住日期、离开日期、客人姓名、住宿人数、客人性别、联系电话、操作人员、预定编号。Room number, advance deposits, arrival date, departure date, guest name, the number of stay, gue
