public string GetFilterExpression(string template, IDataFilterConditionsStore store) { foreach (DataFilterCondition condition in store.Conditions) { if (condition.ConditionType == FilterConditionType.Comparison) { template = template.Replace("__OP__", string.Format("{0}", condition.Operator)); template = template.Replace(string.Format("{0}", condition.Parameter.Name), condition.LeftOperand); } } return(template); }
public string GetFilterExpression(string template, IDataFilterConditionsStore store) { List <SQLDataFilterParameter> parameters = new List <SQLDataFilterParameter>(); foreach (DataFilterCondition condition in store.Conditions) { SQLDataFilterParameter[] conditionParameters = GetParameters(condition); for (int i = 0; i < conditionParameters.Length; i++) { parameters.Add(conditionParameters[i]); } } store.Conditions.Clear(); StringBuilder sb = new StringBuilder(); XmlSerializer s = new XmlSerializer(typeof(List <SQLDataFilterParameter>)); s.Serialize(new StringWriter(sb), parameters); return(sb.ToString()); }