EasyUi 中datagrid 实现查询方法

1、在初始化表格方法中增加传入参数，如下：

 //初始化表格
        function initTable(<strong><span >params</span></strong>) {
            $('#test').datagrid({
                title: '客户列表',
                iconCls: 'icon-Custom',
                loadMsg: '数据加载中...',
                nowrap: true,
                autoRowHeight: true,
                striped: true,
                url: '/CustomManager/GetAllCustomInfo',
                sortName: 'CID',
                sortOrder: 'asc',
                border: true,
                remoteSort: false,
                idField: 'CID',
                pageSize: 10,
                pagination: true,
                rownumbers: true,
                <span ><strong>queryParams: params, //搜索json</strong></span>

2、定义按钮点击事件：

//点击查找按钮出发事件
function searchFunc() {
initTable(initQuery());
}

3、获取查询对象，转换为json对象

//表单查询值组成json对象
function initQuery() {
var queryParams = {
ShopName: $('#ShopName').val(),
PerName: $('#PerName').val() //需要查询的对象
};
return queryParams;
}

4、后台datagrid的绑定事件中接收参数，进行查询

public ActionResult GetAllCustomInfo(T_Custom model)
{
int pageIndex = Request["page"] == null ? 1 : int.Parse(Request["page"]);
int pageSize = Request["rows"] == null ? 10 : int.Parse(Request["rows"]);
int total = 0;
var temp = from u in db.T_Custom
select u;

//判断参数 if (!string.IsNullOrEmpty(model.ShopName)) temp = temp.Where(b => b.ShopName.Contains(model.ShopName)); if (!string.IsNullOrEmpty(model.PerName)) temp = temp.Where(b => b.PerName.Contains(model.PerName));