public BaseObject UpdateLink(LinksEntity link) { using (LinkLogic logic = new LinkLogic()) { return(logic.UpdateLink(link)); } }
public BaseObject InsertLink(LinksEntity link) { using (LinkLogic logic = new LinkLogic()) { return(logic.InsertLink(link)); } }
public BaseObject InsertLink(LinksEntity link) { BaseObject obj = new BaseObject(); if (_db.Connection.State != ConnectionState.Open) { _db.Connection.Open(); } using (var tran = _db.Connection.BeginTransaction()) { try { var lin = new Links() { Contact = link.Contact, Description = link.Description, Email = link.Email, LinkCategoryID = link.LinkCategoryID, LinkUrl = link.LinkUrl, Name = link.Name, PictureFile = link.PictureFile, SortOrder = link.SortOrder, DateCreated = DateTime.Now, UpdateUser = link.UpdateUser }; _db.Links.Add(lin); _db.SaveChanges(); tran.Commit(); obj.Tag = 1; obj.Message = "保存成功!"; } catch (Exception e) { tran.Rollback(); obj.Tag = -1; obj.Message = "保存失败!"; } finally { tran.Dispose(); } } return(obj); }
public int Save(LinksEntity data) { try { return(Connection.Db.Query <int>("spLinksSet", new { ID = data.Id, TitleLink = data.TitleLink, Address = data.Address, Image = data.Image, Description = data.Description, Active = data.Active, }, commandType: CommandType.StoredProcedure).SingleOrDefault()); } catch (Exception ex) { Tools.SaveLog.Save(ex); return(-1); } }
public List <LinksEntity> Search(LinksEntity data) { try { return(Connection.Db.Query <LinksEntity>("spLinksSearch", new { ID = data.Id, TitleLink = "%" + data.TitleLink + "%", Address = "%" + data.Address + "%", Image = "%" + data.Image + "%", Description = "%" + data.Description + "%", Active = data.Active, }, commandType: CommandType.StoredProcedure).ToList()); } catch (Exception ex) { Tools.SaveLog.Save(ex); return(new List <LinksEntity>()); } }
public BaseObject UpdateLink(LinksEntity link) { BaseObject obj = new BaseObject(); var l = _db.Links.Find(link.ID); if (l == null) { obj.Tag = -1; obj.Message = "该记录不存在!"; return(obj); } try { l.Contact = link.Contact; l.Description = link.Description; l.Email = link.Email; l.Name = link.Name; l.LinkUrl = link.LinkUrl; l.PictureFile = link.PictureFile; l.SortOrder = link.SortOrder; l.UpdateUser = link.UpdateUser; l.DateCreated = DateTime.Now; l.LinkCategoryID = link.LinkCategoryID; _db.SaveChanges(); obj.Tag = 1; } catch (Exception) { obj.Tag = -1; obj.Message = "修改失败!"; } return(obj); }
public ActionResult EditLinkJson(LinksEntity param) { var list = new Helpers.SystemHelper().UpdateLink(param); return(Json(list)); }
public ActionResult AddLinkJson(LinksEntity param) { var list = new Helpers.SystemHelper().InsertLink(param); return(Json(list)); }