public void AddCriterion(Criterion criterion) { _criterions.Add(criterion); }
/// <summary> /// 通过FuzzyCriterion生成WHERE语句后的判断字符串 /// </summary> /// <param name="criterion"></param> /// <returns></returns> public static string GetFuzzyStringFromCriterion(Criterion criterion) { return(String.Format("[{0}] LIKE '{1}'", criterion.FieldName, criterion.ParameterValue)); }
/// <summary> /// 通过Criterion生成WHERE语句后的判断字符串 /// </summary> /// <param name="criterion"></param> /// <returns></returns> public static string GetStringFromCriterion(Criterion criterion) { return String.Format("[{0}]{1}@{2}", criterion.FieldName, GetStringFromCriteriaOperater(criterion.CriteriaOperator), criterion.ParameterName); }
/// <summary> /// 通过FuzzyCriterion生成WHERE语句后的判断字符串 /// </summary> /// <param name="criterion"></param> /// <returns></returns> public static string GetFuzzyStringFromCriterion(Criterion criterion) { return String.Format("[{0}] LIKE '{1}'", criterion.FieldName, criterion.ParameterValue); }
/// <summary> /// 通过NULLCriterion生成WHERE语句后的判断字符串 /// </summary> /// <param name="criterion"></param> /// <returns></returns> public static string GetStringFromNULLCriterion(Criterion criterion) { return(String.Format("[{0}] IS NULL", criterion.FieldName)); }