动态搜索是从整个相关数据库中检索,并不是当前数据框中数据
/**comboxGrid数据**/
$('#cg').combogrid({
panelWidth: 360,
idField: 'customer_no', //ID字段
textField: 'meter_no', //显示的字段
url: "<%=contextPath%>/totalPreviewController/getCustMeterInfo_noSecurity?id="+newValue,
fitColumns: true,
striped: true,
editable: true,
pageSize: 10, //每页显示的记录条数,默认为10
pageList: [10, 5, 3], //可以设置每页记录条数的列表
pagination: true, //是否分页
rownumbers: true, //序号
collapsible: false, //是否可折叠的
/* fit: true, */ //自动大小
method: 'post',
columns: [[
{ field: 'customer_no', title: '户号', width: 170},
{ field: 'customer_name', title: '户名', width: 120 },
{ field: 'meter_no', title: '表号', width: 140 }
]],
keyHandler: {
query: function (keyword) { //【动态搜索】处理
//设置查询参数
var queryParams = $('#cg').combogrid("grid").datagrid('options').queryParams;
queryParams.keyword = keyword;
$('#cg').combogrid("grid").datagrid('options').queryParams = queryParams;
//重新加载
$('#cg').combogrid("grid").datagrid("reload");
$('#cg').combogrid("setValue", keyword);
//将查询条件存入隐藏域
$('#hdKeyword').val(keyword);
}
}
});
var getData = function (page, rows) {
$.ajax({
type: "POST",
url: "<%=contextPath%>/totalPreviewController/getCustMeterInfo_noSecurity?id="+newValue,
data: "page=" + page + "&rows=" + rows + "&keyword=" + $('#hdKeyword').val(),
error: function (XMLHttpRequest, textStatus, errorThrown) {
alert(textStatus);
$.messager.progress('close');
},
success: function (data) {
data = JSON.parse(data);
$('#cg').combogrid('grid').datagrid('loadData', data);
}
});
};
}