public void Delete(Modules.SYS_PageAuthority model) { FineOffice.Entity.SYS_PageAuthority entity = new Entity.SYS_PageAuthority { ID = model.ID, }; dal.Delete(entity); }
public FineOffice.Modules.SYS_PageAuthority Update(FineOffice.Modules.SYS_PageAuthority model) { FineOffice.Entity.SYS_PageAuthority entity = new Entity.SYS_PageAuthority { ID = model.ID, Remark = model.Remark, MenuID = model.MenuID, AuthorityName = model.AuthorityName, ControlID = model.ControlID, Ordering = model.Ordering, Version = model.Version }; dal.Update(entity); return(this.GetModel(a => a.ID == model.ID)); }
public override void Delete(Entity.SYS_PageAuthority entity) { using (DataContext cxt = ContextFactory.CreateContext()) { Table <FineOffice.Entity.SYS_PageAuthority> authority = cxt.GetTable <FineOffice.Entity.SYS_PageAuthority>(); try { authority.DeleteOnSubmit(authority.Where(a => a.ID == entity.ID).FirstOrDefault()); cxt.SubmitChanges(); } catch (Exception ex) { throw new Exception(ex.Message); } } }
public override Entity.SYS_PageAuthority Add(Entity.SYS_PageAuthority entity) { using (DataContext cxt = ContextFactory.CreateContext()) { Table <FineOffice.Entity.SYS_PageAuthority> authority = cxt.GetTable <FineOffice.Entity.SYS_PageAuthority>(); FineOffice.Entity.SYS_PageAuthority temp = authority.OrderByDescending(s => s.ID).FirstOrDefault(); entity.ID = 1; if (temp != null) { entity.ID = temp.ID + 1; } authority.InsertOnSubmit(entity); cxt.SubmitChanges(); return(entity); } }
/// <summary> /// 重写Update方法 /// </summary> public override Entity.SYS_PageAuthority Update(Entity.SYS_PageAuthority entity) { using (DataContext cxt = ContextFactory.CreateContext()) { try { Table <FineOffice.Entity.SYS_PageAuthority> authority = cxt.GetTable <FineOffice.Entity.SYS_PageAuthority>(); authority.Attach(entity, true); cxt.SubmitChanges(ConflictMode.ContinueOnConflict); } catch (ChangeConflictException) { cxt.Refresh(RefreshMode.KeepChanges, entity); cxt.SubmitChanges(ConflictMode.FailOnFirstConflict); } catch (Exception ex) { throw new Exception(ex.Message); } return(entity); } }