개정판 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
