有两种方法可供参考
第一次是只需要显示那些所以直接做了URL
先在 $('#list').datagrid('clearSelections').datagrid('reload', { filter: '' });中写,如果不出现则写在URL中
//显示条件
var tj = '?filter={ "groupOp":"AND", "rules": [{ "field":"myxd", "op":"ne", "data":"null"}], "groups": [] }';
var grid = {
bind: function (winSize) {
$('#list').datagrid({
url: actionURL + tj,
toolbar: '#toolbar',
title: "外加工详细",
iconCls: 'icon icon-list',
width: winSize.width,
height: winSize.height,
nowrap: false, //折行
rownumbers: true, //行号
striped: true, //隔行变色
idField: 'KeyId',//主键
singleSelect: true, //单选
frozenColumns: [[]],
columns: [[//应为宽度不是很需要所以注释了宽度
{ title: '选择', field: 'ck', checkbox: true },//后加进去全选字段数据库里是没有的
{ title: '序号', field: 'KeyId', sortable: true, width: '', hidden: false, editor: { type: 'numberspinner', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '订单号', field: 'orderid', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '后加工厂', field: 'myws', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '下单人', field: 'myxd', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '开单日期', field: 'myxdrq', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '后加工收货人', field: 'mysh', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '交货日期', field: 'myjhrq', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '印刷品名', field: 'yspmc', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '加工尺寸', field: 'mycc', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '加工数量', field: 'mynum', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '单价', field: 'mydj', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '金额', field: 'myysf', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '制作项目', field: 'myzzxm', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '加工备注', field: 'wsjgbz', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } }
]],
onEndEdit: onEndEdit,//结束编辑时函数 这里为了简洁 该函数写在下面
onUnselect: onUnselect,
onLoadSuccess: function (data) {
//alert($('body').data('data70'));
//alert($('body').data('data69'));
},
onCancelEdit: onCancelEdit,//在用户取消编辑一行的时候触发
onSelect: onSelect,//在用户选择一行的时候触发
onClickRow: onClickRow,//在用户点击一行的时候触发
//onAfterEdit: onAfterEdit,//在用户完成编辑一行的时候触发
onDblClickCell: onDblClickCell,//为了程序逻辑清楚函数写在外面
onHeaderContextMenu: function (e, field) {//列菜单实现动态隐藏列
e.preventDefault();
if (!cmenu) {
createColumnMenu();
}
cmenu.menu('show', {
left: e.pageX,
top: e.pageY
});
},
pagination: true,
pageSize: PAGESIZE,
pageList: [20, 40, 50, 100, 200]
});
},
getSelectedRow: function () {
return $('#list').datagrid('getSelected');
},
//显示条件
reload: function () {
//{"groupOp":"AND","rules":[{"field":"unit","op":"cn","data":"昆明"},{"field":"connman","op":"cn","data":"朱光明"}],"groups":[]}
$('#list').datagrid('clearSelections').datagrid('reload', { filter: '' });
}
};
第二次需要添加自定义搜索所以就改了一下,参考了https://blog.csdn.net/wei_lanse/article/details/52985659
var tj = '{ "groupOp":"AND", "rules": [{ "field":"myxd", "op":"ne", "data":"null"}], "groups": [] }';
var grid = {
bind: function (winSize) {
$('#list').datagrid({
url: actionURL,
向后台传递参数
queryParams: {
filter: tj
},
toolbar: '#toolbar',
title: "外加工详细",
iconCls: 'icon icon-list',
width: winSize.width,
height: winSize.height,
nowrap: false, //折行
rownumbers: true, //行号
striped: true, //隔行变色
idField: 'KeyId',//主键
singleSelect: true, //单选
frozenColumns: [[]],
columns: [[//应为宽度不是很需要所以注释了宽度
{ title: '选择', field: 'ck', checkbox: true },//后加进去全选字段数据库里是没有的
{ title: '序号', field: 'KeyId', sortable: true, width: '', hidden: false, editor: { type: 'numberspinner', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '订单号', field: 'orderid', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '后加工厂', field: 'myws', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '下单人', field: 'myxd', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '开单日期', field: 'myxdrq', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '后加工收货人', field: 'mysh', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '交货日期', field: 'myjhrq', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '印刷品名', field: 'yspmc', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '加工尺寸', field: 'mycc', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '加工数量', field: 'mynum', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '单价', field: 'mydj', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '金额', field: 'myysf', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '制作项目', field: 'myzzxm', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } },
{ title: '加工备注', field: 'wsjgbz', sortable: true, width: '', hidden: false, editor: { type: 'textbox', options: { required: false, validType: '', missingMessage: '' } } }
]],
onEndEdit: onEndEdit,//结束编辑时函数 这里为了简洁 该函数写在下面
onUnselect: onUnselect,
onLoadSuccess: function (data) {
//alert($('body').data('data70'));
//alert($('body').data('data69'));
},
onCancelEdit: onCancelEdit,//在用户取消编辑一行的时候触发
onSelect: onSelect,//在用户选择一行的时候触发
onClickRow: onClickRow,//在用户点击一行的时候触发
//onAfterEdit: onAfterEdit,//在用户完成编辑一行的时候触发
onDblClickCell: onDblClickCell,//为了程序逻辑清楚函数写在外面
onHeaderContextMenu: function (e, field) {//列菜单实现动态隐藏列
e.preventDefault();
if (!cmenu) {
createColumnMenu();
}
cmenu.menu('show', {
left: e.pageX,
top: e.pageY
});
},
pagination: true,
pageSize: PAGESIZE,
pageList: [20, 40, 50, 100, 200]
});
},
getSelectedRow: function () {
return $('#list').datagrid('getSelected');
},
//显示条件
reload: function () {
//{"groupOp":"AND","rules":[{"field":"unit","op":"cn","data":"昆明"},{"field":"connman","op":"cn","data":"朱光明"}],"groups":[]}
$('#list').datagrid('clearSelections').datagrid('reload', { filter: '' });
}
};