温馨提示:代码在线浏览功能只能做为源码浏览参考,如果想更进一步了解该代码请下载:酒店管理系统(ExtJs)源码
当前文件:
MyHotelManager/HotelBLL/RoomTypeBLL.cs,打开代码结构图
MyHotelManager/HotelBLL/RoomTypeBLL.cs,打开代码结构图1using System; 2
using System.Collections.Generic; 3
using System.Text; 4
using System.Data; 5
using HotelModels; 6
using HotelDAL; 7
8
namespace HotelBLL 9
{ 10
public class RoomTypeBLL 11
{ 12
RoomTypeDAO rtd = new RoomTypeDAO(); //数据层 13
14
/// <summary> 15
/// 添加房间类型 16
/// </summary> 17
/// <param name="rtb"></param> 18
/// <returns></returns> 19
public bool AddRoomType(RoomTypeBean rtb) 20
{ 21
if (rtd.AddRoomType(rtb) > 0) 22
{ 23
return true; 24
} 25
return false; 26
} 27
28
29
30
/// <summary> 31
/// 删除房间类型(根据类型Id) 32
/// </summary> 33
/// <param name="TypeId"></param> 34
/// <returns></returns> 35
public bool DelRoomType(int TypeId) 36
{ 37
if (rtd.DelRoomType(TypeId) > 0) 38
{ 39
return true; 40
} 41
return false; 42
} 43
44
45
46
/// <summary> 47
/// 查询所有房间类型(查询房间类型用到,带搜索) 48
/// </summary> 49
/// <returns></returns> 50
public string GetAllRoomType(string message) 51
{ 52
JSONHelper jsonHelp = new JSONHelper(); 53
jsonHelp.success = true; 54
DataSet ds = rtd.GetAllRoomType(message); 55
foreach (DataRow dr in ds.Tables[0].Rows) 56
{ 57
jsonHelp.AddItem("TypeId", dr["TypeId"].ToString()); 58
jsonHelp.AddItem("TypeName", dr["TypeName"].ToString()); 59
jsonHelp.AddItem("TypePrice", dr["TypePrice"].ToString()); 60
jsonHelp.AddItem("IsTv", dr["IsTv"].ToString()); 61
jsonHelp.AddItem("IsKongTiao", dr["IsKongTiao"].ToString()); 62
jsonHelp.AddItem("Remark", dr["Remark"].ToString()); 63
jsonHelp.ItemOk(); 64
} 65
string str = jsonHelp.ToString(); 66
return str; 67
} 68
69
70
71
/// <summary> 72
/// 查询所有未被使用的房间类型(删除用到) 73
/// </summary> 74
/// <returns></returns> 75
public string GetRoomType() 76
{ 77
JSONHelper jsonHelp = new JSONHelper(); 78
jsonHelp.success = true; 79
DataSet ds = rtd.GetRoomType(); 80
foreach (DataRow dr in ds.Tables[0].Rows) 81
{ 82
jsonHelp.AddItem("TypeId", dr["TypeId"].ToString()); 83
jsonHelp.AddItem("TypeName", dr["TypeName"].ToString()); 84
jsonHelp.ItemOk(); 85
} 86
string str = jsonHelp.ToString(); 87
return str; 88
} 89
90
91
92
93
/// <summary> 94
/// 查询今日房价 95
/// </summary> 96
/// <returns></returns> 97
public string GetTodyPrice() 98
{ 99
JSONHelper jsonHelp = new JSONHelper(); 100
jsonHelp.success = true; 101
DataSet ds = rtd.GetTodyPrice(); 102
foreach (DataRow dr in ds.Tables[0].Rows) 103
{ 104
jsonHelp.AddItem("TypeName", dr["TypeName"].ToString()); 105
jsonHelp.AddItem("TypePrice", dr["TypePrice"].ToString()); 106
jsonHelp.ItemOk(); 107
} 108
string str = jsonHelp.ToString(); 109
return str; 110
} 111
112
} 113
} 114





}