/// <summary> /// 历史记录 /// </summary> /// <param name="pagination"></param> /// <param name="queryJson"></param> /// <returns></returns> public ActionResult GetHistoryRecordPageListJson(Pagination pagination, string queryJson) { var historyId = Request["historyId"] ?? ""; queryJson = queryJson ?? ""; pagination.p_kid = "ID"; pagination.p_fields = "MeaSureNum,HAZARDSOURCEID,RISKASSESSID,historyid,districtname, DANGERSOURCE, ACCIDENTNAME,MEASURE,DEPTNAME,JDGLZRRFULLNAME,ISDANGER,case WHEN ISDANGER>0 then '是' else '否' end as ISDANGERNAME"; pagination.p_tablename = "hsd_hisrelationhd t"; pagination.conditionJson = "1=1"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode like '" + user.DeptCode + "%')"; } if (historyId.Length > 0) { pagination.conditionJson += " and historyid='" + historyId + "'"; } var watch = CommonHelper.TimerStart(); var data = hazardsourcebll.GetPageList(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
public ActionResult Export(string condition, string queryJson) { Pagination pagination = new Pagination(); queryJson = queryJson ?? ""; pagination.p_kid = "ID"; pagination.p_fields = @"districtname, dangersource,accidentname,deptname,jdglzrrfullname, case WHEN gradeval=0 then '未定级' WHEN gradeval>0 then Grade end as gradeStr, case WHEN ishx=1 then '是' else '否' end as ishxStr, case WHEN isba=1 then '是' else '否' end as isbaStr, case WHEN isdjjd=1 then '是' else '否' end as isdjjdStr"; pagination.p_tablename = "v_hsd_dangerqd_djjd t"; pagination.conditionJson = "1=1"; pagination.page = 1; pagination.sidx = "createdate"; pagination.rows = 100000000; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { if (user.RoleName.Contains("省级")) { pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode in(select encode from BASE_DEPARTMENT start with encode='" + user.NewDeptCode + "' connect by prior departmentid = parentid))"; } else { pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode in(select encode from BASE_DEPARTMENT start with encode='" + user.DeptCode + "' connect by prior departmentid = parentid))"; } //pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode like '" + user.DeptCode + "%')"; } var watch = CommonHelper.TimerStart(); var data = hazardsourcebll.GetPageList(pagination, queryJson); //设置导出格式 ExcelConfig excelconfig = new ExcelConfig(); excelconfig.Title = "重大危险源监控登记建档"; excelconfig.TitleFont = "微软雅黑"; excelconfig.TitlePoint = 25; excelconfig.FileName = "重大危险源监控登记建档.xls"; excelconfig.IsAllSizeColumn = true; //每一列的设置,没有设置的列信息,系统将按datatable中的列名导出 List <ColumnEntity> listColumnEntity = new List <ColumnEntity>(); ColumnEntity columnentity = new ColumnEntity(); listColumnEntity.Add(new ColumnEntity() { Column = "districtname", ExcelColumn = "所属区域" }); listColumnEntity.Add(new ColumnEntity() { Column = "dangersource".ToLower(), ExcelColumn = "危险源名称/场所" }); listColumnEntity.Add(new ColumnEntity() { Column = "accidentname".ToLower(), ExcelColumn = "可能导致的事故类型" }); listColumnEntity.Add(new ColumnEntity() { Column = "deptname".ToLower(), ExcelColumn = "责任部门" }); listColumnEntity.Add(new ColumnEntity() { Column = "jdglzrrfullname".ToLower(), ExcelColumn = "监督管理责任人" }); listColumnEntity.Add(new ColumnEntity() { Column = "gradeStr".ToLower(), ExcelColumn = "是否为重大危险源" }); listColumnEntity.Add(new ColumnEntity() { Column = "ishxStr".ToLower(), ExcelColumn = "是否核销" }); listColumnEntity.Add(new ColumnEntity() { Column = "isbaStr".ToLower(), ExcelColumn = "是否备案" }); listColumnEntity.Add(new ColumnEntity() { Column = "isdjjdStr".ToLower(), ExcelColumn = "是否登记建档" }); excelconfig.ColumnEntity = listColumnEntity; //调用导出方法 ExcelHelper.ExcelDownload(data, excelconfig); return(Success("导出成功。")); }
/// <summary> /// 用户列表 /// </summary> /// <param name="pagination">分页参数</param> /// <param name="queryJson">查询参数</param> /// <returns>返回分页列表Json</returns> //[HandlerMonitor(3, "分页查询用户信息!")] public ActionResult GetPageListJson(Pagination pagination, string queryJson) { queryJson = queryJson ?? ""; pagination.p_kid = "ID"; pagination.p_fields = @"gradeval,riskassessid,DeptCode as createuserdeptcode, createuserorgcode,createuserid,districtname,(select count(id) from bis_measures where riskId=t.id) MeaSureNum, DANGERSOURCE, ACCIDENTNAME,MEASURE,DEPTNAME,JDGLZRRFULLNAME,ISDANGER,RESULT, case WHEN ISDANGER>0 then '是' else '否' end as ISDANGERNAME,grade"; pagination.p_tablename = "hsd_Hazardsource t"; pagination.conditionJson = "1=1"; pagination.sidx = pagination.sidx + " " + pagination.sord + ",id"; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); string val = new DataItemDetailBLL().GetItemValue("IsOpenPassword"); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { if (user.RoleName.Contains("省级")) { pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode in(select encode from BASE_DEPARTMENT start with encode='" + user.NewDeptCode + "' connect by prior departmentid = parentid))"; } else { if (user.RoleName.Contains("厂级") || user.RoleName.Contains("公司级")) { pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode like '" + user.OrganizeCode + "%')"; } else { string authType = new AuthorizeBLL().GetOperAuthorzeType(user, HttpContext.Request.Cookies["currentmoduleId"].Value, "search"); if (!string.IsNullOrEmpty(authType)) { switch (authType) { case "1": pagination.conditionJson += " and createuserid='" + user.UserId + "'"; break; case "2": pagination.conditionJson += " and DeptCode='" + user.DeptCode + "'"; break; case "3": pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode like '" + user.DeptCode + "%')"; break; case "4": pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode like '" + user.OrganizeCode + "%')"; break; } } //if (val == "true") //{ // pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode like '" + user.OrganizeCode + "%')"; //} //else //{ // pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode like '" + user.DeptCode + "%')"; //} } } } var IsDanger = Request["IsDanger"] ?? ""; if (IsDanger.Length > 0) { pagination.conditionJson += " and IsDanger=" + IsDanger; } var Grade = Request["Grade"] ?? ""; if (Grade.Length > 0) { if (Grade == "All") { pagination.conditionJson += " and GradeVal>0"; } else { pagination.conditionJson += " and Grade='" + Grade + "' and GradeVal>0"; } } var GradeVal = Request["GradeVal"] ?? ""; if (GradeVal.Length > 0) { pagination.conditionJson += string.Format(" and GradeVal = '{0}'", GradeVal); } var FullName = Request["fullName"] ?? ""; if (FullName.Length > 0 && FullName == "全部") { } else { var UnitCode = Request["UnitCode"] ?? ""; if (UnitCode.Length > 0) { pagination.conditionJson += string.Format(" and deptcode like '{0}%'", UnitCode); } } var areaCode = Request["areaCode"] ?? ""; if (!string.IsNullOrEmpty(areaCode)) { pagination.conditionJson += string.Format(" and gradeval>0 and districtid in(select districtid from bis_district where districtcode like '{0}%')", areaCode); } var DistrictName = Request["DistrictName"] ?? ""; if (DistrictName.Length > 0) { pagination.conditionJson += " and DistrictName like '%" + DistrictName + "%'"; } var TimeYear = Request["TimeYear"] ?? ""; if (TimeYear.Length > 0) { pagination.conditionJson += string.Format(" and to_char(CreateDate, 'yyyy')='{0}'", TimeYear); } var watch = CommonHelper.TimerStart(); var data = hazardsourcebll.GetPageList(pagination, queryJson); var JsonData = new { rows = data, total = pagination.total, page = pagination.page, records = pagination.records, costtime = CommonHelper.TimerEnd(watch) }; return(Content(JsonData.ToJson())); }
public ActionResult Export(string condition, string queryJson) { Pagination pagination = new Pagination(); queryJson = queryJson ?? ""; pagination.p_kid = "ID"; pagination.p_fields = "districtname, DANGERSOURCE, jkarear,jktimestart,jktimeend,JkyhzgIds,case WHEN jkskstatus>0 then '已受控' WHEN jkskstatus=0 then '不受控' else '未监控' end as jkskstatusname"; pagination.p_tablename = "V_HSD_DANGERQD_JK t"; pagination.conditionJson = "1=1"; pagination.page = 1; pagination.rows = 100000000; Operator user = ERCHTMS.Code.OperatorProvider.Provider.Current(); if (user.IsSystem) { pagination.conditionJson = "1=1"; } else { if (user.RoleName.Contains("省级")) { pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode in(select encode from BASE_DEPARTMENT start with encode='" + user.NewDeptCode + "' connect by prior departmentid = parentid))"; } else { pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode in(select encode from BASE_DEPARTMENT start with encode='" + user.DeptCode + "' connect by prior departmentid = parentid))"; } //pagination.conditionJson += " and (CreateUserId='" + user.UserId + "' or DeptCode like '" + user.DeptCode + "%')"; } var watch = CommonHelper.TimerStart(); var data = hazardsourcebll.GetPageList(pagination, queryJson); //设置导出格式 ExcelConfig excelconfig = new ExcelConfig(); excelconfig.Title = "重大危险源监控检测"; excelconfig.TitleFont = "微软雅黑"; excelconfig.TitlePoint = 25; excelconfig.FileName = "重大危险源监控检测.xls"; excelconfig.IsAllSizeColumn = true; //每一列的设置,没有设置的列信息,系统将按datatable中的列名导出 List <ColumnEntity> listColumnEntity = new List <ColumnEntity>(); ColumnEntity columnentity = new ColumnEntity(); listColumnEntity.Add(new ColumnEntity() { Column = "districtname", ExcelColumn = "所属区域" }); listColumnEntity.Add(new ColumnEntity() { Column = "DANGERSOURCE".ToLower(), ExcelColumn = "危险源名称/场所" }); listColumnEntity.Add(new ColumnEntity() { Column = "jkarear".ToLower(), ExcelColumn = "监控地点" }); listColumnEntity.Add(new ColumnEntity() { Column = "jktimestart".ToLower(), ExcelColumn = "监控时间起" }); listColumnEntity.Add(new ColumnEntity() { Column = "jktimeend".ToLower(), ExcelColumn = "监控时间止" }); listColumnEntity.Add(new ColumnEntity() { Column = "JkyhzgIds".ToLower(), ExcelColumn = "隐患" }); listColumnEntity.Add(new ColumnEntity() { Column = "jkskstatusname".ToLower(), ExcelColumn = "监控状态" }); excelconfig.ColumnEntity = listColumnEntity; //调用导出方法 ExcelHelper.ExcelDownload(data, excelconfig); return(Success("导出成功。")); }