/// <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; } } }