public static string GetWhereClause(JQGrid grid, string filters, string ignoreFilterField) { JavaScriptSerializer javaScriptSerializer = new JavaScriptSerializer(); JsonMultipleSearch jsonMultipleSearch = javaScriptSerializer.Deserialize <JsonMultipleSearch>(filters); string text = ""; foreach (MultipleSearchRule current in jsonMultipleSearch.rules) { if (string.IsNullOrEmpty(current.op)) { continue; } if (!string.IsNullOrWhiteSpace(ignoreFilterField) && current.field == ignoreFilterField) { continue; } Util.SearchArguments args = new Util.SearchArguments { SearchColumn = current.field, SearchString = current.data, SearchOperation = Util.GetSearchOperationFromString(current.op) }; string str = (text.Length > 0) ? (" " + jsonMultipleSearch.groupOp + " ") : ""; text = text + str + Util.ConstructLinqFilterExpression(grid, args); } return(text); }
public static string GetWhereClause(JQGrid grid, string searchField, string searchString, string searchOper) { string text = " && "; string text2 = ""; new Hashtable(); Util.SearchArguments args = new Util.SearchArguments { SearchColumn = searchField, SearchString = searchString, SearchOperation = Util.GetSearchOperationFromString(searchOper) }; string str = (text2.Length > 0) ? text : ""; string str2 = Util.ConstructLinqFilterExpression(grid, args); return(text2 + str + str2); }