Cat.Business/Cat.Service/CrmManage/CrmProjectService.cs

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

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

using System;
using System.Linq;
using System.Text;
using System.Data.Common;
using System.Linq.Expressions;
using System.Collections.Generic;
using System.Threading.Tasks;
using Cat.Util;
using Cat.Util.Extension;
using Cat.Util.Model;
using Cat.Data;
using Cat.Data.Repository;
using Cat.Entity.CrmManage;
using Cat.Model.Param.CrmManage;

namespace Cat.Service.CrmManage
{
   /// <summary>
   /// 创 建：admin
   /// 日 期：2021-01-28 18:53
   /// 描 述：CRM项目管理服务类
   /// </summary>
   public class CrmProjectService : RepositoryFactory
   {
      #region 获取数据
      public async Task<List<CrmProjectEntity>> GetList(CrmProjectListParam param)
      {
         var expression = ListFilter(param);
         var list = await this.BaseRepository().FindList(expression);
         return list.ToList();
      }

      public async Task<List<CrmProjectEntity>> GetPageList(CrmProjectListParam param, Pagination pagination)
      {
         string strSql = @" select p.Id,p.ProjectName,p.ProjectDate,p.CustomerName,p.Amount,p.Memo,p.BaseCreateTime,u.RealName as HandlerName
                                from CrmProject p
                                left join SysUser u on p.HandlerId=u.Id
                                where 1=1 and p.BaseIsDelete=0 ";

         if (param.ProjectName.IsNotNullOrEmpty())
         {
            strSql += $"and p.ProjectName like '%{param.ProjectName.Trim()}%' ";
         }
         if (param.CustomerName.IsNotNullOrEmpty())
         {
            strSql += $"and p.CustomerName like '%{param.CustomerName.Trim()}%'";
         }
         if (param.UserName.IsNotNullOrEmpty())
         {
            strSql += $"and u.RealName like '%{param.UserName.Trim()}%'";
         }

         var list = await this.BaseRepository().FindList<CrmProjectEntity>(strSql, pagination);
         return list.ToList();
      }

      public async Task<CrmProjectEntity> GetEntity(long id)
      {
         return await this.BaseRepository().FindEntity<CrmProjectEntity>(id);
      }