AdvQueryItem GetQueryItem()
{
AdvQueryItem item = new AdvQueryItem
{
Name = "test1",
ModelName = typeof(TestLinqModel).AssemblyQualifiedName,
Nodes = new List <AdvQueryNode>()
{
new AdvQueryNode {
Id = 1, ParentId = 0, Expression = "AND", Type = "Operator"
},
new AdvQueryNode {
Id = 2, ParentId = 1, Type = "Expr", Expression = "Field1", Operator = ">", Value = "100"
},
new AdvQueryNode {
Id = 3, ParentId = 1, Type = "Expr", Expression = "Field2", Operator = "NOT LIKE", Value = "bc"
},
new AdvQueryNode {
Id = 4, ParentId = 1, Expression = "OR", Type = "Operator"
},
new AdvQueryNode {
Id = 5, ParentId = 4, Type = "Expr", Expression = "Field3", Operator = "=", Value = "2016-03-04"
},
new AdvQueryNode {
Id = 6, ParentId = 4, Type = "Expr", Expression = "Field3", Operator = "=", Value = "2016-03-06"
},
}
};
return(item);
}
public ActionResult SaveQueryItem(AdvQueryItem item)
{
item.Nodes = JsonHelper.FromJson <List <AdvQueryNode> >(Request.Form["Nodes"]) ?? new List <AdvQueryNode>();
_queryMgr.Save(item);
return(JsonTipsLang("success", "Query_Saved_Success", item.Id));
}
