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