protected void btAdd_Click(object sender, EventArgs e) { HtlTypeDetail _HtlTypeDetail = new HtlTypeDetail(); HtlTypeDetailBLL _HtlTypeDetailBLL = new HtlTypeDetailBLL(); _HtlTypeDetail.HouseType = this.txtHouseType.Text; _HtlTypeDetail.BedType = this.txtBed.Text; _HtlTypeDetail.HaveBreakfast = this.txtBreakfast.Text; _HtlTypeDetail.Broadband = this.txtBroadBand.Text; _HtlTypeDetail.TypeID = int.Parse(Request.QueryString["HtlTypeID"].ToString()); _HtlTypeDetail.Price = TxtPrice.Text; int HotelID = int.Parse(Request.QueryString["HotelID"].ToString()); String HotelName = Request.QueryString["HotelName"].ToString(); int CityID = int.Parse(Request.QueryString["CityID"].ToString()); int PageStart = int.Parse(Request.QueryString["PageStart"].ToString()); int HtlTypeID = int.Parse(Request.QueryString["HtlTypeID"].ToString()); String HtlTypeName = Request.QueryString["HtlTypeName"].ToString(); if (_HtlTypeDetailBLL.AddHotelTypeDetail(_HtlTypeDetail)) { Response.Write("<script language='javascript'>"); Response.Write("alert('添加成功');"); Response.Write("document.location.href='HotelSubRmTypeList.aspx?CityID=" + CityID.ToString() + "&HotelName=" + HotelName.ToString() + "&HtlTypeID" + HtlTypeID.ToString() + "&HotelID=" + HotelID.ToString() + "&PageStart=" + PageStart.ToString() + "&HtlTypeID=" + HtlTypeID.ToString() + "&HtlTypeName=" + HtlTypeName.ToString() + "';"); Response.Write("</script>"); } }
/// <summary> /// 添加一个酒店房型的子房型 /// </summary> /// <param name="_HtlTypeDetail"></param> /// <returns></returns> public bool AddHotelTypeDetail(HtlTypeDetail _HtlTypeDetail) { String Sql = "insert into HotelTypeDetail(HouseType,BedType,HaveBreakfast,Broadband,Price,TypeID) values " + "(@HouseType,@BedType,@HaveBreakfast,@Broadband,@Price,@TypeID)"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@HouseType", _HtlTypeDetail.HouseType), new SqlParameter("@BedType", _HtlTypeDetail.BedType), new SqlParameter("@HaveBreakfast", _HtlTypeDetail.HaveBreakfast), new SqlParameter("@Broadband", _HtlTypeDetail.Broadband), new SqlParameter("@Price", _HtlTypeDetail.Price), new SqlParameter("@TypeID", _HtlTypeDetail.TypeID) }; if (SqlHelper.ExecuteNonQuery(Sql, Paras, CommandType.Text) > 0) { return(true); } return(false); }
/// <summary> /// 添加一个酒店房型的子房型 /// </summary> /// <param name="_HtlTypeDetail"></param> /// <returns></returns> public bool AddHotelTypeDetail(HtlTypeDetail _HtlTypeDetail) { return(this._HtlTypeDetailDAL.AddHotelTypeDetail(_HtlTypeDetail)); }