개정판 c5bc0767
dev issue #1203 : fix bug
Change-Id: Ib8002297516a33d6654df6742d8990beb1b13825
| DTI_PID/SPPIDConverter/DB/Project_DB.cs | ||
|---|---|---|
| 1718 | 1718 |
{
|
| 1719 | 1719 |
cmd.Parameters.Clear(); |
| 1720 | 1720 |
cmd.CommandText = string.Format(@" |
| 1721 |
IF EXISTS (SELECT * FROM {0} WHERE UID = '{1}')
|
|
| 1721 |
IF EXISTS (SELECT * FROM {0} WHERE ID2_OPC_UID = '{1}')
|
|
| 1722 | 1722 |
UPDATE {0} SET SPPID_OPC_MODELITEM_ID = @SPPID_OPC_MODELITEM_ID, ID2_DRAWING_UID = @ID2_DRAWING_UID, ATTRIBUTES = @ATTRIBUTES, PAIRED = @PAIRED WHERE ID2_OPC_UID = @ID2_OPC_UID
|
| 1723 | 1723 |
ELSE |
| 1724 | 1724 |
INSERT INTO {0} (ID2_OPC_UID, SPPID_OPC_MODELITEM_ID, ID2_DRAWING_UID, ATTRIBUTES, PAIRED) VALUES (@ID2_OPC_UID, @SPPID_OPC_MODELITEM_ID, @ID2_DRAWING_UID, @ATTRIBUTES, @PAIRED)", SPPID_OPC_INFO, item.UID);
|
내보내기 Unified diff
