Esempio n. 1
0
        /// <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()));
        }
Esempio n. 2
0
        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("导出成功。"));
        }
Esempio n. 3
0
        /// <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()));
        }
Esempio n. 4
0
        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("导出成功。"));
        }