public static string GetExpression(DateFilterDescriptor dateTimeFilterDescriptor)
{
if (!dateTimeFilterDescriptor.IgnoreTimePart)
{
return(FilterDescriptor.GetExpression((FilterDescriptor)dateTimeFilterDescriptor));
}
if (string.IsNullOrEmpty(dateTimeFilterDescriptor.PropertyName) || dateTimeFilterDescriptor.Operator == FilterOperator.None || dateTimeFilterDescriptor.Operator != FilterOperator.IsNotNull && dateTimeFilterDescriptor.Operator != FilterOperator.IsNull && !dateTimeFilterDescriptor.Value.HasValue)
{
return(string.Empty);
}
string str1 = (string)null;
string str2 = (string)null;
string str3 = DataStorageHelper.EscapeName(dateTimeFilterDescriptor.PropertyName);
if (dateTimeFilterDescriptor.Value.HasValue)
{
str1 = string.Format((IFormatProvider)CultureInfo.InvariantCulture, "#{0}#", (object)dateTimeFilterDescriptor.Value.Value.Date);
str2 = string.Format((IFormatProvider)CultureInfo.InvariantCulture, "#{0}#", (object)dateTimeFilterDescriptor.Value.Value.Date.AddDays(1.0));
}
switch (dateTimeFilterDescriptor.Operator)
{
case FilterOperator.None:
return(string.Empty);
case FilterOperator.IsLike:
case FilterOperator.IsEqualTo:
return(string.Format("{0} >= {1} AND {0} < {2}", (object)str3, (object)str1, (object)str2));
case FilterOperator.IsNotLike:
case FilterOperator.IsNotEqualTo:
return(string.Format("{0} < {1} OR {0} >= {2}", (object)str3, (object)str1, (object)str2));
case FilterOperator.IsLessThan:
return(string.Format("{0} < {1}", (object)str3, (object)str1));
case FilterOperator.IsLessThanOrEqualTo:
return(string.Format("{0} < {1}", (object)str3, (object)str2));
case FilterOperator.IsGreaterThanOrEqualTo:
return(string.Format("{0} >= {1}", (object)str3, (object)str1));
case FilterOperator.IsGreaterThan:
return(string.Format("{0} >= {1}", (object)str3, (object)str2));
case FilterOperator.IsNull:
return(string.Format("{0} IS NULL", (object)str3));
case FilterOperator.IsNotNull:
return(string.Format("NOT ({0} IS NULL)", (object)str3));
default:
return(string.Empty);
}
}
/// <summary>
/// Gets the expression.
/// </summary>
/// <param name="dateTimeFilterDescriptor">The filter descriptor.</param>
/// <returns></returns>
public static string GetExpression(DateFilterDescriptor dateTimeFilterDescriptor)
{
if (dateTimeFilterDescriptor.IgnoreTimePart)
{
if (String.IsNullOrEmpty(dateTimeFilterDescriptor.PropertyName) ||
dateTimeFilterDescriptor.Operator == FilterOperator.None)
{
return(string.Empty);
}
if ((dateTimeFilterDescriptor.Operator != FilterOperator.IsNotNull && dateTimeFilterDescriptor.Operator != FilterOperator.IsNull) &&
dateTimeFilterDescriptor.Value == null)
{
return(string.Empty);
}
string dateBegin = null;
string dateEnd = null;
string propertyName = DataStorageHelper.EscapeName(dateTimeFilterDescriptor.PropertyName);
if (dateTimeFilterDescriptor.Value != null)
{
dateBegin = String.Format(CultureInfo.InvariantCulture, "#{0}#", dateTimeFilterDescriptor.Value.Value.Date);
dateEnd = String.Format(CultureInfo.InvariantCulture, "#{0}#", dateTimeFilterDescriptor.Value.Value.Date.AddDays(1));
}
switch (dateTimeFilterDescriptor.Operator)
{
case FilterOperator.None:
return(String.Empty);
case FilterOperator.IsNull:
return(string.Format("{0} IS NULL", propertyName));
case FilterOperator.IsNotNull:
return(string.Format("NOT ({0} IS NULL)", propertyName));
case FilterOperator.IsLessThan:
return(string.Format("{0} < {1}", propertyName, dateBegin));
case FilterOperator.IsLessThanOrEqualTo:
return(string.Format("{0} < {1}", propertyName, dateEnd));
case FilterOperator.IsLike:
case FilterOperator.IsEqualTo:
return(string.Format("{0} >= {1} AND {0} < {2}", propertyName, dateBegin, dateEnd));
case FilterOperator.IsNotLike:
case FilterOperator.IsNotEqualTo:
return(string.Format("{0} < {1} OR {0} >= {2}", propertyName, dateBegin, dateEnd));
case FilterOperator.IsGreaterThanOrEqualTo:
return(string.Format("{0} >= {1}", propertyName, dateBegin));
case FilterOperator.IsGreaterThan:
return(string.Format("{0} >= {1}", propertyName, dateEnd));
case FilterOperator.StartsWith:
case FilterOperator.EndsWith:
case FilterOperator.Contains:
case FilterOperator.NotContains:
case FilterOperator.IsContainedIn:
case FilterOperator.IsNotContainedIn:
default:
return(String.Empty);
}
}
else
{
return(FilterDescriptor.GetExpression(dateTimeFilterDescriptor));
}
}
public override object Clone()
{
DateFilterDescriptor cloneDescriptor = new DateFilterDescriptor(this.PropertyName, this.Operator, this.Value, this.IgnoreTimePart);
return(cloneDescriptor);
}
public override string ToString()
{
return(DateFilterDescriptor.GetExpression(this));
}
