private void EditAdvertise() { ClassLibrary.Model.SaleAdvertise saleModel = new ClassLibrary.Model.SaleAdvertise(); saleModel.ID = saleId; saleModel.RouteClassId = Request.Form["RouteClassId"]; saleModel.Title = Request.Form["Title"]; saleModel.LinkUrl = Request.Form["LinkURL"]; saleModel.ExpiredTime = Convert.ToDateTime(Request.Form["expiredtime"]); saleModel.SaleOrder = Convert.ToInt32(Request.Form["saleorder"]); HttpPostedFile file = Request.Files["Img"]; string oldImages = Request.Form["Image_Hidden"]; if (file.ContentLength > 0) { string ext = Path.GetExtension(file.FileName); string fileName = Function.GetRandomTime() + ext; string fileFullPath = Server.MapPath(SysConfig.UploadFilePathAdImg); Function.CreatedDirectory(fileFullPath); file.SaveAs(fileFullPath + fileName); //缩图 //Bitmap tmp = new Bitmap(fileFullPath + fileName); //Bitmap bmp0 = Function.MakeThumNail(tmp, 735, 352); //tmp.Dispose(); ////bmp0.Save(fileFullPath + fileName); //Function.SaveBitmapImg(bmp0, fileFullPath + fileName, ((long)100)); //bmp0.Dispose(); Function.DeleteFile(fileFullPath + oldImages); saleModel.Img = fileName; } else { saleModel.Img = oldImages; } if (saleBLL.Update(saleModel)) { Function.goMessagePage("修改特价广告", "操作成功", "Advertise/SaleAdvertiseList.aspx"); } else { Function.goMessagePage("修改特价广告", "操作失败,请稍后再试", "Advertise/SaleAdvertiseList.aspx"); } }
/// <summary> /// 更新一条数据 /// </summary> public bool Update(ClassLibrary.Model.SaleAdvertise model) { StringBuilder strSql = new StringBuilder(); strSql.Append("update SaleAdvertise set "); strSql.Append(" Title = @Title , "); strSql.Append(" LinkUrl = @LinkUrl , "); strSql.Append(" Img = @Img , "); strSql.Append(" RouteClassId = @RouteClassId , "); strSql.Append(" CreatedTime = @CreatedTime , "); strSql.Append(" SaleOrder = @SaleOrder , "); strSql.Append(" ExpiredTime = @ExpiredTime "); strSql.Append(" where ID=@ID "); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4), new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 100), new SqlParameter("@Img", SqlDbType.NVarChar, 50), new SqlParameter("@RouteClassId", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedTime", SqlDbType.DateTime), new SqlParameter("@SaleOrder", SqlDbType.Int, 4), new SqlParameter("@ExpiredTime", SqlDbType.DateTime) }; parameters[0].Value = model.ID; parameters[1].Value = model.Title; parameters[2].Value = model.LinkUrl; parameters[3].Value = model.Img; parameters[4].Value = model.RouteClassId; parameters[5].Value = model.CreatedTime; parameters[6].Value = model.SaleOrder; parameters[7].Value = model.ExpiredTime; int rows = SQLHelper.Execute(strSql.ToString(), parameters); if (rows > 0) { return(true); } else { return(false); } }
/// <summary> /// 得到一个对象实体 /// </summary> public ClassLibrary.Model.SaleAdvertise GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("select ID, Title, LinkUrl, Img, RouteClassId, CreatedTime, SaleOrder, ExpiredTime "); strSql.Append(" from SaleAdvertise "); strSql.Append(" where ID=@ID"); SqlParameter[] parameters = { new SqlParameter("@ID", SqlDbType.Int, 4) }; parameters[0].Value = ID; ClassLibrary.Model.SaleAdvertise model = new ClassLibrary.Model.SaleAdvertise(); DataTable ds = SQLHelper.Query(strSql.ToString(), parameters); if (ds.Rows.Count > 0) { if (ds.Rows[0]["ID"].ToString() != "") { model.ID = int.Parse(ds.Rows[0]["ID"].ToString()); } model.Title = ds.Rows[0]["Title"].ToString(); model.LinkUrl = ds.Rows[0]["LinkUrl"].ToString(); model.Img = ds.Rows[0]["Img"].ToString(); model.RouteClassId = ds.Rows[0]["RouteClassId"].ToString(); if (ds.Rows[0]["CreatedTime"].ToString() != "") { model.CreatedTime = DateTime.Parse(ds.Rows[0]["CreatedTime"].ToString()); } if (ds.Rows[0]["SaleOrder"].ToString() != "") { model.SaleOrder = int.Parse(ds.Rows[0]["SaleOrder"].ToString()); } if (ds.Rows[0]["ExpiredTime"].ToString() != "") { model.ExpiredTime = DateTime.Parse(ds.Rows[0]["ExpiredTime"].ToString()); } return(model); } else { return(null); } }
private void BindData() { ClassLibrary.Model.SaleAdvertise model = saleBLL.GetModel(saleId); if (model.Img != "") { title = model.Title; img = model.Img; LinkURL = model.LinkUrl; routeClassId = model.RouteClassId; saleorder = model.SaleOrder; expiredtime = model.ExpiredTime.ToString("yyyy-MM-dd"); } else { Function.goMessagePage("修改特价广告", "操作失败,数据不存在!", "Advertise/SaleAdvertiseList.aspx"); } }
/// <summary> /// 增加一条数据 /// </summary> public int Add(ClassLibrary.Model.SaleAdvertise model) { StringBuilder strSql = new StringBuilder(); strSql.Append("insert into SaleAdvertise("); strSql.Append("Title,LinkUrl,Img,RouteClassId,CreatedTime,SaleOrder,ExpiredTime"); strSql.Append(") values ("); strSql.Append("@Title,@LinkUrl,@Img,@RouteClassId,@CreatedTime,@SaleOrder,@ExpiredTime"); strSql.Append(") "); strSql.Append(";select @@IDENTITY"); SqlParameter[] parameters = { new SqlParameter("@Title", SqlDbType.NVarChar, 100), new SqlParameter("@LinkUrl", SqlDbType.NVarChar, 100), new SqlParameter("@Img", SqlDbType.NVarChar, 50), new SqlParameter("@RouteClassId", SqlDbType.NVarChar, 50), new SqlParameter("@CreatedTime", SqlDbType.DateTime), new SqlParameter("@SaleOrder", SqlDbType.Int, 4), new SqlParameter("@ExpiredTime", SqlDbType.DateTime) }; parameters[0].Value = model.Title; parameters[1].Value = model.LinkUrl; parameters[2].Value = model.Img; parameters[3].Value = model.RouteClassId; parameters[4].Value = model.CreatedTime; parameters[5].Value = model.SaleOrder; parameters[6].Value = model.ExpiredTime; object obj = SQLHelper.Execute(strSql.ToString(), parameters); if (obj == null) { return(0); } else { return(Convert.ToInt32(obj)); } }