5.0.5.1 新功能优化 无限树型条件 返回
SqlSugar
老数据
5
4243
fate sta 发布于2021/12/26
悬赏：0 飞吻
无限树型过滤查询
Key表示操作方式 ：And=0, Or=1 , Null=-1
[{
"ConditionalList": [{
"Key": -1,
"Value": {
"FieldName": "name",
"FieldValue": "name",
"ConditionalType": 0
}
}, {
"Key": 0,
"Value": {
"ConditionalList": [{
"Key": -1,
"Value": {
"FieldName": "customid",
"FieldValue": "1",
"ConditionalType": 0
}
}, {
"Key": 1,
"Value": {
"FieldName": "id",
"FieldValue": "1",
"ConditionalType": 0
}
}, {
"Key": 1,
"Value": {
"ConditionalList": [{
"Key": -1,
"Value": {
"FieldName": "customid",
"FieldValue": "1",
"ConditionalType": 0
}
}]
}
}]
}
}, {
"Key": 0,
"Value": {
"FieldName": "id",
"FieldValue": "2",
"ConditionalType": 0
}
}]
}]生成SQL:
WHERE ( [name] = @Conditname10002 AND( [customid] = @Conditcustomid10001 OR [id] = @Conditid20001 OR( [customid] = @Conditcustomid10000 ) ) AND [id] = @Conditid30002 )
热忱回答（5）
-
fate sta VIP0
2021/12/26[{ "ConditionalList": [{ "Key": -1, "Value": { "FieldName": "name", "FieldValue": "name", "ConditionalType": 0 } }, { "Key": 0, "Value": { "ConditionalList": [{ "Key": -1, "Value": { "FieldName": "customid", "FieldValue": "1", "ConditionalType": 0 } }, { "Key": 0, "Value": { "FieldName": "id", "FieldValue": "1", "ConditionalType": 0 } }, { "Key": 1, "Value": { "ConditionalList": [{ "Key": -1, "Value": { "FieldName": "customid", "FieldValue": "1", "ConditionalType": 0 } }] } }] } }, { "Key": 1, "Value": { "FieldName": "id", "FieldValue": "2", "ConditionalType": 0 } }] }]WHERE ( [name] = @Conditname10002 AND( [customid] = @Conditcustomid10001 AND [id] = @Conditid20001 OR( [customid] = @Conditcustomid10000 ) ) OR [id] = @Conditid30002 )
Key表示操作方式 ：And=0, Or=1 , Null=-1
0 回复 -
fate sta VIP0
2021/12/26
var conModels= db.Context.Utilities.JsonToConditionalModels(json) //JSO转成 List<IConditionalModel> var list = db.Queryable<Order>().Where(conModels).ToList();
0 回复 -
whwch VIP0
2025/6/29请问遇到布尔值，json应该怎么处理呢
0 回复 -
whwch VIP0
2025/6/29
@whwch：
我测试
"FieldName":"id","FieldValue": 1,"ConditionalType": 0或者"FieldName":"id","FieldValue": false,"ConditionalType": 0这样都不行呢
0 回复 -
fate sta VIP0
2025/6/29
{"FieldName":"id","ConditionalType":"0","FieldValue":"1","CSharpTypeName":"int" }
需要设置CSharpTypeName
0 回复