using?System;
using?System.Collections.Generic;
using?System.Linq;
using?System.Text;
using?DAL;
using?System.Data;


namespace?BLL
{
????public?class?BLL_Hotel
????{


????????//操作員登錄
????????public?static?DataTable?OP_login（string?name?string?pwd）
????????{
????????????return?DAL_Hotel.OPlogin（namepwd）;
????????}

????????//用戶登錄

????????public?static?DataTable?User_Login（string?name?string?pwd）
????????{
????????????return?DAL_Hotel.UserLogin（namepwd）;

????????}

????????//入住信息查詢

????????public?static?DataTable?Live_Mark（）?{
????????????return?DAL_Hotel.LiveMark（）;
????????}

????????//刪除入住信息記錄表

????????public?static?int?Del_Record（int?idd）?{
????????????return?DAL_Hotel.DelRecord（idd）;
????????}

????????//查詢所有顧客信息
????????public?static?DataTable?Cha_Cus（）?{
????????????return?DAL_Hotel.ChaCus（）;
????????
????????}

????????//圖標方式展示房間信息
????????public?static?DataTable?Img_Table（）?{
????????????return?DAL_Hotel.imgtable（）;
????????}



????????//根據(jù)顧客編號查詢信息
????????public?static?DataTable?Cha_Gid（string?gid）
????????{
????????????return?DAL_Hotel.Cha_Gid（gid）;

????????}

????????//根據(jù)房間編號查詢信息
????????public?static?DataTable?Cha_Roomid（string?roomid）
????????{
????????????return?DAL_Hotel.Cha_Roomid（roomid）;
????????}

????????//根據(jù)顧客姓名查詢信息
????????public?static?DataTable?Cha_Gname（string?gname）
????????{
????????????return?DAL_Hotel.Cha_Gname（gname）;

????????}


????????//根據(jù)身份證號查詢信息
????????public?static?DataTable?Cha_Idcard（string?idcard）
????????{
????????????return?DAL_Hotel.Cha_Idcard（idcard）;

????????}


????????//根據(jù)手機號查詢信息
????????public?static?DataTable?Cha_Tel（string?tel）
????????{
????????????return?DAL_Hotel.Cha_Tel（tel）;

????????}

????????//根據(jù)入住時間查詢信息
????????public?static?DataTable?Cha_LiveTime（string?livetime）
????????{
????????????return?DAL_Hotel.Cha_LiveTime（livetime）;
???????????

????????}

????????//根據(jù)房間ID查詢房間信息
????????public?static?DataTable?Cha_One（int?idd）
????????{
????????????return?DAL_Hotel.Cha_One（idd）;

????????}

????????//綁定房間類型

????????public?static?DataTable?bind_roomtype（）
????????{
????????????return?DAL_Hotel.bind_roomtype（）;
????????}

????????//綁定未入住的房間編號

????????public?static?DataTable?bind_roominfo（int?idd）
????????{
????????????return?DAL_Hotel.bind_roominfo（idd）?;


????????}

????????//根據(jù)顧客編號查詢該顧客的個人信息

????????public?static?DataTable?Cha_Guestinfo（int?idd）
????????{
????????????return?DAL_Hotel.Cha_Guestinfo（idd）;
????????}

????????//入住登記（入住信息表插入數(shù)據(jù)）
????????public?static?int?Add_Record（int?gid?int?roomid?DateTime?intime?DateTime?outtime?int?day?double?charge）
????????{
????????????return?DAL_Hotel.Add_Record（gidroomidintimeouttimedaycharge）;
????????}

????????//修改房間狀態(tài)
????????public?static?int?Gai_roomstate（int?roomid?int?roomtype）
????????{
????????????return?DAL_Hotel.Gai_roomstate（roomidroomtype）;
????????}

????????public?static?DataTa

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

?????文件??????83486??2018-05-31?10:08??NET酒店旅館賓館管理系統(tǒng)源碼\.vs\config\applicationhost.config

?????文件????????454??2018-05-31?10:09??NET酒店旅館賓館管理系統(tǒng)源碼\.vs\HotelManage\DesignTimeBuild\.dtbcache

????..A..H.?????41472??2018-05-10?21:36??NET酒店旅館賓館管理系統(tǒng)源碼\.vs\HotelManage\v14\.suo

????..A..H.?????67072??2018-05-31?10:09??NET酒店旅館賓館管理系統(tǒng)源碼\.vs\HotelManage\v15\.suo

?????文件??????????0??2018-05-31?10:08??NET酒店旅館賓館管理系統(tǒng)源碼\.vs\HotelManage\v15\Server\sqlite3\db.lock

?????文件???????4096??2018-05-31?10:08??NET酒店旅館賓館管理系統(tǒng)源碼\.vs\HotelManage\v15\Server\sqlite3\storage.ide

?????文件??????32768??2018-05-31?10:08??NET酒店旅館賓館管理系統(tǒng)源碼\.vs\HotelManage\v15\Server\sqlite3\storage.ide-shm

?????文件?????980592??2018-05-31?10:08??NET酒店旅館賓館管理系統(tǒng)源碼\.vs\HotelManage\v15\Server\sqlite3\storage.ide-wal

?????文件???????7168??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\bin\Debug\BLL.dll

?????文件??????26112??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\bin\Debug\BLL.pdb

?????文件??????15872??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\bin\Debug\DAL.dll

?????文件??????32256??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\bin\Debug\DAL.pdb

?????文件???????2494??2015-03-31?09:35??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\BLL.csproj

?????文件???????7408??2015-05-08?00:12??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\BLL_Hotel.cs

?????文件?????????42??2018-05-31?10:08??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\obj\Debug\BLL.csproj.CoreCompileInputs.cache

?????文件??????13347??2016-05-13?10:09??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt

?????文件??????20533??2018-05-31?10:08??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\obj\Debug\BLL.csprojAssemblyReference.cache

?????文件???????5611??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\obj\Debug\BLL.csprojResolveAssemblyReference.cache

?????文件???????7168??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\obj\Debug\BLL.dll

?????文件??????26112??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\obj\Debug\BLL.pdb

?????文件???????6640??2018-05-10?16:47??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\obj\Debug\DesignTimeResolveAssemblyReferencesInput.cache

?????文件???????3263??2015-05-08?21:55??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\obj\Debug\ResolveAssemblyReference.cache

?????文件???????1362??2015-03-31?07:59??NET酒店旅館賓館管理系統(tǒng)源碼\BLL\Properties\AssemblyInfo.cs

?????文件??????15872??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\DAL\bin\Debug\DAL.dll

?????文件??????32256??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\DAL\bin\Debug\DAL.pdb

?????文件???????2336??2015-03-31?09:35??NET酒店旅館賓館管理系統(tǒng)源碼\DAL\DAL.csproj

?????文件??????12081??2015-05-08?00:15??NET酒店旅館賓館管理系統(tǒng)源碼\DAL\DAL_Hotel.cs

?????文件???????1137??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\DAL\DBHelper.cs

?????文件?????????42??2018-05-31?10:08??NET酒店旅館賓館管理系統(tǒng)源碼\DAL\obj\Debug\DAL.csproj.CoreCompileInputs.cache

?????文件???????9727??2016-05-13?10:32??NET酒店旅館賓館管理系統(tǒng)源碼\DAL\obj\Debug\DAL.csproj.FileListAbsolute.txt

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