/// <summary>
/// 初始化
/// </summary>
/// <returns></returns>
public string StandAloneFrm_Init()
{
ps = new Paras();
ps.SQL = "SELECT m.No, m.Name, n.FK_Node, n.FK_Flow FROM WF_FrmNode n INNER JOIN Sys_MapData m ON n.FK_Frm=m.No WHERE n.FrmEnableRole!=5 AND n.FK_Node=" + SystemConfig.AppCenterDBVarStr + "FK_Node";
ps.Add("FK_Node", this.FK_Node);
//string sql = "SELECT m.No, m.Name, n.FK_Node, n.FK_Flow FROM WF_FrmNode n INNER JOIN Sys_MapData m ON n.FK_Frm=m.No WHERE n.FrmEnableRole!=5 AND n.FK_Node=" + this.FK_Node;
DataTable dt = DBAccess.RunSQLReturnTable(ps);
dt.TableName = "Frms";
dt.Columns[0].ColumnName = "No";
dt.Columns[1].ColumnName = "Name";
DataRow dr = dt.NewRow();
dr[0] = "all";
dr[1] = "请选择表单";
dt.Rows.Add(dr);
DataSet ds = new DataSet();
ds.Tables.Add(dt);
//增加条件集合.
string fk_mainNode = this.GetRequestVal("FK_MainNode");
string toNodeID = this.GetRequestVal("ToNodeID");
Conds conds = new Conds();
conds.Retrieve(CondAttr.FK_Node, fk_mainNode, CondAttr.ToNodeID, toNodeID);
ds.Tables.Add(conds.ToDataTableField("WF_Conds"));
return(BP.Tools.Json.DataSetToJson(ds, false)); // cond.ToJson();
}
public string CondPRI_Move()
{
switch (this.GetRequestVal("MoveType"))
{
case "Up":
Cond up = new Cond(this.MyPK);
up.DoUp(this.FK_Node);
up.RetrieveFromDBSources();
DBAccess.RunSQL("UPDATE WF_Cond SET PRI=" + up.PRI + " WHERE ToNodeID=" + up.ToNodeID);
break;
case "Down":
Cond down = new Cond(this.MyPK);
down.DoDown(this.FK_Node);
down.RetrieveFromDBSources();
DBAccess.RunSQL("UPDATE WF_Cond SET PRI=" + down.PRI + " WHERE ToNodeID=" + down.ToNodeID);
break;
default:
break;
}
Conds cds = new Conds();
cds.Retrieve(CondAttr.FK_Node, this.FK_Node, CondAttr.CondType, 2, CondAttr.PRI);
return(cds.ToJson());
}
public void AddCond(CondVM cond)
{
CondVM newCond = CondVM.CreateDefault(this);
Conds.Add(newCond);
OnCondsOrderChanged();
}
public void DownCond(CondVM cond)
{
int index = Conds.IndexOf(cond);
Conds.Move(index, index + 1);
OnCondsOrderChanged();
}
/// <summary>
/// 初始化
/// </summary>
/// <returns></returns>
public string CondByFrm_Init()
{
DataSet ds = new DataSet();
string fk_mainNode = this.GetRequestVal("FK_MainNode");
string toNodeID = this.GetRequestVal("ToNodeID");
Node nd = new Node(int.Parse(fk_mainNode));
CondType condTypeEnum = (CondType)this.GetRequestValInt("CondType");
//string mypk = fk_mainNode + "_" + toNodeID + "_" + condTypeEnum + "_" + ConnDataFrom.SQLTemplate.ToString();
//增加条件集合.
Conds conds = new Conds();
conds.Retrieve(CondAttr.FK_Node, fk_mainNode, CondAttr.ToNodeID, toNodeID);
ds.Tables.Add(conds.ToDataTableField("WF_Conds"));
string noteIn = "'FID','PRI','PNodeID','PrjNo', 'PrjName', 'FK_NY','FlowDaySpan', 'MyNum','Rec','CDT','RDT','AtPara','WFSta','FlowNote','FlowStartRDT','FlowEnderRDT','FlowEnder','FlowSpanDays','WFState','OID','PWorkID','PFlowNo','PEmp','FlowEndNode','GUID'";
//增加字段集合.
string sql = "";
if (SystemConfig.AppCenterDBType == DBType.Oracle || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
sql = "SELECT KeyOfEn as No, KeyOfEn||' - '||Name as Name FROM Sys_MapAttr WHERE FK_MapData='ND" + int.Parse(nd.FK_Flow) + "Rpt'";
sql += " AND KeyOfEn Not IN (" + noteIn + ") ";
sql += " AND MyDataType NOT IN (6,7) ";
}
else if (SystemConfig.AppCenterDBType == DBType.MySQL)
{
sql = "SELECT KeyOfEn as No, CONCAT(KeyOfEn,' - ', Name ) as Name FROM Sys_MapAttr WHERE FK_MapData='ND" + int.Parse(nd.FK_Flow) + "Rpt'";
sql += " AND KeyOfEn Not IN (" + noteIn + ") ";
sql += " AND MyDataType NOT IN (6,7) ";
}
else
{
sql = "SELECT KeyOfEn as No, KeyOfEn+' - '+Name as Name FROM Sys_MapAttr WHERE FK_MapData='ND" + int.Parse(nd.FK_Flow) + "Rpt'";
sql += " AND KeyOfEn Not IN (" + noteIn + ") ";
sql += " AND MyDataType NOT IN (6,7) ";
}
DataTable dt = DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_MapAttr";
dt.Columns[0].ColumnName = "No";
dt.Columns[1].ColumnName = "Name";
DataRow dr = dt.NewRow();
dr[0] = "all";
dr[1] = "请选择表单字段";
dt.Rows.Add(dr);
ds.Tables.Add(dt);
return(BP.Tools.Json.DataSetToJson(ds, false)); // cond.ToJson();
}
public bool CanUpCond(CondVM cond)
{
int index = Conds.IndexOf(cond);
if (index == 0)
{
return(false);
}
return(true);
}
public bool CanDownCond(CondVM cond)
{
int index = Conds.IndexOf(cond);
if (index == Conds.Count - 1)
{
return(false);
}
return(true);
}
/// <summary>
/// 初始化
/// </summary>
/// <returns></returns>
public string CondPRI_Init()
{
Conds cds = new Conds();
cds.Retrieve(CondAttr.FK_Node, this.FK_Node, CondAttr.CondType, 2, CondAttr.PRI);
foreach (Cond item in cds)
{
Node nd = new Node(item.ToNodeID);
item.Note = nd.Name;
}
return(cds.ToJson());
}
protected void Page_Load(object sender, EventArgs e)
{
switch (this.DoType)
{
case "Up":
Cond up = new Cond(this.MyPK);
up.DoUp(this.FK_MainNode);
up.RetrieveFromDBSources();
DBAccess.RunSQL("UPDATE WF_Cond SET PRI=" + up.PRI + " WHERE ToNodeID=" + up.ToNodeID);
break;
case "Down":
Cond down = new Cond(this.MyPK);
down.DoDown(this.FK_MainNode);
down.RetrieveFromDBSources();
DBAccess.RunSQL("UPDATE WF_Cond SET PRI=" + down.PRI + " WHERE ToNodeID=" + down.ToNodeID);
break;
default:
break;
}
BP.WF.Node nd = new BP.WF.Node(this.FK_MainNode);
this.Pub1.AddTable("class='Table' cellSpacing='1' cellPadding='1' border='1' style='width:100%'");
this.Pub1.AddTR();
this.Pub1.AddTD("class='GroupTitle' colspan='7'", nd.Name);
this.Pub1.AddTREnd();
this.Pub1.AddTR();
this.Pub1.AddTD("class='GroupTitle'", "从节点ID");
this.Pub1.AddTD("class='GroupTitle'", "从节点名称");
this.Pub1.AddTD("class='GroupTitle'", "到节点ID");
this.Pub1.AddTD("class='GroupTitle'", "到节点名称");
this.Pub1.AddTD("class='GroupTitle'", "优先级");
this.Pub1.AddTD("class='GroupTitle' colspan=2", "操作");
this.Pub1.AddTREnd();
Conds cds = new Conds();
//BP.En.QueryObject qo = new QueryObject(cds);
//qo.AddWhere(CondAttr.FK_Node, this.FK_MainNode);
//qo.addAnd();
//qo.AddWhere(CondAttr.FK_Node, this.FK_MainNode);
cds.Retrieve(CondAttr.FK_Node, this.FK_MainNode, CondAttr.CondType, 2, CondAttr.PRI);
string strs = "";
foreach (Cond cd in cds)
{
if (strs.Contains("," + cd.ToNodeID.ToString()))
{
continue;
}
strs += "," + cd.ToNodeID.ToString();
BP.WF.Node mynd = new BP.WF.Node(cd.ToNodeID);
this.Pub1.AddTR();
this.Pub1.AddTD(nd.NodeID);
this.Pub1.AddTD(nd.Name);
this.Pub1.AddTD(mynd.NodeID);
this.Pub1.AddTD(mynd.Name);
this.Pub1.AddTD(cd.PRI);
this.Pub1.AddTD("<a href='CondPRI.aspx?CondType=2&DoType=Up&FK_Flow=" + this.FK_Flow + "&FK_MainNode=" + this.FK_MainNode + "&ToNodeID=" + this.ToNodeID + "&MyPK=" + cd.MyPK + "' class='easyui-linkbutton' data-options=\"iconCls:'icon-up'\">上移</a>");
this.Pub1.AddTD("<a href='CondPRI.aspx?CondType=2&DoType=Down&FK_Flow=" + this.FK_Flow + "&FK_MainNode=" + this.FK_MainNode + "&ToNodeID=" + this.ToNodeID + "&MyPK=" + cd.MyPK + "' class='easyui-linkbutton' data-options=\"iconCls:'icon-down'\">下移</a>");
this.Pub1.AddTREnd();
}
this.Pub1.AddTableEnd();
this.Pub1.AddBR();
string help = "";
help += "<ul>";
help += "<li>在转向中，如果出现一个以上的路线都成立时时，系统就会按照第一个路线来计算，那一个排列最前面就按照那一个计算。</li>";
help += "<li>例如：在demo中002.请假流程，如果一个人员既有基层岗，也有中层岗那么到达基层与中层的路线都会成立，如果设置了方向条件的优先级，系统就会按照优先满足的条件的路线计算。</li>";
help += "</ul>";
this.Pub1.AddEasyUiPanelInfo("帮助", "<span style='font-weight:bold'>什么是方向条件的优先级？</span><br />" + Environment.NewLine
+ help, "icon-help");
}
public override String ToString()
{
return ("DoExp(\n" + Vars.ToString() + ",\n" + Conds.ToString() + ")\n") ;
}
void btn_Save_Click(object sender, EventArgs e)
{
//Button btn = sender as Button;
var btn = sender as LinkBtn;
if (btn.ID == NamesOfBtn.Delete)
{
DBAccess.RunSQL("DELETE FROM WF_Cond WHERE ToNodeID=" + this.ToNodeID + " AND DataFrom=" + (int)ConnDataFrom.Form);
this.Response.Redirect(this.Request.RawUrl, true);
return;
}
if (this.GetOperVal == "" || this.GetOperVal == null)
{
this.Alert("您没有设置条件，请在值文本框中输入值。");
return;
}
DBAccess.RunSQL("DELETE FROM WF_Cond WHERE (" + CondAttr.NodeID + "=" + this.FK_Node + " AND ToNodeID=" + this.ToNodeID + ") AND DataFrom!=" + (int)ConnDataFrom.Form);
Cond cond = new Cond();
cond.HisDataFrom = ConnDataFrom.Form;
cond.NodeID = this.FK_MainNode;
cond.ToNodeID = this.FK_MainNode;
cond.FK_Attr = this.FK_Attr;
cond.FK_Node = this.DDL_Node.SelectedItemIntVal;
cond.FK_Operator = this.DDL_Oper.SelectedItemStringVal;
cond.OperatorValue = this.GetOperVal;
cond.OperatorValueT = this.GetOperValText;
cond.FK_Flow = this.FK_Flow;
cond.HisCondType = this.HisCondType;
if (btn.ID == "Btn_SaveAnd")
{
cond.CondOrAnd = CondOrAnd.ByAnd;
}
else
{
cond.CondOrAnd = CondOrAnd.ByOr;
}
#region 方向条件，全部更新.
Conds conds = new Conds();
QueryObject qo = new QueryObject(conds);
qo.AddWhere(CondAttr.NodeID, this.FK_MainNode);
qo.addAnd();
qo.AddWhere(CondAttr.DataFrom, (int)ConnDataFrom.Form);
qo.addAnd();
qo.AddWhere(CondAttr.CondType, (int)this.HisCondType);
if (this.ToNodeID != 0)
{
qo.addAnd();
qo.AddWhere(CondAttr.ToNodeID, this.ToNodeID);
}
int num = qo.DoQuery();
foreach (Cond item in conds)
{
item.CondOrAnd = cond.CondOrAnd;
item.Update();
}
#endregion
/* 执行同步*/
string sqls = "UPDATE WF_Node SET IsCCFlow=0";
sqls += "@UPDATE WF_Node SET IsCCFlow=1 WHERE NodeID IN (SELECT NODEID FROM WF_Cond a WHERE a.NodeID= NodeID AND CondType=1 )";
BP.DA.DBAccess.RunSQLs(sqls);
string sql = "UPDATE WF_Cond SET DataFrom=" + (int)ConnDataFrom.Form + " WHERE NodeID=" + cond.NodeID + " AND FK_Node=" + cond.FK_Node + " AND ToNodeID=" + this.ToNodeID;
switch (this.HisCondType)
{
case CondType.Flow:
case CondType.Node:
// case CondType.FLRole:
cond.MyPK = BP.DA.DBAccess.GenerOID().ToString(); //cond.NodeID + "_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.Insert();
BP.DA.DBAccess.RunSQL(sql);
this.Response.Redirect("Cond.aspx?MyPK=" + cond.MyPK + "&FK_Flow=" + cond.FK_Flow + "&FK_Node=" + cond.FK_Node + "&FK_MainNode=" + cond.NodeID + "&CondType=" + (int)cond.HisCondType + "&FK_Attr=" + cond.FK_Attr + "&ToNodeID=" + this.Request.QueryString["ToNodeID"], true);
break;
case CondType.Dir:
// cond.MyPK = cond.NodeID +"_"+ this.Request.QueryString["ToNodeID"]+"_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.MyPK = BP.DA.DBAccess.GenerOID().ToString(); //cond.NodeID + "_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.ToNodeID = this.ToNodeID;
cond.Insert();
BP.DA.DBAccess.RunSQL(sql);
this.Response.Redirect("Cond.aspx?MyPK=" + cond.MyPK + "&FK_Flow=" + cond.FK_Flow + "&FK_Node=" + cond.FK_Node + "&FK_MainNode=" + cond.NodeID + "&CondType=" + (int)cond.HisCondType + "&FK_Attr=" + cond.FK_Attr + "&ToNodeID=" + this.Request.QueryString["ToNodeID"], true);
break;
default:
throw new Exception("未设计的情况。");
}
EasyUiHelper.AddEasyUiMessager(this, "保存成功！");
}
public void BindCond()
{
string msg = "";
string note = "";
Cond cond = new Cond();
cond.MyPK = this.MyPK;
if (cond.RetrieveFromDBSources() == 0)
{
if (this.FK_Attr != null)
{
cond.FK_Attr = this.FK_Attr;
}
if (this.FK_MainNode != 0)
{
cond.NodeID = this.FK_MainNode;
}
if (this.FK_Node != 0)
{
cond.FK_Node = this.FK_Node;
}
if (this.FK_Flow != null)
{
cond.FK_Flow = this.FK_Flow;
}
}
//this.AddTable("border=0 widht='500px'");
this.AddTable("class='Table' cellpadding='2' cellspacing='2' style='width:100%;'");
this.AddTR();
this.AddTD("class='GroupTitle' style='width:80px'", "项目");
this.AddTD("class='GroupTitle' style='width:200px'", "采集");
this.AddTD("class='GroupTitle'", "描述");
this.AddTREnd();
this.AddTR();
this.AddTD("节点");
Nodes nds = new Nodes(cond.FK_Flow);
Nodes ndsN = new Nodes();
foreach (BP.WF.Node mynd in nds)
{
ndsN.AddEntity(mynd);
}
DDL ddl = new DDL();
ddl.ID = "DDL_Node";
ddl.BindEntities(ndsN, "NodeID", "Name");
ddl.SetSelectItem(cond.FK_Node);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);
this.AddTD(ddl);
this.AddTD("节点");
this.AddTREnd();
// 属性/字段
MapAttrs attrs = new MapAttrs();
attrs.Retrieve(MapAttrAttr.FK_MapData, "ND" + ddl.SelectedItemStringVal);
MapAttrs attrNs = new MapAttrs();
foreach (MapAttr attr in attrs)
{
if (attr.IsBigDoc)
{
continue;
}
switch (attr.KeyOfEn)
{
case "Title":
//case "RDT":
//case "CDT":
case "FK_Emp":
case "MyNum":
case "FK_NY":
case WorkAttr.Emps:
case WorkAttr.OID:
case StartWorkAttr.Rec:
case StartWorkAttr.FID:
continue;
default:
break;
}
attrNs.AddEntity(attr);
}
ddl = new DDL();
ddl.ID = "DDL_Attr";
if (attrNs.Count == 0)
{
BP.WF.Node nd = new BP.WF.Node(cond.FK_Node);
nd.RepareMap();
this.AddTR();
this.AddTD("");
this.AddTD("colspan=2", "节点没有找到合适的条件");
this.AddTREnd();
this.AddTableEnd();
return;
}
else
{
ddl.BindEntities(attrNs, MapAttrAttr.MyPK, MapAttrAttr.Name);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);
ddl.SetSelectItem(cond.FK_Attr);
}
this.AddTR();
this.AddTD("属性/字段");
this.AddTD(ddl);
this.AddTD("");
this.AddTREnd();
MapAttr attrS = new MapAttr(this.DDL_Attr.SelectedItemStringVal);
this.AddTR();
this.AddTD("操作符");
ddl = new DDL();
ddl.ID = "DDL_Oper";
switch (attrS.LGType)
{
case BP.En.FieldTypeS.Enum:
case BP.En.FieldTypeS.FK:
ddl.Items.Add(new ListItem("=", "="));
ddl.Items.Add(new ListItem("<>", "<>"));
break;
case BP.En.FieldTypeS.Normal:
switch (attrS.MyDataType)
{
case BP.DA.DataType.AppString:
case BP.DA.DataType.AppDate:
case BP.DA.DataType.AppDateTime:
ddl.Items.Add(new ListItem("=", "="));
ddl.Items.Add(new ListItem("LIKE", "LIKE"));
ddl.Items.Add(new ListItem("<>", "<>"));
break;
case BP.DA.DataType.AppBoolean:
ddl.Items.Add(new ListItem("=", "="));
break;
default:
ddl.Items.Add(new ListItem("=", "="));
ddl.Items.Add(new ListItem(">", ">"));
ddl.Items.Add(new ListItem(">=", ">="));
ddl.Items.Add(new ListItem("<", "<"));
ddl.Items.Add(new ListItem("<=", "<="));
ddl.Items.Add(new ListItem("<>", "<>"));
break;
}
break;
default:
break;
}
if (cond != null)
{
try
{
ddl.SetSelectItem(cond.OperatorValueInt);
}
catch
{
}
}
this.AddTD(ddl);
this.AddTD("");
this.AddTREnd();
switch (attrS.LGType)
{
case BP.En.FieldTypeS.Enum:
this.AddTR();
this.AddTD("值");
ddl = new DDL();
ddl.ID = "DDL_Val";
ddl.BindSysEnum(attrS.UIBindKey);
if (cond != null)
{
try
{
ddl.SetSelectItem(cond.OperatorValueInt);
}
catch
{
}
}
this.AddTD(ddl);
this.AddTD("");
this.AddTREnd();
break;
case BP.En.FieldTypeS.FK:
this.AddTR();
this.AddTD("值");
ddl = new DDL();
ddl.ID = "DDL_Val";
ddl.BindEntities(attrS.HisEntitiesNoName);
if (cond != null)
{
try
{
ddl.SetSelectItem(cond.OperatorValueStr);
}
catch
{
}
}
this.AddTD(ddl);
this.AddTD("");
this.AddTREnd();
break;
default:
if (attrS.MyDataType == BP.DA.DataType.AppBoolean)
{
this.AddTR();
this.AddTD("值");
ddl = new DDL();
ddl.ID = "DDL_Val";
ddl.BindAppYesOrNo(0);
if (cond != null)
{
try
{
ddl.SetSelectItem(cond.OperatorValueInt);
}
catch
{
}
}
this.AddTD(ddl);
this.AddTD();
this.AddTREnd();
}
else
{
this.AddTR();
this.AddTD("值");
TB tb = new TB();
tb.ID = "TB_Val";
if (cond != null)
{
tb.Text = cond.OperatorValueStr;
}
this.AddTD(tb);
this.AddTD();
this.AddTREnd();
}
break;
}
Conds conds = new Conds();
QueryObject qo = new QueryObject(conds);
qo.AddWhere(CondAttr.NodeID, this.FK_MainNode);
qo.addAnd();
qo.AddWhere(CondAttr.DataFrom, (int)ConnDataFrom.Form);
qo.addAnd();
qo.AddWhere(CondAttr.CondType, (int)this.HisCondType);
if (this.ToNodeID != 0)
{
qo.addAnd();
qo.AddWhere(CondAttr.ToNodeID, this.ToNodeID);
}
int num = qo.DoQuery();
this.AddTableEnd();
this.AddBR();
this.AddSpace(1);
var btn = new LinkBtn(false, "Btn_SaveAnd", "保存为And条件");
btn.SetDataOption("iconCls", "'icon-save'");
btn.Click += new EventHandler(btn_Save_Click);
this.Add(btn);
this.AddSpace(1);
btn = new LinkBtn(false, "Btn_SaveOr", "保存为Or条件");
btn.SetDataOption("iconCls", "'icon-save'");
btn.Click += new EventHandler(btn_Save_Click);
this.Add(btn);
this.AddSpace(1);
btn = new LinkBtn(false, NamesOfBtn.Delete, "删除");
btn.Attributes["onclick"] = " return confirm('您确定要删除吗？');";
btn.Click += new EventHandler(btn_Save_Click);
this.Add(btn);
this.AddBR();
this.AddBR();
if (num == 0)
{
return;
}
#region 条件
this.AddTable("class='Table' cellpadding='2' cellspacing='2' style='width:100%;'");
this.AddTR();
this.AddTDTitleGroup("序");
this.AddTDTitleGroup("节点");
this.AddTDTitleGroup("字段的英文名");
this.AddTDTitleGroup("字段的中文名");
this.AddTDTitleGroup("操作符");
this.AddTDTitleGroup("值");
this.AddTDTitleGroup("标签");
this.AddTDTitleGroup("运算关系");
this.AddTDTitleGroup("操作");
this.AddTREnd();
int i = 0;
foreach (Cond mync in conds)
{
if (mync.HisDataFrom != ConnDataFrom.Form)
{
continue;
}
i++;
this.AddTR();
this.AddTDIdx(i);
// this.AddTD(mync.HisDataFrom.ToString());
this.AddTD(mync.FK_NodeT);
this.AddTD(mync.AttrKey);
this.AddTD(mync.AttrName);
this.AddTDCenter(mync.FK_Operator);
this.AddTD(mync.OperatorValueStr);
this.AddTD(mync.OperatorValueT);
if (mync.CondOrAnd == CondOrAnd.ByAnd)
{
this.AddTD("AND");
}
else
{
this.AddTD("OR");
}
//if (num > 1)
// this.AddTD(mync.HisConnJudgeWayT);
this.AddTD("<a href='Cond.aspx?MyPK=" + mync.MyPK + "&CondType=" + (int)this.HisCondType + "&FK_Flow=" + this.FK_Flow + "&FK_Attr=" + mync.FK_Attr + "&FK_MainNode=" + mync.NodeID + "&OperatorValue=" + mync.OperatorValueStr + "&FK_Node=" + mync.FK_Node + "&DoType=Del&ToNodeID=" + mync.ToNodeID + "' class='easyui-linkbutton' data-options=\"iconCls:'icon-remove'\" onclick=\"return confirm('确定删除此条件吗?')\">删除</a>");
this.AddTREnd();
}
this.AddTableEnd();
this.AddBR();
AddEasyUiPanelInfo("说明", "在上面的条件集合中ccflow仅仅支持要么是And,要么是OR的两种情形,高级的开发就需要事件来支持条件转向,或者采用其他的方式。");
#endregion
}
public void RemoveCond(CondVM cond)
{
Conds.Remove(cond);
OnCondsOrderChanged();
}
public bool IsLastCond(CondVM cond)
{
return(Conds.Last() == cond);
}
public string StandAloneFrm_Save()
{
string frmID = this.GetRequestVal("FrmID");
//定义变量.
string field = this.GetRequestVal("DDL_Fields");
field = frmID + "_" + field;
int toNodeID = this.GetRequestValInt("ToNodeID");
int fk_Node = this.GetRequestValInt("FK_Node");
string oper = this.GetRequestVal("DDL_Operator");
string operVal = this.GetRequestVal("OperVal");
//节点,子线城,还是其他
CondType condTypeEnum = (CondType)this.GetRequestValInt("CondType");
//把其他的条件都删除掉.
DBAccess.RunSQL("DELETE FROM WF_Cond WHERE (CondType=" + (int)condTypeEnum + " AND NodeID=" + this.FK_Node + " AND ToNodeID=" + toNodeID + ") AND DataFrom!=" + (int)ConnDataFrom.NodeForm);
Cond cond = new Cond();
cond.HisDataFrom = ConnDataFrom.StandAloneFrm;
cond.NodeID = fk_Node;
cond.ToNodeID = toNodeID;
cond.FK_Node = this.FK_Node;
cond.FK_Operator = oper;
cond.OperatorValue = operVal; //操作值.
cond.FK_Attr = field; //字段属性.
// cond.OperatorValueT = ""; // this.GetOperValText;
cond.FK_Flow = this.FK_Flow;
cond.HisCondType = condTypeEnum;
; //保存类型.
if (this.GetRequestVal("SaveType").Equals("AND") == true)
{
cond.CondOrAnd = CondOrAnd.ByAnd;
}
else
{
cond.CondOrAnd = CondOrAnd.ByOr;
}
#region 方向条件，全部更新.
Conds conds = new Conds();
QueryObject qo = new QueryObject(conds);
qo.AddWhere(CondAttr.NodeID, this.FK_Node);
qo.addAnd();
qo.AddWhere(CondAttr.DataFrom, (int)ConnDataFrom.StandAloneFrm);
qo.addAnd();
qo.AddWhere(CondAttr.CondType, (int)condTypeEnum);
if (toNodeID != 0)
{
qo.addAnd();
qo.AddWhere(CondAttr.ToNodeID, toNodeID);
}
int num = qo.DoQuery();
foreach (Cond item in conds)
{
item.CondOrAnd = cond.CondOrAnd;
item.Update();
}
#endregion
/* 执行同步*/
string sqls = "UPDATE WF_Node SET IsCCFlow=0";
sqls += "@UPDATE WF_Node SET IsCCFlow=1 WHERE NodeID IN (SELECT NODEID FROM WF_Cond a WHERE a.NodeID= NodeID AND CondType=1 )";
BP.DA.DBAccess.RunSQLs(sqls);
string sql = "UPDATE WF_Cond SET DataFrom=" + (int)ConnDataFrom.StandAloneFrm + " WHERE NodeID=" + cond.NodeID + " AND FK_Node=" + cond.FK_Node + " AND ToNodeID=" + toNodeID;
switch (condTypeEnum)
{
case CondType.Flow:
case CondType.Node:
cond.MyPK = BP.DA.DBAccess.GenerOID().ToString(); //cond.NodeID + "_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.Insert();
BP.DA.DBAccess.RunSQL(sql);
break;
case CondType.Dir:
// cond.MyPK = cond.NodeID +"_"+ this.Request.QueryString["ToNodeID"]+"_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.MyPK = BP.DA.DBAccess.GenerOID().ToString(); //cond.NodeID + "_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.ToNodeID = toNodeID;
cond.Insert();
BP.DA.DBAccess.RunSQL(sql);
break;
case CondType.SubFlow: //启动子流程.
cond.MyPK = BP.DA.DBAccess.GenerOID().ToString(); //cond.NodeID + "_" + cond.FK_Node + "_" + cond.FK_Attr + "_" + cond.OperatorValue;
cond.ToNodeID = toNodeID;
cond.Insert();
BP.DA.DBAccess.RunSQL(sql);
break;
default:
throw new Exception("未设计的情况。" + condTypeEnum.ToString());
}
return("保存成功!!");
}
protected void Page_Load(object sender, EventArgs e)
{
this.Left.AddFieldSet("帮助");
this.Left.AddB("什么是方向条件的优先级？");
this.Left.AddHR();
this.Left.Add("在方向条件判定中，ccflow会把方向条件按照优先级别排序进行计算。这种情况通常是在采用多个字段设置方向条件。");
this.Left.AddFieldSetEnd();
switch (this.DoType)
{
case "Up":
Cond up = new Cond(this.MyPK);
up.DoUp(this.FK_MainNode);
up.RetrieveFromDBSources();
DBAccess.RunSQL("UPDATE WF_Cond SET PRI=" + up.PRI + " WHERE ToNodeID=" + up.ToNodeID);
break;
case "Down":
Cond down = new Cond(this.MyPK);
down.DoDown(this.FK_MainNode);
down.RetrieveFromDBSources();
DBAccess.RunSQL("UPDATE WF_Cond SET PRI=" + down.PRI + " WHERE ToNodeID=" + down.ToNodeID);
break;
default:
break;
}
BP.WF.Node nd = new BP.WF.Node(this.FK_MainNode);
this.Pub1.AddTable();
this.Pub1.AddCaptionLeft(nd.Name);
this.Pub1.AddTR();
this.Pub1.AddTDTitle("从节点ID");
this.Pub1.AddTDTitle("从节点名称");
this.Pub1.AddTDTitle("到节点ID");
this.Pub1.AddTDTitle("到节点名称");
this.Pub1.AddTDTitle("优先级");
this.Pub1.AddTDTitle("colspan=2", "操作");
this.Pub1.AddTREnd();
Conds cds = new Conds();
//BP.En.QueryObject qo = new QueryObject(cds);
//qo.AddWhere(CondAttr.FK_Node, this.FK_MainNode);
//qo.addAnd();
//qo.AddWhere(CondAttr.FK_Node, this.FK_MainNode);
cds.Retrieve(CondAttr.FK_Node, this.FK_MainNode, CondAttr.CondType, 2, CondAttr.PRI);
string strs = "";
foreach (Cond cd in cds)
{
if (strs.Contains("," + cd.ToNodeID.ToString()))
{
continue;
}
strs += "," + cd.ToNodeID.ToString();
BP.WF.Node mynd = new BP.WF.Node(cd.ToNodeID);
this.Pub1.AddTR();
this.Pub1.AddTD(nd.NodeID);
this.Pub1.AddTD(nd.Name);
this.Pub1.AddTD(mynd.NodeID);
this.Pub1.AddTD(mynd.Name);
this.Pub1.AddTD(cd.PRI);
this.Pub1.AddTD("<a href='CondPRI.aspx?CondType=2&DoType=Up&FK_Flow=" + this.FK_Flow + "&FK_MainNode=" + this.FK_MainNode + "&ToNodeID=" + this.ToNodeID + "&MyPK=" + cd.MyPK + "'>上移</a>");
this.Pub1.AddTD("<a href='CondPRI.aspx?CondType=2&DoType=Down&FK_Flow=" + this.FK_Flow + "&FK_MainNode=" + this.FK_MainNode + "&ToNodeID=" + this.ToNodeID + "&MyPK=" + cd.MyPK + "'>下移</a>");
this.Pub1.AddTREnd();
}
this.Pub1.AddTableEnd();
}
public void BindCond()
{
string msg = "";
string note = "";
BP.WF.Cond cond = new Cond();
cond.MyPK = this.MyPK;
if (cond.RetrieveFromDBSources() == 0)
{
if (this.FK_Attr != null)
{
cond.FK_Attr = this.FK_Attr;
}
if (this.FK_MainNode != 0)
{
cond.NodeID = this.FK_MainNode;
}
if (this.FK_Node != 0)
{
cond.FK_Node = this.FK_Node;
}
if (this.FK_Flow != null)
{
cond.FK_Flow = this.FK_Flow;
}
}
this.AddTable("border=0 widht='500px'");
//this.AddCaptionLeft("");
this.AddTR();
this.AddTDTitle("项目");
this.AddTDTitle("采集");
this.AddTDTitle("描述");
this.AddTREnd();
this.AddTR();
this.AddTD("节点");
Nodes nds = new Nodes(cond.FK_Flow);
Nodes ndsN = new Nodes();
foreach (BP.WF.Node mynd in nds)
{
ndsN.AddEntity(mynd);
}
DDL ddl = new DDL();
ddl.ID = "DDL_Node";
ddl.BindEntities(ndsN, "NodeID", "Name");
ddl.SetSelectItem(cond.FK_Node);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);
this.AddTD(ddl);
this.AddTD("节点");
this.AddTREnd();
// 属性/字段
MapAttrs attrs = new MapAttrs();
attrs.Retrieve(MapAttrAttr.FK_MapData, "ND" + ddl.SelectedItemStringVal);
MapAttrs attrNs = new MapAttrs();
foreach (MapAttr attr in attrs)
{
if (attr.IsBigDoc)
{
continue;
}
switch (attr.KeyOfEn)
{
case "Title":
//case "RDT":
//case "CDT":
case "FK_Emp":
case "MyNum":
case "FK_NY":
case WorkAttr.Emps:
case WorkAttr.OID:
case StartWorkAttr.Rec:
case StartWorkAttr.FID:
continue;
default:
break;
}
attrNs.AddEntity(attr);
}
ddl = new DDL();
ddl.ID = "DDL_Attr";
if (attrNs.Count == 0)
{
BP.WF.Node nd = new BP.WF.Node(cond.FK_Node);
nd.RepareMap();
this.AddTR();
this.AddTD("");
this.AddTD("colspan=2", "节点没有找到合适的条件");
this.AddTREnd();
this.AddTableEnd();
return;
}
else
{
ddl.BindEntities(attrNs, MapAttrAttr.MyPK, MapAttrAttr.Name);
ddl.AutoPostBack = true;
ddl.SelectedIndexChanged += new EventHandler(ddl_SelectedIndexChanged);
ddl.SetSelectItem(cond.FK_Attr);
}
this.AddTR();
this.AddTD("属性/字段");
this.AddTD(ddl);
this.AddTD("");
this.AddTREnd();
MapAttr attrS = new MapAttr(this.DDL_Attr.SelectedItemStringVal);
this.AddTR();
this.AddTD("操作符");
ddl = new DDL();
ddl.ID = "DDL_Oper";
switch (attrS.LGType)
{
case BP.En.FieldTypeS.Enum:
case BP.En.FieldTypeS.FK:
ddl.Items.Add(new ListItem("=", "="));
ddl.Items.Add(new ListItem("<>", "<>"));
break;
case BP.En.FieldTypeS.Normal:
switch (attrS.MyDataType)
{
case BP.DA.DataType.AppString:
case BP.DA.DataType.AppDate:
case BP.DA.DataType.AppDateTime:
ddl.Items.Add(new ListItem("=", "="));
ddl.Items.Add(new ListItem("LIKE", "LIKE"));
ddl.Items.Add(new ListItem("<>", "<>"));
break;
case BP.DA.DataType.AppBoolean:
ddl.Items.Add(new ListItem("=", "="));
break;
default:
ddl.Items.Add(new ListItem("=", "="));
ddl.Items.Add(new ListItem(">", ">"));
ddl.Items.Add(new ListItem(">=", ">="));
ddl.Items.Add(new ListItem("<", "<"));
ddl.Items.Add(new ListItem("<=", "<="));
ddl.Items.Add(new ListItem("<>", "<>"));
break;
}
break;
default:
break;
}
if (cond != null)
{
try
{
ddl.SetSelectItem(cond.OperatorValueInt);
}
catch
{
}
}
this.AddTD(ddl);
this.AddTD("");
this.AddTREnd();
switch (attrS.LGType)
{
case BP.En.FieldTypeS.Enum:
this.AddTR();
this.AddTD("值");
ddl = new DDL();
ddl.ID = "DDL_Val";
ddl.BindSysEnum(attrS.UIBindKey);
if (cond != null)
{
try
{
ddl.SetSelectItem(cond.OperatorValueInt);
}
catch
{
}
}
this.AddTD(ddl);
this.AddTD("");
this.AddTREnd();
break;
case BP.En.FieldTypeS.FK:
this.AddTR();
this.AddTD("值");
ddl = new DDL();
ddl.ID = "DDL_Val";
ddl.BindEntities(attrS.HisEntitiesNoName);
if (cond != null)
{
try
{
ddl.SetSelectItem(cond.OperatorValueStr);
}
catch
{
}
}
this.AddTD(ddl);
this.AddTD("");
this.AddTREnd();
break;
default:
if (attrS.MyDataType == BP.DA.DataType.AppBoolean)
{
this.AddTR();
this.AddTD("值");
ddl = new DDL();
ddl.ID = "DDL_Val";
ddl.BindAppYesOrNo(0);
if (cond != null)
{
try
{
ddl.SetSelectItem(cond.OperatorValueInt);
}
catch
{
}
}
this.AddTD(ddl);
this.AddTD();
this.AddTREnd();
}
else
{
this.AddTR();
this.AddTD("值");
TB tb = new TB();
tb.ID = "TB_Val";
if (cond != null)
{
tb.Text = cond.OperatorValueStr;
}
this.AddTD(tb);
this.AddTD();
this.AddTREnd();
}
break;
}
Conds conds = new Conds();
QueryObject qo = new QueryObject(conds);
qo.AddWhere(CondAttr.NodeID, this.FK_MainNode);
qo.addAnd();
qo.AddWhere(CondAttr.DataFrom, (int)ConnDataFrom.Form);
qo.addAnd();
qo.AddWhere(CondAttr.CondType, (int)this.HisCondType);
if (this.ToNodeID != 0)
{
qo.addAnd();
qo.AddWhere(CondAttr.ToNodeID, this.ToNodeID);
}
int num = qo.DoQuery();
this.AddTRSum();
this.Add("<TD class=TD colspan=3 align=center>");
Button btn = new Button();
btn.ID = "Btn_Save";
btn.CssClass = "Btn";
btn.Text = " Save ";
btn.Click += new EventHandler(btn_Save_Click);
this.Add(btn);
btn = new Button();
btn.ID = "Btn_Del";
btn.CssClass = "Btn";
btn.Text = "Clear";
btn.Attributes["onclick"] = " return confirm('您确定要删除吗？');";
btn.Click += new EventHandler(btn_Save_Click);
this.Add(btn);
this.Add("</TD>");
this.AddTREnd();
this.AddTableEnd();
if (num == 0)
{
return;
}
#region 条件
this.AddTable("border=0 widht='500px'");
this.AddCaptionLeft("说明:同时满足如下条件转向成立,只能删除不能编辑.");
this.AddTR();
this.AddTDTitle("IDX");
this.AddTDTitle("节点");
this.AddTDTitle("字段的英文名");
this.AddTDTitle("字段的中文名");
this.AddTDTitle("操作符");
this.AddTDTitle("值");
this.AddTDTitle("标签");
this.AddTDTitle("操作");
this.AddTREnd();
int i = 0;
foreach (Cond mync in conds)
{
if (mync.HisDataFrom != ConnDataFrom.Form)
{
continue;
}
i++;
this.AddTR();
this.AddTDIdx(i);
// this.AddTD(mync.HisDataFrom.ToString());
this.AddTD(mync.FK_NodeT);
this.AddTD(mync.AttrKey);
this.AddTD(mync.AttrName);
this.AddTDCenter(mync.FK_Operator);
this.AddTD(mync.OperatorValueStr);
this.AddTD(mync.OperatorValueT);
//if (num > 1)
// this.AddTD(mync.HisConnJudgeWayT);
this.AddTD("<a href='Cond.aspx?MyPK=" + mync.MyPK + "&CondType=" + (int)this.HisCondType + "&FK_Flow=" + this.FK_Flow + "&FK_Attr=" + mync.FK_Attr + "&FK_MainNode=" + mync.NodeID + "&OperatorValue=" + mync.OperatorValueStr + "&FK_Node=" + mync.FK_Node + "&DoType=Del&ToNodeID=" + mync.ToNodeID + "' >删除</a>");
this.AddTREnd();
}
this.AddTableEnd();
#endregion
}
