개정판 2b02c914
dev issue #1227 : mapping linenumber attribute
Change-Id: I42023caea7b1ba73d5d60be34dd064696e2111ca
| DTI_PID/APIDConverter/DB/Project_DB.cs | ||
|---|---|---|
| 940 | 940 |
|
| 941 | 941 |
return dt; |
| 942 | 942 |
} |
| 943 |
public static DataTable SelectProjectLineProperties() |
|
| 944 |
{
|
|
| 945 |
DataTable dt = new DataTable(); |
|
| 946 |
Project_Info projectInfo = Project_Info.GetInstance(); |
|
| 947 |
if (projectInfo.DBType == ID2DB_Type.SQLite) |
|
| 948 |
{
|
|
| 949 |
using (SQLiteConnection connection = new SQLiteConnection(string.Format(CultureInfo.CurrentCulture, "Data Source = {0}", projectInfo.DBFilePath)))
|
|
| 950 |
{
|
|
| 951 |
try |
|
| 952 |
{
|
|
| 953 |
connection.Open(); |
|
| 954 |
using (SQLiteCommand cmd = connection.CreateCommand()) |
|
| 955 |
{
|
|
| 956 |
cmd.CommandText = string.Format(@" |
|
| 957 |
SELECT lp.UID, lp.DisplayName, sp.APID_SYMBOL, spa.APID_ATTRIBUTE |
|
| 958 |
FROM {0} as lp
|
|
| 959 |
LEFT OUTER JOIN {1} as sp
|
|
| 960 |
ON lp.UID = sp.UID |
|
| 961 |
LEFT OUTER JOIN {2} as spa
|
|
| 962 |
ON lp.UID = spa.UID;", LineProperties_TABLE, APID_SYMBOL_MAPPING_TABLE, APID_ATTRIBUTE_MAPPING_TABLE); |
|
| 963 |
using (SQLiteDataReader dr = cmd.ExecuteReader()) |
|
| 964 |
dt.Load(dr); |
|
| 965 |
} |
|
| 966 |
connection.Close(); |
|
| 967 |
} |
|
| 968 |
catch (Exception ex) |
|
| 969 |
{
|
|
| 970 |
Log.Write(ex.Message + "\r\n" + ex.StackTrace); |
|
| 971 |
} |
|
| 972 |
finally |
|
| 973 |
{
|
|
| 974 |
connection.Dispose(); |
|
| 975 |
} |
|
| 976 |
} |
|
| 977 |
} |
|
| 978 |
else if (projectInfo.DBType == ID2DB_Type.MSSQL) |
|
| 979 |
{
|
|
| 980 |
using (SqlConnection connection = GetSqlConnection()) |
|
| 981 |
{
|
|
| 982 |
try |
|
| 983 |
{
|
|
| 984 |
if (connection != null && connection.State == ConnectionState.Open) |
|
| 985 |
{
|
|
| 986 |
using (SqlCommand cmd = connection.CreateCommand()) |
|
| 987 |
{
|
|
| 988 |
cmd.CommandText = string.Format(@" |
|
| 989 |
SELECT lp.UID, lp.DisplayName, sp.APID_SYMBOL, spa.APID_ATTRIBUTE |
|
| 990 |
FROM {0} as lp
|
|
| 991 |
LEFT OUTER JOIN {1} as sp
|
|
| 992 |
ON lp.UID = sp.UID |
|
| 993 |
LEFT OUTER JOIN {2} as spa
|
|
| 994 |
ON lp.UID = spa.UID;", LineProperties_TABLE, APID_SYMBOL_MAPPING_TABLE, APID_ATTRIBUTE_MAPPING_TABLE); |
|
| 995 |
using (SqlDataReader dr = cmd.ExecuteReader()) |
|
| 996 |
dt.Load(dr); |
|
| 997 |
} |
|
| 998 |
connection.Close(); |
|
| 999 |
} |
|
| 1000 |
} |
|
| 1001 |
catch (Exception ex) |
|
| 1002 |
{
|
|
| 1003 |
Log.Write(ex.Message + "\r\n" + ex.StackTrace); |
|
| 1004 |
} |
|
| 1005 |
finally |
|
| 1006 |
{
|
|
| 1007 |
if (connection != null) |
|
| 1008 |
connection.Dispose(); |
|
| 1009 |
} |
|
| 1010 |
} |
|
| 1011 |
} |
|
| 1012 |
|
|
| 1013 |
return dt; |
|
| 1014 |
} |
|
| 943 | 1015 |
#endregion |
| 944 | 1016 |
|
| 945 | 1017 |
#region AVEVA |
내보내기 Unified diff
