예제 #1
0
 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);
 }
예제 #2
0
        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());
        }