1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using System.Data;
 5using HotelModels;
 6using HotelDAL;
 7
 8namespace HotelBLL
 9...{
10    public class RoomStateBLL
11    ...{
12        RoomStateDAO rsd = new RoomStateDAO(); //数据层
13
14
15        
16        /**//// <summary>
17        /// 查询房间状态表(所有)
18        /// </summary>
19        /// <returns></returns>
20        public string  GetAllRoomState()
21        ...{
22            JSONHelper jsonHelp = new JSONHelper();
23            jsonHelp.success = true;
24            DataSet ds = rsd.GetAllRoomState();
25            foreach (DataRow dr in ds.Tables[0].Rows)
26            ...{
27                jsonHelp.AddItem("StateId", dr["StateId"].ToString());
28                jsonHelp.AddItem("StateName", dr["StateName"].ToString());
29                jsonHelp.ItemOk();
30            }
31            string str = jsonHelp.ToString();
32            return str;
33        }
34    }
35}
36