Master.CanYinWu.DAL/AnswerDAL.cs

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

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

using Dapper;
using System;
using System.Collections.Generic;
using System.Data;
using System.Linq;
using System.Text;
using Master.CanYinWu.Entity;
using Master.CanYinWu.Entity.Param;
using Master.CanYinWu.Entity.ViewModel;
using Master.CanYinWu.Utility;

namespace Master.CanYinWu.DAL
{
    public class AnswerDAL
    {
        #region 项目答案内容列表
        public Tuple<IList<Answer>, int> GetAnswerList(AnswerSearch param)
        {
            StringBuilder sb = new StringBuilder(@"
                                            select * from( SELECT a.Id,
                                                   a.QuestionId,
                                                   a.[Content],
                                                   a.CreateTime,
                                                   a.isRec,
                                                   a.IsCheck,
                                                   ROW_NUMBER() OVER(ORDER BY a.CreateTime DESC) AS rownumber
                                            FROM   Answer AS a
                                            WHERE  a.Ischeck in(1,0)
                                                   ");

            DynamicParameters dp = new DynamicParameters();
            dp.Add("PageIndex", param.PageIndex);
            dp.Add("PageSize", param.PageSize);
            StringBuilder sqlTotal = new StringBuilder(@"SELECT COUNT(1)
                                                        FROM   Answer AS a
                                                        WHERE  a.Ischeck in(1,0)                                                            
                                                        ");
            DynamicParameters dpTotal = new DynamicParameters();
            if (!string.IsNullOrEmpty(param.Content))
            {
                sb.Append(" and a.Content like '%'+@Content+'%' ");
                dp.Add("Content", param.Content);
                sqlTotal.Append(" and a.Content like '%'+@Content+'%' ");
                dpTotal.Add("Content", param.Content);
            }
            if (param.QuestionId.HasValue)
            {
                sb.Append(" and a.QuestionId=@QuestionId ");
                dp.Add("QuestionId", param.QuestionId);
                sqlTotal.Append(" and a.QuestionId=@QuestionId");
                dpTotal.Add("QuestionId", param.QuestionId);
            }
            sb.Append(" ) AS tab where tab.rownumber BETWEEN (((@PageIndex-1)*@PageSize)+1) and @PageIndex*@PageSize ");
            using (var conn = ConnectionFactory.Connection())
            {
                var query = conn.Query<Answer>(sb.ToString(), dp).ToList();
                var total = conn.ExecuteScalar<int>(sqlTotal.ToString(), dpTotal);
                return new Tuple<IList<Answer>, int>(query, total);
            }
        }