HYTOS

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Drawing;

using System.Data;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.Threading;

using System.IO;

using Microsoft.VisualBasic;

using Ingr.RAD2D;

using Converter.BaseModel;

using Converter.SPPID.Properties;

using Converter.SPPID.DB;

using Converter.SPPID.Util;

using Converter.SPPID.Form;

using Converter.SPPID.Model;

using Plaice;

using Llama;

using DevExpress.XtraSplashScreen;

using Newtonsoft.Json;

using System.Runtime.InteropServices;

using System.Reflection;

using Converter.SPPID.OPC;

namespace Converter.SPPID.Wrapper

{

    public partial class ConverterDocking : UserControl

    {

        Ingr.RAD2D.Application application;

        public ConverterDocking()

        {

            InitializeComponent();

            dynamic dApplication = Interaction.GetObject("", "PIDAutomation.Application");

            WrapperApplication wApp = new WrapperApplication(dApplication.Application);

            application = wApp.RADApplication;

            ReleaseCOMObjects(dApplication);

            dApplication = null;

            try

            {

                textEditDrawingX.EditValue = Settings.Default.DrawingX;

                textEditDrawingY.EditValue = Settings.Default.DrawingY;

                Project_Info _ProjectInfo = Project_Info.GetInstance();

                _ProjectInfo.DefaultPath = Settings.Default.LatestProjectPath;

            }

            catch (Exception ex)

            {

                StringBuilder sb = new StringBuilder();

                sb.AppendLine(ex.Message);

                sb.AppendLine(ex.StackTrace);

                MessageBox.Show(sb.ToString());

            }

        }

        /// <summary>

        /// 선택한 도면들을 읽어서 SPPID로 변환한다.

        /// </summary>

        /// <param name="sender"></param>

        /// <param name="e"></param>

        private void btnConverter_Click(object sender, EventArgs e)

        {

            ConverterForm converterForm = new ConverterForm();

            if (converterForm.ShowDialog() == DialogResult.OK)

            {

                //Ingr.RAD2D.Document doc = application.Documents.Add();

                try

                {

                    CloseOPCForm.Run();

                    for (int i = 0; i < converterForm.Documents.Count; i++)

                    {

                        SPPID_Document document = converterForm.Documents[i];

                        if (document.SetSPPIDMapping() && document.Enable)

                        {

                            using (AutoModeling modeling = new AutoModeling(document, converterForm.checkEditCloseDocument.Checked))

                            {

                                modeling.DocumentLabelText = string.Format("Drawing Name : {0} ({1}/{2})", document.DrawingName, i + 1, converterForm.Documents.Count);

                                modeling.Run();

                            }

                        }

                    }

                }

                catch (Exception ex)

                {

                    MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace);

                }

                finally

                {

                    CloseOPCForm.Stop();

                    //doc.SaveOnClose = false;

                    //doc.Close(false);

                    //dynamic dApplication = Interaction.GetObject("", "PIDAutomation.Application");

                    //dApplication.Drawings[1].CloseDrawing(false);

                    //ReleaseCOMObjects(dApplication);

                    //dApplication = null;

                }

                MessageBox.Show(Msg.EndConvert, Msg.Information, MessageBoxButtons.OK, MessageBoxIcon.Information);

            }

        }

        private void btnLinkOPC_Click(object sender, EventArgs e)

        {

            DataTable tOPCInfo = Project_DB.SelectOPCInfo();

            DataTable tOPCRelations = Project_DB.SelectOPCRelations();

            DataTable tDrawingInfo = Project_DB.SelectDrawingInfo();

            dynamic dApplication = Interaction.GetObject("", "PIDAutomation.Application");

            foreach (DataRow row in tOPCInfo.Rows)

            {

                if (!Convert.ToBoolean(row["PAIRED"]))

                {

                    string drawingUID = row["ID2_DRAWING_UID"].ToString();

                    string OPCUID = row["ID2_OPC_UID"].ToString();

                    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));

                    if (rows.Length == 2)

                    {

                        string fromDrawingsUID1 = rows[0]["From_Drawings_UID"].ToString();

                        string fromDrawingsUID2 = rows[1]["From_Drawings_UID"].ToString();

                        string fromOPCUID1 = rows[0]["From_OPC_UID"].ToString();

                        string fromOPCUID2 = rows[1]["From_OPC_UID"].ToString();

                        string toDrawingsUID1 = rows[0]["To_Drawings_UID"].ToString();

                        string toDrawingsUID2 = rows[1]["To_Drawings_UID"].ToString();

                        string toOPCUID1 = rows[0]["To_OPC_UID"].ToString();

                        string toOPCUID2 = rows[1]["To_OPC_UID"].ToString();

                        DataRow[] fromDrawing = tDrawingInfo.Select(string.Format("ID2_DRAWING_UID = '{0}'", fromDrawingsUID1));

                        DataRow[] toDrawing = tDrawingInfo.Select(string.Format("ID2_DRAWING_UID = '{0}'", toDrawingsUID1));

                        if (fromOPCUID1 == toOPCUID2 && fromOPCUID2 == toOPCUID1 && fromDrawing.Length == 1 && toDrawing.Length == 1)

                        {

                            DataRow fromOPCInfoRow = tOPCInfo.Select(string.Format("ID2_OPC_UID = '{0}'", fromOPCUID1))[0];

                            DataRow toOPCInfoRow = tOPCInfo.Select(string.Format("ID2_OPC_UID = '{0}'", toOPCUID1))[0];

                            string fromOPCModelId = fromOPCInfoRow["SPPID_OPC_MODELITEM_ID"].ToString();

                            string toOPCModelId = toOPCInfoRow["SPPID_OPC_MODELITEM_ID"].ToString();

                            string toDrawingName = toDrawing[0]["DRAWINGNAME"].ToString();

                            List<string[]> toOPCAttributes = JsonConvert.DeserializeObject<List<string[]>>(toOPCInfoRow["ATTRIBUTYES"].ToString());

                            AutoModeling_OPC opc = new AutoModeling_OPC(dApplication, application, fromOPCModelId, toOPCModelId, toDrawingName, toOPCAttributes);

                            if (opc.Run())

                            {

                                fromOPCInfoRow["PAIRED"] = true;

                                toOPCInfoRow["PAIRED"] = true;

                                Project_DB.InsertOPCInfo(fromOPCInfoRow["ID2_OPC_UID"].ToString(), fromOPCInfoRow["SPPID_OPC_MODELITEM_ID"].ToString(), fromOPCInfoRow["ID2_DRAWING_UID"].ToString(), true);

                                Project_DB.InsertOPCInfo(toOPCInfoRow["ID2_OPC_UID"].ToString(), toOPCInfoRow["SPPID_OPC_MODELITEM_ID"].ToString(), toOPCInfoRow["ID2_DRAWING_UID"].ToString(), true);

                            }

                            break;

                        }

                    }

                }

            }

            tOPCInfo.Dispose();

            tOPCRelations.Dispose();

            tDrawingInfo.Dispose();

            ReleaseCOMObjects(dApplication);

            dApplication = null;

            //dynamic application = Interaction.GetObject("", "PIDAutomation.Application");

            //WrapperApplication wApp = new WrapperApplication(application.Application);

            //Ingr.RAD2D.Application radApp = wApp.RADApplication;

            //LMADataSource dataSource = new LMADataSource();

            //LMDrawings drawings = new LMDrawings();

            ////try

            //{

            //    Project_Info _ProjectInfo = Project_Info.GetInstance();

            //    _ProjectInfo.DefaultPath = Settings.Default.LatestProjectPath;

            //    if (Project_DB.ConnTestAndCreateTable())

            //    {

            //        DataTable dt = Project_DB.SelectSPPID_DB_INFO();

            //        if (dt.Columns.Count > 0 && dt.Rows.Count > 0)

            //            SPPIDUtil.ConvertToSPPIDInfo(dt.Rows[0][0].ToString());

            //        else

            //            SPPID_DBInfo.Clear();

            //        SPPID_DBInfo sPPID_DBInfo = SPPID_DBInfo.GetInstance();

            //        if (sPPID_DBInfo.Enable)

            //        {

            //            drawings.Collect(dataSource);

            //            DataTable drawingTable = Project_DB.SelectDrawingInfo();

            //            drawingTable.Columns.Add("EXIST", typeof(bool));

            //            drawingTable.Columns.Add("SPPIDPATH", typeof(string));

            //            foreach (LMDrawing item in drawings)

            //            {

            //                DataRow[] rows = drawingTable.Select(string.Format("DRAWINGNUMBER = '{0}'", item.Attributes["DrawingNumber"].get_Value()));

            //                foreach (DataRow row in rows)

            //                {

            //                    row["EXIST"] = true;

            //                    row["DRAWINGNAME"] = item.Attributes["Name"].get_Value();

            //                    row["SPPIDPATH"] = item.get_Path();

            //                }

            //            }

            //            List<SPPID_Document> allDocuments = new List<SPPID_Document>();

            //            foreach (DataRow row in drawingTable.Rows)

            //                allDocuments.Add((SPPID_Document)row["DOCUMENT"]);

            //            AutoModeling_OPC opc = new AutoModeling_OPC(allDocuments, application, radApp);

            //            opc.Run();

            //        }

            //    }

            //    else

            //    {

            //        MessageBox.Show(Msg.ConnectionFail, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

            //    }

            //}

            ////catch (Exception ex)

            //{

            //    //MessageBox.Show(ex.Message + "\r\n" + ex.StackTrace);

            //}

            ////finally

            //{

            //    ReleaseCOMObjects(dataSource);

            //    ReleaseCOMObjects(drawings);

            //}

        }

        public void ReleaseCOMObjects(params object[] objVars)

        {

            int intNewRefCount = 0;

            foreach (object obj in objVars)

            {

                if (!Information.IsNothing(obj) && System.Runtime.InteropServices.Marshal.IsComObject(obj))

                    intNewRefCount = intNewRefCount + System.Runtime.InteropServices.Marshal.FinalReleaseComObject(obj);

            }

        }

        private void btnGetDrawingSize_Click(object sender, EventArgs e)

        {

            dynamic application = Interaction.GetObject("", "PIDAutomation.Application");

            WrapperApplication wApp = new WrapperApplication(application.Application);

            Ingr.RAD2D.Application radApp = wApp.RADApplication;

            if (radApp.ActiveSelectSet.Count > 0)

            {

                DependencyObject line2D = radApp.ActiveSelectSet[0] as DependencyObject;

                if (line2D != null)

                {

                    double minX = 0;

                    double minY = 0;

                    double maxX = 0;

                    double maxY = 0;

                    line2D.Range(out minX, out minY, out maxX, out maxY);

                    Settings.Default.DrawingX = maxX - minX;

                    Settings.Default.DrawingY = maxY - minY;

                    Settings.Default.Save();

                    textEditDrawingX.EditValue = Settings.Default.DrawingX;

                    textEditDrawingY.EditValue = Settings.Default.DrawingY;

                }

                else

                    MessageBox.Show(Msg.SelectLine, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

            }

            else

                MessageBox.Show(Msg.SelectLine, Msg.Warning, MessageBoxButtons.OK, MessageBoxIcon.Warning);

        }

        #region TEST

        private void simpleButton1_Click(object sender, EventArgs e)

        {

            return;

            Thread outThread = new Thread(func2 =>

            {

                for (int i = 100; i < 120; i++)

                {

                    Thread thread = new Thread(func =>

                    {

                        dynamic application = Interaction.GetObject("", "PIDAutomation.Application");

                        //WrapperApplication wApp = new WrapperApplication(application.Application);

                        //Ingr.RAD2D.Application radApp = wApp.RADApplication;

                        dynamic drawing = application.Drawings.Add("Unit1", "D-Size.pid", i.ToString(), i.ToString());//application.Drawings.OpenDrawing("123");

                        Thread.Sleep(5000);

                        drawing.CloseDrawing(true);

                        //application.Quit();

                        ReleaseCOMObjects(application);

                        application = null;

                        ReleaseCOMObjects(drawing);

                        drawing = null;

                        Thread.Sleep(5000);

                    });

                    thread.Start();

                    thread.Join();

                }

            });

            outThread.Start();

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

            //radApp.ActiveDocument.Close(true);

            //drawing.CloseDrawing(true);

            //ReleaseCOMObjects(application);

            //ReleaseCOMObjects(drawing);

            //application = null;

            //wApp = null;

            //radApp = null;

            //drawing = null;

        }

        private void AutoJoinPipeRun()

        {

            dynamic application = Interaction.GetObject("", "PIDAutomation.Application");

            WrapperApplication wApp = new WrapperApplication(application.Application);

            Ingr.RAD2D.Application radApp = wApp.RADApplication;

            string modelItemId = null;

            List<double[]> vertices = new List<double[]>();

            if (radApp.ActiveSelectSet.Count == 0)

            {

                return;

            }

            dynamic OID = radApp.ActiveSelectSet[0].Key();

            DependencyObject drawingObject = radApp.ActiveDocument.ActiveSheet.DrawingObjects[OID];

            foreach (var attributes in drawingObject.AttributeSets)

            {

                foreach (var attribute in attributes)

                {

                    if (attribute.Name == "ModelID")

                        modelItemId = attribute.GetValue().ToString();

                }

            }

            radApp.ActiveSelectSet.RemoveAll();

        }

        #endregion

        [DllImport("user32.dll")]

        public static extern int FindWindow(string lpClassName, string lpWindowName);

        [DllImport("user32.dll", SetLastError = true)]

        static extern int GetWindowThreadProcessId(IntPtr hWnd, out int processId);

        private void ConverterDocking_Load(object sender, EventArgs e)

        {

#if DEBUG

            this.layoutControlItem2.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Always;

#else

            this.layoutControlItem2.Visibility = DevExpress.XtraLayout.Utils.LayoutVisibility.Never;

#endif

        }

    }

}