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); }