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