프로젝트

일반

사용자정보

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

hytos / DTI_PID / SPPIDConverter / MKey.vb @ 0e6bd93a

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

1
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
    Public _XML_CATEGORY_MERGEDLINE As String = "MERGEDLINE"
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
    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
    Public _XML_TEXTINFOS As String = "TEXTINFOS"
118

    
119
    Public _XML_LINEINFOS_LINE_STARTPOINT As String = "STARTPOINT"
120

    
121
    Public _XML_LINEINFOS_LINE_ENDPOINT As String = "ENDPOINT"
122

    
123
    Public _XML_LINEINFOS_LINE_TYPE As String = "TYPE"
124

    
125
    Public _XML_LINEINFOS_LINE_AREA As String = "AREA"
126

    
127
    Public _XML_CONNECTORS As String = "CONNECTORS"
128

    
129
    Public _XML_CONNECTORS_CONNECTOR As String = "CONNECTOR"
130

    
131
    Public _XML_CONNECTORS_CONNECTOR_CONNECTEDITEM As String = "CONNECTEDITEM"
132

    
133
    Public _XML_CONNECTORS_CONNECTOR_CONNECTPOINT As String = "CONNECTPOINT"
134

    
135
    Public _XML_CONNECTORS_CONNECTOR_SCENECONNECTPOINT As String = "SCENECONNECTPOINT"
136

    
137

    
138
    Public _XML_EQP_UID As String = "UID"
139

    
140
    Public _XML_EQP_TEXT As String = "TEXT"
141

    
142
    Public _XML_EQP_LOCATION As String = "LOCATION"
143

    
144
    Public _XML_EQP_ANGLE As String = "ANGLE"
145

    
146
    Public _XML_EQP_SYSTEMPATH As String = "SYSTEMPATH"
147

    
148

    
149

    
150

    
151
    Public _XML_LINE_UID As String = "UID"
152
    Public _XML_LINE_LINENOUID As String = "LINENO_UID"
153
    Public _XML_LINE_STARTPOINT_X As String = "start_x"
154
    Public _XML_LINE_STARTPOINT_Y As String = "start_y"
155
    Public _XML_LINE_ENDPOINT_X As String = "end_x"
156
    Public _XML_LINE_ENDPOINT_Y As String = "end_y"
157

    
158
    Public _XML_LINE_DWG_STARTPOINT_X As String = "dwg_start_x"
159
    Public _XML_LINE_DWG_STARTPOINT_Y As String = "dwg_start_y"
160
    Public _XML_LINE_DWG_ENDPOINT_X As String = "dwg_end_x"
161
    Public _XML_LINE_DWG_ENDPOINT_Y As String = "dwg_end_y"
162

    
163

    
164
    Public _XML_LINE_STARTPOINT As String = "STARTPOINT"
165
    Public _XML_LINE_ENDPOINT As String = "ENDPOINT"
166
    Public _XML_LINE_RUNNAME As String = "RUNNAME"
167

    
168

    
169
    Public _XML_LINE_SPID As String = "SPID"
170
    Public _XML_LINE_LMCONNECTOR As String = "LMCONNECTOR"
171
    Public _XML_LINE_LMCONNECTOR_1 As String = "LMCONNECTOR_1"
172
    Public _XML_LINE_LMCONNECTOR_2 As String = "LMCONNECTOR_2"
173

    
174

    
175
    Public _XML_LINE_SYSTEMPATH As String = "SYSTEMPATH"
176
    Public _XML_LINE_DRAWING_TF As String = "DRAWING"
177
    Public _XML_LINE_TYPE As String = "TYPE"
178
    Public _XML_LINE_Conn1_Uid As String = "Conn1_Uid"
179
    Public _XML_LINE_Conn2_Uid As String = "Conn2_Uid"
180
    Public _XML_LINE_CONNS As String = "CONNS"
181
    Public _XML_LINE_Direction As String = "Direction"
182
    Public _XML_LINE_FlowDirection As String = "FlowDirection"
183
    Public _XML_LINE_Length As String = "Length"
184
    Public _XML_LINE_Check As String = "Check"
185
    Public _XML_LINE_ValieLine As String = "ValidLine"
186

    
187
    Public _XML_SYMBOL_UID As String = "UID"
188
    Public _XML_SYMBOL_LINENOUID As String = "LINENO_UID"
189
    Public _XML_SYMBOL_NAME As String = "NAME"
190
    Public _XML_SYMBOL_RUNNAME As String = "RUNNAME"
191
    Public _XML_SYMBOL_LOCATION As String = "LOCATION"
192

    
193
    Public _XML_SYMBOL_ORIGINALPOINT As String = "ORIGINALPOINT"
194
    Public _XML_SYMBOL_CENTERPOINT_X As String = "Center_x"
195
    Public _XML_SYMBOL_CENTERPOINT_Y As String = "Center_y"
196
    Public _XML_SYMBOL_DWG_CENTERPOINT_X As String = "Dwg_Center_x"
197
    Public _XML_SYMBOL_DWG_CENTERPOINT_Y As String = "Dwg_Center_y"
198

    
199
    Public _XML_SYMBOL_SIZE As String = "SIZE"
200
    Public _XML_SYMBOL_ANGLE As String = "ANGLE"
201
    Public _XML_SYMBOL_SPID As String = "SPID"
202
    Public _XML_SYMBOL_TYPE As String = "TYPE"
203
    Public _XML_SYMBOL_DRAWING_TF As String = "DRAWING"
204
    Public _XML_SYMBOL_CLASS As String = "CLASS"
205
    Public _XML_SYMBOL_PARENT As String = "PARENT"
206
    Public _XML_SYMBOL_SYSTEMPATH As String = "SYSTEMPATH"
207
    Public _XML_SYMBOL_CONNECTIONPOINT As String = "CONNECTIONPOINT"
208
    Public _XML_SYMBOL_CONNS As String = "CONNS"
209
    Public _XML_SYMBOL_Check As String = "Check"
210
    Public _XML_SYMBOL_Conn1_Uid As String = "Conn1_Uid"
211
    Public _XML_SYMBOL_Conn2_Uid As String = "Conn2_Uid"
212
    Public _XML_SYMBOL_Conn3_Uid As String = "Conn3_Uid"
213
    Public _XML_SYMBOL_Conn4_Uid As String = "Conn4_Uid"
214
    Public _XML_SYMBOL_Conn_Count As String = "Conn_Count"
215
    Public _XML_SYMBOL_LMSYMBOL As String = "LMSYMBOL"
216
    Public _XML_SYMBOL_LMCONNECTOR_1 As String = "LMCONNECTOR_1"
217
    Public _XML_SYMBOL_LMCONNECTOR_2 As String = "LMCONNECTOR_2"
218
    Public _XML_SYMBOL_LMCONNECTOR_3 As String = "LMCONNECTOR_3"
219
    Public _XML_SYMBOL_LMCONNECTOR_4 As String = "LMCONNECTOR_4"
220

    
221
    Public _XML_SYMBOL_OWNER As String = "OWNER"
222

    
223

    
224
    Public _XML_SYMBOL_Conn1_Point As String = "Conn1_Point"
225
    Public _XML_SYMBOL_Conn2_Point As String = "Conn2_Point"
226
    Public _XML_SYMBOL_Conn3_Point As String = "Conn3_Point"
227
    Public _XML_SYMBOL_Conn4_Point As String = "Conn4_Point"
228

    
229
    Public _XML_SYMBOL_CONN1_POINT_X As String = "Conn1_Point_x"
230
    Public _XML_SYMBOL_CONN1_POINT_Y As String = "Conn1_Point_y"
231
    Public _XML_SYMBOL_CONN2_POINT_X As String = "Conn2_Point_x"
232
    Public _XML_SYMBOL_CONN2_POINT_Y As String = "Conn2_Point_y"
233
    Public _XML_SYMBOL_CONN3_POINT_X As String = "Conn3_Point_x"
234
    Public _XML_SYMBOL_CONN3_POINT_Y As String = "Conn3_Point_y"
235
    Public _XML_SYMBOL_CONN4_POINT_X As String = "Conn4_Point_x"
236
    Public _XML_SYMBOL_CONN4_POINT_Y As String = "Conn4_Point_y"
237

    
238
    Public _XML_SYMBOL_DWG_CONN1_POINT_X As String = "Dwg_Conn1_Point_x"
239
    Public _XML_SYMBOL_DWG_CONN1_POINT_Y As String = "Dwg_Conn1_Point_y"
240
    Public _XML_SYMBOL_DWG_CONN2_POINT_X As String = "Dwg_Conn2_Point_x"
241
    Public _XML_SYMBOL_DWG_CONN2_POINT_Y As String = "Dwg_Conn2_Point_y"
242
    Public _XML_SYMBOL_DWG_CONN3_POINT_X As String = "Dwg_Conn3_Point_x"
243
    Public _XML_SYMBOL_DWG_CONN3_POINT_Y As String = "Dwg_Conn3_Point_y"
244
    Public _XML_SYMBOL_DWG_CONN4_POINT_X As String = "Dwg_Conn4_Point_x"
245
    Public _XML_SYMBOL_DWG_CONN4_POINT_Y As String = "Dwg_Conn4_Point_y"
246

    
247
    Public _XML_SYMBOL_MIN_X As String = "min_x"
248
    Public _XML_SYMBOL_MIN_Y As String = "min_y"
249
    Public _XML_SYMBOL_MAX_X As String = "max_x"
250
    Public _XML_SYMBOL_MAX_Y As String = "max_y"
251

    
252

    
253
    Public _XML_SYMBOL_CHILD As String = "CHILD"
254

    
255
    Public _XML_ATTRIBUTE_UID As String = "UID"
256

    
257
    Public _XML_ATTRIBUTE_NAME As String = "NAME"
258

    
259
    Public _XML_ATTRIBUTE_VALUE As String = "VALUE"
260

    
261
    Public _XML_MODELING_UID As String = "UID"
262

    
263
    Public _XML_MODELING_NAME As String = "NAME"
264

    
265
    Public _XML_MODELING_PIPELINE As String = "LINENO"
266

    
267
    Public _XML_MODELING_DWG As String = "DWGNAME"
268

    
269
    Public _XML_MODELING_SYSTEMPATH As String = "SYSTEMPATH"
270

    
271

    
272
    Public _SYMBOL_VALVES As String = "VALVES"
273

    
274
    Public _SYMBOL_FITTINGS As String = "FITTINGS"
275

    
276
    Public _SYMBOL_INSTUMENT As String = "Instrument"
277

    
278
    Public _SYMBOL_ACTUATORS As String = "ACTUATORS"
279

    
280
    Public _SYMBOL_OPC As String = "OPC"
281

    
282
    Public _DB_FITTINGS As String = "PipingComp"
283
    Public _DB_ACTUATORS As String = "Actuator"
284
    Public _DB_OPC As String = "OPC"
285

    
286

    
287
    'Public _OPC_Uid As String = "Uid"
288
    'Public _OPC_Location_X As String = "X"
289
    'Public _OPC_Location_Y As String = "Y"
290
    'Public _OPC_LineNo As String = "LineNo"
291
    'Public _OPC_Connection1_X As String = "Conn1_X"
292
    'Public _OPC_Connection1_Y As String = "Conn1_Y"
293
    'Public _OPC_Connection2_X As String = "Conn2_X"
294
    'Public _OPC_Connection2_Y As String = "Conn2_Y"
295

    
296

    
297
#Region "모델링 결과 데이터테이블"
298

    
299
    Public _Modeling_Uid As String = "Uid"
300
    Public _Modeling_Location_X As String = "X"
301
    Public _Modeling_Location_Y As String = "Y"
302
    Public _Modeling_Type As String = "Type"
303
    Public _Modeling_LineNoUid As String = "LineNoUid"
304
    Public _Modeling_Angle As String = "Angle"
305
    Public _Modeling_Connection1_X As String = "Conn1_X"
306
    Public _Modeling_Connection1_Y As String = "Conn1_Y"
307
    Public _Modeling_Connection2_X As String = "Conn2_X"
308
    Public _Modeling_Connection2_Y As String = "Conn2_Y"
309
    Public _Modeling_Connection3_X As String = "Conn3_X"
310
    Public _Modeling_Connection3_Y As String = "Conn3_Y"
311
    Public _Modeling_Connection4_X As String = "Conn4_X"
312
    Public _Modeling_Connection4_Y As String = "Conn4_Y"
313
    '    Public _Modeling_ConnType As String = "LMConnector"
314
    Public _Modeling_SPID As String = "SPID"
315
    'Public _Modeling_LMSymbol As String = "LMSymbol"
316
    'Public _Modeling_LMConnector As String = "ConnectType"
317

    
318
#End Region
319

    
320
#Region "Gembox Key"
321
    Public _Sheet_Equipment As String = "Equipment"
322
    Public _Sheet_EquipmentComponents As String = "Equipment Components"
323
    Public _Sheet_Instrumentation As String = "Instrumentation"
324
    Public _Sheet_Piping As String = "Piping"
325
    Public _Column_ImageSymbol As String = "Img_SymbolName"
326

    
327
    Public _Column_Index As String = "Index"
328

    
329
    Public _Sheet_ImageSymbol As String = "ImageSymbol"
330

    
331
    Public _Sheet_ImageSymbol_StartCell As String = "StartCell"
332
    Public _Sheet_ImageSymbol_EndCell As String = "EndCell"
333
    Public _Sheet_ImageSymbol_Type As String = "Type"
334

    
335

    
336
    Public _TempPath As String = Path.GetTempPath()
337

    
338

    
339
    Public _TempExcel As Object
340
    Public _TempFileName As String = ""
341

    
342
#End Region
343

    
344

    
345
#Region "Log"
346
    Public _Log_File As String = ""
347
    Public _Log_Path As String = System.Reflection.Assembly.GetExecutingAssembly().Location.Replace("SPPIDConverter.exe", "")
348

    
349
#End Region
350
End Module