Master.CanYinWu.DAL/MessageDAL.cs

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

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

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

namespace Master.CanYinWu.DAL
{
    public class MessageDAL
    {
        private IDbConnection conn;

        #region 留言列表
        /// <summary>
        /// 留言列表
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="key">加盟项目名称</param>
        /// <param name="realName">会员名</param>
        /// <param name="bigCategoryId">行业分类Id</param>
        /// <param name="smallCategoryId">行业二级分类Id</param>
        /// <returns></returns>
        public async Task<Tuple<IEnumerable<MessageViewModel>, int>> GetList(int pageIndex, int pageSize, string key, string realName = "", int bigCategoryId = 0, int smallCategoryId = 0, int fromType = 0, DateTime? dateStart = null, DateTime? dateEnd = null, int? adminId = 0)
        {
            StringBuilder sb = new StringBuilder(@"
                                  SELECT tab.* 
   	                                FROM   (
   	                                       SELECT m.MessageId,
   	                                              m.CreateDate,
   	                                              m.RealName,
   	                                              m.FromType,
   	                                              m.tel,
                                                  m.CompanyName,
   	                                              m.MessageContent,
                                                  m.JoinProjectId,
                                                  m.ProjectJoinName,
                                                  m.Email,
                                                  m.Remark,
                                                  m.Sex,
                                                  m.IPProvince,
                                                  m.IPCity,
                                                  m.UserIp,
                                                   (
   	                                                  SELECT c.Spell
   	                                                  FROM   Category AS c	 WITH(NOLOCK)
   	                                                  WHERE  c.CategoryId = m.BigCategoryId
   	                                                         AND c.ParentId = 0
   	                                              )	 AS BigSpell,
                                                   (
   	                                                  SELECT c.Spell
   	                                                  FROM   Category AS c	 WITH(NOLOCK)
   	                                                  WHERE  c.CategoryId = m.SmallCategoryId
   	                                                         AND c.ParentId <> 0