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());
}
/// <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();
}
/// <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();
}
/// <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");
}
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();
}
