/// <summary> /// 查询数据 /// </summary> /// <returns></returns> public ActionResult CollocationList(string collocationName, bool isEnabled = true, int pageIndex = 1, int pageSize = 10) { var memberId = _adminContract.GetMemberId(AuthorityHelper.OperatorId.Value); var query = _memberCollocationContract.MemberCollocations.Where(e => e.MemberId == memberId); query = query.Where(e => e.IsEnabled == isEnabled); if (!string.IsNullOrEmpty(collocationName) && collocationName.Length > 0) { query = query.Where(e => e.CollocationName.StartsWith(collocationName)); } string strApiUrl = ConfigurationHelper.GetAppSetting("ApiUrl"); var elementQuery = _memberColloEleContract.MemberColloEles.Where(e => !e.IsDeleted && e.IsEnabled) .Where(e => !e.ParentId.HasValue); var joinQuery = query.Join(elementQuery, m => m.Id, e => e.MemberColloId.Value, (m, e) => new { m.Id, m.IsDeleted, m.IsEnabled, m.UpdatedTime, m.CollocationName, ImagePath = strApiUrl + e.ImagePath, IsChecked = false }); var list = joinQuery .OrderByDescending(e => e.UpdatedTime) .Skip((pageIndex - 1) * pageSize) .Take(pageSize) .ToList(); var res = new OperationResult(OperationResultType.Success, string.Empty, new { pageData = list, pageInfo = new PageDto { pageIndex = pageIndex, pageSize = pageSize, totalCount = joinQuery.Count(), } }); return(Json(res, JsonRequestBehavior.AllowGet)); }