public string BuildQueryString(string FieldName)
{
if (QueryConstraints.None == m_Constraint)
{
return("");
}
string ret = FieldName + " " + m_ConstraintStrings[(ulong)m_Constraint] + " ";
//if (typeof(Int32) == m_Value1.GetType())
// ret += ((Int32)m_Value1).ToString();
//else if (typeof(long) == m_Value1.GetType())
// ret += ((long)m_Value1).ToString();
//else if (typeof(Double) == m_Value1.GetType())
// ret += ((Double)m_Value1).ToString();
//else if (typeof(Decimal) == m_Value1.GetType())
// ret += ((Decimal)m_Value1).ToString();
//else if (typeof(Boolean) == m_Value1.GetType())
// ret += ((Boolean)m_Value1) ? 1 : 0;
//else
// ret += "\"" + m_Value1.ToString() + "\"";
ret += DBConvert.ToDBString(m_Value1);
if (QueryConstraints.Between == m_Constraint)
{
ret += " AND ";
}
else
{
return(ret);
}
//if (typeof(Int32) == m_Value2.GetType())
// ret += ((Int32)m_Value2).ToString();
//else if (typeof(long) == m_Value2.GetType())
// ret += ((long)m_Value2).ToString();
//else if (typeof(Double) == m_Value2.GetType())
// ret += ((Double)m_Value2).ToString();
//else if (typeof(Decimal) == m_Value2.GetType())
// ret += ((Decimal)m_Value2).ToString();
//else if (typeof(Boolean) == m_Value2.GetType())
// ret += ((Boolean)m_Value2) ? 1 : 0;
//else
// ret += "\"" + m_Value2.ToString() + "\"";
ret += DBConvert.ToDBString(m_Value2);
return(ret);
}
