public string GetAllWorkState()
{
RiskBLL riskBLL = new RiskBLL(); //安全风险
SaftyCheckDataBLL saBLL = new SaftyCheckDataBLL(); //安全检查
HTBaseInfoBLL htBLL = new HTBaseInfoBLL(); //事故隐患
List <object> data = new List <object>();
OrganizeBLL orgBll = new OrganizeBLL();
DataTable dt = orgBll.GetDTList();
ClassificationBLL classBLL = new ClassificationBLL();
foreach (DataRow dr in dt.Rows)
{
Operator user = new Operator
{
OrganizeId = dr["orgid"].ToString(),
OrganizeCode = dr["encode"].ToString(),
DeptCode = dr["encode"].ToString(),
RoleName = "公司级用户,公司领导"
};
decimal[] fxArr = riskBLL.GetHomeStat(user);
DataTable dtJC = saBLL.GetCheckStat(user);
DataTable dtHT = htBLL.QueryHidWorkList(user); //首页双控工作
data.Add(new { name = dr[1].ToString(), code = dr[0].ToString(), yjfx = fxArr[1], ejfx = fxArr[2], jccs = dtJC.Rows[0][0].ToString(), ybyh = dtHT.Rows[3][2].ToString(), zdyh1 = dtHT.Rows[1][2].ToString(), zdyh2 = dtHT.Rows[2][2].ToString(), yzgs = dtHT.Rows[0][3].ToString(), wzgs = dtHT.Rows[0][4].ToString(), zgl = dtHT.Rows[0][6].ToString() });
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public string GetAllRiskSate()
{
RiskBLL riskBLL = new RiskBLL(); //安全风险
SaftyCheckDataRecordBLL saBLL = new SaftyCheckDataRecordBLL(); //安全检查
HTBaseInfoBLL htBLL = new HTBaseInfoBLL(); //事故隐患
List <object> data = new List <object>();
OrganizeBLL orgBll = new OrganizeBLL();
DataTable dt = orgBll.GetDTList();
ClassificationBLL classBLL = new ClassificationBLL();
foreach (DataRow dr in dt.Rows)
{
Operator user = new Operator
{
OrganizeId = dr["orgid"].ToString(),
OrganizeCode = dr["encode"].ToString(),
RoleName = "公司级用户,公司领导"
};
//计算事故隐患总得分
decimal htScore = htBLL.GetHiddenWarning(user, "");
decimal jcScore = saBLL.GetSafeCheckSumCount(user);
decimal fxScore = riskBLL.GetRiskValueByTime(user, "");
List <ClassificationEntity> list = classBLL.GetList(user.OrganizeId).ToList();
if (list.Count == 0)
{
list = classBLL.GetList("0").ToList();
}
data.Add(new { name = dr[1].ToString(), code = dr[0].ToString(), fxScore = fxScore, jcScore = jcScore, htScore = htScore, score = htScore * decimal.Parse(list[0].WeightCoeffcient) + jcScore * decimal.Parse(list[1].WeightCoeffcient) + fxScore * decimal.Parse(list[2].WeightCoeffcient) });
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(data));
}
public ActionResult GetHiddenValues(string orgCode = "", string orgId = "")
{
Operator curUser = OperatorProvider.Provider.Current();
if (!string.IsNullOrEmpty(orgCode))
{
curUser = new Operator
{
OrganizeId = orgId,
OrganizeCode = orgCode,
RoleName = "公司级用户,公司领导"
};
}
var list = new ClassificationBLL().GetList(curUser.OrganizeId);
if (list.Count() == 0)
{
list = new ClassificationBLL().GetList("0");
}
List <string> xlist = new List <string>();
List <double> ylist = new List <double>();
for (int i = 6; i >= 1; i--)
{
string startDate = string.Empty;
startDate = DateTime.Now.AddMonths(-i).ToString("yyyy-MM") + "-01";
string endDate = Convert.ToDateTime(startDate).AddMonths(1).AddDays(-1).ToString("yyyy-MM-dd");
double score = 0;
string monthname = string.Empty;
DataTable dt = htbaseinfobll.GetHiddenInfoOfWarning(curUser, startDate, endDate);
foreach (DataRow row in dt.Rows)
{
score += Convert.ToDouble(row["score"].ToString());
}
xlist.Add(DateTime.Now.AddMonths(-i).ToString("yyyy.MM"));
ylist.Add(score);
}
var jsondata = new { x = xlist, y = ylist };
return(Content(jsondata.ToJson()));
}
public string GetWarnValue(string time = "", string orgCode = "", string orgId = "")
{
RiskBLL riskBLL = new RiskBLL(); //安全风险
SaftyCheckDataRecordBLL saBLL = new SaftyCheckDataRecordBLL(); //安全检查
HTBaseInfoBLL htBLL = new HTBaseInfoBLL(); //事故隐患
Operator user = OperatorProvider.Provider.Current();
ClassificationBLL classBLL = new ClassificationBLL();
List <ClassificationEntity> list = classBLL.GetList(user.OrganizeId).ToList();
if (list.Count == 0)
{
list = classBLL.GetList("0").ToList();
}
decimal totalScore = 0; int count = 0;
if (user.RoleName.Contains("省级用户") || user.RoleName.Contains("集团用户"))
{
if (!string.IsNullOrEmpty(orgCode))
{
user = new Operator
{
OrganizeId = orgId,
OrganizeCode = orgCode,
RoleName = "公司级用户,公司领导"
};
totalScore = desktopbll.GetScore(user, time);
}
else
{
OrganizeBLL orgBll = new OrganizeBLL();
DataTable dt = orgBll.GetDTList();
foreach (DataRow dr in dt.Rows)
{
user = new Operator
{
OrganizeId = dr[2].ToString(),
OrganizeCode = dr[0].ToString(),
RoleName = "公司级用户,公司领导"
};
totalScore += desktopbll.GetScore(user, time);
}
totalScore = totalScore / dt.Rows.Count;
}
}
else
{
totalScore = desktopbll.GetScore(user, time);
}
DataItemDetailBLL itemBLL = new DataItemDetailBLL();
string val = itemBLL.GetItemValue("基础预警区间分值设置");
count = 0;
if (!string.IsNullOrEmpty(val))
{
string[] arr = val.Split('|');
int j = 0;
foreach (string str in arr)
{
string[] arrVal = str.Split(',');
if (totalScore > decimal.Parse(arrVal[0]) && totalScore <= decimal.Parse(arrVal[1]))
{
count = j;
break;
}
j++;
}
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { score = Math.Round(totalScore, 1), index = count }));
}
public object getHomeWarning([FromBody] JObject json)
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string userId = dy.userid;
//获取用户基本信息
OperatorProvider.AppUserId = userId; //设置当前用户
Operator user = OperatorProvider.Provider.Current();
DesktopBLL desktopbll = new DesktopBLL();
RiskBLL riskBLL = new RiskBLL(); //安全风险
SaftyCheckDataRecordBLL saBLL = new SaftyCheckDataRecordBLL(); //安全检查
HTBaseInfoBLL htBLL = new HTBaseInfoBLL(); //事故隐患
ClassificationBLL classBLL = new ClassificationBLL();
DataItemDetailBLL itemBLL = new DataItemDetailBLL();
List <ClassificationEntity> list = classBLL.GetList(user.OrganizeId).ToList();
if (list.Count == 0)
{
list = classBLL.GetList("0").ToList();
}
decimal totalScore = 0;
decimal yhscore = 0;
decimal aqjcscore = 0;
decimal aqfxscore = 0;
decimal yhzlstardard = 0;
decimal aqjcstardard = 0;
decimal aqfxstardard = 0;
decimal qualifiedscore = 0;
decimal yhscore1 = 0;
decimal aqjcscore1 = 0;
decimal aqfxscore1 = 0;
string val = itemBLL.GetItemValue("基础预警区间分值设置");
int count = 0;
if (user.RoleName.Contains("省级"))
{
DataTable dtDepts = new DepartmentBLL().GetAllFactory(user);
foreach (DataRow dr in dtDepts.Rows)
{
user = new Operator
{
OrganizeId = dr[2].ToString(),
OrganizeCode = dr[0].ToString(),
};
totalScore += desktopbll.GetScore(user, "");
//计算事故隐患总得分
decimal score = htBLL.GetHiddenWarning(user, "");
totalScore += score * decimal.Parse(list[0].WeightCoeffcient);
yhscore1 += score * decimal.Parse(list[0].WeightCoeffcient);
yhzlstardard += score;
//计算安全检查总得分
score = saBLL.GetSafeCheckSumCount(user);
totalScore += score * decimal.Parse(list[1].WeightCoeffcient);
aqjcscore1 += score * decimal.Parse(list[1].WeightCoeffcient);
aqjcstardard += score;
//计算安全风险总得分
score = riskBLL.GetRiskValueByTime(user, "");
totalScore += score * decimal.Parse(list[2].WeightCoeffcient);
aqfxscore1 += score * decimal.Parse(list[2].WeightCoeffcient);
aqfxstardard += score;
}
totalScore = totalScore / dtDepts.Rows.Count;
yhscore = yhscore1 / dtDepts.Rows.Count;
aqjcscore = aqjcscore1 / dtDepts.Rows.Count;
aqfxscore = aqfxscore1 / dtDepts.Rows.Count;
yhzlstardard = yhzlstardard / dtDepts.Rows.Count;
aqjcstardard = aqjcstardard / dtDepts.Rows.Count;
aqfxstardard = aqfxstardard / dtDepts.Rows.Count;
}
else
{
//计算事故隐患总得分
decimal score = htBLL.GetHiddenWarning(user, "");
totalScore = score * decimal.Parse(list[0].WeightCoeffcient);
yhscore = score * decimal.Parse(list[0].WeightCoeffcient);
yhzlstardard = score;
//计算安全检查总得分
score = saBLL.GetSafeCheckSumCount(user);
totalScore += score * decimal.Parse(list[1].WeightCoeffcient);
aqjcscore = score * decimal.Parse(list[1].WeightCoeffcient);
aqjcstardard = score;
//计算安全风险总得分
score = riskBLL.GetRiskValueByTime(user, "");
totalScore += score * decimal.Parse(list[2].WeightCoeffcient);
aqfxscore = score * decimal.Parse(list[2].WeightCoeffcient);
aqfxstardard = score;
}
count = 0;
if (!string.IsNullOrEmpty(val))
{
string[] arr = val.Split('|');
int j = 0;
foreach (string str in arr)
{
string[] arrVal = str.Split(',');
if (totalScore > decimal.Parse(arrVal[0]) && totalScore <= decimal.Parse(arrVal[1]))
{
count = j;
break;
}
j++;
}
qualifiedscore = decimal.Parse(arr[2].Split(',')[0].ToString());
}
string warningtext = string.Empty;
switch (count)
{
case 0:
warningtext = "危险";
break;
case 1:
warningtext = "较危险";
break;
case 2:
warningtext = "较安全";
break;
case 3:
warningtext = "安全";
break;
}
bool isyhzlsucess = Math.Round(yhzlstardard, 1) >= qualifiedscore ? true : false;
bool isaqjcsucess = Math.Round(aqjcstardard, 1) >= qualifiedscore ? true : false;
bool isaqfxsucess = Math.Round(aqfxstardard, 1) >= qualifiedscore ? true : false;
return(new { code = 0, data = new { score = Math.Round(totalScore, 1), yhscore = Math.Round(yhscore, 1), aqjcscore = Math.Round(aqjcscore, 1), aqfxscore = Math.Round(aqfxscore, 1), index = count, warningtext = warningtext, isyhzlsucess = isyhzlsucess, isaqjcsucess = isaqjcsucess, isaqfxsucess = isaqfxsucess }, count = 0 });
}
public object getWarningInfo([FromBody] JObject json)
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string userId = dy.userid;
string startmonth = dy.data.startmonth; //检索对应得月份 格式"2017-11"
string starDate = startmonth + "-01"; //起始时间
//获取用户基本信息
OperatorProvider.AppUserId = userId; //设置当前用户
Operator user = OperatorProvider.Provider.Current();
decimal riskscore = 0; //安全风险得分
decimal safetyscore = 0; //安全检查得分
decimal hiddenscore = 0; //隐患排查得分
/*计算对应的分项总分*/
RiskBLL riskBLL = new RiskBLL();
SaftyCheckDataRecordBLL saftybll = new SaftyCheckDataRecordBLL();
if (user.RoleName.Contains("省级"))
{
DataTable dtDepts = new DepartmentBLL().GetAllFactory(user);
foreach (DataRow dr in dtDepts.Rows)
{
user = new Operator
{
OrganizeId = dr[2].ToString(),
OrganizeCode = dr[0].ToString(),
DeptCode = dr[0].ToString()
};
//安全风险得分 增加自己的总分(非权重计算的)
riskscore += riskBLL.GetRiskValueByTime(user, starDate);
//安全检查得分 增加自己的总分(非权重计算的)
safetyscore += saftybll.GetSafeCheckWarningM(user, starDate, 1);
//隐患排查得分 增加自己的总分(非权重计算的)
hiddenscore += new HTBaseInfoBLL().GetHiddenWarning(user, starDate);
}
riskscore = riskscore / dtDepts.Rows.Count;
safetyscore = safetyscore / dtDepts.Rows.Count;
hiddenscore = hiddenscore / dtDepts.Rows.Count;
riskscore = Math.Round(riskscore, 2);
safetyscore = Math.Round(safetyscore, 2);
hiddenscore = Math.Round(hiddenscore, 2);
}
//获取结果集
DataTable dt = new DataTable();
dt.Columns.Add("indexname"); //分项指标
dt.Columns.Add("score"); //总得分
dt.Columns.Add("weight"); //权重
dt.Columns.Add("lastscore"); //加权重所得
decimal totalscore = 0; //合计总得分
ClassificationBLL classificationbll = new ClassificationBLL();
var list = classificationbll.GetList(user.OrganizeId);
if (list.Count() == 0)
{
list = classificationbll.GetList("0");
}
foreach (ClassificationEntity entity in list)
{
DataRow row = dt.NewRow();
row["indexname"] = entity.ClassificationIndex;
row["weight"] = entity.WeightCoeffcient;
switch (entity.ClassificationCode)
{
case "01": //隐患排查
row["score"] = hiddenscore;
break;
case "02": //安全检查
row["score"] = safetyscore;
break;
case "03": //安全风险
row["score"] = riskscore;
break;
}
row["lastscore"] = Convert.ToDecimal(row["score"].ToString()) * Convert.ToDecimal(entity.WeightCoeffcient); //增加权重系数，计算得分
totalscore += Convert.ToDecimal(row["lastscore"].ToString()); //累加权重系数后所得分项总分
dt.Rows.Add(row);
}
return(new
{
code = 0,
count = 0,
data = dt,
score = totalscore
});
}
