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 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 GetRiskTrend(string orgCode = "", string orgId = "")
{
List <decimal> yValues = new List <decimal>();
List <string> xValues = new List <string>();
if (CacheFactory.Cache().GetCache <List <string> >("RiskTrend_X_" + orgCode) != null)
{
xValues = CacheFactory.Cache().GetCache <List <string> >("RiskTrend_X_" + orgCode);
yValues = CacheFactory.Cache().GetCache <List <decimal> >("RiskTrend_Y_" + orgCode);
}
else
{
RiskBLL riskBLL = new RiskBLL(); //安全风险
SaftyCheckDataRecordBLL saBLL = new SaftyCheckDataRecordBLL(); //安全检查
HTBaseInfoBLL htBLL = new HTBaseInfoBLL(); //事故隐患
string time = DateTime.Now.AddMonths(-13).ToString("yyyy-MM-01");
Operator user = OperatorProvider.Provider.Current();
if (!string.IsNullOrEmpty(orgCode))
{
user = new Operator
{
OrganizeId = orgId,
OrganizeCode = orgCode,
RoleName = "公司级用户,公司领导"
};
}
//ClassificationBLL classBLL = new ClassificationBLL();
//List<ClassificationEntity> list = classBLL.GetList(user.OrganizeId).ToList();
//if (list.Count == 0)
//{
// list = classBLL.GetList("0").ToList();
//}
for (int j = 1; j <= 12; j++)
{
//decimal totalScore = 0;
////计算事故隐患总得分
string startDate = DateTime.Parse(time).AddMonths(j).ToString("yyyy-MM-dd");
//decimal score = htBLL.GetHiddenWarning(user, startDate);
//totalScore = score * decimal.Parse(list[0].WeightCoeffcient);
////计算安全检查总得分
//score = saBLL.GetSafeCheckWarningM(user, startDate, 1);
//totalScore += score * decimal.Parse(list[1].WeightCoeffcient);
////计算安全风险总得分
//score = riskBLL.GetRiskValueByTime(user, startDate);
//totalScore += score * decimal.Parse(list[2].WeightCoeffcient);
//yValues.Add(Math.Round(totalScore, 1));
//xValues.Add(DateTime.Parse(startDate).ToString("yyyy.MM"));
yValues.Add(0);
xValues.Add(DateTime.Parse(startDate).ToString("yyyy.MM"));
}
CacheFactory.Cache().WriteCache <List <string> >(xValues, "RiskTrend_X_" + orgCode, DateTime.Now.AddDays(2));
CacheFactory.Cache().WriteCache <List <decimal> >(yValues, "RiskTrend_Y_" + orgCode, DateTime.Now.AddDays(2));
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new { x = xValues, y = yValues }));
}
public object getFiveTypeInfo([FromBody] JObject json)
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
try
{
if (null != curUser)
{
//安全检查
SaftyCheckDataBLL saftycheckdatabll = new SaftyCheckDataBLL();
var dtcheck = saftycheckdatabll.GetCheckStat(curUser);
decimal checknum = 0;//安全检查次数
if (dtcheck.Rows.Count > 0)
{
checknum = decimal.Parse(dtcheck.Rows[0][0].ToString());
}
//隐患排查
HTBaseInfoBLL htbaseinfobll = new HTBaseInfoBLL();
decimal registernum = 0; //登记的隐患
decimal changenum = 0; //整改的隐患
decimal lllegalnum = 0; //违章的次数
decimal drillplannum = 0; //应急演练数量
var dtht = htbaseinfobll.GetAppHidStatistics(curUser.DeptCode, 4); //登记的隐患数量
if (dtht.Rows.Count > 0)
{
registernum = decimal.Parse(dtht.Rows[0][0].ToString()); //登记的隐患数量
changenum = decimal.Parse(dtht.Rows[1][0].ToString()); //整改的隐患数量
lllegalnum = decimal.Parse(dtht.Rows[2][0].ToString()); //违章的次数
drillplannum = decimal.Parse(dtht.Rows[3][0].ToString()); //应急演练数量
}
return(new
{
Code = 0,
Count = 0,
Info = "获取数据成功",
data = new
{
checknum = checknum, //安全检查数
registernum = registernum, //登记的隐患
changenum = changenum, //整改的隐患
lllegalnum = lllegalnum, //违章的次数
drillplannum = drillplannum //应急演练数量
}
});
}
else
{
return(new { Code = -1, Count = 0, Info = "用户不存在!" });
}
}
catch (Exception ex)
{
return(new { Code = -1, Count = 0, Info = ex.Message });
throw;
}
}
public ActionResult SaveForm(string keyValue, JkjcEntity entity)
{
//查询隐患数量
HTBaseInfoBLL htbaseinfobll = new HTBaseInfoBLL(); //隐患基本信息
var list = htbaseinfobll.GetList(" and relevanceType='DangerSource' and RelevanceId='" + entity.ID + "'").ToList();
entity.JkyhzgIds = list.Count.ToString();
jkjcbll.SaveForm(keyValue, entity);
return(Success("操作成功。"));
}
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 ActionResult SaveSettingForm(string keyCode, HTChangeInfoEntity entity)
{
Operator curUser = new OperatorProvider().Current();
string hidid = Request.Form["HIDID"] != null ? Request.Form["HIDID"].ToString() : ""; //隐患主键
HTBaseInfoEntity bsentity = new HTBaseInfoBLL().GetEntity(hidid); //主键
string rankname = string.Empty;
bool isUpdateDate = false; //是否更新时间
var cEntity = htchangeinfobll.GetEntityByCode(keyCode); //根据HidCode获取整改对象
string postponereason = Request.Form["POSTPONEREASON"] != null ? Request.Form["POSTPONEREASON"].ToString() : "";
string controlmeasure = Request.Form["CONTROLMEASURE"] != null ? Request.Form["CONTROLMEASURE"].ToString() : ""; //管控措施
try
{
WfControlObj wfentity = new WfControlObj();
wfentity.businessid = hidid; //
wfentity.argument1 = bsentity.MAJORCLASSIFY;
wfentity.argument3 = bsentity.HIDTYPE; //隐患类别
wfentity.startflow = "整改延期申请";
wfentity.submittype = "提交";
wfentity.rankid = bsentity.HIDRANK;
wfentity.user = curUser;
wfentity.mark = "整改延期流程";
wfentity.organizeid = bsentity.HIDDEPART; //对应电厂id
//获取下一流程的操作人
WfControlResult result = wfcontrolbll.GetWfControl(wfentity);
//保存申请记录
HTExtensionEntity exentity = new HTExtensionEntity();
//处理成功
if (result.code == WfCode.Sucess)
{
string participant = result.actionperson;
string wfFlag = result.wfflag;
cEntity.POSTPONEPERSON = "," + participant + ","; // 用于当前人账户判断是否具有操作其权限
cEntity.POSTPONEDAYS = entity.POSTPONEDAYS; //申请天数
cEntity.POSTPONEDEPT = result.deptcode; //审批部门Code
cEntity.POSTPONEDEPTNAME = result.deptname; //审批部门名称
cEntity.POSTPONEPERSONNAME = result.username;
cEntity.APPLICATIONSTATUS = wfFlag;
//是否更新时间，累加天数
if (wfFlag == "2")
{
isUpdateDate = true;
}
//如果安环部、生技部审批通过，则更改整改截至时间、验收时间，增加相应的整改天数
if (isUpdateDate)
{
//重新赋值整改截至时间
cEntity.CHANGEDEADINE = cEntity.CHANGEDEADINE.Value.AddDays(cEntity.POSTPONEDAYS);
//更新验收时间
HTAcceptInfoEntity aEntity = htacceptinfobll.GetEntityByHidCode(keyCode);
if (null != aEntity.ACCEPTDATE)
{
aEntity.ACCEPTDATE = aEntity.ACCEPTDATE.Value.AddDays(cEntity.POSTPONEDAYS);
}
htacceptinfobll.SaveForm(aEntity.ID, aEntity);
exentity.HANDLESIGN = "1"; //成功标记
}
cEntity.APPSIGN = "Web";
//更新整改信息
htchangeinfobll.SaveForm(cEntity.ID, cEntity); //更新延期设置
exentity.HIDCODE = cEntity.HIDCODE;
exentity.HIDID = hidid;
exentity.HANDLEDATE = DateTime.Now;
exentity.POSTPONEDAYS = entity.POSTPONEDAYS.ToString();
exentity.HANDLEUSERID = curUser.UserId;
exentity.HANDLEUSERNAME = curUser.UserName;
exentity.HANDLEDEPTCODE = curUser.DeptCode;
exentity.HANDLEDEPTNAME = curUser.DeptName;
exentity.HANDLETYPE = "0"; //申请类型 状态返回 2 时表示整改延期完成 (申请)
exentity.HANDLEID = DateTime.Now.ToString("yyyyMMddhhmmss").ToString();
exentity.POSTPONEREASON = postponereason; //延期理由
exentity.CONTROLMEASURE = controlmeasure; //临时管控措施
exentity.APPSIGN = "Web";
htextensionbll.SaveForm("", exentity);
//极光推送
htworkflowbll.PushMessageForWorkFlow("隐患处理审批", "整改延期审批", wfentity, result);
return(Success(result.message));
}
else
{
return(Error(result.message));
}
}
catch (Exception ex)
{
return(Error(ex.Message.ToString()));
}
}
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
});
}
public object getMainInfo([FromBody] JObject json)
{
try
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string userId = dy.userid;
//获取用户基本信息
OperatorProvider.AppUserId = userId; //设置当前用户
Operator user = OperatorProvider.Provider.Current();
int safechecknum = 0; //待执行的安全检查数
int appoveproblemnum = 0; //待评估隐患数
int changeplanproblemnum = 0; //待制定整改计划
int modifyproblemnum = 0; //待整改隐患数
int modifypostphoneproblemnum = 0; //待审(核)批整改延期隐患数
int reviewproblemnum = 0; //待复查验收的隐患数
int assessproblemnum = 0; //待评估隐患数
int overtimempnum = 0; //逾期未整改隐患
int meuploadp = 0; //我上传的隐患
int planNum = 0; //进行中的风险辨识计划数
RiskPlanBLL planBll = new RiskPlanBLL();
planNum = planBll.GetPlanCount(user, 10);
SaftyCheckDataBLL saftbll = new SaftyCheckDataBLL();
int[] countcheck = saftbll.GetCheckCount(user, 0);
safechecknum = countcheck.Sum();
//隐患待办事项
var data = new HTBaseInfoBLL().QueryHidBacklogRecord("0", user.UserId);
if (data.Rows.Count == 8)
{
appoveproblemnum = int.Parse(data.Rows[0]["pnum"].ToString());
modifyproblemnum = int.Parse(data.Rows[1]["pnum"].ToString());
modifypostphoneproblemnum = int.Parse(data.Rows[2]["pnum"].ToString());
reviewproblemnum = int.Parse(data.Rows[3]["pnum"].ToString());
assessproblemnum = int.Parse(data.Rows[4]["pnum"].ToString());
changeplanproblemnum = int.Parse(data.Rows[7]["pnum"].ToString());
}
var datas = new HTBaseInfoBLL().QueryHidBacklogRecord("10", user.UserId);
if (datas.Rows.Count == 2)
{
if (datas.Rows[0]["serialnumber"].ToString() == "1")
{
meuploadp = int.Parse(datas.Rows[0]["pnum"].ToString());
}
if (datas.Rows[1]["serialnumber"].ToString() == "2")
{
overtimempnum = int.Parse(datas.Rows[1]["pnum"].ToString());
}
}
int meetnum = 0; //安全会议数量
int verifydangerworknum = 0; //高风险作业审核数量
int approvedangerworknum = 0; //高风险作业审批数量
int monitordangerworknum = 0; //高风险作业监督数量
int approveillegalnum = 0; //待核准的违章数量
int verifyillegalnum = 0; //待整改的违章数量
int reviewillegalnum = 0; //待验收的违章数量
int risktrainnum = 0; //风险预知训练
return(new
{
Code = 0,
Count = -1,
Info = "获取数据成功",
data = new
{
safechecknum = safechecknum, //安全检查数
appoveproblemnum = appoveproblemnum, //待评估隐患
changeplanproblemnum = changeplanproblemnum, //待制定整改计划
modifyproblemnum = modifyproblemnum, //待整改隐患
modifypostphoneproblemnum = modifypostphoneproblemnum, //待审(核)批整改延期隐患数
reviewproblemnum = reviewproblemnum, //待复查验收的隐患数
assessproblemnum = assessproblemnum, //待评估隐患数
assessplannum = planNum, //待辨识的计划
overtimempnum = overtimempnum, //逾期未整改隐患
meuploadp = meuploadp, //我上传的隐患
meetnum = meetnum, ///安全会议数量
verifydangerworknum = verifydangerworknum, //高风险作业审核数量
approvedangerworknum = approvedangerworknum, //高风险作业审批数量
monitordangerworknum = monitordangerworknum, //高风险作业监督数量
risktrainnum = risktrainnum, //风险预知训练
approveillegalnum = approveillegalnum, //待核准的违章数量
verifyillegalnum = verifyillegalnum, //待整改的违章数量
reviewillegalnum = reviewillegalnum //待验收的违章数量
}
});
}
catch (Exception ex)
{
return(new { Code = -1, Count = 0, Info = ex.Message });
}
}
public object getDelayItemsForGroup([FromBody] JObject json)
{
try
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string userId = dy.userid;
//获取用户基本信息
OperatorProvider.AppUserId = userId; //设置当前用户
Operator user = OperatorProvider.Provider.Current();
int safechecknum = 0; //待执行安全检查数
int appoveproblemnum = 0; //待评估隐患数
int modifypostphoneproblemnum = 0; //待延期审（核）批
int reviewproblemnum = 0; //待验收隐患
int modifyproblemnum = 0; //待复查验证隐患
int assessproblemnum = 0; //待整改效果评估
int illegalNum = 0; //违章次数
int reviewIllegalNum = 0; //待验收的违章数
//SaftyCheckDataBLL saftbll = new SaftyCheckDataBLL();
//int[] countcheck = saftbll.GetCheckCount(user, 0);
//safechecknum = countcheck.Sum();
//隐患待办事项
var data = new HTBaseInfoBLL().QueryHidBacklogRecord("0", user.UserId);
if (data.Rows.Count == 8)
{
appoveproblemnum = int.Parse(data.Rows[0]["pnum"].ToString()); //待评估隐患数
modifypostphoneproblemnum = int.Parse(data.Rows[2]["pnum"].ToString()); //待延期审（核）批
reviewproblemnum = int.Parse(data.Rows[3]["pnum"].ToString()); //待验收隐患
assessproblemnum = int.Parse(data.Rows[4]["pnum"].ToString()); //待整改效果评估
modifyproblemnum = int.Parse(data.Rows[6]["pnum"].ToString()); //待复查验证隐患
}
List <int> list = new DesktopBLL().GetSafetyCheckForGroup(user);
int deptNum = 0; //一级风险超过3个的电厂数量
int oneRiskNum = 0; //重大风险总数
int twoRiskNum = 0; //较大风险总数
if (user.RoleName.Contains("省级用户"))
{
DataTable dt = riskassessbll.GetIndexRiskTarget("重大风险", user, 1);
DataTable dt1 = riskassessbll.GetIndexRiskTarget("较大风险", user, 2);
DataTable dt2 = riskassessbll.GetIndexRiskTarget("重大风险", user, 3);
deptNum = dt2.Rows.Count;
if (dt.Rows.Count > 0)
{
oneRiskNum = Convert.ToInt32(dt.Compute("Sum(num)", ""));
}
else
{
oneRiskNum = 0;
}
if (dt1.Rows.Count > 0)
{
twoRiskNum = Convert.ToInt32(dt1.Compute("Sum(num)", ""));
}
else
{
twoRiskNum = 0;
}
}
int bigHtNum = 0; //重大隐患数量
int overdueHtNum = 0; //逾期未整改隐患数量
int htNum = 0; //省公司发现隐患
int checkNum = 0; //检查次数
checkNum = list[0];
safechecknum = list[1];
List <decimal> list1 = new DesktopBLL().GetWarnItems(user);
decimal reformPercentNum = list1[1]; //隐患整改率低于80%的电厂数
decimal bigHtFactoryNum = list1[3]; //存在重大隐患电厂数
//重要指标之重大隐患、逾期未整改隐患、省公司发现的隐患
list = new DesktopBLL().GetHtForGroup(user);
bigHtNum = list[0]; //重大隐患数
overdueHtNum = list[2]; //逾期未整改隐患数
htNum = list[3]; //省公司排查的隐患数量
illegalNum = list[6]; //违章次数
reviewIllegalNum = list[5]; //待验收违章
return(new
{
Code = 0,
Count = -1,
Info = "获取数据成功",
data = new
{
safeCheckNum = safechecknum, //待执行安全检查数
appoveProblemNum = appoveproblemnum, //待评估隐患
delayProblemNum = modifypostphoneproblemnum, //待延期审（核）批
reviewProblemNum = reviewproblemnum, //待验收隐患
modifyProblemNum = modifyproblemnum, //待复查验证隐患
assessProblemNum = assessproblemnum, //待整改效果评估
bigHtNum = bigHtNum, //重大隐患数量
overdueHtNum = overdueHtNum, //逾期未整改隐患数量
htNum = htNum, //省公司发现隐患
checkNum = checkNum, //检查次数
reformPercentNum = reformPercentNum, //隐患整改率低于80%的电厂数
bigHtFactoryNum = bigHtFactoryNum, //存在重大隐患电厂数
reviewIllegalNum = reviewIllegalNum, //待验收违章
illegalNum = illegalNum, //违章次数
deptNum = deptNum,
oneRiskNum = oneRiskNum,
twoRiskNum = twoRiskNum
}
});
}
catch (Exception ex)
{
return(new { Code = -1, Count = 0, Info = ex.Message });
}
}
public object getDelayItems([FromBody] JObject json)
{
try
{
string res = json.Value <string>("json");
dynamic dy = JsonConvert.DeserializeObject <ExpandoObject>(res);
string userId = dy.userid;
//获取用户基本信息
OperatorProvider.AppUserId = userId; //设置当前用户
Operator user = OperatorProvider.Provider.Current();
int safechecknum = 0; //待执行的安全检查数
int appoveproblemnum = 0; //待评估隐患数
int changeplanproblemnum = 0; //待制定整改计划
int modifyproblemnum = 0; //待整改隐患数
int modifypostphoneproblemnum = 0; //待审(核)批整改延期隐患数
int reviewproblemnum = 0; //待复查验收的隐患数
int assessproblemnum = 0; //待评估隐患数
int overtimempnum = 0; //逾期未整改隐患
int uploadHtNum = 0; //我上传的隐患
int planNum = 0; //进行中的风险辨识计划数
int dailyexamineNum = 0; //日常考核待审核数
RiskPlanBLL planBll = new RiskPlanBLL();
planNum = planBll.GetPlanCount(user, 10);
SaftyCheckDataBLL saftbll = new SaftyCheckDataBLL();
int[] countcheck = saftbll.GetCheckCount(user, 0);
safechecknum = countcheck.Sum();
DailyexamineBLL dailyexaminebll = new DailyexamineBLL();
dailyexamineNum = dailyexaminebll.CountIndex(user);
int awaitHtNum = 0;//待完善的隐患数量
//隐患待办事项
var data = new HTBaseInfoBLL().QueryHidBacklogRecord("0", user.UserId);
if (data.Rows.Count == 8)
{
appoveproblemnum = int.Parse(data.Rows[0]["pnum"].ToString());
changeplanproblemnum = int.Parse(data.Rows[7]["pnum"].ToString());
modifyproblemnum = int.Parse(data.Rows[1]["pnum"].ToString());
modifypostphoneproblemnum = int.Parse(data.Rows[2]["pnum"].ToString());
reviewproblemnum = int.Parse(data.Rows[3]["pnum"].ToString());
assessproblemnum = int.Parse(data.Rows[4]["pnum"].ToString());
awaitHtNum = int.Parse(data.Rows[5]["pnum"].ToString());
}
var datas = new HTBaseInfoBLL().QueryHidBacklogRecord("10", user.UserId);
if (datas.Rows.Count == 2)
{
if (datas.Rows[0]["serialnumber"].ToString() == "1")
{
uploadHtNum = int.Parse(datas.Rows[0]["pnum"].ToString());
}
if (datas.Rows[1]["serialnumber"].ToString() == "2")
{
overtimempnum = int.Parse(datas.Rows[1]["pnum"].ToString());
}
}
DesktopBLL desktop = new DesktopBLL();
List <int> list = desktop.GetHtNum(user);
int htNum = list[0]; //隐患数量
int bigHtNum = list[1]; //重大隐患数量
int overdueHtCompleteNum = list[3]; //整改延期数量
list = desktop.GetRiskNum(user);
int bigRiskNum = list[1];//重大风险数量
list = desktop.GetWorkNum(user);
int waitconfirmationnum = list[0]; //高风险通用待确认作业数量
int waitapproveworknum = list[1]; //高风险通用待审核(批)作业数量
int monitordangerworknum = list[5]; //高风险待监督的数量
int sidetaskallocation = list[2]; //高风险待分配任务
int sidesupervisionnum = list[6]; //高风险待监管任务
int dangerworknum = list[3]; //高风险作业数量
list = desktop.GetScaffoldNum(user);
int waitscaffoldchecknum = list[0]; //脚手架待验收
int waitscaffoldauditnum = list[1]; //脚手架待审核
int specialEquNum = desktop.GetEquimentNum(user); //特种设备数量
int dangerProjectNum = desktop.GetProjectNum(user); //施工中的危大工程数量
list = desktop.GetlllegalNum(user);
int illegalNum = list[0]; //违章数量
int approveillegalnum = list[1]; //待核准的违章数量
int verifyillegalnum = list[2]; //待整改的违章数量
int reviewillegalnum = list[3]; //待验收的违章数量
int overdueIllegalNum = list[4]; //逾期未整改违章数量
decimal illegalCompleteRatio = desktop.GetlllegalRatio(user); //违章整改率
int meetnum = desktop.GetMeetNum(user.UserId); //安全会议数量
int safetynum = desktop.GetSafetyChangeNum(user); //安全设施变动审待核数量
int risktrainnum = 0; //风险预知训练
list = new OutprojectblacklistBLL().ToAuditOutPeoject(user); //外包工程
int wbscla = list[2]; //待审（核）批三措两案
int wbrcsq = list[5]; //待审（核）批入厂许可
int wbkgsq = list[6]; //待审（核）批开工申请
//data.Add("WBDWZZ", wb[0]);//单位资质
//data.Add("WBRYZZ", wb[1]);//人员资质
//data.Add("WBSCLA", wb[2]);//三措两案
//data.Add("WBDDSB", wb[3]);//特种设备
//data.Add("WBTZSB", wb[4]);//电动设备
//data.Add("WBRCSQ", wb[5]);//入场许可
//data.Add("WBKGSQ", wb[6]);//开工申请
return(new
{
Code = 0,
Count = -1,
Info = "获取数据成功",
data = new
{
safeCheckNum = safechecknum, //安全检查数
meetNum = meetnum, ///安全会议数量
modifyProblemNum = modifyproblemnum, //待整改隐患
appoveProblemNum = appoveproblemnum, //待评估隐患
changeplanProblemNum = changeplanproblemnum, //待制定整改计划
reviewProblemNum = reviewproblemnum, //待复查验收的隐患数
delayProblemNum = modifypostphoneproblemnum, //待审(核)批整改延期隐患数
assessProblemNum = assessproblemnum, //待整改效果评估隐患
assessPlanNum = planNum, //待辨识的计划
dangerWorkNum = dangerworknum, //高风险作业数量
monitorDangerworkNum = monitordangerworknum, //高风险作业监督数量
waitConfirmationNum = waitconfirmationnum, //高风险通用待确认作业数量
waitApproveWorkNum = waitapproveworknum, //高风险通用待审核(批)作业数量
sidetaskallocation = sidetaskallocation, //待分配
sidesupervisionnum = sidesupervisionnum, //待监管
waitscaffoldcheckNum = waitscaffoldchecknum, //脚手架待验收
waitscaffoldauditNum = waitscaffoldauditnum, //脚手架待审核
dangerTrainNum = risktrainnum, //风险预知训练
approveIllegalNum = approveillegalnum, //待核准的违章数量
verifyIllegalNum = verifyillegalnum, //待整改的违章数量
reviewIllegalNum = reviewillegalnum, //待验收的违章数量
htNum = htNum, //隐患数量
bigHtNum = bigHtNum, //重大隐患数量
overdueHtNum = overtimempnum, //逾期未整改隐患数量
bigRiskNum = bigRiskNum, //重大风险数量
specialEquNum = specialEquNum, //特种设备数量
dangerProjectNum = dangerProjectNum, //施工中的危大工程数量
overdueIllegalNum = overdueIllegalNum, //逾期未整改违章数量
illegalCompleteRatio = illegalCompleteRatio, //违章整改率
illegalNum = illegalNum, //违章数量
overdueHtCompleteNum = overdueHtCompleteNum, //整改延期隐患数量
uploadHtNum = uploadHtNum, //我上传隐患数量
safetynum = safetynum, //安全设施变动审待核数量
awaitHtNum = awaitHtNum, //待完善的隐患数量
wbsclaNum = wbscla,
wbrcsqNum = wbrcsq,
wbkgsqNum = wbkgsq,
dailyexamineNum = dailyexamineNum
}
});
}
catch (Exception ex)
{
return(new { Code = -1, Count = 0, Info = ex.Message });
}
}
