1using System;
  2using System.Collections.Generic;
  3using System.Linq;
  4using System.Text;
  5using System.Data;
  6using Entity;
  7using DAL;
  8//该源码下载自www.51aspx.com(５1aｓｐｘ．ｃｏｍ)
  9
 10namespace BLL
 11...{
 12    public class RoomTypeBLL
 13    ...{
 14        /**//// <summary>
 15        /// 查询RoomType表中的数据
 16        /// </summary>
 17        /// <returns>RoomtTypeEntity泛型集合</returns>
 18        public static List<RoomTypeEntity> GetRoomType()
 19        ...{
 20            return RoomTypeDAL.GetRoomType();
 21        }
 22
 23        public static RoomTypeEntity GetRoomTypeByTypeID(int TypeID)
 24        ...{
 25            return RoomTypeDAL.GetRoomTypeByTypeID(TypeID);
 26        }
 27
 28        public static int GetTypeIDByTypeName(string TypeName)
 29        ...{
 30            return RoomTypeDAL.GetTypeIDByTypeName(TypeName);
 31        }
 32
 33        public static int GetCountTypeNameByTypeName(string TypeName)
 34        ...{
 35            return RoomTypeDAL.GetCountTypeNameByTypeName(TypeName);
 36        }
 37
 38        public static DataTable GetRoomTypeByFilter(string TypeName)
 39        ...{
 40            return RoomTypeDAL.GetRoomTypeByFilter(TypeName);
 41        }
 42
 43        public static DataTable GetRoomTypeByFilter()
 44        ...{
 45            return RoomTypeDAL.GetRoomTypeByFilter();
 46        }
 47
 48        public static DataTable GetImageURL()
 49        ...{
 50            return RoomTypeDAL.GetImageURL();
 51        }
 52        public static DataTable GetImageURL(int TypeID)
 53        ...{
 54            return RoomTypeDAL.GetImageURL(TypeID);
 55        }
 56
 57
 58        /**//// <summary>
 59        /// 增加RoomType表中的数据
 60        /// </summary>
 61        /// <param name="RTE">RoomTypeEntity对象</param>
 62        /// <returns>返回结果：
 63        ///          1   执行SQL语句成功
 64        ///         -1   SQL语句执行错误
 65        ///         -2   数据库连接失败
 66        /// </returns>
 67        public static int AddRoomType(RoomTypeEntity RTE)
 68        ...{
 69            return RoomTypeDAL.AddRoomType(RTE);
 70        }
 71
 72        /**//// <summary>
 73        /// 修改RoomType表中的数据
 74        /// </summary>
 75        /// <param name="RTE">RoomTypeEntiy对象</param>
 76        /// <returns>返回结果：
 77        ///          1   执行SQL语句成功
 78        ///         -1   SQL语句执行错误
 79        ///         -2   数据库连接失败
 80        /// </returns>
 81        public static int UpdateRoomType(RoomTypeEntity RTE)
 82        ...{ 
 83            return RoomTypeDAL.UpdateRoomType(RTE);
 84        }
 85
 86        public static int UpdateRoomTypeByTypeName(RoomTypeEntity RTE)
 87        ...{
 88            return RoomTypeDAL.UpdateRoomTypeByTypeName(RTE);
 89        }
 90
 91        /**//// <summary>
 92        /// 删除RoomType表的数据
 93        /// </summary>
 94        /// <param name="RTE">RoomTypeEntity对象</param>
 95        /// <returns>返回结果：
 96        ///          1   执行SQL语句成功
 97        ///         -1   SQL语句执行错误
 98        ///         -2   数据库连接失败
 99        /// </returns>
100        public static int DeleteRoomType(RoomTypeEntity RTE)
101        ...{
102            return RoomTypeDAL.DeleteRoomType(RTE);
103        }
104
105        public static bool GetRoomTypeByRoom_TypeID(int TypeID)
106        ...{
107            DataTable dt = RoomTypeDAL.GetRoomTypeByRoom_TypeID(TypeID);
108            if (dt != null && Convert.ToInt32(dt.Rows[0][0]) > 0)
109            ...{
110                return true;
111            }
112            else 
113            ...{
114                return false;
115            }
116        }
117    }
118}
119