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