프로젝트

일반

사용자정보

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

hytos / DTI_PID / SPPIDConverter / ConverterDocking.cs @ f28a350a

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

1
using System;
2
using System.Collections.Generic;
3
using System.ComponentModel;
4
using System.Drawing;
5
using System.Data;
6
using System.Linq;
7
using System.Text;
8
using System.Threading.Tasks;
9
using System.Windows.Forms;
10
using System.Threading;
11
using System.IO;
12
using Microsoft.VisualBasic;
13
using Ingr.RAD2D;
14
using Converter.BaseModel;
15
using Converter.SPPID.Properties;
16
using Converter.SPPID.DB;
17
using Converter.SPPID.Util;
18
using Converter.SPPID.Form;
19
using Converter.SPPID.Model;
20
using Plaice;
21
using Llama;
22
using DevExpress.XtraSplashScreen;
23
using Newtonsoft.Json;
24
using System.Runtime.InteropServices;
25
using System.Reflection;
26
using Converter.SPPID.OPC;
27

    
28
namespace Converter.SPPID.Wrapper
29
{
30
    public partial class ConverterDocking : UserControl
31
    {
32
        Ingr.RAD2D.Application application;
33
        public ConverterDocking()
34
        {
35
            InitializeComponent();
36

    
37
            dynamic dApplication = Interaction.GetObject("", "PIDAutomation.Application");
38
            WrapperApplication wApp = new WrapperApplication(dApplication.Application);
39
            application = wApp.RADApplication;
40
            
41
            ReleaseCOMObjects(dApplication);
42
            dApplication = null;
43
            try
44
            {
45
                textEditDrawingX.EditValue = Settings.Default.DrawingX;
46
                textEditDrawingY.EditValue = Settings.Default.DrawingY;
47

    
48
                Project_Info _ProjectInfo = Project_Info.GetInstance();
49
                _ProjectInfo.DefaultPath = Settings.Default.LatestProjectPath;
50
            }
51
            catch (Exception ex)
52
            {
53
                StringBuilder sb = new StringBuilder();
54
                sb.AppendLine(ex.Message);
55
                sb.AppendLine(ex.StackTrace);
56
                MessageBox.Show(sb.ToString());
57
            }
58
        }
59

    
60
        /// <summary>
61
        /// 선택한 도면들을 읽어서 SPPID로 변환한다.
62
        /// </summary>
63
        /// <param name="sender"></param>
64
        /// <param name="e"></param>
65
        private void btnConverter_Click(object sender, EventArgs e)
66
        {
67
            ConverterForm converterForm = new ConverterForm();
68
            if (converterForm.ShowDialog() == DialogResult.OK)
69
            {
70
                //Ingr.RAD2D.Document doc = application.Documents.Add();
71

    
72
                try
73
                {
74
                    CloseOPCForm.Run();
75

    
76
                    for (int i = 0; i < converterForm.Documents.Count; i++)
77
                    {
78
                        SPPID_Document document = converterForm.Documents[i];
79
                        if (document.SetSPPIDMapping() && document.Enable)
80
                        {
81
                            using (AutoModeling modeling = new AutoModeling(document, converterForm.checkEditCloseDocument.Checked))
82
                            {
83
                                modeling.DocumentLabelText = string.Format("Drawing Name : {0} ({1}/{2})", document.DrawingName, i + 1, converterForm.Documents.Count);
84
                                modeling.Run();
85
                            }
86
                        }
87
                    }
88
                }
89
                catch (Exception ex)
90
                {
91
                    MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace);
92
                }
93
                finally
94
                {
95
                    CloseOPCForm.Stop();
96

    
97
                    //doc.SaveOnClose = false;
98
                    //doc.Close(false);
99

    
100
                    //dynamic dApplication = Interaction.GetObject("", "PIDAutomation.Application");
101
                    //dApplication.Drawings[1].CloseDrawing(false);
102
                    //ReleaseCOMObjects(dApplication);
103
                    //dApplication = null;
104
                }
105

    
106
                MessageBox.Show(Msg.EndConvert, Msg.Information, MessageBoxButtons.OK, MessageBoxIcon.Information);
107
            }
108
        }
109

    
110
        private void btnLinkOPC_Click(object sender, EventArgs e)
111
        {
112
            DataTable tOPCInfo = Project_DB.SelectOPCInfo();
113
            DataTable tOPCRelations = Project_DB.SelectOPCRelations();
114
            DataTable tDrawingInfo = Project_DB.SelectDrawingInfo();
115
            dynamic dApplication = Interaction.GetObject("", "PIDAutomation.Application");
116

    
117
            foreach (DataRow row in tOPCInfo.Rows)
118
            {
119
                if (!Convert.ToBoolean(row["PAIRED"]))
120
                {
121
                    string drawingUID = row["ID2_DRAWING_UID"].ToString();
122
                    string OPCUID = row["ID2_OPC_UID"].ToString();
123
                    DataRow[] rows = tOPCRelations.Select(string.Format("(From_Drawings_UID = '{0}' AND From_OPC_UID = '{1}') OR (To_Drawings_UID = '{0}' AND To_OPC_UID = '{1}')", drawingUID, OPCUID));
124

    
125
                    if (rows.Length == 2)
126
                    {
127
                        string fromDrawingsUID1 = rows[0]["From_Drawings_UID"].ToString();
128
                        string fromDrawingsUID2 = rows[1]["From_Drawings_UID"].ToString();
129
                        string fromOPCUID1 = rows[0]["From_OPC_UID"].ToString();
130
                        string fromOPCUID2 = rows[1]["From_OPC_UID"].ToString();
131
                        string toDrawingsUID1 = rows[0]["To_Drawings_UID"].ToString();
132
                        string toDrawingsUID2 = rows[1]["To_Drawings_UID"].ToString();
133
                        string toOPCUID1 = rows[0]["To_OPC_UID"].ToString();
134
                        string toOPCUID2 = rows[1]["To_OPC_UID"].ToString();
135

    
136
                        DataRow[] fromDrawing = tDrawingInfo.Select(string.Format("ID2_DRAWING_UID = '{0}'", fromDrawingsUID1));
137
                        DataRow[] toDrawing = tDrawingInfo.Select(string.Format("ID2_DRAWING_UID = '{0}'", toDrawingsUID1));
138
                        DataRow[] fromOPCInfoRows = tOPCInfo.Select(string.Format("ID2_OPC_UID = '{0}'", fromOPCUID1));
139
                        DataRow[] toOPCInfoRows = tOPCInfo.Select(string.Format("ID2_OPC_UID = '{0}'", toOPCUID1));
140

    
141
                        if (fromOPCUID1 == toOPCUID2 && fromOPCUID2 == toOPCUID1 && fromDrawing.Length == 1 && toDrawing.Length == 1 && fromOPCInfoRows.Length == 1 && toOPCInfoRows.Length == 1)
142
                        {
143
                            DataRow fromOPCInfoRow = fromOPCInfoRows[0];
144
                            DataRow toOPCInfoRow = toOPCInfoRows[0];
145
                            string fromOPCModelId = fromOPCInfoRow["SPPID_OPC_MODELITEM_ID"].ToString();
146
                            string toOPCModelId = toOPCInfoRow["SPPID_OPC_MODELITEM_ID"].ToString();
147
                            string toDrawingName = toDrawing[0]["DRAWINGNAME"].ToString();
148
                            List<string[]> toOPCAttributes = JsonConvert.DeserializeObject<List<string[]>>(toOPCInfoRow["ATTRIBUTES"].ToString());
149
                            AutoModeling_OPC opc = new AutoModeling_OPC(dApplication, application, fromOPCModelId, toOPCModelId, toDrawingName, toOPCAttributes);
150
                            if (opc.Run())
151
                            {
152
                                fromOPCInfoRow["PAIRED"] = true;
153
                                toOPCInfoRow["PAIRED"] = true;
154

    
155
                                Project_DB.InsertOPCInfo(fromOPCInfoRow["ID2_OPC_UID"].ToString(), fromOPCInfoRow["SPPID_OPC_MODELITEM_ID"].ToString(), fromOPCInfoRow["ID2_DRAWING_UID"].ToString(), true);
156
                                Project_DB.InsertOPCInfo(toOPCInfoRow["ID2_OPC_UID"].ToString(), toOPCInfoRow["SPPID_OPC_MODELITEM_ID"].ToString(), toOPCInfoRow["ID2_DRAWING_UID"].ToString(), true);
157
                            }
158
                        }
159
                    }
160
                }
161
            }
162

    
163
            tOPCInfo.Dispose();
164
            tOPCRelations.Dispose();
165
            tDrawingInfo.Dispose();
166
            ReleaseCOMObjects(dApplication);
167
            dApplication = null;
168

    
169
            MessageBox.Show(Msg.EndConvert, Msg.Information, MessageBoxButtons.OK, MessageBoxIcon.Information);
170
        }
171

    
172
        public void ReleaseCOMObjects(params object[] objVars)
173
        {
174
            int intNewRefCount = 0;
175
            foreach (object obj in objVars)
176
            {
177
                if (!Information.IsNothing(obj) && System.Runtime.InteropServices.Marshal.IsComObject(obj))
178
                    intNewRefCount = intNewRefCount + System.Runtime.InteropServices.Marshal.FinalReleaseComObject(obj);
179
            }
180
        }
181

    
182
        private void btnGetDrawingSize_Click(object sender, EventArgs e)
183
        {
184
            dynamic application = Interaction.GetObject("", "PIDAutomation.Application");
185
            WrapperApplication wApp = new WrapperApplication(application.Application);
186
            Ingr.RAD2D.Application radApp = wApp.RADApplication;
187

    
188
            if (radApp.ActiveSelectSet.Count > 0)
189
            {
190
                DependencyObject line2D = radApp.ActiveSelectSet[0] as DependencyObject;
191
                if (line2D != null)
192
                {
193
                    double minX = 0;
194
                    double minY = 0;
195
                    double maxX = 0;
196
                    double maxY = 0;
197
                    line2D.Range(out minX, out minY, out maxX, out maxY);
198

    
199
                    Settings.Default.DrawingX = maxX - minX;
200
                    Settings.Default.DrawingY = maxY - minY;
201
                    Settings.Default.Save();
202

    
203
                    textEditDrawingX.EditValue = Settings.Default.DrawingX;
204
                    textEditDrawingY.EditValue = Settings.Default.DrawingY;
205
                }
206
                else
207
                    MessageBox.Show(Msg.SelectLine, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
208
            }
209
            else
210
                MessageBox.Show(Msg.SelectLine, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);
211
        }
212

    
213
        #region TEST
214
        private void simpleButton1_Click(object sender, EventArgs e)
215
        {
216
            foreach (RADObject item in application.ActiveDocument.SelectSet)
217
            {
218
                DependencyObject dependencyObject = item as DependencyObject;
219
                if (dependencyObject != null)
220
                {
221
                    double minX = 0;
222
                    double minY = 0;
223
                    double maxX = 0;
224
                    double maxY = 0;
225
                    dependencyObject.DrawingObjects[0].Range(out minX, out minY, out maxX, out maxY);
226
                }
227
                Symbol2d symbol2D = item as Symbol2d;
228
                if (symbol2D != null)
229
                {
230
                    double minX = 0;
231
                    double minY = 0;
232
                    double maxX = 0;
233
                    double maxY = 0;
234
                    symbol2D.Range(out minX, out minY, out maxX, out maxY);
235
                }
236
            }
237

    
238

    
239

    
240
            return;
241
            Thread outThread = new Thread(func2 =>
242
            {
243
                for (int i = 100; i < 120; i++)
244
                {
245
                    Thread thread = new Thread(func =>
246
                    {
247
                        dynamic application = Interaction.GetObject("", "PIDAutomation.Application");
248
                        //WrapperApplication wApp = new WrapperApplication(application.Application);
249
                        //Ingr.RAD2D.Application radApp = wApp.RADApplication;
250
                        dynamic drawing = application.Drawings.Add("Unit1", "D-Size.pid", i.ToString(), i.ToString());//application.Drawings.OpenDrawing("123");
251

    
252
                        Thread.Sleep(5000);
253

    
254
                        drawing.CloseDrawing(true);
255

    
256
                        //application.Quit();
257
                        ReleaseCOMObjects(application);
258
                        application = null;
259
                        ReleaseCOMObjects(drawing);
260
                        drawing = null;
261
                        Thread.Sleep(5000);
262
                    });
263
                    thread.Start();
264
                    thread.Join();
265
                }
266
            });
267
            outThread.Start();
268
            
269
            
270

    
271

    
272

    
273
            //radApp.Documents.Add(@"\\server70\DEVDOF1Site\GS\PLANT\PLANT1\Unit1\11111.pid");
274

    
275
            //radApp.ActiveDocument.Close(true);
276
            //drawing.CloseDrawing(true);
277

    
278
            //ReleaseCOMObjects(application);
279
            //ReleaseCOMObjects(drawing);
280
            //application = null;
281
            //wApp = null;
282
            //radApp = null;
283
            //drawing = null;
284
        }
285

    
286
        private void AutoJoinPipeRun()
287
        {
288
            dynamic application = Interaction.GetObject("", "PIDAutomation.Application");
289
            WrapperApplication wApp = new WrapperApplication(application.Application);
290
            Ingr.RAD2D.Application radApp = wApp.RADApplication;
291

    
292
            string modelItemId = null;
293
            List<double[]> vertices = new List<double[]>();
294
            if (radApp.ActiveSelectSet.Count == 0)
295
            {
296
                return;
297
            }
298
            dynamic OID = radApp.ActiveSelectSet[0].Key();
299
            DependencyObject drawingObject = radApp.ActiveDocument.ActiveSheet.DrawingObjects[OID];
300
            foreach (var attributes in drawingObject.AttributeSets)
301
            {
302
                foreach (var attribute in attributes)
303
                {
304
                    if (attribute.Name == "ModelID")
305
                        modelItemId = attribute.GetValue().ToString();
306
                }
307
            }
308
            radApp.ActiveSelectSet.RemoveAll();
309

    
310
        }
311
        #endregion
312

    
313

    
314
        [DllImport("user32.dll")]
315
        public static extern int FindWindow(string lpClassName, string lpWindowName);
316

    
317
        [DllImport("user32.dll", SetLastError = true)]
318
        static extern int GetWindowThreadProcessId(IntPtr hWnd, out int processId);
319

    
320
        private void ConverterDocking_Load(object sender, EventArgs e)
321
        {
322
#if DEBUG
323
            this.layoutControlItem2.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
324
#else
325
            this.layoutControlItem2.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
326
#endif
327

    
328
        }
329
    }
330
}
클립보드 이미지 추가 (최대 크기: 500 MB)