HYTOS

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

<configuration>

  <configSections>

    <!-- For more information on Entity Framework configuration, visit http://go.microsoft.com/fwlink/?LinkID=237468 -->

    <section name="entityFramework" type="System.Data.Entity.Internal.ConfigFile.EntityFrameworkSection, EntityFramework, Version=6.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" requirePermission="false" />

    <sectionGroup name="userSettings" type="System.Configuration.UserSettingsGroup, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" >

      <section name="Converter.SPPID.Properties.Settings" type="System.Configuration.ClientSettingsSection, System, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089" allowExeDefinition="MachineToLocalUser" requirePermission="false" />

    </sectionGroup>

  </configSections>

  <entityFramework>

    <defaultConnectionFactory type="System.Data.Entity.Infrastructure.LocalDbConnectionFactory, EntityFramework">

      <parameters>

        <parameter value="mssqllocaldb" />

      </parameters>

    </defaultConnectionFactory>

    <providers>

      <provider invariantName="System.Data.SqlClient" type="System.Data.Entity.SqlServer.SqlProviderServices, EntityFramework.SqlServer" />

      <provider invariantName="System.Data.SQLite.EF6" type="System.Data.SQLite.EF6.SQLiteProviderServices, System.Data.SQLite.EF6" />

    </providers>

  </entityFramework>

  <userSettings>

    <Converter.SPPID.Properties.Settings>

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

        <value />

      </setting>

    </Converter.SPPID.Properties.Settings>

  </userSettings>

</configuration>

namespace Converter.SPPID

{

    partial class ConverterForm

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

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

        protected override void Dispose(bool disposing)

        {

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

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

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

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

        /// </summary>

        private void InitializeComponent()

        {

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.splitterItem1 = new DevExpress.XtraLayout.SplitterItem();

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

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

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

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

            this.layoutControl1.SuspendLayout();

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.SuspendLayout();

            // 

            // defaultLookAndFeel

            // 

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

            // 

            // ribbonControl

            // 

            this.ribbonControl.ExpandCollapseItem.Id = 0;

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

            this.ribbonControl.ExpandCollapseItem});

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

            this.ribbonControl.MaxItemId = 1;

            this.ribbonControl.Name = "ribbonControl";

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

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

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

            this.ribbonControl.ShowToolbarCustomizeItem = false;

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

            this.ribbonControl.Toolbar.ShowCustomizeItem = false;

            // 

            // layoutControl1

            // 

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

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

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

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

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

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

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

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

            this.layoutControl1.Name = "layoutControl1";

            this.layoutControl1.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(982, 292, 650, 400);

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.Size = new System.Drawing.Size(1226, 561);

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            // btnRun

            // 

            this.btnRun.ImageOptions.SvgImage = global::Converter.SPPID.Properties.Resources.next;

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

            this.btnRun.Name = "btnRun";

            this.btnRun.Size = new System.Drawing.Size(79, 36);

            this.btnRun.StyleController = this.layoutControl1;

            this.btnRun.TabIndex = 9;

            this.btnRun.Text = "  Run  ";

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

            // 

            // btnLoadFile

            // 

            this.btnLoadFile.ImageOptions.SvgImage = global::Converter.SPPID.Properties.Resources.open2;

            this.btnLoadFile.Location = new System.Drawing.Point(24, 58);

            this.btnLoadFile.Name = "btnLoadFile";

            this.btnLoadFile.Size = new System.Drawing.Size(110, 36);

            this.btnLoadFile.StyleController = this.layoutControl1;

            this.btnLoadFile.TabIndex = 8;

            this.btnLoadFile.Text = "  Load Files  ";

            this.btnLoadFile.Click += new System.EventHandler(this.btnLoadFile_Click);

            // 

            // btnItemMapping

            // 

            this.btnItemMapping.ImageOptions.SvgImage = global::Converter.SPPID.Properties.Resources.properties;

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

            this.btnItemMapping.Name = "btnItemMapping";

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

            this.btnItemMapping.StyleController = this.layoutControl1;

            this.btnItemMapping.TabIndex = 7;

            this.btnItemMapping.Text = "Item Mapping Setting";

            this.btnItemMapping.Click += new System.EventHandler(this.btnItemMapping_Click);

            // 

            // btnSPPIDDB

            // 

            this.btnSPPIDDB.ImageOptions.SvgImage = global::Converter.SPPID.Properties.Resources.properties;

            this.btnSPPIDDB.Location = new System.Drawing.Point(966, 176);

            this.btnSPPIDDB.Name = "btnSPPIDDB";

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

            this.btnSPPIDDB.StyleController = this.layoutControl1;

            this.btnSPPIDDB.TabIndex = 5;

            this.btnSPPIDDB.Text = "Setting";

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

            // 

            // gridControlConverter

            // 

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

            this.gridControlConverter.MainView = this.gridViewConverter;

            this.gridControlConverter.MenuManager = this.ribbonControl;

            this.gridControlConverter.Name = "gridControlConverter";

            this.gridControlConverter.Size = new System.Drawing.Size(904, 439);

            this.gridControlConverter.TabIndex = 4;

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

            this.gridViewConverter});

            // 

            // gridViewConverter

            // 

            this.gridViewConverter.GridControl = this.gridControlConverter;

            this.gridViewConverter.Name = "gridViewConverter";

            this.gridViewConverter.OptionsView.ShowGroupPanel = false;

            this.gridViewConverter.RowCellClick += new DevExpress.XtraGrid.Views.Grid.RowCellClickEventHandler(this.gridViewConverter_RowCellClick);

            // 

            // btnID2Project

            // 

            this.btnID2Project.Location = new System.Drawing.Point(1004, 58);

            this.btnID2Project.MenuManager = this.ribbonControl;

            this.btnID2Project.Name = "btnID2Project";

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

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

            this.btnID2Project.Properties.ReadOnly = true;

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

            this.btnID2Project.StyleController = this.layoutControl1;

            this.btnID2Project.TabIndex = 10;

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

            // 

            // Root

            // 

            this.Root.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;

            this.Root.GroupBordersVisible = false;

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

            this.layoutControlGroupSPPIDDB,

            this.layoutControlGroupItemMapping,

            this.layoutControlGroupAutoConverter,

            this.emptySpaceItem1,

            this.layoutControlGroupID2Project,

            this.splitterItem1});

            this.Root.Name = "Root";

            this.Root.Size = new System.Drawing.Size(1226, 561);

            this.Root.TextVisible = false;

            // 

            // layoutControlGroupSPPIDDB

            // 

            this.layoutControlGroupSPPIDDB.CaptionImageOptions.SvgImage = global::Converter.SPPID.Properties.Resources.actions_database;

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

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

            this.labelSPPIDPlantName,

            this.labelSPPIDDBStatus,

            this.layoutControlItem2,

            this.simpleLabelItem2,

            this.simpleLabelItem1});

            this.layoutControlGroupSPPIDDB.Location = new System.Drawing.Point(942, 118);

            this.layoutControlGroupSPPIDDB.Name = "layoutControlGroupSPPIDDB";

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

            this.layoutControlGroupSPPIDDB.Text = "SPPID DB";

            // 

            // labelSPPIDPlantName

            // 

            this.labelSPPIDPlantName.AllowHotTrack = false;

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

            this.labelSPPIDPlantName.Location = new System.Drawing.Point(78, 40);

            this.labelSPPIDPlantName.Name = "labelSPPIDPlantName";

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

            this.labelSPPIDPlantName.Text = "SPPIDPlantName";

            this.labelSPPIDPlantName.TextSize = new System.Drawing.Size(93, 14);

            // 

            // labelSPPIDDBStatus

            // 

            this.labelSPPIDDBStatus.AllowHotTrack = false;

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

            this.labelSPPIDDBStatus.Location = new System.Drawing.Point(51, 58);

            this.labelSPPIDDBStatus.Name = "labelSPPIDDBStatus";

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

            this.labelSPPIDDBStatus.Text = "SPPIDDBStatus";

            this.labelSPPIDDBStatus.TextSize = new System.Drawing.Size(93, 14);

            // 

            // layoutControlItem2

            // 

            this.layoutControlItem2.Control = this.btnSPPIDDB;

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

            this.layoutControlItem2.Name = "layoutControlItem2";

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

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

            this.layoutControlItem2.TextVisible = false;

            // 

            // simpleLabelItem2

            // 

            this.simpleLabelItem2.AllowHotTrack = false;

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

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

            this.simpleLabelItem2.MaxSize = new System.Drawing.Size(51, 18);

            this.simpleLabelItem2.MinSize = new System.Drawing.Size(51, 18);

            this.simpleLabelItem2.Name = "simpleLabelItem2";

            this.simpleLabelItem2.Size = new System.Drawing.Size(51, 18);

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

            this.simpleLabelItem2.Text = "Status : ";

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

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

            // 

            // simpleLabelItem1

            // 

            this.simpleLabelItem1.AllowHotTrack = false;

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

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

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

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

            this.simpleLabelItem1.Name = "simpleLabelItem1";

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

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

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

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

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

            // 

            // layoutControlGroupItemMapping

            // 

            this.layoutControlGroupItemMapping.CaptionImageOptions.SvgImage = global::Converter.SPPID.Properties.Resources.arrangegroups;

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

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

            this.layoutControlItem4,

            this.labelItemMappingStatus,

            this.simpleLabelItem5});

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

            this.layoutControlGroupItemMapping.Name = "layoutControlGroupItemMapping";

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

            this.layoutControlGroupItemMapping.Text = "Item Mapping";

            // 

            // layoutControlItem4

            // 

            this.layoutControlItem4.Control = this.btnItemMapping;

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

            this.layoutControlItem4.Name = "layoutControlItem4";

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

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

            this.layoutControlItem4.TextVisible = false;

            // 

            // labelItemMappingStatus

            // 

            this.labelItemMappingStatus.AllowHotTrack = false;

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

            this.labelItemMappingStatus.Location = new System.Drawing.Point(51, 40);

            this.labelItemMappingStatus.Name = "labelItemMappingStatus";

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

            this.labelItemMappingStatus.Text = "MappingStatus";

            this.labelItemMappingStatus.TextSize = new System.Drawing.Size(93, 14);

            // 

            // simpleLabelItem5

            // 

            this.simpleLabelItem5.AllowHotTrack = false;

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

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

            this.simpleLabelItem5.MaxSize = new System.Drawing.Size(51, 18);

            this.simpleLabelItem5.MinSize = new System.Drawing.Size(51, 18);

            this.simpleLabelItem5.Name = "simpleLabelItem5";

            this.simpleLabelItem5.Size = new System.Drawing.Size(51, 18);

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

            this.simpleLabelItem5.Text = "Status : ";

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

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

            // 

            // layoutControlGroupAutoConverter

            // 

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

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

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

            this.layoutControlItem1,

            this.layoutControlItem5,

            this.emptySpaceItem2,

            this.layoutControlItem6});

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

            this.layoutControlGroupAutoConverter.Name = "layoutControlGroupAutoConverter";

            this.layoutControlGroupAutoConverter.Size = new System.Drawing.Size(932, 541);

            this.layoutControlGroupAutoConverter.Text = "Auto Converter";

            // 

            // layoutControlItem1

            // 

            this.layoutControlItem1.Control = this.gridControlConverter;

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

            this.layoutControlItem1.Name = "layoutControlItem1";

            this.layoutControlItem1.Size = new System.Drawing.Size(908, 443);

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

            this.layoutControlItem1.TextVisible = false;

            // 

            // layoutControlItem5

            // 

            this.layoutControlItem5.Control = this.btnLoadFile;

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

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

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

            this.layoutControlItem5.Name = "layoutControlItem5";

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

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

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

            this.layoutControlItem5.TextVisible = false;

            // 

            // emptySpaceItem2

            // 

            this.emptySpaceItem2.AllowHotTrack = false;

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

            this.emptySpaceItem2.Name = "emptySpaceItem2";

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

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

            // 

            // layoutControlItem6

            // 

            this.layoutControlItem6.Control = this.btnRun;

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

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

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

            this.layoutControlItem6.Name = "layoutControlItem6";

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

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

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

            this.layoutControlItem6.TextVisible = false;

            // 

            // emptySpaceItem1

            // 

            this.emptySpaceItem1.AllowHotTrack = false;

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

            this.emptySpaceItem1.Name = "emptySpaceItem1";

            this.emptySpaceItem1.Size = new System.Drawing.Size(264, 173);

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

            // 

            // layoutControlGroupID2Project

            // 

            this.layoutControlGroupID2Project.CaptionImageOptions.SvgImage = global::Converter.SPPID.Properties.Resources.actions_image;

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

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

            this.labelID2ProjectName,

            this.labelID2ProjectStatus,

            this.layoutControlItem7,

            this.simpleLabelItem3,

            this.simpleLabelItem4});

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

            this.layoutControlGroupID2Project.Name = "layoutControlGroupID2Project";

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

            this.layoutControlGroupID2Project.Text = "ID2 Project";

            // 

            // labelID2ProjectName

            // 

            this.labelID2ProjectName.AllowHotTrack = false;

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

            this.labelID2ProjectName.Location = new System.Drawing.Point(90, 24);

            this.labelID2ProjectName.Name = "labelID2ProjectName";

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

            this.labelID2ProjectName.Text = "ID2ProjectName";

            this.labelID2ProjectName.TextSize = new System.Drawing.Size(93, 14);

            // 

            // labelID2ProjectStatus

            // 

            this.labelID2ProjectStatus.AllowHotTrack = false;

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

            this.labelID2ProjectStatus.Location = new System.Drawing.Point(51, 42);

            this.labelID2ProjectStatus.Name = "labelID2ProjectStatus";

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

            this.labelID2ProjectStatus.Text = "ID2ProjectStatus";

            this.labelID2ProjectStatus.TextSize = new System.Drawing.Size(93, 14);

            // 

            // layoutControlItem7

            // 

            this.layoutControlItem7.Control = this.btnID2Project;

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

            this.layoutControlItem7.Name = "layoutControlItem7";

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

            this.layoutControlItem7.Text = "Path :";

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

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

            this.layoutControlItem7.TextToControlDistance = 5;

            // 

            // simpleLabelItem3

            // 

            this.simpleLabelItem3.AllowHotTrack = false;

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

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

            this.simpleLabelItem3.MaxSize = new System.Drawing.Size(90, 18);

            this.simpleLabelItem3.MinSize = new System.Drawing.Size(90, 18);

            this.simpleLabelItem3.Name = "simpleLabelItem3";

            this.simpleLabelItem3.Size = new System.Drawing.Size(90, 18);

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

            this.simpleLabelItem3.Text = "Project Name : ";

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

            this.simpleLabelItem3.TextSize = new System.Drawing.Size(86, 14);

            // 

            // simpleLabelItem4

            // 

            this.simpleLabelItem4.AllowHotTrack = false;

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

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

            this.simpleLabelItem4.MaxSize = new System.Drawing.Size(51, 18);

            this.simpleLabelItem4.MinSize = new System.Drawing.Size(51, 18);

            this.simpleLabelItem4.Name = "simpleLabelItem4";

            this.simpleLabelItem4.Size = new System.Drawing.Size(51, 18);

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

            this.simpleLabelItem4.Text = "Status : ";

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

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

            // 

            // splitterItem1

            // 

            this.splitterItem1.AllowHotTrack = true;

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

            this.splitterItem1.Name = "splitterItem1";

            this.splitterItem1.Size = new System.Drawing.Size(10, 541);

            // 

            // xtraFolderBrowserDialog

            // 

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

            this.xtraFolderBrowserDialog.SelectedPath = "xtraFolderBrowserDialog1";

            // 

            // xtraOpenFileDialog

            // 

            this.xtraOpenFileDialog.FileName = "xtraOpenFileDialog1";

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

            this.xtraOpenFileDialog.Multiselect = true;

            // 

            // ConverterForm

            // 

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

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

            this.ClientSize = new System.Drawing.Size(1226, 593);

            this.Controls.Add(this.layoutControl1);

            this.Controls.Add(this.ribbonControl);

            this.Name = "ConverterForm";

            this.Ribbon = this.ribbonControl;

            this.ShowIcon = false;

            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;

            this.Text = "SPPID Converter";

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

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

            this.layoutControl1.ResumeLayout(false);

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.ResumeLayout(false);

            this.PerformLayout();

        }

        #endregion

        private DevExpress.LookAndFeel.DefaultLookAndFeel defaultLookAndFeel;

        private DevExpress.XtraBars.Ribbon.RibbonControl ribbonControl;

        private DevExpress.XtraLayout.LayoutControl layoutControl1;

        private DevExpress.XtraEditors.SimpleButton btnSPPIDDB;

        private DevExpress.XtraGrid.GridControl gridControlConverter;

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

        private DevExpress.XtraLayout.LayoutControlGroup Root;

        private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroupAutoConverter;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem1;

        private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroupSPPIDDB;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem2;

        private DevExpress.XtraEditors.SimpleButton btnItemMapping;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem4;

        private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroupID2Project;

        private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroupItemMapping;

        private DevExpress.XtraLayout.EmptySpaceItem emptySpaceItem1;

        private DevExpress.XtraEditors.SimpleButton btnRun;

        private DevExpress.XtraEditors.SimpleButton btnLoadFile;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem5;

        private DevExpress.XtraLayout.EmptySpaceItem emptySpaceItem2;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem6;

        private DevExpress.XtraLayout.SimpleLabelItem labelSPPIDPlantName;

        private DevExpress.XtraLayout.SimpleLabelItem labelSPPIDDBStatus;

        private DevExpress.XtraLayout.SimpleLabelItem labelID2ProjectName;

        private DevExpress.XtraLayout.SimpleLabelItem labelID2ProjectStatus;

        private DevExpress.XtraLayout.SimpleLabelItem labelItemMappingStatus;

        private DevExpress.XtraLayout.SimpleLabelItem simpleLabelItem1;

        private DevExpress.XtraLayout.SimpleLabelItem simpleLabelItem2;

        private DevExpress.XtraLayout.SimpleLabelItem simpleLabelItem3;

        private DevExpress.XtraLayout.SimpleLabelItem simpleLabelItem4;

        private DevExpress.XtraLayout.SimpleLabelItem simpleLabelItem5;

        private DevExpress.XtraLayout.SplitterItem splitterItem1;

        private DevExpress.XtraEditors.ButtonEdit btnID2Project;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem7;

        private DevExpress.XtraEditors.XtraFolderBrowserDialog xtraFolderBrowserDialog;

        private DevExpress.XtraEditors.XtraOpenFileDialog xtraOpenFileDialog;

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using Microsoft.VisualBasic;

using Converter.BaseModel;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraEditors.Controls;

using DevExpress.XtraEditors;

using System.Globalization;

using System.Threading;

using System.IO;

using Converter.SPPID.Properties;

using Converter.SPPID.DB;

using Converter.SPPID.Util;

using Converter.SPPID.Form;

using Converter.SPPID.Model;

namespace Converter.SPPID

{

    public partial class ConverterForm : DevExpress.XtraBars.Ribbon.RibbonForm

    {

        private Dictionary<string, SPPID_Document> _DicDocuments = new Dictionary<string, SPPID_Document>();

        public List< SPPID_Document> Documents { get { return _DicDocuments.Select(x => x.Value).ToList(); } }

        private DataTable _ConverterDT = new DataTable();

        private DataTable _SPPIDSymbolPathDT = new DataTable();

        private DataTable _SPPIDUnitDT = new DataTable();

        private RepositoryItemComboBox templateComboBox;

        private DataTable _ID2SymbolDT = new DataTable();

        private DataTable _ID2LineDT = new DataTable();

        private DataTable _ID2AssociationDT = new DataTable();

        private DataTable _ID2LinePropertyDT = new DataTable();

        private List<SymbolMapping> symbolMappings = new List<SymbolMapping>();

        private List<LineMapping> lineMappings = new List<LineMapping>();

        private List<LineNumberMapping> lineNumberMappings = new List<LineNumberMapping>();

        private List<AssociationMapping> associationMappings = new List<AssociationMapping>();

        public ConverterForm()

        {

            InitializeComponent();

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

            Msg.Culture = culture;

            InitUsedDataTable();

            InitGridControl();

            InitID2Project();

        }

        private void InitUsedDataTable()

        {

            // Converter Table

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

            col.Caption = "Drawing File Name";

            col = _ConverterDT.Columns.Add("colDrawingFilePath");

            col.Caption = "DrawingFilePath";

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

            col.Caption = "Unit";

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

            col.Caption = "Template";

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

            col.Caption = "Drawing Number";

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

            col.Caption = "Drawing Name";

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

            col.Caption = "Status";

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

            col = _ID2LineDT.Columns.Add("UID");

            col = _ID2LineDT.Columns.Add("Name");

            col.Caption = "Name";

            col = _ID2LineDT.Columns.Add("Type");

            col.Caption = "Type";

            col = _ID2LineDT.Columns.Add("SPPID_SYMBOL_PATH");

            col.Caption = "SPPID Symbol Path";

            col = _ID2LineDT.Columns.Add("Clear");

            col.Caption = "";

        }

        private void InitGridControl()

        {

            #region Converter Page

            gridViewConverter.OptionsSelection.MultiSelect = true;

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

            gridControlConverter.DataSource = _ConverterDT;

            templateComboBox = new RepositoryItemComboBox();

            templateComboBox.TextEditStyle = TextEditStyles.DisableTextEditor;

            templateComboBox.EditValueChanged += templateComboBox_EditValueChanged;

            gridControlConverter.RepositoryItems.Add(templateComboBox);

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

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

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

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

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

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

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

            gridViewConverter.BestFitColumns();

            #endregion

        }

        private void templateComboBox_EditValueChanged(object sender, EventArgs e)

        {

            gridViewConverter.CloseEditor();

            gridViewConverter.UpdateCurrentRow();

        }

        private void gridViewConverter_RowCellClick(object sender, DevExpress.XtraGrid.Views.Grid.RowCellClickEventArgs e)

        {

            if (e.Column.Name == "colcolTemplate")

            {

                gridViewConverter.ShowEditor();

                (gridViewConverter.ActiveEditor as ComboBoxEdit).ShowPopup();

            }

            else if (e.Column.Name == "colcolUnit")

            {

                UnitForm unitForm = new UnitForm(_SPPIDUnitDT);

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

                {

                    gridViewConverter.SetRowCellValue(e.RowHandle, e.Column, unitForm.SelectedUnit);

                    gridViewConverter.CloseEditor();

                    gridViewConverter.UpdateCurrentRow();

                }

            }

        }

        private void btnID2Project_ButtonClick(object sender, ButtonPressedEventArgs e)

        {

            xtraFolderBrowserDialog.SelectedPath = btnID2Project.Text;

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

            {

                if (xtraFolderBrowserDialog.SelectedPath[xtraFolderBrowserDialog.SelectedPath.Length - 1] == '\\')

                    xtraFolderBrowserDialog.SelectedPath = xtraFolderBrowserDialog.SelectedPath.Remove(xtraFolderBrowserDialog.SelectedPath.Length - 1);

                Settings.Default.LatestProjectPath = xtraFolderBrowserDialog.SelectedPath;

                Settings.Default.Save();

                if (InitID2Project())

                {

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

                }

                else

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

            }

        }

        private bool InitID2Project()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            _ProjectInfo.DefaultPath = Settings.Default.LatestProjectPath;

            if (Project_DB.ConnTestAndCreateTable())

            {

                _ProjectInfo.Enable = true;

                btnID2Project.Text = _ProjectInfo.DefaultPath;

                labelID2ProjectName.Text = _ProjectInfo.Name;

                labelID2ProjectName.AppearanceItemCaption.ForeColor = Color.Blue;

                labelID2ProjectStatus.Text = Msg.ConnectionSuccessful;

                labelID2ProjectStatus.AppearanceItemCaption.ForeColor = Color.Blue;

                layoutControlGroupSPPIDDB.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;

                layoutControlGroupItemMapping.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;

            }

            else

            {

                _ProjectInfo.Enable = false;

                btnID2Project.Text = "";

                labelID2ProjectName.Text = " ";

                labelID2ProjectName.AppearanceItemCaption.ForeColor = Color.Red;

                labelID2ProjectStatus.Text = Msg.ConnectionFail;

                labelID2ProjectStatus.AppearanceItemCaption.ForeColor = Color.Red;

                layoutControlGroupSPPIDDB.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

                layoutControlGroupItemMapping.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

            }

            InitMapping();

            InitSPPIDDB();

            return _ProjectInfo.Enable;

        }

        private void InitMapping()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                InitID2Symbol();

                InitID2Line();

                InitID2LineNumber();

                InitID2Association();

                InitETCSetting();

            }

        }

        private void InitETCSetting()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                DataTable dt = Project_DB.SelectETCSetting();

                if (dt.Columns.Count > 0 && dt.Rows.Count > 0)

                    SPPIDUtil.ConvertToETCSetting(dt.Rows[0][0].ToString());

                else

                    SPPID_DBInfo.Clear();

            }

        }

        private void InitID2Symbol()

        {

            using (DataTable symbolDT = Project_DB.SelectProjectSymbol())

            {

                symbolMappings.Clear();

                _ID2SymbolDT = symbolDT;

                _ID2SymbolDT.Columns.Add("Clear");

                _ID2SymbolDT.Columns["Clear"].Caption = "";

                foreach (DataRow row in symbolDT.Rows)

                {

                    symbolMappings.Add(new SymbolMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        SYMBOLNAME = row["Name"] == null ? "" : row["Name"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),

                    });

                }

            }

        }

        private void InitID2Line()

        {

            using (DataTable lineTypes = Project_DB.SelectProjectLine())

            {

                lineMappings.Clear();

                _ID2LineDT.Rows.Clear();

                foreach (DataRow row in lineTypes.Rows)

                {

                    DataRow newRow = _ID2LineDT.NewRow();

                    newRow["UID"] = row["UID"] == null ? "" : row["UID"].ToString();

                    newRow["Name"] = row["Name"] == null ? "" : row["Name"].ToString();

                    newRow["Type"] = "Line";

                    newRow["SPPID_SYMBOL_PATH"] = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString();

                    _ID2LineDT.Rows.Add(newRow);

                    lineMappings.Add(new LineMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        LINENAME = row["Name"] == null ? "" : row["Name"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString(),

                    });

                }

            }

        }

        private void InitID2LineNumber()

        {

            using (DataTable linePropertiesDT = Project_DB.SelectProjectLineProperties())

            {

                lineNumberMappings.Clear();

                _ID2LinePropertyDT = linePropertiesDT;

                _ID2LinePropertyDT.Columns.Add("Type");

                foreach (DataRow row in linePropertiesDT.Rows)

                {

                    row["Type"] = "Line Property";

                    lineNumberMappings.Add(new LineNumberMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        DisplayName = row["DisplayName"] == null ? "" : row["DisplayName"].ToString(),

                        SPPIDATTRIBUTENAME = row["SPPID_ATTRIBUTE"] == null ? "" : row["SPPID_ATTRIBUTE"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString()

                    });

                }

            }

        }

        private void InitID2Association()

        {

            using (DataTable associationDT = Project_DB.SelectProjectAssociation())

            {

                associationMappings.Clear();

                _ID2AssociationDT = associationDT;

                _ID2AssociationDT.Columns.Add("Clear");

                _ID2AssociationDT.Columns["Clear"].Caption = "";

                foreach (DataRow row in associationDT.Rows)

                {

                    associationMappings.Add(new AssociationMapping()

                    {

                        UID = row["UID"] == null ? "" : row["UID"].ToString(),

                        DisplayAttribute = row["DisplayAttribute"] == null ? "" : row["DisplayAttribute"].ToString(),

                        Type = row["Type"] == null ? "" : row["Type"].ToString(),

                        SPPIDATTRIBUTENAME = row["SPPID_ATTRIBUTE"] == null ? "" : row["SPPID_ATTRIBUTE"].ToString(),

                        SPPIDSYMBOLNAME = row["SPPID_SYMBOL_PATH"] == null ? "" : row["SPPID_SYMBOL_PATH"].ToString()

                    });

                }

            }

        }

        private void InitSPPIDDB()

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (_ProjectInfo.Enable)

            {

                DataTable dt = Project_DB.SelectSPPID_DB_INFO();

                if (dt.Columns.Count > 0 && dt.Rows.Count > 0)

                    SPPIDUtil.ConvertToSPPIDInfo(dt.Rows[0][0].ToString());

                else

                    SPPID_DBInfo.Clear();

            }

            templateComboBox.Items.Clear();

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            if (_SPPIDInfo.Enable)

            {

                labelSPPIDPlantName.Text = _SPPIDInfo.SelectedPlant;

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Blue;

                labelSPPIDDBStatus.Text = Msg.ConnectionSuccessful;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Blue;

                string TemplatePath = SPPID_DB.GetPlantPID_T_OPTIONSETTING_Value("PID Template Path");

                if (!string.IsNullOrEmpty(TemplatePath))

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

                _SPPIDUnitDT = SPPID_DB.GetUnitTree();

                layoutControlGroupAutoConverter.Enabled = true;

            }

            else

            {

                labelSPPIDPlantName.Text = " ";

                labelSPPIDPlantName.AppearanceItemCaption.ForeColor = Color.Red;

                labelSPPIDDBStatus.Text = Msg.ConnectionFail;

                labelSPPIDDBStatus.AppearanceItemCaption.ForeColor = Color.Red;

                layoutControlGroupAutoConverter.Enabled = false;

            }

            _DicDocuments.Clear();

            _ConverterDT.Rows.Clear();

            InitSPPIDSymbolTreeTable();

        }

        private void InitSPPIDSymbolTreeTable()

        {

            SPPID_DBInfo _SPPIDInfo = SPPID_DBInfo.GetInstance();

            _SPPIDSymbolPathDT = new DataTable();

            _SPPIDSymbolPathDT.Columns.Add("ID");

            _SPPIDSymbolPathDT.Columns.Add("Parent");

            _SPPIDSymbolPathDT.Columns.Add("Name");

            _SPPIDSymbolPathDT.Columns.Add("FullPath");

            if (_SPPIDInfo.Enable)

            {

                string symbolPath = SPPID_DB.GetPlantPID_T_OPTIONSETTING_Value("Catalog Explorer root path");

                DirectoryInfo info = new DirectoryInfo(symbolPath);

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

                loop(info, "0", symbolPath);

            }

        }

        private void loop(DirectoryInfo parentInfo, string parentUID, string defaultPath)

        {

            DirectoryInfo[] infos = parentInfo.GetDirectories();

            foreach (DirectoryInfo info in infos)

            {

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

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

                loop(info, uid, defaultPath);

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

                foreach (FileInfo fileInfo in files)

                {

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

                }

            }

        }

        private void btnLoadFile_Click(object sender, EventArgs e)

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (!_ProjectInfo.Enable)

            {

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

                return;

            }

            xtraOpenFileDialog.InitialDirectory = _ProjectInfo.TempDirPath;

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

            {

                foreach (string fileName in xtraOpenFileDialog.FileNames)

                {

                    SPPID_Document document = new SPPID_Document(fileName);

                    document.SymbolMappings = symbolMappings;

                    DataRow[] rows = _ConverterDT.Select(string.Format("colDrawingFilePath = '{0}'", fileName));

                    DataRow row;

                    if (rows.Length == 0)

                    {

                        row = _ConverterDT.NewRow();

                        row["colDrawingFileName"] = Path.GetFileNameWithoutExtension(fileName);

                        row["colDrawingFilePath"] = fileName;

                        row["colDrawingNumber"] = document.DWGNAME;

                        row["colDrawingName"] = document.DWGNAME;

                        if (document.Enable)

                            row["colStatus"] = "Ready";

                        else

                            row["colStatus"] = "Error";

                        row["colUID"] = "";

                        _ConverterDT.Rows.Add(row);

                    }

                    if (!_DicDocuments.ContainsKey(fileName))

                        _DicDocuments.Add(fileName, null);

                    _DicDocuments[fileName] = document;

                }

            }

        } 

        private void btnRun_Click(object sender, EventArgs e)

        {

            DialogResult = DialogResult.OK;

        }

        private void btnSPPIDDB_Click(object sender, EventArgs e)

        {

            SPPID_DB_SettingForm form = new SPPID_DB_SettingForm();

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

                InitSPPIDDB();

        }

        private void btnItemMapping_Click(object sender, EventArgs e)

        {

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            if (!_ProjectInfo.Enable)

            {

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

                return;

            }

            MappingForm form = new MappingForm(_ID2SymbolDT,_SPPIDSymbolPathDT, _ID2LineDT, _ID2LinePropertyDT, _ID2AssociationDT);

            form.ShowDialog();

            InitMapping();

        }

    }

}

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

<root>

  <!-- 

    Microsoft ResX Schema 

    Version 2.0

    The primary goals of this format is to allow a simple XML format 

    that is mostly human readable. The generation and parsing of the 

    various data types are done through the TypeConverter classes 

    associated with the data types.

    Example:

    ... ado.net/XML headers & schema ...

    <resheader name="resmimetype">text/microsoft-resx</resheader>

    <resheader name="version">2.0</resheader>

    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>

    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>

    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>

    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>

    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">

        <value>[base64 mime encoded serialized .NET Framework object]</value>

    </data>

    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>

        <comment>This is a comment</comment>

    </data>

    There are any number of "resheader" rows that contain simple 

    name/value pairs.

    Each data row contains a name, and value. The row also contains a 

    type or mimetype. Type corresponds to a .NET class that support 

    text/value conversion through the TypeConverter architecture. 

    Classes that don't support this are serialized and stored with the 

    mimetype set.

    The mimetype is used for serialized objects, and tells the 

    ResXResourceReader how to depersist the object. This is currently not 

    extensible. For a given mimetype the value must be set accordingly:

    Note - application/x-microsoft.net.object.binary.base64 is the format 

    that the ResXResourceWriter will generate, however the reader can 

    read any of the formats listed below.

    mimetype: application/x-microsoft.net.object.binary.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.soap.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64

    value   : The object must be serialized into a byte array 

            : using a System.ComponentModel.TypeConverter

            : and then encoded with base64 encoding.

    -->

  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />

    <xsd:element name="root" msdata:IsDataSet="true">

      <xsd:complexType>

        <xsd:choice maxOccurs="unbounded">

          <xsd:element name="metadata">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" />

              </xsd:sequence>

              <xsd:attribute name="name" use="required" type="xsd:string" />

              <xsd:attribute name="type" type="xsd:string" />

              <xsd:attribute name="mimetype" type="xsd:string" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="assembly">

            <xsd:complexType>

              <xsd:attribute name="alias" type="xsd:string" />

              <xsd:attribute name="name" type="xsd:string" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="data">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />

              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />

              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="resheader">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" />

            </xsd:complexType>

          </xsd:element>

        </xsd:choice>

      </xsd:complexType>

    </xsd:element>

  </xsd:schema>

  <resheader name="resmimetype">

    <value>text/microsoft-resx</value>

  </resheader>

  <resheader name="version">

    <value>2.0</value>

  </resheader>

  <resheader name="reader">

    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <resheader name="writer">

    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

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

    <value>17, 17</value>

  </metadata>

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

    <value>179, 17</value>

  </metadata>

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

    <value>367, 17</value>

  </metadata>

</root>

using System;

using System.Collections.Generic;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Data;

using System.Globalization;

using System.IO;

using Oracle.ManagedDataAccess.Client;

namespace Converter.SPPID.DB

{

    public class SPPID_DB

    {

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

        public static bool CheckAndSetSPPIDInfo(SPPID_DBInfo dbInfo)

        {

            bool bResult = false;

            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(SPPID_DBInfo dbInfo)

        {

            bool bResult = false;

            try

            {

                if (dbInfo.DBType == "ORACLE")

                {

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

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

                    using (OracleConnection conn = new OracleConnection(connString))

                    {

                        conn.Open();

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

                        {

                            using (OracleCommand cmd = new OracleCommand())

                            {

                                cmd.Connection = conn;

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

                                                FROM {0}.T_DB_DATA DB_DATA 

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

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

                                using (OracleDataAdapter adapter = new OracleDataAdapter())

                                {

                                    DataTable dt = new DataTable();

                                    adapter.SelectCommand = cmd;

                                    adapter.Fill(dt);

                                    foreach (DataRow row in dt.Rows)

                                    {

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

                                        switch (sType)

                                        {

                                            case "SPPIDDATA_DICTIONARY":

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

                                                break;

                                            case "DATA_DICTIONARY":

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

                                                break;

                                            case "SPAPLANT":

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

                                                break;

                                            case "SPPID":

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

                                                break;

                                            default:

                                                break;

                                        }

                                        bResult = true;

                                    }

                                }

                            }

                        }

                    }

                }

                else

                {

                }

            }

            catch (Exception ex)

            {

            }

            return bResult;

        }

        public static List<string> GetPlantList(SPPID_DBInfo dbInfo)

        {

            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

            {

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

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