public IQueryable <SysPermissionSampleModel> Query(SysPermissionGeneralCriteria criteria)
{
IQueryable <SysPermissionSample> data = null;
data = DataContext.Get(x => (x.Name ?? "").IndexOf(criteria.Name ?? "", StringComparison.OrdinalIgnoreCase) > -1 &&
(x.RoleId == criteria.RoleId || criteria.RoleId == null) &&
(x.Active == criteria.Active || criteria.Active == null)
).OrderByDescending(x => x.DatetimeModified);
if (data == null)
{
return(null);
}
var roles = roleRepository.Get().OrderByDescending(x => x.DatetimeModified);
var results = data.Join(roles, x => x.RoleId, y => y.Id, (x, y) => new SysPermissionSampleModel {
Id = x.Id,
Name = x.Name,
RoleId = x.RoleId,
Type = x.Type,
Active = x.Active,
RoleName = y.Name
});
return(results);
}
public IActionResult Query(SysPermissionGeneralCriteria criteria)
{
var results = permissionGeneralService.Query(criteria);
return(Ok(results));
}
