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; //资产自动匹配 public static async Task Matching(AssetsMatchingViewModel assetsAutoMatchingView) { bool IsMaching = false; var pumpMain = new BLL.PumpMain(); var adaptingManage = new BLL.AdaptingManage(); var pipeLineManage = new BLL.PipeLineManage(); var valveMain = new BLL.ValveMain(); var allPump = await pumpMain.GetAll(); var allAdapting = await adaptingManage.GetAll(); var allPipeLine = await pipeLineManage.GetAll(); var allValve = await valveMain.GetAll(); //泵匹配 foreach (var item in assetsAutoMatchingView.PumpMatchingList) { if (await MatchingPumps(item, allPump)) { IsMaching = true; } } //三通匹配 foreach (var item in assetsAutoMatchingView.ThreelinkMatchingList) { if (MatchingThreelink(item, allAdapting)) { IsMaching = true; } } //四通匹配 foreach (var item in assetsAutoMatchingView.FourlinkMatchingList) { if (MatchingFourlink(item, allAdapting)) { 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.ElbowsMatchingList) { if (MatchingElbow(item, allAdapting)) { IsMaching = true; } } return IsMaching; } //泵匹配 public static async Task MatchingPumps(PumpMatchingViewModel viewModel, List pumpMainVmos) { Vmo.PumpMainVmo vmo = null; int startCount = 0; // 尝试绝对匹配 var absoluteMatch = pumpMainVmos.Where(item => (viewModel.RatedN == null || viewModel.RatedN == item.RatedSpeed) && (viewModel.RatedQ == null || viewModel.RatedQ == item.RatedFlow) && (viewModel.RatedH == null || viewModel.RatedH == item.RatedHead) && (viewModel.RatedP == item.RatedPower)).ToList(); if (absoluteMatch != null && absoluteMatch.Count != 0) { foreach (var item in absoluteMatch) { int commonCount = CountCommonCharacters(viewModel.ModelType, item.Name); if (commonCount > startCount) { vmo = item; startCount = commonCount; } } } else { // 尝试区间匹配 var rangeMatch = pumpMainVmos.Where(item => (viewModel.RatedN.HasValue ? Math.Abs(viewModel.RatedN.Value - item.RatedSpeed) <= _speedTolerance : true) && (viewModel.RatedQ.HasValue ? Math.Abs(viewModel.RatedQ.Value - item.RatedFlow) <= _flowTolerance : true) && (viewModel.RatedH.HasValue ? Math.Abs(viewModel.RatedH.Value - item.RatedHead) <= _headTolerance : true) && (Math.Abs(viewModel.RatedP - item.RatedPower) <= _powerTolerance)).ToList(); if (rangeMatch != null && rangeMatch.Count != 0) { foreach (var item in rangeMatch) { int commonCount = CountCommonCharacters(viewModel.ModelType, item.Name); if (commonCount > startCount) { vmo = item; startCount = commonCount; } } } } // if (vmo == null) { foreach (var item in pumpMainVmos) { int commonCount = CountCommonCharacters(viewModel.ModelType, item.Name); if (commonCount > startCount) { vmo = item; startCount = commonCount; } } } if (vmo != null) { viewModel.MatchingRatedH = vmo.RatedHead; viewModel.MatchingRatedN = vmo.RatedSpeed; viewModel.MatchingRatedQ = vmo.RatedFlow; viewModel.MatchingRatedP = vmo.RatedPower; viewModel.MatchingDbId = vmo.ID.ToString(); var list = await new BLL.XhsPumpMainPhartMappingExtensions().GetByPumpMainID(vmo.ID); if (list != null && list.Count > 0) { viewModel.MatchingCurveDbId = list.First().ID.ToString(); } return true; } return false; } //阀门匹配 public static bool MatchingValve(ValveMatchingViewModel input, List adaptingManageVmos) { HStation.Vmo.ValveMainVmo vmo = null; int firstCount = 0; //口径最小差值 // 绝对匹配 var absoluteMatch = adaptingManageVmos.Where(i => ((i.Caliber == null) || i.Caliber == input.Diameter) && ((input.Material == null && i.Material == "默认") || i.Material == input.Material)).ToList(); if (absoluteMatch.Any()) { foreach (var range in absoluteMatch) { int commonCount = CountCommonCharacters(input.ModelType, range.Name); if (commonCount > firstCount) { vmo = range; firstCount = commonCount; } } } else { //区间匹配 var rangeMatch = adaptingManageVmos.Where(item => { if (item.Caliber != null && input.Diameter != null) { return Math.Abs(Convert.ToInt64(item.Caliber - input.Diameter)) <= _caliberTolerance; } else { if (item.Caliber == null) { return true; } } return false; }) .ToList(); if (rangeMatch != null && rangeMatch.Count > 0) { var materialList = new List(); foreach (var range in rangeMatch) { //以材料为条件开始匹配 if (range.Material == "默认") { materialList.Add(range); } else { int commonCount = CountCommonCharacters(input.Material, range.Material); if (commonCount > firstCount) { materialList.Add(range); firstCount = commonCount; } } } //用已经筛选完成的列表中以名称筛选 firstCount = 0; foreach (var material in materialList) { int commonCount = CountCommonCharacters(input.ModelType, material.Name); if (commonCount > firstCount) { vmo = material; firstCount = commonCount; } } } } //口径和材料都没有匹配上,就用型号名匹配 firstCount = 0; if (vmo == null) { foreach (var item in adaptingManageVmos) { int commonCount = CountCommonCharacters(input.ModelType, item.Name); if (commonCount > firstCount) { vmo = item; firstCount = commonCount; } } } if (vmo != null) { input.MatchingMinorLoss = vmo.Coefficient; return true; } return false; } //管道匹配 public static bool MatchingPipe(PipeMatchingViewModel input, List pipeLineManageVmos) { Vmo.PipeLineManageVmo vmo = null; int StartCount = 0; //口径最小差值 // 绝对匹配 var absoluteMatch = pipeLineManageVmos.Where(i => ((i.Caliber == null) || i.Caliber == input.Diameter) && ((input.Material == null && i.Material == "默认") || i.Material == input.Material)).ToList(); if (absoluteMatch.Any()) { foreach (var range in absoluteMatch) { int commonCount = CountCommonCharacters(input.ModelType, range.Name); if (commonCount > StartCount) { vmo = range; StartCount = commonCount; } } } else { //区间匹配 var rangeMatch = pipeLineManageVmos.Where(item => { if (item.Caliber != null) { return Math.Abs(Convert.ToInt64(item.Caliber - input.Diameter)) <= _caliberTolerance; } return false; }) .ToList(); if (rangeMatch != null) { foreach (var range in rangeMatch) { //以材料为条件开始匹配 int commonCount = CountCommonCharacters(input.Material, range.Material); if (commonCount > StartCount) { vmo = range; StartCount = commonCount; } } } } //口径和材料都没有匹配上,就用型号名匹配 if (vmo == null) { foreach (var item in pipeLineManageVmos) { int commonCount = CountCommonCharacters(input.ModelType, item.Name); if (commonCount > StartCount) { vmo = item; StartCount = commonCount; } } } if (vmo != null) { switch (input.eAlgorithmType) { case HStation.Assets.eAlgorithmType.Hazen: input.MatchingMinorLoss = vmo.Hazen; break; case HStation.Assets.eAlgorithmType.Manning: input.MatchingMinorLoss = vmo.Manning; break; case HStation.Assets.eAlgorithmType.Darcy: input.MatchingMinorLoss = vmo.Darcy; break; default: input.MatchingMinorLoss = vmo.Hazen; break; } return true; } return false; } //弯头匹配 public static bool MatchingElbow(ElbowsMatchingViewModel input, List adaptingManageVmos) { Vmo.AdaptingManageVmo 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 == "默认") || i.Material == input.Material)).ToList(); if (absoluteMatch.Any()) { foreach (var range in absoluteMatch) { int commonCount = CountCommonCharacters(input.ModelType, range.Name); if (commonCount > firstCount) { vmo = range; firstCount = commonCount; } } } else { //区间匹配 var rangeMatch = adaptingManageVmos.Where(item => { if (item.Caliber != null && input.Caliber != null) { return Math.Abs(Convert.ToInt64(item.Caliber - input.Caliber)) <= _caliberTolerance; } else { if (item.Caliber == null) { return true; } } return false; }) .ToList(); if (rangeMatch != null && rangeMatch.Count > 0) { var materialList = new List(); foreach (var range in rangeMatch) { //以材料为条件开始匹配 if (range.Material == "默认") { materialList.Add(range); } else { int commonCount = CountCommonCharacters(input.Material, range.Material); if (commonCount > firstCount) { materialList.Add(range); firstCount = commonCount; } } } //用已经筛选完成的列表中以名称筛选 firstCount = 0; foreach (var material in materialList) { int commonCount = CountCommonCharacters(input.ModelType, material.Name); if (commonCount > firstCount) { vmo = material; firstCount = commonCount; } } } } //口径和材料都没有匹配上,就用型号名匹配 firstCount = 0; if (vmo == null) { foreach (var item in adaptingManageVmos) { int commonCount = CountCommonCharacters(input.ModelType, item.Name); if (commonCount > firstCount) { vmo = item; firstCount = commonCount; } } } if (vmo != null) { input.MatchingMinorLoss = vmo.Coefficient; return true; } return false; } //三通匹配 public static bool MatchingThreelink(ThreelinkMatchingViewModel input, List adaptingManageVmos) { Vmo.AdaptingManageVmo 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 == "默认") || i.Material == input.Material)).ToList(); if (absoluteMatch.Any()) { foreach (var range in absoluteMatch) { int commonCount = CountCommonCharacters(input.ModelType, range.Name); if (commonCount > firstCount) { vmo = range; firstCount = commonCount; } } } else { //区间匹配 var rangeMatch = adaptingManageVmos.Where(item => { if (item.Caliber != null && input.Caliber != null) { return Math.Abs(Convert.ToInt64(item.Caliber - input.Caliber)) <= _caliberTolerance; } else { if (item.Caliber == null) { return true; } } return false; }) .ToList(); if (rangeMatch != null && rangeMatch.Count > 0) { var materialList = new List(); foreach (var range in rangeMatch) { //以材料为条件开始匹配 if (range.Material == "默认") { materialList.Add(range); } else { int commonCount = CountCommonCharacters(input.Material, range.Material); if (commonCount > firstCount) { materialList.Add(range); firstCount = commonCount; } } } //用已经筛选完成的列表中以名称筛选 firstCount = 0; foreach (var material in materialList) { int commonCount = CountCommonCharacters(input.ModelType, material.Name); if (commonCount > firstCount) { vmo = material; firstCount = commonCount; } } } } //口径和材料都没有匹配上,就用型号名匹配 firstCount = 0; if (vmo == null) { foreach (var item in adaptingManageVmos) { int commonCount = CountCommonCharacters(input.ModelType, item.Name); if (commonCount > firstCount) { vmo = item; firstCount = commonCount; } } } if (vmo != null) { input.MatchingMinorLoss = vmo.Coefficient; return true; } return false; } //四通匹配 public static bool MatchingFourlink(FourlinkMatchingViewModel input, List adaptingManageVmos) { Vmo.AdaptingManageVmo 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 == "默认") || i.Material == input.Material)).ToList(); if (absoluteMatch.Any()) { foreach (var range in absoluteMatch) { int commonCount = CountCommonCharacters(input.ModelType, range.Name); if (commonCount > firstCount) { vmo = range; firstCount = commonCount; } } } else { //区间匹配 var rangeMatch = adaptingManageVmos.Where(item => { if (item.Caliber != null && input.Caliber != null) { return Math.Abs(Convert.ToInt64(item.Caliber - input.Caliber)) <= _caliberTolerance; } else { if (item.Caliber == null) { return true; } } return false; }) .ToList(); if (rangeMatch != null && rangeMatch.Count > 0) { var materialList = new List(); foreach (var range in rangeMatch) { //以材料为条件开始匹配 if (range.Material == "默认") { materialList.Add(range); } else { int commonCount = CountCommonCharacters(input.Material, range.Material); if (commonCount > firstCount) { materialList.Add(range); firstCount = commonCount; } } } //用已经筛选完成的列表中以名称筛选 firstCount = 0; foreach (var material in materialList) { int commonCount = CountCommonCharacters(input.ModelType, material.Name); if (commonCount > firstCount) { vmo = material; firstCount = commonCount; } } } } //口径和材料都没有匹配上,就用型号名匹配 firstCount = 0; if (vmo == null) { foreach (var item in adaptingManageVmos) { int commonCount = CountCommonCharacters(input.ModelType, item.Name); if (commonCount > firstCount) { vmo = item; firstCount = commonCount; } } } if (vmo != null) { input.MatchingMinorLoss = vmo.Coefficient; return true; } return false; } //返回两个字符串之间相同的字符个数 private static int CountCommonCharacters(string baseString, string compareString) { // 将字符串转换为字符集合 if (baseString == string.Empty || baseString == null || compareString == string.Empty || compareString == null) { return 0; } HashSet baseChars = new HashSet(baseString); HashSet comparisonChars = new HashSet(compareString); // 计算两个集合的交集 int commonCount = baseChars.Intersect(comparisonChars).Count(); return commonCount; } /// /// 获取两个字符串的所有交集 /// /// /// /// public static string GetIntersect(string str1, string str2) { if (str1 == null || str2 == null) return null; return string.Join("", str1.Intersect(str2)); } } }