HYTOS

        const string SPPID_LABEL_INFO_TABLE = "T_SPPID_LABEL_INFO";

                    if (dt.Select(string.Format("NAME = '{0}'", SPPID_LABEL_INFO_TABLE)).Length == 0)

                        cmd.CommandText = string.Format("CREATE TABLE {0} (UID TEXT PRIMARY KEY, LOCATION INT DEFAULT 0, LEADERLINE BOOLEAN)", SPPID_LABEL_INFO_TABLE);

                            SELECT sa.UID, sa.DisplayAttribute, st.TYPE, spa.SPPID_ATTRIBUTE, sp.SPPID_SYMBOL_PATH, spl.LOCATION, spl.LEADERLINE 

                            WHERE sa.SymbolType_UID = st.UID;", SymbolType_TABLE, SymbolAttribute_TABLE, SPPID_SYMBOL_MAPPING_TABLE, SPPID_ATTRIBUTE_MAPPING_TABLE, SPPID_LABEL_INFO_TABLE);

        public static bool InsertLocationMapping(List<Tuple<string, int, bool>> datas)

                                    cmd.CommandText = string.Format("INSERT OR REPLACE INTO {0} (UID, LOCATION, LEADERLINE) VALUES (@UID, @LOCATION, @LEADERLINE)", SPPID_LABEL_INFO_TABLE);

                                    cmd.Parameters.AddWithValue("@LEADERLINE", item.Item3);

            this.checkComboBoxLineNumberLocation = new DevExpress.XtraEditors.CheckedComboBoxEdit();

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

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

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

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

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

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

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

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

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

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

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup8)).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();

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

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

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

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

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

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

            // checkComboBoxLineNumberLocation

            // 

            this.checkComboBoxLineNumberLocation.Location = new System.Drawing.Point(529, 79);

            this.checkComboBoxLineNumberLocation.MenuManager = this.ribbonControl;

            this.checkComboBoxLineNumberLocation.Name = "checkComboBoxLineNumberLocation";

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

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

            this.checkComboBoxLineNumberLocation.Size = new System.Drawing.Size(170, 20);

            this.checkComboBoxLineNumberLocation.StyleController = this.layoutControl1;

            this.checkComboBoxLineNumberLocation.TabIndex = 30;

            // 

            this.tabbedControlGroup.SelectedTabPage = this.GroupSymbol;

            // GroupLineNumber

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

            this.layoutControlGroup8});

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

            this.GroupLineNumber.Name = "GroupLineNumber";

            this.GroupLineNumber.Size = new System.Drawing.Size(691, 632);

            this.GroupLineNumber.Text = "Line Number";

            // layoutControlGroup8

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

            this.layoutControlItem13,

            this.layoutControlItem3,

            this.layoutControlItem18});

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

            this.layoutControlGroup8.Name = "layoutControlGroup8";

            this.layoutControlGroup8.Size = new System.Drawing.Size(691, 632);

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

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

            this.layoutControlItem13.TextVisible = false;

            // layoutControlItem3

            this.layoutControlItem3.Control = this.textBoxLineNumberPath;

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

            this.layoutControlItem3.Name = "layoutControlItem3";

            this.layoutControlItem3.Size = new System.Drawing.Size(410, 24);

            this.layoutControlItem3.Text = "SPPID Line Number Label Path";

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

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

            this.layoutControlItem3.TextToControlDistance = 5;

            // layoutControlItem18

            this.layoutControlItem18.Control = this.checkComboBoxLineNumberLocation;

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

            this.layoutControlItem18.Name = "layoutControlItem18";

            this.layoutControlItem18.Size = new System.Drawing.Size(257, 24);

            this.layoutControlItem18.Text = "Label Location";

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

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

            this.layoutControlItem18.TextToControlDistance = 5;

            // GroupETCSetting

            // 

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

            this.emptySpaceItem3,

            this.layoutControlGroup9,

            this.layoutControlGroup10});

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

            this.GroupETCSetting.Name = "GroupETCSetting";

            this.GroupETCSetting.Size = new System.Drawing.Size(691, 632);

            this.GroupETCSetting.Text = "ETC Setting";

            // 

            // emptySpaceItem3

            // 

            this.emptySpaceItem3.AllowHotTrack = false;

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

            this.emptySpaceItem3.Name = "emptySpaceItem3";

            this.emptySpaceItem3.Size = new System.Drawing.Size(691, 470);

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

            // 

            // layoutControlGroup9

            // 

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

            this.layoutControlItem5,

            this.layoutControlItem7,

            this.layoutControlItem16,

            this.layoutControlItem17});

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

            this.layoutControlGroup9.Name = "layoutControlGroup9";

            this.layoutControlGroup9.Size = new System.Drawing.Size(691, 93);

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

            // 

            // layoutControlItem5

            // 

            this.layoutControlItem5.Control = this.textBoxTextSymbolPath;

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

            this.layoutControlItem5.Name = "layoutControlItem5";

            this.layoutControlItem5.Size = new System.Drawing.Size(403, 24);

            this.layoutControlItem5.Text = "SPPID Text Symbol Path";

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

            // 

            // layoutControlItem7

            // 

            this.layoutControlItem7.Control = this.textBoxNoteSymbolPath;

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

            this.layoutControlItem7.Name = "layoutControlItem7";

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

            this.layoutControlItem7.Text = "SPPID Note Symbol Path";

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

            // 

            // layoutControlItem16

            // 

            this.layoutControlItem16.Control = this.checkComboBoxTextLocation;

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

            this.layoutControlItem16.Name = "layoutControlItem16";

            this.layoutControlItem16.Size = new System.Drawing.Size(264, 24);

            this.layoutControlItem16.Text = "Label Location";

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

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

            this.layoutControlItem16.TextToControlDistance = 5;

            // 

            // layoutControlItem17

            // 

            this.layoutControlItem17.Control = this.checkComboBoxNoteLocation;

            this.layoutControlItem17.Location = new System.Drawing.Point(403, 24);

            this.layoutControlItem17.Name = "layoutControlItem17";

            this.layoutControlItem17.Size = new System.Drawing.Size(264, 24);

            this.layoutControlItem17.Text = "Label Location";

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

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

            this.layoutControlItem17.TextToControlDistance = 5;

            // 

            // layoutControlGroup10

            // 

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

            this.layoutControlItem14});

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

            this.layoutControlGroup10.Name = "layoutControlGroup10";

            this.layoutControlGroup10.Size = new System.Drawing.Size(691, 69);

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

            // 

            // layoutControlItem14

            // 

            this.layoutControlItem14.Control = this.textBoxDrainValveSize;

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

            this.layoutControlItem14.Name = "layoutControlItem14";

            this.layoutControlItem14.Size = new System.Drawing.Size(667, 24);

            this.layoutControlItem14.Text = "Drain Valve Size";

            this.layoutControlItem14.TextSize = new System.Drawing.Size(136, 14);

            // 

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

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

            ((System.ComponentModel.ISupportInitialize)(this.layoutControlGroup8)).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();

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

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

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

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

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

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

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

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

                    item["LEADERLINE"] = false;

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

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

                labelDatas.Add(new Tuple<string, int, bool>(_uid, _LOCATION, _LEADERLINE));

                Project_DB.InsertLocationMapping(labelDatas) &&

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

                    gridview.FocusedColumn.Name != "colLEADERLINE")

    <OutputType>WinExe</OutputType>