HYTOS

            this.ribbonControl.Size = new System.Drawing.Size(378, 32);

            this.layoutControl1.Size = new System.Drawing.Size(378, 270);

            this.btnClose.Location = new System.Drawing.Point(296, 218);

            this.btnSave.Location = new System.Drawing.Point(204, 218);

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

            this.txHost.Size = new System.Drawing.Size(265, 20);

            this.txDBName.Size = new System.Drawing.Size(265, 20);

            this.txUser.Size = new System.Drawing.Size(265, 20);

            this.txPassword.Size = new System.Drawing.Size(265, 20);

            this.btnFolder.Location = new System.Drawing.Point(326, 180);

            this.btnFolder.Size = new System.Drawing.Size(28, 22);

            this.txID2Filepath.Size = new System.Drawing.Size(233, 20);

            this.Root.Size = new System.Drawing.Size(378, 270);

            this.layoutControlItem4.Location = new System.Drawing.Point(192, 206);

            this.layoutControlItem5.Location = new System.Drawing.Point(284, 206);

            this.emptySpaceItem2.Location = new System.Drawing.Point(264, 206);

            this.layoutControlGroup1.Size = new System.Drawing.Size(358, 206);

            this.layoutControlItem1.Size = new System.Drawing.Size(334, 41);

            this.group2.Size = new System.Drawing.Size(334, 26);

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

            this.layoutControlItem2.Size = new System.Drawing.Size(32, 26);

            this.lcID2FilePath.Size = new System.Drawing.Size(302, 26);

            this.group1.Size = new System.Drawing.Size(334, 96);

            this.lcPassword.Size = new System.Drawing.Size(334, 24);

            this.lcHost.Size = new System.Drawing.Size(334, 24);

            this.lcDBName.Size = new System.Drawing.Size(334, 24);

            this.lcUser.Size = new System.Drawing.Size(334, 24);

            this.emptySpaceItem1.Size = new System.Drawing.Size(192, 44);

            this.ClientSize = new System.Drawing.Size(378, 302);

namespace ID2PSN

{

    partial class HistoryForm

    {

        /// <summary>

        /// Required designer variable.

        /// </summary>

        private System.ComponentModel.IContainer components = null;

        /// <summary>

        /// Clean up any resources being used.

        /// </summary>

        /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>

        protected override void Dispose(bool disposing)

        {

            if (disposing && (components != null))

            {

                components.Dispose();

            }

            base.Dispose(disposing);

        }

        #region Windows Form Designer generated code

        /// <summary>

        /// Required method for Designer support - do not modify

        /// the contents of this method with the code editor.

        /// </summary>

        private void InitializeComponent()

        {

            System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(HistoryForm));

            this.ribbonControl = new DevExpress.XtraBars.Ribbon.RibbonControl();

            this.layoutControl1 = new DevExpress.XtraLayout.LayoutControl();

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

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

            this.btnClose = new DevExpress.XtraEditors.SimpleButton();

            this.Root = new DevExpress.XtraLayout.LayoutControlGroup();

            this.emptySpaceItem3 = new DevExpress.XtraLayout.EmptySpaceItem();

            this.layoutControlItem5 = new DevExpress.XtraLayout.LayoutControlItem();

            this.layoutControlItem1 = new DevExpress.XtraLayout.LayoutControlItem();

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

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

            this.layoutControl1.SuspendLayout();

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

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

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

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

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

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

            this.SuspendLayout();

            // 

            // ribbonControl

            // 

            this.ribbonControl.ExpandCollapseItem.Id = 0;

            this.ribbonControl.Items.AddRange(new DevExpress.XtraBars.BarItem[] {

            this.ribbonControl.ExpandCollapseItem,

            this.ribbonControl.SearchEditItem});

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

            this.ribbonControl.MaxItemId = 1;

            this.ribbonControl.Name = "ribbonControl";

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

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

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

            this.ribbonControl.ShowToolbarCustomizeItem = false;

            this.ribbonControl.Size = new System.Drawing.Size(1599, 32);

            this.ribbonControl.Toolbar.ShowCustomizeItem = false;

            // 

            // layoutControl1

            // 

            this.layoutControl1.Controls.Add(this.gridHistory);

            this.layoutControl1.Controls.Add(this.btnClose);

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

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

            this.layoutControl1.Name = "layoutControl1";

            this.layoutControl1.OptionsCustomizationForm.DesignTimeCustomizationFormPositionAndSize = new System.Drawing.Rectangle(488, 408, 650, 400);

            this.layoutControl1.Root = this.Root;

            this.layoutControl1.Size = new System.Drawing.Size(1599, 861);

            this.layoutControl1.TabIndex = 1;

            this.layoutControl1.Text = "layoutControl1";

            // 

            // gridHistory

            // 

            this.gridHistory.Location = new System.Drawing.Point(12, 12);

            this.gridHistory.MainView = this.gridViewHistory;

            this.gridHistory.MenuManager = this.ribbonControl;

            this.gridHistory.Name = "gridHistory";

            this.gridHistory.Size = new System.Drawing.Size(1575, 797);

            this.gridHistory.TabIndex = 6;

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

            this.gridViewHistory});

            // 

            // gridViewHistory

            // 

            this.gridViewHistory.GridControl = this.gridHistory;

            this.gridViewHistory.Name = "gridViewHistory";

            this.gridViewHistory.OptionsView.ShowGroupPanel = false;

            // 

            // btnClose

            // 

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

            this.btnClose.Location = new System.Drawing.Point(1517, 813);

            this.btnClose.Name = "btnClose";

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

            this.btnClose.StyleController = this.layoutControl1;

            this.btnClose.TabIndex = 5;

            this.btnClose.Text = "Close";

            this.btnClose.Click += new System.EventHandler(this.btnClose_Click);

            // 

            // Root

            // 

            this.Root.EnableIndentsWithoutBorders = DevExpress.Utils.DefaultBoolean.True;

            this.Root.GroupBordersVisible = false;

            this.Root.Items.AddRange(new DevExpress.XtraLayout.BaseLayoutItem[] {

            this.emptySpaceItem3,

            this.layoutControlItem5,

            this.layoutControlItem1});

            this.Root.Name = "Root";

            this.Root.Size = new System.Drawing.Size(1599, 861);

            this.Root.TextVisible = false;

            // 

            // emptySpaceItem3

            // 

            this.emptySpaceItem3.AllowHotTrack = false;

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

            this.emptySpaceItem3.Name = "emptySpaceItem3";

            this.emptySpaceItem3.Size = new System.Drawing.Size(1505, 40);

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

            // 

            // layoutControlItem5

            // 

            this.layoutControlItem5.Control = this.btnClose;

            this.layoutControlItem5.Location = new System.Drawing.Point(1505, 801);

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

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

            this.layoutControlItem5.Name = "layoutControlItem5";

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

            this.layoutControlItem5.SizeConstraintsType = DevExpress.XtraLayout.SizeConstraintsType.Custom;

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

            this.layoutControlItem5.TextVisible = false;

            // 

            // layoutControlItem1

            // 

            this.layoutControlItem1.Control = this.gridHistory;

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

            this.layoutControlItem1.Name = "layoutControlItem1";

            this.layoutControlItem1.Size = new System.Drawing.Size(1579, 801);

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

            this.layoutControlItem1.TextVisible = false;

            // 

            // HistoryForm

            // 

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

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

            this.ClientSize = new System.Drawing.Size(1599, 893);

            this.Controls.Add(this.layoutControl1);

            this.Controls.Add(this.ribbonControl);

            this.Name = "HistoryForm";

            this.Ribbon = this.ribbonControl;

            this.StartPosition = System.Windows.Forms.FormStartPosition.CenterParent;

            this.Text = "Revision History";

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

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

            this.layoutControl1.ResumeLayout(false);

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

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

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

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

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

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

            this.ResumeLayout(false);

            this.PerformLayout();

        }

        #endregion

        private DevExpress.XtraBars.Ribbon.RibbonControl ribbonControl;

        private DevExpress.XtraLayout.LayoutControl layoutControl1;

        private DevExpress.XtraLayout.LayoutControlGroup Root;

        private DevExpress.XtraEditors.SimpleButton btnClose;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem5;

        private DevExpress.XtraLayout.EmptySpaceItem emptySpaceItem3;

        private DevExpress.XtraGrid.GridControl gridHistory;

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

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem1;

    }

}

using System;

using System.Collections.Generic;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Linq;

using System.Text;

using System.Threading.Tasks;

using System.Windows.Forms;

using System.IO;

using DevExpress.XtraEditors.Repository;

using DevExpress.XtraGrid.Columns;

using DevExpress.XtraGrid;

using DevExpress.XtraGrid.Views.Grid;

using DevExpress.Utils.StructuredStorage.Internal.Reader;

using DevExpress.XtraTreeList;

using DevExpress.XtraTreeList.Columns;

using DevExpress.XtraTreeList.Nodes;

using DevExpress.Utils.Extensions;

using DevExpress.Utils;

using DevExpress.Utils.Drawing;

namespace ID2PSN

{

    public partial class HistoryForm : DevExpress.XtraBars.Ribbon.RibbonForm

    {

        ID2Info ID2Info = ID2Info.GetInstance();

        public HistoryForm()

        {

            InitializeComponent();

            InitGridRevisionHistory();   

            InitData();            

        }

        public void InitGridRevisionHistory()

        {

            /*

             ProjectCode] nvarchar(255), [RevNumber] int ,[UserName] nvarchar(255) ,[TimeData] nvarchar(255) ," +

                            $"[PSNDatabasePath] nvarchar(255) ,	[PsnByPBSFilter] varchar(20) ,[PsnByNPDFilter] varchar(20) ,[PidDrawings] int ,	" +

                            $"[PipeSystems] int ,[PipeLines] int ,[Topologies] int ,[PipeSystemNetworks] int ,[InValidPSNs] int ,[E2E] int ," +

                            $"[E2B] int ,[B2E] int ,[HDE] int ,[HD2] int ,[HDB] int ,[B2B] int, [LastModificationdate] nvarchar(255), [ID2_PSN] nvarchar(10))

             */

            DataTable dtRevisionHistory = new DataTable();

            dtRevisionHistory.Columns.Add("ProjectCode");

            dtRevisionHistory.Columns.Add("RevNumber");

            dtRevisionHistory.Columns.Add("UserName");

            dtRevisionHistory.Columns.Add("TimeData");

            dtRevisionHistory.Columns.Add("PSNDatabasePath");

            dtRevisionHistory.Columns.Add("PidDrawings");

            dtRevisionHistory.Columns.Add("PipeSystems");

            dtRevisionHistory.Columns.Add("PipeLines");

            dtRevisionHistory.Columns.Add("Topologies");

            dtRevisionHistory.Columns.Add("PipeSystemNetworks");

            dtRevisionHistory.Columns.Add("InValidPSNs");

            dtRevisionHistory.Columns.Add("E2E");

            dtRevisionHistory.Columns.Add("E2B");

            dtRevisionHistory.Columns.Add("B2E");

            dtRevisionHistory.Columns.Add("HDE");

            dtRevisionHistory.Columns.Add("HD2");

            dtRevisionHistory.Columns.Add("HDB");

            dtRevisionHistory.Columns.Add("B2B");

            dtRevisionHistory.Columns.Add("LastModificationdate");

            dtRevisionHistory.Columns.Add("ID2_PSN");

            gridHistory.DataSource = dtRevisionHistory;

            gridViewHistory.OptionsBehavior.AllowPixelScrolling = DefaultBoolean.True;

            GridColumn gridColumn = gridViewHistory.Columns[0];            

            gridColumn.Name = "ProjectCode";

            gridColumn.Caption = "Project Code";

            gridColumn.OptionsColumn.AllowEdit = false;

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 0;

            gridColumn = gridViewHistory.Columns[1];

            gridColumn.Name = "RevNumber";

            gridColumn.Caption = "Revision";

            gridColumn.OptionsColumn.AllowEdit = false;

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 1;

            gridColumn = gridViewHistory.Columns[2];

            gridColumn.Name = "UserName";

            gridColumn.Caption = "User Info";

            gridColumn.OptionsColumn.AllowEdit = false;

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 2;

            gridColumn = gridViewHistory.Columns[3];

            gridColumn.Name = "TimeData";

            gridColumn.Caption = "Time Stamp";

            gridColumn.OptionsColumn.AllowEdit = false;

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 3;

            gridColumn = gridViewHistory.Columns[4];

            gridColumn.Name = "PSNDatabasePath";

            gridColumn.Caption = "PSN Database";

            gridColumn.OptionsColumn.AllowEdit = false;

            gridColumn.OptionsColumn.AllowSort = DevExpress.Utils.DefaultBoolean.False;

            gridColumn.VisibleIndex = 4;

            gridViewHistory.OptionsBehavior.Editable = false;

            gridViewHistory.BestFitColumns();

        }

        public void InitData()

        {

            DataTable dt = DB.SelectRevision();

            gridHistory.DataSource = dt;

        }      

        private void btnClose_Click(object sender, EventArgs e)

        {

            DialogResult = DialogResult.Cancel;

        }

    }

}

<?xml version="1.0" encoding="utf-8"?>

<root>

  <!-- 

    Microsoft ResX Schema 

    Version 2.0

    The primary goals of this format is to allow a simple XML format 

    that is mostly human readable. The generation and parsing of the 

    various data types are done through the TypeConverter classes 

    associated with the data types.

    Example:

    ... ado.net/XML headers & schema ...

    <resheader name="resmimetype">text/microsoft-resx</resheader>

    <resheader name="version">2.0</resheader>

    <resheader name="reader">System.Resources.ResXResourceReader, System.Windows.Forms, ...</resheader>

    <resheader name="writer">System.Resources.ResXResourceWriter, System.Windows.Forms, ...</resheader>

    <data name="Name1"><value>this is my long string</value><comment>this is a comment</comment></data>

    <data name="Color1" type="System.Drawing.Color, System.Drawing">Blue</data>

    <data name="Bitmap1" mimetype="application/x-microsoft.net.object.binary.base64">

        <value>[base64 mime encoded serialized .NET Framework object]</value>

    </data>

    <data name="Icon1" type="System.Drawing.Icon, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

        <value>[base64 mime encoded string representing a byte array form of the .NET Framework object]</value>

        <comment>This is a comment</comment>

    </data>

    There are any number of "resheader" rows that contain simple 

    name/value pairs.

    Each data row contains a name, and value. The row also contains a 

    type or mimetype. Type corresponds to a .NET class that support 

    text/value conversion through the TypeConverter architecture. 

    Classes that don't support this are serialized and stored with the 

    mimetype set.

    The mimetype is used for serialized objects, and tells the 

    ResXResourceReader how to depersist the object. This is currently not 

    extensible. For a given mimetype the value must be set accordingly:

    Note - application/x-microsoft.net.object.binary.base64 is the format 

    that the ResXResourceWriter will generate, however the reader can 

    read any of the formats listed below.

    mimetype: application/x-microsoft.net.object.binary.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Binary.BinaryFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.soap.base64

    value   : The object must be serialized with 

            : System.Runtime.Serialization.Formatters.Soap.SoapFormatter

            : and then encoded with base64 encoding.

    mimetype: application/x-microsoft.net.object.bytearray.base64

    value   : The object must be serialized into a byte array 

            : using a System.ComponentModel.TypeConverter

            : and then encoded with base64 encoding.

    -->

  <xsd:schema id="root" xmlns="" xmlns:xsd="http://www.w3.org/2001/XMLSchema" xmlns:msdata="urn:schemas-microsoft-com:xml-msdata">

    <xsd:import namespace="http://www.w3.org/XML/1998/namespace" />

    <xsd:element name="root" msdata:IsDataSet="true">

      <xsd:complexType>

        <xsd:choice maxOccurs="unbounded">

          <xsd:element name="metadata">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" />

              </xsd:sequence>

              <xsd:attribute name="name" use="required" type="xsd:string" />

              <xsd:attribute name="type" type="xsd:string" />

              <xsd:attribute name="mimetype" type="xsd:string" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="assembly">

            <xsd:complexType>

              <xsd:attribute name="alias" type="xsd:string" />

              <xsd:attribute name="name" type="xsd:string" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="data">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

                <xsd:element name="comment" type="xsd:string" minOccurs="0" msdata:Ordinal="2" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" msdata:Ordinal="1" />

              <xsd:attribute name="type" type="xsd:string" msdata:Ordinal="3" />

              <xsd:attribute name="mimetype" type="xsd:string" msdata:Ordinal="4" />

              <xsd:attribute ref="xml:space" />

            </xsd:complexType>

          </xsd:element>

          <xsd:element name="resheader">

            <xsd:complexType>

              <xsd:sequence>

                <xsd:element name="value" type="xsd:string" minOccurs="0" msdata:Ordinal="1" />

              </xsd:sequence>

              <xsd:attribute name="name" type="xsd:string" use="required" />

            </xsd:complexType>

          </xsd:element>

        </xsd:choice>

      </xsd:complexType>

    </xsd:element>

  </xsd:schema>

  <resheader name="resmimetype">

    <value>text/microsoft-resx</value>

  </resheader>

  <resheader name="version">

    <value>2.0</value>

  </resheader>

  <resheader name="reader">

    <value>System.Resources.ResXResourceReader, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <resheader name="writer">

    <value>System.Resources.ResXResourceWriter, System.Windows.Forms, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b77a5c561934e089</value>

  </resheader>

  <assembly alias="System.Drawing" name="System.Drawing, Version=4.0.0.0, Culture=neutral, PublicKeyToken=b03f5f7f11d50a3a" />

  <data name="btnClose.ImageOptions.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

    <value>

        iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAABGdBTUEAALGPC/xhBQAAAB10RVh0VGl0

        bGUAQ2xvc2U7RXhpdDtCYXJzO1JpYmJvbjtGA7noAAAI60lEQVRYR8WXd1RUZxqHzWaz6ZqiJrFEowYE

        RVRAhYGBoQ1SFGRVEvvKqsGCx8AqqBQVNLoqxY49alBEiggaiUoHUcqAdFH6DEVEmuSf377vHQbBWXfP

        2bN79jvn8bt3Zpjn977f/e5cBwH4vyKMmuA9g2qC9vDhW/+GP/wXeKs0wJemfqP6QCBPKsEfiXeIP73G

        u2/gvX/B+/3gc/48fz97BgyWv53js9myItA3u3K3Hyp3++IxE+gLeg0VAcQuH2I7ylXs3IbSHSq2otTf

        GyWMnzeKGV8vFPluIbxR5LMF+Vv/9jDR3U1KLi6QnX2DT96p2Lld3nb/DnqqCtHztAA9T2ToqcxDz+Nc

        dJc/RHdZNrqLs9D1KB1dhanoyk9GZ+49dOb8ho7sX9GRlYD29BtoT4lFW9I1tN2NQFtiONpuXcTzhPOo

        PxuEvC0eCnJxNwZ0gU/eLaOknbmJeH7jPJ7HvaL1+jm0xp5FawwRfQat107jWeRJtESEoeXKcbSEH0PL

        L0fQfDEUzT8Ho+ncQTSe2Y/GU/ugCNsD+bEAyI/sRO3fvZDrsZGvvA+Jt1msGhzgvRJvT7SnxZDoFIl6

        iTqFZ9eIyDA8u0rCiBN90maWXjqMpguhaCJx41mlWKESH98tiBsO+aM+2Bc1gT8ie8NaDvARoR7gkedG

        vEiKIAkJBKiyK8Tlo2gOJwThETRdVElD0HguiKQkPk3ik/sgP/ETVRyIhsMBJN6B+hA/1AdtR91+bzzd

        sQGZa1ZzgI8JtQDvy9zX0ZpdIgm1UgW1telCiBJu73kSUosVZw5Qi5VSRdheZbVHWbwT9aEkDmaxD4m3

        om7fFtTs8cSTbT8gbeVKDjCYUAvwwQPXFWiNP08CWr9zJGB4LYnqQwG44eSA8/oGuO3ijPojgSSlNpO0

        NmQHbjrPwcnJUxAltUBlgCdqSVzD4p88Ub3bA1W7NuLxFlfcmb9QFYC3Y9/gNB+kOjpSZVTNCaomjFp5

        kgQn9qA62B/RUitEevogISYFEavW47qDDWqoyhqqMnq2FS67rkV8dDKuuHvhF5EhKnzdUU1rXrVrE6qo

        9U9816F4lTPiJFIOMIRQC/BhssNc1O7dhEqPpcIVW08XEJPgZI9oL3+kZleg4kkjissbELnGHbG2UsTO

        tib5OtzLKEFxRQNKnzQhmoJGWZjhqf8GPCVx5WZXlK6eh/yFlogxMecAnxBqAT66Z+dAqTeg3M0Z5T84

        o+LHJaja6Y7LRkZoqJajsqYFrS960Nr+EqWP5UKIy39dj7vpJSihYM0vXqK5rRvPFC04raNLf7+cxM4o

        XuGA4mX2yJsvQZRIwgE+JdQD/Dbbga5UN5StdkTpKhVOSHS2R9q27eh++TsFeImWNhLRXPJYgcycSpRU

        NqLpebcAf+ae52bE2VigiKRFS+zwaKktHi22RY6jGFdnid8Y4OPbUntUbluFElcHYg6Kmb84oMJjBW7a

        2yDDz08QCDKqlOfGfnR3/44Ub29Em4tR5r5YkBYutkHh99Yo+F6KB/ZGuDJDCPAZwbfjvsEBBt+ysqUr

        dQW1zA5Fy3tZxrM9yj2W44bUHEle3lC0dkJBQkVrVx8NzR24u9kL0abGKNu4lKRSFLhIIXOxgozWPn+B

        Be7PnoVwPREH+JwYEIDbMTjeXIqyTZxcisIllHyRlI5nEzYooPmGpRhRq9ejsEwBRQsFaOmCnKgn6po6

        EOe2EdFiQ+QtsISMhLI/WyDfWSKQN88UmVYGuDjtzQGGxJlZoWSdCwq+s6KWUdtcLIVjriDOzBDXaPsl

        JhejoFyB+maSCnQI8rqmLuSXNCBipRuuGeohx8kMeU6myGUcTZAz1wRpkmn4WdeQAwwlBvwicoBPYsWW

        KKbtIqOrNX8BMd+ckOCWpTGi1mzA7eQiyKh6pbADnV096CBqGztQ00teUR0iXd0QI9JHjgOJ7UV4yNgZ

        IUWsi3M6MznAMEI9AG+RAtoyefPEyCXynJRzlFiEirIa5Jc2CLJaknd09iDL3xeZfr7CcbWiQ6BK3o66

        agUu6U3HA1tDJbT22dKZSDKehNNa+hxgOKEW4NNIQwlktNYP54ioZYSDsVDBr7aWKDx6GG0dPdT6TkGY

        vcMfCdZmiLcyFYK002vcFf5MXkgwrpsZk3QG7lvPQBatfZalPu7M0sZJjemqAPyUNSDAZ7xFchdaUOpZ

        QuqHPFMFsqVzEE8yDtEllyPb3w83bSQoXDYXhfReAofw80GnvAF5oSF0IRohx8VWkGZaTEemOTMNifqa

        ODFhKgf4ghgQgNvxebg+Xyxi3JcaKLE2oCoMhDCyJXORaGeJWIkJ7jhYI3+xvbIyIn+RHW7bmuMq/QbE

        007J/c5OkGeYTkOm6VRkmOkindb/9tQJOPaNLgf4klAPcHG6CPfpZpFFqbMs9IT0fMwVZFErZYvojrbS

        me7pUmT1ViUgmU63WSsULnek9+iGZaaHDPEUkk5BmojRQRqt/02dcTg8VocDfEWoBRh6QXcWsuhiyZBQ

        aoaS981chVDJVKSb0mxKAhN6nUXGfKyDdEE0GWlGOkg1nPQKWvvUmVpImDwGh0ZrqwXgfzjAMN4iGVQR

        f1kafWmamL5UOKYvNabZhGeCRKk0pxoRLBApRSkMyVIMtZBCwpSZE5EyQxPJMyYiyUATcVqjETJiIgcY

        QfAj+oAAQ09r6wttSxVpUxWUuh8pPHMlvfQJZtK5IJpIIqUsmWRMkoEGkvS+7eO65igEfanxTzsgbMMw

        jWnyGB1N3NIdhwSdb4ixiJ805hXaXwvECefKY+GcoeoESBI3kdAcScJeNEYQIxE+djT2DZ/Aj+V8IxoQ

        QHgk2zpac9HR8VOajo/XBXNs3BS6anVwZOxkgcNjJgkc+loboaMnIXSUFkJHEiO0qLXEV5oIJoKIg1Tp

        wS+I4Ro4MHwC9g//FnuHjW9eO2TkUnKpHkqFADxUXeDndf6h4H3KW4Vb9Tq8fq8z8g2M6gef8w2Inwd5

        yfvkPPhE1Ql+k9vzOv3/P/ifoPoeVeUDAqiG6o3/Nb1j0KB/AMYUfCkDw9hpAAAAAElFTkSuQmCC

</value>

  </data>

</root>

            this.btnHistory = new DevExpress.XtraEditors.SimpleButton();

            this.layoutControlItem17 = new DevExpress.XtraLayout.LayoutControlItem();

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

            this.layoutControl1.Controls.Add(this.btnHistory);

            this.btnSaveAs.Location = new System.Drawing.Point(24, 794);

            this.btnExportPSN.Location = new System.Drawing.Point(24, 674);

            this.btnSave.Location = new System.Drawing.Point(24, 754);

            this.btnRun.Location = new System.Drawing.Point(24, 714);

            // btnHistory

            // 

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

            this.btnHistory.Location = new System.Drawing.Point(24, 834);

            this.btnHistory.Name = "btnHistory";

            this.btnHistory.Size = new System.Drawing.Size(233, 36);

            this.btnHistory.StyleController = this.layoutControl1;

            this.btnHistory.TabIndex = 26;

            this.btnHistory.Text = "View Revision History";

            this.btnHistory.Click += new System.EventHandler(this.btnHistory_Click);

            // 

            this.layoutControlGroupMain.Size = new System.Drawing.Size(261, 631);

            this.emptySpaceItem1.Size = new System.Drawing.Size(237, 354);

            this.layoutControlItem13,

            this.layoutControlItem17});

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

            this.layoutControlGroup1.Size = new System.Drawing.Size(261, 243);

            // layoutControlItem17

            // 

            this.layoutControlItem17.Control = this.btnHistory;

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

            this.layoutControlItem17.Name = "layoutControlItem17";

            this.layoutControlItem17.Size = new System.Drawing.Size(237, 40);

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

            this.layoutControlItem17.TextVisible = false;

            // 

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

        private DevExpress.XtraEditors.SimpleButton btnHistory;

        private DevExpress.XtraLayout.LayoutControlItem layoutControlItem17;

                DataTable oldPSN = DB.GetPipeSystemNetwork(); 

                    DataRow selectRow = oldPSN.Select(string.Format("OID = '{0}' AND OrderNumber = '{1}'", row["OID"].ToString(), row["OrderNumber"].ToString())).FirstOrDefault();

            PSNPageDT.Columns.Add("Drawings", typeof(string));          

            PSNPageDT.Columns.Add("EGTag", typeof(string));

            PSNPageDT.Columns.Add("HasMLTags", typeof(string));

            PSNPageDT.Columns.Add("Pocket", typeof(string));

            PSNPageDT.Columns.Add("Status", typeof(string));

            gridViewPSN.Columns["EGTag"].DisplayFormat.FormatString = "EG Tag";

            gridViewPSN.Columns["HasMLTags"].DisplayFormat.FormatString = "ML Tags";

            gridViewPSN.Columns["IsValid"].DisplayFormat.FormatString = "Validity";

            gridViewPathItems.Columns["EqpGroupTag"].Caption = "EG Tag";

            gridViewPathItems.Columns["MainLineTag"].Caption = "ML Tag";

            gridViewPathItems.Columns["EGTConnectedPoint"].Caption = "EG Point";

            gridViewPathItems.Columns["EGFlowDirection"].Caption = "EG Flow";

        private void btnHistory_Click(object sender, EventArgs e)

        {

            HistoryForm form = new HistoryForm();

            form.ShowDialog();

        }

  <data name="btnHistory.ImageOptions.Image" type="System.Drawing.Bitmap, System.Drawing" mimetype="application/x-microsoft.net.object.bytearray.base64">

    <value>

        iVBORw0KGgoAAAANSUhEUgAAACAAAAAgCAYAAABzenr0AAAABGdBTUEAALGPC/xhBQAAABN0RVh0VGl0

        bGUASGlzdG9yeTtJdGVtO5A9JW8AAAozSURBVFhHxVZ5VJNXFne0nel0mbZ2s9NO21PbGbV2usmZdmgL

        1qkLddeKWrVUBaG4ASJWRBEBrSIgIjtBlB2CgECABNlXCRAVSEgg7FsIIYABbU9/c98HiWCZ6Zm/Juf8

        znvf+/Ld3+/ed+99bwaA/ytmuLq6/k+g3+8mYeZDMLyb7tvpMO3iw9Ab3ezO/9OuS4UbLYNKY62CysRW

        QaVtNMIysKRtV2Bx9c5LxbEWF/I2rnHiPU3/5wRNZ28ypl2cDGZkw/Ho2d9dKvLZHVymO86/g5DiDiTe

        0iBNNgyhchTX6rS4WqXChdxWOMXU4lu/Qt1WL+GFpba+z/+WEMPE/Hze8Skvxr2eud0n19ziYtGAZ7oM

        2YoRCFtHcV2hwzXZXSQ2jCD61hAiawcRJRlC3O0h8OuHESfRwDnhNjafFWnXnUzdQnYe+U8iDJNNXnnY

        dO4GJ2KCfNZmL6HbnpAypNYPIIc8TZKOIJ4IYuuGEENkkTWDCL05gNCqCXBzDcLFAyRGi7Cybmzzzscq

        l5TTZO9Rwkw9nx4PBJy7AZ9sBTb8KDrByL8+k+22n1dJXg+DLx1GNBFGSbS4UqvlPA4jwoByNQL/C8JI

        0OWbfdjhm49lRxI9yO7vCVMiYZhsPJuL8p778M6SY71nVoLFxUJkEXksEV8mT8MnPAyuUMO3sA/n8/vg

        X6ICr1KNK9UDiKrVEIiQ5uFVavpfPy7R+0tlKoSV92KtmwAme3nbJyJhEGEQsOGMCCVd97hQnxc0Ikmi

        QtQtLUIqB8ibfviX9sO7oBencrpxWtSFoFIVzgtbYRMqxlqPG1jqIsA/HVJpzMIaerYJE8O/qAd+xb3w

        K+mFr6gVXxzma+ab7X+VRVgvwiBg/ekcFHaMUVJpcb1xBFcp1Iz4YnE/edsLV0EHjqS24VRWB87ltGPL

        +WJ8Zp+MbSf58IoUIj6rElUSKfjCargGZcH8xDWYOKbhVIYSPoW9ZKcPtqHlMP4+/AKRP0YY7xt6Aes8

        s5HXNgqeWINgCqs/ecg8PiHohAO/BXZJLXBOa4NzkgyfH07HjlOJyLghhlTRga5eDVQDw9AM6aAevIuu

        vkGkiCQ4GSyEyQ+Z8MhqIye64ZvXCVP7uNE5Cxe/RORcZXDkbLLGPQuiFh2CKXk44swOjnRffDO+j22G

        I4lwjGuA8aFUuAakQ1LXzBGpNCPoJ9IH0KFfo4O8pR/8nFvY55ODdT8WwIsEeOV3YatXLj7a4WNNnH+Y

        LGDmqlMCpEuHcDy9HfZEvJ+IbaKbYHVVAZuoJhxLVcLEKQNH/VJxq6EVHb2D6O4fQreKQGMXG1XDBrT3

        aCEolCEuswbLjmXiaLIcZ4SdsIushtGukBTifILx6gXMWuWaiXhqIPZJSs5rayLdFSnHt7xG7I0hMZfv

        wPRgDJIFpVC09KGtZ3AK2ru1aOMwiNauQbR0aiAqlSOjoAGOgYWwCKyCh7AdLskyGFlGyInzGcIjegGP

        mJ1IR2yNmjxvgjV5zsh3hDdia4gMmwKl2B+nhGVQBSzdE1B0sx6KVhWUHQNoblfTqOHQTGhqZ2sDuCPv

        RV5FE4QlcgQnV8PsVB7cstvgmt4CI6uIYeJkbfpRg4AVLmlcPw+rUCGASsc3v4dC1gU3QRdcrnfAKaUd

        R9PaYeFfDuszSSgRyxDIS8DWXQcRFJEERZuaRI1DplShXNKGQrES+ZVN4IvqYHo0m/KqFScJiywj6Bye

        wRKRNSau7T5qejgFnx9KhrE9H58c4MNoXxI+tE3EezYJWLgnAQss4/G33fF4e2cc5n4XB+tzGTBbtx2H

        AtKwcvVm5Ji8C5HxfAiM3kLae2+AP/9VxL/1EqJffx65FQp8cjiDHFHiGOGj3ZyAl6cIIDy35FD8mFUQ

        eRhSicVOaeDxixGdWoKE9DIkU52nicQQ5NUiv7wevKhrMDY1g5HxUmz8xhpnL8XCLzwV/hHXERiZieCo

        LITG5CA8ToTg2FyYOOfgaGozDic14n2LEB3xzSEYBLCanL3KJVnhliaHu6AV5j6luF6qhLiuE7XSbtxp

        7EFDUx8X3sQUIZav3oq99q5ISMlFVW0j6hXdaGjuo7EXt2U9kNA31fVdqLzdDn6hAmbu+XC61gT7mDq8

        uz2gifjYFjDHDQKeXn44Js0pVgK3jBZYhtXAJ+UOJA1dXEJJybi8tR8J14RYsmIj7H84jaLKBq7cWMYr

        CSwBGykHpCRSL6SWRJxJkmDrxUrqJQpYBpRhwddemcT3HMEggLXFJz+z9D2w06+Ay1THRMr+80VobCGD

        HLka8cnZ+OyL1Tjg5IGSKil6+oc5dPYOoZ3ASpCJYQkpVfajTtHHiVnlkQebK3VwSFJgJSX73BVHHIiP

        3ZpmGToh4bGXF3w69yvnlDG3NNZ4mrHBuxThQjmU5BkruX98ugx7D7mhXCyl1nsXaup4as1d9A2MoEc9

        Qs1omBrUEFq6xkWwiggWSGHmWQC7hEY4xkvx3o7Qsade+fs84vsjxztJANuGZz+3CQqzCiiBcwrtF32w

        wjMfFdJedPZpEcXPRUW1DAPUcgeHRqEdHsMQYUBL7ZdaMBPSTRFp7x1vSCX1PVh8XAQrXi3sScAGj2y8

        vcY9gnjGe8BDAtg2PP7qB8vfWeIQqz2W1EAZq8CeiNtYe6YQYrmKiNlho8Pg8ChG7o5Bp7sP3eh9DN29

        R2tjUGtHSQSdB4RKWR81nxvYEVyDfTEyHLwqwTvfBGqfefPj94lnvA3rBUwSwVQ98+Fmt73LjiRzbdMh

        Xo7dPAmWUxZH5jVjaOQedGM/YfTeTxi79zPu3/+Zex7R3SPcpxORTtRcBZacEGF7UA1so6RwoENsEdX+

        60sOHiT7syd4pt4H2MIE2Cn1wqLtPgFmzqk4ypfBLk6GPZF3sPJsMdafLUJwthziJjVU2jH88ssv6NGM

        4qa8HwFZjVh9ugDLPQvxXdgt2EY3wCG2Hsa20Xjzq+NBZJfVvuEuMEXAJBHsJUuQOR9+4x1qahcPh+jb

        cOLLOYMWoRKs9S7HlxQRU/LyU2c6811E+MItD6vPlWIbeb3nSj3tuQwHiPyjneF40+wEj+z9mfD4hP1f

        X8kMC+Mi2JWJiXhx3sofDiyy5A2vp+PaMYHlhRwHY6WwudpAUamHJZ2SeyLrYE2k+0jgIUo2+9g6mB27

        jvnm/rrXFu+3IzvMc0ZuuIoZ+CY/GBYfiGDhmv3iwqVGC829kj6wCB/70omPbT4FsOXVUHjruHOedTeb

        cDG20NV+sR2dG5sDfpq7yp3/7NsmH9P3LOOZM78i57geXtCD/ZnAwsUS5knCC0+9snDBG/+y2z9vw1nB

        gk2+0nnmF9XztwRg3iY/9V/Xe0vfWu2Z8xeTvQeemDP/Hfr/i4SnCKzfTwn7FJ7pFvVgH01AL4SFkV0k

        mHG2p+yG+9rEyJ7ZOnvPysxAzDCdfYZpFx+G3giBGWShZGIYAasYtk1sZM9snb3/TeJxuM74N5Op7UHB

        IbOtAAAAAElFTkSuQmCC

</value>

  </data>

    <value>25</value>

                repositoryAttributeItem.Items.Clear();

                repositoryAttributeItem.Items.Add("");

    <Compile Include="Form\HistoryForm.cs">

      <SubType>Form</SubType>

    </Compile>

    <Compile Include="Form\HistoryForm.Designer.cs">

      <DependentUpon>HistoryForm.cs</DependentUpon>

    </Compile>

    <EmbeddedResource Include="Form\HistoryForm.resx">

      <DependentUpon>HistoryForm.cs</DependentUpon>

    </EmbeddedResource>

            splashScreenManager1.SetWaitFormDescription(i++ + " / 19  UpdateSubType ( 60 % )");

            splashScreenManager1.SetWaitFormDescription(i++ + " / 19  UpdateErrorForPSN ( 65 % )");

            PathItemSorting();

            splashScreenManager1.SetWaitFormDescription(i++ + " / 19  InsertTeePSN ( 70 % )");

            splashScreenManager1.SetWaitFormDescription(i++ + " / 19  UpdateValveGrouping ( 75 % )");

            splashScreenManager1.SetWaitFormDescription(i++ + " / 19  PathItemSorting ( 80 % )");

            splashScreenManager1.SetWaitFormDescription(i++ + " / 19  UpdateAirFinCooler ( 85 % )");

            // Vent/Drain PSN 데이터 제거

            splashScreenManager1.SetWaitFormDescription(i++ + " / 19  DeleteVentDrain ( 90 % )");

            DeleteVentDrain();

            // 확도 계산

            splashScreenManager1.SetWaitFormDescription(i++ + " / 19  UpdateAccuracy ( 95 % )");

            UpdateAccuracy();

            //UpdatePSNType();

        }

        private void UpdatePSNType()

        {

            try

            {

                foreach (PSNItem PSNItem in PSNItems)

                {    

                    foreach (Group group in PSNItem.Groups)

                    {

                        foreach (Item item in group.Items)

                        {

                            DataRow[] pipeSystems = PipeSystemNetwork.Select(string.Format("OID = '{0}'", PSNItem.PSN_OID()));

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

                            foreach(DataRow dr in pipeSystems)

                            {

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

                            }                            

                        }

                    }                

                }

            }

            catch (Exception ex)

            {

                MessageBox.Show(ex.Message, "ID2 ", MessageBoxButtons.OK, MessageBoxIcon.Error);

            }

                int afcTagNum = 0;

                DataRow[] airFinCoolerRows = PipeSystemNetwork.Select("AFC = 'P1'");

                    DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", dataRow["OID"].ToString()));

                    foreach (DataRow dr in pathItemRows)

                    {

                        dr["EqpGroupTag"] = "AFC" + string.Format("-{0}", string.Format("{0:D3}", afcTagNum));

                    }

                }

                foreach (DataRow dataRow in airFinCoolerRows)

                {

                    string AFCTag = pathItemRows.Where(x => !string.IsNullOrEmpty(x.Field<string>("EqpGroupTag"))).First().Field<string>("EqpGroupTag");

                    List<string> lstViewPipeSystemNetwork_OID = pathItemRows.Select(x => x.Field<string>("ViewPipeSystemNetwork_OID")).ToList();

                                if (lstViewPipeSystemNetwork_OID.Where(x => x.Equals(viewOID)).Count() == 1)

                                {

                                    MainLineTag = "M";

                                    dataRow["AFC"] = "P3";

                                }

                                else if(lstViewPipeSystemNetwork_OID.Where(x => x.Equals(viewOID)).Count() > 1)

                                    DataRow[] viewpipeSystem = PipeSystemNetwork.Select(string.Format("OID = '{0}'", viewOID));

                                    foreach (DataRow row in viewpipeSystem)

                                    {

                                        row["AFC"] = "P4";

                                    }

                                    if(viewpathItemRows.Where(x => !string.IsNullOrEmpty(x.Field<string>("EqpGroupTag"))).Count() > 0)

                                        AFCTag = viewpathItemRows.Where(x => !string.IsNullOrEmpty(x.Field<string>("EqpGroupTag"))).First().Field<string>("EqpGroupTag");                                    

                                       // viewdr["EqpGroupTag"] = AFCTag;

                        }                            

                        dr["EqpGroupTag"] = AFCTag;// "AFC" + string.Format("-{0}", string.Format("{0:D3}", afcTagNum));  //ATG Sequence No Rule 여쭤봐야함.

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

                                    if (!string.IsNullOrEmpty(dr.Field<string>("ViewPipeSystemNetwork_OID")) && !lstpsn.Contains(dr.Field<string>("ViewPipeSystemNetwork_OID")))

                                    {

                                        lstAll.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));

                                    }

                        while (lstpsn.Count() != 0)

                            int lstCount = lstpsn.Count;

                            for (int i = 0; i < lstpsn.Count(); i++) //string psn in lstpsn

                                DataRow[] rule4pathItems = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", lstpsn[i]));

                                    if (!string.IsNullOrEmpty(dr.Field<string>("ViewPipeSystemNetwork_OID")) && !lstAll.Contains(dr.Field<string>("ViewPipeSystemNetwork_OID")))

                                    {

                                        lstAll.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));

                                    }

                                    if (dr["EqpGroupTag"].Equals(EqpGroupTag))

                                        continue;

                                    dr["EqpGroupTag"] = EqpGroupTag;                                  

                                lstpsn.Remove(lstpsn[i]);

                    if (drPathitem["PipeSystemNetwork_OID"].ToString().Contains("901"))

                    {

                    }

                        if (!string.IsNullOrEmpty(dr["BranchTopologySet_OID"].ToString()))

                                //break;

                            {

                                if (rows.First()["SubType"].ToString() != "Bypass" && rows.First()["SubType"].ToString() != "Vent_Drain")

                                {

                                    // bCheck = true;

                                    if (lstitem.ToList().Where(x => !string.IsNullOrEmpty(x.Field<string>("GROUPTAG"))).Count() > 0)

                                    {

                                        lstitem.Add(dr);

                                        keyValuePairs.Add(bCnt, lstitem.ToList());

                                        lstitem.Clear();

                                    }

                                    else

                                    {

                                        keyValuePairs.Add(bCnt, lstitem.ToList());

                                        lstitem.Clear();

                                        lstitem.Add(dr);

                                    }

                                    bCnt++;

                                }

                                else

                                    lstitem.Add(dr);

                            }

                    if (valveitem.AttributeName == "NoSelection" || valveitem.AttributeName == string.Empty)

                        if(string.IsNullOrEmpty(valvetag[1]))

                            VGTag = valveitem.TagIdentifier + string.Format("-{0}", string.Format("{0:D5}", vgTagNum));

                        else

                            VGTag = valveitem.TagIdentifier + "-" + valvetag[1] + string.Format("-{0}", string.Format("{0:D5}", vgTagNum));

                        vgTagNum++;

                                if(!string.IsNullOrEmpty(dr["BranchTopologySet_OID"].ToString()))

                                {

                                    if(TopologySet.Select(string.Format("OID = '{0}'", dr["BranchTopologySet_OID"].ToString())).First().Field<string>("SubType") == "Bypass")

                                    {

                                        DataRow[] rows = keyValuePair.Value.Where(x => x.Field<string>("ViewPipeSystemNetwork_OID").Equals(dr["ViewPipeSystemNetwork_OID"].ToString())).ToArray();