49 Star 263 Fork 106

易开元 / TopskyHotelManagerSystem

Create your Gitee Account
Explore and code with more than 12 million developers,Free private repositories !:)
Sign up
Clone or Download
Sync branch
Notice: Creating folder will generate an empty file .keep, because not support in Git

Organization Logo.png


star fork

中文文档 | English Document

:exclamation: Important Notice:

Note: The master branch changes with the v2.x version, which significantly differs from the v1.x version. Those interested in the v1.x version can move to the v1.x branch address: https://gitee.com/java-and-net/TopskyHotelManagerSystem/tree/v1.x/

:pray: Open Source Projects Referenced:

  1. Fody—Packs all dlls into an exe application. Fody, MIT License
  2. SQLSugar, the most popular ORM framework in China. SQLSugar, Apache-2.0 License
  3. SunnyUI—SunnyUI.Net, based on C# .Net WinForm open-source control library, tool library, extension library, and multi-page development framework. SunnyUI.Net, GPL3.0 License

:exclamation: Project Description:

  1. When redeveloping this project, please follow the MIT open-source license. The SunnyUI.Net framework uses the GPL3.0 open-source license, and the SQLSugarORM framework uses the Apache2.0 license. Please be sure to include the corresponding statement in the project introduction.

  2. Bugs and comments are welcome!

  3. This system’s 95% of the pages are created based on the SunnyUI.Net control library, hereby specially declared!

  4. Regarding the database script issue, please first go to the database script folder, choose either the MySQL version or PostgreSQL version folder to download the Data and Table files. In the database, execute the Table.sql first, then the Data.sql!

  5. For MySQL and PostgreSQL databases:

     5.1 If the local database is MySQL, please change the Repository inherited by the business logic class in the Application layer to MysqlRepository, and configure the mysqlString constant database connection string in the Common layer’s HttpHelper.
     5.2 If the local database is PostgreSQL, no changes are needed, just configure the pgsqlString constant database connection string in the Common layer’s HttpHelper.

:thought_balloon: Development Purpose:

In today's rapidly developing hotel industry, with the increase in daily hotel work, it has become difficult to handle with manpower alone. Some cumbersome data may also cause some losses to the hotel due to human errors, hence the need for a management software that can assist in the internal management of the hotel.

:mag_right: System Development Environment:

Operating System: Windows 10(x64)

Development Tools: Microsoft Visual Studio 2015 (first version of the system)/Microsoft Visual Studio 2019 (latest version of the system)

Database: Microsoft SQL Server 2008 R2 (used in the earliest version)/MySQL v8.0.22 (highly recommended!)/PostgreSQL13 (highly recommended!)

Database Management Tools: Microsoft SQL Server 2008 R2 Management Studio/Navicat 15

Programming Languages: C# language, T-SQL language

Development Platform: .Net

Development Framework: .Net Framework 4.5.2/.Net Framework 4.6.1 (fully upgraded) —>.Net Framework 4.7.1

Development Technology: .NET WinForm

:open_file_folder: System Structure:

├─ .git
├─ .gitignore
├─ EOM.Client.TopSkyHotelManagerSystem.sln
├─ FodyWeavers.xml
├─ README.md
├─ SYS.Common
├─ SYS.Core
├─ SYS.FormUI
│    ├─ .gitignore
│    ├─ App.config
│    ├─ AppFunction
│    ├─ AppInterface
│    ├─ AppMain
│    ├─ AppUserControls
│    ├─ FodyWeavers.xml
│    ├─ FodyWeavers.xsd
│    ├─ Logo
│    ├─ Program.cs
│    ├─ Properties
│    ├─ Resources
├─ SYS.Library
├─ Database Scripts
├─ Project Screenshots
└─ Project Related Documents

:chart_with_upwards_trend: System Database Relationship Diagram (Generated by PDMAN Software) :loudspeaker:

Database Relationship Diagram

:books: Summary of System Function Modules:

Function Summary
(Front Desk) Room Management Reserve Room Check-in Room Checkout Room Switch Room View Customer Info Modify Room Status
(Front Desk) Customer Management Display Customer Info Search Customer Info Add Customer
(Front Desk) Product Consumption Product List Search Product Info Product Consumption Consumption Info
(Front Desk) Additional Features None
(Back Office) Basic Information Position Type Maintenance Ethnicity Type Maintenance Education Type Maintenance Department Information Maintenance
(Back Office) Financial Information Employee Salary Bills Internal Financial Bills Hotel Profit Situation
(Back Office) Utilities Management Utilities Info
(Back Office) Supervision and Statistics Supervision Department Situation
(Back Office) Room Management Room Status Overview Add New Room
(Back Office) Customer Management Customer Information Management Customer Consumption Bills
Function Summary (Continued)
(Back Office) HR Management Employee Management Announcement Logs Upload Announcement Logs
(Back Office) Material Management Product Management Warehouse Supplies
Employee Operation Logs
System Management Add Administrator Permission Assignment Enable/Disable Administrator

:family: Project Authors:

Original Team: Jackson, Benjamin, Bin, Jonathan

Later Maintenance Team: Easy Open Meta (易开元)

:computer: Project Setup and Deployment:

Download and install Microsoft Visual Studio Professional 2019 or above, unzip the downloaded Zip package, and run the .sln file.

:inbox_tray: Database Setup and Deployment (Local):

The author and development team strongly recommend using the PostgreSQL database. Install the PostgreSQL database and start the service, establish the database through a visualization management tool, and quickly create data tables and import data by opening the .sql format files within the database script folder. Steps (using PostgreSQL database as an example):

1. Link to the PostgreSQL database through a visualization management tool, then create a new database named ‘tshoteldb’.

2. Open the db_file.sql in the database script\PostgreSQL version folder through the visualization management tool for data table creation and data import.

MIT License Copyright (c) 2023 Easy-Open-Meta Permission is hereby granted, free of charge, to any person obtaining a copy of this software and associated documentation files (the "Software"), to deal in the Software without restriction, including without limitation the rights to use, copy, modify, merge, publish, distribute, sublicense, and/or sell copies of the Software, and to permit persons to whom the Software is furnished to do so, subject to the following conditions: The above copyright notice and this permission notice shall be included in all copies or substantial portions of the Software. THE SOFTWARE IS PROVIDED "AS IS", WITHOUT WARRANTY OF ANY KIND, EXPRESS OR IMPLIED, INCLUDING BUT NOT LIMITED TO THE WARRANTIES OF MERCHANTABILITY, FITNESS FOR A PARTICULAR PURPOSE AND NONINFRINGEMENT. IN NO EVENT SHALL THE AUTHORS OR COPYRIGHT HOLDERS BE LIABLE FOR ANY CLAIM, DAMAGES OR OTHER LIABILITY, WHETHER IN AN ACTION OF CONTRACT, TORT OR OTHERWISE, ARISING FROM, OUT OF OR IN CONNECTION WITH THE SOFTWARE OR THE USE OR OTHER DEALINGS IN THE SOFTWARE.


针对中小型酒店设计的管理系统,团队项目,参与者请查看README.md。国际仓库地址见下面↓↓↓ expand collapse

Releases (25)





Load More
can not load any more