public void BuildMainSpecReports(MainSpec mspec)
{
/*
* 每天一条新的
* 来的新记录,存
* 来的相同记录, 更新,
* 相比前面60-90天之间有超过30%, remark1
*/
using (var context = new PumpSystemContext()) {
var existSpec = context.MainSpecs.Where(s =>
s.Feature == mspec.Feature &&
s.Position == mspec.Position &&
s.PPGuid == mspec.PPGuid).OrderByDescending(s => s.LatestTime).FirstOrDefault();
if (existSpec != null)
{
if (mspec.LatestTime.Value.Date > existSpec.LatestTime.Value.Date)
{
context.MainSpecs.Add(mspec);
}
else
{
existSpec.LatestTime = mspec.LatestTime;
existSpec.LatestValue = mspec.LatestValue;
if (mspec.MaxValue > existSpec.MaxValue)
{
existSpec.MaxValue = mspec.MaxValue;
}
//前一个季度 比较 设置remark1
var timeRangeStart = existSpec.LatestTime - TimeSpan.FromDays(90 - 5);
var timeRangeEnd = existSpec.LatestTime - TimeSpan.FromDays(90 + 5);
var prevSeasonSpecs =
context.MainSpecs.Where(s =>
s.Feature == mspec.Feature &&
s.Position == mspec.Position &&
s.PPGuid == mspec.PPGuid)
.Where(s => s.LatestTime >= timeRangeStart && s.LatestTime <= timeRangeEnd)
.ToList();
if (prevSeasonSpecs.Any())
{
var prevSeasonSpecMax = prevSeasonSpecs.Max(s => s.MaxValue);
if (existSpec.LatestValue > prevSeasonSpecMax * 1.2)
{
existSpec.Remark1 = "超过了上季度最大值的20%";
}
}
}
}
else
{
context.MainSpecs.Add(mspec);
}
context.SaveChanges();
}
}
public void BuildFaultItemReports(PumpSystem ppSys)
{
using (var context = new PumpSystemContext()) {
var reportsToSave = new List <FaultItemReport>();
foreach (var comp in ppSys)
{
foreach (var fItem in comp.FaultItems.Where(fi => fi.IsHappening))
{
var passedCts = fItem.Criteria.Where(ct => ct.IsHappening && ct.AsReportResult).ToArray();
if (!passedCts.Any())
{
continue;
}
var newRpt = new FaultItemReport();
//设置报告时间
var happenTime = passedCts.Max(ct => ct.Time);
newRpt.FirstTime = happenTime;
newRpt.LatestTime = happenTime;
//设置报告组件
newRpt.CompCode = comp.Code;
//设置报告故障内容和建议
newRpt.Advise = fItem.Advise;
//设置报告故障严重度
newRpt.Severity = GetSeverityFromCriteria(passedCts);
newRpt.CriterionBuiltIds = string.Join(Repo.Separator, passedCts.Select(ct => ct.LibId));
newRpt.RtDatas = string.Join("|||", passedCts.Select(ct => ct.RtDataStr));
//设置显示文本
newRpt.DisplayText = fItem.Description;
#region 给显示文本添加驱动端/非驱动端位置信息
var dict = ParseCriterionRtDataStr(newRpt.RtDatas);
var hasPos_drived = dict.Find(d => d.Key.Contains("_In")) != null;
var hasPos_nonDrived = dict.Find(d => d.Key.Contains("_Out")) != null;
var drivePos = string.Empty;
//有的fitem 驱动端/非驱动端/xyz都有, 加上这个位置信息反而看不懂
//所以只加 只有in的或只有out的
if (hasPos_drived && !hasPos_nonDrived)
{
drivePos = "(驱动端)";
}
else if (!hasPos_drived && hasPos_nonDrived)
{
drivePos = "(非驱动端)";
}
newRpt.DisplayText += drivePos;
#endregion
//设置默认发生次数
newRpt.HappenCount = 1;
var existRpts =
context.FaultItemReports.Where(rptRecord => rptRecord.CompCode == newRpt.CompCode &&
rptRecord.DisplayText == newRpt.DisplayText &&
rptRecord.CriterionBuiltIds == newRpt.CriterionBuiltIds &&
rptRecord.Severity >= newRpt.Severity).ToArray();
var newReportAction = new Action(() =>
{
//添加到图谱的映射
var gMap = new Dictionary <int, int>();
var graphNums = passedCts.SelectMany(ct => ct.GraphNumbers).Distinct().ToArray();
foreach (var graphNum in graphNums)
{
var graph = RuntimeRepo.RtData.Graphs[graphNum - 1]; //graphNum从1开始, graphs数组索引从0开始
var ga = GraphArchive.FromGraph(graph);
var gaId = context.AddGraph(ga);
if (!gMap.ContainsKey(graphNum))
{
gMap.Add(graphNum, gaId);
}
}
newRpt.GraphMap = string.Join(Repo.Separator, gMap.Select(m => $"{m.Key}:{m.Value}"));
_recordValidGrade(newRpt);
//保存
reportsToSave.Add(newRpt);
});
if (!existRpts.Any())
{
newReportAction();
}
else
{
//获取数据库中最新的记录
var latestTime = existRpts.Max(rr => rr.LatestTime);
var latestRpt = existRpts.First(r => r.LatestTime == latestTime);
var newDict = ParseCriterionRtDataStr(newRpt.RtDatas);
var latestDict = ParseCriterionRtDataStr(latestRpt.RtDatas);
//如果newRpt有阈值字段，那就找latestRpt里的阈值进行比较，如果newRpt没有阈值字段，那就不用比了，不存
double newMax;
if (newDict.TryGetMaxValue(fItem.ThresholdField, out newMax))
{
double latestMax;
if (latestDict.TryGetMaxValue(fItem.ThresholdField, out latestMax))
{
//如果都有阈值，那就比较有没有超过10%，有：就作为新记录，没有：就更新记录时间
if (newMax > (1 + _overLimitRatio) * latestMax)
{
newRpt.Remark1 = $"较此表Id为{latestRpt.Id}的故障超限至少{_overLimitRatio*100}%，原值:{latestMax} 新值:{newMax}，因此记录为新故障。";
newReportAction();
}
else
{
latestRpt.LatestTime = newRpt.FirstTime;
latestRpt.HappenCount++;
_recordValidGrade(latestRpt);
}
}
//如果newRpt有阈值字段，但latestRpt没有，那就当做新的记录存下来
else
{
newReportAction();
}
}
}
}
}
if (reportsToSave.Any())
{
context.FaultItemReports.AddRange(reportsToSave);
}
context.SaveChanges();
}
}
public void BuildInferComboReports(PumpSystem ppSys)
{
using (var context = new PumpSystemContext()) {
var reportsToSave = new List <InferComboReport>();
foreach (var comp in ppSys)
{
foreach (var icItem in comp.InferComboItems.Where(ic => ic.IsHappening))
{
GradedCriterion.ForEachValidGradeRange(gradeRange =>
{
var passedGcts =
icItem.ExpressionCts.Where(ct => ct is GradedCriterion)
.Where(gct => gct.IsHappening)
.Cast <GradedCriterion>().ToList();
//假如range是3的话,那么通过的里面至少有个3,且只能有3,不能有1,2
//假如range是2,3的话, 那么通过的里面至少有个2,且只能有2,3
//假如range是1,2,3的话, 那么通过的里面至少有个1,且只能有1,2,3
var checkPass = passedGcts.Any();
checkPass &= passedGcts.Exists(g => (int)g.HappeningGrade == gradeRange[0]);
checkPass &= passedGcts.All(g => gradeRange.Contains((int)g.HappeningGrade));
if (!checkPass)
{
return;
}
var newRpt = new InferComboReport();
//设置报告时间
var happenTime = passedGcts.Max(ct => ct.Time);
newRpt.LibId = icItem.Id;
newRpt.FirstTime = happenTime;
newRpt.LatestTime = happenTime;
//设置报告组件
newRpt.CompCode = comp.Code;
//设置报告故障内容和建议
// var faultItem = Repo.FaultItems.First(fi => fi.IsSameFaultItem(icItem));
newRpt.DisplayText = icItem.FaultResult;
newRpt.EventMode = icItem.EventMode;
newRpt.Expression = icItem.Expression;
newRpt.RtDatas = string.Join(Repo.Separator,
icItem.ExpressionCts.Select(ct => $"{ct.LibId}:{(ct.IsHappening ? 1 : 0)}"));
// newRpt.Advise = faultItem.Advise;
newRpt.HappenCount = 1;
//remark2 作为所用分档
newRpt.Remark2 = "Grade:" + string.Join(",", gradeRange);
//把通过的(为1的)分别是几档写到remark3里
newRpt.Remark3 = "GradeRefer: " + string.Join(Repo.Separator,
passedGcts.Select(g => $"{g.LibId}:{(int) g.HappeningGrade}"));
var icReports = context.InferComboReports.ToList();
//判断是否存在报告，不存在则添加，存在则更新
var existRpts = icReports.Where(rptRecord => rptRecord.LibId == newRpt.LibId &&
rptRecord.EventMode == newRpt.EventMode &&
rptRecord.Expression == newRpt.Expression &&
rptRecord.Remark2 == newRpt.Remark2).ToArray();
if (!existRpts.Any())
{
var intersects = icReports.Select(r => r.LibId).Intersect(icItem.PrevIds).ToList();
if (intersects.Any())
{
newRpt.DisplayText += "(小概率)";
}
reportsToSave.Add(newRpt);
}
else
{
var latestTime = existRpts.Max(rr => rr.LatestTime);
var latestRpt = existRpts.First(r => r.LatestTime == latestTime);
latestRpt.LatestTime = newRpt.FirstTime;
latestRpt.HappenCount++;
}
});
}
}
if (reportsToSave.Any())
{
context.InferComboReports.AddRange(reportsToSave);
}
context.SaveChanges();
}
}