List(PermissionRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
await using (_dbContext)
{
var query = _dbContext.DncPermission.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Name.Contains(payload.Kw.Trim()) ||
x.Code.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > IsDeleted.All)
{
query = query.Where(x => x.IsDeleted == payload.IsDeleted);
}
if (payload.Status > Status.All)
{
query = query.Where(x => x.Status == payload.Status);
}
if (payload.MenuGuid.HasValue)
{
query = query.Where(x => x.MenuGuid == payload.MenuGuid);
}
var list = await query.Paged(payload.CurrentPage, payload.PageSize).
Include(x => x.Menu).ToListAsync();
var totalCount = await query.CountAsync();
var data = list.Select(_mapper.Map <DncPermission, PermissionJsonModel>);
/*
* .Select(x => new PermissionJsonModel {
* MenuName = x.Menu.Name,
* x.
* });
*/
response.SetData(data, totalCount);
return(Ok(response));
}
}
public IActionResult List(PermissionRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext)
{
var query = _dbContext.SystemPermission.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Name.Contains(payload.Kw.Trim()) || x.ActionCode.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => (CommonEnum.IsDeleted)x.IsDeleted == payload.IsDeleted);
}
if (payload.Status > CommonEnum.Status.All)
{
query = query.Where(x => (CommonEnum.Status)x.Status == payload.Status);
}
if (payload.SystemMenuUuid.HasValue)
{
query = query.Where(x => x.SystemMenuUuid == payload.SystemMenuUuid);
}
var list = query.Paged(payload.CurrentPage, payload.PageSize).Include(x => x.SystemMenuUu).ToList();
var totalCount = query.Count();
var data = list.Select(_mapper.Map <SystemPermission, PermissionJsonModel>);
/*
* .Select(x => new PermissionJsonModel {
* MenuName = x.Menu.Name,
* x.
* });
*/
response.SetData(data, totalCount);
ToLog.AddLog("查询", "成功:查询:系统权限信息数据", _dbContext);
return(Ok(response));
}
}
public IHttpActionResult List(PermissionRequestPayload payload)
{
var response = ResponseModelFactory.CreateResultInstance;
using (_dbContext) {
var query = _dbContext.Permissions.AsQueryable();
if (!string.IsNullOrEmpty(payload.Kw))
{
query = query.Where(x => x.Name.Contains(payload.Kw.Trim()) || x.Code.Contains(payload.Kw.Trim()));
}
if (payload.IsDeleted > CommonEnum.IsDeleted.All)
{
query = query.Where(x => x.IsDeleted == payload.IsDeleted);
}
if (payload.Status > CommonEnum.Status.All)
{
query = query.Where(x => x.Status == payload.Status);
}
if (payload.MenuId != -5)
{
query = query.Where(x => x.MenuId == payload.MenuId);
}
var list = query.OrderByDescending(x => x.CreatedOn).Paged(payload.CurrentPage, payload.PageSize).Include(x => x.Menu).ToList();
var totalCount = query.Count();
var data = list.Select(_mapper.Map <Permission, PermissionJsonModel>);
/*
* .Select(x => new PermissionJsonModel {
* MenuName = x.Menu.Name,
* x.
* });
*/
response.SetData(data, totalCount);
return(Ok(response));
}
}
