HYTOS

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

<configuration>

  <configSections>

    <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>

  <system.data>

    <DbProviderFactories>

      <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" />

    </DbProviderFactories>

  </system.data>

  <runtime>

    <assemblyBinding xmlns="urn:schemas-microsoft-com:asm.v1">

      <dependentAssembly>

        <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" />

      </dependentAssembly>

    </assemblyBinding>

  </runtime>

  <oracle.manageddataaccess.client>

    <version number="*">

      <dataSources>

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

      </dataSources>

    </version>

  </oracle.manageddataaccess.client>

</configuration>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using Oracle.ManagedDataAccess.Client;

using Oracle.ManagedDataAccess.Types;

using SPPID.Model;

using System.Data;

using System.Globalization;

using System.IO;

namespace SPPID.DB

{

    public class DB

    {

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

        public static bool CheckAndSetDBInformation()

        {

            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 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;

            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;

        }

        public static DataTable GetUnitTree()

        {

            DataTable dt = new DataTable();

            try

            {

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

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

            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 * 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 SPPID.DB

{

    public sealed class DBInformation

    {

        private static DBInformation dbInfo;

        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 _Status = 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 string PlantPath { get => _PlantPath; set => _PlantPath = 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 string Plant { get => _Plant; set => _Plant = value; }

        public bool Status { get => _Status; set => _Status = value; }

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

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

        public static DBInformation GetInstance()

        {

            if (dbInfo == null)

                dbInfo = new DBInformation();

            return dbInfo;

        }

    }

}

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

namespace SPPIDConverter_AutoModeling

{

    public class ItemMapData

    {

    }

}

namespace SPPIDConverter_AutoModeling

{

    partial class MainControl

    {

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

        {

            Telerik.WinControls.UI.GridViewCheckBoxColumn gridViewCheckBoxColumn1 = new Telerik.WinControls.UI.GridViewCheckBoxColumn();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn1 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn1 = new Telerik.WinControls.UI.GridViewCommandColumn();

            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn1 = new Telerik.WinControls.UI.GridViewComboBoxColumn();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn2 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn3 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn4 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn5 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.TableViewDefinition tableViewDefinition1 = new Telerik.WinControls.UI.TableViewDefinition();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn6 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn7 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.TableViewDefinition tableViewDefinition2 = new Telerik.WinControls.UI.TableViewDefinition();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn8 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn2 = new Telerik.WinControls.UI.GridViewComboBoxColumn();

            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn2 = new Telerik.WinControls.UI.GridViewCommandColumn();

            Telerik.WinControls.UI.TableViewDefinition tableViewDefinition3 = new Telerik.WinControls.UI.TableViewDefinition();

            Telerik.WinControls.UI.GridViewTextBoxColumn gridViewTextBoxColumn9 = new Telerik.WinControls.UI.GridViewTextBoxColumn();

            Telerik.WinControls.UI.GridViewComboBoxColumn gridViewComboBoxColumn3 = new Telerik.WinControls.UI.GridViewComboBoxColumn();

            Telerik.WinControls.UI.GridViewCommandColumn gridViewCommandColumn3 = new Telerik.WinControls.UI.GridViewCommandColumn();

            Telerik.WinControls.UI.TableViewDefinition tableViewDefinition4 = new Telerik.WinControls.UI.TableViewDefinition();

            this.panelMain = new System.Windows.Forms.Panel();

            this.pageView = new Telerik.WinControls.UI.RadPageView();

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

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

            this.pageConverter = new Telerik.WinControls.UI.RadPageViewPage();

            this.radPanel2 = new Telerik.WinControls.UI.RadPanel();

            this.gridViewDrawingList = new Telerik.WinControls.UI.RadGridView();

            this.radPanel1 = new Telerik.WinControls.UI.RadPanel();

            this.btnLoadFiles = new Telerik.WinControls.UI.RadButton();

            this.btnRun = new Telerik.WinControls.UI.RadButton();

            this.pageSetting = new Telerik.WinControls.UI.RadPageViewPage();

            this.radPanel3 = new Telerik.WinControls.UI.RadPanel();

            this.gridViewDB = new Telerik.WinControls.UI.RadGridView();

            this.radPanel5 = new Telerik.WinControls.UI.RadPanel();

            this.btnLoadiniFile = new Telerik.WinControls.UI.RadButton();

            this.btnSPPIDDBTest = new Telerik.WinControls.UI.RadButton();

            this.btnSave = new Telerik.WinControls.UI.RadButton();

            this.pageItemMapping = new Telerik.WinControls.UI.RadPageViewPage();

            this.radPanel4 = new Telerik.WinControls.UI.RadPanel();

            this.radSplitContainer1 = new Telerik.WinControls.UI.RadSplitContainer();

            this.splitPanel1 = new Telerik.WinControls.UI.SplitPanel();

            this.gridViewItemMapping = new Telerik.WinControls.UI.RadGridView();

            this.splitPanel2 = new Telerik.WinControls.UI.SplitPanel();

            this.gridViewAttribute = new Telerik.WinControls.UI.RadGridView();

            this.radPanel6 = new Telerik.WinControls.UI.RadPanel();

            this.btnMappingSave = new Telerik.WinControls.UI.RadButton();

            this.pageReport = new Telerik.WinControls.UI.RadPageViewPage();

            this.panelMain.SuspendLayout();

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

            this.pageView.SuspendLayout();

            this.pageConverter.SuspendLayout();

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

            this.radPanel2.SuspendLayout();

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

            ((System.ComponentModel.ISupportInitialize)(this.gridViewDrawingList.MasterTemplate)).BeginInit();

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

            this.radPanel1.SuspendLayout();

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

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

            this.pageSetting.SuspendLayout();

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

            this.radPanel3.SuspendLayout();

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

            ((System.ComponentModel.ISupportInitialize)(this.gridViewDB.MasterTemplate)).BeginInit();

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

            this.radPanel5.SuspendLayout();

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

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

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

            this.pageItemMapping.SuspendLayout();

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

            this.radPanel4.SuspendLayout();

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

            this.radSplitContainer1.SuspendLayout();

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

            this.splitPanel1.SuspendLayout();

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

            ((System.ComponentModel.ISupportInitialize)(this.gridViewItemMapping.MasterTemplate)).BeginInit();

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

            this.splitPanel2.SuspendLayout();

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

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

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

            this.radPanel6.SuspendLayout();

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

            this.SuspendLayout();

            // 

            // panelMain

            // 

            this.panelMain.Controls.Add(this.pageView);

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

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

            this.panelMain.Name = "panelMain";

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

            this.panelMain.TabIndex = 0;

            // 

            // pageView

            // 

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

            this.pageView.Controls.Add(this.pageSetting);

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

            this.pageView.Controls.Add(this.pageReport);

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

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

            this.pageView.Name = "pageView";

            this.pageView.SelectedPage = this.pageItemMapping;

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

            this.pageView.TabIndex = 0;

            this.pageView.ThemeName = "TelerikMetroBlue";

            this.pageView.SelectedPageChanged += new System.EventHandler(this.pageView_SelectedPageChanged);

            ((Telerik.WinControls.UI.RadPageViewStripElement)(this.pageView.GetChildAt(0))).StripButtons = Telerik.WinControls.UI.StripViewButtons.None;

            // 

            // pageConverter

            // 

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

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

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

            this.pageConverter.ItemSize = new System.Drawing.SizeF(98F, 40F);

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

            this.pageConverter.Name = "pageConverter";

            this.pageConverter.Size = new System.Drawing.Size(725, 849);

            this.pageConverter.Text = "Converter";

            // 

            // radPanel2

            // 

            this.radPanel2.Controls.Add(this.gridViewDrawingList);

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

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

            this.radPanel2.Name = "radPanel2";

            this.radPanel2.Size = new System.Drawing.Size(725, 816);

            this.radPanel2.TabIndex = 1;

            this.radPanel2.Text = "radPanel2";

            this.radPanel2.ThemeName = "MaterialBlueGrey";

            // 

            // gridViewDrawingList

            // 

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

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

            // 

            // 

            // 

            this.gridViewDrawingList.MasterTemplate.AllowAddNewRow = false;

            this.gridViewDrawingList.MasterTemplate.AllowCellContextMenu = false;

            this.gridViewDrawingList.MasterTemplate.AllowColumnHeaderContextMenu = false;

            this.gridViewDrawingList.MasterTemplate.AllowDeleteRow = false;

            this.gridViewDrawingList.MasterTemplate.AllowRowHeaderContextMenu = false;

            gridViewCheckBoxColumn1.EnableHeaderCheckBox = true;

            gridViewCheckBoxColumn1.HeaderCheckBoxAlignment = System.Drawing.ContentAlignment.MiddleCenter;

            gridViewCheckBoxColumn1.HeaderText = "";

            gridViewCheckBoxColumn1.MaxWidth = 30;

            gridViewCheckBoxColumn1.MinWidth = 30;

            gridViewCheckBoxColumn1.Name = "colCheckBox";

            gridViewCheckBoxColumn1.RowSpan = 100;

            gridViewCheckBoxColumn1.Width = 30;

            gridViewTextBoxColumn1.HeaderText = "Drawing File Name";

            gridViewTextBoxColumn1.Name = "colDrawingFileName";

            gridViewTextBoxColumn1.ReadOnly = true;

            gridViewTextBoxColumn1.RowSpan = 100;

            gridViewTextBoxColumn1.Width = 130;

            gridViewCommandColumn1.HeaderText = "Unit";

            gridViewCommandColumn1.Name = "colUnit";

            gridViewCommandColumn1.Width = 70;

            gridViewComboBoxColumn1.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest;

            gridViewComboBoxColumn1.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;

            gridViewComboBoxColumn1.HeaderText = "Template";

            gridViewComboBoxColumn1.Name = "colTemplate";

            gridViewComboBoxColumn1.Width = 140;

            gridViewTextBoxColumn2.HeaderText = "Drawing Number";

            gridViewTextBoxColumn2.Name = "colDrawingNumber";

            gridViewTextBoxColumn2.Width = 119;

            gridViewTextBoxColumn3.HeaderText = "Drawing Name";

            gridViewTextBoxColumn3.Name = "colDrawingName";

            gridViewTextBoxColumn3.Width = 104;

            gridViewTextBoxColumn4.HeaderText = "Status";

            gridViewTextBoxColumn4.MinWidth = 100;

            gridViewTextBoxColumn4.Name = "colStatus";

            gridViewTextBoxColumn4.ReadOnly = true;

            gridViewTextBoxColumn4.RowSpan = 100;

            gridViewTextBoxColumn4.TextAlignment = System.Drawing.ContentAlignment.MiddleCenter;

            gridViewTextBoxColumn4.Width = 100;

            gridViewTextBoxColumn5.HeaderText = "DrawingFullName";

            gridViewTextBoxColumn5.IsVisible = false;

            gridViewTextBoxColumn5.Name = "colDrawingFullName";

            gridViewTextBoxColumn5.ReadOnly = true;

            gridViewTextBoxColumn5.Width = 43;

            this.gridViewDrawingList.MasterTemplate.Columns.AddRange(new Telerik.WinControls.UI.GridViewDataColumn[] {

            gridViewCheckBoxColumn1,

            gridViewTextBoxColumn1,

            gridViewCommandColumn1,

            gridViewComboBoxColumn1,

            gridViewTextBoxColumn2,

            gridViewTextBoxColumn3,

            gridViewTextBoxColumn4,

            gridViewTextBoxColumn5});

            this.gridViewDrawingList.MasterTemplate.EnableGrouping = false;

            this.gridViewDrawingList.MasterTemplate.ViewDefinition = tableViewDefinition1;

            this.gridViewDrawingList.Name = "gridViewDrawingList";

            this.gridViewDrawingList.Size = new System.Drawing.Size(725, 816);

            this.gridViewDrawingList.TabIndex = 0;

            this.gridViewDrawingList.ThemeName = "TelerikMetroBlue";

            this.gridViewDrawingList.CellFormatting += new Telerik.WinControls.UI.CellFormattingEventHandler(this.gridViewDrawingList_CellFormatting);

            this.gridViewDrawingList.CellClick += new Telerik.WinControls.UI.GridViewCellEventHandler(this.gridViewDrawingList_CellClick);

            this.gridViewDrawingList.CellValueChanged += new Telerik.WinControls.UI.GridViewCellEventHandler(this.gridViewDrawingList_CellValueChanged);

            // 

            // radPanel1

            // 

            this.radPanel1.Controls.Add(this.btnLoadFiles);

            this.radPanel1.Controls.Add(this.btnRun);

            this.radPanel1.Dock = System.Windows.Forms.DockStyle.Top;

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

            this.radPanel1.Name = "radPanel1";

            this.radPanel1.Size = new System.Drawing.Size(725, 33);

            this.radPanel1.TabIndex = 0;

            this.radPanel1.ThemeName = "MaterialBlueGrey";

            // 

            // btnLoadFiles

            // 

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

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

            this.btnLoadFiles.Name = "btnLoadFiles";

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

            this.btnLoadFiles.TabIndex = 1;

            this.btnLoadFiles.Text = "Load Files ";

            this.btnLoadFiles.TextAlignment = System.Drawing.ContentAlignment.MiddleRight;

            this.btnLoadFiles.ThemeName = "TelerikMetroBlue";

            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.Image = global::SPPIDConverter_AutoModeling.Properties.Resources.Start;

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

            this.btnRun.Name = "btnRun";

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

            this.btnRun.TabIndex = 0;

            this.btnRun.Text = "Run ";

            this.btnRun.TextAlignment = System.Drawing.ContentAlignment.MiddleRight;

            this.btnRun.ThemeName = "TelerikMetroBlue";

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

            // 

            // pageSetting

            // 

            this.pageSetting.Controls.Add(this.radPanel3);

            this.pageSetting.Controls.Add(this.radPanel5);

            this.pageSetting.Image = global::SPPIDConverter_AutoModeling.Properties.Resources.Setting;

            this.pageSetting.ItemSize = new System.Drawing.SizeF(83F, 40F);

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

            this.pageSetting.Name = "pageSetting";

            this.pageSetting.Size = new System.Drawing.Size(725, 849);

            this.pageSetting.Text = "Setting";

            // 

            // radPanel3

            // 

            this.radPanel3.Controls.Add(this.gridViewDB);

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

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

            this.radPanel3.Name = "radPanel3";

            this.radPanel3.Size = new System.Drawing.Size(725, 819);

            this.radPanel3.TabIndex = 32;

            this.radPanel3.Text = "radPanel3";

            this.radPanel3.ThemeName = "MaterialBlueGrey";

            // 

            // gridViewDB

            // 

            this.gridViewDB.BackColor = System.Drawing.Color.White;

            this.gridViewDB.Cursor = System.Windows.Forms.Cursors.Default;

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

            this.gridViewDB.Font = new System.Drawing.Font("Segoe UI", 9F);

            this.gridViewDB.ForeColor = System.Drawing.SystemColors.ControlText;

            this.gridViewDB.ImeMode = System.Windows.Forms.ImeMode.NoControl;

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

            // 

            // 

            // 

            this.gridViewDB.MasterTemplate.AllowAddNewRow = false;

            this.gridViewDB.MasterTemplate.AllowDeleteRow = false;

            this.gridViewDB.MasterTemplate.AllowDragToGroup = false;

            this.gridViewDB.MasterTemplate.AutoSizeColumnsMode = Telerik.WinControls.UI.GridViewAutoSizeColumnsMode.Fill;

            gridViewTextBoxColumn6.EnableExpressionEditor = false;

            gridViewTextBoxColumn6.HeaderText = "Key";

            gridViewTextBoxColumn6.Name = "colKey";

            gridViewTextBoxColumn6.ReadOnly = true;

            gridViewTextBoxColumn6.Width = 51;

            gridViewTextBoxColumn7.EnableExpressionEditor = false;

            gridViewTextBoxColumn7.HeaderText = "Value";

            gridViewTextBoxColumn7.Name = "colValue";

            gridViewTextBoxColumn7.Width = 674;

            this.gridViewDB.MasterTemplate.Columns.AddRange(new Telerik.WinControls.UI.GridViewDataColumn[] {

            gridViewTextBoxColumn6,

            gridViewTextBoxColumn7});

            this.gridViewDB.MasterTemplate.EnableGrouping = false;

            this.gridViewDB.MasterTemplate.EnableSorting = false;

            this.gridViewDB.MasterTemplate.ShowRowHeaderColumn = false;

            this.gridViewDB.MasterTemplate.ViewDefinition = tableViewDefinition2;

            this.gridViewDB.Name = "gridViewDB";

            this.gridViewDB.RightToLeft = System.Windows.Forms.RightToLeft.No;

            this.gridViewDB.Size = new System.Drawing.Size(725, 819);

            this.gridViewDB.TabIndex = 29;

            this.gridViewDB.ThemeName = "TelerikMetroBlue";

            this.gridViewDB.CellFormatting += new Telerik.WinControls.UI.CellFormattingEventHandler(this.gridViewDB_CellFormatting);

            // 

            // radPanel5

            // 

            this.radPanel5.Controls.Add(this.btnLoadiniFile);

            this.radPanel5.Controls.Add(this.btnSPPIDDBTest);

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

            this.radPanel5.Dock = System.Windows.Forms.DockStyle.Top;

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

            this.radPanel5.Name = "radPanel5";

            this.radPanel5.Size = new System.Drawing.Size(725, 30);

            this.radPanel5.TabIndex = 31;

            this.radPanel5.ThemeName = "MaterialBlueGrey";

            // 

            // btnLoadiniFile

            // 

            this.btnLoadiniFile.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Left)));

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

            this.btnLoadiniFile.Name = "btnLoadiniFile";

            this.btnLoadiniFile.Size = new System.Drawing.Size(110, 24);

            this.btnLoadiniFile.TabIndex = 13;

            this.btnLoadiniFile.Text = "Load Plant ini File";

            this.btnLoadiniFile.ThemeName = "TelerikMetroBlue";

            this.btnLoadiniFile.Click += new System.EventHandler(this.btnLoadiniFile_Click);

            // 

            // btnSPPIDDBTest

            // 

            this.btnSPPIDDBTest.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

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

            this.btnSPPIDDBTest.Name = "btnSPPIDDBTest";

            this.btnSPPIDDBTest.Size = new System.Drawing.Size(82, 24);

            this.btnSPPIDDBTest.TabIndex = 25;

            this.btnSPPIDDBTest.Text = "DB Test";

            this.btnSPPIDDBTest.ThemeName = "TelerikMetroBlue";

            this.btnSPPIDDBTest.Click += new System.EventHandler(this.btnSPPIDDBTest_Click);

            // 

            // btnSave

            // 

            this.btnSave.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

            this.btnSave.Enabled = false;

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

            this.btnSave.Name = "btnSave";

            this.btnSave.Size = new System.Drawing.Size(82, 24);

            this.btnSave.TabIndex = 28;

            this.btnSave.Text = "Save";

            this.btnSave.ThemeName = "TelerikMetroBlue";

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

            // 

            // pageItemMapping

            // 

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

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

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

            this.pageItemMapping.ItemSize = new System.Drawing.SizeF(122F, 40F);

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

            this.pageItemMapping.Name = "pageItemMapping";

            this.pageItemMapping.Size = new System.Drawing.Size(725, 849);

            this.pageItemMapping.Text = "Item Mapping";

            // 

            // radPanel4

            // 

            this.radPanel4.Controls.Add(this.radSplitContainer1);

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

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

            this.radPanel4.Name = "radPanel4";

            this.radPanel4.Size = new System.Drawing.Size(725, 819);

            this.radPanel4.TabIndex = 5;

            this.radPanel4.ThemeName = "MaterialBlueGrey";

            // 

            // radSplitContainer1

            // 

            this.radSplitContainer1.Controls.Add(this.splitPanel1);

            this.radSplitContainer1.Controls.Add(this.splitPanel2);

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

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

            this.radSplitContainer1.Name = "radSplitContainer1";

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

            // 

            // 

            // 

            this.radSplitContainer1.RootElement.MinSize = new System.Drawing.Size(25, 25);

            this.radSplitContainer1.Size = new System.Drawing.Size(725, 819);

            this.radSplitContainer1.TabIndex = 4;

            this.radSplitContainer1.TabStop = false;

            this.radSplitContainer1.ThemeName = "TelerikMetroBlue";

            // 

            // splitPanel1

            // 

            this.splitPanel1.Controls.Add(this.gridViewItemMapping);

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

            this.splitPanel1.Name = "splitPanel1";

            // 

            // 

            // 

            this.splitPanel1.RootElement.MinSize = new System.Drawing.Size(25, 25);

            this.splitPanel1.Size = new System.Drawing.Size(725, 408);

            this.splitPanel1.TabIndex = 0;

            this.splitPanel1.TabStop = false;

            this.splitPanel1.Text = "splitPanel1";

            this.splitPanel1.ThemeName = "TelerikMetroBlue";

            // 

            // gridViewItemMapping

            // 

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

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

            // 

            // 

            // 

            this.gridViewItemMapping.MasterTemplate.AllowAddNewRow = false;

            this.gridViewItemMapping.MasterTemplate.AllowCellContextMenu = false;

            this.gridViewItemMapping.MasterTemplate.AllowColumnHeaderContextMenu = false;

            this.gridViewItemMapping.MasterTemplate.AllowRowHeaderContextMenu = false;

            gridViewTextBoxColumn8.HeaderText = "Item Name";

            gridViewTextBoxColumn8.Name = "colItemName";

            gridViewTextBoxColumn8.Width = 80;

            gridViewComboBoxColumn2.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest;

            gridViewComboBoxColumn2.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;

            gridViewComboBoxColumn2.HeaderText = "SPPID Name";

            gridViewComboBoxColumn2.Name = "colSPPIDName";

            gridViewComboBoxColumn2.Width = 89;

            gridViewCommandColumn2.HeaderText = "Select in Explorer";

            gridViewCommandColumn2.Name = "colSelect";

            gridViewCommandColumn2.Width = 118;

            this.gridViewItemMapping.MasterTemplate.Columns.AddRange(new Telerik.WinControls.UI.GridViewDataColumn[] {

            gridViewTextBoxColumn8,

            gridViewComboBoxColumn2,

            gridViewCommandColumn2});

            this.gridViewItemMapping.MasterTemplate.EnableGrouping = false;

            this.gridViewItemMapping.MasterTemplate.ViewDefinition = tableViewDefinition3;

            this.gridViewItemMapping.Name = "gridViewItemMapping";

            this.gridViewItemMapping.ShowGroupPanel = false;

            this.gridViewItemMapping.Size = new System.Drawing.Size(725, 408);

            this.gridViewItemMapping.TabIndex = 0;

            this.gridViewItemMapping.ThemeName = "TelerikMetroBlue";

            this.gridViewItemMapping.CellFormatting += new Telerik.WinControls.UI.CellFormattingEventHandler(this.gridViewItemMapping_CellFormatting);

            // 

            // splitPanel2

            // 

            this.splitPanel2.Controls.Add(this.gridViewAttribute);

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

            this.splitPanel2.Name = "splitPanel2";

            // 

            // 

            // 

            this.splitPanel2.RootElement.MinSize = new System.Drawing.Size(25, 25);

            this.splitPanel2.Size = new System.Drawing.Size(725, 407);

            this.splitPanel2.TabIndex = 1;

            this.splitPanel2.TabStop = false;

            this.splitPanel2.Text = "splitPanel2";

            this.splitPanel2.ThemeName = "TelerikMetroBlue";

            // 

            // gridViewAttribute

            // 

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

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

            // 

            // 

            // 

            this.gridViewAttribute.MasterTemplate.AllowAddNewRow = false;

            this.gridViewAttribute.MasterTemplate.AllowCellContextMenu = false;

            this.gridViewAttribute.MasterTemplate.AllowColumnHeaderContextMenu = false;

            this.gridViewAttribute.MasterTemplate.AllowRowHeaderContextMenu = false;

            gridViewTextBoxColumn9.HeaderText = "Attribute";

            gridViewTextBoxColumn9.Name = "colAttribute";

            gridViewTextBoxColumn9.Width = 66;

            gridViewComboBoxColumn3.AutoCompleteMode = System.Windows.Forms.AutoCompleteMode.Suggest;

            gridViewComboBoxColumn3.DropDownStyle = Telerik.WinControls.RadDropDownStyle.DropDown;

            gridViewComboBoxColumn3.HeaderText = "SPPID Attribute";

            gridViewComboBoxColumn3.Name = "colSPPIDAttribute";

            gridViewComboBoxColumn3.Width = 108;

            gridViewCommandColumn3.HeaderText = "Select in Explorer";

            gridViewCommandColumn3.Name = "colSelect";

            gridViewCommandColumn3.Width = 118;

            this.gridViewAttribute.MasterTemplate.Columns.AddRange(new Telerik.WinControls.UI.GridViewDataColumn[] {

            gridViewTextBoxColumn9,

            gridViewComboBoxColumn3,

            gridViewCommandColumn3});

            this.gridViewAttribute.MasterTemplate.EnableGrouping = false;

            this.gridViewAttribute.MasterTemplate.ViewDefinition = tableViewDefinition4;

            this.gridViewAttribute.Name = "gridViewAttribute";

            this.gridViewAttribute.ShowGroupPanel = false;

            this.gridViewAttribute.Size = new System.Drawing.Size(725, 407);

            this.gridViewAttribute.TabIndex = 1;

            this.gridViewAttribute.ThemeName = "TelerikMetroBlue";

            this.gridViewAttribute.CellFormatting += new Telerik.WinControls.UI.CellFormattingEventHandler(this.gridViewAttribute_CellFormatting);

            // 

            // radPanel6

            // 

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

            this.radPanel6.Dock = System.Windows.Forms.DockStyle.Top;

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

            this.radPanel6.Name = "radPanel6";

            this.radPanel6.Size = new System.Drawing.Size(725, 30);

            this.radPanel6.TabIndex = 4;

            this.radPanel6.ThemeName = "MaterialBlueGrey";

            // 

            // btnMappingSave

            // 

            this.btnMappingSave.Anchor = ((System.Windows.Forms.AnchorStyles)((System.Windows.Forms.AnchorStyles.Bottom | System.Windows.Forms.AnchorStyles.Right)));

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

            this.btnMappingSave.Name = "btnMappingSave";

            this.btnMappingSave.Size = new System.Drawing.Size(82, 24);

            this.btnMappingSave.TabIndex = 29;

            this.btnMappingSave.Text = "Save";

            this.btnMappingSave.ThemeName = "TelerikMetroBlue";

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

            // 

            // pageReport

            // 

            this.pageReport.Enabled = false;

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

            this.pageReport.ItemSize = new System.Drawing.SizeF(81F, 40F);

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

            this.pageReport.Name = "pageReport";

            this.pageReport.Size = new System.Drawing.Size(725, 849);

            this.pageReport.Text = "Report";

            // 

            // MainControl

            // 

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

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

            this.Controls.Add(this.panelMain);

            this.Name = "MainControl";

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

            this.panelMain.ResumeLayout(false);

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

            this.pageView.ResumeLayout(false);

            this.pageConverter.ResumeLayout(false);

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

            this.radPanel2.ResumeLayout(false);

            ((System.ComponentModel.ISupportInitialize)(this.gridViewDrawingList.MasterTemplate)).EndInit();

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

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

            this.radPanel1.ResumeLayout(false);

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

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

            this.pageSetting.ResumeLayout(false);

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

            this.radPanel3.ResumeLayout(false);

            ((System.ComponentModel.ISupportInitialize)(this.gridViewDB.MasterTemplate)).EndInit();

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

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

            this.radPanel5.ResumeLayout(false);

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

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

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

            this.pageItemMapping.ResumeLayout(false);

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

            this.radPanel4.ResumeLayout(false);

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

            this.radSplitContainer1.ResumeLayout(false);

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

            this.splitPanel1.ResumeLayout(false);

            ((System.ComponentModel.ISupportInitialize)(this.gridViewItemMapping.MasterTemplate)).EndInit();

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

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

            this.splitPanel2.ResumeLayout(false);

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

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

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

            this.radPanel6.ResumeLayout(false);

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

            this.ResumeLayout(false);

        }

        #endregion

        private System.Windows.Forms.Panel panelMain;

        private Telerik.WinControls.UI.RadPageView pageView;

        private Telerik.WinControls.UI.RadPageViewPage pageConverter;

        private Telerik.WinControls.UI.RadPageViewPage pageItemMapping;

        private Telerik.WinControls.UI.RadPageViewPage pageReport;

        private Telerik.WinControls.Themes.TelerikMetroBlueTheme telerikMetroBlueTheme;

        private Telerik.WinControls.Themes.MaterialBlueGreyTheme materialBlueGreyTheme;

        private Telerik.WinControls.UI.RadPanel radPanel2;

        private Telerik.WinControls.UI.RadPanel radPanel1;

        private Telerik.WinControls.UI.RadGridView gridViewDrawingList;

        private Telerik.WinControls.UI.RadButton btnLoadFiles;

        private Telerik.WinControls.UI.RadButton btnRun;

        private Telerik.WinControls.UI.RadPageViewPage pageSetting;

        private Telerik.WinControls.UI.RadButton btnSPPIDDBTest;

        private Telerik.WinControls.UI.RadButton btnLoadiniFile;

        private Telerik.WinControls.UI.RadButton btnSave;

        private Telerik.WinControls.UI.RadPanel radPanel3;

        private Telerik.WinControls.UI.RadGridView gridViewDB;

        private Telerik.WinControls.UI.RadPanel radPanel5;

        private Telerik.WinControls.UI.RadPanel radPanel4;

        private Telerik.WinControls.UI.RadSplitContainer radSplitContainer1;

        private Telerik.WinControls.UI.SplitPanel splitPanel1;

        private Telerik.WinControls.UI.RadGridView gridViewItemMapping;

        private Telerik.WinControls.UI.SplitPanel splitPanel2;

        private Telerik.WinControls.UI.RadPanel radPanel6;

        private Telerik.WinControls.UI.RadButton btnMappingSave;

        private Telerik.WinControls.UI.RadGridView gridViewAttribute;

    }

}

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 Telerik.WinControls.UI;

using System.IO;

using System.Threading;

using SPPID.Modeling;

using SPPID.Model;

using SPPID.Utill;

using SPPID.DB;

using Microsoft.VisualBasic;

using Newtonsoft.Json;

namespace SPPIDConverter_AutoModeling

{

    public partial class MainControl : UserControl

    {

        Thread autoModelingThread;

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

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

        private DataTable dUnit = new DataTable();

        private string TemplatePath;

        private string SymbolPath;

        public MainControl()

        {

            InitializeComponent();

            if (SetPath())

            {

                if (SPPIDUtill.LoadDB())

                    InitDBInformation();

                else

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

                InitGridViewDB();

            }

            else

            {

            }

        }

        private bool SetPath()

        {

            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;

        }

        #region Init Data Setting

        public void InitDBInformation()

        {

            // Unit DataTable

            dUnit = DB.GetUnitTree();

            // Template List

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

            GridViewComboBoxColumn colTemplate = gridViewDrawingList.Columns["colTemplate"] as GridViewComboBoxColumn;

            colTemplate.DataSource = Directory.GetFiles(TemplatePath, "*.pid").ToList().Select(filePath => Path.GetFileName(filePath));

            // Load Mapping

            SPPIDUtill.LoadMapping(symbolMapping, attributeMapping);

            // Symbol Path

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

            GridViewComboBoxColumn colSPPIDName = gridViewItemMapping.Columns["colSPPIDName"] as GridViewComboBoxColumn;

            colSPPIDName.DataSource = Directory.GetFiles(SymbolPath, "*.sym", SearchOption.AllDirectories).ToList().Select(symbol => symbol.Remove(0, SymbolPath.Length));

            // Load Mapping

            SPPIDUtill.LoadMapping(symbolMapping, attributeMapping);

            gridViewItemMapping.BeginUpdate();

            foreach (var item in symbolMapping)

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

            gridViewItemMapping.BestFitColumns();

            gridViewItemMapping.EndUpdate();

            // Attribute

            GridViewComboBoxColumn colSPPIDAttribute = gridViewAttribute.Columns["colSPPIDAttribute"] as GridViewComboBoxColumn;

            colSPPIDAttribute.DataSource = DB.GetSPPIDAttribute();

            // Load Attribute

            gridViewAttribute.BeginUpdate();

            foreach (var item in attributeMapping)

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

            gridViewAttribute.BestFitColumns();

            gridViewAttribute.EndUpdate();

        }

        #endregion

        #region Setting Page

        private const string _DBType = "DB Type";

        private const string _ServiceName = "Service Name";

        private const string _SiteName = "Site Name";

        private const string _ServerIP = "Server IP";

        private const string _Port = "Port";

        private const string _DBUser = "DB User";

        private const string _DBPassword = "DB Password";

        private void InitGridViewDB()

        {

            DBInformation dbInfo = DBInformation.GetInstance();

            gridViewDB.Rows.Add(new object[] { _DBType , dbInfo.DBType});

            gridViewDB.Rows.Add(new object[] { _ServiceName, dbInfo.Service });

            gridViewDB.Rows.Add(new object[] { _SiteName, dbInfo.Site});

            gridViewDB.Rows.Add(new object[] { _ServerIP, dbInfo.ServerIP});

            gridViewDB.Rows.Add(new object[] { _Port, dbInfo.Port});

            gridViewDB.Rows.Add(new object[] { _DBUser, dbInfo.DBUser});

            gridViewDB.Rows.Add(new object[] { _DBPassword, dbInfo.DBPassword});

            gridViewDB.BestFitColumns();

            this.gridViewDB.RowFormatting += new Telerik.WinControls.UI.RowFormattingEventHandler(this.gridViewDB_RowFormatting);

            this.gridViewDB.CellBeginEdit += new Telerik.WinControls.UI.GridViewCellCancelEventHandler(this.gridViewDB_CellBeginEdit);

            this.gridViewDB.CellValueChanged += new Telerik.WinControls.UI.GridViewCellEventHandler(this.gridViewDB_CellValueChanged);

        }

        private void gridViewDB_CellBeginEdit(object sender, GridViewCellCancelEventArgs e)

        {

            string sKey = (string)e.Row.Cells["colKey"].Value;

            if (sKey == _DBType ||

                sKey == _ServiceName ||

                sKey == _SiteName)

            {

                e.Cancel = true;

            }

            else

            {

            }

        }

        private void gridViewDB_RowFormatting(object sender, RowFormattingEventArgs e)

        {

            string sKey = (string)e.RowElement.RowInfo.Cells["colKey"].Value;

            if (sKey == _DBType ||

               sKey == _ServiceName ||

               sKey == _SiteName)

            {

                e.RowElement.DrawFill = true;

                e.RowElement.GradientStyle = Telerik.WinControls.GradientStyles.Solid;

                e.RowElement.BackColor = Color.Aquamarine;

            }

        }

        private void gridViewDB_CellValueChanged(object sender, GridViewCellEventArgs e)

        {

            btnSave.Enabled = false;

        }

        private void btnLoadiniFile_Click(object sender, EventArgs e)

        {

            try

            {

                OpenFileDialog dialog = new OpenFileDialog();

                dialog.Multiselect = false;

                dialog.Filter = "ini File(*.ini)|*.ini";

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

                {

                    string sDBTYPE = string.Empty;

                    string sSERVICENAME = string.Empty;

                    string sUID = string.Empty;

                    string[] texts = File.ReadAllLines(dialog.FileName);

                    bool find = false;

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

                    {

                        string text = texts[i];

                        if (text.Trim() == "[SITESCHEMA]")

                            find = true;

                        if (find)

                        {

                            if (text.StartsWith("DBTYPE=") && string.IsNullOrEmpty(sDBTYPE))

                                sDBTYPE = text.Remove(0, "DBTYPE=".Length);

                            else if (text.StartsWith("DBSERVER=") && string.IsNullOrEmpty(sSERVICENAME))

                                sSERVICENAME = text.Remove(0, "DBSERVER=".Length);

                            else if (text.StartsWith("UID=") && string.IsNullOrEmpty(sUID))

                                sUID = text.Remove(0, "UID=".Length);

                        }

                    }

                    if (string.IsNullOrEmpty(sDBTYPE) || string.IsNullOrEmpty(sSERVICENAME) || string.IsNullOrEmpty(sUID))

                        MessageBox.Show("Unavailable ini file.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);

                    else

                    {

                        foreach (GridViewRowInfo rowInfo in gridViewDB.Rows)

                        {

                            string sKey = (string)rowInfo.Cells["colKey"].Value;

                            if (sKey == _DBType)

                                rowInfo.Cells["colValue"].Value = sDBTYPE;

                            else if (sKey == _ServiceName)

                                rowInfo.Cells["colValue"].Value = sSERVICENAME;

                            else if (sKey == _SiteName)

                                rowInfo.Cells["colValue"].Value = sUID;

                        }

                    }

                }

            }

            catch (Exception ex)

            {

                MessageBox.Show("Unavailable ini file.", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);

            }

        }

        private void btnSPPIDDBTest_Click(object sender, EventArgs e)

        {

            DBInformation dbInfo = DBInformation.GetInstance();

            dbInfo.Status = false;

            foreach (GridViewRowInfo rowInfo in gridViewDB.Rows)

            {

                string sKey = (string)rowInfo.Cells["colKey"].Value;

                string sValue = (string)rowInfo.Cells["colValue"].Value;

                switch (sKey)

                {

                    case _DBType:

                        dbInfo.DBType = sValue;

                        break;

                    case _ServiceName:

                        dbInfo.Service = sValue;

                        break;

                    case _SiteName:

                        dbInfo.Site = sValue;

                        break;

                    case _ServerIP:

                        dbInfo.ServerIP = sValue;

                        break;

                    case _Port:

                        dbInfo.Port = sValue;

                        break;

                    case _DBUser:

                        dbInfo.DBUser = sValue;

                        break;

                    case _DBPassword:

                        dbInfo.DBPassword = sValue;

                        break;

                    default: