/// <summary>
/// 初始化 导入的界面 .
/// </summary>
/// <returns></returns>
public string Imp_Init()
{
DataSet ds = new DataSet();
string sql = "";
System.Data.DataTable dt;
if (this.FK_Flow != null)
{
//加入节点表单. 如果没有流程参数.
Paras ps = new Paras();
ps.SQL = "SELECT NodeID, Name FROM WF_Node WHERE FK_Flow=" + SystemConfig.AppCenterDBVarStr + "FK_Flow ORDER BY NODEID ";
ps.Add("FK_Flow", this.FK_Flow);
dt = BP.DA.DBAccess.RunSQLReturnTable(ps);
dt.TableName = "WF_Node";
if (SystemConfig.AppCenterDBType == DBType.Oracle || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
dt.Columns["NODEID"].ColumnName = "NodeID";
dt.Columns["NAME"].ColumnName = "Name";
}
ds.Tables.Add(dt);
}
#region 加入表单库目录.
if (SystemConfig.AppCenterDBType == DBType.Oracle)
{
sql = "SELECT NO as No ,Name,ParentNo FROM Sys_FormTree ORDER BY PARENTNO, IDX ";
}
else
{
sql = "SELECT No,Name,ParentNo FROM Sys_FormTree ORDER BY PARENTNO, IDX ";
}
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_FormTree";
if (SystemConfig.AppCenterDBType == DBType.Oracle || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
dt.Columns["NO"].ColumnName = "No";
dt.Columns["NAME"].ColumnName = "Name";
dt.Columns["PARENTNO"].ColumnName = "ParentNo";
}
ds.Tables.Add(dt);
//加入表单
sql = "SELECT A.No, A.Name, A.FK_FormTree FROM Sys_MapData A, Sys_FormTree B WHERE A.FK_FormTree=B.No";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "Sys_MapData";
ds.Tables.Add(dt);
if (SystemConfig.AppCenterDBType == DBType.Oracle || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
dt.Columns["NO"].ColumnName = "No";
dt.Columns["NAME"].ColumnName = "Name";
dt.Columns["FK_FORMTREE"].ColumnName = "FK_FormTree";
}
#endregion 加入表单库目录.
#region 加入流程树目录.
sql = "SELECT No,Name,ParentNo FROM WF_FlowSort ORDER BY PARENTNO, IDX ";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "WF_FlowSort";
if (SystemConfig.AppCenterDBType == DBType.Oracle || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
dt.Columns["NO"].ColumnName = "No";
dt.Columns["NAME"].ColumnName = "Name";
dt.Columns["PARENTNO"].ColumnName = "ParentNo";
}
ds.Tables.Add(dt);
//加入表单
sql = "SELECT No, Name, FK_FlowSort FROM WF_Flow ";
dt = BP.DA.DBAccess.RunSQLReturnTable(sql);
dt.TableName = "WF_Flow";
ds.Tables.Add(dt);
if (SystemConfig.AppCenterDBType == DBType.Oracle || SystemConfig.AppCenterDBType == DBType.PostgreSQL)
{
dt.Columns["NO"].ColumnName = "No";
dt.Columns["NAME"].ColumnName = "Name";
dt.Columns["FK_FLOWSORT"].ColumnName = "FK_FlowSort";
}
#endregion 加入流程树目录.
#region 数据源
BP.Sys.SFDBSrcs ens = new BP.Sys.SFDBSrcs();
ens.RetrieveAll();
ds.Tables.Add(ens.ToDataTableField("SFDBSrcs"));
#endregion
//加入系统表.
return(BP.Tools.Json.ToJson(ds));
}
