public Task <List <DropdownItemModel> > GetResListAsync(FilterCurrent curr) { IQueryable <DropdownItemModel> query = null; switch (curr) { case FilterCurrent.CurrentUserId: query = UserRepository.QueryEnable() .OrderByDescending(m => m.Id) .Select(m => new DropdownItemModel() { Value = m.Id, Text = m.LoginName }); break; case FilterCurrent.CurrentRoleId: query = UserRoleRepository.QueryEnable() .OrderBy(m => m.Sort) .ThenByDescending(m => m.Id) .Select(m => new DropdownItemModel() { Value = m.Id, Text = m.Name }); break; case FilterCurrent.CurrentDeptId: query = SysApartRepository.QueryEnable() .OrderBy(m => m.Sort) .ThenByDescending(m => m.Id) .Select(m => new DropdownItemModel() { Value = m.Id, Text = m.Name }); break; default: break; } return(query.ToListAsync()); }
public IEnumerable <DropdownItemModel> GetResList(FilterCurrent curr) { var sql = ""; switch (curr) { case FilterCurrent.CurrentUserId: sql = "select Id as Value,LoginName as Text from Users order by Id desc"; break; case FilterCurrent.CurrentRoleId: sql = "select Id as Value,Name as Text from UserRole order by Sort,Id desc"; break; case FilterCurrent.CurrentDeptId: sql = "select Id as Value,Name as Text from SysApartment order by Sort,Id desc"; break; default: break; } return(DbConn.Query <DropdownItemModel>(sql)); }
public async Task <ActionResult> GetCurrResources(FilterCurrent curr) { var list = await UserRoleSvc.GetResListAsync(curr); return(Json(list)); }