public ApiPageResponse <List <BlogPosts> > Search([FromBody] BlogPostsPageVO dto) { try { ApiPageResponse <List <BlogPosts> > result = new ApiPageResponse <List <BlogPosts> >(); dto.SortValue = "CreateTime DESC"; var lst = _blogPostsService.QueryPageblog(dto); if (lst != null) { result = new ApiPageResponse <List <BlogPosts> >(ApiResponse <List <BlogPosts> > .ResponseSucceed(lst)); result.PageIndex = dto.PageIndex; result.PageSize = dto.PageSize; result.TotalCount = dto.TotalCount; } else { result = new ApiPageResponse <List <BlogPosts> >(ApiResponse <List <BlogPosts> > .ResponseFailed(StatusCodeEnum.ERROR)); } return(result); } catch (Exception ex) { _logger.LogError(ex, "分页搜索异常"); return(new ApiPageResponse <List <BlogPosts> >(ApiResponse <List <BlogPosts> > .ResponseFailed(StatusCodeEnum.ERROR, ex.Message))); } }
/// <summary> /// 根据时间分页查询-首页显示 /// </summary> /// <param name="pageVO"></param> /// <returns></returns> public List <BlogPosts> QueryPageblog(BlogPostsPageVO pageVO) { IPageInfo page = pageVO; string sqlCount = "SELECT COUNT(BlogPostsNo) FROM BlogPosts WITH(NOLOCK) WHERE DataState = @DataState "; string sqlRecord = "SELECT BlogPostsNo FROM BlogPosts WITH(NOLOCK) WHERE DataState = @DataState "; var para = new DynamicParameters(); para.Add("DataState", (byte)DataStateEnum.NORMAL); IEnumerable <BlogPosts> blogs = null; using (IDbConnection dbConnection = CreateConnection(ConnectionNameConstant.PersonalBlog_READ)) { blogs = PageProvider.PageQuery <BlogPosts>(ref page, sqlCount, sqlRecord, dbConnection); if (blogs == null) { return(null); } else { return(blogs.ToList()); } } }
/// <summary> /// 分页查询-首页显示 /// </summary> /// <param name="pageVO"></param> /// <returns></returns> public List <BlogPosts> QueryPageblog(BlogPostsPageVO pageVO) { List <BlogPosts> blogPosts = _blogPostsProvider.QueryPageblog(pageVO); return(blogPosts); }