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));
}
}
