HYTOS

using System;

using System.Collections.Generic;

using System.Data;

using System.Data.Common;

namespace ID2PSN

{

    {

        const string PSN_TOPOLOGY_RULE = "T_PSN_TOPOLOGY_RULE";

        const string PSN_HEADER_SETTING = "T_PSN_HEADER_SETTING";

        const string PSN_EQUIPMENT = "SPPIDEquipment";

        const string PSN_NOZZLE = "SPPIDNozzle";

        const string PSN_FLUIDCODE = "SPPIDFluidCode";

        const string PSN_TOPOLOGYSET = "SPPIDTopologySet";

        /// <summary>

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

                }

            }

            return result;

        }

            return dt;

        }

        public static DataTable SelectFluidCode()

        {

            DataTable dt = null;

                try

                {

                    var query = "SELECT * FROM FluidCode";

                    {

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

                    }

            }

            return dt;

        public static double[] GetDrawingSize()

        {

                            string value = ds.Tables[0].Rows[0][0].ToString();

                            string[] split = value.Split(new char[] { ',' });

                            result = new double[] {

                                };

                            result = new double[] {

                                Math.Min(result[0], result[2]),

            return dt;

        }

        private static void AddWithValue(DbCommand cmd, string PropName, object Value)

        {

            var param = cmd.CreateParameter();

                                AddWithValue(cmd, "@PSNRevisionNumber", row["PSNRevisionNumber"].ToString());

                                AddWithValue(cmd, "@PBS", row["PBS"].ToString());

                                AddWithValue(cmd, "@PIDDrawings", row["PIDDrawings"].ToString());

                                AddWithValue(cmd, "@Status", row["Status"].ToString());

                                connection.ExecuteNonQuery(cmd, txn);

                            }

                    var query = $"SELECT * FROM {PSN_PIPESYSTEMNETWORK} WHERE PSNRevisionNumber = '{string.Format("V{0:D4}", GetRevision())}'";

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

                    {

                    }

                    query = $"SELECT * FROM {PSN_EQUIPMENT}";

                    var query = $"SELECT * FROM {PSN_PIPESYSTEMNETWORK} WHERE PSNRevisionNumber = '{string.Format("V{0:D4}", GetRevision())}'";

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

                    {

                    }

                }

                catch (Exception ex)

            this.ribbonControl.ShowDisplayOptionsMenuButton = DevExpress.Utils.DefaultBoolean.False;

            this.ribbonControl.ShowPageHeadersMode = DevExpress.XtraBars.Ribbon.ShowPageHeadersMode.ShowOnMultiplePages;

            this.ribbonControl.ShowToolbarCustomizeItem = false;

            this.ribbonControl.Toolbar.ShowCustomizeItem = false;

            // 

            // layoutControl1

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

            this.layoutControl1.Name = "layoutControl1";

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            this.labelControlToolTip.ImageAlignToText = DevExpress.XtraEditors.ImageAlignToText.RightCenter;

            this.labelControlToolTip.ImageOptions.Alignment = System.Drawing.ContentAlignment.MiddleLeft;

            this.labelControlToolTip.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("labelControlToolTip.ImageOptions.Image")));

            this.labelControlToolTip.Name = "labelControlToolTip";

            this.labelControlToolTip.Size = new System.Drawing.Size(70, 16);

            this.labelControlToolTip.StyleController = this.layoutControl1;

            // 

            // btnAddType

            // 

            this.btnAddType.Name = "btnAddType";

            this.btnAddType.StyleController = this.layoutControl1;

            this.btnAddType.TabIndex = 0;

            this.btnAddType.Text = "Add Type";

            // 

            // gridControlSymbol

            // 

            this.gridControlSymbol.MainView = this.gridViewSymbol;

            this.gridControlSymbol.MenuManager = this.ribbonControl;

            this.gridControlSymbol.Name = "gridControlSymbol";

            this.gridControlSymbol.TabIndex = 4;

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

            this.gridViewSymbol});

            this.gridControlType.MainView = this.gridViewType;

            this.gridControlType.MenuManager = this.ribbonControl;

            this.gridControlType.Name = "gridControlType";

            this.gridControlType.TabIndex = 3;

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

            this.gridViewType});

            // btnClose

            // 

            this.btnClose.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnClose.ImageOptions.Image")));

            this.btnClose.Name = "btnClose";

            this.btnClose.Size = new System.Drawing.Size(70, 36);

            this.btnClose.StyleController = this.layoutControl1;

            // btnSave

            // 

            this.btnSave.ImageOptions.Image = ((System.Drawing.Image)(resources.GetObject("btnSave.ImageOptions.Image")));

            this.btnSave.Name = "btnSave";

            this.btnSave.Size = new System.Drawing.Size(68, 36);

            this.btnSave.StyleController = this.layoutControl1;

            // 

            // btnAddSymbol

            // 

            this.btnAddSymbol.Name = "btnAddSymbol";

            this.btnAddSymbol.StyleController = this.layoutControl1;

            this.btnAddSymbol.TabIndex = 2;

            this.btnAddSymbol.Text = " Add Symbol";

            this.layoutControlItem7,

            this.emptySpaceItem5});

            this.Root.Name = "Root";

            this.Root.TextVisible = false;

            // 

            // splitterItem1

            // 

            this.splitterItem1.AllowHotTrack = true;

            this.splitterItem1.Name = "splitterItem1";

            // 

            // emptySpaceItem3

            // 

            this.emptySpaceItem3.AllowHotTrack = false;

            this.emptySpaceItem3.Name = "emptySpaceItem3";

            this.emptySpaceItem3.TextSize = new System.Drawing.Size(0, 0);

            // 

            // layoutControlItem4

            // 

            this.layoutControlItem4.Control = this.btnSave;

            this.layoutControlItem4.MaxSize = new System.Drawing.Size(72, 40);

            this.layoutControlItem4.MinSize = new System.Drawing.Size(72, 40);

            this.layoutControlItem4.Name = "layoutControlItem4";

            // layoutControlItem5

            // 

            this.layoutControlItem5.Control = this.btnClose;

            this.layoutControlItem5.MaxSize = new System.Drawing.Size(74, 40);

            this.layoutControlItem5.MinSize = new System.Drawing.Size(74, 40);

            this.layoutControlItem5.Name = "layoutControlItem5";

            // emptySpaceItem2

            // 

            this.emptySpaceItem2.AllowHotTrack = false;

            this.emptySpaceItem2.MaxSize = new System.Drawing.Size(20, 40);

            this.emptySpaceItem2.MinSize = new System.Drawing.Size(20, 40);

            this.emptySpaceItem2.Name = "emptySpaceItem2";

            this.emptySpaceItem4});

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

            this.layoutControlGroup1.Name = "layoutControlGroup1";

            this.layoutControlGroup1.Text = "Header Type";

            // 

            // layoutControlItem2

            this.layoutControlItem2.Control = this.gridControlType;

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

            this.layoutControlItem2.Name = "layoutControlItem2";

            this.layoutControlItem2.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem2.TextVisible = false;

            // 

            // layoutControlItem1

            // 

            this.layoutControlItem1.Control = this.btnAddType;

            this.layoutControlItem1.Name = "layoutControlItem1";

            this.layoutControlItem1.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem1.TextVisible = false;

            // 

            this.emptySpaceItem4.AllowHotTrack = false;

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

            this.emptySpaceItem4.Name = "emptySpaceItem4";

            this.emptySpaceItem4.TextSize = new System.Drawing.Size(0, 0);

            // 

            // layoutControlGroup2

            this.layoutControlItem6,

            this.layoutControlItem3,

            this.emptySpaceItem1});

            this.layoutControlGroup2.Name = "layoutControlGroup2";

            this.layoutControlGroup2.Text = "Type Items";

            // 

            // layoutControlItem6

            this.layoutControlItem6.Control = this.gridControlSymbol;

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

            this.layoutControlItem6.Name = "layoutControlItem6";

            this.layoutControlItem6.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem6.TextVisible = false;

            // 

            // layoutControlItem3

            // 

            this.layoutControlItem3.Control = this.btnAddSymbol;

            this.layoutControlItem3.Name = "layoutControlItem3";

            this.layoutControlItem3.TextSize = new System.Drawing.Size(0, 0);

            this.layoutControlItem3.TextVisible = false;

            // 

            this.emptySpaceItem1.AllowHotTrack = false;

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

            this.emptySpaceItem1.Name = "emptySpaceItem1";

            this.emptySpaceItem1.TextSize = new System.Drawing.Size(0, 0);

            // 

            // layoutControlItem7

            // 

            this.layoutControlItem7.Control = this.labelControlToolTip;

            this.layoutControlItem7.MaxSize = new System.Drawing.Size(74, 20);

            this.layoutControlItem7.MinSize = new System.Drawing.Size(74, 20);

            this.layoutControlItem7.Name = "layoutControlItem7";

            this.emptySpaceItem5.AllowHotTrack = false;

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

            this.emptySpaceItem5.Name = "emptySpaceItem5";

            this.emptySpaceItem5.TextSize = new System.Drawing.Size(0, 0);

            // 

            // HeaderSettingForm

            // 

            this.AutoScaleDimensions = new System.Drawing.SizeF(7F, 14F);

            this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;

            this.Controls.Add(this.layoutControl1);

            this.Controls.Add(this.ribbonControl);

            this.Name = "HeaderSettingForm";

                newRow["FROM_DATA"] = row["FROM_DATA"].ToString();

                newRow["TO_DATA"] = row["TO_DATA"].ToString();

                newRow["TopologySet_OID_Key"] = row["TopologySet_OID_Key"].ToString();

                newRow["Validity"] = row["Validity"].ToString();

                newRow["Status"] = row["Status"].ToString();

        private void MainForm_FormClosed(object sender, FormClosedEventArgs e)

        {

        }

    }

}

        OPC,

    }

    public class PSN

    {

        private double[] DrawingSize = null;

        }

        private void UpdateErrorForPSN()

        {

            foreach (DataRow dataRow in errorRows)

            {

                PSNItem PSNItem = PSNItems.Find(x=>x.PSN_OID() == dataRow["OID"].ToString());

                    PSNItem.EndType = PSNType.Equipment;

                dataRow["Type"] = PSNItem.GetPSNType();

        }

    }