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));
}
