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

    </configSections>

  <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 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 LEVEL, SP_ID, NAME, PARENTID 

                                    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 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 static DBInformation GetInstance()

        {

            if (dbInfo == null)

                dbInfo = new DBInformation();

            return dbInfo;

        }

    }

}

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            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.radSplitContainer1 = new Telerik.WinControls.UI.RadSplitContainer();

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

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

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

            this.radSplitContainer1.SuspendLayout();

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

            this.splitPanel1.SuspendLayout();

            ((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.panelMain.Size = new System.Drawing.Size(735, 900);

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

            this.pageView.SelectedPage = this.pageItemMapping;

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

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

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

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

            this.gridViewDrawingList.MasterTemplate.AllowColumnHeaderContextMenu = false;

            this.gridViewDrawingList.MasterTemplate.AllowRowHeaderContextMenu = false;

            gridViewCheckBoxColumn3.EnableHeaderCheckBox = true;

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

            gridViewCheckBoxColumn3.HeaderText = "";

            gridViewCheckBoxColumn3.MaxWidth = 30;

            gridViewCheckBoxColumn3.MinWidth = 30;

            gridViewCheckBoxColumn3.Name = "colCheckBox";

            gridViewCheckBoxColumn3.RowSpan = 100;

            gridViewCheckBoxColumn3.Width = 30;

            gridViewTextBoxColumn21.HeaderText = "Drawing File Name";

            gridViewTextBoxColumn21.Name = "colDrawingFileName";

            gridViewTextBoxColumn21.ReadOnly = true;

            gridViewTextBoxColumn21.RowSpan = 100;

            gridViewTextBoxColumn21.Width = 130;

            gridViewCommandColumn9.HeaderText = "Unit";

            gridViewCommandColumn9.Name = "colUnit";

            gridViewCommandColumn9.Width = 70;

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

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

            gridViewComboBoxColumn9.HeaderText = "Template";

            gridViewComboBoxColumn9.Name = "colTemplate";

            gridViewComboBoxColumn9.Width = 140;

            gridViewTextBoxColumn22.HeaderText = "Drawing Number";

            gridViewTextBoxColumn22.Name = "colDrawingNumber";

            gridViewTextBoxColumn22.Width = 119;

            gridViewTextBoxColumn23.HeaderText = "Drawing Name";

            gridViewTextBoxColumn23.Name = "colDrawingName";

            gridViewTextBoxColumn23.Width = 104;

            gridViewTextBoxColumn24.HeaderText = "Status";

            gridViewTextBoxColumn24.MinWidth = 100;

            gridViewTextBoxColumn24.Name = "colStatus";

            gridViewTextBoxColumn24.ReadOnly = true;

            gridViewTextBoxColumn24.RowSpan = 100;

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

            gridViewTextBoxColumn24.Width = 100;

            gridViewTextBoxColumn25.HeaderText = "DrawingFullName";

            gridViewTextBoxColumn25.IsVisible = false;

            gridViewTextBoxColumn25.Name = "colDrawingFullName";

            gridViewTextBoxColumn25.ReadOnly = true;

            gridViewTextBoxColumn25.Width = 43;

            gridViewCheckBoxColumn3,

            gridViewTextBoxColumn21,

            gridViewCommandColumn9,

            gridViewComboBoxColumn9,

            gridViewTextBoxColumn22,

            gridViewTextBoxColumn23,

            gridViewTextBoxColumn24,

            gridViewTextBoxColumn25});

            this.gridViewDrawingList.MasterTemplate.ViewDefinition = tableViewDefinition11;

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

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

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

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

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

            gridViewTextBoxColumn26.EnableExpressionEditor = false;

            gridViewTextBoxColumn26.HeaderText = "Key";

            gridViewTextBoxColumn26.Name = "colKey";

            gridViewTextBoxColumn26.ReadOnly = true;

            gridViewTextBoxColumn26.Width = 51;

            gridViewTextBoxColumn27.EnableExpressionEditor = false;

            gridViewTextBoxColumn27.HeaderText = "Value";

            gridViewTextBoxColumn27.Name = "colValue";

            gridViewTextBoxColumn27.Width = 674;

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

            gridViewTextBoxColumn26,

            gridViewTextBoxColumn27});

            this.gridViewDB.MasterTemplate.EnableGrouping = false;

            this.gridViewDB.MasterTemplate.EnableSorting = false;

            this.gridViewDB.MasterTemplate.ShowRowHeaderColumn = false;

            this.gridViewDB.MasterTemplate.ViewDefinition = tableViewDefinition12;

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

            // 

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

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

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

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

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

            this.radPanel4.TabIndex = 5;

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

            // 

            this.gridViewItemMapping.MasterTemplate.AllowCellContextMenu = false;

            this.gridViewItemMapping.MasterTemplate.AllowColumnHeaderContextMenu = false;

            this.gridViewItemMapping.MasterTemplate.AllowDeleteRow = false;

            this.gridViewItemMapping.MasterTemplate.AllowRowHeaderContextMenu = false;

            gridViewTextBoxColumn19.HeaderText = "Item Name";

            gridViewTextBoxColumn19.Name = "colItemName";

            gridViewTextBoxColumn19.Width = 80;

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

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

            gridViewComboBoxColumn7.HeaderText = "SPPID Name";

            gridViewComboBoxColumn7.Name = "colSPPIDName";

            gridViewComboBoxColumn7.Width = 89;

            gridViewCommandColumn7.HeaderText = "Select in Explorer";

            gridViewCommandColumn7.Name = "colSelect";

            gridViewCommandColumn7.Width = 118;

            gridViewTextBoxColumn19,

            gridViewComboBoxColumn7,

            gridViewCommandColumn7});

            this.gridViewItemMapping.MasterTemplate.ViewDefinition = tableViewDefinition9;

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

            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.AllowDeleteRow = false;

            this.gridViewAttribute.MasterTemplate.AllowRowHeaderContextMenu = false;

            gridViewTextBoxColumn20.HeaderText = "Attribute";

            gridViewTextBoxColumn20.Name = "colAttribute";

            gridViewTextBoxColumn20.Width = 66;

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

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

            gridViewComboBoxColumn8.HeaderText = "SPPID Attribute";

            gridViewComboBoxColumn8.Name = "colSPPIDAttribute";

            gridViewComboBoxColumn8.Width = 108;

            gridViewCommandColumn8.HeaderText = "Select in Explorer";

            gridViewCommandColumn8.Name = "colSelect";

            gridViewCommandColumn8.Width = 118;

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

            gridViewTextBoxColumn20,

            gridViewComboBoxColumn8,

            gridViewCommandColumn8});

            this.gridViewAttribute.MasterTemplate.EnableGrouping = false;

            this.gridViewAttribute.MasterTemplate.ViewDefinition = tableViewDefinition10;

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

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

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

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

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

            this.radSplitContainer1.ResumeLayout(false);

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

            this.splitPanel1.ResumeLayout(false);

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

        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.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.SplitPanel splitPanel2;

        private Telerik.WinControls.UI.RadPanel radPanel6;

        private Telerik.WinControls.UI.RadButton btnMappingSave;

        private Telerik.WinControls.UI.RadGridView gridViewAttribute;

using SPPID.DB;

using Newtonsoft.Json;

        Thread autoModelingThread;

        private DataTable dUnit = new DataTable();

        private string TemplatePath;

        private string SymbolPath;

            if (SetPath())

            {

                if (SPPIDUtill.LoadDB())

                    InitDBInformation();

                else

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

                InitGridViewDB();

            }

            else

        private bool SetPath()

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

                        return true;

            }

            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:

                        break;

                }

            }

            if (DB.CheckAndSetDBInformation())

            {

                btnSave.Enabled = true;

                MessageBox.Show("Test Connection Success!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

            else

            {

                MessageBox.Show("Check DB Information!", "Warning", MessageBoxButtons.OK, MessageBoxIcon.Warning);

            }

        }

        private void gridViewDB_CellFormatting(object sender, CellFormattingEventArgs e)

        {

            if (e.Column.Name == "colValue" && (string)e.Row.Cells["colKey"].Value == _DBPassword)

            {

                object value = e.CellElement.RowInfo.Cells["colValue"].Value;

                string text = string.Empty;

                if (value != null)

                {

                    int passwordLen = Convert.ToString(value).Length + 1;

                    text = string.Join("*", new string[passwordLen]);

                }

                e.CellElement.Text = text;

            }

        }

        private void btnSave_Click(object sender, EventArgs e)

        {

            DBInformation dbInfo = DBInformation.GetInstance();

            if (dbInfo != null)

            {

                dbInfo.Status = true;

                string sJson = JsonConvert.SerializeObject(dbInfo);

                SPPIDUtill.SaveDB(sJson);

                MessageBox.Show("Save Success!", "Information", MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

            else

            {

            }

        }

        #endregion

        #region Convert Page

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

        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)

            {

                gridViewDrawingList.CellValueChanged -= new GridViewCellEventHandler(this.gridViewDrawingList_CellValueChanged);

                foreach (string fileName in dia.FileNames)

                {

                    try

                    {

                        GridViewDataRowInfo row = new GridViewDataRowInfo(gridViewDrawingList.MasterView);

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

                        row.Tag = document;

                        if (document == null)

                        {

                            row.Cells["colDrawingFileName"].Value = fileName;

                            row.Cells["colStatus"].Value = _LoadFail;

                            row.Cells["colDrawingFullName"].Value = fileName;

                        }

                        else

                        {

                            row.Cells["colCheckBox"].Value = false;

                            row.Cells["colDrawingFileName"].Value = document.DWGNAME;

                            row.Cells["colDrawingNumber"].Value = document.DWGNAME;

                            row.Cells["colDrawingName"].Value = document.DWGNAME;

                            row.Cells["colDrawingFullName"].Value = fileName;

                        }

                        gridViewDrawingList.Rows.Add(row);

                        CheckValidateDrawing(row);

                    }

                    catch (Exception ex)

                    {

                    }

                }

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

                foreach (GridViewRowInfo rowInfo in gridViewDrawingList.Rows)

                    try

                    {

                        bool bChecked = (bool)rowInfo.Cells["colCheckBox"].Value;

                        string sStatus = rowInfo.Cells["colStatus"].Value.ToString();

                        if (bChecked && sStatus == _Ready)

                        {

                            string sUnit = rowInfo.Cells["colUnit"].Value.ToString();

                            string sTemplate = TemplatePath + @"\" + rowInfo.Cells["colTemplate"].Value.ToString();

                            string sDrawingNumber = rowInfo.Cells["colDrawingNumber"].Value.ToString();

                            string sDrawingName = rowInfo.Cells["colDrawingName"].Value.ToString();

                            //

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

                            application.ActiveWindow.Fit();

                            Thread.Sleep(10);

                            application.ActiveWindow.Zoom = 2000;

                            Thread.Sleep(10);

                            //

                            Document document = rowInfo.Tag as Document;