HYTOS

        <supportedRuntime version="v4.0" sku=".NETFramework,Version=v4.5.2"/>

    <TargetFrameworkVersion>v4.5.2</TargetFrameworkVersion>

    <Reference Include="DevExpress.Data.v18.2, Version=18.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" />

    <Reference Include="DevExpress.Docs.v18.2, Version=18.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a, processorArchitecture=MSIL" />

    <Reference Include="DevExpress.Pdf.v18.2.Core, Version=18.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a, processorArchitecture=MSIL" />

    <Reference Include="DevExpress.Printing.v18.2.Core, Version=18.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" />

    <Reference Include="DevExpress.Sparkline.v18.2.Core, Version=18.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" />

    <Reference Include="DevExpress.Utils.v18.2, Version=18.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a" />

    <Reference Include="DevExpress.XtraEditors.v18.2, Version=18.2.7.0, Culture=neutral, PublicKeyToken=b88d1754d700e49a, processorArchitecture=MSIL" />

    [global::System.CodeDom.Compiler.GeneratedCodeAttribute("System.Resources.Tools.StronglyTypedResourceBuilder", "15.0.0.0")]

        ///   이 강력한 형식의 리소스 클래스를 사용하여 모든 리소스 조회에 대해 현재 스레드의 CurrentUICulture 속성을

        ///   재정의합니다.

    <section name="oracle.manageddataaccess.client" type="OracleInternal.Common.ODPMSectionHandler, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342" />

    <sectionGroup name="applicationSettings" type="System.Configuration.ApplicationSettingsGroup, System">

      <section name="DevExpress.LookAndFeel.Design.AppSettings" type="System.Configuration.ClientSettingsSection" requirePermission="false" />

    </sectionGroup>

  </configSections>

  <applicationSettings>

    <DevExpress.LookAndFeel.Design.AppSettings>

      <setting name="DefaultAppSkin" serializeAs="String">

        <value>Skin/Office 2016 Colorful</value>

      </setting>

      <setting name="DefaultPalette" serializeAs="String">

        <value></value>

      </setting>

      <setting name="TouchUI" serializeAs="String">

        <value></value>

      </setting>

      <setting name="TouchScaleFactor" serializeAs="String">

        <value></value>

      </setting>

      <setting name="DirectX" serializeAs="String">

        <value></value>

      </setting>

      <setting name="RegisterUserSkins" serializeAs="String">

        <value></value>

      </setting>

      <setting name="FontBehavior" serializeAs="String">

        <value></value>

      </setting>

      <setting name="DefaultAppFont" serializeAs="String">

        <value></value>

      </setting>

      <setting name="DPIAwarenessMode" serializeAs="String">

        <value></value>

      </setting>

    </DevExpress.LookAndFeel.Design.AppSettings>

  </applicationSettings>

      <remove invariant="Oracle.ManagedDataAccess.Client" />

      <add name="ODP.NET, Managed Driver" invariant="Oracle.ManagedDataAccess.Client" description="Oracle Data Provider for .NET, Managed Driver" type="Oracle.ManagedDataAccess.Client.OracleClientFactory, Oracle.ManagedDataAccess, Version=4.122.18.3, Culture=neutral, PublicKeyToken=89b483f429c47342" />

        <publisherPolicy apply="no" />

        <assemblyIdentity name="Oracle.ManagedDataAccess" publicKeyToken="89b483f429c47342" culture="neutral" />

        <bindingRedirect oldVersion="4.122.0.0 - 4.65535.65535.65535" newVersion="4.122.18.3" />

        <dataSource alias="SampleDataSource" descriptor="(DESCRIPTION=(ADDRESS=(PROTOCOL=tcp)(HOST=localhost)(PORT=1521))(CONNECT_DATA=(SERVICE_NAME=ORCL))) " />

        public static bool SetPlantDBSetting()

        {

            bool bResult = false;

            DBInformation dbInfo = DBInformation.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.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 List<string> GetPlantList()

        {

            DBInformation dbInfo = DBInformation.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;

        }

                            string sQuery = string.Format(CultureInfo.CurrentCulture,

                                @"SELECT SP_ID, PARENTID, NAME

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

        private string _SelectedPlant = string.Empty;

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

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

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace SPPIDConverter_AutoModeling

{

    public class ItemMapData

    {

    }

}

            this.telerikMetroBlueTheme = new Telerik.WinControls.Themes.TelerikMetroBlueTheme();

            this.materialBlueGreyTheme = new Telerik.WinControls.Themes.MaterialBlueGreyTheme();

            this.pageView.SelectedPage = this.pageItemMapping;

            this.splitPanel1.ThemeName = "TelerikMetroBlue";

            this.splitPanel2.ThemeName = "TelerikMetroBlue";

namespace SPPIDConverter_AutoModeling

{

    partial class MainControl2

    {

        /// <summary> 

        /// 필수 디자이너 변수입니다.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary> 

        /// 사용 중인 모든 리소스를 정리합니다.

        /// </summary>

        /// <param name="disposing">관리되는 리소스를 삭제해야 하면 true이고, 그렇지 않으면 false입니다.</param>

        protected override void Dispose(bool disposing)

        {

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

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region 구성 요소 디자이너에서 생성한 코드

        /// <summary> 

        /// 디자이너 지원에 필요한 메서드입니다. 

        /// 이 메서드의 내용을 코드 편집기로 수정하지 마세요.

        /// </summary>

        private void InitializeComponent()

        {

            this.components = new System.ComponentModel.Container();

            this.tabControl = new DevExpress.XtraTab.XtraTabControl();

            this.pageConverter = new DevExpress.XtraTab.XtraTabPage();

            this.splitContainer1 = new System.Windows.Forms.SplitContainer();

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

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

            this.gridControlConverter = new DevExpress.XtraGrid.GridControl();

            this.gridViewConverter = new DevExpress.XtraGrid.Views.Grid.GridView();

            this.pageDBSetting = new DevExpress.XtraTab.XtraTabPage();

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

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

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

            this.labelControl8 = new DevExpress.XtraEditors.LabelControl();

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

            this.labelControl6 = new DevExpress.XtraEditors.LabelControl();

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

            this.labelControl7 = new DevExpress.XtraEditors.LabelControl();

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

            this.labelControl5 = new DevExpress.XtraEditors.LabelControl();

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

            this.labelControl4 = new DevExpress.XtraEditors.LabelControl();

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

            this.labelControl3 = new DevExpress.XtraEditors.LabelControl();

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

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

            this.labelControl2 = new DevExpress.XtraEditors.LabelControl();

            this.labelControl1 = new DevExpress.XtraEditors.LabelControl();

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

            this.pageItemMapping = new DevExpress.XtraTab.XtraTabPage();

            this.tableLayoutPanel1 = new System.Windows.Forms.TableLayoutPanel();

            this.panelControl4 = new DevExpress.XtraEditors.PanelControl();

            this.groupReducer = new DevExpress.XtraEditors.GroupControl();

            this.labelControl9 = new DevExpress.XtraEditors.LabelControl();

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

            this.radioGroupReducer = new DevExpress.XtraEditors.RadioGroup();

            this.label1 = new System.Windows.Forms.Label();

            this.panelControl3 = new DevExpress.XtraEditors.PanelControl();

            this.gridControlAttribute = new DevExpress.XtraGrid.GridControl();

            this.gridViewAttribute = new DevExpress.XtraGrid.Views.Grid.GridView();

            this.panelControl2 = new DevExpress.XtraEditors.PanelControl();

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

            this.panelControl1 = new DevExpress.XtraEditors.PanelControl();

            this.gridControlSymbol = new DevExpress.XtraGrid.GridControl();

            this.gridViewSymbol = new DevExpress.XtraGrid.Views.Grid.GridView();

            this.pageReport = new DevExpress.XtraTab.XtraTabPage();

            this.defaultLookAndFeel = new DevExpress.LookAndFeel.DefaultLookAndFeel(this.components);

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

            this.tabControl.SuspendLayout();

            this.pageConverter.SuspendLayout();

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

            this.splitContainer1.Panel1.SuspendLayout();

            this.splitContainer1.Panel2.SuspendLayout();

            this.splitContainer1.SuspendLayout();

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

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

            this.pageDBSetting.SuspendLayout();

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

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

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

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

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

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

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

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

            this.pageItemMapping.SuspendLayout();

            this.tableLayoutPanel1.SuspendLayout();

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

            this.panelControl4.SuspendLayout();

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

            this.groupReducer.SuspendLayout();

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

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

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

            this.panelControl3.SuspendLayout();

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

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

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

            this.panelControl2.SuspendLayout();

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

            this.panelControl1.SuspendLayout();

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

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

            this.SuspendLayout();

            // 

            // tabControl

            // 

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

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

            this.tabControl.Name = "tabControl";

            this.tabControl.SelectedTabPage = this.pageConverter;

            this.tabControl.Size = new System.Drawing.Size(735, 900);

            this.tabControl.TabIndex = 0;

            this.tabControl.TabPages.AddRange(new DevExpress.XtraTab.XtraTabPage[] {

            this.pageConverter,

            this.pageDBSetting,

            this.pageItemMapping,

            this.pageReport});

            this.tabControl.SelectedPageChanged += new DevExpress.XtraTab.TabPageChangedEventHandler(this.tabControl_SelectedPageChanged);

            // 

            // pageConverter

            // 

            this.pageConverter.Controls.Add(this.splitContainer1);

            this.pageConverter.ImageOptions.Image = global::SPPIDConverter_AutoModeling.Properties.Resources.Convert;

            this.pageConverter.Name = "pageConverter";

            this.pageConverter.Size = new System.Drawing.Size(733, 856);

            this.pageConverter.Text = "Converter";

            // 

            // splitContainer1

            // 

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

            this.splitContainer1.FixedPanel = System.Windows.Forms.FixedPanel.Panel1;

            this.splitContainer1.IsSplitterFixed = true;

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

            this.splitContainer1.Name = "splitContainer1";

            this.splitContainer1.Orientation = System.Windows.Forms.Orientation.Horizontal;

            // 

            // splitContainer1.Panel1

            // 

            this.splitContainer1.Panel1.Controls.Add(this.btnLoadFiles);

            this.splitContainer1.Panel1.Controls.Add(this.btnRun);

            // 

            // splitContainer1.Panel2

            // 

            this.splitContainer1.Panel2.Controls.Add(this.gridControlConverter);

            this.splitContainer1.Size = new System.Drawing.Size(733, 856);

            this.splitContainer1.SplitterDistance = 33;

            this.splitContainer1.SplitterWidth = 1;

            this.splitContainer1.TabIndex = 3;

            // 

            // btnLoadFiles

            // 

            this.btnLoadFiles.ImageOptions.Image = global::SPPIDConverter_AutoModeling.Properties.Resources.Open;

            this.btnLoadFiles.Location = new System.Drawing.Point(3, 3);

            this.btnLoadFiles.Name = "btnLoadFiles";

            this.btnLoadFiles.Size = new System.Drawing.Size(84, 26);

            this.btnLoadFiles.TabIndex = 0;

            this.btnLoadFiles.Text = "Load Files";

            this.btnLoadFiles.Click += new System.EventHandler(this.btnLoadFiles_Click);

            // 

            // btnRun

            // 

            this.btnRun.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Top | System.Windows.Forms.AnchorStyles.Right)));

            this.btnRun.ImageOptions.Image = global::SPPIDConverter_AutoModeling.Properties.Resources.Start;

            this.btnRun.Location = new System.Drawing.Point(677, 3);

            this.btnRun.Name = "btnRun";

            this.btnRun.Size = new System.Drawing.Size(53, 26);

            this.btnRun.TabIndex = 1;

            this.btnRun.Text = "Run";

            this.btnRun.Click += new System.EventHandler(this.btnRun_Click);

            // 

            // gridControlConverter

            // 

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

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

            this.gridControlConverter.MainView = this.gridViewConverter;

            this.gridControlConverter.Name = "gridControlConverter";

            this.gridControlConverter.Size = new System.Drawing.Size(733, 822);

            this.gridControlConverter.TabIndex = 0;

            this.gridControlConverter.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {

            this.gridViewConverter});

            // 

            // gridViewConverter

            // 

            this.gridViewConverter.GridControl = this.gridControlConverter;

            this.gridViewConverter.Name = "gridViewConverter";

            this.gridViewConverter.OptionsView.ShowGroupPanel = false;

            this.gridViewConverter.CellValueChanged += new DevExpress.XtraGrid.Views.Base.CellValueChangedEventHandler(this.gridViewConverter_CellValueChanged);

            // 

            // pageDBSetting

            // 

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

            this.pageDBSetting.Controls.Add(this.comboBoxPlantList);

            this.pageDBSetting.Controls.Add(this.btnDBTest);

            this.pageDBSetting.Controls.Add(this.labelControl8);

            this.pageDBSetting.Controls.Add(this.tbDBPassword);

            this.pageDBSetting.Controls.Add(this.labelControl6);

            this.pageDBSetting.Controls.Add(this.tbDBUser);

            this.pageDBSetting.Controls.Add(this.labelControl7);

            this.pageDBSetting.Controls.Add(this.tbPort);

            this.pageDBSetting.Controls.Add(this.labelControl5);

            this.pageDBSetting.Controls.Add(this.tbServerIP);

            this.pageDBSetting.Controls.Add(this.labelControl4);

            this.pageDBSetting.Controls.Add(this.tbSiteName);

            this.pageDBSetting.Controls.Add(this.labelControl3);

            this.pageDBSetting.Controls.Add(this.tbServiceName);

            this.pageDBSetting.Controls.Add(this.tbDBType);

            this.pageDBSetting.Controls.Add(this.labelControl2);

            this.pageDBSetting.Controls.Add(this.labelControl1);

            this.pageDBSetting.Controls.Add(this.btnLoadPlantiniFile);

            this.pageDBSetting.ImageOptions.Image = global::SPPIDConverter_AutoModeling.Properties.Resources.Setting;

            this.pageDBSetting.Name = "pageDBSetting";

            this.pageDBSetting.Size = new System.Drawing.Size(733, 856);

            this.pageDBSetting.Text = "DB Setting";

            // 

            // btnSave

            // 

            this.btnSave.Location = new System.Drawing.Point(287, 240);

            this.btnSave.Name = "btnSave";

            this.btnSave.Size = new System.Drawing.Size(71, 23);

            this.btnSave.TabIndex = 22;

            this.btnSave.Text = "Save";

            this.btnSave.Click += new System.EventHandler(this.btnSave_Click);

            // 

            // comboBoxPlantList

            // 

            this.comboBoxPlantList.Location = new System.Drawing.Point(101, 214);

            this.comboBoxPlantList.Name = "comboBoxPlantList";

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

            new DevExpress.XtraEditors.Controls.EditorButton(DevExpress.XtraEditors.Controls.ButtonPredefines.Combo)});

            this.comboBoxPlantList.Size = new System.Drawing.Size(257, 20);

            this.comboBoxPlantList.TabIndex = 21;

            // 

            // btnDBTest

            // 

            this.btnDBTest.Location = new System.Drawing.Point(287, 3);

            this.btnDBTest.Name = "btnDBTest";

            this.btnDBTest.Size = new System.Drawing.Size(71, 23);

            this.btnDBTest.TabIndex = 20;

            this.btnDBTest.Text = "DB Test";

            this.btnDBTest.Click += new System.EventHandler(this.btnDBTest_Click);

            // 

            // labelControl8

            // 

            this.labelControl8.Location = new System.Drawing.Point(12, 217);

            this.labelControl8.Name = "labelControl8";

            this.labelControl8.Size = new System.Drawing.Size(27, 14);

            this.labelControl8.TabIndex = 18;

            this.labelControl8.Text = "Plant";

            // 

            // tbDBPassword

            // 

            this.tbDBPassword.Location = new System.Drawing.Point(101, 188);

            this.tbDBPassword.Name = "tbDBPassword";

            this.tbDBPassword.Properties.PasswordChar = '*';

            this.tbDBPassword.Size = new System.Drawing.Size(257, 20);

            this.tbDBPassword.TabIndex = 16;

            // 

            // labelControl6

            // 

            this.labelControl6.Location = new System.Drawing.Point(12, 191);

            this.labelControl6.Name = "labelControl6";

            this.labelControl6.Size = new System.Drawing.Size(70, 14);

            this.labelControl6.TabIndex = 15;

            this.labelControl6.Text = "DB Password";

            // 

            // tbDBUser

            // 

            this.tbDBUser.Location = new System.Drawing.Point(101, 162);

            this.tbDBUser.Name = "tbDBUser";

            this.tbDBUser.Size = new System.Drawing.Size(257, 20);

            this.tbDBUser.TabIndex = 14;

            // 

            // labelControl7

            // 

            this.labelControl7.Location = new System.Drawing.Point(12, 165);

            this.labelControl7.Name = "labelControl7";

            this.labelControl7.Size = new System.Drawing.Size(43, 14);

            this.labelControl7.TabIndex = 13;

            this.labelControl7.Text = "DB User";

            // 

            // tbPort

            // 

            this.tbPort.Location = new System.Drawing.Point(101, 136);

            this.tbPort.Name = "tbPort";

            this.tbPort.Size = new System.Drawing.Size(257, 20);

            this.tbPort.TabIndex = 12;

            // 

            // labelControl5

            // 

            this.labelControl5.Location = new System.Drawing.Point(12, 139);

            this.labelControl5.Name = "labelControl5";

            this.labelControl5.Size = new System.Drawing.Size(23, 14);

            this.labelControl5.TabIndex = 11;

            this.labelControl5.Text = "Port";

            // 

            // tbServerIP

            // 

            this.tbServerIP.Location = new System.Drawing.Point(101, 110);

            this.tbServerIP.Name = "tbServerIP";

            this.tbServerIP.Size = new System.Drawing.Size(257, 20);

            this.tbServerIP.TabIndex = 10;

            // 

            // labelControl4

            // 

            this.labelControl4.Location = new System.Drawing.Point(12, 113);

            this.labelControl4.Name = "labelControl4";

            this.labelControl4.Size = new System.Drawing.Size(50, 14);

            this.labelControl4.TabIndex = 9;

            this.labelControl4.Text = "Server IP";

            // 

            // tbSiteName

            // 

            this.tbSiteName.Enabled = false;

            this.tbSiteName.Location = new System.Drawing.Point(101, 84);

            this.tbSiteName.Name = "tbSiteName";

            this.tbSiteName.Size = new System.Drawing.Size(257, 20);

            this.tbSiteName.TabIndex = 8;

            // 

            // labelControl3

            // 

            this.labelControl3.Location = new System.Drawing.Point(12, 87);

            this.labelControl3.Name = "labelControl3";

            this.labelControl3.Size = new System.Drawing.Size(56, 14);

            this.labelControl3.TabIndex = 7;

            this.labelControl3.Text = "Site Name";

            // 

            // tbServiceName

            // 

            this.tbServiceName.Enabled = false;

            this.tbServiceName.Location = new System.Drawing.Point(101, 58);

            this.tbServiceName.Name = "tbServiceName";

            this.tbServiceName.Size = new System.Drawing.Size(257, 20);

            this.tbServiceName.TabIndex = 6;

            // 

            // tbDBType

            // 

            this.tbDBType.Enabled = false;

            this.tbDBType.Location = new System.Drawing.Point(101, 32);

            this.tbDBType.Name = "tbDBType";

            this.tbDBType.Size = new System.Drawing.Size(257, 20);

            this.tbDBType.TabIndex = 5;

            // 

            // labelControl2

            // 

            this.labelControl2.Location = new System.Drawing.Point(12, 61);

            this.labelControl2.Name = "labelControl2";

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

            this.labelControl2.TabIndex = 4;

            this.labelControl2.Text = "Service Name";

            // 

            // labelControl1

            // 

            this.labelControl1.Location = new System.Drawing.Point(13, 35);

            this.labelControl1.Name = "labelControl1";

            this.labelControl1.Size = new System.Drawing.Size(47, 14);

            this.labelControl1.TabIndex = 3;

            this.labelControl1.Text = "DB Type";

            // 

            // btnLoadPlantiniFile

            // 

            this.btnLoadPlantiniFile.Location = new System.Drawing.Point(12, 3);

            this.btnLoadPlantiniFile.Name = "btnLoadPlantiniFile";

            this.btnLoadPlantiniFile.Size = new System.Drawing.Size(113, 23);

            this.btnLoadPlantiniFile.TabIndex = 2;

            this.btnLoadPlantiniFile.Text = "Load Plant ini FIle";

            this.btnLoadPlantiniFile.Click += new System.EventHandler(this.LoadPlantiniFile_Click);

            // 

            // pageItemMapping

            // 

            this.pageItemMapping.Controls.Add(this.tableLayoutPanel1);

            this.pageItemMapping.ImageOptions.Image = global::SPPIDConverter_AutoModeling.Properties.Resources.ItemMapping;

            this.pageItemMapping.Name = "pageItemMapping";

            this.pageItemMapping.Size = new System.Drawing.Size(733, 856);

            this.pageItemMapping.Text = "Item Mapping";

            // 

            // tableLayoutPanel1

            // 

            this.tableLayoutPanel1.ColumnCount = 1;

            this.tableLayoutPanel1.ColumnStyles.Add(new System.Windows.Forms.ColumnStyle(System.Windows.Forms.SizeType.Percent, 50.75034F));

            this.tableLayoutPanel1.Controls.Add(this.panelControl4, 0, 3);

            this.tableLayoutPanel1.Controls.Add(this.panelControl3, 0, 2);

            this.tableLayoutPanel1.Controls.Add(this.panelControl2, 0, 0);

            this.tableLayoutPanel1.Controls.Add(this.panelControl1, 0, 1);

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

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

            this.tableLayoutPanel1.Name = "tableLayoutPanel1";

            this.tableLayoutPanel1.RowCount = 4;

            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 9.48718F));

            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Percent, 90.51282F));

            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 215F));

            this.tableLayoutPanel1.RowStyles.Add(new System.Windows.Forms.RowStyle(System.Windows.Forms.SizeType.Absolute, 250F));

            this.tableLayoutPanel1.Size = new System.Drawing.Size(733, 856);

            this.tableLayoutPanel1.TabIndex = 0;

            // 

            // panelControl4

            // 

            this.panelControl4.Controls.Add(this.groupReducer);

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

            this.panelControl4.Location = new System.Drawing.Point(3, 608);

            this.panelControl4.Name = "panelControl4";

            this.panelControl4.Size = new System.Drawing.Size(727, 245);

            this.panelControl4.TabIndex = 3;

            // 

            // groupReducer

            // 

            this.groupReducer.Controls.Add(this.labelControl9);

            this.groupReducer.Controls.Add(this.radioGroupReducer);

            this.groupReducer.Controls.Add(this.textBoxFittingSymbolPath);

            this.groupReducer.Controls.Add(this.label1);

            this.groupReducer.Location = new System.Drawing.Point(5, 5);

            this.groupReducer.Name = "groupReducer";

            this.groupReducer.Size = new System.Drawing.Size(343, 78);

            this.groupReducer.TabIndex = 0;

            this.groupReducer.Text = "Reducer Setting";

            // 

            // labelControl9

            // 

            this.labelControl9.Location = new System.Drawing.Point(5, 24);

            this.labelControl9.Name = "labelControl9";

            this.labelControl9.Size = new System.Drawing.Size(99, 14);

            this.labelControl9.TabIndex = 3;

            this.labelControl9.Text = "Size Symbol Name";

            // 

            // textBoxFittingSymbolPath

            // 

            this.textBoxFittingSymbolPath.Location = new System.Drawing.Point(110, 21);

            this.textBoxFittingSymbolPath.Name = "textBoxFittingSymbolPath";

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

            new DevExpress.XtraEditors.Controls.EditorButton()});

            this.textBoxFittingSymbolPath.Size = new System.Drawing.Size(224, 20);

            this.textBoxFittingSymbolPath.TabIndex = 2;

            this.textBoxFittingSymbolPath.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.textBoxSymbolPath_ButtonClick);

            // 

            // radioGroupReducer

            // 

            this.radioGroupReducer.EditValue = true;

            this.radioGroupReducer.Location = new System.Drawing.Point(110, 47);

            this.radioGroupReducer.Name = "radioGroupReducer";

            this.radioGroupReducer.Properties.Items.AddRange(new DevExpress.XtraEditors.Controls.RadioGroupItem[] {

            new DevExpress.XtraEditors.Controls.RadioGroupItem(true, "End 1 Nom Dia", true, "PipingPoint1.NominalDiameter"),

            new DevExpress.XtraEditors.Controls.RadioGroupItem(true, "End 2 Nom Dia", true, "PipingPoint2.NominalDiameter")});

            this.radioGroupReducer.Size = new System.Drawing.Size(224, 23);

            this.radioGroupReducer.TabIndex = 1;

            // 

            // label1

            // 

            this.label1.AutoSize = true;

            this.label1.Location = new System.Drawing.Point(2, 51);

            this.label1.Name = "label1";

            this.label1.Size = new System.Drawing.Size(92, 14);

            this.label1.TabIndex = 0;

            this.label1.Text = "Large Size Attr.";

            // 

            // panelControl3

            // 

            this.panelControl3.Controls.Add(this.gridControlAttribute);

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

            this.panelControl3.Location = new System.Drawing.Point(3, 393);

            this.panelControl3.Name = "panelControl3";

            this.panelControl3.Size = new System.Drawing.Size(727, 209);

            this.panelControl3.TabIndex = 2;

            // 

            // gridControlAttribute

            // 

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

            this.gridControlAttribute.Location = new System.Drawing.Point(2, 2);

            this.gridControlAttribute.MainView = this.gridViewAttribute;

            this.gridControlAttribute.Name = "gridControlAttribute";

            this.gridControlAttribute.Size = new System.Drawing.Size(723, 205);

            this.gridControlAttribute.TabIndex = 1;

            this.gridControlAttribute.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {

            this.gridViewAttribute});

            // 

            // gridViewAttribute

            // 

            this.gridViewAttribute.GridControl = this.gridControlAttribute;

            this.gridViewAttribute.Name = "gridViewAttribute";

            this.gridViewAttribute.OptionsView.ShowGroupPanel = false;

            // 

            // panelControl2

            // 

            this.panelControl2.Controls.Add(this.btnMappingSave);

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

            this.panelControl2.Location = new System.Drawing.Point(3, 3);

            this.panelControl2.Name = "panelControl2";

            this.panelControl2.Size = new System.Drawing.Size(727, 31);

            this.panelControl2.TabIndex = 1;

            // 

            // btnMappingSave

            // 

            this.btnMappingSave.Location = new System.Drawing.Point(650, 5);

            this.btnMappingSave.Name = "btnMappingSave";

            this.btnMappingSave.Size = new System.Drawing.Size(75, 23);

            this.btnMappingSave.TabIndex = 0;

            this.btnMappingSave.Text = "Save";

            this.btnMappingSave.Click += new System.EventHandler(this.btnMappingSave_Click);

            // 

            // panelControl1

            // 

            this.panelControl1.Controls.Add(this.gridControlSymbol);

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

            this.panelControl1.Location = new System.Drawing.Point(3, 40);

            this.panelControl1.Name = "panelControl1";

            this.panelControl1.Size = new System.Drawing.Size(727, 347);

            this.panelControl1.TabIndex = 0;

            // 

            // gridControlSymbol

            // 

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

            this.gridControlSymbol.Location = new System.Drawing.Point(2, 2);

            this.gridControlSymbol.MainView = this.gridViewSymbol;

            this.gridControlSymbol.Name = "gridControlSymbol";

            this.gridControlSymbol.Size = new System.Drawing.Size(723, 343);

            this.gridControlSymbol.TabIndex = 0;

            this.gridControlSymbol.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {

            this.gridViewSymbol});

            // 

            // gridViewSymbol

            // 

            this.gridViewSymbol.GridControl = this.gridControlSymbol;

            this.gridViewSymbol.Name = "gridViewSymbol";

            this.gridViewSymbol.OptionsView.ShowGroupPanel = false;

            // 

            // pageReport

            // 

            this.pageReport.ImageOptions.Image = global::SPPIDConverter_AutoModeling.Properties.Resources.Report;

            this.pageReport.Name = "pageReport";

            this.pageReport.Size = new System.Drawing.Size(733, 856);

            this.pageReport.Text = "Report";

            // 

            // defaultLookAndFeel

            // 

            this.defaultLookAndFeel.EnableBonusSkins = true;

            this.defaultLookAndFeel.LookAndFeel.SkinName = "Office 2016 Colorful";

            // 

            // MainControl2

            // 

            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 12F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

            this.Controls.Add(this.tabControl);

            this.Name = "MainControl2";

            this.Size = new System.Drawing.Size(735, 900);

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

            this.tabControl.ResumeLayout(false);

            this.pageConverter.ResumeLayout(false);

            this.splitContainer1.Panel1.ResumeLayout(false);

            this.splitContainer1.Panel2.ResumeLayout(false);

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

            this.splitContainer1.ResumeLayout(false);

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

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

            this.pageDBSetting.ResumeLayout(false);

            this.pageDBSetting.PerformLayout();

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

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

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

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

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

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

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

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

            this.pageItemMapping.ResumeLayout(false);

            this.tableLayoutPanel1.ResumeLayout(false);

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

            this.panelControl4.ResumeLayout(false);

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

            this.groupReducer.ResumeLayout(false);

            this.groupReducer.PerformLayout();

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

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

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

            this.panelControl3.ResumeLayout(false);

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

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

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

            this.panelControl2.ResumeLayout(false);

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

            this.panelControl1.ResumeLayout(false);

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

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

            this.ResumeLayout(false);

        }

        #endregion

        private DevExpress.XtraTab.XtraTabControl tabControl;

        private DevExpress.XtraTab.XtraTabPage pageConverter;

        private DevExpress.XtraTab.XtraTabPage pageDBSetting;

        private DevExpress.XtraTab.XtraTabPage pageItemMapping;

        private DevExpress.XtraTab.XtraTabPage pageReport;

        private DevExpress.LookAndFeel.DefaultLookAndFeel defaultLookAndFeel;

        private DevExpress.XtraEditors.SimpleButton btnLoadFiles;

        private DevExpress.XtraEditors.SimpleButton btnRun;

        private System.Windows.Forms.SplitContainer splitContainer1;

        private DevExpress.XtraGrid.GridControl gridControlConverter;

        private DevExpress.XtraGrid.Views.Grid.GridView gridViewConverter;

        private DevExpress.XtraEditors.SimpleButton btnLoadPlantiniFile;

        private DevExpress.XtraEditors.LabelControl labelControl8;

        private DevExpress.XtraEditors.TextEdit tbDBPassword;

        private DevExpress.XtraEditors.LabelControl labelControl6;

        private DevExpress.XtraEditors.TextEdit tbDBUser;

        private DevExpress.XtraEditors.LabelControl labelControl7;

        private DevExpress.XtraEditors.TextEdit tbPort;

        private DevExpress.XtraEditors.LabelControl labelControl5;

        private DevExpress.XtraEditors.TextEdit tbServerIP;

        private DevExpress.XtraEditors.LabelControl labelControl4;

        private DevExpress.XtraEditors.TextEdit tbSiteName;

        private DevExpress.XtraEditors.LabelControl labelControl3;

        private DevExpress.XtraEditors.TextEdit tbServiceName;

        private DevExpress.XtraEditors.TextEdit tbDBType;

        private DevExpress.XtraEditors.LabelControl labelControl2;

        private DevExpress.XtraEditors.LabelControl labelControl1;

        private DevExpress.XtraEditors.SimpleButton btnDBTest;

        private DevExpress.XtraEditors.ComboBoxEdit comboBoxPlantList;

        private DevExpress.XtraEditors.SimpleButton btnSave;

        private System.Windows.Forms.TableLayoutPanel tableLayoutPanel1;

        private DevExpress.XtraEditors.PanelControl panelControl4;

        private DevExpress.XtraEditors.PanelControl panelControl3;

        private DevExpress.XtraEditors.PanelControl panelControl2;

        private DevExpress.XtraEditors.PanelControl panelControl1;

        private DevExpress.XtraEditors.SimpleButton btnMappingSave;

        private DevExpress.XtraGrid.GridControl gridControlAttribute;

        private DevExpress.XtraGrid.Views.Grid.GridView gridViewAttribute;

        private DevExpress.XtraGrid.GridControl gridControlSymbol;

        private DevExpress.XtraGrid.Views.Grid.GridView gridViewSymbol;

        private DevExpress.XtraEditors.GroupControl groupReducer;

        private DevExpress.XtraEditors.RadioGroup radioGroupReducer;

        private System.Windows.Forms.Label label1;

        private DevExpress.XtraEditors.LabelControl labelControl9;

        private DevExpress.XtraEditors.ButtonEdit textBoxFittingSymbolPath;

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Data;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using Microsoft.Win32;

using System.IO;

using System.Threading;

using SPPID.Modeling;

using SPPID.Model;

using SPPID.Utill;

using SPPID.DB;

using Microsoft.VisualBasic;

using Newtonsoft.Json;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors;

namespace SPPIDConverter_AutoModeling

{

    public partial class MainControl2 : UserControl

    {

        const string _Ready = "Ready";

        const string _LoadFail = "Can't Load";

        const string _NeedMapping = "Need Mapping";

        const string _NeedUnit = "Select Unit";

        const string _NeedTemplate = "Select Template";

        const string _Error = "Error";

        const string _EndProcess = "End Process";

        const string _Processing = "Processing";

        Thread autoModelingThread;

        Dictionary<string, Document> dicDocument = new Dictionary<string, Document>();

        private Dictionary<string, string> symbolMapping = new Dictionary<string, string>();

        private Dictionary<string, string> attributeMapping = new Dictionary<string, string>();

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

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

        private DataTable dUnit = new DataTable();

        private string TemplatePath;

        private string SymbolPath;

        DataTable converterDT = new DataTable();

        DataTable symbolDT = new DataTable();

        DataTable attributeDT = new DataTable();

        DataTable symbolPathDT = new DataTable();

        RepositoryItemComboBox templateComboBox;

        RepositoryItemComboBox attributeComboBox;

        public MainControl2()

        {

            InitializeComponent();

            if (InitPath())

            {

                InitDBSettingPage();

                if (SPPIDUtill.LoadDB())

                {

                    InitGridControl();

                    InitDBInformation();

                }

                else

                    MessageBox.Show("Please Check DB Setting", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);

            }

            else

            {

            }

        }

        private void InitGridControl()

        {

            #region Converter Page

            gridViewConverter.OptionsSelection.MultiSelect = true;

            gridViewConverter.OptionsSelection.MultiSelectMode = DevExpress.XtraGrid.Views.Grid.GridMultiSelectMode.CheckBoxRowSelect;

            DataColumn col = converterDT.Columns.Add("colDrawingFileName");

            col.Caption = "Drawing File Name";

            col = converterDT.Columns.Add("colUnit");

            col.Caption = "Unit";

            col = converterDT.Columns.Add("colTemplate");

            col.Caption = "Template";

            col = converterDT.Columns.Add("colDrawingNumber");

            col.Caption = "Drawing Number";

            col = converterDT.Columns.Add("colDrawingName");

            col.Caption = "Drawing Name";

            col = converterDT.Columns.Add("colStatus");

            col.Caption = "Status";

            col = converterDT.Columns.Add("colUID");

            gridControlConverter.DataSource = converterDT;

            templateComboBox = new RepositoryItemComboBox();

            templateComboBox.TextEditStyle = TextEditStyles.DisableTextEditor;

            gridControlConverter.RepositoryItems.Add(templateComboBox);

            gridViewConverter.Columns["colTemplate"].ColumnEdit = templateComboBox;

            RepositoryItemButtonEdit unitButton = new RepositoryItemButtonEdit();

            unitButton.ButtonClick += UnitButton_ButtonClick;

            unitButton.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            gridControlConverter.RepositoryItems.Add(unitButton);

            gridViewConverter.Columns["colUnit"].ColumnEdit = unitButton;

            gridViewConverter.Columns["colDrawingFileName"].OptionsColumn.AllowEdit = false;

            gridViewConverter.Columns["colUnit"].OptionsColumn.ReadOnly = true;

            gridViewConverter.Columns["colStatus"].OptionsColumn.AllowEdit = false;

            gridViewConverter.Columns["colUID"].Visible = false;

            gridViewConverter.BestFitColumns();

            #endregion

            #region Mapping Page

            col = symbolDT.Columns.Add("colItemName");

            col.Caption = "Item Name";

            col = symbolDT.Columns.Add("colSPPIDName");

            col.Caption = "SPPID Name";

            gridControlSymbol.DataSource = symbolDT;

            RepositoryItemButtonEdit symbolButton = new RepositoryItemButtonEdit();

            symbolButton.ButtonClick += SymbolButton_ButtonClick;

            symbolButton.TextEditStyle = TextEditStyles.DisableTextEditor;

            gridControlSymbol.RepositoryItems.Add(symbolButton);

            gridViewSymbol.Columns["colSPPIDName"].ColumnEdit = symbolButton;

            gridViewSymbol.Columns["colItemName"].OptionsColumn.AllowEdit = false;

            col = attributeDT.Columns.Add("colAttribute");

            col.Caption = "Attribute Name";

            col = attributeDT.Columns.Add("colSPPIDAttribute");

            col.Caption = "SPPID Attribute Name";

            gridControlAttribute.DataSource = attributeDT;

            attributeComboBox = new RepositoryItemComboBox();

            attributeComboBox.TextEditStyle = TextEditStyles.DisableTextEditor;

            gridControlAttribute.RepositoryItems.Add(attributeComboBox);

            gridViewAttribute.Columns["colSPPIDAttribute"].ColumnEdit = attributeComboBox;

            gridViewAttribute.Columns["colAttribute"].OptionsColumn.AllowEdit = false;

            #endregion

        }

        private bool InitPath()

        {

            try

            {

                RegistryKey key = Registry.LocalMachine;

                RegistryKey software = key.OpenSubKey("SOFTWARE");

                RegistryKey DOFTECH = software.OpenSubKey("DOFTECH");

                if (DOFTECH != null)

                {

                    RegistryKey ID2 = DOFTECH.OpenSubKey("ID2");

                    if (ID2 != null)

                    {

                        SPPIDUtill.defaultPath = ID2.GetValue("Path").ToString();

                        Log.logPath = SPPIDUtill.defaultPath + @"Converter\SPPID Converter.log";

                        SPPIDUtill.mappingFilePath = SPPIDUtill.defaultPath + @"Converter\mapping.xml";

                        SPPIDUtill.dbFilePath = SPPIDUtill.defaultPath + @"Converter\DB.config";

                        return true;

                    }

                }

            }

            catch (Exception ex)

            {

            }

            return false;

        }

        public void InitDBInformation()

        {

            try

            {

                DBInformation dbInfo = DBInformation.GetInstance();

                if (dbInfo.Status)

                {

                    tbDBType.Text = dbInfo.DBType;

                    tbServiceName.Text = dbInfo.Service;

                    tbSiteName.Text = dbInfo.Site;

                    tbServerIP.Text = dbInfo.ServerIP;

                    tbPort.Text = dbInfo.Port;

                    tbDBUser.Text = dbInfo.DBUser;

                    tbDBPassword.Text = dbInfo.DBPassword;

                    comboBoxPlantList.Properties.Items.AddRange(dbInfo.PlantList);

                    comboBoxPlantList.SelectedIndex = dbInfo.PlantList.FindIndex(x => x == dbInfo.Plant);

                }

                // Unit DataTable

                dUnit = DB.GetUnitTree();

                // Template List

                TemplatePath = DB.GetPlantPID_T_OPTIONSETTING_Value("PID Template Path");

                if (!string.IsNullOrEmpty(TemplatePath))

                {

                    templateComboBox.Items.Clear();

                    templateComboBox.Items.AddRange(Directory.GetFiles(TemplatePath, "*.pid").ToList().Select(filePath => Path.GetFileName(filePath)).ToList());

                }

                // Symbol Path

                SymbolPath = DB.GetPlantPID_T_OPTIONSETTING_Value("Catalog Explorer root path");

                SetPathDataTable();

                // Load Mapping

                SPPIDUtill.LoadMapping(symbolMapping, attributeMapping);

                foreach (var item in symbolMapping)

                    symbolDT.Rows.Add(item.Key, item.Value);

                gridViewSymbol.BestFitColumns();

                // Attribute

                attributeComboBox.Items.Clear();

                attributeComboBox.Items.AddRange(DB.GetSPPIDAttribute());

                // Load Attribute

                foreach (var item in attributeMapping)

                    attributeDT.Rows.Add(new object[] { item.Key, item.Value });

            }

            catch (Exception ex)

            {

            }

        }

        private void SetPathDataTable()

        {

            symbolPathDT = new DataTable();

            symbolPathDT.Columns.Add("ID");

            symbolPathDT.Columns.Add("Parent");

            symbolPathDT.Columns.Add("Name");

            symbolPathDT.Columns.Add("FullPath");

            DirectoryInfo info = new DirectoryInfo(SymbolPath);

            symbolPathDT.Rows.Add(new object[] { "0", "-1", info.Name });

            loop(info, "0");

        }

        private void loop(DirectoryInfo parentInfo, string parentUID)

        {

            DirectoryInfo[] infos = parentInfo.GetDirectories();

            foreach (DirectoryInfo info in infos)

            {

                string uid = Guid.NewGuid().ToString();

                symbolPathDT.Rows.Add(new object[] { uid, parentUID, info.Name });

                loop(info, uid);

                FileInfo[] files = info.GetFiles("*.sym");

                foreach (FileInfo fileInfo in files)

                {

                    symbolPathDT.Rows.Add(new object[] { Guid.NewGuid().ToString(), uid, fileInfo.Name, fileInfo.FullName.Replace(SymbolPath, "") });

                }

            }

        }

        public void InitDBSettingPage()

        {

            comboBoxPlantList.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            textBoxFittingSymbolPath.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

        }

        private void tabControl_SelectedPageChanged(object sender, DevExpress.XtraTab.TabPageChangedEventArgs e)

        {

            if (e.Page.Name == "pageItemMapping")

            {

                gridViewSymbol.BeginUpdate();

                gridViewAttribute.BeginUpdate();

                symbolDT.Rows.Clear();

                attributeDT.Rows.Clear();

                foreach (var item in symbolMapping)

                {

                    if (item.Key == "FittingSymbolPath")

                    {

                        textBoxFittingSymbolPath.EditValue = item.Value;

                    }

                    else

                    {

                        symbolDT.Rows.Add(item.Key, item.Value);

                    }

                }

                foreach (var item in attributeMapping)

                {

                    if (item.Key == "LargeSize")

                    {

                        if (radioGroupReducer.Properties.Items[0].Tag.ToString() == item.Value)

                            radioGroupReducer.SelectedIndex = 0;

                        else

                            radioGroupReducer.SelectedIndex = 1;

                    }

                    else if (item.Key != "SmallSize")

                    {

                        attributeDT.Rows.Add(new object[] { item.Key, item.Value });

                    }

                }

                needSymbolMapping = needSymbolMapping.Distinct().ToList();

                foreach (string item in needSymbolMapping)

                {

                    if (!symbolMapping.ContainsKey(item))

                        symbolDT.Rows.Add(item, "");

                }

                needAttributeMapping = needAttributeMapping.Distinct().ToList();

                foreach (string item in needAttributeMapping)

                {

                    if (!attributeMapping.ContainsKey(item))

                        attributeDT.Rows.Add(item, "");

                }

                gridViewSymbol.EndUpdate();

                gridViewAttribute.EndUpdate();

            }

        }

        #region Converter Page

        private void RefreshGridViewDrawingList()

        {

            if (gridControlConverter.InvokeRequired)

            {

                gridControlConverter.BeginInvoke(new Action(() => gridControlConverter.Refresh()));

                Thread.Sleep(1);

            }

            else

            {

                gridControlConverter.Refresh();

            }

        }

        private void btnLoadFiles_Click(object sender, EventArgs e)

        {

            OpenFileDialog dia = new OpenFileDialog();

            dia.Multiselect = true;

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

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

            {

                foreach (string fileName in dia.FileNames)

                {

                    try

                    {

                        DataRow row = converterDT.NewRow();

                        Document document = Document.Load(fileName, symbolMapping, attributeMapping);

                        if (document == null)

                        {

                            row[""] = fileName;

                            row["colDrawingFileName"] = fileName;

                            row["colStatus"] = _LoadFail;

                        }

                        else

                        {

                            row["colDrawingFileName"] = document.DWGNAME;

                            row["colDrawingNumber"] = document.DWGNAME;

                            row["colDrawingName"] = document.DWGNAME;

                        }

                        string sUID = Guid.NewGuid().ToString();

                        row["colUID"] = sUID;

                        dicDocument.Add(sUID, document);

                        converterDT.Rows.Add(row);

                        gridViewConverter.BestFitColumns();

                    }

                    catch (Exception ex)

                    {

                    }

                }

            }

        }

        private void btnRun_Click(object sender, EventArgs e)

        {

            if (!CheckDB())

            {

                MessageBox.Show("Please Check DB Setting", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);

                return;

            }

            if (gridViewConverter.SelectedRowsCount > 0)

            {

                if (DialogResult.OK == MessageBox.Show("SPPID Converter를 실행하시겠습니까?", "Question", MessageBoxButtons.OKCancel, MessageBoxIcon.Question))

                {

                    try

                    {

                        ProgressForm.stop = false;

                        foreach (int rowHandle in gridViewConverter.GetSelectedRows())

                        {

                            try

                            {

                                string sStatus = gridViewConverter.GetRowCellDisplayText(rowHandle, "colStatus");

                                if (sStatus == _Ready && !ProgressForm.stop)

                                {

                                    gridViewConverter.SetRowCellValue(rowHandle, "colStatus", _Processing);

                                    RefreshGridViewDrawingList();

                                    string sUnit = gridViewConverter.GetRowCellDisplayText(rowHandle, "colUnit");

                                    string sTemplate = TemplatePath + @"\" + gridViewConverter.GetRowCellDisplayText(rowHandle, "colTemplate");

                                    string sDrawingNumber = gridViewConverter.GetRowCellDisplayText(rowHandle, "colDrawingNumber");

                                    string sDrawingName = gridViewConverter.GetRowCellDisplayText(rowHandle, "colDrawingName");

                                    //

                                    dynamic application = Interaction.GetObject("", "PIDAutomation.Application");

                                    dynamic newDrawing = application.Drawings.Add(sUnit, sTemplate, sDrawingNumber, sDrawingName);

                                    application.ActiveWindow.Fit();

                                    Thread.Sleep(100);

                                    application.ActiveWindow.Zoom = 2000;

                                    Thread.Sleep(100);

                                    //

                                    Document document = dicDocument[gridViewConverter.GetRowCellDisplayText(rowHandle, "colUID")];

                                    autoModelingThread = new Thread(Func =>

                                    {

                                        try

                                        {

                                            Thread.Sleep(500);

                                            ProgressForm.UpdateDocument(document.DWGNAME);

                                            AutoModeling auto = new AutoModeling(document);

                                            auto.Run();

                                            ProgressForm.End();

                                        }

                                        catch (Exception ex)

                                        {

                                            Log.WriteLine(ex);

                                        }

                                    });

                                    ProgressForm.Start(autoModelingThread);

                                    gridViewConverter.SetRowCellValue(rowHandle, "colStatus", _EndProcess);

                                    RefreshGridViewDrawingList();

                                    application.ActiveWindow.Fit();

                                    Thread.Sleep(100);

                                    newDrawing.CloseDrawing(true);

                                    Thread.Sleep(100);

                                }

                            }

                            catch (Exception ex)

                            {

                                gridViewConverter.SetRowCellValue(rowHandle, "colStatus", _Error);

                            }

                        }

                    }

                    catch (Exception ex)

                    {

                        MessageBox.Show(ex.Message);

                    }

                }

            }

            else

            {

                MessageBox.Show("도면을 선택해주세요!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);

            }

        }

        private void UnitButton_ButtonClick(object sender, ButtonPressedEventArgs e)

        {

            UnitForm unitForm = new UnitForm(dUnit);

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