public SqlHelper GenerateSql(SqlHelper builder)
{
// Exit if it is empty
if (IsEmpty()) return builder;
if (FieldValue != null)
{
builder.Add(FieldName, FieldValue);
}
if (FieldValueFrom != null && FieldValueTo != null)
{
builder.BETWEEN(FieldName, FieldValueFrom, FieldValueTo);
}
if (!string.IsNullOrEmpty(FieldValueLike))
{
builder.LIKE(FieldName, FieldValueLike, FullTextSearch);
}
if (GreaterThanValue != null)
{
builder.Add(FieldName, ">", GreaterThanValue);
}
if (LessThanValue != null)
{
builder.Add(FieldName, "<", LessThanValue);
}
if (GreaterThanOrEqualToValue != null)
{
builder.Add(FieldName, ">=", GreaterThanOrEqualToValue);
}
if (LessThanOrEqualToValue != null)
{
builder.Add(FieldName, "<=", LessThanOrEqualToValue);
}
if (_IsNull.HasValue)
{
builder.Add(FieldName + (_IsNull.Value ? " IS NULL" : " IS NOT NULL"));
}
if (NotEqualToValue != null)
{
builder.Add(FieldName, "!=", NotEqualToValue);
}
if (InValues != null)
{
builder.IN(FieldName, InValues);
}
if (!string.IsNullOrEmpty(StartsWithValue))
{
builder.StartsWith(FieldName, StartsWithValue);
}
if (!string.IsNullOrEmpty(EndsWithValue))
{
builder.EndsWith(FieldName, EndsWithValue);
}
return builder;
}