프로젝트

일반

사용자정보

통계
| 브랜치(Branch): | 개정판:

hytos / DTI_PID / SPPIDConverter / MKey.vb @ b929957d

이력 | 보기 | 이력해설 | 다운로드 (8.06 KB)

1 6ba3e887 Gyusu
Imports System.IO
2
3
Module MKey
4
    'Public _Item As String = "Item"
5
    'Public _Type As String = "Type"
6
    'Public _Name As String = "Name"
7
    'Public _Class As String = "Class"
8
    'Public _Text As String = "Text"
9
    'Public _Angle As String = "Angle"
10
    'Public _SystemPath As String = "SystemPath"
11
    'Public _X As String = "X"
12
    'Public _Y As String = "Y"
13
    Public _TYPE_Instumentation = "INSTRUMENTATION"
14
15
    Public _DB_TABLE_MAPPING As String = "Mapping"
16
17
    Public _DB_TABLE_ATTRIBUTE As String = "Attribute"
18
19
    Public _DB_TABLE_SYMBOLNAME As String = "SymbolName"
20
21
    Public _DB_COLUMN_MAPPING_PID_SYMBOLNAME As String = "pid_symbolname"
22
    Public _DB_COLUMN_MAPPING_SPPID_SYSTEMPATH As String = "sppid_systempath"
23
    Public _DB_COLUMN_MAPPING_SPPID_SYMBOLNAME As String = "sppid_symbolname"
24
    Public _DB_COLUMN_MAPPING_SPPID_COMPTPYE As String = "sppid_comptype"
25
    Public _DB_COLUMN_MAPPING_SPPID_CLASS As String = "class"
26
27
    Public _DB_COLUMN_ATTRIBUTE_PID_ATTRIBUTE As String = "pid_attribute"
28
    Public _DB_COLUMN_ATTRIBUTE_SPPID_ATTRIBUTE As String = "sppid_attribute"
29
30
    Public _XML_CATEGORY_DWG As String = "DWG"
31
32
    Public _XML_CATEGORY_EQUIPMENT As String = "EQUIPMENT"
33
34
    Public _XML_CATEGORY_LINENO As String = "LINE_NO"
35
36
    Public _XML_CATEGORY_TRIM_LINENO As String = "TRIM_LINE_NO"
37
38
39
    Public _XML_PIPINGOPC As String = "OPC"
40
41
    Public _XML_CATEGORY_RUN As String = "RUN"
42
43
    Public _XML_CATEGORY_LINE As String = "LINE"
44
45
    Public _XML_CATEGORY_SYMBOL As String = "SYMBOL"
46
47
    Public _XML_CATEGORY_ATTRIBUTE As String = "ATTRIBUTE"
48
49
    Public _XML_CATEGORY_FLOWDIRECITON As String = "FLOW DIRECTION"
50
51
    Public _XML_DWGNAME As String = "DWGNAME"
52
53
    Public _XML_DWGSIZE As String = "SIZE"
54
55
    Public _XML_UNIT As String = "UNIT"
56
57
    Public _XML_LINENO_UID As String = "UID"
58
59
    Public _XML_LINENO_TEXT As String = "TEXT"
60
61
    Public _XML_LINENO_LOCATION As String = "LOCATION"
62
63
    Public _XML_LINENO_ANGLE As String = "ANGLE"
64
65
    Public _XML_LINENO_SYSTEMPATH As String = "SYSTEMPATH"
66
67
68
    Public _XML_EQP_UID As String = "UID"
69
70
    Public _XML_EQP_TEXT As String = "TEXT"
71
72
    Public _XML_EQP_LOCATION As String = "LOCATION"
73
74
    Public _XML_EQP_ANGLE As String = "ANGLE"
75
76
    Public _XML_EQP_SYSTEMPATH As String = "SYSTEMPATH"
77
78
79
80
81
    Public _XML_LINE_UID As String = "UID"
82
    Public _XML_LINE_LINENOUID As String = "LINENO_UID"
83
    Public _XML_LINE_STARTPOINT_X As String = "start_x"
84
    Public _XML_LINE_STARTPOINT_Y As String = "start_y"
85
    Public _XML_LINE_ENDPOINT_X As String = "end_x"
86
    Public _XML_LINE_ENDPOINT_Y As String = "end_y"
87
88
    Public _XML_LINE_STARTPOINT As String = "STARTPOINT"
89
90
    Public _XML_LINE_ENDPOINT As String = "ENDPOINT"
91
92
    Public _XML_LINE_SPID As String = "SPID"
93
    Public _XML_LINE_LMCONNECTOR As String = "LMCONNECTOR"
94
    Public _XML_LINE_LMCONNECTOR_1 As String = "LMCONNECTOR_1"
95
    Public _XML_LINE_LMCONNECTOR_2 As String = "LMCONNECTOR_2"
96
97
98
    Public _XML_LINE_SYSTEMPATH As String = "SYSTEMPATH"
99
100
    Public _XML_LINE_DRAWING_TF As String = "DRAWING"
101
102
    Public _XML_LINE_TYPE As String = "TYPE"
103
104
    Public _XML_LINE_Conn1_Uid As String = "Conn1_Uid"
105
    Public _XML_LINE_Conn2_Uid As String = "Conn2_Uid"
106
107
    Public _XML_LINE_CONNS As String = "CONNS"
108
109
110
    Public _XML_LINE_FlowDirection As String = "FlowDirection"
111
    Public _XML_LINE_Length As String = "Length"
112
    Public _XML_LINE_Check As String = "Check"
113
114
    Public _XML_SYMBOL_UID As String = "UID"
115
    Public _XML_SYMBOL_LINENOUID As String = "LINENO_UID"
116
    Public _XML_SYMBOL_NAME As String = "NAME"
117
118
    Public _XML_SYMBOL_LOCATION As String = "LOCATION"
119
120
    Public _XML_SYMBOL_ORIGINALPOINT As String = "ORIGINALPOINT"
121
122
    Public _XML_SYMBOL_SIZE As String = "SIZE"
123
124
    Public _XML_SYMBOL_ANGLE As String = "ANGLE"
125
126
    Public _XML_SYMBOL_SPID As String = "SPID"
127
128
    Public _XML_SYMBOL_TYPE As String = "TYPE"
129
130
    Public _XML_SYMBOL_DRAWING_TF As String = "DRAWING"
131
132
    Public _XML_SYMBOL_CLASS As String = "CLASS"
133
134
    Public _XML_SYMBOL_PARENT As String = "PARENT"
135
136
    Public _XML_SYMBOL_SYSTEMPATH As String = "SYSTEMPATH"
137
138
    Public _XML_SYMBOL_CONNECTIONPOINT As String = "CONNECTIONPOINT"
139
140
    Public _XML_SYMBOL_CONNS As String = "CONNS"
141
142
    Public _XML_SYMBOL_Check As String = "Check"
143
144
    Public _XML_SYMBOL_Conn1_Uid As String = "Conn1_Uid"
145
    Public _XML_SYMBOL_Conn2_Uid As String = "Conn2_Uid"
146
    Public _XML_SYMBOL_Conn3_Uid As String = "Conn3_Uid"
147
    Public _XML_SYMBOL_Conn4_Uid As String = "Conn4_Uid"
148
    Public _XML_SYMBOL_Conn_Count As String = "Conn_Count"
149
150
    Public _XML_SYMBOL_LMCONNECTOR_1 As String = "LMCONNECTOR_1"
151
    Public _XML_SYMBOL_LMCONNECTOR_2 As String = "LMCONNECTOR_2"
152
    Public _XML_SYMBOL_LMCONNECTOR_3 As String = "LMCONNECTOR_3"
153
    Public _XML_SYMBOL_LMCONNECTOR_4 As String = "LMCONNECTOR_4"
154
155
    Public _XML_SYMBOL_Conn1_Point As String = "Conn1_Point"
156
    Public _XML_SYMBOL_Conn2_Point As String = "Conn2_Point"
157
    Public _XML_SYMBOL_Conn3_Point As String = "Conn3_Point"
158
    Public _XML_SYMBOL_Conn4_Point As String = "Conn4_Point"
159
160
161
162
    Public _XML_ATTRIBUTE_UID As String = "UID"
163
164
    Public _XML_ATTRIBUTE_NAME As String = "NAME"
165
166
    Public _XML_ATTRIBUTE_VALUE As String = "VALUE"
167
168
169
    Public _XML_MODELING_UID As String = "UID"
170
171
    Public _XML_MODELING_NAME As String = "NAME"
172
173
    Public _XML_MODELING_PIPELINE As String = "LINENO"
174
175
    Public _XML_MODELING_DWG As String = "DWGNAME"
176
177
    Public _XML_MODELING_SYSTEMPATH As String = "SYSTEMPATH"
178
179
180
    Public _SYMBOL_VALVES As String = "VALVES"
181
182
    Public _SYMBOL_FITTINGS As String = "FITTINGS"
183
184
    Public _SYMBOL_INSTUMENT As String = "Instrument"
185
186
    Public _SYMBOL_ACTUATORS As String = "ACTUATORS"
187
188
    Public _SYMBOL_OPC As String = "OPC"
189
190
    Public _DB_FITTINGS As String = "PipingComp"
191
    Public _DB_ACTUATORS As String = "Actuator"
192
    Public _DB_OPC As String = "OPC"
193
194
195
    'Public _OPC_Uid As String = "Uid"
196
    'Public _OPC_Location_X As String = "X"
197
    'Public _OPC_Location_Y As String = "Y"
198
    'Public _OPC_LineNo As String = "LineNo"
199
    'Public _OPC_Connection1_X As String = "Conn1_X"
200
    'Public _OPC_Connection1_Y As String = "Conn1_Y"
201
    'Public _OPC_Connection2_X As String = "Conn2_X"
202
    'Public _OPC_Connection2_Y As String = "Conn2_Y"
203
204
205
#Region "모델링 결과 데이터테이블"
206
207
    Public _Modeling_Uid As String = "Uid"
208
    Public _Modeling_Location_X As String = "X"
209
    Public _Modeling_Location_Y As String = "Y"
210
    Public _Modeling_Type As String = "Type"
211
    Public _Modeling_LineNoUid As String = "LineNoUid"
212
    Public _Modeling_Angle As String = "Angle"
213
    Public _Modeling_Connection1_X As String = "Conn1_X"
214
    Public _Modeling_Connection1_Y As String = "Conn1_Y"
215
    Public _Modeling_Connection2_X As String = "Conn2_X"
216
    Public _Modeling_Connection2_Y As String = "Conn2_Y"
217
    Public _Modeling_Connection3_X As String = "Conn3_X"
218
    Public _Modeling_Connection3_Y As String = "Conn3_Y"
219
    Public _Modeling_Connection4_X As String = "Conn4_X"
220
    Public _Modeling_Connection4_Y As String = "Conn4_Y"
221
    '    Public _Modeling_ConnType As String = "LMConnector"
222
    Public _Modeling_SPID As String = "SPID"
223
    'Public _Modeling_LMSymbol As String = "LMSymbol"
224
    'Public _Modeling_LMConnector As String = "ConnectType"
225
226
#End Region
227
228
#Region "Gembox Key"
229
    Public _Sheet_Equipment As String = "Equipment"
230
    Public _Sheet_EquipmentComponents As String = "Equipment Components"
231
    Public _Sheet_Instrumentation As String = "Instrumentation"
232
    Public _Sheet_Piping As String = "Piping"
233
    Public _Column_ImageSymbol As String = "Img_SymbolName"
234
235
    Public _Column_Index As String = "Index"
236
237
    Public _Sheet_ImageSymbol As String = "ImageSymbol"
238
239
    Public _Sheet_ImageSymbol_StartCell As String = "StartCell"
240
    Public _Sheet_ImageSymbol_EndCell As String = "EndCell"
241
    Public _Sheet_ImageSymbol_Type As String = "Type"
242
243
244
    Public _TempPath As String = Path.GetTempPath()
245
246
247
    Public _TempExcel As Object
248
    Public _TempFileName As String = ""
249
250
#End Region
251
252
253
#Region "Log"
254
    Public _Log_File As String = ""
255
    Public _Log_Path As String = System.Reflection.Assembly.GetExecutingAssembly().Location.Replace("SPPIDConverter.exe", "")
256
257
#End Region
258
End Module
클립보드 이미지 추가 (최대 크기: 500 MB)