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

		            
  1using System;
  2using System.Collections.Generic;
  3using System.Text;
  4using System.Data;
  5using Model;
  6using DAL;
  7
  8
  9namespace BLL
 10...{
 11    public class RoomTypeBLL
 12    ...{
 13        private DataSet ds;
 14        RoomTypeDAO dao = new RoomTypeDAO();
 15        JSONHelper json = new  JSONHelper();
 16        
 17
 18        //将DataSet 转换为JSON数据
 19        public string getRoomTypeInfo(int start,int limit)
 20        ...{
 21            ds = dao.getAllRoomTypeInfo(start,limit);
 22            json.success = true;
 23           
 24            foreach(DataRow dr in ds.Tables[0].Rows)
 25            ...{
 26                json.AddItem("typeid",dr["typeid"].ToString());
 27                json.AddItem("typename", dr["typename"].ToString());
 28                json.AddItem("typeprice", dr["typeprice"].ToString());
 29                json.AddItem("typeaddbed", dr["typeaddbed"].ToString());
 30                json.AddItem("addbed", dr["addbed"].ToString());
 31                json.AddItem("typedesc", dr["typedesc"].ToString());
 32                json.ItemOk();
 33            }
 34            json.totlalCount = dao.getInfoCount();
 35            string jsons = "";
 36            if (json.totlalCount > 0)
 37            ...{
 38                jsons = json.ToString();
 39            }
 40            else
 41            ...{
 42                jsons = @"{success:false}";
 43            }
 44            return jsons;
 45        }
 46
 47        //删除房间信息
 48        public int DeleteRoomTypeInfo(int typeid)
 49        ...{
 50            return dao.DeleteRoomTypeInfo(typeid);
 51        }
 52
 53        //根据typeid查类型信息
 54        public string getRoomTypeInfo(int typeid)
 55        ...{
 56         
 57            FormJSONHelper json = new FormJSONHelper();
 58            ds = dao.GetTypeInfoByTypeid(typeid);
 59            json.success = true;
 60            foreach(DataRow dr in ds.Tables[0].Rows)
 61            ...{
 62                json.AddItem("typeid", dr["typeid"].ToString());
 63                json.AddItem("typename", dr["typename"].ToString());
 64                json.AddItem("typeprice", dr["typeprice"].ToString());
 65                json.AddItem("typeaddbed", dr["typeaddbed"].ToString());
 66                json.AddItem("addbed", dr["addbed"].ToString());
 67                json.AddItem("typedesc", dr["typedesc"].ToString());
 68                json.ItemOk();
 69            }
 70            string jsons = json.ToString();
 71            return jsons;
 72        }
 73
 74        //保存房间类型信息
 75        public int saveRoomTypeInfo(RoomTypeBean type)
 76        ...{
 77            return dao.saveRoomTypeInfo(type);
 78        }
 79
 80        //添加房间类型信息
 81        public int AddRoomTypeInfo(RoomTypeBean type)
 82        ...{
 83            return dao.AddRoomTypeInfo(type);
 84        }
 85
 86        //今日房价信息
 87        public string getToDayRoomTypeInfo()
 88        ...{
 89            json.success = true;
 90            ds = dao.TodayRoomTypePrice();
 91            foreach(DataRow dr in ds.Tables[0].Rows)
 92            ...{
 93                json.AddItem("typename",dr["typename"].ToString());
 94                json.AddItem("typeprice",dr["typeprice"].ToString());
 95                json.ItemOk();
 96            }
 97            string jsons = "";
 98            if (json.totlalCount > 0)
 99            ...{
100                jsons = json.ToString();
101            }
102            else
103            ...{
104                jsons = @"{success:false}";
105            }
106            return jsons;
107        }
108
109          //修改今日房价
110        public int EditTodayPrice(string typename, decimal typeprice)
111        ...{
112            return dao.EditTodayPrice(typename,typeprice);
113        }
114
115        //开房得到房间类型信息
116        public string OpenRoomGetAllRoomTypeInfos()
117        ...{
118            ds = dao.OpenRoomGetRoomTypeInfo();
119            json.success = true;
120            foreach(DataRow dr in ds.Tables[0].Rows)
121            ...{
122                json.AddItem("typeid", dr["typeid"].ToString());
123                json.AddItem("typename", dr["typename"].ToString());
124                json.AddItem("typedesc", dr["typedesc"].ToString());
125                json.ItemOk();
126            }
127            string jsonss = json.ToString();
128            return jsonss;
129        }
130         //根据房间类型名称判断是否存在
131        public int RoomTypeIsOK(string roomTypeName)
132        ...{
133            return dao.RoomTypeIsOK(roomTypeName);
134        }
135    }
136}
137