| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216 |
- <%@ page language="java" import="java.util.*" pageEncoding="UTF-8"%>
- <%
- String path = request.getContextPath();
- String basePath = request.getScheme()+"://"+request.getServerName()+":"+request.getServerPort()+path+"/";
- %>
- <!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">
- var hiddenP='<%=(String)session.getAttribute("hiddenphone") %>';
- var i = 1;//第几页
- var sum;//总条数
- var totalpage;//总页数
- $(document).ready(function(){
- fLoadTable();
- fLoadData(1,10);
- });
- function fLoadTable(){
- $('#tt').datagrid({
- fit: true,//自动大小
- title: '参数表',
- width: '100%',
- height: 580,
- fitColumns: true,
- singleSelect:false,
- loadMsg:'正在加载, 请稍等 …',
- nowrap : true,//设置为true，当数据长度超出列宽时将会自动截取
- striped : true,//设置为true将交替显示行背景
- collapsible : true,//显示可折叠按钮
- singleSelect:true,//为true时只能选择单行
- fitColumns:true,//允许表格自动缩放，以适应父容器
- rownumbers:true,
- frozenColumns:[[ //选择框
- {field:'ck',checkbox:true}
- ]],
- columns:[[
- {field:'districtName',title:'所属地区',width:'7%'},
- {field:'carNo',title:'车牌号',width:'7%'},
- {field:'regNo',title:'使用登记证',width:'7%'},
- {field:'installNum',title:'安装气瓶数量',width:'7%'},
- {field:'manaUnitName',title:'发证单位',width:'7%'},
- {field:'regTime',title:'发证时间',width:'7%'},
- {field:'appTypeName',title:'应用类型',width:'7%'},
- {field:'time2',title:'厂牌型号',width:'7%'},
- {field:'carUnit',title:'所属单位',width:'7%'},
- {field:'carUnitMana',title:'负责人',width:'7%'},
- {field:'time2',title:'单位电话',width:'7%'},
- {field:'carOwnerName',title:'车主姓名',width:'7%'},
- {field:'phone',title:'联系电话',width:'7%'},
- {field:'post',title:'邮编',width:'7%'},
- {field:'addr',title:'联系地址',width:'7%'},
- {field:'engineNo',title:'发动机号',width:'7%'},
- {field:'carUnit',title:'车架号',width:'7%'},
- {field:'carProduct',title:'汽车厂家',width:'7%'},
- {field:'carName',title:'汽车名称',width:'7%'},
- {field:'time2',title:'设置黑名单',width:'7%'}
-
- ]]
- });
- if(hiddenP!="0"){
- $('#tt').datagrid('hideColumn','phone');
- $('#tt').datagrid('hideColumn','time2');
- }
- }
- function fLoadData(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",
- url:"ajax/carsDataQuery1",
- success:function (data){
- $.messager.progress('close');
- var vData = $.parseJSON(data);
- sum = vData.total;
- totalpage = Math.ceil(sum/rows);
- document.getElementById("total").innerText = sum;
- document.getElementById("totalpage").innerText = totalpage;
- $('#tt').datagrid('loadData', vData); //将数据绑定到datagrid
- $('#pp').pagination({
- total:sum,
- pageList: [2,10,50,100],
- beforePageText: '第',//页数文本框前显示的汉字
- afterPageText: '页 共 {pages} 页',
- displayMsg: '当前显示 {from} - {to} 条记录 共 {total} 条记录',
- onSelectPage:function(pageNumber, pageSize){
- fLoadData();
- }
-
-
- });
- }
- });
-
-
- }
- </script>
-
- <script language="JavaScript">
- var subcat = new Array();
- subcat[0] = new Array('中文','英语','英语')
- subcat[1] = new Array('中文','法语','法语')
- subcat[2] = new Array('英语','中文','中文')
- subcat[3] = new Array('法语','中文','中文')
- function changeselect1(locationid)
- {
- document.form1.s2.length = 0; //初始化下拉列表 清空下拉数据
- document.form1.s2.options[0] = new Option('==请选择==',''); //给第一个值
- for (i=0; i<subcat.length; i++) //legth=20
- {
- if (subcat[i][0] == locationid) //[0] [1] 第一列 第二列
- {document.form1.s2.options[document.form1.s2.length] = new Option(subcat[i][1], subcat[i][2]);} //建立option
- //第一次 length=1 因为有==请选择==
- //i=9时 length= 10 值有11个 因为从0数起 subcat[i][0] == locationid屏蔽了再写
- }
- }
- </script>
- </head>
-
- <body>
- <!-- 查询结果：数据表格 -->
- <table id="tt" cellspacing="0" cellpadding="0" >
- </table>
- <div id="" style="background:#efefef;width:100%; border:1px solid #ccc;position: absolute;bottom: 0px;float: left;">
- <!--<input type="text" id="pageNumber">-->
- <div style="float: left;text-align: left;padding-left: 20px;">
- <span class="hzbspan">第</span><span id="pageNumber" class="hzbspan"></span><span class="hzbspan">页 共</span><span class="hzbspan" id="totalpage"></span><span class="hzbspan">页 </span>
- <select onchange="changeSize();" id="pageSize">
- <option value="5">5</option>
- <option value="10" selected="selected">10</option>
- <option value="20">20</option>
- <option value="30">30</option>
- </select>
- <a id="prepage" class="easyui-linkbutton easyui-tooltip" title="上一页" data-options="iconCls:'icon-undo',plain:true" ></a>
- <input type="text" id="selectpage" style="width: 30px;" onchange="selectpage();"/>
- <a id="nextpage" class="easyui-linkbutton easyui-tooltip" title="下一页" data-options="iconCls:'icon-redo',plain:true" ></a>
- </div>
- <div style="float: left;text-align: right;position: absolute;right: 20px;padding-top: 2px" ><span class="hzbspan">当前显示</span><span class="hzbspan" id="from"></span>-<span class="hzbspan" id="to"></span><span class="hzbspan"> 记录 共</span><span class="hzbspan" id ="total"></span><span class="hzbspan">条记录</span></div>
- </div>
- <div id="toolbar" style="padding-top: 10px;height: auto;">
-
- <form name="form1" method="post" runat="server">
- <span class="easyui-linkbutton" style="cursor: default;margin-bottom: 5px;"><span class="hzbspan" style="color: #f08300;font-size: 16px;" >查询条件:</span></span>
- <span class="hzbspan">车辆所属城市：</span>
- <select name="s1" onChange="changeselect1(this.value)" style="width: 100px;height: 24px;" class="hzbspan">
- <option>==请选择==</option>
- <option value="中文">中文</option>
- <option value="英语">英语</option>
- <option value="英语">法语</option>
- </select>
- <span class="hzbspan">车辆所属县：</span>
- <select name="s2" style="width: 100px;height: 24px;" class="hzbspan">
- <option>==请选择==</option>
- </select>
- <br/>
-
-
-
- <span style="cursor: default"><span class="hzbspan">车牌号: </span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
-
- <span style="cursor: default"><span class="hzbspan">车主: </span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
- <span style="cursor: default"><span class="hzbspan">使用登记证号:</span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
-
-
- <span style="cursor: default"><span class="hzbspan">发证开始时间：</span></span> <input type="text" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">
-
- <br/>
-
-
-
-
- <span style="cursor: default"><span class="hzbspan">发动机号： </span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
- <span style="cursor: default"><span class="hzbspan">车架号: </span></span> <input type="text" style="width: 100px;height: 24px;" class="hzbspan">
-
- <span style="cursor: default"><span class="hzbspan">应用类型： </span></span> <select name="address" style="width: 100px;height: 24px;" class="hzbspan">
- <option>全部</option>
- <option>成都市</option>
- <option>全部</option>
- <option>全部</option>
- <option>全部</option>
- </select>
- <span style="cursor: default"><span class="hzbspan">发证结束时间：</span></span> <input type="text" class="easyui-datebox" style="width: 100px;height: 24px;" class="hzbspan">
-
-
-
- <a id="btninfosearch" class="easyui-linkbutton" icon="icon-search" href="javascript:void(0)" style="margin-bottom: 5px;" ><span class="hzbspan" style="color: #f08300;font-size: 16px;">查 询 </span></a>
- </form>
- </div>
- </body>
- </html>
|
