public object ToSQL_WHERE_Clause(iClass_Base i_oObject)
{
if (f.Count < 1)
{
return(string.Empty);
}
return(" WHERE " + ToString(i_oObject));
}
public string ToString(iClass_Base i_oObject)
{
i_oObject._ValidateSQLOutputParameter(sName);
StringBuilder sb = new StringBuilder();
sb.Append(sName);
//string sTemp;
//if (!string.IsNullOrEmpty(sAlias))
//{
// sTemp = cUtility.GetValidIdentifier(sAlias);
// if (sTemp != sAlias) throw new cInvalidOutputParameterException("Invalid Alias " + sAlias);
// sb.Append(" AS " + sAlias);
//}
return sb.ToString();
}
public string ToString(iClass_Base i_oObject)
{
i_oObject._ValidateSQLOutputParameter(sName);
StringBuilder sb = new StringBuilder();
sb.Append(sName);
//string sTemp;
//if (!string.IsNullOrEmpty(sAlias))
//{
// sTemp = cUtility.GetValidIdentifier(sAlias);
// if (sTemp != sAlias) throw new cInvalidOutputParameterException("Invalid Alias " + sAlias);
// sb.Append(" AS " + sAlias);
//}
return(sb.ToString());
}
public string ToString(iClass_Base i_oObject)
{
string sValue1 = i_oObject._ValidateSQLFilterParameter(sName, enOperator, sValue);
StringBuilder sb = new StringBuilder();
if (bNegate)
{
sb.Append("NOT ");
}
sb.Append('(');
sb.Append(sName);
sb.Append(' ');
switch (enOperator)
{
case enComparison.Equals:
sb.Append('=');
break;
case enComparison.NotEquals:
sb.Append("<>");
break;
case enComparison.LessThan:
sb.Append('<');
break;
case enComparison.GreaterThan:
sb.Append('>');
break;
case enComparison.LessThanOrEquals:
sb.Append("<=");
break;
case enComparison.GreaterThanOrEquals:
sb.Append(">=");
break;
case enComparison.Like:
sb.Append("LIKE");
break;
}
sb.Append(' ');
sb.Append(sValue1);
sb.Append(')');
return(sb.ToString());
}
public string ToString(iClass_Base i_oObject)
{
if (aOutputs.Count < 1)
{
return("*");
}
StringBuilder sb = new StringBuilder();
sb.Append(' ');
for (int i = 0; i < aOutputs.Count; i++)
{
if (i > 0)
{
sb.Append(", \n");
}
sb.Append(aOutputs[i].ToString(i_oObject));
}
sb.Append(' ');
return(sb.ToString());
}
public string ToString(iClass_Base i_oObject)
{
StringBuilder sb = new StringBuilder();
bool bOperator = false;
sb.Append('(');
for (int i = 0; i < f.Count; i++)
{
if (bOperator)
{
sb.Append(' ');
switch ((enLogical)f[i])
{
case enLogical.AND:
sb.Append("AND");
break;
case enLogical.OR:
sb.Append("OR");
break;
}
sb.Append(' ');
}
else
{
if (f[i] is cFilter)
{
sb.Append((f[i] as cFilter).ToString(i_oObject));
}
else
{
sb.Append((f[i] as cFilterParameter).ToString(i_oObject));
}
}
bOperator = !bOperator;
}
sb.Append(')');
return(sb.ToString());
}
public string ToString(iClass_Base i_oObject)
{
string sValue1 = i_oObject._ValidateSQLFilterParameter(sName, enOperator, sValue);
StringBuilder sb = new StringBuilder();
if (bNegate) sb.Append("NOT ");
sb.Append('(');
sb.Append(sName);
sb.Append(' ');
switch (enOperator)
{
case enComparison.Equals:
sb.Append('=');
break;
case enComparison.NotEquals:
sb.Append("<>");
break;
case enComparison.LessThan:
sb.Append('<');
break;
case enComparison.GreaterThan:
sb.Append('>');
break;
case enComparison.LessThanOrEquals:
sb.Append("<=");
break;
case enComparison.GreaterThanOrEquals:
sb.Append(">=");
break;
case enComparison.Like:
sb.Append("LIKE");
break;
}
sb.Append(' ');
sb.Append(sValue1);
sb.Append(')');
return sb.ToString();
}
public object ToSQL_WHERE_Clause(iClass_Base i_oObject)
{
if (f.Count < 1) return string.Empty;
return " WHERE " + ToString(i_oObject);
}
public string ToString(iClass_Base i_oObject)
{
StringBuilder sb = new StringBuilder();
bool bOperator = false;
sb.Append('(');
for (int i = 0; i < f.Count; i++)
{
if (bOperator)
{
sb.Append(' ');
switch ((enLogical)f[i])
{
case enLogical.AND:
sb.Append("AND");
break;
case enLogical.OR:
sb.Append("OR");
break;
}
sb.Append(' ');
}
else
{
if (f[i] is cFilter)
{
sb.Append((f[i] as cFilter).ToString(i_oObject));
}
else
{
sb.Append((f[i] as cFilterParameter).ToString(i_oObject));
}
}
bOperator = !bOperator;
}
sb.Append(')');
return sb.ToString();
}
