public ServiceResult GetRole(RoleCriteria cri = null) { var result = new ServiceResult(); try { using (var db = new AgnosDBContext()) { var rows = db.Roles .Where(w => 1 == 1); if (cri != null) { if (cri.Role_ID.HasValue) { rows = rows.Where(w => w.Role_ID == cri.Role_ID); } } result.Object = rows.OrderByDescending(o => o.Role_Name).ToList(); result.Code = ReturnCode.SUCCESS; } } catch (Exception ex) { result.Code = ReturnCode.ERROR_DB; result.Exception = ex; } return(result); }
public ServiceResult GetPageRole(RoleCriteria cri = null) { var result = new ServiceResult(); try { using (var db = new AgnosDBContext()) { var rows = db.Page_Role .Include(i => i.Role) .Include(i => i.Page) .Where(w => 1 == 1 && w.Record_Status != Record_Status.Delete); if (cri != null) { if (cri.Page_ID.HasValue) { rows = rows.Where(w => w.Page_ID == cri.Page_ID); } if (cri.Role_ID.HasValue) { rows = rows.Where(w => w.Role_ID == cri.Role_ID); } if (cri.Page_Role_ID.HasValue) { rows = rows.Where(w => w.Page_Role_ID == cri.Page_Role_ID); } } result.Object = rows.OrderBy(o => o.Role_ID).ThenBy(o => o.Page.Page_Code).ToList(); result.Code = ReturnCode.SUCCESS; } } catch (Exception ex) { result.Code = ReturnCode.ERROR_DB; result.Exception = ex; } return(result); }