namespace HStation.WinFrmUI
|
{
|
public class AssetsMatchingHelper
|
{
|
private readonly Lazy<BLL.XhsPumpMainPhartMappingExtensions> _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<AssetsMatchingViewModel> Matching(AssetsMatchingViewModel assetsAutoMatchingView)
|
{
|
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();
|
var assetsAutoMatching = new AssetsMatchingViewModel();
|
var pumpMatchingList = new List<PumpMatchingViewModel>();
|
var threeLinkMatchingList = new List<ThreelinkMatchingViewModel>();
|
var fourLinkMatchingList = new List<FourlinkMatchingViewModel>();
|
var pipeLineMatchingList = new List<PipeMatchingViewModel>();
|
var valveMatchingList = new List<ValveMatchingViewModel>();
|
var elbowsMatchingList = new List<ElbowsMatchingViewModel>();
|
//泵匹配
|
foreach (var item in assetsAutoMatchingView.PumpMatchingList)
|
{
|
pumpMatchingList.Add(await MatchingPumps(item, allPump));
|
}
|
//三通匹配
|
foreach (var item in assetsAutoMatchingView.ThreelinkMatchingList)
|
{
|
threeLinkMatchingList.Add(MatchingThreeLink(item, allAdapting));
|
}
|
//四通匹配
|
foreach (var item in assetsAutoMatchingView.FourlinkMatchingList)
|
{
|
fourLinkMatchingList.Add(MatchingFourLink(item, allAdapting));
|
}
|
//管道匹配
|
foreach (var item in assetsAutoMatchingView.PipeMatchingList)
|
{
|
pipeLineMatchingList.Add(MatchingPipes(item, allPipeLine));
|
}
|
//阀门匹配
|
foreach (var item in assetsAutoMatchingView.ValveMatchingList)
|
{
|
valveMatchingList.Add(MatchingValves(item, allValve));
|
}
|
//弯头匹配
|
foreach (var item in assetsAutoMatchingView.ElbowsMatchingList)
|
{
|
elbowsMatchingList.Add(MatchingElbows(item, allAdapting));
|
}
|
assetsAutoMatching.PumpMatchingList = pumpMatchingList;
|
assetsAutoMatching.ThreelinkMatchingList = threeLinkMatchingList;
|
assetsAutoMatching.FourlinkMatchingList = fourLinkMatchingList;
|
assetsAutoMatching.ElbowsMatchingList = elbowsMatchingList;
|
assetsAutoMatching.PipeMatchingList = pipeLineMatchingList;
|
assetsAutoMatching.ValveMatchingList = valveMatchingList;
|
return assetsAutoMatching;
|
}
|
|
//弯头匹配
|
public static ElbowsMatchingViewModel MatchingElbows(ElbowsMatchingViewModel input, List<Vmo.AdaptingManageVmo> 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<Vmo.AdaptingManageVmo>();
|
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 input;
|
}
|
return input;
|
}
|
|
//四通匹配
|
public static FourlinkMatchingViewModel MatchingFourLink(FourlinkMatchingViewModel input, List<Vmo.AdaptingManageVmo> 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<Vmo.AdaptingManageVmo>();
|
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 input;
|
}
|
return input;
|
}
|
|
//三通匹配
|
public static ThreelinkMatchingViewModel MatchingThreeLink(ThreelinkMatchingViewModel input, List<Vmo.AdaptingManageVmo> 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<Vmo.AdaptingManageVmo>();
|
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 input;
|
}
|
return input;
|
}
|
|
//阀门匹配
|
public static ValveMatchingViewModel MatchingValves(ValveMatchingViewModel input, List<Vmo.ValveMainVmo> adaptingManageVmos)
|
{
|
HStation.Vmo.ValveMainVmo vmo = null;
|
int firstCount = 0;
|
//口径最小差值
|
// 绝对匹配
|
var absoluteMatch = adaptingManageVmos.Where(i =>
|
((input.Diameter == null && 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<Vmo.ValveMainVmo>();
|
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 input;
|
}
|
return input;
|
}
|
|
//泵匹配
|
public static async Task<PumpMatchingViewModel> MatchingPumps(PumpMatchingViewModel viewModel, List<Vmo.PumpMainVmo> 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;
|
}
|
}
|
return null;
|
}
|
|
//管道匹配
|
public static PipeMatchingViewModel MatchingPipes(PipeMatchingViewModel input, List<Vmo.PipeLineManageVmo> pipeLineManageVmos)
|
{
|
Vmo.PipeLineManageVmo vmo = null;
|
int StartCount = 0;
|
//口径最小差值
|
// 绝对匹配
|
var absoluteMatch = pipeLineManageVmos.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 > StartCount)
|
{
|
vmo = range;
|
StartCount = commonCount;
|
}
|
}
|
}
|
else
|
{
|
//区间匹配
|
var rangeMatch = pipeLineManageVmos.Where(item =>
|
{
|
if (item.Caliber != null && input.Caliber != null)
|
{
|
return Math.Abs(Convert.ToInt64(item.Caliber - input.Caliber)) <= _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;
|
return input;
|
|
case HStation.Assets.eAlgorithmType.Manning:
|
input.MatchingMinorLoss = vmo.Manning;
|
return input;
|
|
case HStation.Assets.eAlgorithmType.Darcy:
|
input.MatchingMinorLoss = vmo.Darcy;
|
return input;
|
|
default:
|
input.MatchingMinorLoss = vmo.Hazen;
|
return input;
|
}
|
}
|
return input;
|
}
|
|
//返回两个字符串之间相同的字符个数
|
private static int CountCommonCharacters(string baseString, string compareString)
|
{
|
// 将字符串转换为字符集合
|
if (baseString == string.Empty || baseString == null || compareString == string.Empty || compareString == null)
|
{
|
return 0;
|
}
|
HashSet<char> baseChars = new HashSet<char>(baseString);
|
HashSet<char> comparisonChars = new HashSet<char>(compareString);
|
// 计算两个集合的交集
|
int commonCount = baseChars.Intersect(comparisonChars).Count();
|
return commonCount;
|
}
|
|
/// <summary>
|
/// 获取两个字符串的所有交集
|
/// </summary>
|
/// <param name="str1"></param>
|
/// <param name="str2"></param>
|
/// <returns></returns>
|
public static string GetIntersect(string str1, string str2)
|
{
|
if (str1 == null || str2 == null) return null;
|
|
return string.Join("", str1.Intersect(str2));
|
}
|
|
}
|
}
|
