jqgrid 条件查询

来源：互联网发布：gh0st源码分析编辑：程序博客网时间：2024/06/06 01:31

前台 js

$("#table_list_2").jqGrid({    url:path+"/gethistoryAlarm",    datatype:"json",    height:450,    autowidth:true,    shrinkToFit:true,    rowNum:15,    colNames:["序号","端站","报警参数","报警类型","报警值","报警时间","备注"],    colModel:[        {name:"id",index:"" + "",editable:true,width:60,sorttype:"int",search:true},        {name:"rtuName",index:"rtuName",editable:true,width:90,sorttype:"date"},        {name:"csName",index:"csName",editable:true,width:100},        {name:"warnTypeName",index:"warnTypeName",editable:true,width:80,sorttype:"float"},        {name:"value",index:"value",editable:true,width:80,sorttype:"float"},        {name:"alarmTime",index:"alarmTime",editable:true,width:80,sorttype:"float"},        {name:"note",index:"note",editable:true,width:100,sortable:false}    ],    postData:{'queryTime':time,'rtuId':rtuId},    pager:"#pager_list_2",    viewrecords:true,    add:true,    edit:true,    addtext:"Add",    edittext:"Edit",    hidegrid:false});$("#table_list_2").setSelection(4,true);$("#table_list_2").jqGrid("navGrid","#pager_list_2",{        edit:true,        add:true,del:true,search:true},    {        height:50,        reloadAfterSubmit:true    });     $(window).bind("resize",function(){    var width=$(".jqGrid_wrapper").width();    $("#table_list_2").setGridWidth(width)})

其中：条件参数 post Data即为后台可获取参数传参， request.getParam()获取即可

查询按钮 click只需要调用如下js即可:

function queryHistoryAlarm(){    $("#table_list_2").jqGrid('setGridParam',{        datatype:'json',        postData:{'queryTime':time,'rtuId':rtuId},        page:1    }).trigger("reloadGrid");}

后台获取的参数条件查询只需要根据传参即可获取具体数据

我用的maybatis 用动态sql就可以了很方便

阅读全文

0 0