프로젝트

일반

사용자정보

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

hytos / DTI_PID / SPPIDConverter / ConverterDocking.cs @ 1299077b

이력 | 보기 | 이력해설 | 다운로드 (13 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
            DependencyObject aa = application.ActiveSelectSet[0] as DependencyObject;
217
            double mx = 0;
218
            double my = 0;
219
            double x = 0;
220
            double y = 0;
221
            aa.Range(out mx, out my, out x, out y);
222

    
223

    
224
            return;
225
            Thread outThread = new Thread(func2 =>
226
            {
227
                for (int i = 100; i < 120; i++)
228
                {
229
                    Thread thread = new Thread(func =>
230
                    {
231
                        dynamic application = Interaction.GetObject("", "PIDAutomation.Application");
232
                        //WrapperApplication wApp = new WrapperApplication(application.Application);
233
                        //Ingr.RAD2D.Application radApp = wApp.RADApplication;
234
                        dynamic drawing = application.Drawings.Add("Unit1", "D-Size.pid", i.ToString(), i.ToString());//application.Drawings.OpenDrawing("123");
235

    
236
                        Thread.Sleep(5000);
237

    
238
                        drawing.CloseDrawing(true);
239

    
240
                        //application.Quit();
241
                        ReleaseCOMObjects(application);
242
                        application = null;
243
                        ReleaseCOMObjects(drawing);
244
                        drawing = null;
245
                        Thread.Sleep(5000);
246
                    });
247
                    thread.Start();
248
                    thread.Join();
249
                }
250
            });
251
            outThread.Start();
252
            
253
            
254

    
255

    
256

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

    
259
            //radApp.ActiveDocument.Close(true);
260
            //drawing.CloseDrawing(true);
261

    
262
            //ReleaseCOMObjects(application);
263
            //ReleaseCOMObjects(drawing);
264
            //application = null;
265
            //wApp = null;
266
            //radApp = null;
267
            //drawing = null;
268
        }
269

    
270
        private void AutoJoinPipeRun()
271
        {
272
            dynamic application = Interaction.GetObject("", "PIDAutomation.Application");
273
            WrapperApplication wApp = new WrapperApplication(application.Application);
274
            Ingr.RAD2D.Application radApp = wApp.RADApplication;
275

    
276
            string modelItemId = null;
277
            List<double[]> vertices = new List<double[]>();
278
            if (radApp.ActiveSelectSet.Count == 0)
279
            {
280
                return;
281
            }
282
            dynamic OID = radApp.ActiveSelectSet[0].Key();
283
            DependencyObject drawingObject = radApp.ActiveDocument.ActiveSheet.DrawingObjects[OID];
284
            foreach (var attributes in drawingObject.AttributeSets)
285
            {
286
                foreach (var attribute in attributes)
287
                {
288
                    if (attribute.Name == "ModelID")
289
                        modelItemId = attribute.GetValue().ToString();
290
                }
291
            }
292
            radApp.ActiveSelectSet.RemoveAll();
293

    
294
        }
295
        #endregion
296

    
297

    
298
        [DllImport("user32.dll")]
299
        public static extern int FindWindow(string lpClassName, string lpWindowName);
300

    
301
        [DllImport("user32.dll", SetLastError = true)]
302
        static extern int GetWindowThreadProcessId(IntPtr hWnd, out int processId);
303

    
304
        private void ConverterDocking_Load(object sender, EventArgs e)
305
        {
306
#if DEBUG
307
            this.layoutControlItem2.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;
308
#else
309
            this.layoutControlItem2.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;
310
#endif
311

    
312
        }
313
    }
314
}
클립보드 이미지 추가 (최대 크기: 500 MB)