HYTOS

        //2021.11.26 추가

        const string PSN_INSULATIONPURPOSE = "SPPIDInsulationPurpose";

                    matched = names.FirstOrDefault(param => param == PSN_INSULATIONPURPOSE);

                    if (matched == null)

                    {

                        var query = $"CREATE TABLE {PSN_INSULATIONPURPOSE} (UID NVARCHAR(50), Code NVARCHAR(255), Description NVARCHAR(255), Remarks NVARCHAR(255))";

                        using (var cmd = connection.GetSqlStringCommand(query))

                        {

                            cmd.ExecuteNonQuery();

                        }

                    }

        public static DataTable SelectInsulationPurpose()

        {

            DataTable dt = null;

            ID2Info id2Info = ID2Info.GetInstance();

            using (IAbstractDatabase connection = id2Info.CreateConnection())

            {

                try

                {

                    var query = "SELECT * FROM InsulationPurpose";

                    using (var ds = connection.ExecuteDataSet(connection.GetSqlStringCommand(query)))

                    {

                        dt = ds.Tables[0].Copy();

                    }

                }

                catch (Exception ex)

                {

                    Log.Write(ex.Message + "\r\n" + ex.StackTrace);

                }

            }

            return dt;

        }

        public static DataTable SelectPSNINSULATIONPURPOSE()

        {

            DataTable dt = null;

            ID2Info id2Info = ID2Info.GetInstance();

            using (IAbstractDatabase connection = id2Info.CreateConnection(ID2DB_Type.SQLite))

            {

                try

                {

                    var query = $"SELECT * FROM {PSN_INSULATIONPURPOSE}";

                    using (var ds = connection.ExecuteDataSet(connection.GetSqlStringCommand(query)))

                    {

                        dt = ds.Tables[0].Copy();

                    }

                }

                catch (Exception ex)

                {

                    Log.Write(ex.Message + "\r\n" + ex.StackTrace);

                }

            }

            return dt;

        }

            this.xtraInsulationPurpose = new DevExpress.XtraTab.XtraTabPage();

            this.gridControlInsulationPurpose = new DevExpress.XtraGrid.GridControl();

            this.gridViewInsulationPurpose = new DevExpress.XtraGrid.Views.Grid.GridView();

            this.xtraInsulationPurpose.SuspendLayout();

            ((System.ComponentModel.ISupportInitialize)(this.gridControlInsulationPurpose)).BeginInit();

            ((System.ComponentModel.ISupportInitialize)(this.gridViewInsulationPurpose)).BeginInit();

            this.xtraTabPagePipingMaterialsClass,

            this.xtraInsulationPurpose});

            this.xtraTabPagePipingMaterialsClass.Size = new System.Drawing.Size(554, 831);

            this.gridControlPipingMaterialsClass.Size = new System.Drawing.Size(554, 831);

            // xtraInsulationPurpose

            // 

            this.xtraInsulationPurpose.Controls.Add(this.gridControlInsulationPurpose);

            this.xtraInsulationPurpose.Name = "xtraInsulationPurpose";

            this.xtraInsulationPurpose.Size = new System.Drawing.Size(554, 831);

            this.xtraInsulationPurpose.Text = "Insulation Purpose";

            // 

            // gridControlInsulationPurpose

            // 

            this.gridControlInsulationPurpose.Dock = System.Windows.Forms.DockStyle.Fill;

            this.gridControlInsulationPurpose.Location = new System.Drawing.Point(0, 0);

            this.gridControlInsulationPurpose.MainView = this.gridViewInsulationPurpose;

            this.gridControlInsulationPurpose.MenuManager = this.ribbonControl;

            this.gridControlInsulationPurpose.Name = "gridControlInsulationPurpose";

            this.gridControlInsulationPurpose.Size = new System.Drawing.Size(554, 831);

            this.gridControlInsulationPurpose.TabIndex = 1;

            this.gridControlInsulationPurpose.ViewCollection.AddRange(new DevExpress.XtraGrid.Views.Base.BaseView[] {

            this.gridViewInsulationPurpose});

            // 

            // gridViewInsulationPurpose

            // 

            this.gridViewInsulationPurpose.GridControl = this.gridControlInsulationPurpose;

            this.gridViewInsulationPurpose.Name = "gridViewInsulationPurpose";

            this.gridViewInsulationPurpose.OptionsView.ShowGroupPanel = false;

            // 

            this.xtraInsulationPurpose.ResumeLayout(false);

            ((System.ComponentModel.ISupportInitialize)(this.gridControlInsulationPurpose)).EndInit();

            ((System.ComponentModel.ISupportInitialize)(this.gridViewInsulationPurpose)).EndInit();

        private DevExpress.XtraTab.XtraTabPage xtraInsulationPurpose;

        private DevExpress.XtraGrid.GridControl gridControlInsulationPurpose;

        private DevExpress.XtraGrid.Views.Grid.GridView gridViewInsulationPurpose;

            DataTable insulationPurpose = DB.SelectInsulationPurpose();

            DataTable PSNINSULATIONDT = DB.SelectPSNINSULATIONPURPOSE();

            // InsulationPurpose

            DataTable InsulationViewDT = new DataTable();

            InsulationViewDT.Columns.Add("UID", typeof(string));

            InsulationViewDT.Columns.Add("Code", typeof(string));

            InsulationViewDT.Columns.Add("Description", typeof(string));

            InsulationViewDT.Columns.Add("Remarks", typeof(string));

            foreach (DataRow row in PSNINSULATIONDT.Rows)

            {

                string uid = row["UID"].ToString();

                DataRow[] rows = InsulationViewDT.Select(string.Format("UID = '{0}'", uid));

                if (rows.Length == 1)

                {

                    DataRow oldRow = rows.First();

                    DataRow newRow = InsulationViewDT.NewRow();

                    newRow["UID"] = row["UID"];

                    newRow["Code"] = row["Code"];

                    newRow["Description"] = row["Description"];

                    newRow["Remarks"] = row["Allowables"];

                    InsulationViewDT.Rows.Add(newRow);

                    InsulationViewDT.Rows.Remove(oldRow);

                }

            }

            foreach (DataRow row in InsulationViewDT.Rows)

            {

                DataRow newRow = InsulationViewDT.NewRow();

                newRow["UID"] = row["UID"];

                newRow["Code"] = row["Code"];

                newRow["Description"] = row["Description"];

                newRow["Remarks"] = row["Allowables"];

                InsulationViewDT.Rows.Add(newRow);

            }

            gridControlInsulationPurpose.DataSource = InsulationViewDT;           

            gridViewInsulationPurpose.Columns["UID"].OptionsColumn.AllowEdit = false;

            gridViewInsulationPurpose.Columns["UID"].Visible = false;

            gridViewInsulationPurpose.Columns["Code"].OptionsColumn.AllowEdit = false;

            gridViewInsulationPurpose.Columns["Description"].OptionsColumn.AllowEdit = false;

            gridViewInsulationPurpose.Columns["Remarks"].OptionsColumn.AllowEdit = false;

            gridViewInsulationPurpose.OptionsCustomization.AllowSort = false;

            gridViewInsulationPurpose.OptionsCustomization.AllowFilter = false;

                                    LineNumber lineNumber = item.Document.LineNumbers.Find(x => x.UID == item.Owner);

                                    if (lineNumber != null)

                                    {

                                        List<Attribute> att = lineNumber.Attributes;

                                        if(att != null)

                                        {

                                            DataRow newPipelineRow = pipelineDT.NewRow();

                                            List<string> oid = new List<string>();

                                            string FluidCode = att.Where(x => x.Name.ToUpper().Equals("FLUIDCODE")).FirstOrDefault() != null ? att.Where(x => x.Name.ToUpper().Equals("FLUIDCODE")).FirstOrDefault().Value : string.Empty;

                                            string PMC = lineNumber.Attributes.Where(x => x.Name.ToUpper().Equals("PIPINGMATERIALSCLASS")).FirstOrDefault() != null ? lineNumber.Attributes.Where(x => x.Name.ToUpper().Equals("PIPINGMATERIALSCLASS")).FirstOrDefault().Value : string.Empty;

                                            string SEQNUMBER = lineNumber.Attributes.Where(x => x.Name.ToUpper().Equals("TAG SEQ NO")).FirstOrDefault() != null ? lineNumber.Attributes.Where(x => x.Name.ToUpper().Equals("TAG SEQ NO")).FirstOrDefault().Value : string.Empty;

                                            string INSULATION = lineNumber.Attributes.Where(x => x.Name.ToUpper().Equals("INSULATIONPURPOSE")).FirstOrDefault() != null ? lineNumber.Attributes.Where(x => x.Name.ToUpper().Equals("INSULATIONPURPOSE")).FirstOrDefault().Value : string.Empty;

                                            //InsulationPurpose

                                            if (!string.IsNullOrEmpty(FluidCode)) oid.Add(FluidCode);

                                            if (!string.IsNullOrEmpty(PMC)) oid.Add(PMC);                                          

                                            string PipeSystem_OID = string.Join("-", oid);

                                            if (!string.IsNullOrEmpty(SEQNUMBER)) oid.Add(SEQNUMBER);

                                            if (!string.IsNullOrEmpty(INSULATION)) oid.Add(INSULATION);

                                            string OID = string.Join("-", oid);

                                            newPipelineRow["OID"] = OID;

                                            newPipelineRow["PipeSystem_OID"] = PipeSystem_OID;

                                            newPipelineRow["FLUID"] = FluidCode;

                                            newPipelineRow["PMC"] = PMC;

                                            newPipelineRow["SEQNUMBER"] = SEQNUMBER;

                                            newPipelineRow["INSULATION"] = INSULATION;

                                            newPipelineRow["FROM_DATA"] = string.Empty;

                                            newPipelineRow["TO_DATA"] = string.Empty;

                                            newPipelineRow["Unit"] = PSNItem.GetPBSData();

                                            pipelineDT.Rows.Add(newPipelineRow);

                                        }                                        

                                    }