HYTOS

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

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

        <value>0</value>

      </setting>

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

        <value />

      </setting>

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

        <value />

      </setting>

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

        <value />

      </setting>

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

        <value />

      </setting>

                _ProjectInfo.DefaultPath = Settings.Default.ProjectPath;

                _ProjectInfo.DBType = (ID2DB_Type)Settings.Default.ProjectDBType;

                _ProjectInfo.ServerIP = Settings.Default.ProjectServerIP;

                _ProjectInfo.Port = Settings.Default.ProjectPort;

                _ProjectInfo.DBUser = Settings.Default.ProjectDBUser;

                _ProjectInfo.DBPassword = Settings.Default.ProjectDBPassword;

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

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

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

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

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

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

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

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

            // btnID2DB

            // 

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

            this.btnID2DB.Location = new System.Drawing.Point(967, 58);

            this.btnID2DB.Name = "btnID2DB";

            this.btnID2DB.Size = new System.Drawing.Size(243, 36);

            this.btnID2DB.StyleController = this.layoutControl1;

            this.btnID2DB.TabIndex = 15;

            this.btnID2DB.Text = "Setting";

            this.btnID2DB.Click += new System.EventHandler(this.btnID2DB_Click);

            // 

            this.checkEditCloseDocument.Location = new System.Drawing.Point(735, 76);

            this.comboBoxEditDefaultTemplate.Location = new System.Drawing.Point(609, 76);

            this.comboBoxEditDefaultTemplate.Size = new System.Drawing.Size(112, 20);

            this.buttonEditDefaultUnit.Location = new System.Drawing.Point(392, 76);

            this.buttonEditDefaultUnit.Size = new System.Drawing.Size(113, 20);

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

            this.btnItemMapping.Location = new System.Drawing.Point(967, 344);

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

            this.btnSPPIDDB.Location = new System.Drawing.Point(967, 210);

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

            this.gridControlConverter.Size = new System.Drawing.Size(905, 441);

            this.layoutControlGroupSPPIDDB.Location = new System.Drawing.Point(943, 152);

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

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

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

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

            this.layoutControlGroupItemMapping.Location = new System.Drawing.Point(943, 286);

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

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

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

            this.layoutControlGroupAutoConverter.Size = new System.Drawing.Size(933, 545);

            this.layoutControlItem1.Size = new System.Drawing.Size(909, 445);

            this.emptySpaceItem2.Size = new System.Drawing.Size(590, 18);

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

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

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

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

            this.layoutControlItem8.Size = new System.Drawing.Size(216, 24);

            this.emptySpaceItem3.Size = new System.Drawing.Size(62, 24);

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

            this.emptySpaceItem5.Location = new System.Drawing.Point(701, 18);

            this.emptySpaceItem1.Location = new System.Drawing.Point(943, 402);

            this.emptySpaceItem1.Size = new System.Drawing.Size(271, 143);

            this.simpleLabelItem4,

            this.layoutControlItem7,

            this.labelDBType,

            this.simpleLabelItem7});

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

            this.layoutControlGroupID2Project.Size = new System.Drawing.Size(271, 152);

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

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

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

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

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

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

            // layoutControlItem7

            // 

            this.layoutControlItem7.Control = this.btnID2DB;

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

            this.layoutControlItem7.Name = "layoutControlItem7";

            this.layoutControlItem7.Size = new System.Drawing.Size(247, 40);

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

            this.layoutControlItem7.TextVisible = false;

            // 

            // labelDBType

            // 

            this.labelDBType.AllowHotTrack = false;

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

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

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

            this.labelDBType.Name = "labelDBType";

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

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

            this.labelDBType.Text = "DB Type";

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

            // 

            // simpleLabelItem7

            // 

            this.simpleLabelItem7.AllowHotTrack = false;

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

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

            this.simpleLabelItem7.MaxSize = new System.Drawing.Size(63, 18);

            this.simpleLabelItem7.MinSize = new System.Drawing.Size(63, 18);

            this.simpleLabelItem7.Name = "simpleLabelItem7";

            this.simpleLabelItem7.Size = new System.Drawing.Size(63, 18);

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

            this.simpleLabelItem7.Text = "DB Type : ";

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

            this.simpleLabelItem7.TextSize = new System.Drawing.Size(59, 14);

            // 

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

            this.xtraFolderBrowserDialog.ShowNewFolderButton = false;

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

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

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

        private DevExpress.XtraEditors.SimpleButton btnID2DB;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem7;

        private DevExpress.XtraLayout.SimpleLabelItem labelDBType;

        private DevExpress.XtraLayout.SimpleLabelItem simpleLabelItem7;

        private void btnID2DB_Click(object sender, EventArgs e)

            ID2DBSetting form = new ID2DBSetting();

            DialogResult = form.ShowDialog();

            Project_Info _ProjectInfo = Project_Info.GetInstance();

            _ProjectInfo.DefaultPath = Settings.Default.ProjectPath;

            _ProjectInfo.DBType = (ID2DB_Type)Settings.Default.ProjectDBType;

            _ProjectInfo.ServerIP = Settings.Default.ProjectServerIP;

            _ProjectInfo.Port = Settings.Default.ProjectPort;

            _ProjectInfo.DBUser = Settings.Default.ProjectDBUser;

            _ProjectInfo.DBPassword = Settings.Default.ProjectDBPassword;

            if (DialogResult == DialogResult.OK)

                labelDBType.Text = _ProjectInfo.DBType.ToString();

                labelDBType.AppearanceItemCaption.ForeColor = Color.Blue;

                labelDBType.Text = "";

  <data name="btnID2DB.ImageOptions.SvgImage" type="DevExpress.Utils.Svg.SvgImage, DevExpress.Data.v18.2" mimetype="application/x-microsoft.net.object.bytearray.base64">

    <value>

        AAEAAAD/////AQAAAAAAAAAMAgAAAFlEZXZFeHByZXNzLkRhdGEudjE4LjIsIFZlcnNpb249MTguMi43

        LjAsIEN1bHR1cmU9bmV1dHJhbCwgUHVibGljS2V5VG9rZW49Yjg4ZDE3NTRkNzAwZTQ5YQUBAAAAHURl

        dkV4cHJlc3MuVXRpbHMuU3ZnLlN2Z0ltYWdlAQAAAAREYXRhBwICAAAACQMAAAAPAwAAAA0DAAAC77u/

        PD94bWwgdmVyc2lvbj0nMS4wJyBlbmNvZGluZz0nVVRGLTgnPz4NCjxzdmcgeD0iMHB4IiB5PSIwcHgi

        IHZpZXdCb3g9IjAgMCAzMiAzMiIgdmVyc2lvbj0iMS4xIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcv

        MjAwMC9zdmciIHhtbG5zOnhsaW5rPSJodHRwOi8vd3d3LnczLm9yZy8xOTk5L3hsaW5rIiBlbmFibGUt

        YmFja2dyb3VuZD0ibmV3IDAgMCAzMiAzMiIgeG1sOnNwYWNlPSJwcmVzZXJ2ZSIgaWQ9IkxheWVyXzEi

        Pg0KICA8ZyBpZD0iUHJvcGVydGllcyI+DQogICAgPHBhdGggZD0iTTMwLDE4di00bC00LjQtMC43Yy0w

        LjItMC44LTAuNS0xLjUtMC45LTIuMWwyLjYtMy42bC0yLjgtMi44bC0zLjYsMi42Yy0wLjctMC40LTEu

        NC0wLjctMi4xLTAuOUwxOCwyaC00ICAgbC0wLjcsNC40Yy0wLjgsMC4yLTEuNSwwLjUtMi4xLDAuOUw3

        LjUsNC43TDQuNyw3LjVsMi42LDMuNmMtMC40LDAuNy0wLjcsMS40LTAuOSwyLjFMMiwxNHY0bDQuNCww

        LjdjMC4yLDAuOCwwLjUsMS41LDAuOSwyLjEgICBsLTIuNiwzLjZsMi44LDIuOGwzLjYtMi42YzAuNyww

        LjQsMS40LDAuNywyLjEsMC45TDE0LDMwaDRsMC43LTQuNGMwLjgtMC4yLDEuNS0wLjUsMi4xLTAuOWwz

        LjYsMi42bDIuOC0yLjhsLTIuNi0zLjYgICBjMC40LTAuNywwLjctMS40LDAuOS0yLjFMMzAsMTh6IE0x

        NiwyMGMtMi4yLDAtNC0xLjgtNC00YzAtMi4yLDEuOC00LDQtNHM0LDEuOCw0LDRDMjAsMTguMiwxOC4y

        LDIwLDE2LDIweiIgZmlsbD0iIzExNzdENyIgY2xhc3M9IkJsdWUiIC8+DQogIDwvZz4NCjwvc3ZnPgs=

</value>

  </data>

using System.Data.SqlClient;

        private static SqlConnection GetSqlConnection()

            SqlConnection connection = null;

                connection = new SqlConnection(string.Format(CultureInfo.CurrentCulture,

                    @"Data Source = {0},{1}; Initial Catalog = {2}; User ID = {3}; Password = {4};",

                    projectInfo.ServerIP,

                    projectInfo.Port,

                    System.IO.Path.GetFileName(projectInfo.DefaultPath),

                    projectInfo.DBUser,

                    projectInfo.DBPassword));

                connection = null;

            return connection;

        public static bool ConnTestAndCreateTable()

            bool result = false;

            if (projectInfo.DBType == ID2DB_Type.SQLite)

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

                    try

                        connection.Open();

                        if (connection.State == ConnectionState.Open)

                        {

                            using (SQLiteCommand cmd = connection.CreateCommand())

                            {

                                cmd.CommandText = "SELECT NAME FROM sqlite_master WHERE type='table'";

                                using (SQLiteDataReader dr = cmd.ExecuteReader())

                                using (DataTable dt = new DataTable())

                                {

                                    dt.Load(dr);

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

                                    {

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

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

                                        cmd.CommandText = string.Format("CREATE TABLE {0} (JsonString TEXT, SettingType TEXT)", SPPID_SETTING_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, LEADERLINE BOOLEAN)", SPPID_SYMBOL_MAPPING_TABLE);

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

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

                                        cmd.ExecuteNonQuery();

                                    }

                                    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);

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

                                        cmd.CommandText = string.Format("CREATE TABLE {0} (ID2_DRAWING_UID Text PRIMARY KEY, PATH TEXT, DRAWINGNUMBER TEXT, DRAWINGNAME TEXT)", SPPID_DRAWING_INFO);

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

                                        cmd.CommandText = string.Format("CREATE TABLE {0} (ID2_OPC_UID TEXT PRIMARY KEY, SPPID_OPC_MODELITEM_ID TEXT, ID2_DRAWING_UID TEXT, ATTRIBUTES TEXT, PAIRED BOOL)", SPPID_OPC_INFO);

                                        cmd.ExecuteNonQuery();

                                    }

                                }

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

                                cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_SYMBOL_MAPPING_TABLE);

                                using (SQLiteDataReader dr = cmd.ExecuteReader())

                                using (DataTable dt = new DataTable())

                                {

                                    dt.Load(dr);

                                    if (!dt.Columns.Contains("LEADERLINE"))

                                    {

                                        cmd.CommandText = string.Format("ALTER TABLE {0} ADD COLUMN LEADERLINE BOOLEAN", SPPID_SYMBOL_MAPPING_TABLE);

                                        cmd.ExecuteNonQuery();

                                    }

                                }

                                cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_SETTING_TABLE);

                                using (SQLiteDataReader dr = cmd.ExecuteReader())

                                using (DataTable dt = new DataTable())

                                {

                                    dt.Load(dr);

                                    if (!dt.Columns.Contains("SettingType"))

                                    {

                                        cmd.CommandText = string.Format("ALTER TABLE {0} ADD COLUMN SettingType Text", SPPID_SETTING_TABLE);

                                        cmd.ExecuteNonQuery();

                                    }

                                }

                                cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_DRAWING_INFO);

                                using (SQLiteDataReader dr = cmd.ExecuteReader())

                                using (DataTable dt = new DataTable())

                                {

                                    dt.Load(dr);

                                    if (dt.Columns.Contains("DOCUMENT"))

                                    {

                                        cmd.CommandText = string.Format("DROP TABLE {0}", SPPID_DRAWING_INFO);

                                        cmd.ExecuteNonQuery();

                                        cmd.CommandText = string.Format("CREATE TABLE {0} (ID2_DRAWING_UID Text PRIMARY KEY, PATH TEXT, DRAWINGNUMBER TEXT, DRAWINGNAME TEXT)", SPPID_DRAWING_INFO);

                                        cmd.ExecuteNonQuery();

                                    }

                                }

                                #endregion

                            }

                            result = true;

                        }

                        connection.Close();

                    }

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        connection.Dispose();

            else if (projectInfo.DBType == ID2DB_Type.MSSQL)

                using (SqlConnection connection = GetSqlConnection())

                    try

                        if (connection != null && connection.State == ConnectionState.Open)

                        {

                            using (SqlCommand cmd = connection.CreateCommand())

                            {

                                cmd.CommandText = "SELECT TABLE_NAME AS NAME FROM INFORMATION_SCHEMA.TABLES";

                                using (SqlDataReader dr = cmd.ExecuteReader())

                                using (DataTable dt = new DataTable())

                                {

                                    dt.Load(dr);

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

                                    {

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

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

                                        cmd.CommandText = string.Format("CREATE TABLE {0} (JsonString varchar(255), SettingType varchar(255))", SPPID_SETTING_TABLE);

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

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

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

                                        cmd.CommandText = string.Format("CREATE TABLE {0} (UID varchar(255) PRIMARY KEY, SPPID_ATTRIBUTE varchar(255))", SPPID_ATTRIBUTE_MAPPING_TABLE);

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

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

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

                                        cmd.CommandText = string.Format("CREATE TABLE {0} (ID2_DRAWING_UID varchar(255) PRIMARY KEY, PATH varchar(255), DRAWINGNUMBER varchar(255), DRAWINGNAME varchar(255))", SPPID_DRAWING_INFO);

                                        cmd.ExecuteNonQuery();

                                    }

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

                                    {

                                        cmd.CommandText = string.Format("CREATE TABLE {0} (ID2_OPC_UID varchar(255) PRIMARY KEY, SPPID_OPC_MODELITEM_ID varchar(255), ID2_DRAWING_UID varchar(255), ATTRIBUTES varchar(255), PAIRED BIT)", SPPID_OPC_INFO);

                                        cmd.ExecuteNonQuery();

                                    }

                                }

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

                                #endregion

                            }

                            result = true;

                        }

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        if (connection != null)

                            connection.Dispose();

                    }

            return result;

        public static bool SaveSPPID_DB_INFO(string jsonString)

            if (projectInfo.DBType == ID2DB_Type.SQLite)

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

                    try

                    {

                        connection.Open();

                        using (SQLiteCommand cmd = connection.CreateCommand())

                            cmd.CommandText = string.Format("DELETE FROM {0}", SPPID_DB_INFO_TABLE);

                            cmd.ExecuteNonQuery();

                            cmd.CommandText = string.Format("INSERT INTO {0} VALUES (@jsonString)", SPPID_DB_INFO_TABLE);

                            cmd.Parameters.AddWithValue("@jsonString", jsonString);

                        connection.Close();

                    }

                    catch (Exception ex)

                    {

                        return false;

                    }

                    finally

                    {

                        connection.Dispose();

            }

            else if (projectInfo.DBType == ID2DB_Type.MSSQL)

            {

                using (SqlConnection connection = GetSqlConnection())

                    try

                    {

                        if (connection != null && connection.State == ConnectionState.Open)

                        {

                        }

                    }

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        if (connection != null)

                            connection.Dispose();

                    }

        public static DataTable SelectSPPID_DB_INFO()

            if (projectInfo.DBType == ID2DB_Type.SQLite)

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

                    try

                        connection.Open();

                        using (SQLiteCommand cmd = connection.CreateCommand())

                        {

                            cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_DB_INFO_TABLE);

                            using (SQLiteDataReader dr = cmd.ExecuteReader())

                                dt.Load(dr);

                        }

                        connection.Close();

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        connection.Dispose();

                    }

            }

            else if (projectInfo.DBType == ID2DB_Type.MSSQL)

            {

                using (SqlConnection connection = GetSqlConnection())

                    try

                    {

                        if (connection != null && connection.State == ConnectionState.Open)

                        {

                        }

                    }

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        if (connection != null)

                            connection.Dispose();

                    }

        public static bool SaveETCSetting(Dictionary<string,string> dicSetting)

            Project_Info projectInfo = Project_Info.GetInstance();

            if (projectInfo.DBType == ID2DB_Type.SQLite)

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

                    try

                        connection.Open();

                        using (SQLiteCommand cmd = connection.CreateCommand())

                        {

                            cmd.CommandText = string.Format("DELETE FROM {0}", SPPID_SETTING_TABLE);

                            cmd.ExecuteNonQuery();

                            foreach (var item in dicSetting)

                            {

                                cmd.CommandText = string.Format("INSERT INTO {0} VALUES (@jsonString, @SettingType)", SPPID_SETTING_TABLE);

                                cmd.Parameters.AddWithValue("@jsonString", item.Value);

                                cmd.Parameters.AddWithValue("@SettingType", item.Key);

                                cmd.ExecuteNonQuery();

                            }

                        }

                        connection.Close();

                    catch (Exception ex)

                        return false;

                    finally

                        connection.Dispose();

                }

            }

            else if (projectInfo.DBType == ID2DB_Type.MSSQL)

            {

                using (SqlConnection connection = GetSqlConnection())

                {

                    try

                        if (connection != null && connection.State == ConnectionState.Open)

                        {

                        }

                    catch (Exception ex)

                    finally

                        if (connection != null)

                            connection.Dispose();

            }

            return true;

        }

        public static DataTable SelectSetting()

        {

            DataTable dt = new DataTable();

            Project_Info projectInfo = Project_Info.GetInstance();

            if (projectInfo.DBType == ID2DB_Type.SQLite)

            {

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

                    try

                        connection.Open();

                        using (SQLiteCommand cmd = connection.CreateCommand())

                        {

                            cmd.CommandText = string.Format("SELECT * FROM {0}", SPPID_SETTING_TABLE);

                            using (SQLiteDataReader dr = cmd.ExecuteReader())

                                dt.Load(dr);

                        }

                        connection.Close();

                    catch (Exception ex)

                    {

                    }

                    finally

                        connection.Dispose();

            }

            else if (projectInfo.DBType == ID2DB_Type.MSSQL)

            {

                using (SqlConnection connection = GetSqlConnection())

                    try

                    {

                        if (connection != null && connection.State == ConnectionState.Open)

                        {

                        }

                    }

                    catch (Exception ex)

                    }

                    finally

                    {

                        if (connection != null)

                            connection.Dispose();

            return dt;

            if (projectInfo.DBType == ID2DB_Type.SQLite)

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

                    try

                        connection.Open();

                        using (SQLiteCommand cmd = connection.CreateCommand())

                        {

                            cmd.CommandText = string.Format(@"

                            using (SQLiteDataReader dr = cmd.ExecuteReader())

                                dt.Load(dr);

                            DataTable dtClone = dt.Clone();

                            dtClone.Columns["UID"].DataType = typeof(string);

                            foreach (DataRow row in dt.Rows)

                            {

                                dtClone.ImportRow(row);

                            }

                            dt.Dispose();

                            dt = dtClone;

                        connection.Close();

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        connection.Dispose();

                    }

            }

            else if (projectInfo.DBType == ID2DB_Type.MSSQL)

            {

                using (SqlConnection connection = GetSqlConnection())

                    try

                    {

                        if (connection != null && connection.State == ConnectionState.Open)

                        {

                        }

                    }

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        if (connection != null)

                            connection.Dispose();

                    }

            if (projectInfo.DBType == ID2DB_Type.SQLite)

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

                using (DataTable dt = new DataTable())

                    try

                        connection.Open();

                        using (SQLiteCommand cmd = connection.CreateCommand())

                        {

                            cmd.CommandText = string.Format(@"

                            using (SQLiteDataReader dr = cmd.ExecuteReader())

                                dt.Load(dr);

                            List<string> childList = new List<string>();

                            foreach (DataRow row in dt.Rows)

                                if (row["AdditionalSymbol"] != null && !DBNull.Value.Equals(row["AdditionalSymbol"]) && !string.IsNullOrEmpty((string)row["AdditionalSymbol"]))

                                    string[] array = row["AdditionalSymbol"].ToString().Split(new char[] { '/' });

                                    foreach (var childString in array)

                                    {

                                        childList.Add(childString.Split(new char[] { ',' })[2]);

                                    }

                            }

                            dt.Clear();

                            cmd.Reset();

                            cmd.CommandText = string.Format(@"

                            using (SQLiteDataReader dr = cmd.ExecuteReader())

                                dt.Load(dr);

                            childList = childList.Distinct().ToList();

                            foreach (var child in childList)

                            {

                                string mappingPath = string.Empty;

                                DataRow[] rows = dt.Select(string.Format("UID = '{0}'", child));

                                if (rows.Length == 1)

                                    mappingPath = !DBNull.Value.Equals(rows[0]["SPPID_SYMBOL_PATH"]) ? (string)rows[0]["SPPID_SYMBOL_PATH"] : null;

                                DataRow newRow = result.NewRow();

                                newRow["UID"] = child;

                                newRow["Name"] = child;

                                newRow["Type"] = "Child Symbol";

                                newRow["SPPID_SYMBOL_PATH"] = mappingPath;

                                result.Rows.Add(newRow);

                            }

                        connection.Close();

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        connection.Dispose();

                    }

            }

            else if (projectInfo.DBType == ID2DB_Type.MSSQL)

            {

                using (SqlConnection connection = GetSqlConnection())

                    try

                    {

                        if (connection != null && connection.State == ConnectionState.Open)

                        {

                        }

                    }

                    catch (Exception ex)

                    {

                    }

                    finally

                    {

                        if (connection != null)

                            connection.Dispose();

                    }