/// <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("导出成功。"));
}