Cat.Business/Cat.Service/WorkFLowManage/WfInstanceService.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.WorkFLowManage;
using Cat.Model.Param.WorkFLowManage;
using Cat.Web.Code;

namespace Cat.Service.WorkFLowManage
{
    /// <summary>
    /// 创 建：admin
    /// 日 期：2021-05-11 19:02
    /// 描 述：流程实例服务类
    /// </summary>
    public class WfInstanceService :  RepositoryFactory
    {
        #region 获取数据
        public async Task<List<WfInstanceEntity>> GetList(WfInstanceListParam param)
        {
            var expression = ListFilter(param);
            var list = await this.BaseRepository().FindList(expression);
            return list.ToList();
        }

        public async Task<List<WfInstanceEntity>> GetPageList(WfInstanceListParam param, Pagination pagination)
        {
            string strSql = @"select w.*,u.RealName as CreatorName,m.MenuName,m.MenuUrl,h.BaseCreateTime as FinishDate 
                                from WfInstance w
                                left join SysUser u on w.BaseCreatorId=u.Id 
                                left join SysMenu m on w.MenuId=m.Id
                                left join WfHistory h on h.InstanceId=w.Id and NodeName='结束'
                                where 1=1 ";
            if (param.FlowName.IsNotNullOrEmpty())
            {
                strSql += $"and w.FlowName like '%{param.FlowName.Trim()}%' ";
            }
            if (param.UserName.IsNotNullOrEmpty())
            {
                strSql += $"and u.RealName like '%{param.UserName.Trim()}%' ";
            }
            if (param.IsFinish>-1)
            {
                strSql += $"and w.IsFinish='{param.IsFinish}' ";
            }
            var list = await this.BaseRepository().FindList<WfInstanceEntity>(strSql, pagination);
            return list.ToList();
        }

        public async Task<List<WfInstanceEntity>> GetMyStartFlowList(WfInstanceListParam param, Pagination pagination)
        {
            string strSql = @" select i.*,m.MenuName,m.MenuUrl,h.BaseCreateTime as FinishDate