Master.CanYinWu.DAL/TimeArticleDAL.cs

这里只显示每个文件的开头 60 行。登录后可以解锁完整代码。

微信扫码关注公众号，代码整理好后第一时间通知你。

using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using System.Threading.Tasks;
using Master.CanYinWu.Entity;
using Master.CanYinWu.Utility;

namespace Master.CanYinWu.DAL
{
 public   class TimeArticleDAL
    {
        #region 定时文章列表
        /// <summary>
        /// 定时文章列表
        /// </summary>       
        public Tuple<IList<TimeArticle>, int> GetList(int pageIndex, int pageSize, string key, string articleAttribute = null, int articleColumnId = 0)
        {
            StringBuilder sb = new StringBuilder(@"
                                                SELECT * FROM(
                                                SELECT tab.ArticleInfoId,
                                                       tab.ArticleTitle,
                                                       tab.SimpleTitle,
                                                       tab.Weight,
                                                       tab.Thumbnail,
                                                       tab.Author,
                                                       tab.CreateTime,
                                                       tab.ArticleAttribute,
                                                       tab.TAG,
                                                       tab.TimingTime,
                                                       (
                                                           SELECT URL
                                                           FROM   ArticleColumn AS atc
                                                           WHERE  atc.ArticleColumnId = tab.ArticleColumnParentId
                                                       )  AS URL,
                                                       (
                                                           SELECT ColumnName
                                                           FROM   ArticleColumn AS atc
                                                           WHERE  atc.ArticleColumnId = tab.ArticleColumnParentId
                                                       )  AS ColumnParentName,  
                                                       tab.IsCheck,     
                                                   ROW_NUMBER() OVER(ORDER BY ArticleInfoId DESC) AS        rownumber
                                                                       
                                                  FROM   TimeArticle AS tab	 WHERE tab.isdelete=0
                                                 ");
            StringBuilder sqlTotal = new StringBuilder(@"select count(1)  from TimeArticle where IsDelete =0");          
            DynamicParameters dp = new DynamicParameters();
            dp.Add("PageIndex", pageIndex);
            dp.Add("PageSize", pageSize);

            DynamicParameters dpTotal = new DynamicParameters();
            if (!string.IsNullOrEmpty(key))
            {
                sb.Append(" and ArticleTitle like '%'+@Key+'%' ");
                sqlTotal.Append(" and ArticleTitle like '%'+@Key+'%' ");
                dp.Add("Key", key);
                dpTotal.Add("Key", key);
            }