using HStation.Vmo; using HStation.WinFrmUI.PhartRelation; using System.Windows.Input; namespace HStation.WinFrmUI { public class AssetsMatchingHelper { private readonly Lazy _bll_ex = new(); private const double _caliberTolerance = 10.0; private const double _speedTolerance = 100; private const double _flowTolerance = 10; private const double _headTolerance = 5; private const double _powerTolerance = 0.05; private const double _valveLift = 10;//阀门开度范围 private const int _angle = 1;//角度范围 //资产自动匹配 public static bool Matching(AssetsMatchingViewModel assetsAutoMatchingView, out string Error) { Error = string.Empty; bool IsMaching = false; var AssetsPumpMain = new BLL.AssetsPumpMain(); var adaptingManage = new BLL.AdaptingManage(); var pipeLineManage = new BLL.AssetsPipeMain(); var AssetsValveMain = new BLL.AssetsValveMain(); var AssetsElbowMain = new BLL.AssetsElbowMain(); var AssetsThreelinkMain = new BLL.AssetsThreelinkMain(); var AssetsFourlinkMain = new BLL.AssetsFourlinkMain(); try { var allPump = Task.Run(async () => await AssetsPumpMain.GetAll()).Result; var allAdapting = Task.Run(async () => await adaptingManage.GetAll()).Result; var allPipeLine = Task.Run(async () => await pipeLineManage.GetAll()).Result; var allValve = Task.Run(async () => await AssetsValveMain.GetAll()).Result; var allElbow = Task.Run(async () => await AssetsElbowMain.GetAll()).Result; var allThreeLink = Task.Run(async () => await AssetsThreelinkMain.GetAll()).Result; var allFourLink = Task.Run(async () => await AssetsFourlinkMain.GetAll()).Result; //泵匹配 foreach (var item in assetsAutoMatchingView.PumpMatchingList) { if (MatchingPumps(item, allPump)) { IsMaching = true; } } //三通匹配 foreach (var item in assetsAutoMatchingView.ThreelinkMatchingList) { if (MatchingThreelink(item, allThreeLink)) { IsMaching = true; } } //四通匹配 foreach (var item in assetsAutoMatchingView.FourlinkMatchingList) { if (MatchingFourlink(item, allFourLink)) { IsMaching = true; } } //管道匹配 foreach (var item in assetsAutoMatchingView.PipeMatchingList) { if (MatchingPipe(item, allPipeLine)) { IsMaching = true; } } //阀门匹配 foreach (var item in assetsAutoMatchingView.ValveMatchingList) { if (MatchingValve(item, allValve)) { IsMaching = true; } } //弯头匹配 foreach (var item in assetsAutoMatchingView.ElbowMatchingList) { if (MatchingElbow(item, allElbow)) { IsMaching = true; } } } catch (Exception ex) { Error = ex.Message; return false; } return IsMaching; } //泵匹配 public static bool MatchingPumps(PumpMatchingViewModel InputModel, List AssetsPumpMainVmos) { if (AssetsPumpMainVmos == null) { return true; } Vmo.AssetsPumpMainVmo vmo = null; int startCount = 0; // 尝试绝对匹配 var absoluteMatch = AssetsPumpMainVmos.Where(item => (InputModel.RatedN == null || InputModel.RatedN == item.RatedSpeed) && (InputModel.RatedQ == null || InputModel.RatedQ == item.RatedFlow) && (InputModel.RatedH == null || InputModel.RatedH == item.RatedHead) && (InputModel.RatedP == item.RatedPower)).ToList(); if (absoluteMatch != null && absoluteMatch.Count != 0) { foreach (var item in absoluteMatch) { int commonCount = GetIntersect(InputModel.ModelType, item.Name); if (commonCount > startCount) { vmo = item; startCount = commonCount; } } } else { // 尝试区间匹配 var rangeMatch = AssetsPumpMainVmos.Where(item => (InputModel.RatedN.HasValue ? Math.Abs(InputModel.RatedN.Value - item.RatedSpeed) <= _speedTolerance : true) && (InputModel.RatedQ.HasValue ? Math.Abs(InputModel.RatedQ.Value - item.RatedFlow) <= _flowTolerance : true) && (InputModel.RatedH.HasValue ? Math.Abs(InputModel.RatedH.Value - item.RatedHead) <= _headTolerance : true) && (Math.Abs(InputModel.RatedP - item.RatedPower) <= _powerTolerance)).ToList(); if (rangeMatch != null && rangeMatch.Count != 0) { foreach (var item in rangeMatch) { int commonCount = GetIntersect(InputModel.ModelType, item.Name); if (commonCount > startCount) { vmo = item; startCount = commonCount; } } } } // if (vmo == null) { foreach (var item in AssetsPumpMainVmos) { int commonCount = GetIntersect(InputModel.ModelType, item.Name); if (commonCount > startCount) { vmo = item; startCount = commonCount; } } } if (vmo != null) { InputModel.MatchingRatedH = vmo.RatedHead; InputModel.MatchingRatedN = vmo.RatedSpeed; InputModel.MatchingRatedQ = vmo.RatedFlow; InputModel.MatchingRatedP = vmo.RatedPower; InputModel.MatchingDbId = vmo.ID.ToString(); InputModel.MatchingModelType = vmo.Name; var list = Task.Run(async () => await new BLL.XhsPumpMainPhartMappingExtensions().GetByPumpMainID(vmo.ID)).Result; if (list != null && list.Count > 0) { var maxImportanceItem = list.OrderByDescending(x => x.Importance).First(); InputModel.MatchingCurveDbId = maxImportanceItem.ID.ToString(); var graph_qh = maxImportanceItem.Diagram.GraphList.Find(x => x.GraphType == HStation.PhartRelation.eGraphType.PumpQH); var graph_qe = maxImportanceItem.Diagram.GraphList.Find(x => x.GraphType == HStation.PhartRelation.eGraphType.PumpQE); var graph_qp = maxImportanceItem.Diagram.GraphList.Find(x => x.GraphType == HStation.PhartRelation.eGraphType.PumpQP); if (graph_qh != null) { var points_qh = PhartPerformCurveHelper.GetFeatPointList(graph_qh.GraphType, graph_qh.GeometryInfo, 100, null); InputModel.MatchingCurveQH = new List(); foreach (var item in points_qh) { InputModel.MatchingCurveQH.Add(new CurvePointMatchingViewModel(item.X, item.Y)); } } if (graph_qe != null) { var points_qe = PhartPerformCurveHelper.GetFeatPointList(graph_qe.GraphType, graph_qe.GeometryInfo, 100, null); InputModel.MatchingCurveQE = new List(); foreach (var item in points_qe) { InputModel.MatchingCurveQE.Add(new CurvePointMatchingViewModel(item.X, item.Y)); } } if (graph_qp != null) { var points_qp = PhartPerformCurveHelper.GetFeatPointList(graph_qp.GraphType, graph_qp.GeometryInfo, 100, null); InputModel.MatchingCurveQP = new List(); foreach (var item in points_qp) { InputModel.MatchingCurveQP.Add(new CurvePointMatchingViewModel(item.X, item.Y)); } } } return true; } return false; } //阀门匹配 public static bool MatchingValve(ValveMatchingViewModel input, List adaptingManageVmos) { if (adaptingManageVmos == null) { return true; } HStation.Vmo.AssetsValveMainVmo vmo = null; //口径最小差值 // 绝对匹配 adaptingManageVmos = adaptingManageVmos.Where(x => x.ValveType == input.ValveType).ToList(); var nameMatching = adaptingManageVmos.Where(x => (x.KeyWord != null && x.KeyWord.Any(keyword => GetIntersect(keyword, input.ModelType) >= 1)) || (x.KeyWord == null || !x.KeyWord.Any()) && GetIntersect(x.Name, input.ModelType) >= 1 ) //先进行筛选,后进行从大到小排序 .OrderByDescending(x => (x.KeyWord != null && x.KeyWord.Any(keyword => GetIntersect(keyword, input.ModelType) >= 1)) || (x.KeyWord == null || !x.KeyWord.Any()) && GetIntersect(x.Name, input.ModelType) >= 1) .ToList();//使用型号名或者关键字找出相同字符在1以上并且进行排序 if (nameMatching.Count > 0) { var absoluteMatching = nameMatching.Where(i => ((i.Caliber == null) || Math.Abs(Convert.ToInt64(i.Caliber) - input.Diameter) <= _caliberTolerance) && //直径约束 i.Material == input.Material //材料约束 ).ToList(); if (absoluteMatching.Count > 1) { return false; } else if (absoluteMatching.Count == 1) { vmo = absoluteMatching.First(); } else return false; } else if (nameMatching.Count == 1) { vmo = nameMatching.First(); } else { var absoluteMatching = adaptingManageVmos.Where(i => ((i.Caliber == null) || Math.Abs(Convert.ToInt64(i.Caliber) - input.Diameter) <= _caliberTolerance) && //直径约束 i.Material == input.Material //材料约束 ).ToList(); if (absoluteMatching.Count > 1) { return false; } else if (absoluteMatching.Count == 1) { vmo = absoluteMatching.First(); } else return false; } if (vmo != null) { input.MatchingMinorLoss = vmo.MinorLoss; input.MatchingDbId = vmo.ID.ToString(); input.MatchingDiameter = vmo.Caliber; input.MatchingMaterial = vmo.Material; input.MatchingModelType = vmo.Name; input.MatchingValveSetting = vmo.ValveSetting; input.MatchingValveType = vmo.ValveType; if (vmo.ValveType == HStation.Assets.eValveType.GPV) { var list = Task.Run(async () => await new BLL.XhsPumpMainPhartMappingExtensions().GetByPumpMainID(vmo.ID)).Result; if (list != null && list.Count > 0) { var maxImportanceItem = list.OrderByDescending(x => x.Importance).First(); input.MatchingCurveDbId = maxImportanceItem.ID.ToString(); var graph_ql = maxImportanceItem.Diagram.GraphList.Find(x => x.GraphType == HStation.PhartRelation.eGraphType.ValveQL); var graph_ol = maxImportanceItem.Diagram.GraphList.Find(x => x.GraphType == HStation.PhartRelation.eGraphType.ValveOL); if (graph_ql != null) { var points_qh = PhartPerformCurveHelper.GetFeatPointList(graph_ql.GraphType, graph_ql.GeometryInfo, 100, null); input.MatchingCurveQL = new List(); foreach (var item in points_qh) { input.MatchingCurveQL.Add(new CurvePointMatchingViewModel(item.X, item.Y)); } } } return true; } else if (vmo.ValveType == HStation.Assets.eValveType.TCV) { var list = Task.Run(async () => await new BLL.XhsPumpMainPhartMappingExtensions().GetByPumpMainID(vmo.ID)).Result; if (list != null && list.Count > 0) { var maxImportanceItem = list.OrderByDescending(x => x.Importance).First(); input.MatchingCurveDbId = maxImportanceItem.ID.ToString(); var graph_ol = maxImportanceItem.Diagram.GraphList.Find(x => x.GraphType == HStation.PhartRelation.eGraphType.ValveOL); if (graph_ol != null) { var points_qh = PhartPerformCurveHelper.GetFeatPointList(graph_ol.GraphType, graph_ol.GeometryInfo, 100, null); input.MatchingCurveOL = new List(); foreach (var item in points_qh) { input.MatchingCurveOL.Add(new CurvePointMatchingViewModel(item.X, item.Y)); } } } return true; } } return false; } //管道匹配 public static bool MatchingPipe(PipeMatchingViewModel input, List pipeLineManageVmos) { if (pipeLineManageVmos == null) { return true; } Vmo.AssetsPipeMainVmo vmo = null; int firstCount = 0; //口径最小差值 // 绝对匹配 var absoluteMatch = pipeLineManageVmos.Where(i => ((i.Caliber == null) || i.Caliber == input.Diameter) && ((input.Material == null) || i.MaterialName == input.Material)).ToList(); if (absoluteMatch.Count > 1) { } else if (absoluteMatch.Count == 1) { vmo = absoluteMatch.First(); } else { //区间匹配 var rangeMatch = pipeLineManageVmos .Where(item => item.Caliber == null || Math.Abs(Convert.ToInt64(item.Caliber) - Convert.ToInt64(input.Diameter)) <= _caliberTolerance) .ToList(); if (rangeMatch != null) { var materialList = new List(); foreach (var range in rangeMatch) { //以材料为条件开始匹配 if (range.MaterialName == null) { materialList.Add(range); } else { int commonCount = GetIntersect(input.Material, range.MaterialName); if (commonCount > firstCount) { materialList.Add(range); firstCount = commonCount; } } } firstCount = 0; if (materialList.Count < 1) return false; var allMatchingList = materialList .Where(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType) >= 2) .OrderByDescending(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType)) .ToList();//找出相同字符在2以上并且进行排序 if (allMatchingList.Count < 1) return false;//通过型号名没有找到,则视为没有匹配到 foreach (var item in allMatchingList) { if (item.IsDefault) { vmo = item; } } vmo = allMatchingList.First();//如果没有设置默认值,则默认返回匹配字符最多的一条数据 } } //口径和材料都没有匹配上,就用型号名匹配 if (vmo != null) { switch (input.eAlgorithmType) { case HStation.Assets.eAlgorithmType.Hazen: input.MatchingRoughness = vmo.Hazen; break; case HStation.Assets.eAlgorithmType.Manning: input.MatchingRoughness = vmo.Manning; break; case HStation.Assets.eAlgorithmType.Darcy: input.MatchingRoughness = vmo.Darcy; break; default: input.MatchingRoughness = vmo.Hazen; break; } input.MatchingDbId = vmo.ID.ToString(); input.MatchingMaterial = vmo.MaterialName; input.MatchingModelType = vmo.Name; input.MatchingMinorLoss = vmo.Coefficient; return true; } return false; } //弯头匹配 public static bool MatchingElbow(ElbowMatchingViewModel input, List adaptingManageVmos) { if (adaptingManageVmos == null) { return true; } Vmo.AssetsElbowMainVmo vmo = null; int firstCount = 0; // 绝对匹配 /* var absoluteMatch = adaptingManageVmos.Where(i => ((input.Caliber == null && i.Caliber == null) || i.Caliber == input.Caliber) && ((input.Material == null) || i.Material == input.Material)).ToList(); if (absoluteMatch.Count > 1) { var allMatchingList = absoluteMatch .Where(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType) >= 2) .OrderByDescending(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType)) .ToList();//找出相同字符在2以上并且进行排序 if (allMatchingList.Count < 1) return false;//通过型号名没有找到,则视为没有匹配到 foreach (var item in allMatchingList) { if (item.IsDefault) { vmo = item; } } vmo = allMatchingList.First();//如果没有设置默认值,则默认返回匹配字符最多的一条数据 } else if (absoluteMatch.Count == 1) { vmo = absoluteMatch.First(); } else { //区间匹配 var rangeMatch = adaptingManageVmos .Where(item => (input.Caliber == null && input.Caliber == null) || (item.Caliber.HasValue && input.Caliber.HasValue) && //存在值,则进行下面差值判断 Math.Abs(Convert.ToInt64(item.Caliber) - Convert.ToInt64(input.Caliber)) <= _caliberTolerance || item.ElbowLengthType == input.ElbowLengthType || (item.Angle.HasValue && input.Angle.HasValue) && //存在值,则进行下面差值判断 Math.Abs(Convert.ToInt64(item.Angle) - Convert.ToInt64(input.Angle)) <= _angle) .ToList(); if (rangeMatch != null && rangeMatch.Count > 0) { var materialList = new List(); foreach (var range in rangeMatch) { //以材料为条件开始匹配 if (range.Material == null) { materialList.Add(range); } else { int commonCount = GetIntersect(input.Material, range.Material); if (commonCount > firstCount) { materialList.Add(range); firstCount = commonCount; } } } //用已经筛选完成的列表中以名称筛选 firstCount = 0; if (materialList.Count < 1) return false; var allMatchingList = materialList .Where(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType) >= 2) .OrderByDescending(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType)) .ToList();//找出相同字符在2以上并且进行排序 if (allMatchingList.Count < 1) return false;//通过型号名没有找到,则视为没有匹配到 foreach (var item in allMatchingList) { if (item.IsDefault) { vmo = item; } } vmo = allMatchingList.First();//如果没有设置默认值,则默认返回匹配字符最多的一条数据 } } //精确匹配和粗糙匹配都没有匹配到就返回错误 firstCount = 0; if (vmo != null) { input.MatchingMinorLoss = vmo.MinorLoss; input.MatchingDbId = vmo.ID.ToString(); input.MatchingMaterial = vmo.Material; input.MatchingModelType = vmo.Name; input.MatchingConnectionLength = vmo.ElbowLengthType; input.MatchingAngle = vmo.Angle; return true; }*/ return false; } //三通匹配 public static bool MatchingThreelink(ThreelinkMatchingViewModel input, List adaptingManageVmos) { if (adaptingManageVmos == null) { return true; } Vmo.AssetsThreelinkMainVmo vmo = null; int firstCount = 0; // 绝对匹配 var absoluteMatch = adaptingManageVmos.Where(i => ((input.Caliber == null && i.Caliber == null) || i.Caliber == input.Caliber) && ((input.Material == null) || i.MaterialName == input.Material)).ToList(); if (absoluteMatch.Count > 1) { var allMatchingList = absoluteMatch .Where(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType) >= 2) .OrderByDescending(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType)) .ToList();//找出相同字符在2以上并且进行排序 if (allMatchingList.Count < 1) return false;//通过型号名没有找到,则视为没有匹配到 foreach (var item in allMatchingList) { if (item.IsDefault) { vmo = item; } } vmo = allMatchingList.First();//如果没有设置默认值,则默认返回匹配字符最多的一条数据 } else if (absoluteMatch.Count == 1) { vmo = absoluteMatch.First(); } else { //区间匹配 var rangeMatch = adaptingManageVmos .Where(item => input.Caliber == null || item.Caliber == null || Math.Abs(Convert.ToInt64(item.Caliber) - Convert.ToInt64(input.Caliber)) <= _caliberTolerance) .ToList(); if (rangeMatch != null && rangeMatch.Count > 0) { var materialList = new List(); foreach (var range in rangeMatch) { //以材料为条件开始匹配 if (range.MaterialName == null) { materialList.Add(range); } else { int commonCount = GetIntersect(input.Material, range.MaterialName); if (commonCount > firstCount) { materialList.Add(range); firstCount = commonCount; } } } //用已经筛选完成的列表中以名称筛选 firstCount = 0; if (materialList.Count < 1) return false; var allMatchingList = materialList .Where(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType) >= 2) .OrderByDescending(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType)) .ToList();//找出相同字符在2以上并且进行排序 if (allMatchingList.Count < 1) return false;//通过型号名没有找到,则视为没有匹配到 foreach (var item in allMatchingList) { if (item.IsDefault) { vmo = item; } } vmo = allMatchingList.First();//如果没有设置默认值,则默认返回匹配字符最多的一条数据 } } //精确匹配和粗糙匹配都没有匹配到就返回错误 firstCount = 0; if (vmo != null) { input.MatchingMinorLoss = vmo.Coefficient; input.MatchingDbId = vmo.ID.ToString(); input.MatchingMaterial = vmo.MaterialName; input.MatchingModelType = vmo.Name; input.MatchingRunThroughCoefficient = vmo.RunThroughCoefficient; input.MatchingBranchThroughCoefficient = vmo.BranchThroughCoefficient; return true; } return false; } //四通匹配 public static bool MatchingFourlink(FourlinkMatchingViewModel input, List adaptingManageVmos) { /* if (adaptingManageVmos == null) { return true; } Vmo.AssetsFourlinkMainVmo vmo = null; int firstCount = 0; // 绝对匹配 var absoluteMatch = adaptingManageVmos.Where(i => ((input.Caliber == null && i.Caliber == null) || i.Caliber == input.Caliber) && ((input.Material == null) || i.Material == input.Material)).ToList(); if (absoluteMatch.Count > 1) { var allMatchingList = absoluteMatch .Where(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType) >= 2) .OrderByDescending(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType)) .ToList();//找出相同字符在2以上并且进行排序 if (allMatchingList.Count < 1) return false;//通过型号名没有找到,则视为没有匹配到 foreach (var item in allMatchingList) { } vmo = allMatchingList.First();//如果没有设置默认值,则默认返回匹配字符最多的一条数据 } else if (absoluteMatch.Count == 1) { vmo = absoluteMatch.First(); } else { //区间匹配 var rangeMatch = adaptingManageVmos .Where(item => input.Caliber == null || item.Caliber == null || Math.Abs(Convert.ToInt64(item.Caliber) - Convert.ToInt64(input.Caliber)) <= _caliberTolerance) .ToList(); if (rangeMatch != null && rangeMatch.Count > 0) { var materialList = new List(); foreach (var range in rangeMatch) { //以材料为条件开始匹配 if (range.Material == null) { materialList.Add(range); } else { int commonCount = GetIntersect(input.Material, range.Material); if (commonCount > firstCount) { materialList.Add(range); firstCount = commonCount; } } } //用已经筛选完成的列表中以名称筛选 firstCount = 0; if (materialList.Count < 1) return false; var allMatchingList = materialList .Where(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType) >= 2) .OrderByDescending(x => GetIntersect(x.KeyWord == string.Empty ? x.Name : x.KeyWord, input.ModelType)) .ToList();//找出相同字符在2以上并且进行排序 if (allMatchingList.Count < 1) return false;//通过型号名没有找到,则视为没有匹配到 foreach (var item in allMatchingList) { } vmo = allMatchingList.First();//如果没有设置默认值,则默认返回匹配字符最多的一条数据 } } //精确匹配和粗糙匹配都没有匹配到就返回错误 firstCount = 0; if (vmo != null) { input.MatchingMinorLoss = vmo.MinorLoss; input.MatchingDbId = vmo.ID.ToString(); input.MatchingMaterial = vmo.Material; input.MatchingModelType = vmo.Name; return true; }*/ return false; } /// /// 获取两个字符串的所有交集 /// public static int GetIntersect(string str1, string str2) { if (str1 == null || str2 == null) return 0; return string.Join("", str1.Intersect(str2)).Count(); } } }