//var dataSource = $("#grid").data("kendoGrid").dataSource;
// //获取过滤条件
//var filters = dataSource.filter();
获取全部表格的数据
//var allData = dataSource.data();
对全部数据进行过滤条件的筛选
//var query = new kendo.data.Query(allData);
在这里进行发送了请求
这里是一个filter的时候
var filter = { };
$.ajax({
url: url3,
dataType: "json",
type: "post",
data: {
FunctionID: window.FunctionID
}
})
.done(function (result2) {
if (result2.IsSuccess && (result2.Data.filter1_value.length > 0 || result2.Data.filter2_value.length > 0)) {
filter = { logic: result2.logic, filters: [] };
var value1 =parseFloat( result2.Data.filter1_value);
var value2 = parseFloat(result2.Data.filter2_value);
if (result2.Data.filter1_value.length > 0) {
filter.filters.push({ field: result2.Data.filter1_name, operator: result2.Data.filter1_operator, value: value1});
}
if (result2.Data.filter2_value.length > 0) {
filter.filters.push({ field: result2.Data.filter2_name, operator: result2.Data.filter2_operator, value: value2 });
}
}
})
其中
filter: filter,//这个是给kendoUI过滤条件
sort:result.Data.columns,//这个是给他进行排序
这里是多个filter的时候
var filterAll = new Array();
if (result2.IsSuccess) {
for (var i = 0; i < result2.Data.length; i++) {
var iInt = 0;
filter = { logic: null, filters: [] };
if (result2.Data[i].filter_value1 != 0) {//第一个值不为0
iInt = iInt + 1;
var field_name = result2.Data[i].field_name;
var filter_operator1 = result2.Data[i].filter_operator1;
var filter_value1 = result2.Data[i].filter_value1;
filter.filters.push({ field: field_name, operator: filter_operator1, value: filter_value1 });
}
if (result2.Data[i].filter_value2 != 0) {//第二个值不为0
iInt = iInt + 1;
var field_name = result2.Data[i].field_name;
var filter_operator2 = result2.Data[i].filter_operator2;
var filter_value2 = result2.Data[i].filter_value2;
filter.filters.push({ field: field_name, operator: filter_operator2, value: result2.Data[i].filter_value2 });
}
if (iInt == 2) {//有两个值的时候用中间连接
filter.logic = result2.Data[i].filter_logic;
}
if (iInt > 0) {//至少有一个值否则不用加到筛选条件集合里面
filterAll.push(filter);
}
}
}