当前文件： ExtjsHotelManage/BLL/RoomBLL.cs[2K，2009-6-12 11:42:12]，打开代码结构图

		            
 1using System;
 2using System.Collections.Generic;
 3using System.Text;
 4using Model;
 5using DAL;
 6using System.Data;
 7
 8namespace BLL
 9...{
10    public class RoomBLL
11    ...{
12        RoomDAO dao = new RoomDAO();
13        private DataSet ds;
14        //得到房间信息
15        public string GetRoomInfosByTypeid(int typeid)
16        ...{
17            JSONHelper json = new JSONHelper();
18            ds = dao.GetRoomInfoByTypeid(typeid);
19            json.success = true;
20            foreach(DataRow dr in ds.Tables[0].Rows)
21            ...{
22                json.AddItem("roomid",dr["roomid"].ToString());
23                json.AddItem("number",dr["number"].ToString());
24                json.AddItem("roomdesc", dr["roomdesc"].ToString());
25                json.ItemOk();
26            }
27            string jsons = json.ToString();
28            return jsons;
29        }
30        //查询房间信息分页
31        public string GetRoomInfoPage(int start,int limit)
32        ...{
33            JSONHelper json = new JSONHelper();
34            ds = dao.GetRoomInfoPaging(start, limit);
35            json.success = true;
36            foreach(DataRow dr in ds.Tables[0].Rows)
37            ...{
38                json.AddItem("roomid", dr["roomid"].ToString());
39                json.AddItem("number", dr["number"].ToString());
40                json.AddItem("bednumber", dr["bednumber"].ToString());
41                json.AddItem("guestnumber", dr["guestnumber"].ToString());
42                json.AddItem("typeid", dr["typeid"].ToString());
43                json.AddItem("roomstate", dr["roomstate"].ToString());
44                json.AddItem("roomdesc", dr["roomdesc"].ToString());
45                json.ItemOk();
46            }
47            json.totlalCount = dao.GetAllRoomCount();
48            string jsons="";
49            if (json.totlalCount > 0)
50            ...{
51                jsons = json.ToString();
52            }
53            else
54            ...{
55                jsons = @"{success:false}";
56            }
57           
58            return jsons;
59        }
60        //得到房间信息不判断状态
61        public RoomBean getRoonInfosNoState(int roomid)
62        ...{
63            return dao.getRoonInfosNoState(roomid);
64        }
65          //更新房间信息
66        public int SaveRoomInfo(RoomBean room)
67        ...{
68            return dao.SaveRoomInfo(room);
69        }
70        //添加新房间
71        public int AddRoomInfo(RoomBean room)
72        ...{
73            return dao.AddRoomInfo(room);
74        }
75        //验证房间号是否存在
76        public int RoomIDIsOK(string roomid)
77        ...{
78            return dao.RoomIDIsOK(roomid);
79        }
80        //删除房间信息
81        public int DelRoomInfos(int roomid)
82        ...{
83            return dao.DelRoomInfos(roomid);
84        }
85    }
86}
87