1using System;
  2using System.Collections.Generic;
  3using System.Linq;
  4using System.Text;
  5using Entity;
  6using DAL;
  7using System.Data;
  8
  9
 10namespace BLL
 11...{
 12    public class RoomBLL
 13    ...{
 14        /**//// <summary>
 15        /// 查询Room表中的数据
 16        /// </summary>
 17        /// <returns>RoomEntity泛型集合</returns>
 18        public static List<RoomEntity> GetRoom()
 19        ...{
 20            return RoomDAL.GetRoom();
 21        }
 22
 23        public static RoomEntity GetRoomByRoomID(int RoomID)
 24        ...{
 25            return RoomDAL.GetRoomByRoomID(RoomID);
 26        }
 27
 28        public static string GetStateByRoomID(int RoomID)
 29        ...{
 30            DataTable dt = RoomDAL.GetStateByRoomID(RoomID);
 31            return dt.Rows[0][0].ToString();
 32        }
 33
 34        public static DataTable GetRoom_RoomTypeInfo(string TypeName,int BedNumber,int GuestNumber)
 35        ...{
 36            return RoomDAL.GetRoom_RoomTypeInfo(TypeName,BedNumber,GuestNumber);
 37        }
 38        public static DataTable GetRoom_RoomTypeInfo()
 39        ...{
 40            return RoomDAL.GetRoom_RoomTypeInfo();
 41        }
 42
 43        public static DataTable GetRoom_RoomTypeInfoByRoomID(int RoomID)
 44        ...{
 45            return RoomDAL.GetRoom_RoomTypeInfoByRoomID(RoomID);
 46        }
 47
 48        public static string GetStateByNumber(string Number)
 49        ...{
 50            DataTable dt = RoomDAL.GetStateByNumber(Number);
 51            return dt.Rows[0][0].ToString();
 52        }
 53
 54        public static DataTable GetRoomByFilter(string TypeName, string Number)
 55        ...{
 56            return RoomDAL.GetUserByFilter(TypeName, Number);
 57        }
 58
 59        public static DataTable GetRoomByFilter()
 60        ...{
 61            return RoomDAL.GetUserByFilter();
 62        }
 63        public static int GetRoomIDByNumber(string Number)
 64        ...{
 65            return RoomDAL.GetRoomIDByNumber(Number);
 66        }
 67
 68
 69        public static bool SelectRoom(string number)
 70        ...{
 71            return RoomDAL.SelectRoom(number);
 72        }
 73
 74
 75
 76        /**//// <summary>
 77        /// 增加Room表中的数据
 78        /// </summary>
 79        /// <param name="RE">RoomEntity对象</param>
 80        /// <returns>返回结果：
 81        ///          1   执行SQL语句成功
 82        ///         -1   SQL语句执行错误
 83        ///         -2   数据库连接失败
 84        /// </returns>
 85        public static int AddRoom(RoomEntity RE)
 86        ...{
 87            return RoomDAL.AddRoom(RE);
 88        }
 89
 90        /**//// <summary>
 91        /// 修改Room表中的数据
 92        /// </summary>
 93        /// <param name="RE">RoomEntity对象</param>
 94        /// <returns>返回结果：
 95        ///          1   执行SQL语句成功
 96        ///         -1   SQL语句执行错误
 97        ///         -2   数据库连接失败
 98        /// </returns>
 99        public static int UpdateRoom(RoomEntity RE)
100        ...{
101            return RoomDAL.UpdateRoom(RE);
102        }
103
104        public static int UpdateRoomByNumber(RoomEntity RE)
105        ...{
106            return RoomDAL.UpdateRoomByNumber(RE);
107        }
108
109        public static int UpdateStateByRoomID(int RoomID)
110        ...{
111            return RoomDAL.UpdateStateByRoomID(RoomID);
112        }
113
114        public static int UpdateStateByNumber(string Number)
115        ...{
116            return RoomDAL.UpdateStateByNumber(Number);
117        }
118
119
120
121
122
123        /**//// <summary>
124        /// 删除Room表中的数据
125        /// </summary>
126        /// <param name="RE">RoomEntity对象</param>
127        /// <returns>返回结果：
128        ///          1   执行SQL语句成功
129        ///         -1   SQL语句执行错误
130        ///         -2   数据库连接失败
131        /// </returns>
132        public static int DeleteRoom(RoomEntity RE)
133        ...{
134            return RoomDAL.DeleteRoom(RE);
135        }
136    }
137}
138