HYTOS

            DataTable dtPathItems = PathItems.Clone();

            DataTable dtPipeSystemNetwork = PipeSystemNetwork.DefaultView.ToTable(true, new string[] { "OID" });

            foreach (DataRow drpipe in dtPipeSystemNetwork.Rows)

            {

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

                DataTable dtSequenceItems = SequenceData.Clone();

                foreach (DataRow drpath in pathItemRows)

                {

                    DataRow sequenceRows = SequenceData.Select(string.Format("PathItem_OID = '{0}'", drpath.Field<string>("OID"))).First();

                    DataRow newRow = dtSequenceItems.NewRow();

                    foreach (DataColumn column in SequenceData.Columns)

                        if (dtSequenceItems.Columns[column.ColumnName] != null)

                            newRow[column.ColumnName] = sequenceRows[column.ColumnName];

                    dtSequenceItems.Rows.Add(newRow);

                }

                foreach (DataRow sqrow in dtSequenceItems.Select().OrderBy(x => Convert.ToInt32(x.Field<string>("SERIALNUMBER"))))

                    DataRow newRow = dtPathItems.NewRow();

                    DataRow row = PathItems.Select(string.Format("OID = '{0}'", sqrow["PathItem_OID"])).First();

                    foreach (DataColumn column in PathItems.Columns)

                        if (dtPathItems.Columns[column.ColumnName] != null)

                            newRow[column.ColumnName] = row[column.ColumnName];

                    dtPathItems.Rows.Add(newRow);

                }

                //foreach (DataRow sqrow in datasqDT.Select().OrderBy(x => Convert.ToInt32(x.Field<string>("SERIALNUMBER"))))

                //{

                //    DataRow newRow = gridDT.NewRow();

                    //    DataRow row = dataDT.Select(string.Format("OID = '{0}'", sqrow["PathItem_OID"])).First();

                    //    foreach (DataColumn column in dataDT.Columns)

                    //        if (gridDT.Columns[column.ColumnName] != null)

                    //            newRow[column.ColumnName] = row[column.ColumnName];

                    //    gridDT.Rows.Add(newRow);

                    //}

            PathItems.Clear();

            PathItems = dtPathItems.Copy();

            // AirFinCooler 

            UpdateAirFinCooler();