如何反序列化的jqGrid中的ASP.NET MVC2多组搜索条件 [英] how to deserialize jqgrid multiple group search criteria in asp .net mvc2
问题描述
如果使用多个分组,jqGrid的高级搜索可以产生像
搜索条件<$p$p><$c$c>{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[{\"groupOp\":\"AND\",\"rules\":[{\"field\":\"Nimi\",\"op\":\"cn\",\"data\":\"kk\"},{\"field\":\"Nimi\",\"op\":\"cn\",\"data\":\"kkk\"}],\"groups\":[]}]}尝试使用反序列化它ASP .NET MVC2
VAR串=新的JavaScriptSerializer();
VAR filtersList = serializer.Deserialize&LT;滤光器&gt;(_过滤器);
类Filter
{
公共GroupOp groupOp {搞定;组; }
公开名单&LT;规则&GT;规则{搞定;组; }
公开名单&LT;滤光器&gt;组{搞定;组; }
}阶级统治
{
公共字符串域{搞定;组; }
公共运算Op {搞定;组; }
公共字符串数据{搞定;组; }
}枚举GroupOp
{
和,
要么
}枚举操作
{
EQ,//平等
NE,//不等于
LT,//少
乐//小于或等于
GT,//大
GE,//大于或等于
体重,//开头
BN,//开头不是
@In,//,在
妮,//不
EW,//结尾
恩,//不是结束
CN,//包含
NC //不包含
}
返回空filtersList.rules财产
如何从这些数据中得到正确的规则是什么?
更新
过滤器
{groupOp:和,规则:[{场:Nimi敬上,运:CN,数据:} ,
{场:Nimi敬上,运:CN,数据:},{场:Nimi敬上,运:CN,数据:}] ,
组:[{groupOp:和,规则:[],组:[]},{groupOp:和,规则:
[{场:Nimi敬上,运:CN,数据:}],组:[{groupOp:和,规则:[],
\"groups\":[{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[]},{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[{\"groupOp\":\"AND\",\"rules\":[],
\"groups\":[{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[]},{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[]}]}]}]}]},{\"groupOp\":\"AND\",\"rules\":[{\"field\":\"Nimi\",\"op\":\"cn\",\"data\":\"\"}],\"groups\":[{\"groupOp\":\"AND\",\"rules\":[{\"field\":\"Nimi\",\"op\":\"cn\",\"data\":\"\"},{\"field\":\"Nimi\",\"op\":\"cn\",\"data\":\"\"}],
\"groups\":[]}]},{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[]},{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[]},{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[]},{\"groupOp\":\"AND\",\"rules\":[],\"groups\":[]}]}]}]}
使用从参考答案更新部分
code仍然会产生无效的其中
((klient.Nimi ILIKE('%'|| E''||'%')ESCAPE'!')和(klient.Nimi ILIKE
('%'|| E''||'%')ESCAPE'!')和(klient.Nimi ILIKE('%'|| E''||'%')ESCAPE'!'))AND
((((klient.Nimi ILIKE('%'|| E''||'%')ESCAPE'!'))AND(((((())))AND(((klient.Nimi ILIKE(' %'|| E''||'%')ESCAPE'!'))AND(((klient.Nimi ILIKE('%'|| E''||'%')ESCAPE'!')
AND(klient.Nimi ILIKE('%'|| E''||'%')ESCAPE'!'))))))))
我看不出有任何问题,即code
常量字符串过滤器={\\groupOp \\:\\和\\,\\规则\\:[],+
\\组\\:[{\\groupOp \\:\\和\\,\\规则\\:+
{\\字段\\:\\Nimi敬上\\,\\OP \\:\\CN \\,\\DATA \\:\\KK \\},+
{\\字段\\:\\Nimi敬上\\,\\OP \\:\\CN \\,\\DATA \\:\\KKK \\}],\\组\\:[]}] };VAR串行=新的JavaScriptSerializer();
VAR filtersList = serializer.Deserialize&LT;滤光器&gt;(过滤器);
产生 filtersList
,其中 filtersList.rules
是空列表。它对应于您有输入的数据。在另一边的 filtersList.groups
部分是不是空的。在 filtersList
从上面的code会产生过滤器
对象,它等同于以下直接初始化:
VAR filtersList =新的过滤器{
groupOp = GroupOp.AND,
规则=新的List&LT;规则&GT;(0)
组=新的List&LT;滤光器&gt; {
新的过滤器{
groupOp = GroupOp.AND,
规则=新的List&LT;规则&GT; {
新规则{字段=Nimi敬上,OP = Operations.cn,数据=KK},
新规则{字段=Nimi敬上,OP = Operations.cn,数据=KKK}
},
组=新的List&LT;滤光器&gt;(0)
}
}
};
如果一个人解析从信息 filtersList
可以得到在年底仍是 WHERE
语句类似如下
(Nimi敬上LIKE'%KK%')和(Nimi敬上LIKE'%KKK%')
例如答案的code。要准确地从答案code产生((Nimi敬上LIKE'%KK%')和(Nimi敬上LIKE'%KKK%'))
这实际上是在一样的。
If multiple grouping is used, jqgrid advanced search can generate search criteria like
{"groupOp":"AND","rules":[],"groups":[{"groupOp":"AND","rules":[{"field":"Nimi","op":"cn","data":"kk"},{"field":"Nimi","op":"cn","data":"kkk"}],"groups":[]}]}
Trying to de-serialize it in ASP .NET MVC2 using
var serializer = new JavaScriptSerializer();
var filtersList = serializer.Deserialize<Filter>(_filters);
class Filter
{
public GroupOp groupOp { get; set; }
public List<Rule> rules { get; set; }
public List<Filter> groups { get; set; }
}
class Rule
{
public string field { get; set; }
public Operations op { get; set; }
public string data { get; set; }
}
enum GroupOp
{
AND,
OR
}
enum Operations
{
eq, // "equal"
ne, // "not equal"
lt, // "less"
le, // "less or equal"
gt, // "greater"
ge, // "greater or equal"
bw, // "begins with"
bn, // "does not begin with"
@in, // "in"
ni, // "not in"
ew, // "ends with"
en, // "does not end with"
cn, // "contains"
nc // "does not contain"
}
returns empty filtersList.rules property
How to get correct rules from this data ?
update
filter
{"groupOp":"AND","rules":[{"field":"Nimi","op":"cn","data":""},
{"field":"Nimi","op":"cn","data":""},{"field":"Nimi","op":"cn","data":""}],
"groups":[{"groupOp":"AND","rules":[],"groups":[]},{"groupOp":"AND","rules":
[{"field":"Nimi","op":"cn","data":""}],"groups":[{"groupOp":"AND","rules":[],
"groups":[{"groupOp":"AND","rules":[],"groups":[]},{"groupOp":"AND","rules":[],"groups":[{"groupOp":"AND","rules":[],"groups":[{"groupOp":"AND","rules":[],
"groups":[{"groupOp":"AND","rules":[],"groups":[{"groupOp":"AND","rules":[],"groups":[]},{"groupOp":"AND","rules":[],"groups":[]}]}]}]}]},{"groupOp":"AND","rules":[{"field":"Nimi","op":"cn","data":""}],"groups":[{"groupOp":"AND","rules":[{"field":"Nimi","op":"cn","data":""},{"field":"Nimi","op":"cn","data":""}],
"groups":[]}]},{"groupOp":"AND","rules":[],"groups":[]},{"groupOp":"AND","rules":[],"groups":[]},{"groupOp":"AND","rules":[],"groups":[]},{"groupOp":"AND","rules":[],"groups":[]}]}]}]}
using code from updated part in referenced answer still generates invalid where
((klient.Nimi ILIKE ('%' || E'' || '%') ESCAPE '!')AND(klient.Nimi ILIKE
('%' || E'' || '%') ESCAPE '!')AND(klient.Nimi ILIKE ('%' || E'' || '%') ESCAPE '!'))AND
((((klient.Nimi ILIKE ('%' || E'' || '%') ESCAPE '!'))AND(((((())))AND(((klient.Nimi ILIKE ('%' || E'' || '%') ESCAPE '!'))AND(((klient.Nimi ILIKE ('%' || E'' || '%') ESCAPE '!')
AND(klient.Nimi ILIKE ('%' || E'' || '%') ESCAPE '!'))))))))
I see no problem that the code
const string filters = "{\"groupOp\":\"AND\",\"rules\":[]," +
"\"groups\":[{\"groupOp\":\"AND\",\"rules\":[" +
"{\"field\":\"Nimi\",\"op\":\"cn\",\"data\":\"kk\"}," +
"{\"field\":\"Nimi\",\"op\":\"cn\",\"data\":\"kkk\"}],\"groups\":[]}]}";
var serializer = new JavaScriptSerializer();
var filtersList = serializer.Deserialize<Filter>(filters);
produce the filtersList
where filtersList.rules
is empty list. It corresponds to the input data which you has. On the other side the filtersList.groups
part is not empty. The filtersList
from the above code will produce the Filter
object which equivalent to the following direct initializing:
var filtersList = new Filter {
groupOp = GroupOp.AND,
rules = new List<Rule>(0),
groups = new List<Filter> {
new Filter {
groupOp = GroupOp.AND,
rules = new List<Rule> {
new Rule {field = "Nimi", op = Operations.cn, data = "kk"},
new Rule {field = "Nimi", op = Operations.cn, data = "kkk"}
},
groups = new List<Filter>(0)
}
}
};
If one parse the information from the filtersList
one can get at the end still the WHERE
statement like the following
(Nimi LIKE '%kk%') AND (Nimi LIKE '%kkk%')
see the code of UPDATED part of the answer for example. To be exactly the code from the answer produces ((Nimi LIKE '%kk%')AND(Nimi LIKE '%kkk%'))
which is practically the same.
这篇关于如何反序列化的jqGrid中的ASP.NET MVC2多组搜索条件的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!