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