/// <summary>
/// 删除一个广告信息
/// </summary>
/// <returns></returns>
public ActionResult DeleteWarmInfo()
{
int ID = int.Parse(Request["Id"]);
Business.Sys_Adviertisement Sys_Adviertisement = new Business.Sys_Adviertisement();
Model.Adviertisement Adviertisement = Sys_Adviertisement.GetModel(ID.ToString());
if (Sys_Adviertisement.DeleteWarm(ID))
{
return(Content("True"));
}
return(Content("False"));
}
/// <summary>
/// 修改一条记录
/// </summary>
/// <param name="Flower"></param>
/// <returns></returns>
public bool UpdateAdviertisemente(Model.Adviertisement adv)
{
const string sql = @"UPDATE Adviertisement SET Title=@Title,UsersId=@UsersId,Content=@Content,
UpdateTime=@UpdateTime,Picture=@Picture,Pictures=@Pictures WHERE Id=@Id";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
adv.Title,
adv.UsersId,
adv.Content,
adv.UpdateTime,
adv.Picture,
adv.Pictures,
adv.ID,
})));
}
/// <summary>
/// 写入一条记录
/// </summary>
/// <param name="Adviertisement"></param>
/// <returns></returns>
public bool InsertAdviertisement(Model.Adviertisement adv)
{
const string sql = @"INSERT INTO Adviertisement(Title,UsersId,Content,CreateTime,UpdateTime,Picture,Pictures)
VALUES(@Title,@UsersId,@Content,@CreateTime,@UpdateTime,@Picture,@Pictures)";
return(Factory.DBHelper.ExecSQL(SQLConString, sql.ToString(), new DynamicParameters(new
{
adv.Title,
adv.UsersId,
adv.Content,
adv.CreateTime,
adv.UpdateTime,
adv.Picture,
adv.Pictures
})));
}
/// <summary>
/// 删除一个广告信息
/// </summary>
/// <returns></returns>
public ActionResult DeleteAdvInfo()
{
int ID = int.Parse(Request["AdvId"]);
Business.Sys_Adviertisement Sys_Adviertisement = new Business.Sys_Adviertisement();
Model.Adviertisement Adviertisement = Sys_Adviertisement.GetModel(ID.ToString());
string path = Server.MapPath("~") + Adviertisement.Picture;
//删除广告图片
if (System.IO.File.Exists(path))
{
System.IO.File.Delete(path);
}
if (Sys_Adviertisement.DeleteAdviertisement(ID))
{
return(Content("True"));
}
return(Content("False"));
}
public ActionResult Add(Model.Adviertisement adv)
{
try
{
Business.Sys_Adviertisement Sys_Adviertisement = new Business.Sys_Adviertisement();
HttpPostedFileBase file = Request.Files["attach_path"];
adv.Picture = Utility.ChangeText.SaveUploadPicture(file, "AdvPic");
adv.CreateTime = DateTime.Now;
adv.UpdateTime = DateTime.Now;
Sys_Adviertisement.InsertAdviertisement(adv);
Response.Write("<script>parent.layer.closeAll();</script>");
return(View());
}
catch (Exception ex)
{
Utility.Log.WriteTextLog("报错", "Adviertisement", "Add", "后台提交广告", "");
return(null);
}
}
