宾馆客房管理信息系统的设计与实现
（表2.1 系统设计目标）
| 主要模块 | 功能描述 |
| 系统管理 | 用户只有使用密码登陆后。才能使用系统的功能。用户登陆后可以添加管理员。 |
| 客房管理 | 可以查看所有的客房信息，包括（房间号、类型、级别、费用），进行添加、删除、和修改。 |
| 入住管理 | 可以查看当前客房的入住信息。 |
| 退房管理 | 可以进行退房操作。 |
| 客房查询 | 可以根据各种查询条件对客房进行查询。查询条件包括，客房的房间号、类型、级别、费用和入住情况等。 |
| 房客查询 | 可以查询当前入住的房客信息。查询条件包括，姓名、身份证号。 |
| 效益查询 | 可以查询一定时间内的收入情况。 |
| 报表打印 | 可以打印当前所有客房的信息。 |
Hotel Room Management Information System Design and Implementation of
Abstract
The twenty-first century is the era of information technology, the computer has been applied to all walks of life. Use of computer information management technology, can effectively reduce the cost of enterprise management, improve internal efficiency.
In this paper, daily hotel room room management in general and the starting process to design a hotel room every day, management information systems, which can manage the daily hotel room all the rooms of the information, you can easily add, modify or delete. Passenger check-in and check-out are available through a simple operation is complete. Also can easily query, the query including guest rooms, fees, benefits and so on. Finally, you can also right hotel room every day, room information report output.
In this paper, Visual Basic 6.0 development tools as a front, using Microsoft SQL SERVER 2000 as back-end database, using Adodc as the database access control to media. This paper discusses the system design ideas, the main tools and design methods. Then described in detail the database design, system modular design and interface design, the last of the system description is given for each specific module.
The system is running stable, and numerous tests and modifications, has been able to achieve practical application level.
Key words: Visual Basic 6.0, ADO, MIS, management of hotel rooms
Abstract
The 21th century is a century of information. The usage of computer has varied from many fields. With the computer Manage information system, one company can efficiently reduce cost for management, and promote the efficiency inside the company.
This article embarked daily from the guesthouse guest room guest room management general flow, has designed a set of daily guesthouses guestrooms management information system, it was allowed to manage daily in the guesthouse guest room all guest rooms information, was allowed to facilitate increase, revision , deletion. The passenger enters and returns a house all may complete through the simple operation. Also may carry on the convenience the inquiry, the inquiry content including the guest room, the charge, the benefit and so on. Finally, but also may carry on the report form output daily to the guest houseguest room guest room information.
This article uses Visual Basic 6.0 to do for the onstage development kit, uses Microsoft SQL SERVER 2,000 to do is the backstage database, uses Adodc to control the achievement database visit the medium. This article mainly elaborated the system design mentality, main tool and design method. Afterwards in detail introduced the database design, the system module design and the contact surface design, finally have produced showing to system each concrete module. This system movement is stable, passes through the various test and the revision, already was allowed to achieve the practical application the level.
Key word: Visual Basic 6.0, ADO, MIS, guesthouse guest room management
Summary . I
Abstract .. II
1. . 1 Introduction
1.1 Development Background . 1
1.2 The Significance of Management Information Systems . 2
1.3 The main work of this . 2
二. Analysis . 3
2.1 System design goals . 3
2.2 Feasibility Analysis . 4
2.2.1 Technical feasibility 4
2.2.2 Feasibility of time 5
2.2.3 economic feasibility 5
2.2.4 Operation Feasibility 5
三. System Design . 6
3.1 The system function module design . 6
3.2 System flowchart . 7
四. The main tools and implementation technology . 9
4.1 Visual Basic 6.0 .. 9
4.2 ADO Database Access Technology . 10
4.3 VB Database Access Technology . 12
4.4 Modular Design . 13
五. Detailed design . 14
5.1 Database Design . 14
5.1.1 E-R diagram design 14
5.1.2 Database relational table design 16
5.2 system features modular design . 19
5.3 User Interface Design . 20
5.4 Database Access Function . 20
六. System function modules to achieve . 22
6.1 login module . 22
6.2 The main interface . 22
6.3 User Management . 24
6.4 users to add / modify . 25
6.5 Room Information . 26
6.6 Room information changes . 27
6.7 Guest Information . 28
6.8 Guest Information Edit Form . 28
6.9 Check-out Information Form . 29
Check out the information changes form 6.10 . 30
6.11 Room Information Query Form . 30
6.12 fee Information Query Form . 31
6.13 Efficiency Information Query Form . 32
(Figure 6.13-effectiveness of information query form). 32
6.14 Report Output Form . 32
7. Postscript . 34
Reference: 35
Thanks . 37
1. Introduction
1.1 Development Background
Modern society is information society. With the computer network technology, database technology, management, technology development, information processing and use of already deep into all aspects of human life.
The 21st century, global economic integration, businesses will face more intense competition in the market. Scientific management, electronic, network of corporate necessity. Success or failure of the relationship between the implementation of the enterprise''s survival and development.
As China''s rapid socio-economic development and the deepening of reform and opening up, all kinds of state-owned enterprises, the private sector is growing in size, strength has been improving, data, information processing and demand is increasing. Use computers to manage information collection, processing, handling and delivery, enterprise management has become an indispensable means and tools to build a comprehensive integrated, information technology, network-based enterprise management information system, is now extremely urgent. A modern standard computer information network completed, will undoubtedly make the efficiency of enterprises has leapt to a new level.
Hotel room industry in the world, hailed as a sunrise industry, never weak. In China, the hotel room to foster the cultivation of industry in the country, is working on developing an unprecedented rate. With the hotel room industry booming and China''s entering WTO, the influx of foreign travel companies, the market competition is fierce. In this environment, the traditional mode of operation of hotel rooms has been unable to adapt to the rapid development of today''s market. Want to dominate the market in the competition, lock customers, and only by accelerating the internal management of information technology, electronic construction, improve efficiency, reduce operating costs, thereby enhancing the competitiveness of enterprises.
1.2 Significance of Management Information System
Management information system is MIS (Management Information System), in the emphasis on management, emphasizing information in today''s society it is becoming increasingly popular, more and more important. Management Information System (MIS) research began in the 20th century, 70''s, goal is to business managers to use computer-based information systems. Management information system will be computer science, management science, operations research and systems connected to the establishment and application in these disciplines form the basis of information collection, processing, handling and delivery methods, to form an intertwined system.
1.3 The main work of this article
This according to daily hotel room management of the requirements and business processes, established a highly information-based and integrated into daily hotel room management system. Computer technology, database technology, workflow technology, focused on the use of them. Synthesis achieved, including the system log, room management, occupancy management, check-out management, and effectiveness of customer query, reporting, printing and other features.
This paper introduces the idea of the detailed design of the system, introducing the main development tools and enabling technologies. And to do all the functional modules are described.
二. Analysis
Software requirements analysis software life cycle an important step. It is only through needs analysis to the software functionality and performance of the overall concept described as a specific software requirements specification, thereby laying the foundation for software development. Software requirements analysis work is also a constant awareness and gradual refinement process. The research phase of the process of software requirements analysis and design information, so that progressively refine the software to the definition of the extent of detail and analyze all kinds of different software elements, and then these elements to find workable solutions.
2.1 System design goals
The system for management of daily hotel room room design, mainly in order to achieve management of daily hotel room room. The main functions such as Table 2.1:
(Table 2.1 System Design Goals)
Main modules
Functional Description
System Management
Only after landing a user using a password. In order to use the system functions. After making landfall, the user can add an administrator.
Housekeeping
You can view all of the guest rooms, including (room number, types, levels, costs), to add, delete, and modify.
Check Management
You can view the current information on room occupancy.
Check-out management
Can check-out operation.
Room Search
Query can be based on a variety of rooms to search. Query include room room number, type, level, cost and availability and so on.
Tenant Search
Can search for information on the current occupancy of the tenant. Query, including, name, ID number.
Efficiency Query
Can query the income within a certain period of time.
Report Print
You can print all current room information.
2.2 Feasibility Analysis
Before doing requirements analysis, do first a feasibility study.
① economic viability, namely, cost-benefit analysis, systems development from an economic point of view to determine whether the "viable."
② technical feasibility, that is, the technical risk assessment, from the developer''s technical strength, work based on complexity of the problem and so proceed to determine system development time, cost and other restrictions under the possibility of success.
③ time the feasibility of determining system development can be completed within the stipulated time, can meet user''s needs.
④ the choice of operation, namely, to determine system development can meet the simple requirements of users.
2.2.1 Technical feasibility
Daily hotel room management information system works is through the user interface to the user''s actions into a store the background information and data related to database operations, then the relevant results of operations will be returned to the user. Taking into account the nature of the application, this system uses stand-alone editions has been able to meet the requirements in the database, in order to save money to customers, I have chosen the database is SQL SERVER 2000, this is because the SQL SERVER 2000 has a good generality and the reliability of the database is only convenient to keep in a file backup, and have to meet the information management requirements. In the development of language, I use the Visual Basic as a front-end application development tools, it is because Visual Basic as a visual RAD programming tool with easy to learn, flexible and convenient, easy to expand and develop the characteristics of the rapid. It can be with the back-end SQL SERVER 2000 database, ADO through the built-in combination to achieve a rapid and efficient solution.
2.2.2 Time Feasibility
The whole system itself is not very large, not too many technical difficulties, using VB6.0 to develop, should not have any difficulties and risks. Taking into account there are already many similar management software in actual operation, so I will be them as a reference, to learn from their good design ideas, and further expand its development of ideas. On graduation design two month period will be basically completed system design from system analysis to all aspects of the work in time is feasible.
2.2.3 Economic Feasibility
Daily hotel room management information system itself is not a direct result of cost-effective. However, its application can save human resource consumption and waste, thereby saving costs, improve efficiency, the role it plays is also very significant. In addition the system uses the SQL SERVER 2000 database, so apart from the application other than royalties, customers no longer need to pay other expenses to further protect the customer''s interests.
2.2.4 Operation Feasibility
Daily Hotel Room Management Information System is based on VB 6.0 platform developed. Visual Basic is Microsoft''s launch of a widely used tool for database development, its treatment of a small database has an unparalleled advantage. In addition, it generates the interface is also very easy to use, it is consistent with the standard windows program, with simple, easy to use and so on. So operational aspects are feasible.
三. Design
3.1 System Function Module Design
The system is divided into system modules, room management module, the occupancy management functions, check-out management, room check function, the guests information query module, benefits information query, reporting capabilities. Function of each module are as follows:
System modules:
Provide sign-on, and verify the user''s legitimacy;
Rooms Management Module:
Room information to add, modify rooms information, delete the room information;
Check-management features:
Check the information to add, modify arrival information, delete the occupancy information;
Check-out management features:
Check-out information to add, modify, check-out information, delete the check information;
Room inquiry function:
Press room number, grade, type, status of the guest rooms to search;
Guest information query functions:
By guest name, identity card number check guests;
Efficiency Information Inquiry:
Time to check every day, according to the profitability of hotel rooms;
Report Features:
Room information can output reports.
Figure 3.1 Functional structure diagram for the system
