jqgrid 条件查询

最新推荐文章于 2024-04-30 19:40:07 发布

scscdslt

最新推荐文章于 2024-04-30 19:40:07 发布

阅读量3.7k

点赞数

分类专栏： java

本文链接：https://blog.csdn.net/scscdslt/article/details/78270478

版权

java 专栏收录该内容

18 篇文章 0 订阅

订阅专栏

前台 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");


}