/// <summary> /// 获取全部房间类型 /// </summary> /// <returns>房间类型列表</returns> public List <RoomTypeList> GetTypeList() { List <RoomTypeList> list = new List <RoomTypeList>(); string sql = string.Format(@"SELECT TypeName+CASE WHEN TypeWindow=0 THEN ' | 无窗' WHEN TypeWindow=1 THEN ' | 有窗' END,TypeId FROM RoomType"); SqlDataReader r = DBHerper.Reader(sql); while (r.Read()) { RoomTypeList l = new RoomTypeList() { TypeName = r[0].ToString(), TypeID = r[1].ToString() }; list.Add(l); } r.Close(); return(list); }
/// <summary> /// 获取全部房间信息并筛选 /// </summary> /// <param name="id">房间ID</param> /// <returns>房间信息列表</returns> public List <RoomTypeList> GetRoomInfo(string id) { List <RoomTypeList> list = new List <RoomTypeList>(); string sql = string.Format(@"SELECT RoomId,RoomStateName,TypeName+CASE WHEN TypeWindow=0 THEN ' | 无窗' WHEN TypeWindow=1 THEN ' | 有窗' END FROM RoomType AS T,Room AS R,RoomState AS S WHERE (R.RoomTypeId=T.TypeId AND R.RoomStateId=S.RoomStateId) AND RoomId LIKE '%{0}%'", id); SqlDataReader r = DBHerper.Reader(sql); while (r.Read()) { RoomTypeList l = new RoomTypeList() { TypeID = r[0].ToString(), StateName = r[1].ToString(), TypeName = r[2].ToString() }; list.Add(l); } r.Close(); return(list); }