public static bool AddLink(Models.Links model)
{
using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
{
return(db.Insert(model) != null);
}
}
public static bool UpdateLink(Models.Links model)
{
using (PetaPoco.Database db = new PetaPoco.Database("sqlconnection"))
{
var entity = db.Query <Models.Links>("where id=@0", model.Id).SingleOrDefault();
entity.IsHidden = model.IsHidden;
entity.Logo = model.Logo;
entity.Name = model.Name;
entity.Url = model.Url;
return(db.Update(entity) > 0);
}
}
//提交保存
protected void btnsave_Click(object sender, EventArgs e)
{
if (Request["type"] == "Edit")
{
long Id = Convert.ToInt64(Request["ID"]);
var item = db.Find(Id);
if (item != null)
{
item.Title = txtbt.Text;
item.LinkStr = txtdz.Text;
if (db.Edit(item))
{
Page.ClientScript.RegisterStartupScript(GetType(), "e1", "edOK();", true);
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "e2", "layer.alert('修改失败');", true);
}
}
else
{
//找不到数据就返回列表
Response.Redirect("LinksListPG.aspx");
}
}
else
{
Models.Links item = new Models.Links();
item.Title = txtbt.Text;
item.LinkStr = txtdz.Text;
if (db.Add(item))
{
Page.ClientScript.RegisterStartupScript(GetType(), "a1", "adOK()", true);
}
else
{
Page.ClientScript.RegisterStartupScript(GetType(), "a2", "layer.alert('添加失败');", true);
}
}
}
public ActionResult UpdateLink(Models.Links model)
{
bool result = false;
if (model.Id == 0)
{
result = DataProvider.AdminDataProvider.AddLink(model);
}
else
{
result = DataProvider.AdminDataProvider.UpdateLink(model);
}
if (result)
{
TempData["result"] = "操作成功";
}
else
{
TempData["result"] = "操作失败";
}
return(RedirectToAction("Links"));
}