HYTOS

            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.Name = "layoutControl1";

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

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            // btnID2DB

            // 

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

            this.btnID2DB.Name = "btnID2DB";

            this.btnID2DB.StyleController = this.layoutControl1;

            this.btnID2DB.TabIndex = 15;

            this.btnID2DB.Text = "Setting";

            // 

            // checkEditCloseDocument

            // 

            this.checkEditCloseDocument.MenuManager = this.ribbonControl;

            this.checkEditCloseDocument.Name = "checkEditCloseDocument";

            this.checkEditCloseDocument.Properties.Caption = "Close Document";

            // 

            // comboBoxEditDefaultTemplate

            // 

            this.comboBoxEditDefaultTemplate.MenuManager = this.ribbonControl;

            this.comboBoxEditDefaultTemplate.Name = "comboBoxEditDefaultTemplate";

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

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

            this.comboBoxEditDefaultTemplate.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            this.comboBoxEditDefaultTemplate.StyleController = this.layoutControl1;

            this.comboBoxEditDefaultTemplate.TabIndex = 12;

            this.comboBoxEditDefaultTemplate.SelectedIndexChanged += new System.EventHandler(this.comboBoxEditDefaultTemplate_SelectedIndexChanged);

            // 

            // buttonEditDefaultUnit

            // 

            this.buttonEditDefaultUnit.MenuManager = this.ribbonControl;

            this.buttonEditDefaultUnit.Name = "buttonEditDefaultUnit";

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

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

            this.buttonEditDefaultUnit.Properties.TextEditStyle = DevExpress.XtraEditors.Controls.TextEditStyles.DisableTextEditor;

            this.buttonEditDefaultUnit.StyleController = this.layoutControl1;

            this.buttonEditDefaultUnit.TabIndex = 11;

            this.buttonEditDefaultUnit.ButtonClick += new DevExpress.XtraEditors.Controls.ButtonPressedEventHandler(this.buttonEditDefaulUnit_ButtonClick);

            // btnRun

            // 

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

            this.btnRun.Name = "btnRun";

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

            this.btnRun.StyleController = this.layoutControl1;

            // btnItemMapping

            // 

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

            this.btnItemMapping.Name = "btnItemMapping";

            this.btnItemMapping.StyleController = this.layoutControl1;

            this.btnItemMapping.TabIndex = 7;

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

            // btnSPPIDDB

            // 

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

            this.btnSPPIDDB.Name = "btnSPPIDDB";

            this.btnSPPIDDB.StyleController = this.layoutControl1;

            this.btnSPPIDDB.TabIndex = 5;

            this.btnSPPIDDB.Text = "Setting";

            this.gridControlConverter.MainView = this.gridViewConverter;

            this.gridControlConverter.MenuManager = this.ribbonControl;

            this.gridControlConverter.Name = "gridControlConverter";

            this.gridControlConverter.TabIndex = 4;

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

            this.gridViewConverter});

            this.layoutControlGroupID2Project,

            this.splitterItem1});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // layoutControlGroupSPPIDDB

            this.layoutControlItem2,

            this.simpleLabelItem2,

            this.simpleLabelItem1});

            this.layoutControlGroupSPPIDDB.Name = "layoutControlGroupSPPIDDB";

            this.layoutControlGroupSPPIDDB.Text = "SPPID DB";

            // 

            // labelSPPIDPlantName

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

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

            this.labelSPPIDPlantName.Name = "labelSPPIDPlantName";

            this.labelSPPIDPlantName.Text = "SPPIDPlantName";

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

            // 

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

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

            this.labelSPPIDDBStatus.Name = "labelSPPIDDBStatus";

            this.labelSPPIDDBStatus.Text = "SPPIDDBStatus";

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

            // 

            this.layoutControlItem2.Control = this.btnSPPIDDB;

            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;

            // 

            this.layoutControlItem4,

            this.labelItemMappingStatus,

            this.simpleLabelItem5});

            this.layoutControlGroupItemMapping.Name = "layoutControlGroupItemMapping";

            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.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem4.TextVisible = false;

            // 

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

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

            this.labelItemMappingStatus.Name = "labelItemMappingStatus";

            this.labelItemMappingStatus.Text = "MappingStatus";

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

            // 

            this.emptySpaceItem5});

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

            this.layoutControlGroupAutoConverter.Name = "layoutControlGroupAutoConverter";

            this.layoutControlGroupAutoConverter.Text = "Auto Converter";

            // 

            // layoutControlItem1

            this.layoutControlItem1.Control = this.gridControlConverter;

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

            this.layoutControlItem1.Name = "layoutControlItem1";

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

            this.layoutControlItem1.TextVisible = false;

            // 

            this.emptySpaceItem2.AllowHotTrack = false;

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

            this.emptySpaceItem2.Name = "emptySpaceItem2";

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

            // 

            // layoutControlItem6

            // 

            this.layoutControlItem6.Control = this.btnRun;

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

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

            this.layoutControlItem6.Name = "layoutControlItem6";

            // layoutControlItem3

            // 

            this.layoutControlItem3.Control = this.buttonEditDefaultUnit;

            this.layoutControlItem3.Name = "layoutControlItem3";

            this.layoutControlItem3.Text = "Default Unit";

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

            this.layoutControlItem3.TextSize = new System.Drawing.Size(65, 14);

            // layoutControlItem8

            // 

            this.layoutControlItem8.Control = this.comboBoxEditDefaultTemplate;

            this.layoutControlItem8.Name = "layoutControlItem8";

            this.layoutControlItem8.Text = "Default Template";

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

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

            this.emptySpaceItem3.AllowHotTrack = false;

            this.emptySpaceItem3.Location = new System.Drawing.Point(236, 18);

            this.emptySpaceItem3.Name = "emptySpaceItem3";

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

            // 

            // layoutControlItem9

            // layoutControlItem10

            // 

            this.layoutControlItem10.Control = this.checkEditCloseDocument;

            this.layoutControlItem10.MaxSize = new System.Drawing.Size(115, 24);

            this.layoutControlItem10.MinSize = new System.Drawing.Size(115, 24);

            this.layoutControlItem10.Name = "layoutControlItem10";

            // emptySpaceItem5

            // 

            this.emptySpaceItem5.AllowHotTrack = false;

            this.emptySpaceItem5.Name = "emptySpaceItem5";

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

            // 

            // emptySpaceItem1

            // 

            this.emptySpaceItem1.AllowHotTrack = false;

            this.emptySpaceItem1.Name = "emptySpaceItem1";

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

            // 

            // layoutControlGroupID2Project

            this.layoutControlItem7,

            this.labelDBType,

            this.simpleLabelItem7});

            this.layoutControlGroupID2Project.Name = "layoutControlGroupID2Project";

            this.layoutControlGroupID2Project.Text = "ID2 Project";

            // 

            // labelID2ProjectName

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

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

            this.labelID2ProjectName.Name = "labelID2ProjectName";

            this.labelID2ProjectName.Text = "ID2ProjectName";

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

            // 

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

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

            this.labelID2ProjectStatus.Name = "labelID2ProjectStatus";

            this.labelID2ProjectStatus.Text = "ID2ProjectStatus";

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

            // 

            this.layoutControlItem7.Control = this.btnID2DB;

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

            this.layoutControlItem7.Name = "layoutControlItem7";

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

            this.layoutControlItem7.TextVisible = false;

            // 

            this.labelDBType.Location = new System.Drawing.Point(63, 58);

            this.labelDBType.MinSize = new System.Drawing.Size(97, 18);

            this.labelDBType.Name = "labelDBType";

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

            this.labelDBType.Text = "DB Type";

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

            // splitterItem1

            // 

            this.splitterItem1.AllowHotTrack = true;

            this.splitterItem1.Name = "splitterItem1";

            // 

            // xtraFolderBrowserDialog

            // 

            // 

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

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

            this.Controls.Add(this.layoutControl1);

            this.Controls.Add(this.ribbonControl);

            this.Name = "ConverterForm";

                                }

                                #region Check Column 업데이트시 예비용

                                #endregion

                            }

                            result = true;

                        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 

                            using (SqlCommand cmd = connection.CreateCommand())

                            {

                                cmd.CommandText = string.Format(@"

                            FROM {1} as sa

                                 LEFT OUTER JOIN {2} as sp 

                                      ON sa.UID = SP.UID 

            return dt;

        }

        private static DataTable SelectDrawingProjectAttribute2()

        {

            DataTable dt = new DataTable();

            return true;

        }

        {

            Project_Info projectInfo = Project_Info.GetInstance();

            if (projectInfo.DBType == ID2DB_Type.SQLite)

                                    foreach (var item in datas)

                                    {

                                        cmd.Parameters.Clear();

                                        cmd.Parameters.AddWithValue("@UID", item.Item1);

                                        cmd.Parameters.AddWithValue("@SPPID_ATTRIBUTE", item.Item2);

                                        cmd.ExecuteNonQuery();

                                    }

                                }

                                    cmd.Parameters.Clear();

                                    cmd.CommandText = string.Format(@"

                                    IF EXISTS (SELECT * FROM {0} WHERE UID = '{1}')

                                    ELSE

                                    cmd.Parameters.AddWithValue("@UID", item.Item1);

                                    if (string.IsNullOrEmpty(item.Item2))

                                        cmd.Parameters.AddWithValue("@SPPID_ATTRIBUTE", DBNull.Value);

                                    else

                                        cmd.Parameters.AddWithValue("@SPPID_ATTRIBUTE", item.Item2);

                                    cmd.ExecuteNonQuery();

                                }

                            }

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

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

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

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

            RepositoryItemCheckedComboBoxEdit checkedComboEdit = new RepositoryItemCheckedComboBoxEdit();

                if (DBNull.Value.Equals(item["LEADERLINE"]))

                    item["LEADERLINE"] = false;

            }

            SPPIDAttributeDT.Columns["ITEMTYPE"].Caption = "Item Type";

            RepositoryItemLookUpEdit lookUpEdit = new RepositoryItemLookUpEdit();

            gridViewLine.Columns["Clear"].MaxWidth = 16;

            gridViewAttribute.Columns["Clear"].ColumnEdit = clearButton;

            gridViewAttribute.Columns["Clear"].MaxWidth = 16;

        }

        private void lookUpEdit_KeyUp(object sender, KeyEventArgs e)

        {

            Cursor = Cursors.WaitCursor;

            List<Tuple<string, string, string, bool>> symbolDatas = new List<Tuple<string, string, string, bool>>();

            List<Tuple<string, int, bool>> labelDatas = new List<Tuple<string, int, bool>>();

            foreach (DataRow row in symbolDT.Rows)

            {

                symbolDatas.Add(new Tuple<string, string, string, bool>(_uid, _name, _SPPIDSymbolPath, false));

                string _SPPID_Attribute = row["SPPID_ATTRIBUTE"] == DBNull.Value ? null : row["SPPID_ATTRIBUTE"].ToString();

            }

            foreach (DataRow row in attributeDT.Rows)

                string _SPPIDSymbolPath = row["SPPID_SYMBOL_PATH"] == DBNull.Value ? null : row["SPPID_SYMBOL_PATH"].ToString();

                symbolDatas.Add(new Tuple<string, string, string, bool>(_uid, _name, _SPPIDSymbolPath, false));

                string _SPPID_Attribute = row["SPPID_ATTRIBUTE"] == DBNull.Value ? null : row["SPPID_ATTRIBUTE"].ToString();

                int _LOCATION = (int)row["LOCATION"];

                bool _LEADERLINE = (bool)row["LEADERLINE"];

            {

                string _uid = row["UID"].ToString();

                string _SPPID_Attribute = row["SPPID_ATTRIBUTE"] == DBNull.Value ? null : row["SPPID_ATTRIBUTE"].ToString();

            }

            #region Setting

            {

                if (gridview.FocusedColumn.Name != "colClear" && 

                    gridview.FocusedColumn.Name != "colSPPID_ATTRIBUTE" &&

                    e.Cancel = true;

            }

        }