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

namespace?BLL
{
????public?class?HotelUserBLL
????{
????????///?

????????///?查詢HotelUser表中的數據
????????///?

????????///?HotelUserEntity泛型集合
????????public?static?List?GetHotelUser（）
????????{
????????????return?HotelUserDAL.GetHotelUser（）;
????????}

????????public?static?DataTable?GetHotelUserByUserID（int?UserID）
????????{
????????????return?HotelUserDAL.GetHotelUserByUserID（UserID）;
????????}

????????public?static?DataTable?GetHotelUserByUserName（string?UserName）
????????{
????????????return?HotelUserDAL.GetHotelUserByUserName（UserName）;
????????}

????????public?static?DataTable?GetHotelUserByName（string?Name）
????????{
????????????return?HotelUserDAL.GetHotelUserByName（Name）;
????????}
????????public?static?int?GetUserIDByUserName（string?UserName）
????????{
????????????return?HotelUserDAL.GetUserIDByUserName（UserName）;
????????}


????????///?

????????///?登錄驗證
????????///?

????????///?
????????///?
????????public?static?string?ExistUser（HotelUserEntity?HUE）
????????{
????????????DataTable?dt?=?HotelUserDAL.ExistUser（HUE）;
????????????if?（dt?!=?null?&&?Convert.ToInt32（dt.Rows[0][0]）?>?0）
????????????{
????????????????return?“成功“;
????????????}
????????????else
????????????{
????????????????return?“失敗“;
????????????}
????????}

????????public?static?HotelUserEntity?GetUserInfoByUserName（string?UserName）
????????{
????????????return?HotelUserDAL.GetUserInfoByUserName（UserName）;
????????}

????????public?static?int?GetCountUserName（string?UserName）
????????{
????????????return?HotelUserDAL.GetCountUserName（UserName）;
????????}


????????///?

????????///?增加HotelUser表中的數據
????????///?

????????///?HotelUserEntity對象
????????///?返回結果：
????????///??????????1???執行SQL語句成功
????????///?????????-1???SQL語句執行錯誤
????????///?????????-2???數據庫連接失敗
????????///?
????????public?static?int?AddHotelUser（HotelUserEntity?HUE）
????????{
????????????return?HotelUserDAL.AddHotelUser（HUE）;
????????}

????????///?

????????///?修改HotelUser表中的數據
????????///?

????????///?HotelUserEntity對象
????????///?返回結果：
????????///??????????1???執行SQL語句成功
????????///?????????-1???SQL語句執行錯誤
????????///?????????-2???數據庫連接失敗
????????///?
????????public?static?int?UpdateHotelUser（HotelUserEntity?HUE）
????????{
????????????return?HotelUserDAL.UpdateHotelUser（HUE）;
????????}

????????public?static?int?UpdateStatusByUserName（int?Status?string?UserNamestring?SessionName）
????????{
????????????return?HotelUserDAL.UpdateStatusByUserName（Status?UserNameSessionName）;
????????}

????????public?static?int?ChangePwd（HotelUserEntity?

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

?????文件??????49152??2008-08-21?09:05??酒店管理系統說明書\Hotel.doc

????..A.SH.??????5120??2008-08-21?09:16??酒店管理系統說明書\Thumbs.db

?????文件??????28040??2008-06-26?10:56??酒店管理系統說明書\類圖.jpg

?????文件??????91648??2008-08-21?09:04??酒店管理系統說明書\網頁布局.doc

?????文件??????45056??2008-08-21?09:04??酒店管理系統說明書\酒店管理系統需求文檔.doc

?????目錄??????????0??2008-08-21?09:16??酒店管理系統說明書

?????文件???????2952??2008-08-21?09:18??51aspx源碼必讀.txt

?????文件???????4945??2007-07-18?09:38??from.gif

?????文件???????5578??2008-07-18?14:41??Solution_Hotel.sln

?????文件??????28040??2008-06-26?10:56??類圖.jpg

?????文件????????125??2007-03-27?14:33??最新Asp.Net源碼下載.url

?????文件???????8704??2008-08-21?09:00??BLL\bin\Debug\BLL.dll

?????文件??????46592??2008-08-21?09:00??BLL\bin\Debug\BLL.pdb

?????文件??????19968??2008-08-21?09:00??BLL\bin\Debug\DAL.dll

?????文件??????56832??2008-08-21?09:00??BLL\bin\Debug\DAL.pdb

?????文件???????7680??2008-08-21?08:59??BLL\bin\Debug\Entity.dll

?????文件??????36352??2008-08-21?08:59??BLL\bin\Debug\Entity.pdb

?????目錄??????????0??2008-07-27?12:35??BLL\bin\Debug

?????目錄??????????0??2008-07-25?08:20??BLL\bin

?????文件???????3023??2008-07-26?23:12??BLL\BLL.csproj

?????文件???????3929??2008-07-26?23:43??BLL\HotelUserBLL.cs

?????文件????????475??2008-07-26?23:12??BLL\MessageBLL.cs

?????文件???????2757??2008-08-21?08:59??BLL\obj\Debug\BLL.csproj.FileListAbsolute.txt

?????文件???????8704??2008-08-21?09:00??BLL\obj\Debug\BLL.dll

?????文件??????46592??2008-08-21?09:00??BLL\obj\Debug\BLL.pdb

?????文件???????5632??2008-07-27?16:02??BLL\obj\Debug\Refactor\BLL.dll

?????目錄??????????0??2008-07-26?10:01??BLL\obj\Debug\Refactor

?????文件??????13344??2008-08-21?09:00??BLL\obj\Debug\ResolveAssemblyReference.cache

?????目錄??????????0??2008-07-25?08:20??BLL\obj\Debug\TempPE

?????目錄??????????0??2008-08-21?09:00??BLL\obj\Debug

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