Master.CanYinWu.DAL/Customer/CustomerDAL.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.Utility;

namespace Master.CanYinWu.DAL.Customer
{
  public  class CustomerDAL
    {
        #region 分类列表
        /// <summary>
        /// 分类列表
        /// </summary>
        /// <param name="pageIndex"></param>
        /// <param name="pageSize"></param>
        /// <param name="key"></param>
        /// <param name="bigCategoryId">行业分类Id</param>
        /// <returns></returns>
        public async Task<Tuple<IEnumerable<Entity.Customer>, int>> GetCustomerList(int pageIndex, int pageSize, string userName, string commpanyName,string  tel,int? customerType  ,int IsCheck= 0)
        {
            StringBuilder sb = new StringBuilder($@" select a.* from(
                            SELECT ROW_NUMBER() over (order by CustomerId desc) as  rownumber,
                                   c.CustomerId,
                                   c.LoginName,
                                   c.BusinessLicense,
                                   c.CompanyName,
                                   c.Email,
                                   c.LastLoginIP,
                                   c.RegisterIP,
                                   c.CheckResultRemark,
                                   c.LastLoginTime,
                                   c.CreateTime,
                                   c.ExpireTime,
                                   c.QQ,
                                   c.Tel,
                                   (
                                       SELECT pji.ShortName
                                       FROM   ProjectJoinInfo AS pji WITH (NOLOCK)
                                       WHERE  c.ProjectJoinInId = pji.ProjectJoinId
                                   )AS ShortName,
                                   (SELECT a.UserName 
                                      FROM  [admin]  AS a WITH (NOLOCK) WHERE a.IsDel=0 AND a.AdminId=c.adminid) AS Leader,
   (SELECT  cl.TypeName  FROM CustomerTypeLevel AS cl WITH (NOLOCK)  WHERE cl.CustomerTypeLevelId=c.CustomerTypeLevelId) AS  TypeName
                            FROM   Customer AS c WITH(NOLOCK)
                            WHERE  c.IsDelete = 0 and c.IsCheck={IsCheck}");
            DynamicParameters dp = new DynamicParameters();
            dp.Add("PageIndex", pageIndex);
            dp.Add("PageSize", pageSize);
            StringBuilder sqlTotal = new StringBuilder(@"select count(1)  from Customer where IsDelete =0");
            DynamicParameters dpTotal = new DynamicParameters();
            if (!string.IsNullOrEmpty(commpanyName))
            {
                sb.Append(" and CompanyName=@CompanyName ");
                sqlTotal.Append(" and CompanyName=@CompanyName ");
                dp.Add("CompanyName", commpanyName);
                dpTotal.Add("CompanyName", commpanyName);