개정판 acfb1ca2
APIDConverter AutoCAD 2021 support. Project Symbol Mapping.
Change-Id: I282e46dba8250bfbd777b78f4f8752da3992ccfc
| DTI_PID/APIDConverter/DB/Project_DB.cs | ||
|---|---|---|
| 1436 | 1436 |
using (SqlCommand cmd = connection.CreateCommand()) |
| 1437 | 1437 |
{
|
| 1438 | 1438 |
cmd.CommandText = string.Format(@" |
| 1439 |
SELECT * FROM {0}
|
|
| 1439 |
SELECT ID, Relative_Path, 'STANDARD' as Type FROM {0} WHERE Relative_Path > ' '
|
|
| 1440 | 1440 |
;", "StdPrjFolStructure"); |
| 1441 | 1441 |
|
| 1442 | 1442 |
using (SqlDataReader dr = cmd.ExecuteReader()) |
| ... | ... | |
| 1447 | 1447 |
|
| 1448 | 1448 |
return dt; |
| 1449 | 1449 |
} |
| 1450 |
public static DataTable SelectProjectSymbolStructureTable() |
|
| 1451 |
{
|
|
| 1452 |
DataTable dt = new DataTable(); |
|
| 1453 |
|
|
| 1454 |
using (SqlConnection connection = new SqlConnection()) |
|
| 1455 |
{
|
|
| 1456 |
connection.ConnectionString = GetAvevaConnectionString_Admin(); |
|
| 1457 |
connection.Open(); |
|
| 1458 |
using (SqlCommand cmd = connection.CreateCommand()) |
|
| 1459 |
{
|
|
| 1460 |
cmd.CommandText = string.Format(@" |
|
| 1461 |
SELECT ID, Relative_Path, 'PROJECT' as Type FROM {0} WHERE Relative_Path > ' '
|
|
| 1462 |
;", "UsrStdFolStructure"); |
|
| 1463 |
|
|
| 1464 |
using (SqlDataReader dr = cmd.ExecuteReader()) |
|
| 1465 |
dt.Load(dr); |
|
| 1466 |
} |
|
| 1467 |
connection.Close(); |
|
| 1468 |
} |
|
| 1469 |
|
|
| 1470 |
return dt; |
|
| 1471 |
} |
|
| 1450 | 1472 |
public static DataTable SelectStandardSymbolImageTable() |
| 1451 | 1473 |
{
|
| 1452 | 1474 |
DataTable dt = new DataTable(); |
| ... | ... | |
| 1458 | 1480 |
using (SqlCommand cmd = connection.CreateCommand()) |
| 1459 | 1481 |
{
|
| 1460 | 1482 |
cmd.CommandText = string.Format(@" |
| 1461 |
SELECT ss.Symbol_Name, ss.Pic_Binary, sps.Relative_Path FROM {0} as ss
|
|
| 1483 |
SELECT ss.Symbol_Name, ss.Pic_Binary, sps.Relative_Path, 'STANDARD' as Type FROM {0} as ss
|
|
| 1462 | 1484 |
LEFT OUTER JOIN {1} as sps
|
| 1463 | 1485 |
ON ss.Relative_Path = sps.ID |
| 1464 | 1486 |
ORDER BY sps.ID ASC |
| ... | ... | |
| 1472 | 1494 |
|
| 1473 | 1495 |
return dt; |
| 1474 | 1496 |
} |
| 1497 |
public static DataTable SelectProjectSymbolImageTable() |
|
| 1498 |
{
|
|
| 1499 |
DataTable dt = new DataTable(); |
|
| 1500 |
|
|
| 1501 |
using (SqlConnection connection = new SqlConnection()) |
|
| 1502 |
{
|
|
| 1503 |
connection.ConnectionString = GetAvevaConnectionString_Admin(); |
|
| 1504 |
connection.Open(); |
|
| 1505 |
using (SqlCommand cmd = connection.CreateCommand()) |
|
| 1506 |
{
|
|
| 1507 |
cmd.CommandText = string.Format(@" |
|
| 1508 |
SELECT ss.Symbol_Name, ss.Pic_Binary, sps.Relative_Path, 'PROJECT' as Type FROM {0} as ss
|
|
| 1509 |
LEFT OUTER JOIN {1} as sps
|
|
| 1510 |
ON ss.Relative_Path = sps.ID |
|
| 1511 |
ORDER BY sps.ID ASC |
|
| 1512 |
;", "prjSymbols", "UsrStdFolStructure"); |
|
| 1513 |
|
|
| 1514 |
using (SqlDataReader dr = cmd.ExecuteReader()) |
|
| 1515 |
dt.Load(dr); |
|
| 1516 |
} |
|
| 1517 |
connection.Close(); |
|
| 1518 |
} |
|
| 1519 |
|
|
| 1520 |
return dt; |
|
| 1521 |
} |
|
| 1475 | 1522 |
public static DataTable SelectDrawingTable() |
| 1476 | 1523 |
{
|
| 1477 | 1524 |
DataTable dt = new DataTable(); |
내보내기 Unified diff
