Master.CanYinWu.DAL/QuestionDAL.cs

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

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

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

namespace Master.CanYinWu.DAL
{
   public class QuestionDAL
    {
        #region 项目问模块列表
        public Tuple<IList<QuestionViewModel>, int> GetList(QuestionSearch param)
        {
            StringBuilder sb = new StringBuilder(@"
                                                SELECT *
                                                FROM   (
                                                           SELECT q.Id,
                                                                  q.Title,
                                                                  pji.ShortName,
                                                                  pji.[Url],
                                                                  q.CreateTime,
                                                                  q.IsCheck,
                                                                  q.IsRec,
                                                                  (
                                                                      SELECT c.CategoryName
                                                                      FROM   Category AS c
                                                                      WHERE  c.CategoryId = pji.BigCategoryId
                                                                  )  AS BigCategoryName,
                                                                  ( SELECT c.Spell
                                                                      FROM   Category AS c
                                                                      WHERE  c.CategoryId = pji.BigCategoryId
                                                                  )  AS BigSpell,
                                                                  (
                                                                      SELECT c.CategoryName
                                                                      FROM   Category AS c
                                                                      WHERE  c.CategoryId = pji.SmallCategoryId
                                                                  )  AS SmallCategoryName,
                                                                  (
                                                                      SELECT c.Spell
                                                                      FROM   Category AS c
                                                                      WHERE  c.CategoryId = pji.SmallCategoryId
                                                                  )  AS SmallSpell,
                                                                  (
                                                                      SELECT COUNT(1)
                                                                      FROM   Answer AS a
                                                                      WHERE  a.QuestionId = q.Id
                                                                  )  AS answerCount,
                                                				   pji.BigCategoryId,
                                                				   pji.SmallCategoryId,
                                                                  ROW_NUMBER() OVER(ORDER BY q.Id DESC) AS rownumber
                                                           FROM   Question q
                                                                  left  JOIN ProjectJoinInfo AS pji
                                                                       ON  q.ProjectJoinId = pji.ProjectJoinId
                                                           WHERE    q.IsCheck IN(1,0)
                                                      ");