yxh
/
CNG


			
							123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443
							<%@ 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();
			selectSpcialStation();
			//fLoadData(i,pageSize);
		});
		function fLoadTable(){
				grid=$('#tt').datagrid({
				  fit: true,//自动大小   
					title: '',
					width: '100%',
					height: 580,
					toolbar: '#toolbar',
					fitColumns: true,
					loadMsg:'正在加载, 请稍等 …',
	            	nowrap : true,//设置为true，当数据长度超出列宽时将会自动截取
	            	striped : true,//设置为true将交替显示行背景
					collapsible : false,//显示可折叠按钮
	            	fitColumns:true,//允许表格自动缩放，以适应父容器
	            	rownumbers:true,
	            	pagination:true,//分页控件 
					columns:[[
						{field:'equpState',align:'left',title:'状态',width:40,formatter: function(value, row, index){
    if (value == "0") {
        return '<font style="color:green;font-weight: bold;">'+"正常"+'</font>';
    }
    else if(value == "1") {
        return '<font style="color:red;font-weight: bold;">'+"超期"+'</font>';
    }else{
        return '<font style="color:red;font-weight: bold;">'+"无状态"+'</font>';
    }
}},
						{field:'stationNo',align:'left',title:'站点编号',width:120},
						{field:'stationName',align:'left',title:'站点名称',width:'180px'},
						{field:'equpName',align:'left',title:'设备名称',width:100},
						{field:'equpTypeName',align:'left',title:'设备类别',width:60},
						{field:'equpModel',align:'left',title:'规格型号',width:120},
						{field:'licenseNo',align:'left',title:'使用证编号',width:120},
						{field:'useDate1',align:'left',title:'投用日期',width:120},
						{field:'checkDate1',align:'left',title:'检验日期',width:'160px'},
						{field:'checkUnit',align:'left',title:'检验单位',width:'180px'},
						{field:'checkResult',align:'left',title:'检验结论',width:'120px'},
						{field:'nextCheckDate1',align:'left',title:'下次检验日期',width:'160px'},
						{field:'operDetail',align:'left',title:'操作状态',width:'120px'},
						{field:'editStationNo',align:'left',title:'登记/修改站点',width:'180px'},
						{field:'editOperatorNo',align:'left',title:'登记/修改操作员',width:'120px'},
						{field:'editOperTime1',align:'left',title:'录入时间',width:'160px'},
						{field:'auditStationNo',align:'left',title:'审核站点',width:'120px'},
						{field:'auditOperatorNo',align:'left',title:'审核操作员',width:'120px'},
						{field:'auditOperTime1',align:'left',title:'审核时间',width:'120px'},
						{field:'equpSelfNo',align:'left',title:'设备自编号',width:'120px'},
						{field:'produceDate1',align:'left',title:'出厂日期',width:'120px'},
						{field:'producer',align:'left',title:'生产厂家',width:'120px'},
						{field:'producerLic',align:'left',title:'生产许可证号',width:'120px'},
						{field:'equpRegNo',align:'left',title:'设备注册代码',width:'120px'},
						{field:'timequpParame2',align:'left',title:'设备参数',width:'120px'},
						{field:'checkReport',align:'left',title:'鉴定报告',width:'120px'},
						{field:'time2',align:'left',title:'操作',width:'120px'}
						
					]]
				});	
		}
		function show(message) {  
	            $.messager.show({  
	                title: '提示信息',  
	                msg: message,  
	                timeout: 2000,  
	                showType: 'slide'  
	            });  
	        }
		
		function fLoadData(page,rows){
		if(!$('#specialStation option:selected').text()){
			return false;
		}
		
			    $.messager.progress({ 
			        title: '请等待', 
			        msg: '正在加载数据...', 
			        text: '查询中.......' 
			    }); 
				$.ajax({
					type:"POST",
					contentType: "application/x-www-form-urlencoded; charset=UTF-8",
					data:$('#specialform').serialize(),
					url:"ajax/specialequipmentdataQuery?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();
				selectSpcialStation();
				//changeSize();
		}
		
	function changeSize(){
		fLoadData(1,10);
	}
	function selectSpcialStation(){
			var ii=1;
			var select = document.getElementById("specialStation");
			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:$('#specialform').serialize(),
					url:"ajax/hiddenspeStation?type=2",
					success:function (data){
						var obj=eval("(" + data + ")");
						$.each(obj.rows, function(i,item){   
							select.options.add(new Option(item.name, item.id));
  						});
						      
							
					}
			});
	}
	function selectSpcialStation1(){
			selectSpcialStation();
			//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:$('#specialform').serialize(),
					url:"ajax/specialequipmentdataQuery?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="specialform" action="ajax/special" 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="selectSpcialStation1();" >
						</select>
  		 			</td>
  		 		</tr>
  		 		<tr>
  		 			<td>
  		 				<span class="hzbspan">站点:</span>
  		 			</td>
  		 			<td>
  		 				<select  name="specialStation" id = "specialStation" 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">设备GUID:</span></span></td>
			<td><input type="text" name="equpGuid" id="equpGuid" style="width: 150px;height: 34px;"  class="hzbspan" placeholder="-   -   -   -   -   -   -">
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">设备名称:</span></span></td>
			<td><input type="text"  name="equpName" id="equpName" style="width: 150px;height: 34px;"  class="hzbspan" placeholder="-   -   -   -   -   -   -">
			</td>
			<td><span  style="cursor: default"><span class="hzbspan">设备类别：</span></span></td>
			<td><select  name="equpType" id="equpType" style="width: 150px;height: 34px;" class="hzbspan select">
							<option value="-1" selected="selected">全部</option>
							<option value="1">压力容器</option>
							<option value="2">压力管道</option>
							<option value="3">起重机械</option>
							<option value="4">锅炉</option>
							<option value="5">电梯</option>
							<option value="6">场(厂)内机动车辆</option>
							<option value="7">客运索道</option>
							<option value="8">大型游乐设施</option>
							<option value="9">安全附件</option>
				</select></td>
			<td>
			<span  style="cursor: default"><span class="hzbspan">规格型号：</span></span></td>
			<td><input type="text" name="equpModel" id="equpModel"  style="width: 150px;height: 34px;"  class="hzbspan" placeholder="-   -   -   -   -   -   -">
			</td>			
			</tr><tr>
			<td>
			<span  style="cursor: default"><span class="hzbspan">录入开始时间:</span></span></td>
			<td><input type="text" name="editSDate" id="editSDate" 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="editEDate" id="editEDate" 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="checkSDate" id="checkSDate" 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="checkEDate" id="checkEDate" class="easyui-datebox" style="width: 150px;height: 34px;"  class="hzbspan" data-options="prompt:'-   -   -   -   -   -   -'">
			</td></tr><tr>
			<td>
			<span  style="cursor: default"><span class="hzbspan">下次检验开始日期:</span></span></td>
			<td><input type="text"  name="nextCheckSDate" id="nextCheckSDate"  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="nextCheckEDate" id="nextCheckEDate"   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><select  name="opeState" id="opeState" style="width: 150px;height: 34px;" class="hzbspan select" >
					<option value="-1" selected="selected">全部</option>
					<option value="0">新数据,要求审核</option>
					<option value="1">安装完成,要求监检</option>
					<option value="2">监检完成,要求审核</option>
					<option value="3">检验完成,要求审核或复装</option>
					<option value="4">审核完成</option>
					<option value="5">已经发标签</option>
					<option value="6">数据审核不通过</option>
					<option value="7">检验后数据不通过</option>
					
					<option value="8">过户后审核不通过</option>
					<option value="9">监检不通过</option>
					<option value="10">未发标签</option>
					<option value="21">申请加瓶</option>
					<option value="22">申请减瓶</option>
					<option value="31">过户,要求审核</option>
					<option value="41">已注销</option>
				</select></td>
			<td>
				<span  style="cursor: default"><span class="hzbspan">只查超期数据：</span></span></td>
			<td><input type="checkbox" name="exceedOnly" id="exceedOnly" value="yes" >
			</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>