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