public ActionResult GetAreaListJson(string areaId = "", string mode = "", string planId = "", string dataType = "", string areaName = "")
{
DangerSourceBLL dsBll = new DangerSourceBLL();
var curUser = new OperatorProvider().Current();
List <DistrictEntity> list = bis_districtbll.GetList().Where(p => p.OrganizeId == curUser.OrganizeId).ToList();
List <DistrictEntity> districtdata = list.Where(p => p.DistrictCode.Contains(curUser.OrganizeCode) && p.DistrictID != "0").ToList();
RiskPlanBLL plan = new RiskPlanBLL();
string ids = plan.GetPlanAreaIds(0, planId);
if (dataType.Equals("0") && string.IsNullOrEmpty(ids))
{
areaId = "-1";
}
if (dataType.Equals("0"))
{
districtdata = districtdata.Where(t => !ids.Contains(t.DistrictID)).ToList();
}
else
{
districtdata = districtdata.Where(t => areaId.Contains(t.DistrictID)).ToList();
}
List <DistrictEntity> list1 = new List <DistrictEntity>();
foreach (DistrictEntity item in districtdata)
{
bool hasChildren = list.Count(t => t.ParentID == item.DistrictID) == 0 ? false : true;
if (!hasChildren)
{
item.Description = item.DistrictName;
item.DistrictName = dsBll.GetPathName(item.DistrictCode, curUser.OrganizeId);
list1.Add(item);
}
else
{
item.Description = item.DistrictName;
list1.Add(item);
}
}
if (!string.IsNullOrWhiteSpace(areaName))
{
list1 = list1.Where(t => t.DistrictName.Contains(areaName.Trim())).ToList();
}
var JsonData = new
{
rows = list1.OrderBy(t => t.DistrictCode).ThenBy(t => t.SortCode).ToList(),
total = 1,
page = 1,
records = districtdata.Count
};
return(Content(JsonData.ToJson()));
}
public ActionResult GetAreasJson(string orgID, string areaIds, string planId)
{
List <DistrictEntity> list = bis_districtbll.GetList().ToList();
List <DistrictEntity> districtdata = new List <DistrictEntity>();
districtdata = list.OrderBy(a => a.SortCode).ToList();
if (orgID != "0")
{
districtdata = districtdata.Where(a => a.OrganizeId == orgID).ToList();
}
if (!string.IsNullOrEmpty(planId))
{
RiskPlanBLL riskplanbll = new RiskPlanBLL();
string data = riskplanbll.GetCurrUserAreaId(planId, OperatorProvider.Provider.Current().Account);
districtdata = districtdata.Where(t => data.Contains(t.DistrictID)).ToList();
}
districtdata = districtdata.OrderBy(t => t.DistrictCode).ThenBy(t => t.SortCode).ToList();
List <TreeEntity> treeList = new List <TreeEntity>();
foreach (DistrictEntity item in districtdata)
{
TreeEntity tree = new TreeEntity();
bool hasChildren = districtdata.Count(t => t.ParentID == item.DistrictID) == 0 ? false : true;
tree.id = item.DistrictID;
tree.text = item.DistrictName.Replace("\\", "╲");
tree.value = item.DistrictCode;
tree.Attribute = "Code";
tree.AttributeValue = item.DistrictCode;
tree.AttributeA = "Dept";
tree.AttributeValueA = item.ChargeDept + "," + item.ChargeDeptCode + "," + item.ChargeDeptID;
tree.parentId = "0";
tree.isexpand = false;
tree.complete = true;
tree.hasChildren = hasChildren;
tree.showcheck = true;
treeList.Add(tree);
}
return(Content(treeList.TreeToJson("0")));
}
public string GetWorkList(int mode = 0)
{
//获取当前用户
Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current();
string execCheckNum = "0"; //待执行的安全检查数
string perfectionHiddenNum = "0"; //待完善隐患数
string approvalHiddenNum = "0"; //待评估隐患数
string reformHiddenNum = "0"; //待整改隐患数
string delayHiddenNum = "0"; //待审(核)批整改延期隐患数
string reviewHiddenNum = "0"; //待验收的隐患数
string recheckHiddenNum = "0"; //待复查验证的隐患数
string assessHiddenNum = "0"; //待整改效果评估隐患数
string planNum = "0"; //进行中的风险评估计划数
RiskPlanBLL planBll = new RiskPlanBLL();
planNum = planBll.GetPlanCount(user, mode).ToString();
SaftyCheckDataBLL saftbll = new SaftyCheckDataBLL();
int[] countcheck = saftbll.GetCheckCount(user, mode);
execCheckNum = countcheck.Sum() + "," + countcheck[0] + "," + countcheck[1] + "," + countcheck[2] + "," + countcheck[3] + "," + countcheck[4];
//隐患待办事项
var data = htbaseinfobll.QueryHidBacklogRecord(mode.ToString(), user.UserId);
if (data.Rows.Count == 8)
{
approvalHiddenNum = data.Rows[0]["pnum"].ToString(); //待评估隐患数
perfectionHiddenNum = data.Rows[5]["pnum"].ToString(); //待完善隐患数
reformHiddenNum = data.Rows[1]["pnum"].ToString(); //待整改隐患数
delayHiddenNum = data.Rows[2]["pnum"].ToString(); //待审(核)批整改延期隐患数
reviewHiddenNum = data.Rows[3]["pnum"].ToString(); //待验收的隐患数
recheckHiddenNum = data.Rows[6]["pnum"].ToString(); //待复查验证隐患数
assessHiddenNum = data.Rows[4]["pnum"].ToString(); //待整改效果评估隐患数
}
return(Newtonsoft.Json.JsonConvert.SerializeObject(new string[] { execCheckNum, perfectionHiddenNum, approvalHiddenNum, reformHiddenNum, delayHiddenNum, reviewHiddenNum, recheckHiddenNum, assessHiddenNum, planNum }));
}
public ActionResult GetCurListJson(string areaId = "", string mode = "", string planId = "", string dataType = "", string objId = "", string areaName = "")
{
try
{
var curUser = new OperatorProvider().Current();
List <DistrictEntity> list = new List <DistrictEntity>();
if (!string.IsNullOrEmpty(objId))
{
list = bis_districtbll.GetOrgList(objId).ToList();
}
else
{
list = bis_districtbll.GetList().ToList();
}
if (!string.IsNullOrWhiteSpace(areaName))
{
list = list.Where(t => t.DistrictName.Contains(areaName.Trim())).ToList();
}
List <DistrictEntity> allList = bis_districtbll.GetOrgList(curUser.OrganizeId).ToList();
List <DistrictEntity> districtdata = list;
if (!curUser.IsSystem && string.IsNullOrEmpty(objId))
{
districtdata = districtdata.Where(p => p.OrganizeId == curUser.OrganizeId).ToList();
}
if (string.IsNullOrEmpty(areaId))
{
if (mode == "1")
{
RiskPlanBLL plan = new RiskPlanBLL();
areaId = plan.GetPlanAreaIds(0, planId);
districtdata = districtdata.Where(t => !areaId.Contains(t.DistrictID) && t.DistrictID != "0").ToList();
List <DistrictEntity> list1 = districtdata.Where(t => t.DistrictCode.Length > 6).ToList();
foreach (DistrictEntity entity in list1)
{
if (entity.DistrictCode.Length >= 6)
{
string code = entity.DistrictCode.Substring(0, 6);
var d = districtdata.Where(t => t.DistrictCode == code);
if (districtdata.Where(t => t.DistrictCode == code).Count() == 0)
{
DistrictEntity de = list.Where(t => t.DistrictCode == code).FirstOrDefault();
if (!districtdata.Contains(de))
{
districtdata.Add(de);
}
}
}
}
}
//else
//{
// districtdata = districtdata.Where(t => areaId.Contains(t.DistrictID) && t.DistrictID != "0").ToList();
//}
List <TreeGridEntity> treeList = new List <TreeGridEntity>();
string parentId = "0";
if (!string.IsNullOrWhiteSpace(areaName) && districtdata.Count > 0)
{
districtdata = GetParentId(districtdata, allList);
// parentId = districtdata[0].ParentID;
}
districtdata = districtdata.OrderBy(a => a.DistrictCode).ThenBy(a => a.SortCode).ToList();
foreach (DistrictEntity item in districtdata)
{
TreeGridEntity tree = new TreeGridEntity();
int count = districtdata.Count(t => t.DistrictCode.StartsWith(item.DistrictCode));
int count1 = districtdata.Count(t => t.DistrictCode.StartsWith(item.DistrictCode) && t.DistrictCode != item.DistrictCode);
bool hasChildren = count1 == 0 ? false : true;
tree.id = item.DistrictID;
tree.parentId = item.ParentID;
tree.expanded = false;
tree.hasChildren = hasChildren;
tree.childCount = count;
tree.code = item.DistrictCode;
string itemJson = item.ToJson();
tree.entityJson = itemJson;
treeList.Add(tree);
}
return(Content(treeList.TreeJson(parentId)));
}
else
{
if (mode == "1")
{
RiskPlanBLL plan = new RiskPlanBLL();
string ids = plan.GetPlanAreaIds(0, planId);
if (!string.IsNullOrEmpty(ids) && dataType.Equals("0"))
{
areaId = ids;
districtdata = districtdata.Where(t => !areaId.Contains(t.DistrictID) && t.DistrictID != "0").ToList();
}
else
{
if (dataType == "0")
{
districtdata = districtdata.Where(t => t.DistrictID != "0").ToList();
}
else
{
districtdata = districtdata.Where(t => areaId.Contains(t.DistrictID) && t.DistrictID != "0").ToList();
}
}
List <DistrictEntity> list1 = districtdata.Where(t => t.DistrictCode.Length > 6).ToList();
foreach (DistrictEntity entity in list1)
{
if (entity.DistrictCode.Length >= 6)
{
string code = entity.DistrictCode.Substring(0, 6);
if (districtdata.Where(t => t.DistrictCode == code).Count() == 0)
{
DistrictEntity de = list.Where(t => t.DistrictCode == code).FirstOrDefault();
if (!districtdata.Contains(de))
{
districtdata.Add(de);
}
}
}
}
}
else
{
districtdata = districtdata.Where(t => areaId.Contains(t.DistrictID) && t.DistrictID != "0").ToList();
}
districtdata = districtdata.OrderBy(a => a.DistrictCode).ThenBy(a => a.SortCode).ToList();
var JsonData = new
{
rows = districtdata,
total = 1,
page = 1,
records = districtdata.Count
};
return(Content(JsonData.ToJson()));
}
}
catch (Exception ex)
{
return(Error(ex.ToString()));
}
}
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 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 });
}
}
