You cannot select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.

77 lines
2.3 KiB
Plaintext

using System.Data;
using BP.DA;
using BP.En;
using BP.WF.Template;
namespace BP.WF.DTS
{
/// <summary>
/// 升级ccflow6 要执行的调度
/// </summary>
public class CheckDirCondModel : Method
{
/// <summary>
/// 不带有参数的方法
/// </summary>
public CheckDirCondModel()
{
this.Title = "检查所有流程方向条件设置是否正确?";
this.Help = "1.检查DirCondModel,配置的模式是否正确.";
this.Help += "\t\n 2.检查条件中配置的SQL";
}
/// <summary>
/// 设置执行变量
/// </summary>
/// <returns></returns>
public override void Init()
{
}
/// <summary>
/// 当前的操纵员是否可以执行这个方法
/// </summary>
public override bool IsCanDo
{
get
{
if (BP.Web.WebUser.No.Equals("admin")==true)
return true;
else
return false;
}
}
/// <summary>
/// 执行
/// </summary>
/// <returns>返回执行结果</returns>
public override object Do()
{
string err = "";
// 查询出来按照连接线.
Nodes nds = new Nodes();
nds.Retrieve(NodeAttr.CondModel, (int)DirCondModel.ByLineCond);
string sql = "方向条件未配置----------------------";
foreach (Node item in nds)
{
if (item.HisToNDNum <= 0)
continue;
NodeSimples toNDs = item.HisToNodeSimples;
var num = 0;
foreach (NodeSimple nd in toNDs)
{
sql = "SELECT * FROM WF_Cond WHERE CondType=2 and FK_Node=" + item.NodeID + " AND ToNodeID=" + nd.NodeID;
DataTable DT = DBAccess.RunSQLReturnTable(sql);
if (DT.Rows.Count == 0)
num++;
}
if (num > 1)
err += "<br>@流程["+item.FK_Flow+","+item.FlowName+"],节点["+item.NodeID+","+item.Name+"]方向条件设置错误,到达的节点有[" + toNDs.Count + "]个,没有设置连接线条件的有["+num+"]个";
}
return err;
}
}
}