Beispiel #1
0
        /// <summary>
        ///     获取文章分页
        /// </summary>
        /// <param name="param"></param>
        /// <returns></returns>
        public Task <PagedResultsDto <SystemArticleOutput> > GetPagingArticleType(SystemArticlePagingInput param)
        {
            string sWhere = "";

            if (!string.IsNullOrWhiteSpace(param.Title))
            {
                sWhere += $" And Title like '%{param.Title.Trim()}%'";
            }
            string sql = @"select article.*,articletype.Name ArticleTypeName
                            from Sys_Article article
                            left join Sys_ArticleType articletype on article.ArticleTypeId=articletype.ArticleTypeId
                              Where 1=1 " + sWhere;

            return(SqlMapperUtil.PagingQuery <SystemArticleOutput>(sql, param));;
        }
 public async Task <JsonResult> GetPagingArticle(SystemArticlePagingInput param)
 {
     return(JsonForGridPaging(await _systemArticleLogic.GetPagingArticle(param)));
 }
Beispiel #3
0
 /// <summary>
 ///     获取文章分页
 /// </summary>
 /// <param name="param"></param>
 /// <returns></returns>
 public Task <PagedResults <SystemArticleOutput> > GetPagingArticle(SystemArticlePagingInput param)
 {
     return(_systemArticleRepository.GetPagingArticleType(param));
 }