protected void btEdit_Click(object sender, EventArgs e) { MallInfoBLL _MallInfoBLL = new MallInfoBLL(); MallInfo _MallInfo = new MallInfo(); _MallInfo.Local = this.TxtLoc.Text.Trim(); _MallInfo.PhoneNum = this.txtPhoneNum.Text.Trim(); _MallInfo.Introduction = this.TxtIntroduce.Text.Trim(); _MallInfo.OpenTime = this.TxtOpenTime.Text.Trim(); _MallInfo.CityID = int.Parse(Request.QueryString["CityID"].ToString()); _MallInfo.MallName = this.txtMallName.Text.Trim(); if (this.txtMallLgt.Text.Trim() != "") { _MallInfo.SLongitude = float.Parse(this.txtMallLgt.Text.Trim().ToString()); } else { _MallInfo.SLongitude = 0.0f; } if (this.txtMallLat.Text.Trim() != "") { _MallInfo.Slatitude = float.Parse(txtMallLat.Text.Trim().ToString()); } else { _MallInfo.Slatitude = 0.0f; } int CityID = int.Parse(Request.QueryString["CityID"].ToString()); int MallID = int.Parse(Request.QueryString["MallID"].ToString()); if (_MallInfoBLL.UpdMallInfo(MallID, _MallInfo)) { Response.Write("<script language='javascript'>"); Response.Write("alert('更改成功');"); Response.Write("document.location.href='MallInfoList.aspx?&CityID=" + CityID.ToString() + "';"); Response.Write("</script>"); } }
/// <summary> /// 更新酒店信息 /// </summary> /// <param name="MallID"></param> /// <param name="_MallInfo"></param> /// <returns></returns> public bool UpdMallInfo(int MallID, MallInfo _MallInfo) { String Sql = "update MallInfo set Local=@Local,PhoneNum=@PhoneNum,Introduction=@Introduction,OpenTime=@OpenTime," + "SLongitude=@SLongitude,Slatitude=@Slatitude where MallID = @MallID"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@SLongitude", _MallInfo.SLongitude), new SqlParameter("@Slatitude", _MallInfo.Slatitude), new SqlParameter("@Local", _MallInfo.Local), new SqlParameter("@Introduction", _MallInfo.Introduction), new SqlParameter("@OpenTime", _MallInfo.OpenTime), new SqlParameter("@PhoneNum", _MallInfo.PhoneNum), new SqlParameter("@MallID", MallID) }; if (SqlHelper.ExecuteNonQuery(Sql, Paras, CommandType.Text) > 0) { return(true); } return(false); }
/// <summary> /// 添加一个商场信息 /// </summary> /// <param name="_MallInfo"></param> public bool AddMallInfo(MallInfo _MallInfo) { String Sql = "insert into MallInfo(Local,PhoneNum,Introduction,OpenTime,CityID,SLongitude,Slatitude,MallName) values" + "(@Local,@PhoneNum,@Introduction,@OpenTime,@CityID,@SLongitude,@Slatitude,@MallName)"; SqlParameter[] Paras = new SqlParameter[] { new SqlParameter("@Local", _MallInfo.Local), new SqlParameter("@PhoneNum", _MallInfo.PhoneNum), new SqlParameter("@Introduction", _MallInfo.Introduction), new SqlParameter("@OpenTime", _MallInfo.OpenTime), new SqlParameter("@CityID", _MallInfo.CityID), new SqlParameter("@SLongitude", _MallInfo.SLongitude), new SqlParameter("@Slatitude", _MallInfo.Slatitude), new SqlParameter("@MallName", _MallInfo.MallName) }; if (SqlHelper.ExecuteNonQuery(Sql, Paras, CommandType.Text) > 0) { return(true); } return(false); }
public async Task <IActionResult> MallInfo(MallInfo mallInfo) { _context.MallInfo.Update(mallInfo); _context.SaveChanges(); return(View(mallInfo)); }
/// <summary> /// 更新酒店信息 /// </summary> /// <param name="MallID"></param> /// <param name="_MallInfo"></param> /// <returns></returns> public bool UpdMallInfo(int MallID, MallInfo _MallInfo) { return(this._MallInfoDAL.UpdMallInfo(MallID, _MallInfo)); }
/// <summary> /// 添加一个商场信息 /// </summary> /// <param name="_MallInfo"></param> public bool AddMallInfo(MallInfo _MallInfo) { return(this._MallInfoDAL.AddMallInfo(_MallInfo)); }