HYTOS

<?xml version="1.0" encoding="utf-8"?>

<configuration>

</configuration>

  <ItemGroup>

    <None Include="App.config" />

  </ItemGroup>

using System.IO;

        private static ProjectInfo projectInfo;

        private string _Path;

        private string _Name;

        private bool _Enable;

        public string Path {

            get { return _Path; }

            set {

                _Path = value;

                _Name = System.IO.Path.GetFileName(value);

            }

        }

        public string Name

        {

            get { return _Name; }

        }

        public bool Enable { get => _Enable; set => _Enable = value; }

        public static ProjectInfo GetInstance()

        {

            if (projectInfo == null)

                projectInfo = new ProjectInfo();

            return projectInfo;

        }

<?xml version="1.0" encoding="utf-8"?>

            this.btnID2Project = new DevExpress.XtraEditors.ButtonEdit();

            this.simpleLabelItem1 = new DevExpress.XtraLayout.SimpleLabelItem();

            this.layoutControlItem7 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlGroupAutoConverter = new DevExpress.XtraLayout.LayoutControlGroup();

            this.layoutControlItem1 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem5 = new DevExpress.XtraLayout.LayoutControlItem();

            this.emptySpaceItem2 = new DevExpress.XtraLayout.EmptySpaceItem();

            this.layoutControlItem6 = new DevExpress.XtraLayout.LayoutControlItem();

            this.xtraFolderBrowserDialog = new DevExpress.XtraEditors.XtraFolderBrowserDialog();

            this.xtraOpenFileDialog = new DevExpress.XtraEditors.XtraOpenFileDialog();

            ((System.ComponentModel.ISupportInitialize)(this.btnID2Project.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.simpleLabelItem1)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem7)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupAutoConverter)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem5)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem2)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem6)).BeginInit();

            this.layoutControl1.Controls.Add(this.btnID2Project);

            this.btnRun.Location = new System.Drawing.Point(910, 58);

            this.btnItemMapping.Location = new System.Drawing.Point(1011, 310);

            this.btnItemMapping.Size = new System.Drawing.Size(231, 36);

            this.btnSPPIDDB.Location = new System.Drawing.Point(1011, 58);

            this.btnSPPIDDB.Size = new System.Drawing.Size(231, 36);

            this.btnSPPIDDB.Click += new System.EventHandler(this.btnSPPIDDB_Click);

            this.gridControlConverter.Size = new System.Drawing.Size(949, 349);

            // btnID2Project

            this.btnID2Project.Location = new System.Drawing.Point(1049, 192);

            this.btnID2Project.MenuManager = this.ribbonControl;

            this.btnID2Project.Name = "btnID2Project";

            this.btnID2Project.Properties.Buttons.AddRange(new DevExpress.XtraEditors.Controls.EditorButton[] {

            this.btnID2Project.Properties.ReadOnly = true;

            this.btnID2Project.Size = new System.Drawing.Size(193, 20);

            this.btnID2Project.StyleController = this.layoutControl1;

            this.btnID2Project.TabIndex = 10;

            this.btnID2Project.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.btnID2Project_ButtonClick);

            this.layoutControlGroupAutoConverter,

            this.simpleLabelItem2,

            this.simpleLabelItem1});

            this.layoutControlGroupSPPIDDB.Location = new System.Drawing.Point(987, 0);

            this.layoutControlGroupSPPIDDB.Size = new System.Drawing.Size(259, 134);

            this.labelSPPIDPlantName.AppearanceItemCaption.Options.UseForeColor = true;

            this.labelSPPIDPlantName.Size = new System.Drawing.Size(157, 18);

            this.labelSPPIDDBStatus.AppearanceItemCaption.Options.UseForeColor = true;

            this.labelSPPIDDBStatus.Size = new System.Drawing.Size(184, 18);

            this.layoutControlItem2.Size = new System.Drawing.Size(235, 40);

            this.simpleLabelItem2.AppearanceItemCaption.Options.UseForeColor = true;

            // simpleLabelItem1

            // 

            this.simpleLabelItem1.AllowHotTrack = false;

            this.simpleLabelItem1.AppearanceItemCaption.Options.UseForeColor = true;

            this.simpleLabelItem1.Location = new System.Drawing.Point(0, 40);

            this.simpleLabelItem1.MaxSize = new System.Drawing.Size(78, 18);

            this.simpleLabelItem1.MinSize = new System.Drawing.Size(78, 18);

            this.simpleLabelItem1.Name = "simpleLabelItem1";

            this.simpleLabelItem1.Size = new System.Drawing.Size(78, 18);

            this.simpleLabelItem1.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

            this.simpleLabelItem1.Text = "Plant Name : ";

            this.simpleLabelItem1.TextAlignMode = DevExpress.XtraLayout.TextAlignModeItem.AutoSize;

            this.simpleLabelItem1.TextSize = new System.Drawing.Size(74, 14);

            // 

            this.layoutControlItem7,

            this.layoutControlGroupID2Project.Location = new System.Drawing.Point(987, 134);

            this.layoutControlGroupID2Project.Size = new System.Drawing.Size(259, 118);

            this.labelID2ProjectName.AppearanceItemCaption.Options.UseForeColor = true;

            this.labelID2ProjectName.Size = new System.Drawing.Size(145, 18);

            this.labelID2ProjectStatus.AppearanceItemCaption.Options.UseForeColor = true;

            this.labelID2ProjectStatus.Size = new System.Drawing.Size(184, 18);

            // layoutControlItem7

            this.layoutControlItem7.Control = this.btnID2Project;

            this.layoutControlItem7.Location = new System.Drawing.Point(0, 0);

            this.layoutControlItem7.Name = "layoutControlItem7";

            this.layoutControlItem7.Size = new System.Drawing.Size(235, 24);

            this.layoutControlItem7.Text = "Path :";

            this.layoutControlItem7.TextAlignMode = DevExpress.XtraLayout.TextAlignModeItem.AutoSize;

            this.layoutControlItem7.TextSize = new System.Drawing.Size(33, 14);

            this.layoutControlItem7.TextToControlDistance = 5;

            this.simpleLabelItem3.AppearanceItemCaption.Options.UseForeColor = true;

            this.simpleLabelItem4.AppearanceItemCaption.Options.UseForeColor = true;

            this.layoutControlGroupItemMapping.Location = new System.Drawing.Point(987, 252);

            this.layoutControlGroupItemMapping.Size = new System.Drawing.Size(259, 116);

            this.layoutControlItem4.Size = new System.Drawing.Size(235, 40);

            this.labelItemMappingStatus.AppearanceItemCaption.Options.UseForeColor = true;

            this.labelItemMappingStatus.Size = new System.Drawing.Size(184, 18);

            this.simpleLabelItem5.AppearanceItemCaption.Options.UseForeColor = true;

            // layoutControlGroupAutoConverter

            // 

            this.layoutControlGroupAutoConverter.CaptionImageOptions.SvgImage = global::Converter.SPPID.AutoModeling.Properties.Resources.convertto;

            this.layoutControlGroupAutoConverter.GroupStyle = DevExpress.Utils.GroupStyle.Card;

            this.layoutControlGroupAutoConverter.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {

            this.layoutControlItem1,

            this.layoutControlItem5,

            this.emptySpaceItem2,

            this.layoutControlItem6});

            this.layoutControlGroupAutoConverter.Location = new System.Drawing.Point(0, 0);

            this.layoutControlGroupAutoConverter.Name = "layoutControlGroupAutoConverter";

            this.layoutControlGroupAutoConverter.Size = new System.Drawing.Size(977, 451);

            this.layoutControlGroupAutoConverter.Text = "Auto Converter";

            // 

            // layoutControlItem1

            // 

            this.layoutControlItem1.Control = this.gridControlConverter;

            this.layoutControlItem1.Location = new System.Drawing.Point(0, 40);

            this.layoutControlItem1.Name = "layoutControlItem1";

            this.layoutControlItem1.Size = new System.Drawing.Size(953, 353);

            this.layoutControlItem1.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem1.TextVisible = false;

            // 

            // layoutControlItem5

            // 

            this.layoutControlItem5.Control = this.btnLoadFile;

            this.layoutControlItem5.Location = new System.Drawing.Point(0, 0);

            this.layoutControlItem5.MaxSize = new System.Drawing.Size(98, 40);

            this.layoutControlItem5.MinSize = new System.Drawing.Size(98, 40);

            this.layoutControlItem5.Name = "layoutControlItem5";

            this.layoutControlItem5.Size = new System.Drawing.Size(98, 40);

            this.layoutControlItem5.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

            this.layoutControlItem5.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem5.TextVisible = false;

            // 

            // emptySpaceItem2

            // 

            this.emptySpaceItem2.AllowHotTrack = false;

            this.emptySpaceItem2.Location = new System.Drawing.Point(98, 0);

            this.emptySpaceItem2.Name = "emptySpaceItem2";

            this.emptySpaceItem2.Size = new System.Drawing.Size(788, 40);

            this.emptySpaceItem2.TextSize = new System.Drawing.Size(0, 0);

            // 

            // layoutControlItem6

            // 

            this.layoutControlItem6.Control = this.btnRun;

            this.layoutControlItem6.Location = new System.Drawing.Point(886, 0);

            this.layoutControlItem6.MaxSize = new System.Drawing.Size(67, 40);

            this.layoutControlItem6.MinSize = new System.Drawing.Size(67, 40);

            this.layoutControlItem6.Name = "layoutControlItem6";

            this.layoutControlItem6.Size = new System.Drawing.Size(67, 40);

            this.layoutControlItem6.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

            this.layoutControlItem6.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem6.TextVisible = false;

            // 

            this.emptySpaceItem1.Location = new System.Drawing.Point(987, 368);

            this.emptySpaceItem1.Size = new System.Drawing.Size(259, 83);

            this.splitterItem1.Location = new System.Drawing.Point(977, 0);

            // xtraFolderBrowserDialog

            // 

            this.xtraFolderBrowserDialog.DialogStyle = DevExpress.Utils.CommonDialogs.FolderBrowserDialogStyle.Wide;

            this.xtraFolderBrowserDialog.SelectedPath = "xtraFolderBrowserDialog1";

            // 

            // xtraOpenFileDialog

            // 

            this.xtraOpenFileDialog.FileName = "xtraOpenFileDialog1";

            this.xtraOpenFileDialog.Filter = "Xml Files(*.xml)|*.xml";

            this.xtraOpenFileDialog.Multiselect = true;

            // 

            ((System.ComponentModel.ISupportInitialize)(this.btnID2Project.Properties)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.simpleLabelItem1)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem7)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroupAutoConverter)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem5)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem2)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem6)).EndInit();

        private DevExpress.XtraEditors.ButtonEdit btnID2Project;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem7;

        private DevExpress.XtraEditors.XtraFolderBrowserDialog xtraFolderBrowserDialog;

        private DevExpress.XtraEditors.XtraOpenFileDialog xtraOpenFileDialog;

using Converter.BaseModel;

using System.Globalization;

using System.Threading;

using System.IO;

using Converter.SPPID.AutoModeling.Properties;

using Converter.SPPID.AutoModeling.DB;

using Converter.SPPID.AutoModeling.Util;

using Converter.SPPID.AutoModeling.Form;

        private DataTable converterDT = new DataTable();

        private RepositoryItemComboBox templateComboBox;

        ProjectInfo _ProjectInfo = ProjectInfo.GetInstance();

        SPPIDInfo _SPPIDInfo = SPPIDInfo.GetInstance();

            CultureInfo culture = CultureInfo.GetCultureInfo("en");

            Msg.Culture = culture;

            SPPIDUtil.ReadSPPIDInfo();

            SPPIDUtil.ReadID2ProjectInfo();

            SetID2ProjectUI();

            SetSPPIDDBUI();

        private void btnID2Project_ButtonClick(object sender, ButtonPressedEventArgs e)

        {

            if (xtraFolderBrowserDialog.ShowDialog() == DialogResult.OK)

            {

                bool result = false;

                string dirPath = xtraFolderBrowserDialog.SelectedPath;

                if (IsID2Project(dirPath))

                {

                    _ProjectInfo.Path = dirPath;

                    _ProjectInfo.Enable = true;

                    if (SPPIDUtil.SaveID2ProjectInfo())

                    {

                        result = true;

                        SetID2ProjectUI();

                        MessageBox.Show(Msg.SuccessProjectSelect, Msg.Information, MessageBoxButtons.OK, MessageBoxIcon.Information);

                    }

                }

                if (!result)

                {

                    _ProjectInfo.Enable = false;

                    SetID2ProjectUI();

                    MessageBox.Show(Msg.FailProjectSelect, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                }

            }

        }

        private void SetID2ProjectUI()

        {

            if (_ProjectInfo.Enable)

            {

                btnID2Project.Text = _ProjectInfo.Path;

                labelID2ProjectName.Text = _ProjectInfo.Name;

                labelID2ProjectName.AppearanceItemCaption.ForeColor = Color.Blue;

                labelID2ProjectStatus.Text = Msg.ConnectionSuccessful;

                labelID2ProjectStatus.AppearanceItemCaption.ForeColor = Color.Blue;

            }

            else

            {

                btnID2Project.Text = "";

                labelID2ProjectName.Text = " ";

                labelID2ProjectName.AppearanceItemCaption.ForeColor = Color.Red;

                labelID2ProjectStatus.Text = Msg.ConnectionFail;

                labelID2ProjectStatus.AppearanceItemCaption.ForeColor = Color.Red;

            }

        }

        private void SetSPPIDDBUI()

        {

            if (_SPPIDInfo.Enable)

            {

                labelSPPIDPlantName.Text = _SPPIDInfo.SelectedPlant;

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Blue;

                labelSPPIDDBStatus.Text = Msg.ConnectionSuccessful;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Blue;

            }

            else

            {

                labelSPPIDPlantName.Text = " ";

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Red;

                labelSPPIDDBStatus.Text = Msg.ConnectionFail;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Red;

            }

        }

        private bool IsID2Project(string path)

        {

            bool result = false;

            string[] directories = Directory.GetDirectories(path, "*", SearchOption.TopDirectoryOnly);

            for (int i = 0; i < directories.Length; i++)

                directories[i] = Path.GetFileName(directories[i]);

            List<string> dirList = directories.ToList();

            if (dirList.Contains("db") &&

                dirList.Contains("Temp") &&

                dirList.Contains("image"))

            {

                result = true;

            }

            return result;

        }

            if (!_ProjectInfo.Enable)

            {

                MessageBox.Show(Msg.PleaseSetID2ProjectInfo, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            xtraOpenFileDialog.InitialDirectory = _ProjectInfo.Path + @"\temp";

            if (xtraOpenFileDialog.ShowDialog() == DialogResult.OK)

                foreach (string fileName in xtraOpenFileDialog.FileNames)

        private void btnSPPIDDB_Click(object sender, EventArgs e)

        {

            SPPID_DB_SettingForm form = new SPPID_DB_SettingForm();

            if (form.ShowDialog() == DialogResult.OK)

                SetSPPIDDBUI();

        }

  <metadata name="xtraFolderBrowserDialog.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

    <value>179, 17</value>

  </metadata>

  <metadata name="xtraOpenFileDialog.TrayLocation" type="System.Drawing.Point, System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a">

    <value>367, 17</value>

  </metadata>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data;

using System.Globalization;

using System.IO;

using Oracle.ManagedDataAccess.Client;

namespace Converter.SPPID.AutoModeling.DB

{

    public class DB

    {

        private const string oConnString = "(DESCRIPTION = (ADDRESS = (PROTOCOL = TCP)(HOST ={0}" + @")(PORT = {1}))(CONNECT_DATA = (SERVICE_NAME = {2})))";

        public static bool CheckAndSetSPPIDInfo()

        {

            bool bResult = false;

            SPPIDInfo dbInfo = SPPIDInfo.GetInstance();

            try

            {

                if (dbInfo.DBType == "ORACLE")

                {

                    string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);

                    connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword;

                    using (OracleConnection conn = new OracleConnection(connString))

                    {

                        conn.Open();

                        if (conn.State == System.Data.ConnectionState.Open)

                        {

                            using (OracleCommand cmd = new OracleCommand())

                            {

                                cmd.Connection = conn;

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT NAME, PATH FROM {0}.T_ROOTITEM", dbInfo.Site);

                                using (OracleDataReader reader = cmd.ExecuteReader())

                                {

                                    while (reader.Read())

                                    {

                                        dbInfo.Plant = reader["NAME"].ToString();

                                        dbInfo.PlantPath = reader["PATH"].ToString();

                                    }

                                    cmd.CommandText = string.Format(CultureInfo.CurrentCulture, @"SELECT SP_SCHEMA_TYPE, USERNAME

                                                FROM {0}.T_DB_DATA DB_DATA 

                                                INNER JOIN {0}.T_ROOTITEM ROOTITEM ON DB_DATA.SP_ROOTITEMID = ROOTITEM.SP_ID 

                                                WHERE ROOTITEM.NAME = '{1}'", dbInfo.Site, dbInfo.Plant);

                                    using (OracleDataAdapter adapter = new OracleDataAdapter())

                                    {

                                        DataTable dt = new DataTable();

                                        adapter.SelectCommand = cmd;

                                        adapter.Fill(dt);

                                        foreach (DataRow row in dt.Rows)

                                        {

                                            string sType = row["SP_SCHEMA_TYPE"].ToString();

                                            switch (sType)

                                            {

                                                case "SPPIDDATA_DICTIONARY":

                                                    dbInfo.PlantPIDDic = row["USERNAME"].ToString();

                                                    break;

                                                case "DATA_DICTIONARY":

                                                    dbInfo.PlantDic = row["USERNAME"].ToString();

                                                    break;

                                                case "SPAPLANT":

                                                    dbInfo.Plant = row["USERNAME"].ToString();

                                                    break;

                                                case "SPPID":

                                                    dbInfo.PlantPID = row["USERNAME"].ToString();

                                                    break;

                                                default:

                                                    break;

                                            }

                                        }

                                        bResult = true;

                                    }

                                }

                            }

                        }

                    }

                }

                else

                {

                }

            }

            catch (Exception ex)

            {

            }

            return bResult;

        }

        public static bool SetPlantDBSetting()

        {

            bool bResult = false;

            SPPIDInfo dbInfo = SPPIDInfo.GetInstance();

            try

            {

                if (dbInfo.DBType == "ORACLE")

                {

                    string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);

                    connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword;

                    using (OracleConnection conn = new OracleConnection(connString))

                    {

                        conn.Open();

                        if (conn.State == System.Data.ConnectionState.Open)

                        {

                            using (OracleCommand cmd = new OracleCommand())

                            {

                                cmd.Connection = conn;

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, @"SELECT SP_SCHEMA_TYPE, USERNAME

                                                FROM {0}.T_DB_DATA DB_DATA 

                                                INNER JOIN {0}.T_ROOTITEM ROOTITEM ON DB_DATA.SP_ROOTITEMID = ROOTITEM.SP_ID 

                                                WHERE ROOTITEM.NAME = '{1}'", dbInfo.Site, dbInfo.SelectedPlant);

                                using (OracleDataAdapter adapter = new OracleDataAdapter())

                                {

                                    DataTable dt = new DataTable();

                                    adapter.SelectCommand = cmd;

                                    adapter.Fill(dt);

                                    foreach (DataRow row in dt.Rows)

                                    {

                                        string sType = row["SP_SCHEMA_TYPE"].ToString();

                                        switch (sType)

                                        {

                                            case "SPPIDDATA_DICTIONARY":

                                                dbInfo.PlantPIDDic = row["USERNAME"].ToString();

                                                break;

                                            case "DATA_DICTIONARY":

                                                dbInfo.PlantDic = row["USERNAME"].ToString();

                                                break;

                                            case "SPAPLANT":

                                                dbInfo.Plant = row["USERNAME"].ToString();

                                                break;

                                            case "SPPID":

                                                dbInfo.PlantPID = row["USERNAME"].ToString();

                                                break;

                                            default:

                                                break;

                                        }

                                        bResult = true;

                                    }

                                }

                            }

                        }

                    }

                }

                else

                {

                }

            }

            catch (Exception ex)

            {

            }

            return bResult;

        }

        public static List<string> GetPlantList()

        {

            SPPIDInfo dbInfo = SPPIDInfo.GetInstance();

            List<string> plantList = new List<string>();

            try

            {

                if (dbInfo.DBType == "ORACLE")

                {

                    string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);

                    connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword;

                    using (OracleConnection conn = new OracleConnection(connString))

                    {

                        conn.Open();

                        if (conn.State == System.Data.ConnectionState.Open)

                        {

                            using (OracleCommand cmd = new OracleCommand())

                            {

                                cmd.Connection = conn;

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT NAME, PATH FROM {0}.T_ROOTITEM", dbInfo.Site);

                                using (OracleDataReader reader = cmd.ExecuteReader())

                                {

                                    while (reader.Read())

                                    {

                                        plantList.Add(reader["NAME"].ToString());

                                    }

                                }

                            }

                        }

                    }

                }

                else

                {

                }

            }

            catch (Exception ex)

            {

            }

            return plantList;

        }

        public static DataTable GetUnitTree()

        {

            DataTable dt = new DataTable();

            try

            {

                SPPIDInfo dbInfo = SPPIDInfo.GetInstance();

                if (dbInfo.DBType == "ORACLE")

                {

                    string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);

                    connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword;

                    using (OracleConnection conn = new OracleConnection(connString))

                    {

                        conn.Open();

                        if (conn.State == System.Data.ConnectionState.Open)

                        {

                            string sQuery = string.Format(CultureInfo.CurrentCulture,

                                @"SELECT SP_ID, PARENTID, NAME

                                    FROM {0}.T_PLANTGROUP 

                                    START WITH PARENTID='-1'

                                    CONNECT BY PRIOR SP_ID=PARENTID", dbInfo.Plant);

                            using (OracleCommand cmd = new OracleCommand(sQuery, conn))

                            using (OracleDataAdapter adapter = new OracleDataAdapter())

                            {

                                adapter.SelectCommand = cmd;

                                adapter.Fill(dt);

                            }

                        }

                    }

                }

                else

                {

                }

            }

            catch (Exception ex)

            {

            }

            return dt;

        }

        public static string GetPlantPID_T_OPTIONSETTING_Value(string name)

        {

            string TemplatePath = string.Empty;

            SPPIDInfo dbInfo = SPPIDInfo.GetInstance();

            try

            {

                if (dbInfo.DBType == "ORACLE")

                {

                    string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);

                    connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword;

                    using (OracleConnection conn = new OracleConnection(connString))

                    {

                        conn.Open();

                        if (conn.State == System.Data.ConnectionState.Open)

                        {

                            using (OracleCommand cmd = new OracleCommand())

                            {

                                cmd.Connection = conn;

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT VALUE FROM {0}.T_OPTIONSETTING WHERE NAME = '{1}'", dbInfo.PlantPID, name);

                                using (OracleDataReader reader = cmd.ExecuteReader())

                                {

                                    while (reader.Read())

                                    {

                                        TemplatePath = reader["VALUE"].ToString();

                                        break;

                                    }

                                }

                            }

                        }

                    }

                }

                else

                {

                }

            }

            catch (Exception ex)

            {

            }

            return TemplatePath;

        }

        public static List<string> GetSPPIDAttribute()

        {

            List<string> attributes = new List<string>();

            SPPIDInfo dbInfo = SPPIDInfo.GetInstance();

            try

            {

                if (dbInfo.DBType == "ORACLE")

                {

                    string connString = string.Format(oConnString, dbInfo.ServerIP, dbInfo.Port, dbInfo.Service);

                    connString = "Data Source=" + connString + ";User Id=" + dbInfo.DBUser + ";Password=" + dbInfo.DBPassword;

                    using (OracleConnection conn = new OracleConnection(connString))

                    {

                        conn.Open();

                        if (conn.State == System.Data.ConnectionState.Open)

                        {

                            using (OracleCommand cmd = new OracleCommand())

                            {

                                cmd.Connection = conn;

                                // 정리 필요

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_EQUIPMENT");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_NOZZLE");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_PIPINGCOMP");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_PIPERUN");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_INSTRUMENT");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_INLINECOMP");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_VESSEL");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_EXCHANGER");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_MECHANICAL");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                                cmd.CommandText = string.Format(CultureInfo.CurrentCulture, "SELECT * FROM {0}.{1}", dbInfo.PlantPID, "T_EQUIPCOMPONENT");

                                using (OracleDataReader reader = cmd.ExecuteReader(CommandBehavior.SchemaOnly))

                                {

                                    DataTable dt = reader.GetSchemaTable();

                                    foreach (DataRow row in dt.Rows)

                                        attributes.Add(row["ColumnName"].ToString());

                                }

                            }

                        }

                    }

                }

                else

                {

                }

            }

            catch (Exception ex)

            {

            }

            return attributes.Distinct().ToList();

        }

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace Converter.SPPID.AutoModeling.DB

{

    public class SPPIDInfo

    {

        private static SPPIDInfo sPPIDInfo;

        private string _DBType = string.Empty;

        private string _Service = string.Empty;

        private string _Site = string.Empty;

        private string _ServerIP = string.Empty;

        private string _Port = string.Empty;

        private string _DBUser = string.Empty;

        private string _DBPassword = string.Empty;

        private List<string> _PlantList = new List<string>();

        private string _SelectedPlant = string.Empty;

        private string _PlantPath = string.Empty;

        private string _Plant = string.Empty;

        private string _PlantDic = string.Empty;

        private string _PlantPID = string.Empty;

        private string _PlantPIDDic = string.Empty;

        private bool _Enable = false;

        public string DBType { get => _DBType; set => _DBType = value; }

        public string Service { get => _Service; set => _Service = value; }

        public string Site { get => _Site; set => _Site = value; }

        public string ServerIP { get => _ServerIP; set => _ServerIP = value; }

        public string Port { get => _Port; set => _Port = value; }

        public string DBUser { get => _DBUser; set => _DBUser = value; }

        public string DBPassword { get => _DBPassword; set => _DBPassword = value; }

        public List<string> PlantList { get => _PlantList; set => _PlantList = value; }

        public string SelectedPlant { get => _SelectedPlant; set => _SelectedPlant = value; }

        public string PlantPath { get => _PlantPath; set => _PlantPath = value; }

        public string Plant { get => _Plant; set => _Plant = value; }

        public string PlantDic { get => _PlantDic; set => _PlantDic = value; }

        public string PlantPID { get => _PlantPID; set => _PlantPID = value; }

        public string PlantPIDDic { get => _PlantPIDDic; set => _PlantPIDDic = value; }

        public bool Enable { get => _Enable; set => _Enable = value; }

        public static SPPIDInfo GetInstance()

        {

            if (sPPIDInfo == null)

                sPPIDInfo = new SPPIDInfo();

            return sPPIDInfo;

        }

    }

}

namespace Converter.SPPID.AutoModeling.Form

{

    partial class SPPID_DB_SettingForm

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

            this.ribbonControl = new DevExpress.XtraBars.Ribbon.RibbonControl();

            this.layoutControl1 = new DevExpress.XtraLayout.LayoutControl();

            this.simpleButton2 = new DevExpress.XtraEditors.SimpleButton();

            this.btnSave = new DevExpress.XtraEditors.SimpleButton();

            this.comboPlant = new DevExpress.XtraEditors.ComboBoxEdit();

            this.textBoxDBPassword = new DevExpress.XtraEditors.TextEdit();

            this.textBoxDBUser = new DevExpress.XtraEditors.TextEdit();

            this.textBoxDBType = new DevExpress.XtraEditors.TextEdit();

            this.btnLoadINIFile = new DevExpress.XtraEditors.SimpleButton();

            this.textBoxServiceName = new DevExpress.XtraEditors.TextEdit();

            this.textBoxSiteName = new DevExpress.XtraEditors.TextEdit();

            this.textBoxServerIP = new DevExpress.XtraEditors.TextEdit();

            this.textBoxPort = new DevExpress.XtraEditors.TextEdit();

            this.btnGetPlantList = new DevExpress.XtraEditors.SimpleButton();

            this.Root = new DevExpress.XtraLayout.LayoutControlGroup();

            this.layoutControlGroup1 = new DevExpress.XtraLayout.LayoutControlGroup();

            this.layoutControlItem1 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem2 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem3 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem4 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlGroup2 = new DevExpress.XtraLayout.LayoutControlGroup();

            this.layoutControlItem5 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem6 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem7 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem8 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem9 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem12 = new DevExpress.XtraLayout.LayoutControlItem();

            this.emptySpaceItem2 = new DevExpress.XtraLayout.EmptySpaceItem();

            this.layoutControlItem10 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem11 = new DevExpress.XtraLayout.LayoutControlItem();

            this.xtraOpenFileDialog = new DevExpress.XtraEditors.XtraOpenFileDialog();

            ((System.ComponentModel.ISupportInitialize)(this.ribbonControl)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControl1)).BeginInit();

            this.layoutControl1.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.comboPlant.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.textBoxDBPassword.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.textBoxDBUser.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.textBoxDBType.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.textBoxServiceName.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.textBoxSiteName.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.textBoxServerIP.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.textBoxPort.Properties)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.Root)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup1)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem1)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem2)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem3)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem4)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup2)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem5)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem6)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem7)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem8)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem9)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem12)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.emptySpaceItem2)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem10)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlItem11)).BeginInit();

            this.SuspendLayout();

            // 

            // ribbonControl

            // 

            this.ribbonControl.ExpandCollapseItem.Id = 0;

            this.ribbonControl.Items.AddRange(new DevExpress.XtraBars.BarItem[] {

            this.ribbonControl.ExpandCollapseItem});

            this.ribbonControl.Location = new System.Drawing.Point(0, 0);

            this.ribbonControl.MaxItemId = 1;

            this.ribbonControl.Name = "ribbonControl";

            this.ribbonControl.ShowApplicationButton = DevExpress.Utils.DefaultBoolean.False;

            this.ribbonControl.ShowDisplayOptionsMenuButton = DevExpress.Utils.DefaultBoolean.False;

            this.ribbonControl.ShowPageHeadersMode = DevExpress.XtraBars.Ribbon.ShowPageHeadersMode.ShowOnMultiplePages;

            this.ribbonControl.ShowToolbarCustomizeItem = false;

            this.ribbonControl.Size = new System.Drawing.Size(417, 32);

            this.ribbonControl.Toolbar.ShowCustomizeItem = false;

            // 

            // layoutControl1

            // 

            this.layoutControl1.Controls.Add(this.simpleButton2);

            this.layoutControl1.Controls.Add(this.btnSave);

            this.layoutControl1.Controls.Add(this.comboPlant);

            this.layoutControl1.Controls.Add(this.textBoxDBPassword);

            this.layoutControl1.Controls.Add(this.textBoxDBUser);

            this.layoutControl1.Controls.Add(this.textBoxDBType);

            this.layoutControl1.Controls.Add(this.btnLoadINIFile);

            this.layoutControl1.Controls.Add(this.textBoxServiceName);

            this.layoutControl1.Controls.Add(this.textBoxSiteName);

            this.layoutControl1.Controls.Add(this.textBoxServerIP);

            this.layoutControl1.Controls.Add(this.textBoxPort);

            this.layoutControl1.Controls.Add(this.btnGetPlantList);

            this.layoutControl1.Dock = System.Windows.Forms.DockStyle.Fill;

            this.layoutControl1.Location = new System.Drawing.Point(0, 32);

            this.layoutControl1.Name = "layoutControl1";

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.Size = new System.Drawing.Size(417, 440);

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            // simpleButton2

            // 

            this.simpleButton2.ImageOptions.SvgImage = global::Converter.SPPID.AutoModeling.Properties.Resources.close;

            this.simpleButton2.Location = new System.Drawing.Point(202, 392);

            this.simpleButton2.Name = "simpleButton2";

            this.simpleButton2.Size = new System.Drawing.Size(203, 36);

            this.simpleButton2.StyleController = this.layoutControl1;

            this.simpleButton2.TabIndex = 14;

            this.simpleButton2.Text = "Cancel";

            //