/// <summary>
/// 记录新发起的工作流实例
/// </summary>
/// <param name="WFName">工作流名称</param>
/// <param name="WFDataID">工作流实例对应的数据的ID</param>
/// <param name="OpeManID">操作人</param>
/// <param name="WFID">工作流ID</param>
/// <param name="NewInstanceID">新工作流实例ID</param>
public static string PutDownNewInstance(string WFName, string WFDataID, string OpeManID, string WFID, string NewInstanceID)
{
try
{
string WFVersion = CWFManager.GetLastVersion(WFName);
if (WFVersion == null || WFVersion == "")
{
CInstanceManager.SetInstanceError(NewInstanceID, "缺少工作流版本号");
WFGlobal.ErrInfo = CLog.PutDownErrInfo("工作流实例" + NewInstanceID + "缺少工作流版本号");
return(WFGlobal.ErrInfo);
}
if (CDataHelper.ExecuteNonQuery("insert into " + CTableName.FlowChartInstance + "(flowchart_id,flowchart_version,instance_id,cre_date,cre_man,instance_status) values('" + WFID + "','" + WFVersion + "','" + NewInstanceID + "','" + DateTime.Now.ToString() + "','" + OpeManID + "','" + EInstanceStatus.Active.ToString() + "')") < 0)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("记录工作流实例信息失败。");
return(WFGlobal.ErrInfo);
}
if (CDataHelper.ExecuteNonQuery("insert into " + CTableName.FlowChartPars + "(instance_id,keyvalue) values('" + NewInstanceID + "','" + WFDataID + "')") < 0)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("记录工作流数据信息失败。");
return(WFGlobal.ErrInfo);
}
return(WFGlobal.success);
}
catch (Exception ex)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("记录工作流实例操作异常。工作流名称：" + WFName + "，数据ID：" + WFDataID + "，发起人ID：" + OpeManID + "，工作流ID：" + WFID + "，异常信息：" + ex.Message.ToString());
return(WFGlobal.ErrInfo);
}
}
public string GetInstanceAll()
{
try
{
return(CInstanceManager.GetInstance("SELECT f.flowchart_name,i.[flowchart_id],i.[flowchart_version],i.[instance_id],i.[cre_date] ,u.user_name,i.[cre_man],i.[instance_status],i.[instance_message] FROM [kailifon].[dbo].[a_flowchart_instance] as i left join " + CTableName.FlowChart + " as f on(f.flowchart_id=i.flowchart_id) left join a_user as u on (i.cre_man=u.user_id) "));
}
catch (Exception ex)
{
throw ex;
}
}
public string GetInstanceFlowHistory(string InstanceID)
{
try
{
return(CInstanceManager.GetInstanceFlowHistory(InstanceID));
}
catch (Exception ex)
{
CLog.PutDownErrInfo("获取工作流实例流转历史操作异常。实例ID：" + InstanceID + "，异常信息：" + ex.Message.ToString());
throw ex;
}
}
public string TerminateInstance(string InstanceID)
{
try
{
if (WFGlobal.ServerStarted == true)
{
return(CInstanceManager.SetInstanceComplete(InstanceID));
}
WFGlobal.ErrInfo = CLog.PutDownErrInfo("停止工作流实例操作失败，工作流服务未启动。工作流实例ID：" + InstanceID);
return(WFGlobal.ErrInfo);
}
catch (Exception ex)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("停止工作流实例操作失败，工作流服务未启动。工作流实例ID：" + InstanceID + "，异常信息：" + ex.Message.ToString());
return(WFGlobal.ErrInfo);
}
}
/// <summary>
/// 发起流程命令处理
/// </summary>
/// <param name="WFName">流程名称</param>
/// <param name="WFDataID">数据表相对应数据ID</param>
/// <param name="OpeManID">发起人ID</param>
private string WFStartDeal(string WFName, string WFDataID, string OpeManID)
{
try
{
string WFID = CWFManager.GetLastVersionWFID(WFName);
if (WFID == null || WFID == "")
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("工作流" + WFName + "不存在。");
return(WFGlobal.ErrInfo);
}
string StartNodeID = CNodeManager.GetStartNodeID(WFID);
if (StartNodeID == null || StartNodeID == "")
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("工作流" + WFID + "没有起始节点。");
return(WFGlobal.ErrInfo);
}
string NewInstanceID = Guid.NewGuid().ToString();
//记录工作流实例
string PutDownInstanceResult = CInstanceManager.PutDownNewInstance(WFName, WFDataID, OpeManID, WFID, NewInstanceID);
if (PutDownInstanceResult != WFGlobal.success)
{
return(PutDownInstanceResult);
}
//将工作流实例的审批人设定为发起人
string PutDownApproverResult = CApprovalManager.PutDownApprover(NewInstanceID, StartNodeID, OpeManID, 1, "");
if (PutDownApproverResult != WFGlobal.success)
{
return(PutDownApproverResult);
}
//流程流转
return(WFTransmitDeal(NewInstanceID, StartNodeID, EApprovalOpinion.意, OpeManID, ""));
}
catch (Exception ex)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("发起工作流操作异常。工作流名称：" + WFName + "，发起人ID：" + OpeManID + "，数据ID" + WFDataID + "，异常信息：" + ex.Message.ToString());
return(WFGlobal.ErrInfo);
}
}
/// <summary>
/// 节点转移，从当前节点进入下一节点
/// </summary>
/// <param name="WFID"></param>
/// <param name="InstanceID"></param>
/// <param name="NodeID"></param>
/// <param name="NextNodeID"></param>
public static string NodeTransfer(string InstanceID, string NodeID, string NextNodeID)
{
try
{
if (CNodeManager.IsNodeThroughEnable(InstanceID, NextNodeID))
{
//记录流转历史
if (CDataHelper.ExecuteNonQuery("insert into " + CTableName.FlowChartHistory + "(instance_id,node_id,next_node_id) values('" + InstanceID + "','" + NodeID + "','" + NextNodeID + "')") < 0)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("记录工作流实例流转节点失败，工作流实例ID：" + InstanceID + "，开始节点ID：" + NodeID + "，结束节点ID：" + NextNodeID);
return(WFGlobal.ErrInfo);
}
string NodeType = CNodeManager.GetNodeType(NextNodeID);
if (NodeType == CNodeType.SwitchType)
{
return(GoNextNodesFromSwitchNode(InstanceID, NextNodeID));
}
else if (NodeType == CNodeType.ProcessType)
{
RunProcessScript(InstanceID, NextNodeID);
return(CNodeManager.GoNextNodesFromOtherNode(InstanceID, NextNodeID));
}
else if (NodeType == CNodeType.ApproveType || NodeType == CNodeType.StartType)
{
return(CNodeManager.PutDownNodeApprover(InstanceID, NextNodeID));
}
else if (NodeType == CNodeType.EndType)
{
return(CInstanceManager.SetInstanceComplete(InstanceID));
}
}
return(WFGlobal.success);
}
catch (Exception ex)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("节点流转异常，工作流实例ID：" + InstanceID + "，开始节点ID：" + NodeID + "，结束节点ID：" + NextNodeID);
return(WFGlobal.ErrInfo);
}
}
/// <summary>
/// 记录节点的审批人
/// </summary>
/// <param name="InstanceID"></param>
/// <param name="NodeID"></param>
public static string PutDownNodeApprover(string InstanceID, string NodeID)
{
try
{
string nodetype = CNodeManager.GetNodeType(NodeID);
if (nodetype == null)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("获取节点" + NodeID + "的节点类型失败，工作流实例ID：" + InstanceID);
CInstanceManager.SetInstanceError(InstanceID, WFGlobal.ErrInfo);
return(WFGlobal.ErrInfo);
}
int ApprovalNum = CApprovalManager.GetLastApprovalNum(InstanceID, NodeID);
//判断是否开始流程
if (nodetype == CNodeType.StartType)
{
string StartManID = CInstanceManager.GetInstanceStartManID(InstanceID);
if (StartManID == null)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("获取流程实例的发起人失败，工作流实例ID：" + InstanceID);
CInstanceManager.SetInstanceError(InstanceID, WFGlobal.ErrInfo);
return(WFGlobal.ErrInfo);
}
string ApprovalNote = CApprovalManager.GetApprovalNote(InstanceID, NodeID);
string PutDownApproverResult = CApprovalManager.PutDownApprover(InstanceID, NodeID, StartManID, ApprovalNum + 1, ApprovalNote);
if (PutDownApproverResult != WFGlobal.success)
{
return(PutDownApproverResult);
}
}
//判断流程是否结束
else if (nodetype != CNodeType.EndType)
{
DataTable dtReceiver = CApprovalManager.GetApprover(InstanceID, NodeID);
string ApprovalNote = CApprovalManager.GetApprovalNote(InstanceID, NodeID);
if (dtReceiver != null)
{
if (dtReceiver.Rows.Count > 0)
{
for (int i = 0; i < dtReceiver.Rows.Count; i++)
{
string ReceiverID = dtReceiver.Rows[i][WFGlobal.UserID].ToString();
string PutDownApproverResult = CApprovalManager.PutDownApprover(InstanceID, NodeID, ReceiverID, ApprovalNum + 1, ApprovalNote);
if (PutDownApproverResult != WFGlobal.success)
{
return(PutDownApproverResult);
}
}
}
}
}
return(WFGlobal.success);
}
catch (Exception ex)
{
WFGlobal.ErrInfo = CLog.PutDownErrInfo("记录节点审批人操作异常。工作流实例ID：" + InstanceID + "，节点ID：" + NodeID + "，异常信息：" + ex.Message.ToString());
return(WFGlobal.ErrInfo);
}
}