hytos / DTI_PID / SPPIDConverter / MKey.vb @ a31687ed
이력 | 보기 | 이력해설 | 다운로드 (12.2 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 | 76f465d0 | Gyusu | Public _XML_CATEGORY_MERGEDLINE As String = "MERGEDLINE" |
45 | 6ba3e887 | Gyusu | 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 | e6ef24be | gaqhf | Public _XML_SYMBOLS As String = "SYMBOLS" |
68 | |||
69 | Public _XML_SYMBOLS_SYMBOL As String = "SYMBOL" |
||
70 | |||
71 | Public _XML_SYMBOLS_SYMBOL_UID As String = "UID" |
||
72 | |||
73 | Public _XML_SYMBOLS_SYMBOL_NAME As String = "NAME" |
||
74 | |||
75 | Public _XML_SYMBOLS_SYMBOL_TYPE As String = "TYPE" |
||
76 | |||
77 | Public _XML_SYMBOLS_SYMBOL_ORIGINALPOINT As String = "ORIGINALPOINT" |
||
78 | |||
79 | Public _XML_SYMBOLS_SYMBOL_LOCATION As String = "LOCATION" |
||
80 | |||
81 | Public _XML_SYMBOLS_SYMBOL_SIZE As String = "SIZE" |
||
82 | |||
83 | Public _XML_SYMBOLS_SYMBOL_ANGLE As String = "ANGLE" |
||
84 | |||
85 | Public _XML_SYMBOLS_SYMBOL_PARENT As String = "PARENT" |
||
86 | |||
87 | Public _XML_SYMBOLS_SYMBOL_CHILD As String = "CHILD" |
||
88 | |||
89 | Public _XML_SYMBOLS_SYMBOL_HASINSTRUMENTLABEL As String = "HASINSTRUMENTLABEL" |
||
90 | |||
91 | Public _XML_SYMBOLS_SYMBOL_AREA As String = "AREA" |
||
92 | |||
93 | Public _XML_SYMBOLS_SYMBOL_CURRENTPOINTMODEINDEX As String = "CURRENTPOINTMODEINDEX" |
||
94 | |||
95 | Public _XML_LINENOS As String = "LINENOS" |
||
96 | |||
97 | Public _XML_LINENOS_LINENO As String = "LINE_NO" |
||
98 | |||
99 | Public _XML_LINENOS_LINENO_UID As String = "UID" |
||
100 | |||
101 | Public _XML_TRIMLINENOS As String = "TRIMLINENOS" |
||
102 | |||
103 | Public _XML_TRIMLINENOS_TRIM_LINE_NO As String = "TRIM_LINE_NO" |
||
104 | |||
105 | Public _XML_LINEINFOS As String = "LINEINFOS" |
||
106 | |||
107 | Public _XML_LINEINFOS_LINE As String = "LINE" |
||
108 | |||
109 | Public _XML_LINEINFOS_LINE_UID As String = "UID" |
||
110 | |||
111 | Public _XML_RUN As String = "RUN" |
||
112 | |||
113 | Public _XML_RUN_SYMBOL As String = "SYMBOL" |
||
114 | |||
115 | Public _XML_RUN_LINE As String = "LINE" |
||
116 | |||
117 | |||
118 | Public _XML_LINEINFOS_LINE_STARTPOINT As String = "STARTPOINT" |
||
119 | |||
120 | Public _XML_LINEINFOS_LINE_ENDPOINT As String = "ENDPOINT" |
||
121 | |||
122 | Public _XML_LINEINFOS_LINE_TYPE As String = "TYPE" |
||
123 | |||
124 | Public _XML_LINEINFOS_LINE_AREA As String = "AREA" |
||
125 | |||
126 | Public _XML_CONNECTORS As String = "CONNECTORS" |
||
127 | |||
128 | Public _XML_CONNECTORS_CONNECTOR As String = "CONNECTOR" |
||
129 | |||
130 | Public _XML_CONNECTORS_CONNECTOR_CONNECTEDITEM As String = "CONNECTEDITEM" |
||
131 | |||
132 | Public _XML_CONNECTORS_CONNECTOR_CONNECTPOINT As String = "CONNECTPOINT" |
||
133 | |||
134 | Public _XML_CONNECTORS_CONNECTOR_SCENECONNECTPOINT As String = "SCENECONNECTPOINT" |
||
135 | |||
136 | 6ba3e887 | Gyusu | |
137 | Public _XML_EQP_UID As String = "UID" |
||
138 | |||
139 | Public _XML_EQP_TEXT As String = "TEXT" |
||
140 | |||
141 | Public _XML_EQP_LOCATION As String = "LOCATION" |
||
142 | |||
143 | Public _XML_EQP_ANGLE As String = "ANGLE" |
||
144 | |||
145 | Public _XML_EQP_SYSTEMPATH As String = "SYSTEMPATH" |
||
146 | |||
147 | |||
148 | |||
149 | |||
150 | Public _XML_LINE_UID As String = "UID" |
||
151 | Public _XML_LINE_LINENOUID As String = "LINENO_UID" |
||
152 | Public _XML_LINE_STARTPOINT_X As String = "start_x" |
||
153 | Public _XML_LINE_STARTPOINT_Y As String = "start_y" |
||
154 | Public _XML_LINE_ENDPOINT_X As String = "end_x" |
||
155 | Public _XML_LINE_ENDPOINT_Y As String = "end_y" |
||
156 | |||
157 | 76f465d0 | Gyusu | Public _XML_LINE_DWG_STARTPOINT_X As String = "dwg_start_x" |
158 | Public _XML_LINE_DWG_STARTPOINT_Y As String = "dwg_start_y" |
||
159 | Public _XML_LINE_DWG_ENDPOINT_X As String = "dwg_end_x" |
||
160 | Public _XML_LINE_DWG_ENDPOINT_Y As String = "dwg_end_y" |
||
161 | 6ba3e887 | Gyusu | |
162 | 76f465d0 | Gyusu | |
163 | Public _XML_LINE_STARTPOINT As String = "STARTPOINT" |
||
164 | 6ba3e887 | Gyusu | Public _XML_LINE_ENDPOINT As String = "ENDPOINT" |
165 | 76f465d0 | Gyusu | Public _XML_LINE_RUNNAME As String = "RUNNAME" |
166 | |||
167 | 6ba3e887 | Gyusu | |
168 | Public _XML_LINE_SPID As String = "SPID" |
||
169 | Public _XML_LINE_LMCONNECTOR As String = "LMCONNECTOR" |
||
170 | Public _XML_LINE_LMCONNECTOR_1 As String = "LMCONNECTOR_1" |
||
171 | Public _XML_LINE_LMCONNECTOR_2 As String = "LMCONNECTOR_2" |
||
172 | |||
173 | |||
174 | Public _XML_LINE_SYSTEMPATH As String = "SYSTEMPATH" |
||
175 | Public _XML_LINE_DRAWING_TF As String = "DRAWING" |
||
176 | Public _XML_LINE_TYPE As String = "TYPE" |
||
177 | Public _XML_LINE_Conn1_Uid As String = "Conn1_Uid" |
||
178 | Public _XML_LINE_Conn2_Uid As String = "Conn2_Uid" |
||
179 | Public _XML_LINE_CONNS As String = "CONNS" |
||
180 | 76f465d0 | Gyusu | Public _XML_LINE_Direction As String = "Direction" |
181 | 6ba3e887 | Gyusu | Public _XML_LINE_FlowDirection As String = "FlowDirection" |
182 | Public _XML_LINE_Length As String = "Length" |
||
183 | Public _XML_LINE_Check As String = "Check" |
||
184 | 76f5e1a8 | Gyusu | Public _XML_LINE_ValieLine As String = "ValidLine" |
185 | 6ba3e887 | Gyusu | |
186 | Public _XML_SYMBOL_UID As String = "UID" |
||
187 | Public _XML_SYMBOL_LINENOUID As String = "LINENO_UID" |
||
188 | Public _XML_SYMBOL_NAME As String = "NAME" |
||
189 | 76f465d0 | Gyusu | Public _XML_SYMBOL_RUNNAME As String = "RUNNAME" |
190 | 6ba3e887 | Gyusu | Public _XML_SYMBOL_LOCATION As String = "LOCATION" |
191 | |||
192 | Public _XML_SYMBOL_ORIGINALPOINT As String = "ORIGINALPOINT" |
||
193 | 76f465d0 | Gyusu | Public _XML_SYMBOL_CENTERPOINT_X As String = "Center_x" |
194 | Public _XML_SYMBOL_CENTERPOINT_Y As String = "Center_y" |
||
195 | Public _XML_SYMBOL_DWG_CENTERPOINT_X As String = "Dwg_Center_x" |
||
196 | Public _XML_SYMBOL_DWG_CENTERPOINT_Y As String = "Dwg_Center_y" |
||
197 | 6ba3e887 | Gyusu | |
198 | Public _XML_SYMBOL_SIZE As String = "SIZE" |
||
199 | Public _XML_SYMBOL_ANGLE As String = "ANGLE" |
||
200 | Public _XML_SYMBOL_SPID As String = "SPID" |
||
201 | Public _XML_SYMBOL_TYPE As String = "TYPE" |
||
202 | Public _XML_SYMBOL_DRAWING_TF As String = "DRAWING" |
||
203 | Public _XML_SYMBOL_CLASS As String = "CLASS" |
||
204 | Public _XML_SYMBOL_PARENT As String = "PARENT" |
||
205 | Public _XML_SYMBOL_SYSTEMPATH As String = "SYSTEMPATH" |
||
206 | Public _XML_SYMBOL_CONNECTIONPOINT As String = "CONNECTIONPOINT" |
||
207 | Public _XML_SYMBOL_CONNS As String = "CONNS" |
||
208 | Public _XML_SYMBOL_Check As String = "Check" |
||
209 | Public _XML_SYMBOL_Conn1_Uid As String = "Conn1_Uid" |
||
210 | Public _XML_SYMBOL_Conn2_Uid As String = "Conn2_Uid" |
||
211 | Public _XML_SYMBOL_Conn3_Uid As String = "Conn3_Uid" |
||
212 | Public _XML_SYMBOL_Conn4_Uid As String = "Conn4_Uid" |
||
213 | Public _XML_SYMBOL_Conn_Count As String = "Conn_Count" |
||
214 | 76f465d0 | Gyusu | Public _XML_SYMBOL_LMSYMBOL As String = "LMSYMBOL" |
215 | 6ba3e887 | Gyusu | Public _XML_SYMBOL_LMCONNECTOR_1 As String = "LMCONNECTOR_1" |
216 | Public _XML_SYMBOL_LMCONNECTOR_2 As String = "LMCONNECTOR_2" |
||
217 | Public _XML_SYMBOL_LMCONNECTOR_3 As String = "LMCONNECTOR_3" |
||
218 | Public _XML_SYMBOL_LMCONNECTOR_4 As String = "LMCONNECTOR_4" |
||
219 | |||
220 | f291ddcb | Gyusu | Public _XML_SYMBOL_OWNER As String = "OWNER" |
221 | |||
222 | |||
223 | 6ba3e887 | Gyusu | Public _XML_SYMBOL_Conn1_Point As String = "Conn1_Point" |
224 | Public _XML_SYMBOL_Conn2_Point As String = "Conn2_Point" |
||
225 | Public _XML_SYMBOL_Conn3_Point As String = "Conn3_Point" |
||
226 | Public _XML_SYMBOL_Conn4_Point As String = "Conn4_Point" |
||
227 | |||
228 | 76f465d0 | Gyusu | Public _XML_SYMBOL_CONN1_POINT_X As String = "Conn1_Point_x" |
229 | Public _XML_SYMBOL_CONN1_POINT_Y As String = "Conn1_Point_y" |
||
230 | Public _XML_SYMBOL_CONN2_POINT_X As String = "Conn2_Point_x" |
||
231 | Public _XML_SYMBOL_CONN2_POINT_Y As String = "Conn2_Point_y" |
||
232 | Public _XML_SYMBOL_CONN3_POINT_X As String = "Conn3_Point_x" |
||
233 | Public _XML_SYMBOL_CONN3_POINT_Y As String = "Conn3_Point_y" |
||
234 | Public _XML_SYMBOL_CONN4_POINT_X As String = "Conn4_Point_x" |
||
235 | Public _XML_SYMBOL_CONN4_POINT_Y As String = "Conn4_Point_y" |
||
236 | |||
237 | Public _XML_SYMBOL_DWG_CONN1_POINT_X As String = "Dwg_Conn1_Point_x" |
||
238 | Public _XML_SYMBOL_DWG_CONN1_POINT_Y As String = "Dwg_Conn1_Point_y" |
||
239 | Public _XML_SYMBOL_DWG_CONN2_POINT_X As String = "Dwg_Conn2_Point_x" |
||
240 | Public _XML_SYMBOL_DWG_CONN2_POINT_Y As String = "Dwg_Conn2_Point_y" |
||
241 | Public _XML_SYMBOL_DWG_CONN3_POINT_X As String = "Dwg_Conn3_Point_x" |
||
242 | Public _XML_SYMBOL_DWG_CONN3_POINT_Y As String = "Dwg_Conn3_Point_y" |
||
243 | Public _XML_SYMBOL_DWG_CONN4_POINT_X As String = "Dwg_Conn4_Point_x" |
||
244 | Public _XML_SYMBOL_DWG_CONN4_POINT_Y As String = "Dwg_Conn4_Point_y" |
||
245 | 6ba3e887 | Gyusu | |
246 | e38f99a7 | Gyusu | Public _XML_SYMBOL_MIN_X As String = "min_x" |
247 | Public _XML_SYMBOL_MIN_Y As String = "min_y" |
||
248 | Public _XML_SYMBOL_MAX_X As String = "max_x" |
||
249 | Public _XML_SYMBOL_MAX_Y As String = "max_y" |
||
250 | |||
251 | |||
252 | 9c86a823 | Gyusu | Public _XML_SYMBOL_CHILD As String = "CHILD" |
253 | |||
254 | 6ba3e887 | Gyusu | Public _XML_ATTRIBUTE_UID As String = "UID" |
255 | |||
256 | Public _XML_ATTRIBUTE_NAME As String = "NAME" |
||
257 | |||
258 | Public _XML_ATTRIBUTE_VALUE As String = "VALUE" |
||
259 | |||
260 | Public _XML_MODELING_UID As String = "UID" |
||
261 | |||
262 | Public _XML_MODELING_NAME As String = "NAME" |
||
263 | |||
264 | Public _XML_MODELING_PIPELINE As String = "LINENO" |
||
265 | |||
266 | Public _XML_MODELING_DWG As String = "DWGNAME" |
||
267 | |||
268 | Public _XML_MODELING_SYSTEMPATH As String = "SYSTEMPATH" |
||
269 | |||
270 | |||
271 | Public _SYMBOL_VALVES As String = "VALVES" |
||
272 | |||
273 | Public _SYMBOL_FITTINGS As String = "FITTINGS" |
||
274 | |||
275 | Public _SYMBOL_INSTUMENT As String = "Instrument" |
||
276 | |||
277 | Public _SYMBOL_ACTUATORS As String = "ACTUATORS" |
||
278 | |||
279 | Public _SYMBOL_OPC As String = "OPC" |
||
280 | |||
281 | Public _DB_FITTINGS As String = "PipingComp" |
||
282 | Public _DB_ACTUATORS As String = "Actuator" |
||
283 | Public _DB_OPC As String = "OPC" |
||
284 | |||
285 | |||
286 | 'Public _OPC_Uid As String = "Uid" |
||
287 | 'Public _OPC_Location_X As String = "X" |
||
288 | 'Public _OPC_Location_Y As String = "Y" |
||
289 | 'Public _OPC_LineNo As String = "LineNo" |
||
290 | 'Public _OPC_Connection1_X As String = "Conn1_X" |
||
291 | 'Public _OPC_Connection1_Y As String = "Conn1_Y" |
||
292 | 'Public _OPC_Connection2_X As String = "Conn2_X" |
||
293 | 'Public _OPC_Connection2_Y As String = "Conn2_Y" |
||
294 | |||
295 | |||
296 | #Region "모델링 결과 데이터테이블" |
||
297 | |||
298 | Public _Modeling_Uid As String = "Uid" |
||
299 | Public _Modeling_Location_X As String = "X" |
||
300 | Public _Modeling_Location_Y As String = "Y" |
||
301 | Public _Modeling_Type As String = "Type" |
||
302 | Public _Modeling_LineNoUid As String = "LineNoUid" |
||
303 | Public _Modeling_Angle As String = "Angle" |
||
304 | Public _Modeling_Connection1_X As String = "Conn1_X" |
||
305 | Public _Modeling_Connection1_Y As String = "Conn1_Y" |
||
306 | Public _Modeling_Connection2_X As String = "Conn2_X" |
||
307 | Public _Modeling_Connection2_Y As String = "Conn2_Y" |
||
308 | Public _Modeling_Connection3_X As String = "Conn3_X" |
||
309 | Public _Modeling_Connection3_Y As String = "Conn3_Y" |
||
310 | Public _Modeling_Connection4_X As String = "Conn4_X" |
||
311 | Public _Modeling_Connection4_Y As String = "Conn4_Y" |
||
312 | ' Public _Modeling_ConnType As String = "LMConnector" |
||
313 | Public _Modeling_SPID As String = "SPID" |
||
314 | 'Public _Modeling_LMSymbol As String = "LMSymbol" |
||
315 | 'Public _Modeling_LMConnector As String = "ConnectType" |
||
316 | |||
317 | #End Region |
||
318 | |||
319 | #Region "Gembox Key" |
||
320 | Public _Sheet_Equipment As String = "Equipment" |
||
321 | Public _Sheet_EquipmentComponents As String = "Equipment Components" |
||
322 | Public _Sheet_Instrumentation As String = "Instrumentation" |
||
323 | Public _Sheet_Piping As String = "Piping" |
||
324 | Public _Column_ImageSymbol As String = "Img_SymbolName" |
||
325 | |||
326 | Public _Column_Index As String = "Index" |
||
327 | |||
328 | Public _Sheet_ImageSymbol As String = "ImageSymbol" |
||
329 | |||
330 | Public _Sheet_ImageSymbol_StartCell As String = "StartCell" |
||
331 | Public _Sheet_ImageSymbol_EndCell As String = "EndCell" |
||
332 | Public _Sheet_ImageSymbol_Type As String = "Type" |
||
333 | |||
334 | |||
335 | Public _TempPath As String = Path.GetTempPath() |
||
336 | |||
337 | |||
338 | Public _TempExcel As Object |
||
339 | Public _TempFileName As String = "" |
||
340 | |||
341 | #End Region |
||
342 | |||
343 | |||
344 | #Region "Log" |
||
345 | Public _Log_File As String = "" |
||
346 | Public _Log_Path As String = System.Reflection.Assembly.GetExecutingAssembly().Location.Replace("SPPIDConverter.exe", "") |
||
347 | |||
348 | #End Region |
||
349 | End Module |