Cat.Business/Cat.Service/CrmManage/CrmProjectListProcessService.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 CrmProjectListProcessService : RepositoryFactory
   {
      #region 获取数据
      public async Task<List<CrmProjectListProcessEntity>> GetList(CrmProjectListProcessListParam param)
      {
         var expression = ListFilter(param);
         var list = await this.BaseRepository().FindList(expression);
         return list.ToList();
      }

      public async Task<List<CrmProjectListProcessEntity>> GetPageList(CrmProjectListProcessListParam param, Pagination pagination)
      {
         string strSql = @" select p.*,u.RealName as UserName
                                from CrmProjectListProcess p
                                left
                                join SysUser u on p.BaseCreatorId = u.Id
                                where 1=1 and p.BaseIsDelete=0 ";

         if (param.ProjectId.IsNotNullOrEmpty())
         {
            strSql += $"and p.ProjectId='{param.ProjectId}'";
         }
         var list = await this.BaseRepository().FindList<CrmProjectListProcessEntity>(strSql, pagination);
         return list.ToList();
      }

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

      #region 提交数据
      public async Task SaveForm(CrmProjectListProcessEntity entity)
      {
         if (entity.Id.IsNullOrZero())
         {
            entity.Create();