1using System;
  2using System.Collections.Generic;
  3using System.Linq;
  4using System.Text;
  5using System.Data;
  6using Entity;
  7using DAL;
  8
  9namespace BLL
 10...{
 11    public class HotelUserBLL
 12    ...{
 13        /**//// <summary>
 14        /// 查询HotelUser表中的数据
 15        /// </summary>
 16        /// <returns>HotelUserEntity泛型集合</returns>
 17        public static List<HotelUserEntity> GetHotelUser()
 18        ...{
 19            return HotelUserDAL.GetHotelUser();
 20        }
 21
 22        public static DataTable GetHotelUserByUserID(int UserID)
 23        ...{
 24            return HotelUserDAL.GetHotelUserByUserID(UserID);
 25        }
 26
 27        public static DataTable GetHotelUserByUserName(string UserName)
 28        ...{
 29            return HotelUserDAL.GetHotelUserByUserName(UserName);
 30        }
 31
 32        public static DataTable GetHotelUserByName(string Name)
 33        ...{
 34            return HotelUserDAL.GetHotelUserByName(Name);
 35        }
 36        public static int GetUserIDByUserName(string UserName)
 37        ...{
 38            return HotelUserDAL.GetUserIDByUserName(UserName);
 39        }
 40
 41
 42        /**//// <summary>
 43        /// 登录验证
 44        /// </summary>
 45        /// <param name="HUE"></param>
 46        /// <returns></returns>
 47        public static string ExistUser(HotelUserEntity HUE)
 48        ...{
 49            DataTable dt = HotelUserDAL.ExistUser(HUE);
 50            if (dt != null && Convert.ToInt32(dt.Rows[0][0]) > 0)
 51            ...{
 52                return "成功";
 53            }
 54            else
 55            ...{
 56                return "失败";
 57            }
 58        }
 59
 60        public static HotelUserEntity GetUserInfoByUserName(string UserName)
 61        ...{
 62            return HotelUserDAL.GetUserInfoByUserName(UserName);
 63        }
 64
 65        public static int GetCountUserName(string UserName)
 66        ...{
 67            return HotelUserDAL.GetCountUserName(UserName);
 68        }
 69
 70
 71        /**//// <summary>
 72        /// 增加HotelUser表中的数据
 73        /// </summary>
 74        /// <param name="HUE">HotelUserEntity对象</param>
 75        /// <returns>返回结果：
 76        ///          1   执行SQL语句成功
 77        ///         -1   SQL语句执行错误
 78        ///         -2   数据库连接失败
 79        /// </returns>
 80        public static int AddHotelUser(HotelUserEntity HUE)
 81        ...{
 82            return HotelUserDAL.AddHotelUser(HUE);
 83        }
 84
 85        /**//// <summary>
 86        /// 修改HotelUser表中的数据
 87        /// </summary>
 88        /// <param name="HUE">HotelUserEntity对象</param>
 89        /// <returns>返回结果：
 90        ///          1   执行SQL语句成功
 91        ///         -1   SQL语句执行错误
 92        ///         -2   数据库连接失败
 93        /// </returns>
 94        public static int UpdateHotelUser(HotelUserEntity HUE)
 95        ...{
 96            return HotelUserDAL.UpdateHotelUser(HUE);
 97        }
 98
 99        public static int UpdateStatusByUserName(int Status, string UserName,string SessionName)
100        ...{
101            return HotelUserDAL.UpdateStatusByUserName(Status, UserName,SessionName);
102        }
103
104        public static int ChangePwd(HotelUserEntity HUE,string pwd)
105        ...{
106            return HotelUserDAL.ChangePwd(HUE,pwd);
107        }
108
109        /**//// <summary>
110        /// 删除HotelUser表中的数据
111        /// </summary>
112        /// <param name="HUE">HotelUserEntity对象</param>
113        /// <returns>返回结果：
114        ///          1   执行SQL语句成功
115        ///         -1   SQL语句执行错误
116        ///         -2   数据库连接失败
117        /// </returns>
118        public static int DeleteHotelUser(HotelUserEntity HUE)
119        ...{
120            return HotelUserDAL.DeleteHotelUser(HUE);
121        }
122
123        public static int DeleteHotelUserByUserID(int UserID)
124        ...{
125            return HotelUserDAL.DeleteHotelUserByUserID(UserID);
126        }
127    }
128}
129