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