개정판 20dd244c
dev issue #1230 : edit thread, edit CoordinateCorrection
Change-Id: I9f2db1b78232cf092b129cf30a3427791a0f1645
DTI_PID/APIDConverter/DB/Project_DB.cs | ||
---|---|---|
93 | 93 |
} |
94 | 94 |
if (dt.Select(string.Format("NAME = '{0}'", APID_ATTRIBUTE_TABLE)).Length == 0) |
95 | 95 |
{ |
96 |
cmd.CommandText = string.Format("CREATE TABLE {0} (LEVEL1 TEXT, LEVEL2 TEXT, ATTRIBUTE_KEY TEXT, ATTRIBUTE_NAME TEXT)", APID_ATTRIBUTE_TABLE);
|
|
96 |
cmd.CommandText = string.Format("CREATE TABLE {0} (LEVEL1 TEXT PRIMARY KEY, LEVEL2 TEXT PRIMARY KEY, ATTRIBUTE_KEY TEXT PRIMARY KEY, ATTRIBUTE_NAME TEXT)", APID_ATTRIBUTE_TABLE);
|
|
97 | 97 |
cmd.ExecuteNonQuery(); |
98 | 98 |
} |
99 | 99 |
} |
... | ... | |
894 | 894 |
{ |
895 | 895 |
cmd.Parameters.Clear(); |
896 | 896 |
cmd.CommandText = string.Format(@" |
897 |
IF EXISTS (SELECT * FROM {0} WHERE LEVEL1 = '{1}' AND LEVEL2 = '{2}' AND ATTRIBUTE_KEY = '{3}') |
|
898 |
UPDATE {0} SET ATTRIBUTE_NAME = @ATTRIBUTE_NAME WHERE LEVEL1 = '{1}' AND LEVEL2 = '{2}' AND ATTRIBUTE_KEY = '{3}' |
|
899 |
ELSE |
|
900 |
INSERT INTO {0} (LEVEL1, LEVEL2, ATTRIBUTE_KEY, ATTRIBUTE_NAME) VALUES (@LEVEL1, @LEVEL2, @ATTRIBUTE_KEY, @ATTRIBUTE_NAME)", |
|
897 |
INSERT OR REPLACE INTO {0} (LEVEL1, LEVEL2, ATTRIBUTE_KEY, ATTRIBUTE_NAME) VALUES (@LEVEL1, @LEVEL2, @ATTRIBUTE_KEY, @ATTRIBUTE_NAME)", |
|
901 | 898 |
APID_ATTRIBUTE_TABLE, item.Item1, item.Item2, item.Item3); |
902 | 899 |
cmd.Parameters.AddWithValue("@LEVEL1", item.Item1); |
903 | 900 |
cmd.Parameters.AddWithValue("@LEVEL2", item.Item2); |
내보내기 Unified diff