我在使用LigerUI中根据表单查询条件进行查询，使用表格Grid展示时出的问题

[huisheng]

我的代码如下，要实现的是筛选记录。
数据是通过后台得到的。
$(function () {
grid = $("#maingrid").ligerGrid({
columns: [
{ name: 'ID', display: '序号', width: 85 },
{ name: 'UserName', display: '用户名', width: 120 },
{ name: 'RoleName', display: '所属部门', width: 80 },
{ name: 'StateTxt', display: '用户状态', width: 80 }
],
url:'../Sys_User/UserGetData',
sortname: 'ID', pageSize: 20, rownumbers: true,
width: '98%', height: '100%', heightDiff: -10, rowHeight: 28,
where: f_getWhere()
});
});

//过滤属性
function f_getWhere() {
// alert(JSON.stringify(griddata));
if (!grid) return null;

var clause = function (rowdata, rowindex) {
var username = $('#txtKey').val();
var rolename = $('#SSjoblist').val(); //部门
return ((rowdata.UserName.indexOf(username) > -1) || (rowdata.RoleName.indexOf(rolename) > -1) );
};
return clause;
}

function fsearch() {

$.ajax({
url: '../Sys_User/UserGetData',
dataType: 'json',
type: 'POST',
success: function (result) {
if (result.Total > 0) {
griddata = JSON.stringify(result);
alert(JSON.stringify(result));
}
}
});

grid.options.data = $.extend(true, {}, griddata);
grid.loadData(f_getWhere());
}

数据显示是正常的。筛选也没有提示出错，就是输入条件后，和查询前的结果一样的。没有变化。

[huisheng]

你好，你这段代码来源于LigerRmv2的源代码中。。在使用时受到了他的很多限制。

[huisheng]

请高手帮帮我吧。

[hellofurixiang]

---------前台 <div id="mainsearch" style=" width:98%"> <div class="searchtitle"> <span>搜索</span><img src="@Url.Content("~/Content/icons/32X32/searchtool.gif")" /> <div class="togglebtn"></div> </div> <div class="navline" style="margin-bottom:4px; margin-top:4px;"></div> <div class="searchbox"> <form id="formsearch" class="l-form"></form> </div> </div> <div id="maingrid"></div> <script type="text/javascript"> //相对路径 var rootPath = "@Url.Content("~/Admin/")"; var columns=[ { display: "编号", name: "CustomerID", type: "hidden", width: 70, minWidth: 30 }, { display: "会员账号", name: "Username", width: 230, type: "text", align: "Center" }, { display: "机构编号", name: "OrgID", width: 180, type: "text", align: "Center" }, { display: '邮箱', name: 'Email', align: 'Center', width: 250, minWidth: 30, type: 'text' }, { display: "状态", name: "Active", width: 70, type: "text", align: "Center",render: function (row) { var sts = "未知"; if (row.Active == "1") { return "启用"; } else if (row.Active == "0") { return "禁用" } return sts; }}, { display: "是否删除", name: "Deleted", width: 70, type: "text", align: "Center",render: function (row) { var sts = "未知"; if (row.Deleted == "1") { return "是"; } else if (row.Deleted == "0") { return "否" } return sts; }} ]; //列表结构 var grid = $("#maingrid").ligerGrid({ columns: columns, dataAction: 'server', pageSize: 20, toolbar: {}, url: rootPath + 'NopCustomer/GetAllForGrid', sortName: 'CustomerID', width: '98%', height: '100%',heightDiff:-10, checkbox: true }); //双击事件 LG.setGridDoubleClick(grid, 'modify'); $("#formsearch").ligerForm({ fields: [ { display: "会员账号", name: "Username", newline: true, labelWidth: 100, width: 220, space: 30, type: "text", cssClass: "field" }, { display: "机构", name: "OrgID",attr: { op: "equal" }, newline: false, labelWidth: 100, width: 220, space: 30, type: "select", cssClass: "field" , comboboxName:"OrganName",options: {tree:{url :'@Url.Content("~/Admin/OrganCustomer/GetTreeList")', checkbox: false,isExpandCurrent: false, btnClickToToggleOnly: true }, valueFieldID: "OrgID",selectBoxWidth: 250,selectBoxHeight: 200, treeLeafOnly: false }}], appendID: true, toJSON: JSON2.stringify }); //增加搜索按钮,并创建事件 LG.appendSearchButtons("#formsearch", grid); </script> -------后台 [Description("[机构客户]获取用户信息(主页必须)")] [LoginAllowView] public ActionResult GetAllForGrid() { LigerUIGridRequest requestGrid = new LigerUIGridRequest(HttpContext); return this.JsonFormat(service.GetAllCustomers(requestGrid)); } 你开始就写错了，你这样是获取不到数据的，这样些是初始化界面时的条件，$('#txtKey').val()这样是没办法获取到数据的，它是列，attr: { op: "equal" }为查询条件对应的对比符号，点击搜索按钮之后会提交数据到HttpContext，希望能帮到你。

[huisheng]

谢谢。结贴。

[yangziyan126]

griddata = JSON.stringify(result);涉及浏览器兼容问题，IE会出问题