/DTI_PID/BaseModel/Project_DB.cs - Diff - HYTOS - 일정관리

개정판 e00e891d

ID	e00e891d7e20e5bede4eb2b7dd8ea461cef78fdb
상위	88365b05
하위	635a8747, 2ba8339b

gaqhf 이(가) 5년 이상 전에 추가함

dev issue #000 : end mapping

Change-Id: I66da9a36ddc64be0951b68927751ea4089b8db40

             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 SPPID_ETC_SETTING_TABLE = "T_SPPID_ETC_SETTING_TABLE";
             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;
+            }
             public static bool SaveETCSetting(string jsonString)
+            {
                 Project_Info projectInfo = Project_Info.GetInstance();
                 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_ETC_SETTING_TABLE);
                             cmd.ExecuteNonQuery();
                             cmd.CommandText = string.Format("INSERT INTO {0} VALUES (@jsonString)", SPPID_ETC_SETTING_TABLE);
                             cmd.Parameters.AddWithValue("@jsonString", jsonString);
                             cmd.ExecuteNonQuery();
+                        }
                         connection.Close();
+                    }
                     catch (Exception ex)
+                    {
                         return false;
+                    }
                     finally
+                    {
                         connection.Dispose();
+                    }
+                }
                 return true;
+            }
             public static DataTable SelectETCSetting()
+            {
                 DataTable dt = new DataTable();
                 Project_Info projectInfo = Project_Info.GetInstance();
                 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_ETC_SETTING_TABLE);
                             using (SQLiteDataReader dr = cmd.ExecuteReader())
                                 dt.Load(dr);
+                        }
                         connection.Close();
+                    }
                     catch (Exception ex)
+                    {
+                    }
                     finally
+                    {
                         connection.Dispose();
+                    }
+                }
                 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_ETC_SETTING_TABLE)).Length == 0)
+                        {
                             cmd.CommandText = string.Format("CREATE TABLE {0} (JsonString TEXT)", SPPID_ETC_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)", SPPID_SYMBOL_MAPPING_TABLE);

내보내기 Unified diff

프로젝트

일반

사용자정보

HYTOS

개정판 e00e891d