개정판 56cd4954
dev issue #1223 : Add Symbol Image, AVEVA Symbol
Change-Id: Iab81f1b8025356abe2de247a70aea3b70df17e75
| DTI_PID/APIDConverter/DB/Project_DB.cs | ||
|---|---|---|
| 449 | 449 |
return strConn; |
| 450 | 450 |
} |
| 451 | 451 |
|
| 452 |
public static DataTable SelectSymbolTable() |
|
| 452 |
public static DataTable SelectStandardSymbolTable()
|
|
| 453 | 453 |
{
|
| 454 | 454 |
DataTable dt = new DataTable(); |
| 455 | 455 |
|
| ... | ... | |
| 459 | 459 |
connection.Open(); |
| 460 | 460 |
using (SqlCommand cmd = connection.CreateCommand()) |
| 461 | 461 |
{
|
| 462 |
cmd.CommandText = string.Format("SELECT * FROM {0}", "SYMBOLS");
|
|
| 462 |
cmd.CommandText = string.Format(@" |
|
| 463 |
SELECT ss.ID, ss.Symbol_Name, sps.Relative_Path FROM {0} as ss
|
|
| 464 |
LEFT OUTER JOIN {1} as sps
|
|
| 465 |
ON ss.Relative_Path = sps.ID |
|
| 466 |
ORDER BY sps.ID ASC |
|
| 467 |
;", "stdSymbols", "StdPrjFolStructure"); |
|
| 468 |
|
|
| 469 |
using (SqlDataReader dr = cmd.ExecuteReader()) |
|
| 470 |
dt.Load(dr); |
|
| 471 |
} |
|
| 472 |
connection.Close(); |
|
| 473 |
} |
|
| 474 |
|
|
| 475 |
return dt; |
|
| 476 |
} |
|
| 477 |
public static DataTable SelectStandardSymbolStructureTable() |
|
| 478 |
{
|
|
| 479 |
DataTable dt = new DataTable(); |
|
| 480 |
|
|
| 481 |
using (SqlConnection connection = new SqlConnection()) |
|
| 482 |
{
|
|
| 483 |
connection.ConnectionString = GetAvevaConnectionString_Admin(); |
|
| 484 |
connection.Open(); |
|
| 485 |
using (SqlCommand cmd = connection.CreateCommand()) |
|
| 486 |
{
|
|
| 487 |
cmd.CommandText = string.Format(@" |
|
| 488 |
SELECT * FROM {0}
|
|
| 489 |
;", "StdPrjFolStructure"); |
|
| 490 |
|
|
| 491 |
using (SqlDataReader dr = cmd.ExecuteReader()) |
|
| 492 |
dt.Load(dr); |
|
| 493 |
} |
|
| 494 |
connection.Close(); |
|
| 495 |
} |
|
| 496 |
|
|
| 497 |
return dt; |
|
| 498 |
} |
|
| 499 |
public static DataTable SelectStandardSymbolImageTable() |
|
| 500 |
{
|
|
| 501 |
DataTable dt = new DataTable(); |
|
| 502 |
|
|
| 503 |
using (SqlConnection connection = new SqlConnection()) |
|
| 504 |
{
|
|
| 505 |
connection.ConnectionString = GetAvevaConnectionString_Admin(); |
|
| 506 |
connection.Open(); |
|
| 507 |
using (SqlCommand cmd = connection.CreateCommand()) |
|
| 508 |
{
|
|
| 509 |
cmd.CommandText = string.Format(@" |
|
| 510 |
SELECT ss.Symbol_Name, ss.Pic_Binary, sps.Relative_Path FROM {0} as ss
|
|
| 511 |
LEFT OUTER JOIN {1} as sps
|
|
| 512 |
ON ss.Relative_Path = sps.ID |
|
| 513 |
ORDER BY sps.ID ASC |
|
| 514 |
;", "stdSymbols", "StdPrjFolStructure"); |
|
| 515 |
|
|
| 463 | 516 |
using (SqlDataReader dr = cmd.ExecuteReader()) |
| 464 | 517 |
dt.Load(dr); |
| 465 | 518 |
} |
내보내기 Unified diff
