hytos / DTI_PID / SPPIDConverter / MKey.vb @ 6e10659e
이력 | 보기 | 이력해설 | 다운로드 (10.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 | |||
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 | 76f465d0 | Gyusu | Public _XML_LINE_DWG_STARTPOINT_X As String = "dwg_start_x" |
89 | Public _XML_LINE_DWG_STARTPOINT_Y As String = "dwg_start_y" |
||
90 | Public _XML_LINE_DWG_ENDPOINT_X As String = "dwg_end_x" |
||
91 | Public _XML_LINE_DWG_ENDPOINT_Y As String = "dwg_end_y" |
||
92 | 6ba3e887 | Gyusu | |
93 | 76f465d0 | Gyusu | |
94 | Public _XML_LINE_STARTPOINT As String = "STARTPOINT" |
||
95 | 6ba3e887 | Gyusu | Public _XML_LINE_ENDPOINT As String = "ENDPOINT" |
96 | 76f465d0 | Gyusu | Public _XML_LINE_RUNNAME As String = "RUNNAME" |
97 | |||
98 | 6ba3e887 | Gyusu | |
99 | Public _XML_LINE_SPID As String = "SPID" |
||
100 | Public _XML_LINE_LMCONNECTOR As String = "LMCONNECTOR" |
||
101 | Public _XML_LINE_LMCONNECTOR_1 As String = "LMCONNECTOR_1" |
||
102 | Public _XML_LINE_LMCONNECTOR_2 As String = "LMCONNECTOR_2" |
||
103 | |||
104 | |||
105 | Public _XML_LINE_SYSTEMPATH As String = "SYSTEMPATH" |
||
106 | Public _XML_LINE_DRAWING_TF As String = "DRAWING" |
||
107 | Public _XML_LINE_TYPE As String = "TYPE" |
||
108 | Public _XML_LINE_Conn1_Uid As String = "Conn1_Uid" |
||
109 | Public _XML_LINE_Conn2_Uid As String = "Conn2_Uid" |
||
110 | Public _XML_LINE_CONNS As String = "CONNS" |
||
111 | 76f465d0 | Gyusu | Public _XML_LINE_Direction As String = "Direction" |
112 | 6ba3e887 | Gyusu | Public _XML_LINE_FlowDirection As String = "FlowDirection" |
113 | Public _XML_LINE_Length As String = "Length" |
||
114 | Public _XML_LINE_Check As String = "Check" |
||
115 | 76f5e1a8 | Gyusu | Public _XML_LINE_ValieLine As String = "ValidLine" |
116 | 6ba3e887 | Gyusu | |
117 | Public _XML_SYMBOL_UID As String = "UID" |
||
118 | Public _XML_SYMBOL_LINENOUID As String = "LINENO_UID" |
||
119 | Public _XML_SYMBOL_NAME As String = "NAME" |
||
120 | 76f465d0 | Gyusu | Public _XML_SYMBOL_RUNNAME As String = "RUNNAME" |
121 | 6ba3e887 | Gyusu | Public _XML_SYMBOL_LOCATION As String = "LOCATION" |
122 | |||
123 | Public _XML_SYMBOL_ORIGINALPOINT As String = "ORIGINALPOINT" |
||
124 | 76f465d0 | Gyusu | Public _XML_SYMBOL_CENTERPOINT_X As String = "Center_x" |
125 | Public _XML_SYMBOL_CENTERPOINT_Y As String = "Center_y" |
||
126 | Public _XML_SYMBOL_DWG_CENTERPOINT_X As String = "Dwg_Center_x" |
||
127 | Public _XML_SYMBOL_DWG_CENTERPOINT_Y As String = "Dwg_Center_y" |
||
128 | 6ba3e887 | Gyusu | |
129 | Public _XML_SYMBOL_SIZE As String = "SIZE" |
||
130 | Public _XML_SYMBOL_ANGLE As String = "ANGLE" |
||
131 | Public _XML_SYMBOL_SPID As String = "SPID" |
||
132 | Public _XML_SYMBOL_TYPE As String = "TYPE" |
||
133 | Public _XML_SYMBOL_DRAWING_TF As String = "DRAWING" |
||
134 | Public _XML_SYMBOL_CLASS As String = "CLASS" |
||
135 | Public _XML_SYMBOL_PARENT As String = "PARENT" |
||
136 | Public _XML_SYMBOL_SYSTEMPATH As String = "SYSTEMPATH" |
||
137 | Public _XML_SYMBOL_CONNECTIONPOINT As String = "CONNECTIONPOINT" |
||
138 | Public _XML_SYMBOL_CONNS As String = "CONNS" |
||
139 | Public _XML_SYMBOL_Check As String = "Check" |
||
140 | Public _XML_SYMBOL_Conn1_Uid As String = "Conn1_Uid" |
||
141 | Public _XML_SYMBOL_Conn2_Uid As String = "Conn2_Uid" |
||
142 | Public _XML_SYMBOL_Conn3_Uid As String = "Conn3_Uid" |
||
143 | Public _XML_SYMBOL_Conn4_Uid As String = "Conn4_Uid" |
||
144 | Public _XML_SYMBOL_Conn_Count As String = "Conn_Count" |
||
145 | 76f465d0 | Gyusu | Public _XML_SYMBOL_LMSYMBOL As String = "LMSYMBOL" |
146 | 6ba3e887 | Gyusu | Public _XML_SYMBOL_LMCONNECTOR_1 As String = "LMCONNECTOR_1" |
147 | Public _XML_SYMBOL_LMCONNECTOR_2 As String = "LMCONNECTOR_2" |
||
148 | Public _XML_SYMBOL_LMCONNECTOR_3 As String = "LMCONNECTOR_3" |
||
149 | Public _XML_SYMBOL_LMCONNECTOR_4 As String = "LMCONNECTOR_4" |
||
150 | |||
151 | f291ddcb | Gyusu | Public _XML_SYMBOL_OWNER As String = "OWNER" |
152 | |||
153 | |||
154 | 6ba3e887 | Gyusu | Public _XML_SYMBOL_Conn1_Point As String = "Conn1_Point" |
155 | Public _XML_SYMBOL_Conn2_Point As String = "Conn2_Point" |
||
156 | Public _XML_SYMBOL_Conn3_Point As String = "Conn3_Point" |
||
157 | Public _XML_SYMBOL_Conn4_Point As String = "Conn4_Point" |
||
158 | |||
159 | 76f465d0 | Gyusu | Public _XML_SYMBOL_CONN1_POINT_X As String = "Conn1_Point_x" |
160 | Public _XML_SYMBOL_CONN1_POINT_Y As String = "Conn1_Point_y" |
||
161 | Public _XML_SYMBOL_CONN2_POINT_X As String = "Conn2_Point_x" |
||
162 | Public _XML_SYMBOL_CONN2_POINT_Y As String = "Conn2_Point_y" |
||
163 | Public _XML_SYMBOL_CONN3_POINT_X As String = "Conn3_Point_x" |
||
164 | Public _XML_SYMBOL_CONN3_POINT_Y As String = "Conn3_Point_y" |
||
165 | Public _XML_SYMBOL_CONN4_POINT_X As String = "Conn4_Point_x" |
||
166 | Public _XML_SYMBOL_CONN4_POINT_Y As String = "Conn4_Point_y" |
||
167 | |||
168 | Public _XML_SYMBOL_DWG_CONN1_POINT_X As String = "Dwg_Conn1_Point_x" |
||
169 | Public _XML_SYMBOL_DWG_CONN1_POINT_Y As String = "Dwg_Conn1_Point_y" |
||
170 | Public _XML_SYMBOL_DWG_CONN2_POINT_X As String = "Dwg_Conn2_Point_x" |
||
171 | Public _XML_SYMBOL_DWG_CONN2_POINT_Y As String = "Dwg_Conn2_Point_y" |
||
172 | Public _XML_SYMBOL_DWG_CONN3_POINT_X As String = "Dwg_Conn3_Point_x" |
||
173 | Public _XML_SYMBOL_DWG_CONN3_POINT_Y As String = "Dwg_Conn3_Point_y" |
||
174 | Public _XML_SYMBOL_DWG_CONN4_POINT_X As String = "Dwg_Conn4_Point_x" |
||
175 | Public _XML_SYMBOL_DWG_CONN4_POINT_Y As String = "Dwg_Conn4_Point_y" |
||
176 | 6ba3e887 | Gyusu | |
177 | e38f99a7 | Gyusu | Public _XML_SYMBOL_MIN_X As String = "min_x" |
178 | Public _XML_SYMBOL_MIN_Y As String = "min_y" |
||
179 | Public _XML_SYMBOL_MAX_X As String = "max_x" |
||
180 | Public _XML_SYMBOL_MAX_Y As String = "max_y" |
||
181 | |||
182 | |||
183 | 9c86a823 | Gyusu | Public _XML_SYMBOL_CHILD As String = "CHILD" |
184 | |||
185 | 6ba3e887 | Gyusu | Public _XML_ATTRIBUTE_UID As String = "UID" |
186 | |||
187 | Public _XML_ATTRIBUTE_NAME As String = "NAME" |
||
188 | |||
189 | Public _XML_ATTRIBUTE_VALUE As String = "VALUE" |
||
190 | |||
191 | Public _XML_MODELING_UID As String = "UID" |
||
192 | |||
193 | Public _XML_MODELING_NAME As String = "NAME" |
||
194 | |||
195 | Public _XML_MODELING_PIPELINE As String = "LINENO" |
||
196 | |||
197 | Public _XML_MODELING_DWG As String = "DWGNAME" |
||
198 | |||
199 | Public _XML_MODELING_SYSTEMPATH As String = "SYSTEMPATH" |
||
200 | |||
201 | |||
202 | Public _SYMBOL_VALVES As String = "VALVES" |
||
203 | |||
204 | Public _SYMBOL_FITTINGS As String = "FITTINGS" |
||
205 | |||
206 | Public _SYMBOL_INSTUMENT As String = "Instrument" |
||
207 | |||
208 | Public _SYMBOL_ACTUATORS As String = "ACTUATORS" |
||
209 | |||
210 | Public _SYMBOL_OPC As String = "OPC" |
||
211 | |||
212 | Public _DB_FITTINGS As String = "PipingComp" |
||
213 | Public _DB_ACTUATORS As String = "Actuator" |
||
214 | Public _DB_OPC As String = "OPC" |
||
215 | |||
216 | |||
217 | 'Public _OPC_Uid As String = "Uid" |
||
218 | 'Public _OPC_Location_X As String = "X" |
||
219 | 'Public _OPC_Location_Y As String = "Y" |
||
220 | 'Public _OPC_LineNo As String = "LineNo" |
||
221 | 'Public _OPC_Connection1_X As String = "Conn1_X" |
||
222 | 'Public _OPC_Connection1_Y As String = "Conn1_Y" |
||
223 | 'Public _OPC_Connection2_X As String = "Conn2_X" |
||
224 | 'Public _OPC_Connection2_Y As String = "Conn2_Y" |
||
225 | |||
226 | |||
227 | #Region "모델링 결과 데이터테이블" |
||
228 | |||
229 | Public _Modeling_Uid As String = "Uid" |
||
230 | Public _Modeling_Location_X As String = "X" |
||
231 | Public _Modeling_Location_Y As String = "Y" |
||
232 | Public _Modeling_Type As String = "Type" |
||
233 | Public _Modeling_LineNoUid As String = "LineNoUid" |
||
234 | Public _Modeling_Angle As String = "Angle" |
||
235 | Public _Modeling_Connection1_X As String = "Conn1_X" |
||
236 | Public _Modeling_Connection1_Y As String = "Conn1_Y" |
||
237 | Public _Modeling_Connection2_X As String = "Conn2_X" |
||
238 | Public _Modeling_Connection2_Y As String = "Conn2_Y" |
||
239 | Public _Modeling_Connection3_X As String = "Conn3_X" |
||
240 | Public _Modeling_Connection3_Y As String = "Conn3_Y" |
||
241 | Public _Modeling_Connection4_X As String = "Conn4_X" |
||
242 | Public _Modeling_Connection4_Y As String = "Conn4_Y" |
||
243 | ' Public _Modeling_ConnType As String = "LMConnector" |
||
244 | Public _Modeling_SPID As String = "SPID" |
||
245 | 'Public _Modeling_LMSymbol As String = "LMSymbol" |
||
246 | 'Public _Modeling_LMConnector As String = "ConnectType" |
||
247 | |||
248 | #End Region |
||
249 | |||
250 | #Region "Gembox Key" |
||
251 | Public _Sheet_Equipment As String = "Equipment" |
||
252 | Public _Sheet_EquipmentComponents As String = "Equipment Components" |
||
253 | Public _Sheet_Instrumentation As String = "Instrumentation" |
||
254 | Public _Sheet_Piping As String = "Piping" |
||
255 | Public _Column_ImageSymbol As String = "Img_SymbolName" |
||
256 | |||
257 | Public _Column_Index As String = "Index" |
||
258 | |||
259 | Public _Sheet_ImageSymbol As String = "ImageSymbol" |
||
260 | |||
261 | Public _Sheet_ImageSymbol_StartCell As String = "StartCell" |
||
262 | Public _Sheet_ImageSymbol_EndCell As String = "EndCell" |
||
263 | Public _Sheet_ImageSymbol_Type As String = "Type" |
||
264 | |||
265 | |||
266 | Public _TempPath As String = Path.GetTempPath() |
||
267 | |||
268 | |||
269 | Public _TempExcel As Object |
||
270 | Public _TempFileName As String = "" |
||
271 | |||
272 | #End Region |
||
273 | |||
274 | |||
275 | #Region "Log" |
||
276 | Public _Log_File As String = "" |
||
277 | Public _Log_Path As String = System.Reflection.Assembly.GetExecutingAssembly().Location.Replace("SPPIDConverter.exe", "") |
||
278 | |||
279 | #End Region |
||
280 | End Module |