/DTI_PID/ID2PSN/DB.cs - Diff - HYTOS - 일정관리

개정판 a2ab8a90

ID	a2ab8a906dcb508c3742f381cbd060c4824c5333
상위	af2e60f2
하위	8bca0296, 340bf987

이지연이(가) 2년 이상 전에 추가함

issue #000: 추가 기능 Setting UI 추가

Change-Id: Ia3330d0e17cc32b26d8c27450934e82c68173344

             const string PSN_VIEW = "T_PSN_VIEW";
             const string PSN_TRANSFORMKEYWORD_SETTING = "T_PSN_TRANSFORMKEYWORD_SETTING";
             const string PSN_VALVEGROUP_SETTING = "SPPIDValveGroup";
             const string PSN_MULTIWAY_SETTING = "T_PSN_MULTIWAY_SETTING";
             const string PSN_PATHITEMS = "SPPIDPathItem";
             const string PSN_SEQUENCEDATA = "SPPIDSequenceData";
             const string PSN_PIPESYSTEMNETWORK = "SPPIDPipeSystemNetwork";
-...
                             AddColumn(PSN_TRANSFORMKEYWORD_SETTING, dicColCheck);
+                        }
                         matched = names.FirstOrDefault(param => param == PSN_MULTIWAY_SETTING);
                         dicColCheck.Clear();
                         dicColCheck.Add("INDEX", "INTEGER");
                         dicColCheck.Add("NAME", "TEXT");
                         dicColCheck.Add("MULTIWAY", "TEXT");
                         if (matched == null)
+                        {
                             var query = $"CREATE TABLE {PSN_MULTIWAY_SETTING} ([INDEX] INTEGER, [NAME] TEXT, [MULTIWAY] TEXT)";
                             using (var cmd = connection.GetSqlStringCommand(query))
+                            {
                                 cmd.ExecuteNonQuery();
+                            }
+                        }
                         else
+                        {
                             AddColumn(PSN_MULTIWAY_SETTING, dicColCheck);
+                        }
                         matched = names.FirstOrDefault(param => param == PSN_PIPELINE);
                         dicColCheck.Clear();
                         dicColCheck.Add("OID", "NVARCHAR(255)");
-...
                 return dt;
+            }
             public static DataTable SelectMultiwaysSetting()
+            {
                 DataTable dt = null;
                 ID2Info id2Info = ID2Info.GetInstance();
                 using (IAbstractDatabase connection = id2Info.CreateConnection())
+                {
                     try
+                    {
                         var query = $@"SELECT [MULTIWAY], [INDEX], [NAME] FROM {PSN_MULTIWAY_SETTING};";
                         using (var ds = connection.ExecuteDataSet(connection.GetSqlStringCommand(query)))
+                        {
                             dt = ds.Tables[0].Copy();
+                        }
+                    }
                     catch (Exception ex)
+                    {
                         Log.Write(ex.Message + "\r\n" + ex.StackTrace);
+                    }
+                }
                 return dt;
+            }
             public static DataTable SelectValveGroupItemsSetting()
+            {
                 DataTable dt = null;
-...
                 return true;
+            }
             public static bool SaveMultiwaysSetting(List<MultiwayItem> multiwayItems)
+            {
                 ID2Info id2Info = ID2Info.GetInstance();
                 using (IAbstractDatabase connection = id2Info.CreateConnection())
+                {
                     using (var txn = connection.BeginTransaction())
+                    {
                         try
+                        {
                             var query = $"DELETE FROM {PSN_MULTIWAY_SETTING}";
                             connection.ExecuteNonQuery(connection.GetSqlStringCommand(query), txn);
                             foreach (MultiwayItem item in multiwayItems)
+                            {
                                 query = $"INSERT INTO {PSN_MULTIWAY_SETTING} ([INDEX], NAME, MULTIWAY) VALUES (@INDEX, @NAME, @MULTIWAY)";
                                 var cmd = connection.GetSqlStringCommand(query);
                                 AddWithValue(cmd, "@INDEX", item.Index);
                                 AddWithValue(cmd, "@NAME", item.Name);
                                 AddWithValue(cmd, "@MULTIWAY", item.Multiway);
                                 connection.ExecuteNonQuery(cmd, txn);
+                            }
                             txn.Commit();
+                        }
                         catch (Exception ex)
+                        {
                             Log.Write(ex.Message + "\r\n" + ex.StackTrace);
                             return false;
+                        }
+                    }
+                }
                 return true;
+            }
             public static bool SaveEquipmentNopocketSetting(List<EquipmentNoPocketItem> keywordItems)
+            {
                 ID2Info id2Info = ID2Info.GetInstance();
-...
                             AddColumn(PSN_TRANSFORMKEYWORD_SETTING, dicColCheck);
+                        }
                         matched = names.FirstOrDefault(param => param == PSN_MULTIWAY_SETTING);
                         dicColCheck.Clear();
                         dicColCheck.Add("INDEX", "INTEGER");
                         dicColCheck.Add("NAME", "TEXT");
                         dicColCheck.Add("MULTIWAY", "TEXT");
                         if (matched == null)
+                        {
                             var query = $"CREATE TABLE {PSN_MULTIWAY_SETTING} ([INDEX] INTEGER, [NAME] TEXT, [MULTIWAY] TEXT)";
                             using (var cmd = connection.GetSqlStringCommand(query))
+                            {
                                 cmd.ExecuteNonQuery();
+                            }
+                        }
                         else
+                        {
                             AddColumn(PSN_MULTIWAY_SETTING, dicColCheck);
+                        }
                         matched = names.FirstOrDefault(param => param == PSN_PIPELINE);
                         dicColCheck.Clear();
                         dicColCheck.Add("OID", "NVARCHAR(255)");
-...
+            }
             public static bool SaveAnotherPSNData(PSN item, List<HeaderInfo> headerInfos, List<VentDrainInfo> ventDrainInfos,
               List<KeywordItem> keywordItems, DataTable dtTopologyRule, DataTable dtFluidCode, DataTable dtPMC, DataTable dtInsulation, DataTable dtvalvegrouping, DataTable dtnopocket, DataTable dtafc)
               List<KeywordItem> keywordItems, DataTable dtTopologyRule, DataTable dtFluidCode, DataTable dtPMC, DataTable dtInsulation, DataTable dtvalvegrouping, DataTable dtnopocket, DataTable dtafc,
               List<MultiwayItem> multiwayItems)
+            {
                 AnotherID2Info id2Info = AnotherID2Info.GetInstance();
-...
                                     connection.ExecuteNonQuery(cmd, txn);
+                                }
                                 //Multiway Setting
                                 query = $"DELETE FROM {PSN_MULTIWAY_SETTING}";
                                 connection.ExecuteNonQuery(connection.GetSqlStringCommand(query), txn);
                                 foreach (MultiwayItem itemMultiway in multiwayItems)
+                                {
                                     query = $"INSERT INTO {PSN_MULTIWAY_SETTING} ([INDEX], NAME, MULTIWAY) VALUES (@INDEX, @NAME, @MULTIWAY)";
                                     var cmd = connection.GetSqlStringCommand(query);
                                     AddWithValue(cmd, "@INDEX", itemMultiway.Index);
                                     AddWithValue(cmd, "@NAME", itemMultiway.Name);
                                     AddWithValue(cmd, "@MULTIWAY", itemMultiway.Multiway);
                                     connection.ExecuteNonQuery(cmd, txn);
+                                }
                                 //FulidCode
                                 query = $"DELETE FROM {PSN_FLUIDCODE}";
                                 connection.ExecuteNonQuery(connection.GetSqlStringCommand(query), txn);

내보내기 Unified diff

프로젝트

일반

사용자정보

HYTOS

개정판 a2ab8a90