protected virtual string CreateWhereFieldStringForValue(string field, OP whereOperator, params string[] value)
{
if (whereOperator == OP.NULL_OR_DI)
{
return(string.Format(
"({0} IS NULL OR {0} {1} {2})",
field,
SqlBuilderHelper.GetStringForOperator(whereOperator),
value));
}
if (whereOperator == OP.NOT_IN && value.Length == 0)
{
return("/* NOT IN () */ 1 = 1");
}
if (whereOperator == OP.IN && value.Length == 0)
{
return("/* IN () */ 1 = 0");
}
return
($"{field} {SqlBuilderHelper.GetStringForOperator(whereOperator)} {(value != null ? GetStringValueByOperator(whereOperator, value) : GetNullStringValueByOperator(whereOperator))}");
}
protected override string CreateWhereFieldStringForParameter(string field, string paramName, OP whereOperator)
{
return($"{GetAliasForType()}.{field} {SqlBuilderHelper.GetStringForOperator(whereOperator)} {DbConfigConfig.WithParameters(paramName)}");
}
protected virtual string CreateWhereFieldStringForParameter(string field, string paramName, OP whereOperator)
{
return($"{field} {SqlBuilderHelper.GetStringForOperator(whereOperator)} {DbConfig.WithParameters(paramName)}");
}