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));
}
