public IActionResult List(PageListParam <SystemLogListParam> pageListParam)
{
var listParam = pageListParam.Params;
var uris = new[]
{
new Uri("http://192.168.20.81:9200")
};
using (var connectionPool = new SniffingConnectionPool(uris))
{
using (var settings = new ConnectionSettings(connectionPool).DefaultIndex("chengongtestdb"))
{
settings.DeadTimeout(TimeSpan.FromMinutes(1));
settings.MaxRetryTimeout(TimeSpan.FromMinutes(1));
settings.ConnectionLimit(100);
var client = new ElasticClient(settings);
var qwe = client.Search <object>(a => a.AllIndices()
.AllTypes().From(pageListParam.Limit * (pageListParam.Page - 1))
.Size(pageListParam.Limit).Query(q => q.Match(b => b.Field("_all").Query(listParam.Content))));
var documents = qwe.Hits.Select(a => new SystemLogList {
Content = a.Source.ToJson(), Index = a.Index, Type = a.Type
}).ToList();
return(PageListResult(new PageListResult(documents, (int)((SearchResponse <object>)qwe).Total)));
}
}
}
public IActionResult List(PageListParam <RoleListParam> pageListParam)
{
var where = ExpressionBuilder.True <SysRole>();
var listParam = pageListParam.Params;
if (!listParam.RoleName.IsNullOrEmpty())
{
where = where.And(a => a.RoleName.StartsWith(listParam.RoleName));
}
if (listParam.EndCreateDateTime.HasValue)
{
where = where.And(a => a.CreateDateTime >= listParam.BeganCreateDateTime.Value);
}
if (listParam.BeganCreateDateTime.HasValue)
{
where = where.And(a => a.CreateDateTime <= listParam.EndCreateDateTime.Value);
}
if (listParam.RoleStatus.HasValue)
{
where = where.And(a => a.RoleStatus == listParam.RoleStatus.Value);
}
var result = _roleService.PageList(where, pageListParam);
result.Data = ((List <SysRole>)result.Data).Select(a => new RoleTableList
{
SysRoleId = a.SysRoleId,
CreateDateTime = a.CreateDateTime,
RoleName = a.RoleName,
RoleStatus = ((ERoleStatus)a.RoleStatus).GetDisplayName()
}).ToList();
return(PageListResult(result));
}
public IActionResult List(PageListParam <ListParam> pageListParam)
{
var where = ExpressionBuilder.True <SysUser>();
var listParam = pageListParam.Params;
if (!listParam.UserName.IsNullOrEmpty())
{
where = where.And(a => a.UserName.StartsWith(listParam.UserName));
}
if (!listParam.UserId.IsNullOrEmpty())
{
where = where.And(a => a.SysUserId == listParam.UserId);
}
if (!listParam.Mobile.IsNullOrEmpty())
{
where = where.And(a => a.Mobile.StartsWith(listParam.Mobile));
}
if (!listParam.Email.IsNullOrEmpty())
{
where = where.And(a => a.Email.StartsWith(listParam.Email));
}
if (!listParam.RealName.IsNullOrEmpty())
{
where = where.And(a => a.RealName.StartsWith(listParam.RealName));
}
if (listParam.UserStatus != null)
{
where = where.And(a => a.UserStatus == listParam.UserStatus.Value);
}
if (listParam.UserType != null)
{
where = where.And(a => a.UserType == listParam.UserType.Value);
}
if (listParam.BeganCreateDateTime.HasValue)
{
where = where.And(a => a.CreateDateTime >= listParam.BeganCreateDateTime);
}
if (listParam.EndCreateDateTime.HasValue)
{
where = where.And(a => a.CreateDateTime <= listParam.EndCreateDateTime);
}
var result = _userService.PageList(where, pageListParam);
result.Data = ((List <SysUser>)result.Data).Select(a => new UserTableList
{
CreateDateTime = a.CreateDateTime,
Email = a.Email,
Mobile = a.Mobile,
RealName = a.RealName,
SysUserId = a.SysUserId,
UserName = a.UserName,
UserStatus = ((EUserStatus)a.UserStatus).GetDisplayName(),
UserType = ((EUserType)a.UserType).GetDisplayName()
}).ToList();
return(PageListResult(result));
}
public PageListResult PageList(Expression <Func <SysUser, bool> > expression, PageListParam pageListParam)
{
var userQueryable = _skyChenContext.SysUser.Where(expression);
var totalCount = userQueryable.Count();
var userList = userQueryable.OrderBy(a => a.CreateDateTime).ToPageList(pageListParam);
return(new PageListResult(userList, totalCount));
}
public static List <T> ToPageList <T>(this IEnumerable <T> dbContext, PageListParam pageListParam) where T : class
{
return(dbContext.Skip((pageListParam.Page - 1) * pageListParam.Limit).Take(pageListParam.Limit).ToList());
}
