/// <summary>
/// Gets the value string.
/// </summary>
/// <param name="value">The value.</param>
/// <returns></returns>
private static string GetValueString(DataObjectBroker dob, object value)
{
string valueString = String.Empty;
if (value == null)
{
valueString = "NULL";
}
else if (value.GetType() == typeof(bool))
{
if (value.ToString() == "True")
{
valueString = "1";
}
else
{
valueString = "0";
}
}
else if (value.GetType() == typeof(decimal))
{
valueString = ((decimal)value).ToString(new System.Globalization.CultureInfo("en-US"));
}
else if (value.GetType() == typeof(double))
{
valueString = ((double)value).ToString(new System.Globalization.CultureInfo("en-US"));
}
else if (value.GetType() == typeof(DateTime))
{
valueString = dob.ConnectionInfo.FormatDate(value);
}
else
{
valueString = value.ToString();
}
return(valueString);
}
public SqlGroupByCriteria(SqlGroupByCriteria oc, IObjectBroker dataObjectBroker)
: base(oc)
{
m_DataObjectBroker = (DataObjectBroker)dataObjectBroker;
}
public SqlGroupByCriteria(GroupCriteria groupCriteria, IObjectBroker dataObjectBroker)
: base(groupCriteria)
{
m_DataObjectBroker = (DataObjectBroker)dataObjectBroker;
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlFilterCriteria"/> class.
/// </summary>
/// <param name="dataObjectBroker">The data object broker.</param>
public SqlFilterCriteria(IObjectBroker dataObjectBroker)
{
m_DataObjectBroker = (DataObjectBroker)dataObjectBroker;
}
public static string ComparisonTextForParameters(DataObjectBroker dob, ComparisonMethod comparisonMethod, ref object value, int counter)
{
return(dob.ConnectionInfo.ComparisonTextForParameters(comparisonMethod, ref value, counter));
}
/// <summary>
/// Comparisons the text.
/// </summary>
/// <param name="method">The method.</param>
/// <param name="value">The value.</param>
/// <returns></returns>
//private string ComparisonText(ComparisonMethod method, object value)
public static string ComparisonText(DataObjectBroker dob, ComparisonMethod method, object value, Type type)
{
return(dob.ConnectionInfo.ComparisonText(method, GetValueString(dob, value), type));
}
/// <summary>
/// Initializes a new instance of the <see cref="SqlOrderByCriteria"/> class.
/// </summary>
/// <param name="dataObjectBroker">The data object broker.</param>
/// <param name="orderCriteria">The order criteria.</param>
public SqlOrderByCriteria(OrderCriteria orderCriteria, IObjectBroker dataObjectBroker)
: base(orderCriteria)
{
m_DataObjectBroker = (DataObjectBroker)dataObjectBroker;
}
