bksh_table.jsp 12.0 KB
<%@ page language="java" contentType="text/html; charset=utf-8"
	pageEncoding="utf-8"%>
<%@ page import="com.dao.bksh.SHDataBase"%>
<%@ page import="com.dao.dbutil.DataBase"%>
<%@ page import="com.vo.SHDataManage"%>
<%@ page import="com.vo.SH_outline_DataManage"%>
<%@ page import="com.vo.sh_Sound"%>
<%@ page import="java.text.SimpleDateFormat"%>
<%@ page import="java.util.Date"%>

<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN" "http://www.w3.org/TR/html4/loose.dtd">
<html>
<head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<link rel="stylesheet" href="../../css/table.css" type="text/css" />
<script type="text/jscript" src="../../js/datatable/tablecloth.js"></script>
<%
	String outdate;
	String selectresult = request.getParameter("selectdate");
	SimpleDateFormat df = new SimpleDateFormat("yyyy-MM-dd HH:00:00");//设置日期格式
	SimpleDateFormat df_month = new SimpleDateFormat("yyyy-MM-dd ");//设置日期格式
	if (selectresult == null || selectresult == "") {
		selectresult = df.format(new Date());
	}
	SHDataBase shdb = new SHDataBase();
	DataBase db = new DataBase();
	selectresult = shdb.showRightTime(selectresult);
	SHDataManage sh = shdb.getPublicData(selectresult);//在线数据查询
	SH_outline_DataManage shoutline = shdb.getoutlineData(selectresult);//手工数据查询
	if( shoutline.getDate()==null){
		outdate = 	df_month.format(new Date());
	}
	 outdate = shoutline.getDate().substring(0, 10);
	//排放标准字符串
	String outstrand = "DB11/890-2012城镇污水处理厂水污染物排放标准";
	sh_Sound sound=shdb.getSound(selectresult);//厂界噪声查询
	String soundTime=sound.getDate().substring(0, 7);
%>
</head>
<body>
	<table align="center">
		<tr style="height: 55px; ">
			<th width="3%" height="25">企业名称</th>
			<th width="3%">检测方式</th>
			<th width="5%">监测点位</th>
			<th width="6%">监测时间</th>
			<th colspan="2" width="1%">监测项目及排放浓度</th>
			<th width="8%">污染物排放标准限值</th>
			<th width="3%">是否达标</th>
			<th width="2%">超标倍数</th>
			<th width="5%">评价标准</th>
			<th width="3%">排放方式</th>
			<th width="3%">排放去向</th>
			<th width="20%">备注</th>
		</tr>
		<tr>
			<td rowspan="31">昌祥污水净化有限公司</td>
			<td rowspan="9">在线监测</td>
			<td>进水口</td>
			<td><%=selectresult%></td>
			<td width="6%">COD(mg/l)</td>
			<td width="8%"><%=sh.getCxwsjh_incod_eq()%></td>
			<td>--</td>
			<td>--</td>
			<td>--</td>
			<td rowspan="22">《城镇污水处理厂水污染物排放标准》(DB11/890-2012   表1-B标准)</td>
			<td rowspan="22">达标后排放</td>
			<td rowspan="22">东沙河</td>
			<td><%=sh.getA_incod_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=selectresult%></td>
			<td>COD(mg/l)</td>
			<td><%=sh.getCxwsjh_outcod_eq()%></td>
			<td>≤30</td>
			<td><%=shdb.iSInTostandard(sh.getA_outcod_mul())%></td>
			<td><%=sh.getA_outcod_mul()%></td>
			<td><%=sh.getA_outcod_note()%></td>
		</tr>
		<tr>
			<td>进水口</td>
			<td><%=selectresult%></td>
			<td>氨氮(mg/l)</td>
			<td><%=sh.getCxwsjh_innh4n_eq()%></td>
			<td>--</td>
			<td>--</td>
			<td>--</td>
			<td><%=sh.getA_innh4n_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=selectresult%></td>
			<td>氨氮(mg/l)</td>
			<td><%=sh.getCxwsjh_outnh4n_eq()%></td>
			<td>≤1.5</td>
			<td><%=shdb.iSInTostandard(sh.getA_outnh4n_mul())%></td>
			<td><%=sh.getA_outnh4n_mul()%></td>
			<td><%=sh.getA_outnh4n_note()%></td>
		</tr>
		<tr>
			<td>进水口</td>
			<td><%=selectresult%></td>
			<td>PH</td>
			<td><%=sh.getCxwsjh_inph_eq()%></td>
			<td>--</td>
			<td>--</td>
			<td>--</td>
			<td><%=sh.getA_inph_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=selectresult%></td>
			<td>PH</td>
			<td><%=sh.getCxwsjh_outph_eq()%></td>
			<td>6.5~8.5</td>
			<td><%=shdb.iSInTostandard(sh.getA_outph_mul())%></td>
			<td><%=sh.getA_outph_mul()%></td>
			<td><%=sh.getA_outph_note()%></td>
		</tr>
	    <!--新增加的总磷,总氮  -->
 	    <tr>
			<td>进水口</td>
			<td><%=selectresult%></td>
			<td>总磷(mg/l)</td>
			<td><%=sh.getCxwsjh_intp_eq()%></td>
			<td>--</td>
			<td>--</td>
			<td>--</td>
<%-- 			<td><%=shdb.iSInTostandard(sh.getA_intp_mul())%></td>
			<td><%=sh.getA_intp_mul()%></td> --%>
			<td><%=sh.getA_intp_note()%></td>
		</tr>
	    
		<tr>
			<td>出水口</td>
			<td><%=selectresult%></td>
			<td>总磷(mg/l)</td>
			<td><%=sh.getCxwsjh_outzl_eq()%></td>
			<td>≤0.3</td>
			<td><%=shdb.iSInTostandard(sh.getA_outzl_mul())%></td>
			<td><%=sh.getA_outzl_mul()%></td>
			<td><%=sh.getA_outzl_note()%></td>
		</tr>

		<tr>
			<td>出水口</td>
			<td><%=selectresult%></td>
			<td>总氮(mg/l)</td>
			<td><%=sh.getCxwsjh_outzd_eq()%></td>
			<td>≤15</td>
			<td><%=shdb.iSInTostandard(sh.getA_outzd_mul())%></td>
			<td><%=sh.getA_outzd_mul()%></td>
			<td><%=sh.getA_outzd_note()%></td>
		</tr>
		<!--新增加的总磷,总氮  -->
		
		<tr>
			<td rowspan="13" style="background:#e5f1f4">手工监测</td>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>生化需氧量(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_shxyl())%></td>
			<td>≤6</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_shxyl_mul())%></td>
			<td><%=shoutline.getA_shxyl_mul()%></td>
			<td><%=shoutline.getA_shxyl_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>悬浮物(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_ss())%></td>
			<td>≤5</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_ss_mul())%></td>
			<td><%=shoutline.getA_ss_mul()%></td>
			<td><%=shoutline.getA_ss_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>动植物油(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_dzwy())%></td>
			<td>≤0.5</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_dzwy_mul())%></td>
			<td><%=shoutline.getA_dzwy_mul()%></td>
			<td><%=shoutline.getA_dzwy_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>石油类(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_syl())%></td>
			<td>≤0.5</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_syl_mul())%></td>
			<td><%=shoutline.getA_syl_mul()%></td>
			<td><%=shoutline.getA_syl_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>阴离子表面活性剂(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_ylzbmhxj())%></td>
			<td>≤0.3</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_ylzbmhxj_mul())%></td>
			<td><%=shoutline.getA_ylzbmhxj_mul()%></td>
			<td><%=shoutline.getA_ylzbmhxj_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>色度(稀释倍数)</td>
			<td><%=db.roundtofour(shoutline.getA_sd())%></td>
			<td>≤15</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_sd_mul())%></td>
			<td><%=shoutline.getA_sd_mul()%></td>
			<td><%=shoutline.getA_sd_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>粪大肠菌群(MPN/L)</td>
			<td><%=db.roundtofour(shoutline.getA_fdcjq())%></td>
			<td>≤1000</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_fdcjq_mul())%></td>
			<td><%=shoutline.getA_fdcjq_mul()%></td>
			<td><%=shoutline.getA_fdcjq_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>总镉(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_tcd())%></td>
			<td>≤0.005</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_tcd_mul())%></td>
			<td><%=shoutline.getA_tcd_mul()%></td>
			<td><%=shoutline.getA_tcd_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>总铬(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_tcr())%></td>
			<td>≤0.1</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_tcr_mul())%></td>
			<td><%=shoutline.getA_tcr_mul()%></td>
			<td><%=shoutline.getA_tcr_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>六价铬(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_ljg())%></td>
			<td>≤0.05</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_ljg_mul())%></td>
			<td><%=shoutline.getA_ljg_mul()%></td>
			<td><%=shoutline.getA_ljg_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>总砷(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_tas())%></td>
			<td>≤0.05</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_tas_mul())%></td>
			<td><%=shoutline.getA_tas_mul()%></td>
			<td><%=shoutline.getA_tas_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>总铅(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_tpb())%></td>
			<td>≤0.05</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_tpb_mul())%></td>
			<td><%=shoutline.getA_tpb_mul()%></td>
			<td><%=shoutline.getA_tpb_note()%></td>
		</tr>
		<tr>
			<td>出水口</td>
			<td><%=outdate%></td>
			<td>烷基汞(mg/L)</td>
			<td><%=db.roundtofour(shoutline.getA_wjg())%></td>
			<td>不得检出</td>
			<td><%=shdb.iSInTostandard(shoutline.getA_wjg_mul())%></td>
			<td><%=shoutline.getA_wjg_mul()%></td>
			<td><%=shoutline.getA_wjg_note()%></td>
		</tr>
		<tr></tr>
		<tr>
			<td  rowspan="8" style="background:#e5f1f4">厂界噪音手工检测</td>
			<td>厂区厂界(东)</td>
			<td><%=soundTime%><br>(昼间)</td>
			<td>厂界噪声dB(A)</td>
			<td><%=db.roundtofour(sound.getSound_e()) %></td>
			<td>≤55</td>
			<td><%=shdb.iSInTostandard(sound.getSound_e_mul())%></td>
			<td><%=sound.getSound_e_mul() %></td>
			<td rowspan="8" style="background:#e5f1f4">--</td>
			<td rowspan="8" style="background:#e5f1f4">--</td>
            <td rowspan="8" style="background:#e5f1f4">--</td>
			
			<td><%=sound.getSound_e_note() %></td>
		</tr>
		<tr>
		<td>厂区厂界(西)</td>
			<td><%=soundTime%><br>(昼间)</td>
			<td>厂界噪声dB(A)</td>
			<td><%=db.roundtofour(sound.getSound_w()) %></td>
			<td>≤55</td>
			<td><%=shdb.iSInTostandard(sound.getSound_w_mul())%></td>
			<td><%=sound.getSound_w_mul() %></td>
			<td><%=sound.getSound_w_note() %></td>
		</tr>
		<tr>
		<td>厂区厂界(南)</td>
			<td><%=soundTime%><br>(昼间)</td>
			<td>厂界噪声dB(A)</td>
			<td><%=db.roundtofour(sound.getSound_s()) %></td>
			<td>≤55</td>
			<td><%=shdb.iSInTostandard(sound.getSound_s_mul())%></td>
			<td><%=sound.getSound_s_mul() %></td>
			<td><%=sound.getSound_s_note() %></td>
		</tr>
		<tr>
		<td>厂区厂界(北)</td>
			<td><%=soundTime%><br>(昼间)</td>
			<td>厂界噪声dB(A)</td>
			<td><%=db.roundtofour(sound.getSound_n()) %></td>
			<td>≤55</td>
			<td><%=shdb.iSInTostandard(sound.getSound_n_mul())%></td>
			<td><%=sound.getSound_n_mul() %></td>
			<td><%=sound.getSound_n_note() %></td>
		</tr>
		<tr>
			
			<td>厂区厂界(东)</td>
			<td><%=soundTime%><br>(夜间)</td>
			<td>厂界噪声dB(A)</td>
			<td><%=db.roundtofour(sound.getSound_e_night()) %></td>
			<td>≤45</td>
			<td><%=shdb.iSInTostandard(sound.getSound_e_night_mul())%></td>
			<td><%=sound.getSound_e_night_mul() %></td>		
			<td><%=sound.getSound_e_night_note() %></td>
		</tr>
		<tr>
		<td>厂区厂界(西)</td>
			<td><%=soundTime%><br>(夜间)</td>
			<td>厂界噪声dB(A)</td>
			<td><%=db.roundtofour(sound.getSound_w_night()) %></td>
			<td>≤45</td>
			<td><%=shdb.iSInTostandard(sound.getSound_w_night_mul())%></td>
			<td><%=sound.getSound_w_night_mul() %></td>
			<td><%=sound.getSound_w_night_note() %></td>
		</tr>
		<tr>
		<td>厂区厂界(南)</td>
			<td><%=soundTime%><br>(夜间)</td>
			<td>厂界噪声dB(A)</td>
			<td><%=db.roundtofour(sound.getSound_s_night()) %></td>
			<td>≤45</td>
			<td><%=shdb.iSInTostandard(sound.getSound_s_night_mul())%></td>
			<td><%=sound.getSound_s_night_mul() %></td>
			<td><%=sound.getSound_s_night_note() %></td>
		</tr>
		<tr>
		<td>厂区厂界(北)</td>
			<td><%=soundTime%><br>(夜间)</td>
			<td>厂界噪声dB(A)</td>
			<td><%=db.roundtofour(sound.getSound_n_night()) %></td>
			<td>≤45</td>
			<td><%=shdb.iSInTostandard(sound.getSound_n_night_mul())%></td>
			<td><%=sound.getSound_n_night_mul() %></td>
			<td><%=sound.getSound_n_night_note() %></td>
		</tr>
	</table>
</body>
</html>