개정판 401efcff
dev issue #000 : SPPID Attribute Mapping 필요없는 값 Query 수정
Change-Id: I4db9fef9491d4ad50ac8fcb08d4cbc02794402c2
| DTI_PID/SPPIDConverter/DB/Project_DB.cs | ||
|---|---|---|
| 427 | 427 |
using (SQLiteCommand cmd = connection.CreateCommand()) |
| 428 | 428 |
{
|
| 429 | 429 |
cmd.CommandText = string.Format(@" |
| 430 |
SELECT sa.UID, sa.DisplayAttribute, st.TYPE, spa.SPPID_ATTRIBUTE, sp.SPPID_SYMBOL_PATH, spl.LOCATION, spl.LEADERLINE
|
|
| 430 |
SELECT sa.UID, sa.DisplayAttribute, st.TYPE, spa.SPPID_ATTRIBUTE, sp.SPPID_SYMBOL_PATH, spl.LOCATION, spl.LEADERLINE, sa.Property
|
|
| 431 | 431 |
FROM {1} as sa, {0} as st
|
| 432 | 432 |
LEFT OUTER JOIN {2} as sp
|
| 433 | 433 |
ON sa.UID = SP.UID |
| ... | ... | |
| 435 | 435 |
ON sa.UID = spa.UID |
| 436 | 436 |
LEFT OUTER JOIN {4} as spl
|
| 437 | 437 |
ON sa.UID = spl.UID |
| 438 |
WHERE sa.SymbolType_UID = st.UID;", SymbolType_TABLE, SymbolAttribute_TABLE, SPPID_SYMBOL_MAPPING_TABLE, SPPID_ATTRIBUTE_MAPPING_TABLE, SPPID_LABEL_INFO_TABLE); |
|
| 438 |
WHERE sa.SymbolType_UID = st.UID AND (sa.Property != 2 OR sa.Property IS NULL);", SymbolType_TABLE, SymbolAttribute_TABLE, SPPID_SYMBOL_MAPPING_TABLE, SPPID_ATTRIBUTE_MAPPING_TABLE, SPPID_LABEL_INFO_TABLE);
|
|
| 439 | 439 |
using (SQLiteDataReader dr = cmd.ExecuteReader()) |
| 440 | 440 |
dt.Load(dr); |
| 441 | 441 |
} |
내보내기 Unified diff
