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 |