public List <RiskLevelCount> GetRiskIdentifyCount(string orgid, int year)
{
var data = new List <RiskLevelCount>();
using (var db = _dbContext.GetIntance())
{
RiskLevelCount model1 = new RiskLevelCount();
model1.Name = "第一季度";
model1.Counts = new List <int>();
model1.Counts.Add(db.Queryable <RiskPointEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.CreateTime.Year == year && it.CreateTime.Month >= 1 && it.CreateTime.Month <= 3).Count());
model1.Counts.Add(db.Queryable <RiskClassIficationEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.CreateTime.Year == year && it.CreateTime.Month >= 1 && it.CreateTime.Month <= 3).GroupBy(it => it.RiskFactor).Count());
data.Add(model1);
RiskLevelCount model2 = new RiskLevelCount();
model2.Counts = new List <int>();
model2.Name = "第二季度";
model2.Counts.Add(db.Queryable <RiskPointEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.CreateTime.Year == year && it.CreateTime.Month >= 4 && it.CreateTime.Month <= 6).Count());
model2.Counts.Add(db.Queryable <RiskClassIficationEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.CreateTime.Year == year && it.CreateTime.Month >= 4 && it.CreateTime.Month <= 6).GroupBy(it => it.RiskFactor).Count());
data.Add(model2);
RiskLevelCount model3 = new RiskLevelCount();
model3.Counts = new List <int>();
model3.Name = "第三季度";
model3.Counts.Add(db.Queryable <RiskPointEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.CreateTime.Year == year && it.CreateTime.Month >= 7 && it.CreateTime.Month <= 9).Count());
model3.Counts.Add(db.Queryable <RiskClassIficationEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.CreateTime.Year == year && it.CreateTime.Month >= 7 && it.CreateTime.Month <= 9).GroupBy(it => it.RiskFactor).Count());
data.Add(model3);
RiskLevelCount model4 = new RiskLevelCount();
model4.Counts = new List <int>();
model4.Name = "第四季度";
model4.Counts.Add(db.Queryable <RiskPointEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.CreateTime.Year == year && it.CreateTime.Month >= 1 && it.CreateTime.Month <= 3).Count());
model4.Counts.Add(db.Queryable <RiskClassIficationEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.CreateTime.Year == year && it.CreateTime.Month >= 10 && it.CreateTime.Month <= 12).GroupBy(it => it.RiskFactor).Count());
data.Add(model4);
}
return(data);
}
public List <RiskLevelCount> GetRiskByLevelTJ(string orgid)
{
var data = new List <RiskLevelCount>();
using (var db = _dbContext.GetIntance())
{
var riskPointNameList = db.Queryable <RiskPointEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid).GroupBy(it => it.Name).Select(it => it.Name).ToList();
foreach (var obj in riskPointNameList)
{
RiskLevelCount model = new RiskLevelCount();
model.Name = obj;
model.Counts = new List <int>();
model.Counts.Add(db.Queryable <RiskClassIficationEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.RiskPointName == obj && it.RiskLevel == "1").Count());
model.Counts.Add(db.Queryable <RiskClassIficationEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.RiskPointName == obj && it.RiskLevel == "2").Count());
model.Counts.Add(db.Queryable <RiskClassIficationEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.RiskPointName == obj && it.RiskLevel == "3").Count());
model.Counts.Add(db.Queryable <RiskClassIficationEntity>().Where(it => it.DeleteMark == 1 && it.OrgId == orgid && it.RiskPointName == obj && it.RiskLevel == "4").Count());
data.Add(model);
}
}
return(data);
}
