/// <summary>
/// 添加客房表
/// </summary>
private void AddRoom()
{
RoomBLL rBll = new RoomBLL(); //逻辑层
RoomBean rb = new RoomBean();
//得到表单提交的值
rb.Number = Request.Form["Number"];
//分别给实体Bean赋值
rb.BedNumber = int.Parse(Request.Form["BedNumber"].ToString());
rb.TypeId = int.Parse(Request.Form["TypeId"].ToString());
rb.StateId = int.Parse(Request.Form["StateId"].ToString());
rb.Remark = Request.Form["remark"];
string json;
//如果success为true,则表示服务器端处理成功
if (rBll.AddRoom(rb))
{
json = @"{success: true}";
}
else
{
json = @"{success: false}";
}
Response.Write(json);
}
/// <summary>
/// 添加客房表
/// </summary>
/// <param name="rb"></param>
/// <returns></returns>
public bool AddRoom(RoomBean rb)
{
if (rd.AddRoom(rb) > 0)
{
return(true);
}
return(false);
}
private void Add_Rooms(object sender, RoutedEventArgs e)
{
RoomBean bean = new RoomBean();
if (this.roomName.Text.Equals(""))
{
MessageBox.Show("请输入机房名!");
return;
}
RoomClass rc = new RoomClass();
bean.RoomName = this.roomName.Text;
if (!this.belongs.Text.Equals(""))
{
bean.Belongs = this.belongs.Text;
}
if (!this.purpose.Text.Equals(""))
{
bean.Purpose = this.purpose.Text;
}
if (!this.floor.Text.Equals(""))
{
bean.Floor = this.floor.Text;
}
int state = rc.AddRoom(bean);
if (state == BaseRequest.HAS)
{
MessageBox.Show("已存在该机房名!");
}
else if (state == BaseRequest.SUCCESS)
{
MessageBox.Show("操作成功!");
this.addRooms.Visibility = Visibility.Hidden;
RoomManagerBean.AddRoom.page.ShowPages(RoomManagerBean.AddRoom.roomDate, rc.queryRoomsList(), BaseRequest.PAGE_SIZE);
}
else
{
MessageBox.Show("系统异常，请连管理员!");
}
}
/// <summary>
/// 添加客房表
/// </summary>
/// <param name="rb"></param>
/// <returns></returns>
public int AddRoom(RoomBean rb)
{
int count = 0;
try
{
SqlParameter[] sp =
{
para = new SqlParameter("@Number", rb.Number),
para = new SqlParameter("@BedNumber", rb.BedNumber),
para = new SqlParameter("@TypeId", rb.TypeId),
para = new SqlParameter("@StateId", rb.StateId),
para = new SqlParameter("@Remark", rb.Remark)
};
count = sh.RunSql("AddRoom", sp);
}
catch (Exception ex)
{
throw ex;
}
return(count);
}
private void Sava_Edit(object sender, RoutedEventArgs e)
{
if (this.roomName.Text.Equals(""))
{
MessageBox.Show("请输入机房名称!");
return;
}
RoomBean bean = new RoomBean();
RoomClass rc = new RoomClass();
bean.RoomName = this.roomName.Text;
bean.Floor = this.floor.Text;
bean.Purpose = this.purpose.Text;
bean.Belongs = this.belongs.Text;
bean.Id = (int)this.roomId.Content;
int state = rc.saveEditRoom(bean);
if (state == BaseRequest.SUCCESS)
{
MessageBox.Show("操作成功!");
this.edit_room.Visibility = Visibility.Hidden;
RoomManagerBean.AddRoom.page.ShowPages(RoomManagerBean.AddRoom.roomDate, rc.queryRoomsList(), BaseRequest.PAGE_SIZE);
}
}
