/// <summary>
/// Create WHERE line
/// </summary>
public void CreateWhere(string sqlFieldName, string sqlFieldValue, eSqlConditionType ConditionType, eSqlValueType ValueType)
{
if (m_sqlWhere.Length > 0)
m_sqlWhere.Append(" ");
switch (ConditionType)
{
case eSqlConditionType.And:
{
if (m_sqlWhere.Length < 1)
m_sqlWhere.Append("WHERE " + sqlFieldName);
else
m_sqlWhere.Append("AND " + sqlFieldName);
break;
}
case eSqlConditionType.Or:
{
if (m_sqlWhere.Length < 1)
m_sqlWhere.Append("WHERE " + sqlFieldName);
else
m_sqlWhere.Append("OR " + sqlFieldName);
break;
}
}
if (sqlFieldValue.Length > 0)
{
if (ValueType == eSqlValueType.String)
m_sqlWhere.Append(" LIKE '%" + sqlFieldValue + "%'");
else if (ValueType == eSqlValueType.Int)
m_sqlWhere.Append(" = " + sqlFieldValue);
else if (ValueType == eSqlValueType.In)
m_sqlWhere.Append(" IN (" + sqlFieldValue + ")");
}
}
/// <summary>
/// Create WHERE line
/// </summary>
public void CreateWhere(string sqlFieldName, string MinValue, string MaxValue, eSqlConditionType ConditionType)
{
if (m_sqlWhere.Length > 0)
m_sqlWhere.Append(" ");
string sqlCondition = string.Empty;
if (Convert.ToInt32(MaxValue) == 0)
sqlCondition = sqlFieldName + " >= " + MinValue;
else
sqlCondition = "(" + sqlFieldName + " BETWEEN " + MinValue + " AND " + MaxValue + ")";
switch (ConditionType)
{
case eSqlConditionType.And:
{
if (m_sqlWhere.Length < 1)
m_sqlWhere.Append("WHERE " + sqlCondition);
else
m_sqlWhere.Append("AND " + sqlCondition);
break;
}
case eSqlConditionType.Or:
{
if (m_sqlWhere.Length < 1)
m_sqlWhere.Append("WHERE " + sqlCondition);
else
m_sqlWhere.Append("OR " + sqlCondition);
break;
}
}
}
/// <summary>
/// Create WHERE line
/// </summary>
public void CreateWhere(string sqlStatement, eSqlConditionType ConditionType)
{
if (m_sqlWhere.Length > 0)
m_sqlWhere.Append(" ");
switch (ConditionType)
{
case eSqlConditionType.And:
{
if (m_sqlWhere.Length < 1)
m_sqlWhere.Append("WHERE " + sqlStatement);
else
m_sqlWhere.Append("AND " + sqlStatement);
break;
}
case eSqlConditionType.Or:
{
if (m_sqlWhere.Length < 1)
m_sqlWhere.Append("WHERE " + sqlStatement);
else
m_sqlWhere.Append("OR " + sqlStatement);
break;
}
}
}
