using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?System.Data;
using?System.Configuration;
using?System.Windows.Forms;

using?MySql.Data.MySqlClient;
using?System.xml;
using?MySql.Data;


namespace?HotelManagementSystem
{
????public?class?DbManager
????{
????????public?static?string?login_id?=?““;//定義全局變量，記錄當前登錄的用戶編號??
????????public?static?string?login_name?=?““;//定義全局變量，記錄當前登錄的用戶名??
????????public?static?string?login_passwd?=?““;??//密碼
????????public?static?int?power?=?0;
????????public?static?string?identy?=?““;
????????public?static?int?dprices?=?100;???//單人房單價
????????public?static?int?hprices?=?0;???//豪華單人房單價
????????public?static?int?sprices?=?0;???//商務雙人房單價
????????public?static?int?gprices?=?0;???//高級大床房單價
????????public?static?int?tprices?=?0;???//特色大床房單價

????????public?static?MySqlConnection?conn;//定義一個MySqlConnection類型的公共變量conn，用于判斷數據庫是否連接成功??
????????public?static?string?sqlcon?=?“server=47.106.90.110;database=hoteldatabase;user?id=root@zzj;pwd=aaa333...;CharSet=utf8“;

????????#region?建立數據庫連接
????????///?
??
????????///?建立數據庫連接??
????????///?
??
????????///???
????????public?static?MySqlConnection?GetConn（）
????????{
????????????conn?=?new?MySqlConnection（sqlcon）;
????????????conn.Open（）;
????????????return?conn;
????????}
????????#endregion

????????#region?關閉數據庫
????????///?
??
????????///?關閉數據庫??
????????///?
??
????????public?void?CloseConn（）
????????{
????????????if?（conn.State?==?ConnectionState.Open）???//判斷是否打開與數據庫的連接??
????????????{
????????????????conn.Close（）;???//關閉數據庫的連接??
????????????????conn.Dispose（）;???//釋放My_con變量的所有空間??
????????????}
????????}
????????#endregion

????????#region??讀取指定表中的信息
????????///?
??
????????///?讀取指定表中的信息.??
????????///?
??
????????///?SQL語句??
????????///?返回bool型??
????????public?MySqlDataReader?GetComand（string?sqlStr）
????????{
????????????GetConn（）;???//打開與數據庫的連接??
????????????MySqlCommand?comand?=?conn.CreateCommand（）;//創建一個SqlCommand對象，用于執行SQL語句??
????????????comand.CommandText?=?sqlStr;????//獲取指定的SQL語句??
????????????MySqlDataReader?myRead?=?comand.ExecuteReader（）;?//執行SQL語名句，生成一個MySqlDataReader對象??
????????????return?myRead;
????????}
????????#endregion

????????#region?執行MySqlCommand命令
????????///?
??
????????///?執行SqlCommand??
????????///?
??
????????///?SQL語句??
????????public?void?GetSqlCom（string?sqlStr）
????????{
????????????GetConn（）;???//打開與數據庫的連接??
????????????MySqlCommand?sqlCom?=?new?MySqlCommand（sqlStr?conn）;?//創建一個MySqlCommand對象，用于執行SQL語句??
????????????sqlCom.ExecuteNonQuery（）;???//執行SQL語句??
????????????sqlCom.Dispose（）;???//釋放所有空間??
????????????CloseConn（）;????//調用con_close（）方法，關閉與數據庫的連接??
????????}
????????#endregion

????????#region??創建DataSet對象
????????///?
??
????????//

?屬性????????????大小?????日期????時間???名稱
-----------?---------??----------?-----??----

????.CA....???????222??2018-05-17?20:08??HotelManagementSystem\.vs\HotelManagementSystem\DesignTimeBuild\.dtbcache

????.CA..H.????152576??2019-01-04?21:49??HotelManagementSystem\.vs\HotelManagementSystem\v15\.suo

????.CA....?????????0??2018-05-17?19:03??HotelManagementSystem\.vs\HotelManagementSystem\v15\Server\sqlite3\db.lock

????.CA....??????4096??2018-05-17?19:03??HotelManagementSystem\.vs\HotelManagementSystem\v15\Server\sqlite3\storage.ide

????.CA....?????32768??2019-01-04?21:47??HotelManagementSystem\.vs\HotelManagementSystem\v15\Server\sqlite3\storage.ide-shm

????.CA....???1301952??2019-01-04?21:49??HotelManagementSystem\.vs\HotelManagementSystem\v15\Server\sqlite3\storage.ide-wal

????.CA....???6493743??2018-04-17?11:33??HotelManagementSystem\Database1\Database1.dbmdl

????.CA....??????3368??2018-04-17?11:32??HotelManagementSystem\Database1\Database1.sqlproj

????.CA....???????144??2018-04-17?11:32??HotelManagementSystem\Database1\Database1.sqlproj.user

????.CA....??????3108??2018-04-30?10:46??HotelManagementSystem\HotelManagementSystem\3.lrc

????.CA....????250044??2018-04-28?19:40??HotelManagementSystem\HotelManagementSystem\3.wav

????.CA....???????187??2018-04-14?00:02??HotelManagementSystem\HotelManagementSystem\App.config

????.CA....????250044??2018-04-28?19:35??HotelManagementSystem\HotelManagementSystem\bin\Debug\3.wav

????.CA....?????53760??2018-04-28?19:39??HotelManagementSystem\HotelManagementSystem\bin\Debug\AxInterop.WMPLib.dll

????.CA....???3693283??2018-05-02?22:14??HotelManagementSystem\HotelManagementSystem\bin\Debug\Debug.rar

????.CA....???1888768??2018-07-26?19:32??HotelManagementSystem\HotelManagementSystem\bin\Debug\HotelManagementSystem.exe

????.CA....???????187??2018-04-14?00:02??HotelManagementSystem\HotelManagementSystem\bin\Debug\HotelManagementSystem.exe.config

????.CA....????239104??2018-07-26?19:32??HotelManagementSystem\HotelManagementSystem\bin\Debug\HotelManagementSystem.pdb

????.CA....?????23168??2018-05-04?17:28??HotelManagementSystem\HotelManagementSystem\bin\Debug\HotelManagementSystem.vshost.exe

????.CA....???????187??2018-04-14?00:02??HotelManagementSystem\HotelManagementSystem\bin\Debug\HotelManagementSystem.vshost.exe.config

????.CA....???????490??2015-07-10?19:01??HotelManagementSystem\HotelManagementSystem\bin\Debug\HotelManagementSystem.vshost.exe.manifest

????.CA....????330752??2018-05-17?19:03??HotelManagementSystem\HotelManagementSystem\bin\Debug\Interop.WMPLib.dll

????.CA....?????49168??2012-09-26?03:16??HotelManagementSystem\HotelManagementSystem\bin\Debug\Microsoft.CSharp.dll

????.CA....???1550200??2014-06-02?21:12??HotelManagementSystem\HotelManagementSystem\bin\Debug\Microsoft.Office.Interop.Excel.dll

????.CA....?????63336??2014-06-02?21:12??HotelManagementSystem\HotelManagementSystem\bin\Debug\Microsoft.Vbe.Interop.dll

????.CA....????294912??2013-05-22?17:21??HotelManagementSystem\HotelManagementSystem\bin\Debug\MySql.Data.dll

????.CA....????448360??2014-06-02?21:12??HotelManagementSystem\HotelManagementSystem\bin\Debug\office.dll

????.CA....?????32392??2018-05-16?23:53??HotelManagementSystem\HotelManagementSystem\bin\Debug\stdole.dll

????.CA....?????27192??2012-09-26?03:16??HotelManagementSystem\HotelManagementSystem\bin\Debug\System.Data.DataSetExtensions.dll

????.CA....???1164272??2012-09-26?03:16??HotelManagementSystem\HotelManagementSystem\bin\Debug\System.Data.dll

............此處省略210個文件信息