1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Data;
  5using HotelModels;
  6using HotelDAL;
  7
  8namespace HotelBLL
  9...{
 10    public class RoomBLL
 11    ...{
 12
 13        RoomDAO rd = new RoomDAO(); //数据层
 14
 15
 16        /**//// <summary>
 17        /// 根据类型Id查询所有客房信息(状态为空闲)
 18        /// </summary>
 19        /// <param name="TypeId"></param>
 20        /// <returns></returns>
 21        public string GetRoomByTypeId(int TypeId)
 22        ...{
 23            JSONHelper jsonHelp = new JSONHelper();
 24            jsonHelp.success = true;
 25            DataSet ds = rd.GetRoomByTypeId(TypeId);
 26            foreach (DataRow dr in ds.Tables[0].Rows)
 27            ...{
 28                jsonHelp.AddItem("RoomId", dr["RoomId"].ToString());
 29                jsonHelp.AddItem("Number", dr["Number"].ToString());
 30                jsonHelp.ItemOk();
 31            }
 32            string str = jsonHelp.ToString();
 33            return str;
 34        }
 35
 36
 37        /**//// <summary>
 38        /// 添加客房表
 39        /// </summary>
 40        /// <param name="rb"></param>
 41        /// <returns></returns>
 42        public bool AddRoom(RoomBean rb)
 43        ...{
 44            if (rd.AddRoom(rb) > 0)
 45            ...{
 46                return true;
 47            }
 48            return false;
 49        }
 50
 51
 52        
 53        /**//// <summary>
 54        /// 查询所有客房信息(查看客房信息用到,带搜索)
 55        /// </summary>
 56        /// <param name="message"></param>
 57        /// <returns></returns>
 58        public string GetAllRoom(string message)
 59        ...{
 60            JSONHelper jsonHelp = new JSONHelper();
 61            jsonHelp.success = true;
 62            DataSet ds = rd.GetAllRoom(message);
 63            foreach (DataRow dr in ds.Tables[0].Rows)
 64            ...{
 65                jsonHelp.AddItem("Number", dr["Number"].ToString());
 66                jsonHelp.AddItem("BedNumber", dr["BedNumber"].ToString());
 67                jsonHelp.AddItem("TypeName", dr["TypeName"].ToString());
 68                jsonHelp.AddItem("StateName", dr["StateName"].ToString());
 69                jsonHelp.AddItem("Remark", dr["Remark"].ToString());
 70                jsonHelp.ItemOk();
 71            }
 72            string str = jsonHelp.ToString();
 73            return str;
 74        }
 75
 76
 77        /**//// <summary>
 78        /// 查询所有状态为空闲的房间(删除客房时用到)
 79        /// </summary>
 80        /// <returns></returns>
 81        public string GetRoom()
 82        ...{
 83            JSONHelper jsonHelp = new JSONHelper();
 84            jsonHelp.success = true;
 85            DataSet ds = rd.GetRoom();
 86            foreach (DataRow dr in ds.Tables[0].Rows)
 87            ...{
 88                jsonHelp.AddItem("RoomId", dr["RoomId"].ToString());
 89                jsonHelp.AddItem("Number", dr["Number"].ToString());
 90                jsonHelp.ItemOk();
 91            }
 92            string str = jsonHelp.ToString();
 93            return str;
 94        }
 95
 96
 97        /**//// <summary>
 98        /// 删除客房表(根据房间编号)
 99        /// </summary>
100        /// <param name="Number"></param>
101        /// <returns></returns>
102        public bool DelRoom(string Number)
103        ...{
104            if (rd.DelRoom(Number) > 0)
105            ...{
106                return true;
107            }
108            return false;
109        }
110
111    }
112}
113