|
|
using System;
|
|
|
using System.Collections;
|
|
|
using System.Data;
|
|
|
using BP.DA;
|
|
|
using BP.Sys;
|
|
|
using BP.En;
|
|
|
using BP.WF.Data;
|
|
|
using BP.Web;
|
|
|
using BP.Difference;
|
|
|
|
|
|
|
|
|
namespace BP.WF.Template
|
|
|
{
|
|
|
/// <summary>
|
|
|
/// 条件属性
|
|
|
/// </summary>
|
|
|
public class CondAttr
|
|
|
{
|
|
|
#region 属性.
|
|
|
/// <summary>
|
|
|
/// 关联的从表-vue版本的数据格式.
|
|
|
/// </summary>
|
|
|
public const string RefPKVal = "RefPKVal";
|
|
|
/// <summary>
|
|
|
/// 关联的流程编号
|
|
|
/// </summary>
|
|
|
public const string RefFlowNo = "RefFlowNo";
|
|
|
/// <summary>
|
|
|
/// 数据来源
|
|
|
/// </summary>
|
|
|
public const string DataFrom = "DataFrom";
|
|
|
public const string DataFromText = "DataFromText";
|
|
|
/// <summary>
|
|
|
/// 属性Key
|
|
|
/// </summary>
|
|
|
public const string AttrKey = "AttrKey";
|
|
|
/// <summary>
|
|
|
/// 名称
|
|
|
/// </summary>
|
|
|
public const string AttrName = "AttrName";
|
|
|
/// <summary>
|
|
|
/// 属性
|
|
|
/// </summary>
|
|
|
public const string FK_Attr = "FK_Attr";
|
|
|
/// <summary>
|
|
|
/// 运算符号
|
|
|
/// </summary>
|
|
|
public const string FK_Operator = "FK_Operator";
|
|
|
/// <summary>
|
|
|
/// 运算的值
|
|
|
/// </summary>
|
|
|
public const string OperatorValue = "OperatorValue";
|
|
|
/// <summary>
|
|
|
/// 操作值
|
|
|
/// </summary>
|
|
|
public const string OperatorValueT = "OperatorValueT";
|
|
|
/// <summary>
|
|
|
/// Node
|
|
|
/// </summary>
|
|
|
public const string FK_Node = "FK_Node";
|
|
|
/// <summary>
|
|
|
/// 条件类型
|
|
|
/// </summary>
|
|
|
public const string CondType = "CondType";
|
|
|
/// <summary>
|
|
|
/// 流程
|
|
|
/// </summary>
|
|
|
public const string FK_Flow = "FK_Flow";
|
|
|
/// <summary>
|
|
|
/// 启动的子流程(对子流程有效)
|
|
|
/// </summary>
|
|
|
public const string SubFlowNo = "SubFlowNo";
|
|
|
/// <summary>
|
|
|
/// 对方向条件有效
|
|
|
/// </summary>
|
|
|
public const string ToNodeID = "ToNodeID";
|
|
|
/// <summary>
|
|
|
/// 备注
|
|
|
/// </summary>
|
|
|
public const string Note = "Note";
|
|
|
/// <summary>
|
|
|
/// 顺序号
|
|
|
/// </summary>
|
|
|
public const string Idx = "Idx";
|
|
|
/// <summary>
|
|
|
/// 数据源
|
|
|
/// </summary>
|
|
|
public const string FK_DBSrc = "FK_DBSrc";
|
|
|
public const string Tag1 = "Tag1";
|
|
|
public const string JSFX = "JSFX";
|
|
|
#endregion 属性.
|
|
|
|
|
|
#region 属性。
|
|
|
/// <summary>
|
|
|
/// 指定人员方式
|
|
|
/// </summary>
|
|
|
public const string SpecOperWay = "SpecOperWay";
|
|
|
/// <summary>
|
|
|
/// 指定人员方式的参数
|
|
|
/// </summary>
|
|
|
public const string SpecOperPara = "SpecOperPara";
|
|
|
#endregion 属性。
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 条件
|
|
|
/// </summary>
|
|
|
public class Cond : EntityMyPK
|
|
|
{
|
|
|
#region 参数属性.
|
|
|
/// <summary>
|
|
|
/// 指定人员方式
|
|
|
/// </summary>
|
|
|
public SpecOperWay SpecOperWay
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return (SpecOperWay)this.GetParaInt(CondAttr.SpecOperWay);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetPara(CondAttr.SpecOperWay, (int)value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 指定人员参数
|
|
|
/// </summary>
|
|
|
public string SpecOperPara
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetParaString(CondAttr.SpecOperPara);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetPara(CondAttr.SpecOperPara, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 求指定的人员.
|
|
|
/// </summary>
|
|
|
public string SpecOper
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
var way = this.SpecOperWay;
|
|
|
if (way == SpecOperWay.CurrOper)
|
|
|
return BP.Web.WebUser.No;
|
|
|
|
|
|
|
|
|
if (way == SpecOperWay.SpecNodeOper)
|
|
|
{
|
|
|
string sql = "SELECT FK_Emp FROM WF_GenerWorkerlist WHERE FK_Node=" + this.SpecOperPara + " AND WorkID=" + this.WorkID;
|
|
|
string fk_emp = DBAccess.RunSQLReturnStringIsNull(sql, null);
|
|
|
if (fk_emp == null)
|
|
|
throw new Exception("@您在配置方向条件时错误，求指定的人员的时候，按照指定的节点[" + this.SpecOperPara + "]，作为处理人，但是该节点上没有人员。查询SQL:" + sql);
|
|
|
return fk_emp;
|
|
|
}
|
|
|
|
|
|
if (way == SpecOperWay.SpecSheetField)
|
|
|
{
|
|
|
if (this.en.Row.ContainsKey(this.SpecOperPara.Replace("@", "")) == false)
|
|
|
throw new Exception("@您在配置方向条件时错误，求指定的人员的时候，按照指定的字段[" + this.SpecOperPara + "]作为处理人，但是该字段不存在。");
|
|
|
|
|
|
return this.en.GetValStringByKey(this.SpecOperPara.Replace("@", ""));
|
|
|
}
|
|
|
|
|
|
if (way == SpecOperWay.CurrOper)
|
|
|
{
|
|
|
if (this.en.Row.ContainsKey(this.SpecOperPara.Replace("@", "")) == false)
|
|
|
throw new Exception("@您在配置方向条件时错误，求指定的人员的时候，按照指定的字段[" + this.SpecOperPara + "]作为处理人，但是该字段不存在。");
|
|
|
|
|
|
return this.en.GetValStringByKey(this.SpecOperPara.Replace("@", ""));
|
|
|
}
|
|
|
|
|
|
if (way == SpecOperWay.SpenEmpNo)
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(this.SpecOperPara) == false)
|
|
|
throw new Exception("@您在配置方向条件时错误，求指定的人员的时候，按照指定的人员[" + this.SpecOperPara + "]作为处理人，但是人员参数没有设置。");
|
|
|
return this.SpecOperPara;
|
|
|
}
|
|
|
|
|
|
throw new Exception("@配置异常，没有判断的条件类型。");
|
|
|
}
|
|
|
}
|
|
|
#endregion 参数属性.
|
|
|
|
|
|
#region 基本属性.
|
|
|
public GERpt en = null;
|
|
|
/// <summary>
|
|
|
/// 数据来源
|
|
|
/// </summary>
|
|
|
public ConnDataFrom HisDataFrom
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return (ConnDataFrom)this.GetValIntByKey(CondAttr.DataFrom);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
switch (value)
|
|
|
{
|
|
|
case ConnDataFrom.NodeForm:
|
|
|
this.DataFromText = "节点表单";
|
|
|
break;
|
|
|
case ConnDataFrom.StandAloneFrm:
|
|
|
this.DataFromText = "独立表单";
|
|
|
break;
|
|
|
case ConnDataFrom.CondOperator:
|
|
|
this.DataFromText = "操作符";
|
|
|
break;
|
|
|
case ConnDataFrom.Depts:
|
|
|
this.DataFromText = "部门条件";
|
|
|
break;
|
|
|
case ConnDataFrom.Stas:
|
|
|
this.DataFromText = "角色条件";
|
|
|
break;
|
|
|
case ConnDataFrom.SQL:
|
|
|
this.DataFromText = "SQL条件";
|
|
|
break;
|
|
|
case ConnDataFrom.SQLTemplate:
|
|
|
this.DataFromText = "SQL模板条件";
|
|
|
break;
|
|
|
case ConnDataFrom.Paras:
|
|
|
this.DataFromText = "参数条件";
|
|
|
break;
|
|
|
case ConnDataFrom.Url:
|
|
|
this.DataFromText = "URL条件";
|
|
|
break;
|
|
|
case ConnDataFrom.WebApi:
|
|
|
this.DataFromText = "WebAPI条件";
|
|
|
break;
|
|
|
case ConnDataFrom.WorkCheck:
|
|
|
this.DataFromText = "审核组件立场";
|
|
|
break;
|
|
|
default:
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
this.SetValByKey(CondAttr.DataFrom, (int)value);
|
|
|
}
|
|
|
}
|
|
|
public string RefPKVal
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.RefPKVal);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.RefPKVal, value);
|
|
|
}
|
|
|
}
|
|
|
public string DataFromText
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.DataFromText);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.DataFromText, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 流程编号
|
|
|
/// </summary>
|
|
|
public string FK_Flow
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.FK_Flow);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.FK_Flow, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 隶属流程编号，用于备份删除.
|
|
|
/// </summary>
|
|
|
public string RefFlowNo
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.RefFlowNo);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.RefFlowNo, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 数据源
|
|
|
/// </summary>
|
|
|
public string FK_DBSrc
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.FK_DBSrc);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.FK_DBSrc, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 备注
|
|
|
/// </summary>
|
|
|
public string Note
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.Note);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.Note, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 条件类型(表单条件，角色条件，部门条件，开发者参数)
|
|
|
/// </summary>
|
|
|
public CondType CondType
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return (CondType)this.GetValIntByKey(CondAttr.CondType);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.CondType, (int)value);
|
|
|
}
|
|
|
}
|
|
|
public int CondTypeInt
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(CondAttr.CondType);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.CondType, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 节点ID
|
|
|
/// </summary>
|
|
|
public int FK_Node
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(CondAttr.FK_Node);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.FK_Node, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 对方向条件有效
|
|
|
/// </summary>
|
|
|
public int ToNodeID
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(CondAttr.ToNodeID);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.ToNodeID, value);
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 重写.
|
|
|
protected override bool beforeUpdateInsertAction()
|
|
|
{
|
|
|
if (DataType.IsNullOrEmpty(this.RefFlowNo) == true)
|
|
|
{
|
|
|
if (this.CondType == CondType.Dir
|
|
|
|| this.CondType == CondType.Node
|
|
|
|| this.CondType == CondType.SubFlow)
|
|
|
{
|
|
|
Node nd = new Node(this.FK_Node);
|
|
|
this.RefFlowNo = nd.FK_Flow;
|
|
|
}
|
|
|
|
|
|
if (this.CondType == CondType.Flow)
|
|
|
{
|
|
|
this.RefFlowNo = this.FK_Flow;
|
|
|
if (DataType.IsNullOrEmpty(this.RefFlowNo) == true)
|
|
|
throw new Exception("err@流程完成条件设置错误，没有给FK_Flow赋值。");
|
|
|
}
|
|
|
|
|
|
//for vue版本数据格式.增加一个主从表的标记字段.
|
|
|
if (this.CondType == CondType.Dir)
|
|
|
this.RefPKVal = this.FK_Flow + '_' + this.FK_Node + '_' + this.ToNodeID;
|
|
|
}
|
|
|
return base.beforeUpdateInsertAction();
|
|
|
}
|
|
|
protected override bool beforeInsert()
|
|
|
{
|
|
|
//设置他的主键。
|
|
|
this.setMyPK(DBAccess.GenerGUID());
|
|
|
return base.beforeInsert();
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 清除数据缓存
|
|
|
/// </summary>
|
|
|
protected override void afterInsertUpdateAction()
|
|
|
{
|
|
|
Flow flow = new Flow(this.FK_Flow);
|
|
|
flow.ClearAutoNumCash(true);
|
|
|
base.afterInsertUpdateAction();
|
|
|
}
|
|
|
protected override void afterDelete()
|
|
|
{
|
|
|
Flow flow = new Flow(this.FK_Flow);
|
|
|
flow.ClearAutoNumCash(true);
|
|
|
base.afterDelete();
|
|
|
}
|
|
|
#endregion 重写.
|
|
|
|
|
|
#region 实现基本的方方法
|
|
|
/// <summary>
|
|
|
/// 属性
|
|
|
/// </summary>
|
|
|
public string FK_Attr
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.FK_Attr);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
if (value == null)
|
|
|
throw new Exception("FK_Attr不能设置为null");
|
|
|
|
|
|
value = value.Trim();
|
|
|
|
|
|
this.SetValByKey(CondAttr.FK_Attr, value);
|
|
|
|
|
|
BP.Sys.MapAttr attr = new BP.Sys.MapAttr(value);
|
|
|
|
|
|
if (attr.LGType == FieldTypeS.Enum)
|
|
|
{
|
|
|
/*是一个枚举类型的*/
|
|
|
SysEnum se = new SysEnum(attr.UIBindKey, this.OperatorValueInt);
|
|
|
this.OperatorValueT = se.Lab;
|
|
|
}
|
|
|
|
|
|
this.SetValByKey(CondAttr.AttrKey, attr.KeyOfEn);
|
|
|
this.SetValByKey(CondAttr.AttrName, attr.Name);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 要运算的实体属性
|
|
|
/// </summary>
|
|
|
public string AttrKey
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.AttrKey);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.AttrKey, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 属性名称
|
|
|
/// </summary>
|
|
|
public string AttrName
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.AttrName);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.AttrName, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// Idx
|
|
|
/// </summary>
|
|
|
public int Idx
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(CondAttr.Idx);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.Idx, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 计算方向
|
|
|
/// </summary>
|
|
|
public bool JSFX
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValBooleanByKey(CondAttr.JSFX);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 操作的值
|
|
|
/// </summary>
|
|
|
public string OperatorValueT
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValStringByKey(CondAttr.OperatorValueT);
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.OperatorValueT, value);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 运算符号
|
|
|
/// </summary>
|
|
|
public string FK_Operator
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string s = this.GetValStringByKey(CondAttr.FK_Operator);
|
|
|
if (s == null || s == "")
|
|
|
return "=";
|
|
|
return s;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
string val = "";
|
|
|
|
|
|
switch (value)
|
|
|
{
|
|
|
case "dengyu":
|
|
|
val = "=";
|
|
|
break;
|
|
|
case "dayu":
|
|
|
val = ">";
|
|
|
break;
|
|
|
case "dayudengyu":
|
|
|
val = ">=";
|
|
|
break;
|
|
|
case "xiaoyu":
|
|
|
val = "<";
|
|
|
break;
|
|
|
case "xiaoyudengyu":
|
|
|
val = "<=";
|
|
|
break;
|
|
|
case "budengyu":
|
|
|
val = "!=";
|
|
|
break;
|
|
|
case "like":
|
|
|
val = " LIKE ";
|
|
|
break;
|
|
|
default:
|
|
|
break;
|
|
|
}
|
|
|
|
|
|
this.SetValByKey(CondAttr.FK_Operator, val);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 运算值
|
|
|
/// </summary>
|
|
|
public object OperatorValue
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string s = this.GetValStringByKey(CondAttr.OperatorValue);
|
|
|
s = s.Replace("~", "'");
|
|
|
|
|
|
if (s.Contains("@") == true)
|
|
|
{
|
|
|
if (s.Equals("@WebUser.No") == true)
|
|
|
return WebUser.No;
|
|
|
if (s.Equals("@WebUser.Name") == true)
|
|
|
return WebUser.Name;
|
|
|
if (s.Equals("@WebUser.FK_Dept") == true)
|
|
|
return WebUser.FK_Dept;
|
|
|
if (s.Equals("@WebUser.FK_DeptName") == true)
|
|
|
return WebUser.FK_DeptName;
|
|
|
}
|
|
|
return s;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
this.SetValByKey(CondAttr.OperatorValue, value as string);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 操作值Str
|
|
|
/// </summary>
|
|
|
public string OperatorValueStr
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string sql = this.GetValStringByKey(CondAttr.OperatorValue);
|
|
|
sql = sql.Replace("~", "'");
|
|
|
return sql;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 操作值int
|
|
|
/// </summary>
|
|
|
public int OperatorValueInt
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValIntByKey(CondAttr.OperatorValue);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 操作值boolen
|
|
|
/// </summary>
|
|
|
public bool OperatorValueBool
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return this.GetValBooleanByKey(CondAttr.OperatorValue);
|
|
|
}
|
|
|
}
|
|
|
private Int64 _FID = 0;
|
|
|
public Int64 FID
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return _FID;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
_FID = value;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// workid
|
|
|
/// </summary>
|
|
|
private Int64 _WorkID = 0;
|
|
|
public Int64 WorkID
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return _WorkID;
|
|
|
}
|
|
|
set
|
|
|
{
|
|
|
_WorkID = value;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 条件消息
|
|
|
/// </summary>
|
|
|
public string MsgOfCond = "";
|
|
|
/// <summary>
|
|
|
/// 上移
|
|
|
/// </summary>
|
|
|
/// <param name="fk_node">节点ID</param>
|
|
|
public void DoUp(int fk_node)
|
|
|
{
|
|
|
int condtypeInt = (int)this.CondType;
|
|
|
this.DoOrderUp(CondAttr.FK_Node, fk_node.ToString(), CondAttr.CondType, condtypeInt.ToString(), CondAttr.Idx);
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 下移
|
|
|
/// </summary>
|
|
|
/// <param name="fk_node">节点ID</param>
|
|
|
public void DoDown(int fk_node)
|
|
|
{
|
|
|
int condtypeInt = (int)this.CondType;
|
|
|
this.DoOrderDown(CondAttr.FK_Node, fk_node.ToString(), CondAttr.CondType, condtypeInt.ToString(), CondAttr.Idx);
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 方向条件-下移
|
|
|
/// </summary>
|
|
|
public void DoDown2020Cond()
|
|
|
{
|
|
|
if (this.CondType == CondType.Dir)
|
|
|
this.DoOrderDown(CondAttr.FK_Node, this.FK_Node, CondAttr.ToNodeID,
|
|
|
this.ToNodeID, CondAttr.CondType, (int)CondType.Dir, CondAttr.Idx);
|
|
|
|
|
|
if (this.CondType == CondType.Flow)
|
|
|
this.DoOrderDown(CondAttr.FK_Node, this.FK_Node, CondAttr.CondType, (int)CondType.Flow, CondAttr.Idx);
|
|
|
|
|
|
if (this.CondType == CondType.SubFlow)
|
|
|
this.DoOrderDown(CondAttr.FK_Node, this.FK_Node, CondAttr.CondType, (int)CondType.SubFlow, CondAttr.Idx);
|
|
|
|
|
|
if (this.CondType == CondType.Node)
|
|
|
this.DoOrderDown(CondAttr.FK_Node, this.FK_Node, CondAttr.CondType, (int)CondType.Node, CondAttr.Idx);
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 方向条件-上移
|
|
|
/// </summary>
|
|
|
public void DoUp2020Cond()
|
|
|
{
|
|
|
if (this.CondType == CondType.Dir)
|
|
|
this.DoOrderUp(CondAttr.FK_Node, this.FK_Node, CondAttr.ToNodeID,
|
|
|
this.ToNodeID, CondAttr.CondType, (int)CondType.Dir, CondAttr.Idx);
|
|
|
|
|
|
if (this.CondType == CondType.Flow)
|
|
|
this.DoOrderUp(CondAttr.FK_Node, this.FK_Node, CondAttr.CondType, (int)CondType.Flow, CondAttr.Idx);
|
|
|
|
|
|
if (this.CondType == CondType.SubFlow)
|
|
|
this.DoOrderUp(CondAttr.FK_Node, this.FK_Node, CondAttr.CondType, (int)CondType.SubFlow, CondAttr.Idx);
|
|
|
|
|
|
if (this.CondType == CondType.Node)
|
|
|
this.DoOrderUp(CondAttr.FK_Node, this.FK_Node, CondAttr.CondType, (int)CondType.Node, CondAttr.Idx);
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 构造方法
|
|
|
/// <summary>
|
|
|
/// 条件
|
|
|
/// </summary>
|
|
|
public Cond() { }
|
|
|
/// <summary>
|
|
|
/// 条件
|
|
|
/// </summary>
|
|
|
/// <param name="mypk"></param>
|
|
|
public Cond(string mypk)
|
|
|
{
|
|
|
this.setMyPK(mypk);
|
|
|
this.Retrieve();
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 公共方法
|
|
|
/// <summary>
|
|
|
/// 这个条件能不能通过
|
|
|
/// </summary>
|
|
|
public virtual bool IsPassed
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
Node nd = new Node(this.FK_Node);
|
|
|
if (this.en == null)
|
|
|
{
|
|
|
#region 实体不存在则进行重新初始化
|
|
|
GERpt en = nd.HisFlow.HisGERpt;
|
|
|
try
|
|
|
{
|
|
|
en.SetValByKey("OID", this.WorkID);
|
|
|
en.Retrieve();
|
|
|
en.ResetDefaultVal();
|
|
|
this.en = en;
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
//this.Delete();
|
|
|
return false;
|
|
|
//throw new Exception("@在取得判断条件实体[" + nd.EnDesc + "], 出现错误:" + ex.Message + "@错误原因是定义流程的判断条件出现错误,可能是你选择的判断条件工作类是当前工作节点的下一步工作造成,取不到该实体的实例.");
|
|
|
}
|
|
|
#endregion
|
|
|
}
|
|
|
|
|
|
if (this.HisDataFrom == ConnDataFrom.Stas)
|
|
|
{
|
|
|
#region 按角色控制
|
|
|
string strs = "," + this.OperatorValue.ToString() + ",";
|
|
|
strs += "," + this.OperatorValueT.ToString() + ",";
|
|
|
strs = strs.Replace("@", ",");
|
|
|
|
|
|
string strs1 = "";
|
|
|
|
|
|
BP.Port.DeptEmpStations sts = new BP.Port.DeptEmpStations();
|
|
|
string userNo = this.SpecOper;
|
|
|
if (SystemConfig.CCBPMRunModel == CCBPMRunModel.SAAS && this.SpecOper.StartsWith(WebUser.OrgNo) == false)
|
|
|
userNo = WebUser.OrgNo + "_" + this.SpecOper;
|
|
|
sts.Retrieve("FK_Emp", userNo);
|
|
|
foreach (BP.Port.DeptEmpStation st in sts)
|
|
|
{
|
|
|
if (strs.Contains("," + st.FK_Station + ",") == true)
|
|
|
{
|
|
|
this.MsgOfCond = "@以角色判断方向，条件为true：角色集合" + strs + "，操作员(" + BP.Web.WebUser.No + ")角色:" + st.FK_Station + st.FK_StationT;
|
|
|
|
|
|
//处理计算方向.
|
|
|
if (this.JSFX == false)
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
}
|
|
|
strs1 += st.FK_Station + "-" + st.FK_StationT;
|
|
|
}
|
|
|
|
|
|
this.MsgOfCond = "@以角色判断方向，条件为false：角色集合" + strs + "，操作员(" + BP.Web.WebUser.No + ")角色:" + strs1;
|
|
|
|
|
|
//处理计算方向.
|
|
|
if (this.JSFX == false)
|
|
|
return false;
|
|
|
else
|
|
|
return true;
|
|
|
#endregion
|
|
|
}
|
|
|
|
|
|
if (this.HisDataFrom == ConnDataFrom.Depts)
|
|
|
{
|
|
|
#region 按部门控制
|
|
|
string strs = "," + this.OperatorValue.ToString() + ",";
|
|
|
strs = strs.Replace("@", ",");
|
|
|
|
|
|
// 需要递归计算.
|
|
|
string subDeptStr = "";
|
|
|
if (this.IsSubDept)
|
|
|
{
|
|
|
foreach (string str in strs.Split(','))
|
|
|
{
|
|
|
subDeptStr = GenerDeptNosString(str, subDeptStr);
|
|
|
}
|
|
|
}
|
|
|
strs += subDeptStr + ",";
|
|
|
|
|
|
//计算出来当前人员的所有部门.
|
|
|
BP.Port.DeptEmps sts = new BP.Port.DeptEmps();
|
|
|
sts.Retrieve(BP.Port.DeptEmpAttr.FK_Emp, this.SpecOper);
|
|
|
BP.Port.Emp emp = new BP.Port.Emp(this.SpecOper);
|
|
|
emp.UserID = this.SpecOper;
|
|
|
if (emp.RetrieveFromDBSources() == 1)
|
|
|
{
|
|
|
BP.Port.DeptEmp de = new BP.Port.DeptEmp();
|
|
|
de.FK_Dept = emp.FK_Dept;
|
|
|
sts.AddEntity(de);
|
|
|
}
|
|
|
|
|
|
|
|
|
string strs1 = "";
|
|
|
foreach (BP.Port.DeptEmp st in sts)
|
|
|
{
|
|
|
if (strs.Contains("," + st.FK_Dept + ",") == true)
|
|
|
{
|
|
|
this.MsgOfCond = "@以角色判断方向，条件为true：部门集合" + strs + "，操作员(" + BP.Web.WebUser.No + ")部门:" + st.FK_Dept;
|
|
|
|
|
|
//处理计算方向.
|
|
|
if (this.JSFX == false)
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
}
|
|
|
|
|
|
|
|
|
|
|
|
strs1 += st.FK_Dept;
|
|
|
}
|
|
|
|
|
|
this.MsgOfCond = "@以部门判断方向，条件为false：部门集合" + strs + "，操作员(" + BP.Web.WebUser.No + ")部门:" + strs1;
|
|
|
|
|
|
//处理计算方向.
|
|
|
if (this.JSFX == false)
|
|
|
return false;
|
|
|
else
|
|
|
return true;
|
|
|
#endregion
|
|
|
}
|
|
|
|
|
|
if (this.HisDataFrom == ConnDataFrom.SQL)
|
|
|
{
|
|
|
#region 按SQL 计算
|
|
|
//this.MsgOfCond = "@以表单值判断方向，值 " + en.EnDesc + "." + this.AttrKey + " (" + en.GetValStringByKey(this.AttrKey) + ") 操作符:(" + this.FK_Operator + ") 判断值:(" + this.OperatorValue.ToString() + ")";
|
|
|
string sql = this.OperatorValueStr;
|
|
|
sql = sql.Replace("~", "'");
|
|
|
sql = sql.Replace("@WebUser.No", BP.Web.WebUser.No);
|
|
|
sql = sql.Replace("@WebUser.Name", BP.Web.WebUser.Name);
|
|
|
sql = sql.Replace("@WebUser.FK_DeptName", BP.Web.WebUser.FK_DeptName);
|
|
|
sql = sql.Replace("@WebUser.FK_Dept", BP.Web.WebUser.FK_Dept);
|
|
|
|
|
|
sql = sql.Replace("@WebUser.OrgNo", BP.Web.WebUser.OrgNo);
|
|
|
//获取参数值
|
|
|
//System.Collections.Specialized.NameValueCollection urlParams = HttpContextHelper.RequestParams; // System.Web.HttpContext.Current.Request.Form;
|
|
|
foreach (string key in HttpContextHelper.RequestParamKeys)
|
|
|
{
|
|
|
//循环使用数组
|
|
|
if (DataType.IsNullOrEmpty(key) == false && sql.Contains(key) == true)
|
|
|
sql = sql.Replace("@" + key, HttpContextHelper.RequestParams(key));
|
|
|
//sql = sql.Replace("@" + key, urlParams[key]);
|
|
|
}
|
|
|
|
|
|
if (en.IsOIDEntity == true)
|
|
|
{
|
|
|
sql = sql.Replace("@WorkID", en.GetValStrByKey("OID"));
|
|
|
sql = sql.Replace("@OID", en.GetValStrByKey("OID"));
|
|
|
}
|
|
|
|
|
|
if (sql.Contains("@") == true)
|
|
|
{
|
|
|
/* 如果包含 @ */
|
|
|
foreach (Attr attr in this.en.EnMap.Attrs)
|
|
|
{
|
|
|
sql = sql.Replace("@" + attr.Key, en.GetValStrByKey(attr.Key));
|
|
|
}
|
|
|
}
|
|
|
|
|
|
int result = 0;
|
|
|
//如果是本地数据源
|
|
|
if (DataType.IsNullOrEmpty(this.FK_DBSrc) == true || this.FK_DBSrc == "local")
|
|
|
result = DBAccess.RunSQLReturnValInt(sql, -1);
|
|
|
else
|
|
|
{
|
|
|
SFDBSrc dbSrc = new SFDBSrc(this.FK_DBSrc);
|
|
|
result = dbSrc.RunSQLReturnInt(sql, 0);
|
|
|
}
|
|
|
if (result <= 0)
|
|
|
return false;
|
|
|
|
|
|
return true;
|
|
|
#endregion 按SQL 计算
|
|
|
}
|
|
|
|
|
|
if (this.HisDataFrom == ConnDataFrom.SQLTemplate)
|
|
|
{
|
|
|
#region 按SQLTemplate 计算
|
|
|
//this.MsgOfCond = "@以表单值判断方向，值 " + en.EnDesc + "." + this.AttrKey + " (" + en.GetValStringByKey(this.AttrKey) + ") 操作符:(" + this.FK_Operator + ") 判断值:(" + this.OperatorValue.ToString() + ")";
|
|
|
string fk_sqlTemplate = this.OperatorValueStr;
|
|
|
SQLTemplate sqltemplate = new SQLTemplate();
|
|
|
sqltemplate.No = fk_sqlTemplate;
|
|
|
if (sqltemplate.RetrieveFromDBSources() == 0)
|
|
|
throw new Exception("@配置的SQLTemplate编号为[" + sqltemplate + "]被删除了,判断条件丢失.");
|
|
|
|
|
|
string sql = sqltemplate.Docs;
|
|
|
sql = sql.Replace("~", "'");
|
|
|
sql = sql.Replace("@WebUser.No", BP.Web.WebUser.No);
|
|
|
sql = sql.Replace("@WebUser.Name", BP.Web.WebUser.Name);
|
|
|
sql = sql.Replace("@WebUser.FK_Dept", BP.Web.WebUser.FK_Dept);
|
|
|
|
|
|
if (en.IsOIDEntity == true)
|
|
|
{
|
|
|
sql = sql.Replace("@WorkID", en.GetValStrByKey("OID"));
|
|
|
sql = sql.Replace("@OID", en.GetValStrByKey("OID"));
|
|
|
}
|
|
|
|
|
|
if (sql.Contains("@") == true)
|
|
|
{
|
|
|
/* 如果包含 @ */
|
|
|
foreach (Attr attr in this.en.EnMap.Attrs)
|
|
|
{
|
|
|
sql = sql.Replace("@" + attr.Key, en.GetValStrByKey(attr.Key));
|
|
|
}
|
|
|
}
|
|
|
|
|
|
int result = 0;
|
|
|
//如果是本地数据源
|
|
|
if (DataType.IsNullOrEmpty(this.FK_DBSrc) == true || this.FK_DBSrc == "local")
|
|
|
result = DBAccess.RunSQLReturnValInt(sql, -1);
|
|
|
else
|
|
|
{
|
|
|
SFDBSrc dbSrc = new SFDBSrc(this.FK_DBSrc);
|
|
|
result = dbSrc.RunSQLReturnInt(sql, 0);
|
|
|
}
|
|
|
if (result <= 0)
|
|
|
return false;
|
|
|
|
|
|
if (result >= 1)
|
|
|
return true;
|
|
|
|
|
|
throw new Exception("@您设置的sql返回值，不符合农芯BPM的要求，必须是0或大于等于1。");
|
|
|
#endregion
|
|
|
}
|
|
|
|
|
|
if (this.HisDataFrom == ConnDataFrom.Url)
|
|
|
{
|
|
|
#region URL 参数计算
|
|
|
string url = this.OperatorValueStr;
|
|
|
if (url.Contains("?") == false)
|
|
|
url = url + "?1=2";
|
|
|
|
|
|
url = url.Replace("@SDKFromServHost", BP.Difference.SystemConfig.AppSettings["SDKFromServHost"]);
|
|
|
url = BP.WF.Glo.DealExp(url, this.en, "");
|
|
|
|
|
|
#region 加入必要的参数.
|
|
|
if (url.Contains("&FK_Flow") == false)
|
|
|
url += "&FK_Flow=" + this.FK_Flow;
|
|
|
if (url.Contains("&FK_Node") == false)
|
|
|
url += "&FK_Node=" + this.FK_Node;
|
|
|
|
|
|
if (url.Contains("&WorkID") == false)
|
|
|
url += "&WorkID=" + this.WorkID;
|
|
|
|
|
|
if (url.Contains("&FID") == false)
|
|
|
url += "&FID=" + this.FID;
|
|
|
|
|
|
if (url.Contains("&Token") == false)
|
|
|
url += "&Token=" + BP.Web.WebUser.Token;
|
|
|
|
|
|
if (url.Contains("&UserNo") == false)
|
|
|
url += "&UserNo=" + BP.Web.WebUser.No;
|
|
|
|
|
|
|
|
|
#endregion 加入必要的参数.
|
|
|
|
|
|
#region 对url进行处理.
|
|
|
if (BP.Difference.SystemConfig.IsBSsystem)
|
|
|
{
|
|
|
/*是bs系统，并且是url参数执行类型.*/
|
|
|
string myurl = HttpContextHelper.RequestRawUrl;// BP.Sys.Base.Glo.Request.RawUrl;
|
|
|
if (myurl.IndexOf('?') != -1)
|
|
|
myurl = myurl.Substring(myurl.IndexOf('?'));
|
|
|
|
|
|
myurl = myurl.Replace("?", "&");
|
|
|
string[] paras = myurl.Split('&');
|
|
|
foreach (string s in paras)
|
|
|
{
|
|
|
string[] strs = s.Split('=');
|
|
|
|
|
|
//如果已经有了这个参数.
|
|
|
if (url.Contains(strs[0] + "=") == true)
|
|
|
continue;
|
|
|
|
|
|
if (url.Contains(s))
|
|
|
continue;
|
|
|
url += "&" + s;
|
|
|
}
|
|
|
url = url.Replace("&?", "&");
|
|
|
}
|
|
|
|
|
|
//替换特殊的变量.
|
|
|
url = url.Replace("&?", "&");
|
|
|
|
|
|
if (BP.Difference.SystemConfig.IsBSsystem == false)
|
|
|
{
|
|
|
/*非bs模式下调用,比如在cs模式下调用它,它就取不到参数. */
|
|
|
}
|
|
|
|
|
|
|
|
|
if (url.Contains("http") == false)
|
|
|
{
|
|
|
/*如果没有绝对路径 */
|
|
|
if (BP.Difference.SystemConfig.IsBSsystem)
|
|
|
{
|
|
|
/*在cs模式下自动获取*/
|
|
|
string host = HttpContextHelper.RequestUrlHost;//BP.Sys.Base.Glo.Request.Url.Host;
|
|
|
if (url.Contains("@AppPath"))
|
|
|
url = url.Replace("@AppPath", "http://" + host + HttpContextHelper.RequestApplicationPath);//BP.Sys.Base.Glo.Request.ApplicationPath
|
|
|
else//BP.Sys.Base.Glo.Request.Url.Authority
|
|
|
url = "http://" + HttpContextHelper.RequestUrlAuthority + url;
|
|
|
}
|
|
|
|
|
|
if (BP.Difference.SystemConfig.IsBSsystem == false)
|
|
|
{
|
|
|
/*在cs模式下它的baseurl 从web.config中获取.*/
|
|
|
string cfgBaseUrl = BP.Difference.SystemConfig.AppSettings["HostURL"];
|
|
|
if (DataType.IsNullOrEmpty(cfgBaseUrl))
|
|
|
{
|
|
|
string err = "调用url失败:没有在web.config中配置BaseUrl,导致url事件不能被执行.";
|
|
|
BP.DA.Log.DebugWriteError(err);
|
|
|
throw new Exception(err);
|
|
|
}
|
|
|
url = cfgBaseUrl + url;
|
|
|
}
|
|
|
}
|
|
|
#endregion 对url进行处理.
|
|
|
|
|
|
#region 求url的值
|
|
|
try
|
|
|
{
|
|
|
url = url.Replace("'", "");
|
|
|
// url = url.Replace("//", "/");
|
|
|
// url = url.Replace("//", "/");
|
|
|
System.Text.Encoding encode = System.Text.Encoding.GetEncoding("gb2312");
|
|
|
string text = DataType.ReadURLContext(url, 8000, encode);
|
|
|
if (text == null)
|
|
|
//throw new Exception("@流程设计的方向条件错误，执行的URL错误:" + url + ", 返回为null, 请检查设置是否正确。");
|
|
|
return false;
|
|
|
|
|
|
if (DataType.IsNullOrEmpty(text) == true)
|
|
|
// throw new Exception("@错误，没有接收到返回值.");
|
|
|
return false;
|
|
|
|
|
|
if (DataType.IsNumStr(text) == false)
|
|
|
//throw new Exception("@错误，不符合约定的格式，必须是数字类型。");
|
|
|
return false;
|
|
|
try
|
|
|
{
|
|
|
float f = float.Parse(text);
|
|
|
if (f > 0)
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
return false;
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
throw new Exception("@判断url方向出现错误:" + ex.Message + ",执行url错误:" + url);
|
|
|
}
|
|
|
#endregion 对url进行处理.
|
|
|
|
|
|
#endregion
|
|
|
}
|
|
|
|
|
|
if (this.HisDataFrom == ConnDataFrom.WebApi)
|
|
|
{
|
|
|
#region WebApi接口
|
|
|
//返回值
|
|
|
string postData = "";
|
|
|
string apiUrl = this.OperatorValueStr;
|
|
|
if (apiUrl.Contains("@WebApiHost"))//可以替换配置文件中配置的webapi地址
|
|
|
apiUrl = apiUrl.Replace("@WebApiHost", BP.Difference.SystemConfig.AppSettings["WebApiHost"]);
|
|
|
|
|
|
//如果有参数
|
|
|
if (apiUrl.Contains("?"))
|
|
|
{
|
|
|
//api接口地址
|
|
|
string apiHost = apiUrl.Split('?')[0];
|
|
|
//api参数
|
|
|
string apiParams = apiUrl.Split('?')[1];
|
|
|
//参数替换
|
|
|
apiParams = BP.WF.Glo.DealExp(apiParams, this.en);
|
|
|
//执行POST
|
|
|
postData = BP.WF.Glo.HttpPostConnect(apiHost, apiParams);
|
|
|
|
|
|
if (postData == "true")
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
}
|
|
|
else
|
|
|
{//如果没有参数，执行GET
|
|
|
postData = BP.WF.Glo.HttpGet(apiUrl);
|
|
|
if (postData == "true")
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
}
|
|
|
#endregion WebApi接口
|
|
|
}
|
|
|
|
|
|
#region 审核组件的立场
|
|
|
if (this.HisDataFrom == ConnDataFrom.WorkCheck)
|
|
|
{
|
|
|
//获取当前节点的审核组件信息
|
|
|
string tag = BP.WF.Dev2Interface.GetCheckTag(this.FK_Flow, this.WorkID, this.FK_Node, WebUser.No);
|
|
|
if (tag.Contains("@FWCView=" + this.OperatorValue) == true)
|
|
|
return true;
|
|
|
return false;
|
|
|
}
|
|
|
#endregion 审核组件的立场
|
|
|
|
|
|
if (this.HisDataFrom == ConnDataFrom.Paras)
|
|
|
{
|
|
|
Hashtable ht = en.Row;
|
|
|
return BP.WF.Glo.CondExpPara(this.OperatorValueStr, ht, en.OID);
|
|
|
}
|
|
|
|
|
|
//从节点表单里判断.
|
|
|
if (this.HisDataFrom == ConnDataFrom.NodeForm)
|
|
|
{
|
|
|
if (en.EnMap.Attrs.Contains(this.AttrKey) == false)
|
|
|
throw new Exception("err@判断条件方向出现错误：实体：" + nd.EnDesc + " 属性" + this.AttrKey + "已经被删除方向条件判断失败.");
|
|
|
|
|
|
this.MsgOfCond = "@以表单值判断方向，值 " + en.EnDesc + "." + this.AttrKey + " (" + en.GetValStringByKey(this.AttrKey) + ") 操作符:(" + this.FK_Operator + ") 判断值:(" + this.OperatorValue.ToString() + ")";
|
|
|
return CheckIsPass(en);
|
|
|
}
|
|
|
|
|
|
//从独立表单里判断.
|
|
|
if (this.HisDataFrom == ConnDataFrom.StandAloneFrm)
|
|
|
{
|
|
|
MapAttr attr = new MapAttr(this.FK_Attr);
|
|
|
attr.setMyPK(this.FK_Attr);
|
|
|
if (attr.RetrieveFromDBSources() == 0)
|
|
|
throw new Exception("err@到达【" + this.ToNodeID + "】方向条件设置错误,原来做方向条件的字段:" + this.FK_Attr + ",已经不存在了.");
|
|
|
|
|
|
GEEntity myen = new GEEntity(attr.FK_MapData, en.OID);
|
|
|
return CheckIsPass(myen);
|
|
|
}
|
|
|
return false;
|
|
|
}
|
|
|
}
|
|
|
private bool CheckIsPass(Entity en)
|
|
|
{
|
|
|
MapAttr attr = new MapAttr(this.FK_Attr);
|
|
|
attr.setMyPK(this.FK_Attr);
|
|
|
if (attr.RetrieveFromDBSources() == 0)
|
|
|
throw new Exception("err@到达【" + this.ToNodeID + "】方向条件设置错误,原来做方向条件的字段:" + this.FK_Attr + ",已经不存在了.");
|
|
|
|
|
|
try
|
|
|
{
|
|
|
switch (this.FK_Operator.Trim().ToLower())
|
|
|
{
|
|
|
case "<>":
|
|
|
case "!=":
|
|
|
case "budingyu":
|
|
|
case "budengyu": //不等于.
|
|
|
if (attr.IsNum == true)
|
|
|
{
|
|
|
if (en.GetValDoubleByKey(this.AttrKey) != Double.Parse(this.OperatorValue.ToString()))
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
}
|
|
|
if (en.GetValStringByKey(this.AttrKey).Equals(this.OperatorValue.ToString()) == false)
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
case "=": // 如果是 =
|
|
|
case "dengyu":
|
|
|
if (attr.IsNum == true)
|
|
|
{
|
|
|
if (en.GetValDoubleByKey(this.AttrKey) == Double.Parse(this.OperatorValue.ToString()))
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
}
|
|
|
if (en.GetValStringByKey(this.AttrKey).Equals(this.OperatorValue.ToString().Replace("\"", "")) == true)
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
case ">":
|
|
|
case "dayu":
|
|
|
if (en.GetValDoubleByKey(this.AttrKey) > Double.Parse(this.OperatorValue.ToString()))
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
|
|
|
//if (en.GetValDoubleByKey(this.AttrKey) > Double.Parse(this.OperatorValue.ToString()))
|
|
|
// return true;
|
|
|
//else
|
|
|
// return false;
|
|
|
case ">=":
|
|
|
case "dayudengyu":
|
|
|
if (en.GetValDoubleByKey(this.AttrKey) >= Double.Parse(this.OperatorValue.ToString()))
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
case "<":
|
|
|
case "xiaoyu":
|
|
|
if (en.GetValDoubleByKey(this.AttrKey) < Double.Parse(this.OperatorValue.ToString()))
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
//if (en.GetValDoubleByKey(this.AttrKey) < Double.Parse(this.OperatorValue.ToString()))
|
|
|
// return true;
|
|
|
//else
|
|
|
// return false;
|
|
|
case "<=":
|
|
|
case "xiaoyudengyu":
|
|
|
if (en.GetValDoubleByKey(this.AttrKey) <= Double.Parse(this.OperatorValue.ToString()))
|
|
|
return true;
|
|
|
else
|
|
|
return false;
|
|
|
case "like":
|
|
|
case "baohan":
|
|
|
if (en.GetValStringByKey(this.AttrKey).IndexOf(this.OperatorValue.ToString()) == -1)
|
|
|
return false;
|
|
|
else
|
|
|
return true;
|
|
|
default:
|
|
|
throw new Exception("@没有找到操作符号(" + this.FK_Operator.Trim().ToLower() + ").");
|
|
|
}
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
Node nd23 = new Node(this.FK_Node);
|
|
|
throw new Exception("@判断条件:Node=[" + this.FK_Node + "," + nd23.EnDesc + "], 出现错误。@" + ex.Message + "。有可能您设置了非法的条件判断方式。");
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 属性
|
|
|
/// </summary>
|
|
|
public override Map EnMap
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
if (this._enMap != null)
|
|
|
return this._enMap;
|
|
|
Map map = new Map("WF_Cond", "条件");
|
|
|
|
|
|
map.AddMyPK();
|
|
|
|
|
|
//for vue版本数据主从格式. 2022.9.28.
|
|
|
map.AddTBString(CondAttr.RefPKVal, null, "关联主键", true, true, 0, 40, 20);
|
|
|
|
|
|
//为流程的模板导出.
|
|
|
map.AddTBString(CondAttr.RefFlowNo, null, "流程编号", true, true, 0, 5, 20);
|
|
|
|
|
|
//用于整体流程的删除，导入，导出.
|
|
|
map.AddTBString(CondAttr.RefFlowNo, null, "流程编号", true, true, 0, 5, 20);
|
|
|
map.AddTBInt(CondAttr.FK_Node, 0, "节点ID", true, true);
|
|
|
|
|
|
|
|
|
//@0=节点完成条件@1=流程条件@2=方向条件@3=启动子流程.
|
|
|
map.AddTBInt(CondAttr.CondType, 0, "条件类型", true, true);
|
|
|
map.AddTBString(CondAttr.FK_Flow, null, "流程", true, true, 0, 4, 20);
|
|
|
|
|
|
//对于启动子流程规则有效. *************************************
|
|
|
map.AddTBString(CondAttr.SubFlowNo, null, "子流程编号", true, true, 0, 5, 20);
|
|
|
|
|
|
//对方向条件有效. *************************************
|
|
|
map.AddTBInt(CondAttr.ToNodeID, 0, "ToNodeID（对方向条件有效）", true, true);
|
|
|
|
|
|
|
|
|
//条件字段. *************************************
|
|
|
//@0=NodeForm表单数据,1=StandAloneFrm独立表单,2=Stas角色数据,3=Depts,4=按sql计算.
|
|
|
//5,按sql模版计算.6,按参数,7=按Url @=100条件表达式.
|
|
|
map.AddTBInt(CondAttr.DataFrom, 0, "条件数据来源", true, true);
|
|
|
map.AddTBString(CondAttr.DataFromText, null, "条件数据来源T", true, true, 0, 4, 20);
|
|
|
map.AddTBString(CondAttr.FK_Attr, null, "属性", true, true, 0, 80, 20);
|
|
|
map.AddTBString(CondAttr.AttrKey, null, "属性键", true, true, 0, 60, 20);
|
|
|
map.AddTBString(CondAttr.AttrName, null, "中文名称", true, true, 0, 500, 20);
|
|
|
map.AddTBString(CondAttr.FK_Operator, "=", "运算符号", true, true, 0, 60, 20);
|
|
|
map.AddTBString(CondAttr.OperatorValue, "", "要运算的值", true, true, 0, 4000, 20);
|
|
|
map.AddTBString(CondAttr.OperatorValueT, "", "要运算的值T", true, true, 0, 4000, 20);
|
|
|
map.AddTBString(CondAttr.Note, null, "备注", true, true, 0, 500, 20);
|
|
|
map.AddTBString(CondAttr.FK_DBSrc, "local", "SQL的数据来源", false, true, 0, 50, 20);
|
|
|
//参数 for wangrui add 2015.10.6. 条件为station,depts模式的时候，需要指定人员。
|
|
|
map.AddTBAtParas(2000);
|
|
|
map.AddTBInt(CondAttr.Idx, 0, "优先级", true, true);
|
|
|
map.AddTBInt(CondAttr.JSFX, 0, "计算方向", true, true);
|
|
|
|
|
|
//用到了UIBindKey的存储.
|
|
|
map.AddTBString(CondAttr.Tag1, null, "Tag1", true, true, 0, 100, 20);
|
|
|
|
|
|
this._enMap = map;
|
|
|
return this._enMap;
|
|
|
}
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
private string GenerDeptNosString(string deptNo, string deptNos)
|
|
|
{
|
|
|
BP.Port.Depts ens = new BP.Port.Depts();
|
|
|
ens.Retrieve(EntityTreeAttr.ParentNo, deptNo);
|
|
|
|
|
|
foreach (BP.Port.Dept en in ens)
|
|
|
{
|
|
|
deptNos += "," + en.No;
|
|
|
GenerDeptNosString(en.No, deptNos);
|
|
|
}
|
|
|
return deptNos;
|
|
|
}
|
|
|
|
|
|
/// <summary>
|
|
|
/// 是否递归子部门 - 对部门条件计算有效.
|
|
|
/// </summary>
|
|
|
public bool IsSubDept
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string val = this.GetValStringByKey("Tag1");
|
|
|
if (DataType.IsNullOrEmpty(val) == true || val.Equals("0"))
|
|
|
return false;
|
|
|
return true;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 条件s
|
|
|
/// </summary>
|
|
|
public class Conds : Entities
|
|
|
{
|
|
|
#region 属性
|
|
|
public string ConditionDesc
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
return "";
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 获得Entity
|
|
|
/// </summary>
|
|
|
public override Entity GetNewEntity
|
|
|
{
|
|
|
get { return new Cond(); }
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 执行计算
|
|
|
/// </summary>
|
|
|
/// <param name="runModel">模式</param>
|
|
|
/// <returns></returns>
|
|
|
public bool GenerResult(GERpt en = null)
|
|
|
{
|
|
|
|
|
|
try
|
|
|
{
|
|
|
if (this.Count == 0)
|
|
|
throw new Exception("err@没有要计算的条件，无法计算.");
|
|
|
|
|
|
//给条件赋值.
|
|
|
if (en != null)
|
|
|
{
|
|
|
foreach (Cond cd in this)
|
|
|
{
|
|
|
cd.WorkID = en.OID;
|
|
|
cd.en = en;
|
|
|
}
|
|
|
}
|
|
|
|
|
|
#region 首先计算简单的.
|
|
|
//如果只有一个条件,就直接范围该条件的执行结果.
|
|
|
if (this.Count == 1)
|
|
|
{
|
|
|
Cond cond = this[0] as Cond;
|
|
|
return cond.IsPassed;
|
|
|
}
|
|
|
#endregion 首先计算简单的.
|
|
|
|
|
|
#region 处理混合计算。
|
|
|
string exp = "";
|
|
|
foreach (Cond item in this)
|
|
|
{
|
|
|
if (item.HisDataFrom == ConnDataFrom.CondOperator)
|
|
|
{
|
|
|
exp += " " + item.OperatorValue;
|
|
|
continue;
|
|
|
}
|
|
|
|
|
|
if (item.IsPassed)
|
|
|
exp += " 1=1 ";
|
|
|
else
|
|
|
exp += " 1=2 ";
|
|
|
}
|
|
|
|
|
|
//如果是混合计算.
|
|
|
string sql = "";
|
|
|
switch (BP.Difference.SystemConfig.AppCenterDBType)
|
|
|
{
|
|
|
case DBType.MSSQL:
|
|
|
sql = " SELECT TOP 1 No FROM WF_Emp WHERE " + exp;
|
|
|
break;
|
|
|
case DBType.MySQL:
|
|
|
case DBType.PostgreSQL:
|
|
|
case DBType.UX:
|
|
|
sql = " SELECT No FROM WF_Emp WHERE " + exp + " limit 1 ";
|
|
|
break;
|
|
|
case DBType.Oracle:
|
|
|
case DBType.KingBaseR3:
|
|
|
case DBType.KingBaseR6:
|
|
|
case DBType.DM:
|
|
|
sql = " SELECT No FROM WF_Emp WHERE " + exp + " AND rownum <=1 ";
|
|
|
break;
|
|
|
default:
|
|
|
throw new Exception("err@没有做的数据库类型判断.");
|
|
|
}
|
|
|
|
|
|
DataTable dt = DBAccess.RunSQLReturnTable(sql);
|
|
|
if (dt.Rows.Count == 0)
|
|
|
return false;
|
|
|
return true;
|
|
|
#endregion 处理混合计算。
|
|
|
}
|
|
|
catch (Exception ex)
|
|
|
{
|
|
|
throw new Exception("err@计算条件出现错误:" + this.NodeID + " - " + ex.Message);
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 描述
|
|
|
/// </summary>
|
|
|
public string MsgOfDesc
|
|
|
{
|
|
|
get
|
|
|
{
|
|
|
string msg = "";
|
|
|
foreach (Cond c in this)
|
|
|
{
|
|
|
msg += "@" + c.MsgOfCond;
|
|
|
}
|
|
|
return msg;
|
|
|
}
|
|
|
}
|
|
|
public int NodeID = 0;
|
|
|
#endregion
|
|
|
|
|
|
#region 构造
|
|
|
/// <summary>
|
|
|
/// 条件
|
|
|
/// </summary>
|
|
|
public Conds()
|
|
|
{
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 条件
|
|
|
/// </summary>
|
|
|
/// <param name="fk_flow">流程编号</param>
|
|
|
public Conds(string fk_flow)
|
|
|
{
|
|
|
this.Retrieve(CondAttr.FK_Flow, fk_flow);
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 条件
|
|
|
/// </summary>
|
|
|
/// <param name="ct">类型</param>
|
|
|
/// <param name="nodeID">节点</param>
|
|
|
public Conds(CondType ct, int nodeID, Int64 workid, GERpt enData)
|
|
|
{
|
|
|
this.NodeID = nodeID;
|
|
|
this.Retrieve(CondAttr.FK_Node, nodeID, CondAttr.CondType, (int)ct, CondAttr.Idx);
|
|
|
foreach (Cond en in this)
|
|
|
{
|
|
|
en.WorkID = workid;
|
|
|
en.en = enData;
|
|
|
}
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 条件 - 配置信息
|
|
|
/// </summary>
|
|
|
/// <param name="ct"></param>
|
|
|
/// <param name="nodeID"></param>
|
|
|
public Conds(CondType ct, int nodeID)
|
|
|
{
|
|
|
this.Retrieve(CondAttr.FK_Node, nodeID, CondAttr.CondType, (int)ct, CondAttr.Idx);
|
|
|
}
|
|
|
#endregion
|
|
|
|
|
|
#region 为了适应自动翻译成java的需要,把实体转换成List.
|
|
|
/// <summary>
|
|
|
/// 转化成 java list,C#不能调用.
|
|
|
/// </summary>
|
|
|
/// <returns>List</returns>
|
|
|
public System.Collections.Generic.IList<Cond> ToJavaList()
|
|
|
{
|
|
|
return (System.Collections.Generic.IList<Cond>)this;
|
|
|
}
|
|
|
/// <summary>
|
|
|
/// 转化成list
|
|
|
/// </summary>
|
|
|
/// <returns>List</returns>
|
|
|
public System.Collections.Generic.List<Cond> Tolist()
|
|
|
{
|
|
|
System.Collections.Generic.List<Cond> list = new System.Collections.Generic.List<Cond>();
|
|
|
for (int i = 0; i < this.Count; i++)
|
|
|
{
|
|
|
list.Add((Cond)this[i]);
|
|
|
}
|
|
|
return list;
|
|
|
}
|
|
|
#endregion 为了适应自动翻译成java的需要,把实体转换成List.
|
|
|
}
|
|
|
}
|