HYTOS

                    using (SQLiteCommand cmd = connection.CreateCommand())

                    {

                        cmd.CommandText = string.Format(@"

                            FROM {1} as sa, {0} as st 

                                 LEFT OUTER JOIN {2} as sp 

                                      ON sa.UID = SP.UID 

                                     ON sa.UID = spa.UID

                                LEFT OUTER JOIN {4} as spl 

                                     ON sa.UID = spl.UID

                        using (SQLiteDataReader dr = cmd.ExecuteReader())

                            dt.Load(dr);

                    }

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

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

            this.tabbedControlGroup = new DevExpress.XtraLayout.TabbedControlGroup();

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

            this.ribbonControl.ShowToolbarCustomizeItem = false;

            this.ribbonControl.Toolbar.ShowCustomizeItem = false;

            // 

            // layoutControl1

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

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

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

            this.layoutControl1.Name = "layoutControl1";

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.TabIndex = 2;

            this.layoutControl1.Text = "layoutControl1";

            // 

            // checkComboBoxLineNumberLocation

            // 

            this.checkComboBoxLineNumberLocation.MenuManager = this.ribbonControl;

            this.checkComboBoxLineNumberLocation.Name = "checkComboBoxLineNumberLocation";

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

            // 

            // checkComboBoxNoteLocation

            // 

            this.checkComboBoxNoteLocation.MenuManager = this.ribbonControl;

            this.checkComboBoxNoteLocation.Name = "checkComboBoxNoteLocation";

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

            // 

            // checkComboBoxTextLocation

            // 

            this.checkComboBoxTextLocation.MenuManager = this.ribbonControl;

            this.checkComboBoxTextLocation.Name = "checkComboBoxTextLocation";

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

            // btnImageRefresh

            // 

            this.btnImageRefresh.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnImageRefresh.ImageOptions.SvgImage")));

            this.btnImageRefresh.Name = "btnImageRefresh";

            this.btnImageRefresh.StyleController = this.layoutControl1;

            this.btnImageRefresh.TabIndex = 27;

            this.btnImageRefresh.Text = "Refresh SPPID Image";

            // 

            // textBoxDrainValveSize

            // 

            this.textBoxDrainValveSize.MenuManager = this.ribbonControl;

            this.textBoxDrainValveSize.Name = "textBoxDrainValveSize";

            this.textBoxDrainValveSize.Size = new System.Drawing.Size(524, 20);

            // 

            // textBoxNoteSymbolPath

            // 

            this.textBoxNoteSymbolPath.MenuManager = this.ribbonControl;

            this.textBoxNoteSymbolPath.Name = "textBoxNoteSymbolPath";

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

            // 

            // textBoxTextSymbolPath

            // 

            this.textBoxTextSymbolPath.MenuManager = this.ribbonControl;

            this.textBoxTextSymbolPath.Name = "textBoxTextSymbolPath";

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

            // 

            // textBoxLineNumberPath

            // 

            this.textBoxLineNumberPath.MenuManager = this.ribbonControl;

            this.textBoxLineNumberPath.Name = "textBoxLineNumberPath";

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

            // 

            // gridControlLineNumber

            // 

            this.gridControlLineNumber.MainView = this.gridViewLineNumber;

            this.gridControlLineNumber.MenuManager = this.ribbonControl;

            this.gridControlLineNumber.Name = "gridControlLineNumber";

            this.gridControlLineNumber.TabIndex = 21;

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

            this.gridViewLineNumber});

            // btnClose

            // 

            this.btnClose.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnClose.ImageOptions.SvgImage")));

            this.btnClose.Name = "btnClose";

            this.btnClose.Size = new System.Drawing.Size(86, 36);

            this.btnClose.StyleController = this.layoutControl1;

            // 

            // gridControlAttribute

            // 

            this.gridControlAttribute.MainView = this.gridViewAttribute;

            this.gridControlAttribute.MenuManager = this.ribbonControl;

            this.gridControlAttribute.Name = "gridControlAttribute";

            this.gridControlAttribute.TabIndex = 19;

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

            this.gridViewAttribute});

            // 

            // gridControlLine

            // 

            this.gridControlLine.MainView = this.gridViewLine;

            this.gridControlLine.MenuManager = this.ribbonControl;

            this.gridControlLine.Name = "gridControlLine";

            this.gridControlLine.TabIndex = 18;

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

            this.gridViewLine});

            // 

            // gridControlSymbol

            // 

            this.gridControlSymbol.MainView = this.gridViewSymbol;

            this.gridControlSymbol.MenuManager = this.ribbonControl;

            this.gridControlSymbol.Name = "gridControlSymbol";

            this.gridControlSymbol.TabIndex = 16;

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

            this.gridViewSymbol});

            // 

            // pictureEditSPPIDSymbol

            // 

            this.pictureEditSPPIDSymbol.MenuManager = this.ribbonControl;

            this.pictureEditSPPIDSymbol.Name = "pictureEditSPPIDSymbol";

            this.pictureEditSPPIDSymbol.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;

            this.pictureEditSPPIDSymbol.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;

            this.pictureEditSPPIDSymbol.StyleController = this.layoutControl1;

            this.pictureEditSPPIDSymbol.TabIndex = 15;

            // 

            // btnSave

            // 

            this.btnSave.ImageOptions.SvgImage = ((DevExpress.Utils.Svg.SvgImage)(resources.GetObject("btnSave.ImageOptions.SvgImage")));

            this.btnSave.Name = "btnSave";

            this.btnSave.Size = new System.Drawing.Size(84, 36);

            this.btnSave.StyleController = this.layoutControl1;

            // treeListSPPIDTreeList

            // 

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

            this.treeListSPPIDTreeList.Name = "treeListSPPIDTreeList";

            this.treeListSPPIDTreeList.TabIndex = 12;

            this.treeListSPPIDTreeList.FocusedNodeChanged += new DevExpress.XtraTreeList.FocusedNodeChangedEventHandler(this.treeListSPPIDTreeList_FocusedNodeChanged);

            this.treeListSPPIDTreeList.DoubleClick += new System.EventHandler(this.treeListSPPIDTreeList_DoubleClick);

            // 

            // pictureEditID2Symbol

            // 

            this.pictureEditID2Symbol.MenuManager = this.ribbonControl;

            this.pictureEditID2Symbol.Name = "pictureEditID2Symbol";

            this.pictureEditID2Symbol.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;

            this.pictureEditID2Symbol.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;

            this.pictureEditID2Symbol.StyleController = this.layoutControl1;

            this.pictureEditID2Symbol.TabIndex = 4;

            // 

            // pictureEditMapped

            // 

            this.pictureEditMapped.MenuManager = this.ribbonControl;

            this.pictureEditMapped.Name = "pictureEditMapped";

            this.pictureEditMapped.Properties.ShowCameraMenuItem = DevExpress.XtraEditors.Controls.CameraMenuItemVisibility.Auto;

            this.pictureEditMapped.Properties.SizeMode = DevExpress.XtraEditors.Controls.PictureSizeMode.Squeeze;

            this.pictureEditMapped.StyleController = this.layoutControl1;

            this.pictureEditMapped.TabIndex = 5;

            // 

            this.layoutControlItem4,

            this.emptySpaceItem1});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // layoutControlGroup2

            this.layoutControlGroup5,

            this.splitterItem5,

            this.layoutControlItem15});

            this.layoutControlGroup2.Name = "layoutControlGroup2";

            this.layoutControlGroup2.Text = "SPPID Symbol";

            // 

            // layoutControlItem8

            this.layoutControlItem8.Control = this.treeListSPPIDTreeList;

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

            this.layoutControlItem8.Name = "layoutControlItem8";

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

            this.layoutControlItem8.TextVisible = false;

            // 

            // 

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

            this.layoutControlItem9});

            this.layoutControlGroup5.Name = "layoutControlGroup5";

            this.layoutControlGroup5.Text = "SPPID Image";

            // 

            // layoutControlItem9

            this.layoutControlItem9.Control = this.pictureEditSPPIDSymbol;

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

            this.layoutControlItem9.Name = "layoutControlItem9";

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

            this.layoutControlItem9.TextVisible = false;

            // 

            // splitterItem5

            // 

            this.splitterItem5.AllowHotTrack = true;

            this.splitterItem5.Name = "splitterItem5";

            // 

            // layoutControlItem15

            // 

            this.layoutControlItem15.Control = this.btnImageRefresh;

            this.layoutControlItem15.Name = "layoutControlItem15";

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

            this.layoutControlItem15.TextVisible = false;

            // 

            // emptySpaceItem2

            // 

            this.emptySpaceItem2.AllowHotTrack = false;

            this.emptySpaceItem2.Name = "emptySpaceItem2";

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

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

            this.splitterItem3.AllowHotTrack = true;

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

            this.splitterItem3.Name = "splitterItem3";

            // 

            // tabbedControlGroup

            // 

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

            this.tabbedControlGroup.Name = "tabbedControlGroup";

            this.tabbedControlGroup.SelectedTabPage = this.GroupSymbol;

            this.tabbedControlGroup.TabPages.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {

            this.GroupSymbol,

            this.GroupLine,

            this.GroupAttribute,

            this.GroupETCSetting});

            // 

            // GroupSymbol

            // 

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

            this.layoutControlGroup1});

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

            this.GroupSymbol.Name = "GroupSymbol";

            this.GroupSymbol.Text = "Symbol";

            // 

            // splitterItem1

            // 

            this.splitterItem1.AllowHotTrack = true;

            this.splitterItem1.Name = "splitterItem1";

            // 

            // layoutControlGroup3

            // 

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

            this.layoutControlItem1});

            this.layoutControlGroup3.Name = "layoutControlGroup3";

            this.layoutControlGroup3.Text = "ID2 Image";

            // 

            // layoutControlItem1

            this.layoutControlItem1.Control = this.pictureEditID2Symbol;

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

            this.layoutControlItem1.Name = "layoutControlItem1";

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

            this.layoutControlItem1.TextVisible = false;

            // 

            // 

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

            this.layoutControlItem2});

            this.layoutControlGroup4.Name = "layoutControlGroup4";

            this.layoutControlGroup4.Text = "Mapped Image";

            // 

            // layoutControlItem2

            this.layoutControlItem2.Control = this.pictureEditMapped;

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

            this.layoutControlItem2.Name = "layoutControlItem2";

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

            this.layoutControlItem2.TextVisible = false;

            // 

            // splitterItem4

            // 

            this.splitterItem4.AllowHotTrack = true;

            this.splitterItem4.Name = "splitterItem4";

            // 

            // layoutControlGroup1

            // 

            this.layoutControlItem6});

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

            this.layoutControlGroup1.Name = "layoutControlGroup1";

            this.layoutControlGroup1.Text = "ID2 Symbol List";

            // 

            // layoutControlItem6

            this.layoutControlItem6.Control = this.gridControlSymbol;

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

            this.layoutControlItem6.Name = "layoutControlItem6";

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

            this.layoutControlItem6.TextVisible = false;

            // 

            this.layoutControlGroup6});

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

            this.GroupLine.Name = "GroupLine";

            this.GroupLine.Text = "Line";

            // 

            // layoutControlGroup6

            this.layoutControlItem10});

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

            this.layoutControlGroup6.Name = "layoutControlGroup6";

            this.layoutControlGroup6.Text = "ID2 Line List";

            // 

            // layoutControlItem10

            this.layoutControlItem10.Control = this.gridControlLine;

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

            this.layoutControlItem10.Name = "layoutControlItem10";

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

            this.layoutControlItem10.TextVisible = false;

            // 

            this.layoutControlGroup8});

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

            this.GroupLineNumber.Name = "GroupLineNumber";

            this.GroupLineNumber.Text = "Line Number";

            // 

            // layoutControlGroup8

            this.layoutControlItem18});

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

            this.layoutControlGroup8.Name = "layoutControlGroup8";

            this.layoutControlGroup8.Text = "ID2 Line Number";

            // 

            // layoutControlItem13

            this.layoutControlItem13.Control = this.gridControlLineNumber;

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

            this.layoutControlItem13.Name = "layoutControlItem13";

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

            this.layoutControlItem13.TextVisible = false;

            // 

            this.layoutControlItem18.TextSize = new System.Drawing.Size(78, 14);

            this.layoutControlItem18.TextToControlDistance = 5;

            // 

            // GroupETCSetting

            // 

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

            this.layoutControlGroup10});

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

            this.GroupETCSetting.Name = "GroupETCSetting";

            this.GroupETCSetting.Text = "ETC Setting";

            // 

            // emptySpaceItem3

            // 

            this.emptySpaceItem3.AllowHotTrack = false;

            this.emptySpaceItem3.Name = "emptySpaceItem3";

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

            // 

            // layoutControlGroup9

            this.layoutControlItem17});

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

            this.layoutControlGroup9.Name = "layoutControlGroup9";

            this.layoutControlGroup9.Text = "Text && Note Setting";

            // 

            // layoutControlItem5

            // 

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

            this.layoutControlItem14});

            this.layoutControlGroup10.Name = "layoutControlGroup10";

            this.layoutControlGroup10.Text = "Drain Valve Setting";

            // 

            // layoutControlItem14

            // layoutControlItem12

            // 

            this.layoutControlItem12.Control = this.btnClose;

            this.layoutControlItem12.MaxSize = new System.Drawing.Size(90, 40);

            this.layoutControlItem12.MinSize = new System.Drawing.Size(90, 40);

            this.layoutControlItem12.Name = "layoutControlItem12";

            // layoutControlItem4

            // 

            this.layoutControlItem4.Control = this.btnSave;

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

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

            this.layoutControlItem4.Name = "layoutControlItem4";

            // emptySpaceItem1

            // 

            this.emptySpaceItem1.AllowHotTrack = false;

            this.emptySpaceItem1.MaxSize = new System.Drawing.Size(15, 40);

            this.emptySpaceItem1.MinSize = new System.Drawing.Size(15, 40);

            this.emptySpaceItem1.Name = "emptySpaceItem1";

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

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

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

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

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

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

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

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

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

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

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

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

            gridControlLine.RepositoryItems.Add(clearButton);

            gridViewLine.ExpandAllGroups();

            gridControlAttribute.DataSource = attributeDT;

            gridViewAttribute.Columns["UID"].Visible = false;

            gridViewAttribute.Columns["DisplayAttribute"].Caption = "Attribute Name";

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

            gridViewAttribute.Columns["LOCATION"].Caption = "Label Location";

            gridViewAttribute.Columns["LEADERLINE"].Caption = "Show Leader Line";

            RepositoryItemCheckedComboBoxEdit checkedComboEdit = new RepositoryItemCheckedComboBoxEdit();

            foreach (DataRow item in attributeDT.Rows)

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

            Cursor = Cursors.Default;

        }

        private void btnClose_Click(object sender, EventArgs e)

        {

            DialogResult = DialogResult.Cancel;