/// <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);
}
