yxh
/
CNG


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363
							<%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
<%@ page import="com.runzhixing.tool.Util" %>
<%@ page import="com.runzhixing.bean.CityPlace" %>
<%@ page import="com.runzhixing.bean.CountryPlace" %>
<%@ page import="com.runzhixing.bean.Station" %>
<%@ page import="com.runzhixing.bean.AuthorityRegionPlace" %>
<%@ page import="com.runzhixing.bean.User" %>
<%@ page import="com.runzhixing.constant.Constant" %>
<%
String path = request.getContextPath();
String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";


User user = (User)session.getAttribute(Constant.userMark); 
List<AuthorityRegionPlace> arplist = user.getPrivilegePlaces1();

List<CityPlace> cplist = new ArrayList<CityPlace>();
List<CountryPlace> cyplist = new ArrayList<CountryPlace>();
List<Station> slist = new ArrayList<Station>();
%>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
  <head>
    <base href="<%=basePath%>">
    
    <title>介质质量查询</title>
    
	<meta http-equiv="pragma" content="no-cache">
	<meta http-equiv="cache-control" content="no-cache">
	<meta http-equiv="expires" content="0">    
	<meta http-equiv="keywords" content="keyword1,keyword2,keyword3">
	<meta http-equiv="description" content="This is my page">
	<meta http-equiv="X-UA-Compatible" content="IE=9"/>
	<meta http-equiv="X-UA-Compatible" content="IE=10"/>
	<link rel="stylesheet" type="text/css" href="css/easyui/themes/default/easyui.css">
	<link rel="stylesheet" type="text/css" href="css/easyui/themes/icon.css">
	<link rel="stylesheet" type="text/css" href="css/easyui/demo/demo.css">
	<script type="text/javascript" src="css/easyui/jquery.min.js"></script>
	<script type="text/javascript" src="css/easyui/jquery.easyui.min.js"  charset="utf-8"></script>
	<script type="text/javascript" src="css/easyui/locale/easyui-lang-zh_CN.js"  charset="utf-8"></script>
	<link rel="stylesheet" type="text/css" href="css/common/hzbstyle.css">
	<script type="text/javascript" src="js/common/area.js"></script>
	<style type="text/css">
		 a:HOVER{
			color: red;
			text-decoration: none;
		}
		 a{
			color: #f08300;
			text-decoration: none;
		}
	</style>
	<script type="text/javascript" src="js/easyui/export.js"></script>
	<script type="text/javascript">
		var grid="";
		var exportString="";
	
	
		var i = 1;//第几页
		var sum;//总条数
		var pageSize =10;
		var totalpage;//总页数
		$(document).ready(function(){
			fLoadTable();
			pageSize = $('#pageSize').val();
			
			selectCountry();
			selectstation();
			//fLoadData(i,pageSize);
		});
		function fLoadTable(){
				grid=$('#tt').datagrid({
				  fit: true,//自动大小   
					title: '',
					width: '100%',
					height: 580,
					toolbar: '#toolbar',
					fitColumns: true,
					singleSelect:false,
					loadMsg:'正在加载, 请稍等 …',
	            	nowrap : true,//设置为true，当数据长度超出列宽时将会自动截取
	            	striped : true,//设置为true将交替显示行背景
					collapsible : false,//显示可折叠按钮
					singleSelect:true,//为true时只能选择单行
	            	fitColumns:true,//允许表格自动缩放，以适应父容器
	            	rownumbers:true,
	            	pagination:true,//分页控件 
					columns:[[
						{field:'shst',align:'left',title:'硫化氢标准值',width:'160px'},
						{field:'shexAct',align:'left',title:'硫化氢检测值',width:'160px'},
						{field:'waterStppm',align:'left',title:'水分PPM标准值',width:'160px'},
						{field:'waterStdewPoint',align:'left',title:'水分露点标准值',width:'160px'},
						{field:'waterExppm',align:'left',title:'水分PPM检测值',width:'160px'},
						{field:'waterExdewPoint',align:'left',title:'水分露点检测值',width:'160px'},
						{field:'checker',align:'left',title:'记录人',width:'160px'},
						{field:'checkTime1',align:'left',title:'记录时间',width:'160px'},
						{field:'stationName',align:'left',title:'站点',width:'160px'},
						{field:'opeatorName',align:'left',title:'操作人员',width:'160px'},
						{field:'operTime1',align:'left',title:'录入时间',width:'160px'},
						{field:'remark',align:'left',title:'备注',width:'160px'}
						
					]]
				});	
		}
		

function show(message) {  
	            $.messager.show({  
	                title: '提示信息',  
	                msg: message,  
	                timeout: 2000,  
	                showType: 'slide'  
	            });  
	        }
		function fLoadData(page,rows){
		if(!$('#station option:selected').text()){
			return false;
		}
			    $.messager.progress({ 
			        title: '请等待', 
			        msg: '正在加载数据...', 
			        text: '查询中.......' 
			    }); 
				$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					data:$('#CNGQform').serialize(),
					url:"ajax/CNGQualityQuery?page="+page+"&psize="+rows,
					success:function (data){
							$.messager.progress('close'); 
							var vData = $.parseJSON(data);
							sum = vData.total;
							if(sum==0){
								show("没有查询到相关信息!!!");
							}
							totalpage = Math.ceil(sum/rows);
							$('#tt').datagrid('loadData', vData); //将数据绑定到datagrid   
							var p = $('#tt').datagrid('getPager'); 
							$(p).pagination({ 
						        pageList: [10,20,30,100,200,400],//可以设置每页记录条数的列表 
						        beforePageText: '第',//页数文本框前显示的汉字 
						        afterPageText: '页    共 {pages} 页', 
						        displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录', 
								onSelectPage: function (pageNumber, pageSize) { 
					                fLoadData(pageNumber, pageSize); 
           						 } 
							
							});
											}
				});
	
			
		}
		
		function selectCountry(){
			var id=document.getElementById("city").value;
			var select = document.getElementById("country");
			for(var i=select.options.length-1;i>=0;i--) {
				select.options.remove(i);
			}
			$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					url:"ajax/hiddenCity?cityId="+id,
					success:function (data){
						var obj=eval("(" + data + ")");
						$.each(obj.rows, function(i,item){      
							select.options.add(new Option(item.name, item.id));
  						});
						      
							
					}
			});
		}
		
		function selectCountry1(){
				selectCountry();
				//selectstation();
				//changeSize();
		}
		
	function changeSize(){
		fLoadData(1,10);
	}
	
	function selectstation(){
			var ii=1;
			var id=document.getElementById("country").value;
			var select = document.getElementById("station");
			for(var i=select.options.length-1;i>=0;i--) {
				select.options.remove(i);
			}
			$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					data:$('#CNGQform').serialize(),
					url:"ajax/hiddenCNGStation?cityId="+id,
					success:function (data){
						var obj=eval("(" + data + ")");
						$.each(obj.rows, function(i,item){   
							   
							select.options.add(new Option(item.name, item.id));
  						});
						      
							
					}
			});
	}
		function selectstation1(){
			selectstation();
			//changeSize();
	}
	function expt1(){
		expt(grid);
	}
	function exptSingle(){
		if(!grid){
			alert("数据为空");
			return false;
		}else{
			expt(grid);
		}
		
	}
	function exptAll(){
		fLoadDataAll(1,5000);
	}
	
	function fLoadDataAll(page,rows){
			
				document.getElementById("pageNumber").innerText = i;
				document.getElementById("from").innerText = (page-1)*rows;
				document.getElementById("to").innerText = page*rows;
			    $.messager.progress({ 
			        title: '请等待', 
			        msg: '正在加载数据...', 
			        text: '查询中.......' 
			    }); 
				$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					data:$('#CNGQform').serialize(),
					url:"ajax/CNGQualityQuery?page="+page+"&psize="+rows,
					success:function (data){
							$.messager.progress('close'); 
							var vData = $.parseJSON(data);
							sum = vData.total;
							if(sum==0){
								show("没有查询到相关信息!!!");
							}
							totalpage = Math.ceil(sum/rows);
							document.getElementById("total").innerText = sum;
							document.getElementById("totalpage").innerText = totalpage;
							var vData = $.parseJSON(data);
							$('#tt').datagrid('loadData', vData); //将数据绑定到datagrid   
							var p = $('#tt').datagrid('getPager'); 
							$(p).pagination({ 
						        pageList: [10,20,30,100,200,400],//可以设置每页记录条数的列表 
						        beforePageText: '第',//页数文本框前显示的汉字 
						        afterPageText: '页    共 {pages} 页', 
						        displayMsg: '当前显示 {from} - {to} 条记录   共 {total} 条记录', 
								onSelectPage: function (pageNumber, pageSize) { 
					                fLoadData(pageNumber, pageSize); 
           						 } 
							
							});
							if(!grid){
			alert("数据为空");
			return false;
		}else{
			expt(grid);
		}
											}
				});
	
			
		}
	
	
	</script>
	
  </head>
  
  <body>
    <!-- 查询结果：数据表格 -->
  	<table id="tt"  cellspacing="0" cellpadding="0" >
	</table>
	<div id="toolbar" style="padding-top: 0px;height: auto;">
	
  		  <form id="CNGQform" action="ajax/CNGQ" method="post">
  		 	<table>
  		 		<tr>
  		 			<td>
  		 				<span class="hzbspan">省:</span>
  		 			</td>
  		 			<td>
  		 				<select  name="province" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select">
							<%for(AuthorityRegionPlace arp:arplist){
								cplist = arp.getCityPlace();
							 %>
								<option value="<%=arp.getId() %>">
									<%=arp.getName() %>
								</option>
							<%} %>
						</select>
  		 			</td>
  		 			<td>
  		 				<span class="hzbspan">市:</span>
  		 			</td>
  		 			<td>
  		 				<select  name="city" id="city" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select" onchange="selectCountry1()">
				
							<%
								
								for(CityPlace cp:cplist){
								cyplist = cp.getSubPlaceList();
							%>		
								
								<option value="<%=cp.getId() %>">
									<%=cp.getName() %>
								</option>
								
							 
							<%} %>
						</select>
  		 			</td>
  		 			<td>
  		 				<span class="hzbspan">县:</span>
  		 			</td>
  		 			<td>
  		 				<select  name="country" id = "country" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select"  onchange="selectstation1();" >
						</select>
  		 			</td>
  		 		</tr>
  		 		<tr>
  		 			<td>
  		 				<span class="hzbspan">站点:</span>
  		 			</td>
  		 			<td>
  		 				<select  name="station" id = "station" style="width: 150px;height: 34px;min-width: 100px;" class="hzbspan select"  >
							<option value="">全部</option>
						</select>
  		 			</td>
  		 		</tr>
			<tr>
			<td>
			<span  style="cursor: default"><span class="hzbspan">开始时间:</span></span></td>
			<td><input type="text" name="startTime"  class="easyui-datebox" style="width: 150px;height: 34px;"  class="hzbspan" data-options="prompt:'-   -   -   -   -   -   -'">
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">结束时间:</span></span></td>
			<td><input type="text" name="endTime" class="easyui-datebox" style="width: 150px;height: 34px;"  class="hzbspan" data-options="prompt:'-   -   -   -   -   -   -'">
			
			</td>
			<td>
			<a id="btninfosearch" onclick="changeSize();" class="easyui-linkbutton" icon="icon-search" href="javascript:void(0)" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">查询</span></a> 
			<a id="btninfosearch" onclick="exptSingle();" class="easyui-linkbutton" icon="icon-save" href="javascript:void(0)" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">导出</span></a> 
		</td></tr></table>
		</form>	
	</div>
	<div id="dialog2"></div> 
  </body>
</html>