计1084-6-FF-概要设计报告(V1.0)

1、酒店管理系统概要设计The System Design Report of Hotel Management System拟 制 人 荧火虫工程组 审 核 人 批 准 人 二零一零年十一月三十日目录 TOC o 1-3 u 1 引言(Introduction) PAGEREF _Toc278888434 h 11.1 编写的目的(The Goal of Writing) PAGEREF _Toc278888435 h 11.2 背景说明(Background) PAGEREF _Toc278888436 h 11.3 定义(Definition) PAGEREF _Toc278888437 h

2、 21.4 参考文献(Reference Material)： PAGEREF _Toc278888438 h 22 总体设计(The Overall Design) PAGEREF _Toc278888439 h 32.1 系统说明(System Instructions) PAGEREF _Toc278888440 h 32.2 系统任务(System Tasks) PAGEREF _Toc278888441 h 32.2.1 系统目标(System Target) PAGEREF _Toc278888442 h 32.2.2 运行环境(Running Environment) PAGER

3、EF _Toc278888443 h 32.3 需求规定(Demand Requirements) PAGEREF _Toc278888444 h 42.3.1 功能需求(Functional Requirements) PAGEREF _Toc278888445 h 42.3.2 性能需求Performance Requirements PAGEREF _Toc278888446 h 52.4 模块构造框图(Module structure diagram) PAGEREF _Toc278888447 h 62.4.1 登录模块 PAGEREF _Toc278888448 h 7客房管理模块

4、(Room Management Module) PAGEREF _Toc278888449 h 72.4.3 餐饮管理模块(Restaurant Management Module) PAGEREF _Toc278888450 h 72.4.4 查询管理模块(Enquiry Management Module) PAGEREF _Toc278888451 h 72.4.5 报表管理模块(Statements Management Module) PAGEREF _Toc278888452 h 82.4.6 系统管理模块(System Management Module) PAGEREF _T

5、oc278888453 h 83 模块功能描述Module Functional Description PAGEREF _Toc278888454 h 83.1 主界面(Main Interface) PAGEREF _Toc278888455 h 83.2 登录模块(Login Module) PAGEREF _Toc278888456 h 93.2.1 登陆概述(Login Overview) PAGEREF _Toc278888457 h 9登陆权限(Login Permission) PAGEREF _Toc278888458 h 93.3 餐饮管理模块(Restaurant Man

6、agement Module) PAGEREF _Toc278888459 h 93.4 客房管理模块(Room Management Module) PAGEREF _Toc278888460 h 113.5 查询管理模块(Query Management Module) PAGEREF _Toc278888461 h 143.6 报表管理模块(Report Management Module) PAGEREF _Toc278888462 h 153.7 系统管理模块(System Management Module) PAGEREF _Toc278888463 h 174 接口设计Inte

7、rface Design PAGEREF _Toc278888464 h 194.1 用户接口User Interface PAGEREF _Toc278888465 h 194.2 外部接口(External Interface) PAGEREF _Toc278888466 h 194.3 内部接口(Internal Interface) PAGEREF _Toc278888467 h 205 运行设计(Operating Design) PAGEREF _Toc278888468 h 205.1 运行模块组合(Run Module Combination) PAGEREF _Toc2788

8、88469 h 205.2 运行控制(Running Control) PAGEREF _Toc278888470 h 205.3 运行时间(Running Time) PAGEREF _Toc278888471 h 216 数据库构造设计(Database Structure Design) PAGEREF _Toc278888472 h 216.1 数据库管理模块(Database Management Module) PAGEREF _Toc278888473 h 216.2 表的定义(Table Definitions) PAGEREF _Toc278888474 h 227 系统出错

9、设计System Error Design PAGEREF _Toc278888475 h 277.1 出错信息Error Messages PAGEREF _Toc278888476 h 277.2 补救措施(Remedial Measures) PAGEREF _Toc278888477 h 281 引言(Introduction)(1081308104 陈赛花) 编写的目的(The Goal of Writing)酒店管理系统是为提高酒店各部门管理人员的工作效率而开发的。系统让各部门管理人员能够更方便地处理酒店事务的进程，到达更高的效率。Hotel Management System i

10、s developed to improve the working efficiency of the hotel staff of various departments. System allows management of various departments can more easily deal with the process of hotel services, to achieve higher efficiency.概要设计说明书是在需求分析的根底上，对系统的设计考虑进展概要说明，包括系统的根本处理流程，总体设计，各模块的功能描述及数据库构造设计，为系统的详细设计奠定

11、根底。编写概要设计说明书的目的是能准确无误地用计算机处理过程来表达用户的各项要求，以此作为详细设计的纲领性的文件。其主要任务是通过对用户需求进展综合、归纳与抽象。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 data

12、base structure design, make the basic for the systems detailed design. 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

13、 and abstraction through user needs. 背景说明(Background)a. 系统名称：酒店管理系统System Name: Hotel Management System显示对应的拉丁字符的拼字典 - HYPERLINK 酒店管理系统是为提高酒店各部门管理人员的工作效率而开发的。系统让各部门管理人员能够更方便地处理酒店事务的进程，到达更高的效率&langpair=zh|en 查看字典详细内容b. 系统提出者：萤火虫工程小组 System proponent：Fire Fly Project Teamc. 系统开发者：萤火虫工程小组The developer

14、of the system: Fire Fly Project Teamd. 系统用户：酒店各部门人员System User: various departments management 定义(Definition)用于存取数据以及查询、更新和管理关系数据库系统。SQL (Structured Query Language): is a database query and programming language ,is used to access the data and query, update and manage a relational database system.数据库

15、构造设计(Database Structure Design)：指数据库中各个 HYPERLINK 表构造的关系，包括信息保存在哪些表格中、各个表的构造如何以及各个表之间的关系。Database design (Database Structure Design): refers to the structure of each table in the database relations, including what form that information stored in, how the structure of each table, and the relationship

16、 between the various tables. 参考文献(Reference Material)：朗读显示对应的拉丁字符的拼音1 张海藩软件工程第五版北京：清华大学出版社，20212 刘金岭，冯万利，张有东等编著数据库原理及应用北京：清华大学出版社，20213 肖汉软件工程理论与实践第一版北京：科学出版社，20064 周涛，吕伟臣，廉颖SQL Server 2000数据库企业级应用北京：清华大学出版社20215，Mike Hotek(美)SQL Server 2000数据库效劳器架构设计北京：清华大学出版社20076 肖金秀，何鹏，周柏伟，黄元隆北京：冶金工业出版社，2 总体设计(T

17、he Overall Design) 系统说明(System Instructions)任务提出单位：淮阴工学院计算机工程学院计算机1084-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 Col

18、lege of Huaiyin Institute of Technology.预期用户：酒店管理员Expected users: hotel managers. 系统任务(System Tasks) 系统目标(System Target)1各部门通过自己不同权限来登陆个人界面；Each department through their own individual rights to land personal interface;2对客户信息进展全面管理；Comprehensive management of customer information;3通过系统管理员对原有数据进展添加、修

19、改和删除；The original data through the system administrator to add, modify and delete;4各部门管理员登录后能对其界面进展管理各种信息。Each department manager can manage all kinds of information after registering for its interface. 运行环境(Running Environment)效劳器端(Server-side)：数据库(Database)：SQL Server 2005；操作系统(Operating System)：M

20、icrosoft Windows XP及以上操作系统。其它：根据用户数量和计算机安装情况配置一定数量的打印机。Other: according to the number of users and computer installation configuration a certain number of printers. 需求规定(Demand Requirements) 功能需求(Functional Requirements)系统具有如下根本功能：System has the following basic functions:登录模块：各部门管理员可以通过系统管理员所分配的账号和密

21、码登陆，从而进入到不同的界面，但系统管理员可以进入主界面。假设各部门管理员想要修改密码或忘记密码，应找系统管理员来处理。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 want

22、s to modify the password or forgotten 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.餐饮管理模块：由于在高档

23、次的酒店内，餐饮管理方面还是比拟小的，主要是客户在住宿时吃早餐、中餐、晚餐。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

24、. check the status of projects, daily management of hotel operations.报表管理模块：财务管理主要是处理酒店的日常的账务报表，有收入报表、消费报表、酒店总表、人事工资报表，Financial management mainly deal with daily accounting statements hotel, income statement, consumer reports, hotel overall table, personnel salary statements,系统管理模块：系统应该在用户应有的权限下，尽量

25、提供操作的灵活性，应该让录入/修改人员方便地对整个酒店员工的数据库信息进展管理，让领导层能完成员工的考勤审批操作。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 leadership to complete the s

26、taff attendance approval operation. 性能需求Performance Requirements在给定本钱、进度的前提下，开发出的软件具有可修改性、有效性、可靠性、可理解性、可维护性并满足用户需求的软件产品。以提高软件产品的质量和开发效率，减少维护的困难。At a given cost, under the premise of progress, the developed software has modify, validity, reliability, understandability, maintainability and software pr

27、oducts 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 failure caused by concept, design and s

28、tructure 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 modify the system without increasing t

29、he 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)可理解性。系统具有清晰的构造，能直接反映问题的需求。可理解性有助于控制软件系统的复杂性，并支持软件的维护、移植或重用。Understa

30、ndability: 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)可维护性。软件产品交付用户使用后，能够对它进展修改，以便改正潜伏的错误，改良性能和其他属性，使软件产品适应环境的变化。Maintainability: after delivery

31、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.(1081308133 姚婷婷)酒店管理系统Hotel Management System客房管理Room Management餐饮管理Restaurant Management查询管理Enquiry Management报表管理Stateme

32、nts 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话费入帐Telephone charge in account消费入帐Consume in account入住旅客信息Check-in passenger Information客房入

33、住状态Guest room occupancy State物品消耗信息Item cost Information物品消耗汇总Items consumed Summary押金消费信息Deposit consumer Information客房入住报表Guest room occupancy Statements客房餐费报表Guest room meals Statements客房话费报表Guest room fee Statements客房结帐汇总表Guest room checkout Summary form操作权限设置Operating permission Settings修改用户密码M

34、odify user Password酒店信息设置Hotel information Set酒店客房设置Hotel rooms Set消费物品设置Consumer goods Settings系统帮助信息The system helps Information 模块构造框图(Module structure diagram)图 酒店管理系统主模块图2.4.1 登录模块登陆模块的构造图如下列图2.2所示。Login management module structure diagram as shown in Figure 2.2.登录Login用户名User name密码Password图2.

35、2 登陆模块构造图2.4.2客房管理模块(Room Management Module)客房管理模块的构造图如下列图2.3所示。Room management module structure diagram as shown in Figure 2.3.入住登记Registration换房登记Move rooms Registration退房登记Check-out Registration预订房间Booking Rooms预订入住Reservation Check-in补交押金Fill the Deposit补打帐单Fill the Bill客房管理Room Management图2.3 客

36、房管理模块构造图2.4.3 餐饮管理模块(Restaurant Management Module)餐饮管理模块构造框图如下列图2.4所示。Restaurant management module structure diagram as shown in Figure 2.4.餐费入帐Meal charge in account话费入帐Telephone charge in account消费入帐Consume in account餐饮管理RestaurantManagement图2.4 餐饮管理模块构造图2.4.4 查询管理模块(Enquiry Management Module)查询管理

37、模块构造框图如下列图2.5所示。Enquiry management module structure diagram as shown in Figure 2.5.入住旅客信息Check-in passenger Information客房入住状态Guest room occupancy State物品消耗信息Item cost Information物品消耗汇总Items consumed Summary押金消费信息Deposit consumer Information查询管理Enquiry Management图2.5 查询管理模块构造图2.4.5 报表管理模块(Statements

38、Management Module)报表管理模块构造框图如下列图2.6所示。Statements management module structure diagram as shown in Figure 2.6.报表管理Statements Management客房入住报表Guest room occupancy Statements客房餐费报表Guest room meals Statements客房话费报表Guest room fee Statements客房结帐汇总表Guest room checkout Summary form图2.6 报表管理模块构造图2.4.6 系统管理模块(

39、System Management Module)系统管理模块构造框图如下列图2.7所示。System management module structure diagram as shown in Figure 2.7.系统管理System Management操作权限设置Operating permission Settings修改用户密码Modify user Password酒店信息设置Hotel information Set酒店客房设置Hotel rooms Set消费物品设置Consumer goods Settings系统帮助信息The system helps Informa

40、tion图2.7 系统管理模块构造图3 模块功能描述Module Functional Description(1081308136 张小娟)3.1 主界面(Main Interface)除了系统管理员所进入的主界面是一个完整的主界面，其它各部门管理员所进入的界面仅是自己管理局部的界面，这是由于系统管理员设置好了的权限。主界面是：In addition to the system administrator to enter the main interface is a complete main interface, and other departments into the admin

41、istrator interface is only part of their management interface, which is good because the system administrator to set permissions. The main interface is:图 酒店管理系统主界面3.2 登录模块(Login Module)朗读 登陆概述(Login Overview)此模块分为系统管理员登陆和各部门管理员登陆。系统管理员的账号、姓名和密码由系统初始化，各部门管理员的登陆信息由系统管理员添加、修改和删除。This module divides int

42、o administrator login and owner login. Administrator login divides into super administrator 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 admin

43、istrator. The owner login must be login after register by owner according to the information of the owner.3.2.2登陆权限(Login Permission)系统管理员登陆成功后，可对系统的所有后台进展管理。各部门管理员登录成功后，除去系统管理权限，可管理其它所分配管理员端的后台模块。After super administrator login, super administrator could manager the background of the system. And af

44、ter normal administrator login, they can manager the background of administrator but the permission of system management.3.3 餐饮管理模块(Restaurant Management Module)餐饮模块主要实现以下功能：Restaurant module achieves the following functions:(1) 餐饮管理人员只需根据系统管理员所分配的账号和密码来登陆。餐饮模块内只包括一个餐饮入账。Restaurant management staff

45、only according to the system administrator account and password. Restaurant module 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

46、type, amount and used in the instructions. (3) 新增旅客用餐信息，并且保存后，旅客用餐信息将出现在下方的列表框内。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

47、Name (automatic display)用餐时间 Dining Time 用餐类别 Dining Types用餐金额 Dining Amount相关说明 Referent Instruction处理(Treatment)：新增add保存save打印print输出(Output)：将会提示：检查登记是否正确，是否确定保存，一旦保存将无法修改。Will be prompted to: Check the registration is correct, whether to save, if saved will not be modified3.4 客房管理模块(Room Managem

48、ent Module)客房实现的主要功能如下：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 registrati

49、on, the 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

50、deposits, 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)：将会提示：检查登记是否正确，是否确定保存，一旦保存将无法修改。Wil

51、l 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)：打

52、印print保存save输出(Output)：结账信息保存 Save the checkout information.预定登记(Booking Register)：输入(Input)：房号、预收押金、入住日期、离开日期、客人姓名、住宿人数、客人性别、联系 、操作人员、预定编号。Room number, advance deposits, arrival date, departure date, guest name, the number of stay, guests of gender, telephone number, and the operator is scheduled n

53、umber.处理(Treatment)：新增、保存、打印add, save, print 输出(Output)：将会提示：检查登记是否正确，是否确定保存，一旦保存将无法修改。Will be prompted to: Check the registration is correct, whether to save, if saved will not be modified.预订入住(Reservation Check)：输入(Input)：房号、折扣价格、预收押金、入住日期、离开日期、客人姓名、证件名称、证件号码、证件地址、住宿人数、客人性别、联系 、操作人员、入住编号。 Room num

54、ber, discount prices, advance deposits, arrival date, departure date, guest name, document name, document number, document addresses, the number of stay, guests of gender, telephone number, the operator, the occupancy number.处理(Treatment)：新增、保存、打印 Add, save, print输出(Output)：将会提示：检查登记是否正确，是否确定保存，一旦保存

55、将无法修改。Will be prompted to: Check the registration is correct, whether to save, if saved will not be modified补交押金(Pay deposit)：输入(Input)：酒店房号、旅客姓名、已经发生的费用、押金补交信息。 Hotel room number, passenger name, has been the costs incurred, pay the deposit information.处理(Treatment)： 打印、保存print, save输出(Output)：当您为旅

56、客打印押金单后，必须保存该操作，是否继续。When you print the deposit receipt for the visitors, must save the operation, whether to continue.打印帐单(Print Billing)：输入(Input)：帐单类型、酒店房号、客人姓名 Billing type, hotel room number, guest name处理(Treatment)：查询、打印query, print输出(Output)：查询后信息将出现在旅客结账单的列表里。Inquiry, the information will ap

57、pear in the list of passengers in a single checkout.话费报表(Report Calls)：输入(Input)：开场日期、完毕日期Start date, end date.处理(Treatment)： 查询、打印 query, print输出(Output)：查询后信息将出现在旅客结账单的列表里。Inquiry, the information will appear in the list of passengers in a single checkout.3.5 查询管理模块(Query Management Module)(108130

58、8104 陈赛花)查询模块所实现的功能有：Query module function can be achieved:入住旅客信息查询 Stay at the passenger information Enquiry客户入住状态查询 Customer Check Status Inquiry物品消耗信息查询 Consumption of information query items物品消耗汇总查询 Consumption goods aggregate query押金消费信息查询 Deposit consumer information search入住旅客信息查询(Stay at the

59、 passenger information Enquiry)：输入(Input)：任选你所清楚的一个或几个信息Choose your clear one or more information处理(Treatment)：查询、保存 Query, Save输出(Output)：所有符合查询条件的信息显示在下面的列表框内。The information that matches the query appears in the list box below.客房入住状态查询(Customer Check Status Inquiry)：输入(Input)：无输入 No input处理(Treat

60、ment)：无处理 no treatment输出(Output)：无输出 no output物品消耗信息查询(Consumption of information query items)：输入(Input)：开场日期、完毕日期、商品名称 start date, end date, product name处理(Treatment)：查询、打印 Query, print输出(Output)：所有符合查询条件的信息显示在下面的列表框内。The information that matches the query appears in the list box below.物品消耗汇总查询(con