개정판 bfbc9f6c
issue #000:
Change-Id: I11d4ffc99b26ccefaf7012c2336afa4e0a71983d
| DTI_PID/ID2PSN/PSN.cs | ||
|---|---|---|
| 364 | 364 |
EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Add(new EquipmentAirFinCoolerItem() |
| 365 | 365 |
{
|
| 366 | 366 |
Type = row["Type"].ToString(), |
| 367 |
TagIdentifier = row["TagIdentifier"].ToString(), |
|
| 368 |
AttributeName = row["AttributeName"].ToString(), |
|
| 367 | 369 |
Name = row["Name"].ToString() |
| 368 | 370 |
}); |
| 369 | 371 |
} |
| ... | ... | |
| 373 | 375 |
DataRow[] pumpRows = PipeSystemNetwork.Select("PUMP = 'PUMP'");
|
| 374 | 376 |
// 1, 2번 |
| 375 | 377 |
foreach (DataRow dataRow in pumpRows) |
| 376 |
{
|
|
| 377 |
pumpTagNum++; |
|
| 378 |
|
|
| 378 |
{
|
|
| 379 | 379 |
DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", dataRow["OID"].ToString()));
|
| 380 | 380 |
|
| 381 |
string eqTag = string.Empty; |
|
| 381 |
string EGTAG = "EGTAG"; |
|
| 382 |
string ItemTag = "ItemTag"; |
|
| 382 | 383 |
string EGFlowDirection = string.Empty; |
| 384 |
string Prefix = string.Empty; |
|
| 385 |
Dictionary<string, string> eqkeyValuePairs = new Dictionary<string, string>(); |
|
| 386 |
|
|
| 383 | 387 |
PSNItem PSNItem = PSNItems.Find(x => x.PSN_OID() == dataRow["OID"].ToString()); |
| 384 | 388 |
if (PSNItem.Groups.First().Items.First().Equipment != null) |
| 385 | 389 |
{
|
| 386 | 390 |
if (EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type == "Pump" && PSNItem.Groups.First().Items.First().Equipment.Name.Contains(x.Name)).Count() > 0) |
| 387 | 391 |
{
|
| 388 |
eqTag = PSNItem.Groups.First().Items.First().Equipment.ItemTag; |
|
| 392 |
EquipmentAirFinCoolerItem equipmentAirFinCoolerItem = EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type == "Pump" && PSNItem.Groups.First().Items.First().Equipment.Name.Contains(x.Name)).First(); |
|
| 393 |
if (!string.IsNullOrEmpty(equipmentAirFinCoolerItem.AttributeName)) |
|
| 394 |
EGTAG = PSNItem.Groups.First().Items.First().Equipment.Attributes.Find(x => x.Name == equipmentAirFinCoolerItem.AttributeName) == null |
|
| 395 |
? string.Empty : PSNItem.Groups.First().Items.First().Equipment.Attributes.Find(x => x.Name == equipmentAirFinCoolerItem.AttributeName).Value; |
|
| 396 |
|
|
| 397 |
ItemTag = PSNItem.Groups.First().Items.First().Equipment.ItemTag; |
|
| 398 |
Prefix = equipmentAirFinCoolerItem.TagIdentifier; |
|
| 399 |
EGTAG = Prefix + "-" + EGTAG; |
|
| 389 | 400 |
EGFlowDirection = "O"; |
| 390 | 401 |
} |
| 391 | 402 |
} |
| ... | ... | |
| 393 | 404 |
{
|
| 394 | 405 |
if (EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type == "Pump" && PSNItem.Groups.Last().Items.Last().Equipment.Name.Contains(x.Name)).Count() > 0) |
| 395 | 406 |
{
|
| 396 |
eqTag = PSNItem.Groups.Last().Items.Last().Equipment.ItemTag; |
|
| 407 |
EquipmentAirFinCoolerItem equipmentAirFinCoolerItem = EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type == "Pump" && PSNItem.Groups.Last().Items.Last().Equipment.Name.Contains(x.Name)).First(); |
|
| 408 |
if (!string.IsNullOrEmpty(equipmentAirFinCoolerItem.AttributeName)) |
|
| 409 |
EGTAG = EGTAG = PSNItem.Groups.Last().Items.Last().Equipment.Attributes.Find(x => x.Name == equipmentAirFinCoolerItem.AttributeName) == null |
|
| 410 |
? string.Empty : PSNItem.Groups.Last().Items.Last().Equipment.Attributes.Find(x => x.Name == equipmentAirFinCoolerItem.AttributeName).Value; |
|
| 411 |
|
|
| 412 |
ItemTag = PSNItem.Groups.Last().Items.Last().Equipment.ItemTag; |
|
| 413 |
Prefix = equipmentAirFinCoolerItem.TagIdentifier; |
|
| 414 |
EGTAG = Prefix + "-" + EGTAG; |
|
| 397 | 415 |
EGFlowDirection = "I"; |
| 398 | 416 |
} |
| 399 | 417 |
} |
| 400 | 418 |
|
| 401 |
if(!string.IsNullOrEmpty(eqTag)) |
|
| 419 |
//Attribute가 세팅되어있지 않다면 |
|
| 420 |
if (EGTAG.Equals("EGTAG"))
|
|
| 402 | 421 |
{
|
| 403 |
foreach (DataRow dr in pathItemRows)
|
|
| 422 |
if (!eqkeyValuePairs.ContainsKey(ItemTag))
|
|
| 404 | 423 |
{
|
| 405 |
dr["EqpGroupTag"] = eqTag; |
|
| 406 |
dr["EGFlowDirection"] = EGFlowDirection; |
|
| 424 |
pumpTagNum++; |
|
| 425 |
EGTAG = Prefix + string.Format("-{0}", string.Format("{0:D5}", pumpTagNum));
|
|
| 426 |
eqkeyValuePairs.Add(ItemTag, EGTAG); |
|
| 427 |
} |
|
| 428 |
else |
|
| 429 |
{
|
|
| 430 |
EGTAG = eqkeyValuePairs[ItemTag]; |
|
| 407 | 431 |
} |
| 408 | 432 |
} |
| 433 |
|
|
| 434 |
foreach (DataRow dr in pathItemRows) |
|
| 435 |
{
|
|
| 436 |
dr["EqpGroupTag"] = EGTAG; |
|
| 437 |
dr["EGFlowDirection"] = EGFlowDirection; |
|
| 438 |
} |
|
| 409 | 439 |
} |
| 410 | 440 |
|
| 411 | 441 |
// 3, 4번 |
| ... | ... | |
| 671 | 701 |
Dictionary<string, string> keyValuePairs = new Dictionary<string, string>(); |
| 672 | 702 |
foreach (DataRow dataRow in airFinCoolerRows) |
| 673 | 703 |
{
|
| 674 |
string[] afcTag = dataRow.Field<string>("AFC").Split(new string[] { "\\" }, StringSplitOptions.None);
|
|
| 675 |
if (afcTag.Length > 1) |
|
| 676 |
{
|
|
| 677 |
string afc = string.Empty; |
|
| 678 |
if(!keyValuePairs.ContainsKey(afcTag[1])) |
|
| 679 |
{
|
|
| 680 |
afcTagNum++; |
|
| 681 |
afc = "AFC" + string.Format("-{0}", string.Format("{0:D3}", afcTagNum));
|
|
| 682 |
keyValuePairs.Add(afcTag[1], afc); |
|
| 683 |
} |
|
| 684 |
else |
|
| 685 |
{
|
|
| 686 |
afc = keyValuePairs[afcTag[1]]; |
|
| 687 |
} |
|
| 688 |
|
|
| 689 |
DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", dataRow["OID"].ToString()));
|
|
| 690 |
foreach (DataRow dr in pathItemRows) |
|
| 691 |
{
|
|
| 692 |
dr["EqpGroupTag"] = afc; |
|
| 693 |
} |
|
| 694 |
} |
|
| 695 |
} |
|
| 696 |
|
|
| 697 |
foreach (DataRow dataRow in airFinCoolerRows) |
|
| 698 |
{
|
|
| 699 |
|
|
| 700 | 704 |
string EGFlowDirection = string.Empty; |
| 701 |
|
|
| 705 |
string EGTAG = "EGTAG"; |
|
| 706 |
string Prefix = string.Empty; |
|
| 707 |
//item.Attributes.Find(x => x.Name == valveitem.AttributeName).Value; |
|
| 702 | 708 |
PSNItem PSNItem = PSNItems.Find(x => x.PSN_OID() == dataRow["OID"].ToString()); |
| 703 | 709 |
if (PSNItem.Groups.First().Items.First().Equipment != null) |
| 704 | 710 |
{
|
| 705 | 711 |
if (EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type != "Pump" && PSNItem.Groups.First().Items.First().Equipment.Name.Contains(x.Name)).Count() > 0) |
| 706 | 712 |
{
|
| 713 |
EquipmentAirFinCoolerItem equipmentAirFinCoolerItem = EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type != "Pump" && PSNItem.Groups.First().Items.First().Equipment.Name.Contains(x.Name)).First(); |
|
| 714 |
if(!string.IsNullOrEmpty(equipmentAirFinCoolerItem.AttributeName)) |
|
| 715 |
EGTAG = PSNItem.Groups.First().Items.First().Equipment.Attributes.Find(x => x.Name == equipmentAirFinCoolerItem.AttributeName) == null |
|
| 716 |
? string.Empty : PSNItem.Groups.First().Items.First().Equipment.Attributes.Find(x => x.Name == equipmentAirFinCoolerItem.AttributeName).Value; |
|
| 717 |
|
|
| 718 |
Prefix = equipmentAirFinCoolerItem.TagIdentifier; |
|
| 719 |
EGTAG = Prefix + "-" + EGTAG; |
|
| 707 | 720 |
EGFlowDirection = "O"; |
| 708 | 721 |
} |
| 709 | 722 |
} |
| ... | ... | |
| 711 | 724 |
{
|
| 712 | 725 |
if (EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type != "Pump" && PSNItem.Groups.Last().Items.Last().Equipment.Name.Contains(x.Name)).Count() > 0) |
| 713 | 726 |
{
|
| 727 |
EquipmentAirFinCoolerItem equipmentAirFinCoolerItem = EquipmentAirFinCooler.EquipmentAirFinCoolerItem.Where(x => x.Type != "Pump" && PSNItem.Groups.Last().Items.Last().Equipment.Name.Contains(x.Name)).First(); |
|
| 728 |
if (!string.IsNullOrEmpty(equipmentAirFinCoolerItem.AttributeName)) |
|
| 729 |
EGTAG = PSNItem.Groups.Last().Items.Last().Equipment.Attributes.Find(x => x.Name == equipmentAirFinCoolerItem.AttributeName) == null |
|
| 730 |
? string.Empty : PSNItem.Groups.Last().Items.Last().Equipment.Attributes.Find(x => x.Name == equipmentAirFinCoolerItem.AttributeName).Value; |
|
| 731 |
|
|
| 732 |
Prefix = equipmentAirFinCoolerItem.TagIdentifier; |
|
| 733 |
EGTAG = Prefix + "-" + EGTAG; |
|
| 714 | 734 |
EGFlowDirection = "I"; |
| 715 | 735 |
} |
| 716 | 736 |
} |
| 717 | 737 |
|
| 738 |
if(!string.IsNullOrEmpty(EGFlowDirection)) |
|
| 739 |
{
|
|
| 740 |
string[] afcTag = dataRow.Field<string>("AFC").Split(new string[] { "\\" }, StringSplitOptions.None);
|
|
| 741 |
|
|
| 742 |
//Attribute가 세팅되어있지 않다면 |
|
| 743 |
if (EGTAG.Equals("EGTAG"))
|
|
| 744 |
{
|
|
| 745 |
if (!keyValuePairs.ContainsKey(afcTag[1])) |
|
| 746 |
{
|
|
| 747 |
afcTagNum++; |
|
| 748 |
EGTAG = Prefix + string.Format("-{0}", string.Format("{0:D5}", afcTagNum));
|
|
| 749 |
keyValuePairs.Add(afcTag[1], EGTAG); |
|
| 750 |
} |
|
| 751 |
else |
|
| 752 |
{
|
|
| 753 |
EGTAG = keyValuePairs[afcTag[1]]; |
|
| 754 |
} |
|
| 755 |
} |
|
| 756 |
|
|
| 757 |
DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", dataRow["OID"].ToString()));
|
|
| 758 |
foreach (DataRow dr in pathItemRows) |
|
| 759 |
{
|
|
| 760 |
dr["EqpGroupTag"] = EGTAG; |
|
| 761 |
dr["EGFlowDirection"] = EGFlowDirection; |
|
| 762 |
} |
|
| 763 |
} |
|
| 764 |
|
|
| 765 |
} |
|
| 766 |
|
|
| 767 |
List<string> changePSN = new List<string>(); |
|
| 768 |
foreach (DataRow dataRow in airFinCoolerRows) |
|
| 769 |
{
|
|
| 770 |
if (changePSN.Contains(dataRow["OID"].ToString())) |
|
| 771 |
continue; |
|
| 772 |
|
|
| 718 | 773 |
DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", dataRow["OID"].ToString()));
|
| 719 |
string AFCTag = pathItemRows.Where(x => !string.IsNullOrEmpty(x.Field<string>("EqpGroupTag"))).First().Field<string>("EqpGroupTag");
|
|
| 720 |
List<string> lstViewPipeSystemNetwork_OID = pathItemRows.Select(x => x.Field<string>("ViewPipeSystemNetwork_OID")).ToList();
|
|
| 721 |
//ViewPipeSystemNetwork_OID |
|
| 722 |
string MainLineTag = ""; |
|
| 774 |
string AFCTag = string.Empty; |
|
| 775 |
if (pathItemRows.Where(x => !string.IsNullOrEmpty(x.Field<string>("EqpGroupTag"))).Count() > 0)
|
|
| 776 |
AFCTag = pathItemRows.Where(x => !string.IsNullOrEmpty(x.Field<string>("EqpGroupTag"))).First().Field<string>("EqpGroupTag");
|
|
| 777 |
|
|
| 778 |
List<string> lstViewPipeSystemNetwork_OID = pathItemRows.Select(x => x.Field<string>("ViewPipeSystemNetwork_OID")).Distinct().ToList();
|
|
| 779 |
|
|
| 723 | 780 |
if (dataRow["Type"].ToString() == "E2E") |
| 724 | 781 |
{
|
| 725 |
MainLineTag = "M"; |
|
| 726 |
dataRow["AFC"] = "P3"; |
|
| 782 |
foreach (DataRow dr in pathItemRows) |
|
| 783 |
{
|
|
| 784 |
dr["MainLineTag"] = "M"; |
|
| 785 |
} |
|
| 786 |
dataRow["AFC"] = "P3"; |
|
| 727 | 787 |
} |
| 728 | 788 |
else if (dataRow["Type"].ToString() == "E2B" || dataRow["Type"].ToString() == "B2E") |
| 729 | 789 |
{
|
| 730 |
foreach (string viewOID in lstViewPipeSystemNetwork_OID)
|
|
| 731 |
{
|
|
| 732 |
if (viewOID == dataRow["OID"].ToString())
|
|
| 733 |
continue;
|
|
| 734 |
|
|
| 735 |
DataRow dr = PipeSystemNetwork.Select(string.Format("OID = '{0}'", viewOID)).First();
|
|
| 736 |
if (!dr.Field<string>("AFC").Contains("P1"))
|
|
| 790 |
foreach (string lstoid in lstViewPipeSystemNetwork_OID)
|
|
| 791 |
{
|
|
| 792 |
DataRow[] viewPathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", lstoid));
|
|
| 793 |
List<string> lstview = viewPathItemRows.Select(x => x.Field<string>("ViewPipeSystemNetwork_OID")).Distinct().ToList();
|
|
| 794 |
lstview.Remove(dataRow["OID"].ToString()); // P1인 자기 자신 제거 |
|
| 795 |
//제거 후 다른 P2를 확인
|
|
| 796 |
foreach (string lstvw in lstview)
|
|
| 737 | 797 |
{
|
| 738 |
if (lstViewPipeSystemNetwork_OID.Where(x => x.Equals(viewOID)).Count() == 1) |
|
| 798 |
DataRow[] pipesn = PipeSystemNetwork.Select(string.Format("OID = '{0}' AND AFC = 'P2'", lstvw));
|
|
| 799 |
if(pipesn.Count() > 0) |
|
| 739 | 800 |
{
|
| 740 |
MainLineTag = "M"; |
|
| 741 |
dataRow["AFC"] = "P3"; |
|
| 742 |
} |
|
| 743 |
else if(lstViewPipeSystemNetwork_OID.Where(x => x.Equals(viewOID)).Count() > 1) |
|
| 744 |
{
|
|
| 745 |
DataRow[] viewpipeSystem = PipeSystemNetwork.Select(string.Format("OID = '{0}'", viewOID));
|
|
| 746 |
foreach (DataRow row in viewpipeSystem) |
|
| 801 |
List<string> lstpipe = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", lstvw)).Select(x=>x.Field<string>("ViewPipeSystemNetwork_OID")).Distinct().ToList();
|
|
| 802 |
lstpipe.Remove(lstvw); //현재 자기 라인 제거 |
|
| 803 |
lstpipe.Remove(dataRow["OID"].ToString()); //기준 P1 제거 |
|
| 804 |
List<string> lstnewpipe = new List<string>(); |
|
| 805 |
foreach (string pipe in lstpipe) |
|
| 747 | 806 |
{
|
| 748 |
row["AFC"] = "P4"; |
|
| 807 |
if (airFinCoolerRows.Where(x => x.Field<string>("OID").Equals(pipe)).Count() > 0) //P1이면 리스트에 추가
|
|
| 808 |
lstnewpipe.Add(pipe); |
|
| 749 | 809 |
} |
| 750 | 810 |
|
| 751 |
DataRow[] viewpathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", viewOID));
|
|
| 752 |
|
|
| 753 |
//if(viewpathItemRows.Where(x => !string.IsNullOrEmpty(x.Field<string>("EqpGroupTag"))).Count() > 0)
|
|
| 754 |
// AFCTag = viewpathItemRows.Where(x => !string.IsNullOrEmpty(x.Field<string>("EqpGroupTag"))).First().Field<string>("EqpGroupTag");
|
|
| 755 |
afcTagNum++; |
|
| 756 |
AFCTag = "AFC" + string.Format("-{0}", string.Format("{0:D3}", afcTagNum));
|
|
| 757 |
foreach (DataRow viewdr in viewpathItemRows) |
|
| 811 |
if (lstnewpipe.Count() == 0) |
|
| 758 | 812 |
{
|
| 759 |
viewdr["EqpGroupTag"] = AFCTag; |
|
| 760 |
viewdr["MainLineTag"] = "M"; |
|
| 813 |
foreach (DataRow dr in pathItemRows) |
|
| 814 |
{
|
|
| 815 |
dr["MainLineTag"] = "M"; |
|
| 816 |
} |
|
| 817 |
dataRow["AFC"] = "P3"; |
|
| 818 |
} |
|
| 819 |
else if (lstnewpipe.Count() > 0) //P2에 기준 P1 말고 다른 P1이 있다면 P2에 ML값 AGT값 지정 후 P2에 연결된 모든 P1들의 AGT값 치환 |
|
| 820 |
{
|
|
| 821 |
// P2에 ML값 AGT값 지정 |
|
| 822 |
DataRow[] viewpathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", lstvw));
|
|
| 823 |
DataRow[] pipesystemRows = PipeSystemNetwork.Select(string.Format("OID = '{0}'", lstvw));
|
|
| 824 |
foreach (DataRow viewdr in pipesystemRows) |
|
| 825 |
{
|
|
| 826 |
viewdr["AFC"] = "P4"; |
|
| 827 |
} |
|
| 828 |
|
|
| 829 |
foreach (DataRow viewdr in viewpathItemRows) |
|
| 830 |
{
|
|
| 831 |
viewdr["EqpGroupTag"] = AFCTag; |
|
| 832 |
viewdr["MainLineTag"] = "M"; |
|
| 833 |
} |
|
| 834 |
// 연결된 모든 P1들의 AGT값 치환 |
|
| 835 |
foreach (string pipe in lstnewpipe) |
|
| 836 |
{
|
|
| 837 |
viewpathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", pipe));
|
|
| 838 |
foreach (DataRow viewdr in viewpathItemRows) |
|
| 839 |
{
|
|
| 840 |
viewdr["EqpGroupTag"] = AFCTag; |
|
| 841 |
} |
|
| 842 |
} |
|
| 761 | 843 |
} |
| 762 | 844 |
} |
| 763 |
} |
|
| 764 |
}
|
|
| 845 |
}
|
|
| 846 |
} |
|
| 765 | 847 |
} |
| 766 | 848 |
|
| 767 |
foreach (DataRow dr in pathItemRows) |
|
| 768 |
{
|
|
| 769 |
dr["EqpGroupTag"] = AFCTag;// "AFC" + string.Format("-{0}", string.Format("{0:D3}", afcTagNum)); //ATG Sequence No Rule 여쭤봐야함.
|
|
| 770 |
dr["MainLineTag"] = MainLineTag; |
|
| 771 |
dr["EGFlowDirection"] = EGFlowDirection; |
|
| 772 |
} |
|
| 773 | 849 |
} |
| 774 |
|
|
| 775 | 850 |
//P3을 제외한 P1 |
| 776 | 851 |
airFinCoolerRows = PipeSystemNetwork.Select("AFC Like 'P1%'");
|
| 777 | 852 |
foreach (DataRow dataRow in airFinCoolerRows) |
| 778 | 853 |
{
|
| 779 |
//ML이 공란 |
|
| 780 |
DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}' AND MainLineTag = ''", dataRow["OID"].ToString()));
|
|
| 781 |
|
|
| 854 |
DataRow[] pathItemRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", dataRow["OID"].ToString()));
|
|
| 855 |
|
|
| 782 | 856 |
if (pathItemRows.Count() > 0) |
| 783 | 857 |
{
|
| 784 | 858 |
List<string> lstViewPipeSystemNetwork_OID = pathItemRows.Select(x => x.Field<string>("ViewPipeSystemNetwork_OID")).Distinct().ToList();
|
| ... | ... | |
| 788 | 862 |
foreach (string viewOID in lstViewPipeSystemNetwork_OID) |
| 789 | 863 |
{
|
| 790 | 864 |
if (dataRow["OID"].ToString() == viewOID) |
| 865 |
{
|
|
| 866 |
lstAll.Add(viewOID); |
|
| 791 | 867 |
continue; |
| 868 |
} |
|
| 792 | 869 |
|
| 793 | 870 |
//P3이면 |
| 794 | 871 |
DataRow viewPSN = null; |
| ... | ... | |
| 798 | 875 |
if (viewPSN != null) |
| 799 | 876 |
{
|
| 800 | 877 |
//P3의 AGT를 가져와 P1에 입력 |
| 801 |
EqpGroupTag = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", viewOID)).First().Field<string>("EqpGroupTag");
|
|
| 878 |
if(string.IsNullOrEmpty(EqpGroupTag)) |
|
| 879 |
EqpGroupTag = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", viewOID)).First().Field<string>("EqpGroupTag");
|
|
| 880 |
|
|
| 802 | 881 |
foreach (DataRow dr in pathItemRows) |
| 803 | 882 |
{
|
| 883 |
|
|
| 804 | 884 |
dr["EqpGroupTag"] = EqpGroupTag; |
| 805 | 885 |
|
| 806 | 886 |
//P1의 AGT와 같은 모든 AGT를 P3의 AGT로 변경하기위해 |
| 807 | 887 |
if (!string.IsNullOrEmpty(dr.Field<string>("ViewPipeSystemNetwork_OID")) && !lstpsn.Contains(dr.Field<string>("ViewPipeSystemNetwork_OID")))
|
| 808 | 888 |
{
|
| 809 |
lstpsn.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));
|
|
| 810 |
lstAll.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));
|
|
| 889 |
//AND MainLineTag = '' |
|
| 890 |
if (PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}' ", dr.Field<string>("ViewPipeSystemNetwork_OID"))).Count() > 0)
|
|
| 891 |
{
|
|
| 892 |
lstpsn.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));
|
|
| 893 |
lstAll.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));
|
|
| 894 |
} |
|
| 811 | 895 |
} |
| 812 | 896 |
} |
| 813 | 897 |
} |
| ... | ... | |
| 815 | 899 |
} |
| 816 | 900 |
|
| 817 | 901 |
while (lstpsn.Count() != 0) |
| 818 |
{
|
|
| 819 |
int lstCount = lstpsn.Count;
|
|
| 820 |
for (int i = 0; i < lstpsn.Count(); i++) //string psn in lstpsn
|
|
| 902 |
{
|
|
| 903 |
DataRow[] rule4pathItems = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", lstpsn[0]));
|
|
| 904 |
foreach (DataRow dr in rule4pathItems)
|
|
| 821 | 905 |
{
|
| 822 |
|
|
| 823 |
DataRow[] rule4pathItems = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", lstpsn[i]));
|
|
| 824 |
foreach (DataRow dr in rule4pathItems) |
|
| 906 |
if (!string.IsNullOrEmpty(dr.Field<string>("ViewPipeSystemNetwork_OID")) && !lstAll.Contains(dr.Field<string>("ViewPipeSystemNetwork_OID")))
|
|
| 825 | 907 |
{
|
| 826 |
if (!string.IsNullOrEmpty(dr.Field<string>("ViewPipeSystemNetwork_OID")) && !lstAll.Contains(dr.Field<string>("ViewPipeSystemNetwork_OID")))
|
|
| 908 |
DataRow viewPSN = null; |
|
| 909 |
|
|
| 910 |
if (airFinCoolerRows.Where(x => x.Field<string>("OID") == dr.Field<string>("ViewPipeSystemNetwork_OID")).Count() > 0)
|
|
| 911 |
viewPSN = airFinCoolerRows.Where(x => x.Field<string>("OID") == dr.Field<string>("ViewPipeSystemNetwork_OID")).First();
|
|
| 912 |
|
|
| 913 |
//DataRow[] pathItemviewRows = PathItems.Select(string.Format("PipeSystemNetwork_OID = '{0}'", dr.Field<string>("ViewPipeSystemNetwork_OID")));
|
|
| 914 |
//if (pathItemviewRows.Select(x => x.Field<string>("MainLineTag") == "M").Count() > 0)
|
|
| 915 |
//{
|
|
| 916 |
//} |
|
| 917 |
if (viewPSN != null) |
|
| 827 | 918 |
{
|
| 828 |
DataRow viewPSN = null; |
|
| 829 |
//연결된 PathItem-Tee (P3인것만) 의 PathItem-Tee에 또 P3가 있다면 해당 PSN도 Tag변경 만약 P3가 아닌 모든 OID면 해당 로직 삭제 (위에로직도 변경필요) |
|
| 830 |
if (PipeSystemNetwork.Select(string.Format("OID = '{0}' AND AFC = 'P3'", dr.Field<string>("ViewPipeSystemNetwork_OID"))).Count() > 0)
|
|
| 831 |
viewPSN = PipeSystemNetwork.Select(string.Format("OID = '{0}' AND AFC = 'P3'", dr.Field<string>("ViewPipeSystemNetwork_OID"))).First();
|
|
| 832 |
if(viewPSN != null) |
|
| 833 |
{
|
|
| 834 |
lstpsn.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));
|
|
| 835 |
lstAll.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));
|
|
| 836 |
} |
|
| 919 |
lstpsn.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));
|
|
| 920 |
lstAll.Add(dr.Field<string>("ViewPipeSystemNetwork_OID"));
|
|
| 837 | 921 |
} |
| 922 |
} |
|
| 838 | 923 |
|
| 839 |
if (dr["EqpGroupTag"].Equals(EqpGroupTag)) |
|
| 840 |
continue; |
|
| 924 |
|
|
| 841 | 925 |
|
| 842 |
dr["EqpGroupTag"] = EqpGroupTag; |
|
| 843 |
} |
|
| 926 |
dr["EqpGroupTag"] = EqpGroupTag; |
|
| 844 | 927 |
|
| 845 |
lstpsn.Remove(lstpsn[i]); |
|
| 846 | 928 |
} |
| 847 |
|
|
| 929 |
lstpsn.Remove(lstpsn[0]); |
|
| 848 | 930 |
} |
| 849 | 931 |
} |
| 850 | 932 |
|
| ... | ... | |
| 971 | 1053 |
List<Item> valveGroupingItem = new List<Item>(); |
| 972 | 1054 |
int bCnt = 0; |
| 973 | 1055 |
|
| 974 |
//bool bCheck = false; |
|
| 975 |
if (drPathitem["PipeSystemNetwork_OID"].ToString().Contains("901"))
|
|
| 976 |
{
|
|
| 977 |
|
|
| 978 |
} |
|
| 1056 |
|
|
| 979 | 1057 |
List<DataRow> lstitem = new List<DataRow>(); |
| 980 | 1058 |
foreach (DataRow dr in pathItemRows) |
| 981 | 1059 |
{
|
| 982 |
//if (!string.IsNullOrEmpty(dr["GROUPTAG"].ToString())) |
|
| 983 |
// break; |
|
| 984 |
|
|
| 985 | 1060 |
if (!string.IsNullOrEmpty(dr["BranchTopologySet_OID"].ToString())) |
| 986 | 1061 |
{
|
| 987 | 1062 |
DataRow[] rows = TopologySet.Select(string.Format("OID = '{0}'", dr["BranchTopologySet_OID"].ToString()));
|
| ... | ... | |
| 991 | 1066 |
keyValuePairs.Add(bCnt, lstitem.ToList()); |
| 992 | 1067 |
bCnt++; |
| 993 | 1068 |
lstitem.Clear(); |
| 994 |
//break; |
|
| 995 | 1069 |
} |
| 996 | 1070 |
else |
| 997 | 1071 |
{
|
| 998 | 1072 |
if (rows.First()["SubType"].ToString() != "Bypass" && rows.First()["SubType"].ToString() != "Vent_Drain") |
| 999 | 1073 |
{
|
| 1000 |
// bCheck = true; |
|
| 1001 | 1074 |
if (lstitem.ToList().Where(x => !string.IsNullOrEmpty(x.Field<string>("GROUPTAG"))).Count() > 0)
|
| 1002 | 1075 |
{
|
| 1003 | 1076 |
lstitem.Add(dr); |
| ... | ... | |
| 1016 | 1089 |
else |
| 1017 | 1090 |
lstitem.Add(dr); |
| 1018 | 1091 |
} |
| 1019 |
|
|
| 1020 | 1092 |
} |
| 1021 | 1093 |
else |
| 1022 | 1094 |
lstitem.Add(dr); |
| ... | ... | |
| 1025 | 1097 |
if (lstitem.Count > 0) |
| 1026 | 1098 |
{
|
| 1027 | 1099 |
keyValuePairs.Add(bCnt, lstitem); |
| 1028 |
//bCnt++; |
|
| 1029 | 1100 |
} |
| 1030 | 1101 |
|
| 1031 | 1102 |
if (keyValuePairs.Count() == 0) |
| ... | ... | |
| 1039 | 1110 |
} |
| 1040 | 1111 |
else |
| 1041 | 1112 |
{
|
| 1042 |
if(string.IsNullOrEmpty(valvetag[1])) |
|
| 1043 |
VGTag = valveitem.TagIdentifier + string.Format("-{0}", string.Format("{0:D5}", vgTagNum));
|
|
| 1044 |
else |
|
| 1045 |
VGTag = valveitem.TagIdentifier + "-" + valvetag[1] + string.Format("-{0}", string.Format("{0:D5}", vgTagNum));
|
|
| 1046 |
|
|
| 1047 |
vgTagNum++; |
|
| 1113 |
//if(string.IsNullOrEmpty(valvetag[1])) |
|
| 1114 |
// VGTag = valveitem.TagIdentifier + string.Format("-{0}", string.Format("{0:D5}", vgTagNum));
|
|
| 1115 |
//else |
|
| 1116 |
VGTag = valveitem.TagIdentifier + "-" + valvetag[1]; |
|
| 1048 | 1117 |
} |
| 1049 | 1118 |
|
| 1050 | 1119 |
foreach (KeyValuePair<int, List<DataRow>> keyValuePair in keyValuePairs) |
| ... | ... | |
| 1073 | 1142 |
} |
| 1074 | 1143 |
} |
| 1075 | 1144 |
} |
| 1076 |
|
|
| 1077 |
|
|
| 1078 |
//ViewPipeSystemNetwork_OID |
|
| 1079 |
//DataRow[] rows = TopologySet.Select(string.Format("OID = '{0}'", dr["BranchTopologySet_OID"].ToString()));
|
|
| 1080 | 1145 |
} |
| 1081 | 1146 |
} |
| 1082 | 1147 |
} |
| 1083 | 1148 |
} |
| 1084 |
|
|
| 1085 | 1149 |
if(valveitem.GroupType.Contains("PSV"))
|
| 1086 | 1150 |
{
|
| 1087 | 1151 |
DataRow[] psnRows = PipeSystemNetwork.Select(string.Format("OID = '{0}'", drPathitem["PipeSystemNetwork_OID"].ToString()));
|
| ... | ... | |
| 1089 | 1153 |
row["Pocket"] = "Yes"; |
| 1090 | 1154 |
} |
| 1091 | 1155 |
} |
| 1092 |
|
|
| 1093 |
|
|
| 1094 | 1156 |
} |
| 1095 | 1157 |
catch (Exception ex) |
| 1096 | 1158 |
{
|
| 1097 | 1159 |
MessageBox.Show(ex.Message, "ID2 ", MessageBoxButtons.OK, MessageBoxIcon.Error); |
| 1098 | 1160 |
} |
| 1099 |
//} |
|
| 1100 | 1161 |
} |
| 1101 | 1162 |
|
| 1102 | 1163 |
private void SetTopologyData() |
| ... | ... | |
| 1154 | 1215 |
List<LineNumber> lineNumbers = group.Document.LineNumbers.FindAll(x => !x.IsCopy); |
| 1155 | 1216 |
Random random = new Random(); |
| 1156 | 1217 |
int index = random.Next(lineNumbers.Count - 1); |
| 1157 |
|
|
| 1218 |
|
|
| 1158 | 1219 |
// Copy |
| 1159 | 1220 |
LineNumber cLineNumber = lineNumbers[index].Copy(); |
| 1160 | 1221 |
group.Document.LineNumbers.Add(cLineNumber); |
| ... | ... | |
| 1205 | 1266 |
|
| 1206 | 1267 |
item.PSNPipeLineID = string.Join("-", pipeLineID);
|
| 1207 | 1268 |
item.TopologyData = string.Join("-", pipeLineID);
|
| 1208 |
|
|
| 1269 |
|
|
| 1209 | 1270 |
} |
| 1210 | 1271 |
else |
| 1211 | 1272 |
{
|
내보내기 Unified diff
