protected void Add_Click(object sender, EventArgs e) { if (RoomIdAfter.Text == "")//酒店客房编号未填 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('请输入一个该酒店的客房编号!!');</script>"); } else { hotelRoom hr = new hotelRoom(); //酒店客房信息对象 hr.Rid = RoomIdBefore.Text.Trim() + RoomIdAfter.Text.Trim(); //酒店客房编号 hr.Hid = Request["HotelId"]; //接收来自酒店信息页面a链接传递过来的酒店编号 string type = Type.Text.Trim(); //客房类型 if (room.IdisExisted(hr.Rid)) //要添加的酒店客房编号存在 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('要添加的客房编号已存在,请重新输入一个编号!');</script>"); } else if (type == "")//客房类型未填 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('请输入客房类型!');</script>"); } else if (AllNumber.Text == "" || Int32.Parse(AllNumber.Text.Trim()) <= 0)//客房总量为空或填写的客房总量小等于0时 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('请输入大于0的客房总量!');</script>"); } else if (SinglePrice.Text == "" || Double.Parse(SinglePrice.Text.Trim()) <= 0)//每晚价格为空或填写的价格小等于0时 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('请输入该客房住一晚的价格,价格需大于0!');</script>"); } else { if (room.TypeisExisted(type)) //要添加的客房类型已存在 { hr.Tid = room.searchRoomTypeId(type); //根据客房类型名称查询到的客房类型编号 hr.Rnumber = Int32.Parse(AllNumber.Text.Trim()); //客房总量 hr.Rprice = Double.Parse(SinglePrice.Text.Trim()); //每晚价格 hr.Rremark = Remark.Value.Trim(); //备注 hr.RvacantNum = hr.Rnumber; //当前可预约空房数为客房总量 hr.RimageUrl = RoomImgUpload.Value.Trim(); //上传的客房图片url名称 room.addHotelRoomInfo(hr); //添加酒店客房信息 Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加成功!');</script>"); InitGridView();//重新加载表格数据 //清空文本框 RoomIdAfter.Text = ""; Type.Text = ""; AllNumber.Text = ""; SinglePrice.Text = ""; Remark.Value = ""; } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('要添加的客房类型不存在,请先去客房类型管理界面进行添加!');</script>"); } } } }
//更新编辑的数据行 protected void GridView1_RowUpdating(object sender, GridViewUpdateEventArgs e) { hotelRoom hr = new hotelRoom(); //酒店客房信息对象 roomType t = new roomType(); //客房类型对象 GridViewRow row = this.GridView1.Rows[e.RowIndex]; hr.Rid = e.Keys[0].ToString().Trim(); //酒店客房编号 hr.Hid = HotelId.Text.Trim(); //酒店编号 if (UpdateRoomImg.Value == "") //如果没有更改酒店客房图片 { hr.RimageUrl = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[1].Controls[0]).Text.ToString(); //原先的客房图片 } else { hr.RimageUrl = UpdateRoomImg.Value.Trim(); //上传的本地图片url } string oldType = room.searchHotelRoomType(hr.Rid); //修改前的该酒店的客房类型名称 bool flag = false; //标志要修改成的客房类型是否存在 string type = ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString(); //客房类型 if (!room.TypeisExisted(type)) //如果要修改成的客房类型不存在 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('该客房类型不存在,请先去客房类型管理页面添加!');</script>"); ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text = oldType;//还原原先客房类型 } else//如果要修改成的客房类型存在 { for (int i = 0; i < GridView1.Rows.Count; i++) { //要修改成的酒店的该客房类型已存在 if (((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text.ToString() == GridView1.Rows[i].Cells[3].Text && i != e.RowIndex) { flag = true; //要修改的客房类型存在 Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('该客房类型已存在,请直接在它的数据行修改!');</script>"); ((TextBox)this.GridView1.Rows[e.RowIndex].Cells[3].Controls[0]).Text = oldType; //还原原先客房类型 } } if (!flag) //要修改成的酒店的该客房类型不存在 { hr.Tid = room.searchRoomTypeId(type); //根据客房类型查到的客房类型编号 hr.Rprice = Double.Parse(((TextBox)row.Cells[10].Controls[0]).Text.ToString()); //每晚价格 hr.Rnumber = Int32.Parse(((TextBox)row.Cells[11].Controls[0]).Text.ToString()); //总数量 hr.Rremark = ((TextBox)row.Cells[12].Controls[0]).Text.ToString(); //酒店客房备注 hr.RvacantNum = Int32.Parse(((TextBox)row.Cells[13].Controls[0]).Text.ToString()); //当前空房数 if (room.updateHotelRoomInfo(hr, hr.Rid)) //执行修改的方法成功 { this.GridView1.EditIndex = -1; //取消编辑状态 RoomImgLabel.Style.Add("display", "none"); //标签不可见 UpdateRoomImg.Attributes.Add("disabled", "disabled"); //文件上传控件禁用 InitGridView(); //重新加载一次数据 } } } }
protected void RoomAdd_Click(object sender, EventArgs e) { if (RoomIdAfter.Text == "") { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('请输入一个该酒店的客房编号!!');</script>"); } else { hotelRoom hr = new hotelRoom(); //酒店客房信息对象 hr.Rid = RoomIdBefore.Text.Trim() + RoomIdAfter.Text.Trim(); //酒店客房编号 hr.Hid = HotelId.Text.Trim(); //酒店编号 string typeName = TypeName.Text.Trim(); //客房类型 if (room.IdisExisted(hr.Rid)) //要添加的酒店客房编号存在 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('要添加的客房编号已存在,请重新输入一个编号!');</script>"); } else if (typeName == "")//客房类型未填 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('请输入客房类型!');</script>"); } else if (AllNumber.Text == "" || Int32.Parse(AllNumber.Text.Trim()) <= 0)//客房总量为空或填写的客房总量小等于0时 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('请输入大于0的客房总量!');</script>"); } else if (SinglePrice.Text == "" || Double.Parse(SinglePrice.Text.Trim()) <= 0)//每晚价格为空或填写的价格小等于0时 { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('请输入该客房住一晚的价格,价格需大于0!');</script>"); } else { if (room.TypeisExisted(typeName)) //要添加的客房类型已存在 { hr.Tid = room.searchRoomTypeId(typeName); //根据客房类型名称查询到的客房类型编号 hr.Rnumber = Int32.Parse(AllNumber.Text.Trim()); //客房总量 hr.Rprice = Double.Parse(SinglePrice.Text.Trim()); //每晚价格 hr.Rremark = Remark.Text.Trim(); //备注 hr.RvacantNum = hr.Rnumber; //当前可预约空房数为客房总量 hr.RimageUrl = RoomImgUpload.Value.Trim(); //上传的客房图片url名称 room.addHotelRoomInfo(hr); //添加酒店客房信息 Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('添加成功!');</script>"); RoomTable.Attributes.CssStyle.Remove("display"); //设置客房添加表可见 //显示添加成功的酒店客房信息 DataTable table = room.searchHotelRoomById(hr.Hid); //根据酒店编号查询客房信息 this.RoomGridView.DataSource = table; this.RoomGridView.DataBind(); //数据绑定 //清空文本框 RoomIdAfter.Text = ""; TypeName.Text = ""; AllNumber.Text = ""; SinglePrice.Text = ""; Remark.Text = ""; } else { Page.ClientScript.RegisterStartupScript(Page.GetType(), "message", "<script language='javascript' defer>alert('要添加的客房类型不存在,请先去客房类型管理界面进行添加!');</script>"); } } } }