/// <summary> /// 删除一个流程模板 /// </summary> /// <param name="workflowId">流程模板Id</param> /// <returns></returns> public int DeleteWorkFlow(string workflowId) { int returnInt = -1; if (workflowId.Trim().Length == 0 || workflowId == null) { throw new Exception("DeleteWorkFlow方法错误,workflowId 不能为空!"); } try { //1、存储过程方式删除流程模板 //returnInt = this.DBProvider.ExecuteProcedure("DeleteWorkFlow", new IDbDataParameter[] { DBProvider.MakeParameter(WorkFlowTemplateTable.FieldWorkFlowId, workflowId) }); /* * 删除的各语句 * DELETE WORKFLOW WHERE WORKFLOWID = @WORKFLOWID * DELETE WORKTASK WHERE WORKFLOWID = @WORKFLOWID * DELETE WORKLINK WHERE WORKFLOWID = @WORKFLOWID * DELETE TASKVAR WHERE WORKFLOWID = @WORKFLOWID * DELETE OPERATOR WHERE WORKFLOWID = @WORKFLOWID * DELETE WORKTASKCOMMANDS WHERE WORKFLOWID = @WORKFLOWID * DELETE SUBWORKFLOW WHERE WORKFLOWID = @WORKFLOWID * DELETE WORKTASKCONTROLS WHERE WORKFLOWID = @WORKFLOWID * DELETE WORKFLOWEVENT WHERE WORKFLOWID = @WORKFLOWID * DELETE WORKOUTTIME WHERE WORKFLOWID = @WORKFLOWID */ //2、直接语句方式删除流程模板 //2.1、删除流程模板 returnInt += new WorkFlowTemplateManager(DBProvider, this.UserInfo, WorkFlowTemplateTable.TableName).Delete(WorkFlowTemplateTable.FieldWorkFlowId, workflowId); //2.2、删除任务节点 returnInt += new WorkTaskManager(DBProvider, this.UserInfo, WorkFlowTemplateTable.TableName).Delete(WorkTaskTable.FieldWorkFlowId, workflowId); //2.3、删除连线 returnInt += new WorkLinkManager(DBProvider, this.UserInfo, WorkLinkTable.TableName).Delete(WorkLinkTable.FieldWorkFlowId, workflowId); //2.4、删除任务节点变量 returnInt += new TaskVarManager(DBProvider, this.UserInfo, TaskVarTable.TableName).Delete(TaskVarTable.FieldWorkFlowId, workflowId); //2.5、删除操作者 returnInt += new OperatorManager(DBProvider, this.UserInfo, OperatorTable.TableName).Delete(OperatorTable.FieldWorkFlowId, workflowId); //2.5、删除任务节点命令 returnInt += new WorkTaskCommandsManager(DBProvider, this.UserInfo, WorkTaskCommandsTable.TableName).Delete(WorkTaskCommandsTable.FieldWorkFlowId, workflowId); //2.6、删除子流程 returnInt += new SubWorkFlowManager(DBProvider, this.UserInfo, SubWorkFlowTable.TableName).Delete(SubWorkFlowTable.FieldWorkFlowId, workflowId); //2.7、删除任务节点表单 returnInt += new WorkTaskControlsManager(DBProvider, this.UserInfo, WorkTaskControlsTable.TableName).Delete(WorkTaskControlsTable.FieldWorkflowId, workflowId); //2.8、删除任务节点事件通知 returnInt += new WorkFlowEventManager(DBProvider, this.UserInfo, WorkFlowEventTable.TableName).Delete(WorkFlowEventTable.FieldWorkFlowId, workflowId); //2.9、删除任务节点工作任务超时设置 returnInt += new WorkOutTimeManager(DBProvider, this.UserInfo, WorkOutTimeTable.TableName).Delete(WorkOutTimeTable.FieldWorkFlowId, workflowId); } catch (Exception ex) { throw new Exception("BizLogicError:删除流程失败,请与管理员联系!Error:" + ex.Message); } return(returnInt); }
/// <summary> /// 获得流程的所有子流程 /// </summary> /// <param name="userInfo">用户</param> /// <param name="workFlowId">流程模版Id</param> /// <returns>指定流程的所有子流程列表</returns> public DataTable GetWorkFlowAllSub(UserInfo userInfo, string workFlowId) { var parameter = ParameterUtil.CreateWithOutMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName); var dataTable = new DataTable(TaskVarTable.TableName); ServiceUtil.ProcessWorkFlowDb(userInfo, parameter, dbProvider => { var manager = new SubWorkFlowManager(dbProvider, userInfo); dataTable = manager.GetWorkflowAllSub(workFlowId); }); return(dataTable); }
/// <summary> /// 删除子流程节点配置 /// </summary> /// <param name="userInfo">用户</param> ///<param name="workFlowId">流程模版主键</param> /// <param name="taskId">任务模版主键</param> /// <returns>大于0成功</returns> public int DeleteSubWorkFlow(UserInfo userInfo, string workFlowId, string taskId) { var returnValue = -1; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.WorkFlowUserControlService_DeleteSubWorkFlow); ServiceUtil.ProcessWorkFlowDbWithTransaction(userInfo, parameter, dbProvider => { var manager = new SubWorkFlowManager(dbProvider, userInfo); returnValue = manager.DeleteSubWorkFlow(workFlowId, taskId); }); return(returnValue); }
/// <summary> /// 增加子流程节点配置 /// </summary> /// <param name="userInfo">用户</param> /// <param name="entity">子流程节点配置实体</param> /// <returns>增加成功返回实体主键</returns> public string InsertSubWorkFlow(UserInfo userInfo, SubWorkFlowEntity entity) { var returnValue = string.Empty; var parameter = ParameterUtil.CreateWithMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName, RDIFrameworkMessage.WorkFlowUserControlService_InsertSubWorkFlow); ServiceUtil.ProcessWorkFlowDbWithTransaction(userInfo, parameter, dbProvider => { var manager = new SubWorkFlowManager(dbProvider, userInfo); returnValue = manager.InsertSubWorkFlow(entity); }); return(returnValue); }
/// <summary> /// 判断子流程配置信息是否存在 /// </summary> /// <param name="userInfo">用户</param> ///<param name="subId">子流程主键</param> /// <returns>true存在</returns> public bool ExistsSubWorkFlowBySubId(UserInfo userInfo, string subId) { var returnValue = false; var parameter = ParameterUtil.CreateWithOutMessage(userInfo, MethodBase.GetCurrentMethod(), this.serviceName); ServiceUtil.ProcessWorkFlowDbWithTransaction(userInfo, parameter, dbProvider => { var manager = new SubWorkFlowManager(dbProvider, userInfo); returnValue = manager.Exists(subId); }); return(returnValue); }
/// <summary> /// 创建所有符合条件的任务实例 /// </summary> /// <param name="userId">处理人Id</param> /// <param name="workFlowId">工作流模板id</param> /// <param name="workTaskId">当前任务Id</param> /// <param name="workFlowInstanceId">工作流实例Id</param> /// <param name="workTaskInstanceId">原任务实例Id</param> /// <param name="operatorInstanceId">处理者实例Id</param> /// <param name="commandName">命令</param> /// <returns> /// 000002:没有配置后续任务 /// 000000:操作成功 /// </returns> public string CreateNextTaskInstance(string userId, string workFlowId, string workTaskId, string workFlowInstanceId, string workTaskInstanceId, string operatorInstanceId, string commandName) { var userName = new PiUserManager(DbFactoryProvider.GetProvider(SystemInfo.RDIFrameworkDbType, SystemInfo.RDIFrameworkDbConectionString), this.UserInfo).GetEntity(userId).UserName; var dt = GetLineEndTasks(workFlowId, workTaskId, commandName); if (dt != null && dt.Rows.Count > 0) { var condition = ""; //条件 var priority = ""; //优先级,只执行优先级最高的分支,如果优先级相同 那么同时执行。 var endTaskId = ""; //后续任务节点Id var endoperRule = ""; //新任务处理者策略 var startoperRule = ""; //当前任务处理者策略 var taskType = ""; //节点类型 var endTaskTypeAndOr = ""; //控制节点专用,表示and/or var operParam = new OperParameter(); //创建处理者参数 #region 配置了后续节点 var l = dt.Rows.Count; var branchPriority = dt.Rows[0]["PRIORITY"].ToString();//优先级 //遍历满足条件的所有任务节点 for (var i = 0; i < l; i++) { var dr = dt.Rows[i]; condition = dr["CONDITION"].ToString(); priority = dr["PRIORITY"].ToString(); endTaskId = dr["ENDTASKID"].ToString(); endoperRule = dr["ENDOPERRULE"].ToString(); startoperRule = dr["STARTOPERRULE"].ToString(); taskType = dr["ENDTASKTYPEID"].ToString(); endTaskTypeAndOr = dr["ENDTASKTYPEANDOR"].ToString(); operParam.OperRule = endoperRule; operParam.IsJumpSelf = Convert.ToBoolean(dr["ISJUMPSELF"]); if (priority != branchPriority) { break; //只执行优先级最高的分支 } if (ExpressPass(userId, workFlowId, workTaskId, workFlowInstanceId, workTaskInstanceId, condition)) //满足条件的任务节点 { switch (taskType) { case "2": //结束节点 { #region 结束节点 //产生一个结束节点的实例 var newEndTaskId = BusinessLogic.NewGuid(); //新任务处理者实例Id var endWorktaskIns = new WorkTaskInstanceEntity { WorkFlowId = workFlowId, WorkTaskId = endTaskId, WorkFlowInsId = workFlowInstanceId, WorkTaskInsId = newEndTaskId, PreviousTaskId = workTaskInstanceId, TaskInsCaption = new WorkTaskManager(this.DBProvider, this.UserInfo).GetTaskCaption(endTaskId), Status = "2"//结束节点不需要再处理,但此处不能为3,设置结束实例会修改该值=3 }; new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).Create(endWorktaskIns); //设置处理者实例正常结束 new OperatorInstanceManager(this.DBProvider, this.UserInfo).SetOperatorInstanceOver(userId, operatorInstanceId); //设置任务实例正常结束 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetWorkTaskInstanceOver(userName, workTaskInstanceId); new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetWorkTaskInstanceOver(userName, newEndTaskId); //结束节点实例 结束 //设置流程实例正常结束 new WorkFlowInstanceManager(this.DBProvider, this.UserInfo).SetWorkflowInstanceOver(workFlowInstanceId); //设定流程实例的当前位置 new WorkFlowInstanceManager(this.DBProvider, this.UserInfo).SetCurrTaskId(workFlowInstanceId, endTaskId); new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetSuccessMsg(WorkFlowConst.WorkflowOverMsg, workTaskInstanceId); //结束节点单独处理,任务提交给谁了 //检查是否子流程调用 DataTable operInfo = new WorkFlowInstanceManager(this.DBProvider, this.UserInfo).GetWorkflowInstance(workFlowInstanceId); if (operInfo != null && operInfo.Rows.Count > 0) { var isSubWorkflow = false; //是否是子流程调用 var mainWorkflowInsId = ""; var mainWorktaskId = ""; var mainWorkflowId = ""; var mainWorktaskInsId = ""; isSubWorkflow = BusinessLogic.ConvertIntToBoolean(operInfo.Rows[0][WorkFlowInstanceTable.FieldIsSubWorkflow]); mainWorkflowInsId = operInfo.Rows[0][WorkFlowInstanceTable.FieldMainWorkflowInsId].ToString(); //主流程实例Id mainWorktaskId = operInfo.Rows[0][WorkFlowInstanceTable.FieldMainWorktaskId].ToString(); //子流程节点模板Id mainWorkflowId = operInfo.Rows[0][WorkFlowInstanceTable.FieldMainWorkflowId].ToString(); //主流程模板Id mainWorktaskInsId = operInfo.Rows[0][WorkFlowInstanceTable.FieldMainWorktaskInsId].ToString(); //主任务实例Id,进入子节点前的任务节点实例 if (isSubWorkflow) { //创建一个子流程节点实例痕迹,表示子流程节点处理完成 var newTaskId = BusinessLogic.NewGuid(); //新任务处理者实例Id var workTaskInstance = new WorkTaskInstanceEntity { WorkFlowId = mainWorkflowId, WorkTaskId = mainWorktaskId, WorkFlowInsId = mainWorkflowInsId, WorkTaskInsId = newTaskId, PreviousTaskId = mainWorktaskInsId, TaskInsCaption = "子流程", Status = "3" }; new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).Create(workTaskInstance); var result = CreateNextTaskInstance(userId, mainWorkflowId, mainWorktaskId, mainWorkflowInsId, newTaskId, operatorInstanceId, "提交"); if (result != WorkFlowConst.SuccessCode) { return(result); } } } #endregion break; } case "3": { #region 交互节点 switch (endoperRule) { case "1": { //创建一个任务实例 var newTaskId = BusinessLogic.NewGuid(); //新任务处理者实例Id var workTaskInstance = new WorkTaskInstanceEntity { WorkFlowId = workFlowId, WorkTaskId = endTaskId, WorkFlowInsId = workFlowInstanceId, WorkTaskInsId = newTaskId, PreviousTaskId = workTaskInstanceId, TaskInsCaption = new WorkTaskManager(this.DBProvider, this.UserInfo).GetTaskCaption(endTaskId), Status = "1" }; new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).Create(workTaskInstance); //创建多个处理人 var result = CreateOperInstance(userId, workTaskInstanceId, workTaskId, workFlowId, endTaskId, workFlowInstanceId, newTaskId, operParam); //创建处理者实例 if (result != WorkFlowConst.SuccessCode) { return(result); } } break; case "2": { //创建任务实例和处理人 var result = CreateOperInstance(userId, workTaskInstanceId, workTaskId, workFlowId, endTaskId, workFlowInstanceId, workTaskInstanceId, operParam); if (result != WorkFlowConst.SuccessCode) { return(result); } } break; } //设置处理者实例正常结束 new OperatorInstanceManager(this.DBProvider, this.UserInfo).SetOperatorInstanceOver(userId, operatorInstanceId); //设置任务实例正常结束 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetWorkTaskInstanceOver(userName, workTaskInstanceId); //设定流程实例的当前位置 new WorkFlowInstanceManager(this.DBProvider, this.UserInfo).SetCurrTaskId(workFlowInstanceId, endTaskId); //设定任务实例成功提交信息 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetSuccessMsg(WorkFlowConst.SuccessMsg, workTaskInstanceId); #endregion break; } case "4": //控制节点 { #region 控制节点 //设置处理者实例正常结束 new OperatorInstanceManager(this.DBProvider, this.UserInfo).SetOperatorInstanceOver(userId, operatorInstanceId); //设置任务实例正常结束 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetWorkTaskInstanceOver(userName, workTaskInstanceId); //设定流程实例的当前位置 new WorkFlowInstanceManager(this.DBProvider, this.UserInfo).SetCurrTaskId(workFlowInstanceId, endTaskId); //设定任务实例成功提交信息 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetSuccessMsg(WorkFlowConst.SuccessMsg, workTaskInstanceId); //******start检查判断节点前面的所以节点的任务实例是否都完成 //取控制节点前端所以节点,进行逐个判断 var dtstart = GetLineStartTasks(workFlowId, endTaskId); var allPass = true; //全部通过 foreach (DataRow dr1 in dtstart.Rows) { var taskId = dr1["STARTTASKID"].ToString(); if (endTaskTypeAndOr == WorkConst.Command_Or) //or分支 { if (IsPassJudge(workFlowId, workFlowInstanceId, taskId, endTaskTypeAndOr)) //判断每个节点实例是否完成 { allPass = true; break; //如果有一个通过即可。 } allPass = false; } else //and分支 { if (!IsPassJudge(workFlowId, workFlowInstanceId, taskId, endTaskTypeAndOr)) //判断每个节点实例是否完成 { allPass = false; break; //如果有一个未完成的,不产生新的实例,流程等待。 } } } //********end检查判断节点前面的所以节点的任务实例结束 //如果判断节点前面的流程实例全部完成,自动进行递归,创建下一任务实例。 if (allPass) { //创建一个判断节点实例 var newTaskId = BusinessLogic.NewGuid(); //新任务处理者实例Id var workTaskInstance = new WorkTaskInstanceEntity { WorkFlowId = workFlowId, WorkTaskId = endTaskId, WorkFlowInsId = workFlowInstanceId, WorkTaskInsId = newTaskId, PreviousTaskId = workTaskInstanceId, TaskInsCaption = endTaskTypeAndOr, Status = "3" }; new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).Create(workTaskInstance); var result = CreateNextTaskInstance(userId, workFlowId, endTaskId, workFlowInstanceId, newTaskId, operatorInstanceId, "提交"); if (result != WorkFlowConst.SuccessCode) { return(result); } } #endregion break; } case "5": //查看节点 { #region 查看节点 switch (endoperRule) { case "1": { //创建一个任务实例 var newTaskId = BusinessLogic.NewGuid(); //新任务处理者实例Id var workTaskInstance = new WorkTaskInstanceEntity { WorkFlowId = workFlowId, WorkTaskId = endTaskId, WorkFlowInsId = workFlowInstanceId, WorkTaskInsId = newTaskId, PreviousTaskId = workTaskInstanceId, TaskInsCaption = new WorkTaskManager(this.DBProvider, this.UserInfo).GetTaskCaption(endTaskId), Status = "1" }; new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).Create(workTaskInstance); //创建多个处理人 var result = CreateOperInstance(userId, workTaskInstanceId, workTaskId, workFlowId, endTaskId, workFlowInstanceId, newTaskId, operParam); //创建任务实例 if (result != WorkFlowConst.SuccessCode) { return(result); } } break; case "2": { //创建任务实例和处理人 var result = CreateOperInstance(userId, workTaskInstanceId, workTaskId, workFlowId, endTaskId, workFlowInstanceId, workTaskInstanceId, operParam); if (result != WorkFlowConst.SuccessCode) { return(result); } } break; } //设置处理者实例正常结束 new OperatorInstanceManager(this.DBProvider, this.UserInfo).SetOperatorInstanceOver(userId, operatorInstanceId); //设置任务实例正常结束 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetWorkTaskInstanceOver(userName, workTaskInstanceId); //设定流程实例的当前位置 new WorkFlowInstanceManager(this.DBProvider, this.UserInfo).SetCurrTaskId(workFlowInstanceId, endTaskId); //设定任务实例成功提交信息 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetSuccessMsg(WorkFlowConst.SuccessMsg, workTaskInstanceId); #endregion break; } case "6": //子流程节点 { #region 子流程节点 var subWf = new SubWorkFlowManager(this.DBProvider, this.UserInfo).GetSubWorkflowTable(workFlowId, endTaskId); if (subWf != null && subWf.Rows.Count > 0) { var subWorkflowId = subWf.Rows[0][SubWorkFlowTable.FieldSubWorkFlowId].ToString(); var subStartTaskId = subWf.Rows[0][SubWorkFlowTable.FieldSubStartTaskId].ToString(); var subWorkflowCaption = subWf.Rows[0][SubWorkFlowTable.FieldSubWorkFlowCaption].ToString(); //*******进入子流程 var wfruntime = new WorkFlowRuntime { UserId = userId, WorkFlowId = subWorkflowId, WorkTaskId = subStartTaskId, WorkFlowInstanceId = BusinessLogic.NewGuid(), WorkTaskInstanceId = BusinessLogic.NewGuid(), IsSubWorkflow = true, MainWorkflowId = workFlowId, MainWorkflowInsId = workFlowInstanceId, MainWorktaskId = endTaskId, MainWorktaskInsId = workTaskInstanceId, //记录进入子流程之前的任务实例 WorkFlowNo = "subWorkflow", CommandName = "提交", WorkflowInsCaption = subWorkflowCaption, IsDraft = true//开始节点需要交互,草稿状态,暂不提交 }; wfruntime.Start(); //设置处理者实例正常结束 new OperatorInstanceManager(this.DBProvider, this.UserInfo).SetOperatorInstanceOver(userId, operatorInstanceId); //设置任务实例正常结束 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetWorkTaskInstanceOver(userName, workTaskInstanceId); //设定流程实例的当前位置 new WorkFlowInstanceManager(this.DBProvider, this.UserInfo).SetCurrTaskId(workFlowInstanceId, endTaskId); //设定任务实例成功提交信息 new WorkTaskInstanceManager(this.DBProvider, this.UserInfo).SetSuccessMsg(WorkFlowConst.SuccessMsg, workTaskInstanceId); } #endregion break; } } } } #endregion } else { //未配置后续节点 return(WorkFlowConst.NoFoundTaskCode); } return(WorkFlowConst.SuccessCode); }