HYTOS

        const string SPPID_DB_INFO_TABLE = "T_SPPID_CONNECTION_INFO";

        const string SPPID_SYMBOL_MAPPING_TABLE = "T_SPPID_SYMBOL_MAPPING";

        const string SPPID_ATTRIBUTE_MAPPING_TABLE = "T_SPPID_ATTRIBUTE_MAPPING";

        const string LineProperties_TABLE = "LineProperties";

        const string LineTypes_TABLE = "LineTypes";

            Project_Info projectInfo = Project_Info.GetInstance();

            using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))

            {

                try

                {

                    connection.Open();

            return dt;

        }

        private static void CreateTable(SQLiteConnection connection)

        {

            using (SQLiteCommand cmd = connection.CreateCommand())

                        cmd.CommandText = string.Format("CREATE TABLE {0} (JsonString TEXT)", SPPID_DB_INFO_TABLE);

                        cmd.ExecuteNonQuery();

                    }

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

                    {

                        cmd.CommandText = string.Format("CREATE TABLE {0} (UID TEXT PRIMARY KEY, NAME TEXT, SPPID_SYMBOL_PATH TEXT)", SPPID_SYMBOL_MAPPING_TABLE);

                InitID2Line();

                InitID2LineNumber();

                InitID2Association();

            }

        }

        {

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

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

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

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

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

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

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

            this.layoutControl1.SuspendLayout();

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

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

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

            // 

            // layoutControl1

            // 

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

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

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

            this.layoutControl1.TabIndex = 2;

            this.layoutControl1.Text = "layoutControl1";

            // 

            // 

            // 

            // textBoxNoteSymbolPath

            // 

            // 

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

            this.tabbedControlGroup.Name = "tabbedControlGroup";

            this.tabbedControlGroup.Size = new System.Drawing.Size(715, 678);

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

            this.GroupSymbol,

            // 

            // layoutControlItem14

            // 

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

            this.layoutControlItem14.Name = "layoutControlItem14";

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

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

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

            this.layoutControl1.ResumeLayout(false);

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

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

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

        private DevExpress.XtraLayout.EmptySpaceItem emptySpaceItem3;

        private DevExpress.XtraEditors.ButtonEdit textBoxNoteSymbolPath;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem7;

        private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroup9;

        private DevExpress.XtraLayout.LayoutControlGroup layoutControlGroup10;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem14;

using DevExpress.XtraEditors;

using Converter.BaseModel;

using Converter.AutoModeling.SPPID.Properties;

namespace Converter.AutoModeling.SPPID.Form

{

            clearButton.ButtonClick += repositoryItemButtonEdit_ButtonClick;

            clearButton.TextEditStyle = TextEditStyles.HideTextEditor;

            gridControlSymbol.DataSource = symbolDT;

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

            gridViewSymbol.Columns["SPPID_SYMBOL_PATH"].Caption = "SPPID Symbol Path";

            gridControlSymbol.RepositoryItems.Add(clearButton);

            gridViewSymbol.ExpandAllGroups();

            gridControlLine.DataSource = lineDT;

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

            gridViewLine.Columns["SPPID_SYMBOL_PATH"].Caption = "SPPID Symbol Path";

            gridControlLine.RepositoryItems.Add(clearButton);

            gridViewLine.ExpandAllGroups();

            gridControlAssociation.DataSource = associationDT;

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

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

            gridControlAssociation.RepositoryItems.Add(clearButton);

            gridViewAssociation.ExpandAllGroups();

            gridControlLineNumber.DataSource = linePropertyDT;

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

            gridViewLineNumber.Columns["DisplayName"].Caption = "Property Name";

            gridViewLineNumber.Columns["SPPID_ATTRIBUTE"].Caption = "SPPID Attribute Name";

            gridViewLineNumber.Columns["Type"].GroupIndex = 0;

            gridViewLineNumber.ExpandAllGroups();

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

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

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

            textBoxNoteSymbolPath.Properties.TextEditStyle = TextEditStyles.DisableTextEditor;

            textBoxNoteSymbolPath.Properties.Buttons[0].Kind = ButtonPredefines.Glyph;

            textBoxNoteSymbolPath.Properties.Buttons[0].Image = Resources.pencolor_16x16;

        }

        private void textBoxETC_ButtonClick(object sender, ButtonPressedEventArgs e)

                attributeDatas.Add(new Tuple<string, string>(_uid, _SPPID_Attribute));

            }

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

            else

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

            return setting;

        }

    }

}

            }

            return true;

        }

    }

}