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

개정판 310aeb31

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

dev issue #000 : Instrument Lable 임시 모델링 개발 / Signal Run Branch 안되던 현상 수정

Change-Id: I245c21b40b7e9aa69731f69fb9fc7cc656691121

                         using (SQLiteCommand cmd = connection.CreateCommand())
+                        {
                             cmd.CommandText = string.Format(@"
                                 SELECT sp.UID, s.Name, st.Type, sp.SPPID_SYMBOL_PATH FROM {1} as st, {0} as s
                                 SELECT s.UID, s.Name, st.Type, sp.SPPID_SYMBOL_PATH FROM {1} as st, {0} as s
                                     LEFT OUTER JOIN {2} as sp
                                         ON s.UID = SP.UID
                                 WHERE s.SymbolType_UID = st.UID
                                 ORDER BY st.TYPE ASC;", Symbol_TABLE, SymbolType_TABLE, SPPID_SYMBOL_MAPPING_TABLE);
                             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();
+                    }

내보내기 Unified diff