public bool Generate(ConditionGeneratorContext context)
{
if (context.Operator != "Between")
{
return(false);
}
string paraNameBegin = string.Format("{0}{1}", context.ParameterName, Constant.PARAMETER_SUFFIX_BETWEEN_BEGIN);
string paraNameEnd = string.Format("{0}{1}", context.ParameterName, Constant.PARAMETER_SUFFIX_BETWEEN_END);
context.SqlBuilder.Append($" [{context.FieldName}] BETWEEN {context.GetParameterCommand(paraNameBegin)} AND {context.GetParameterCommand(paraNameEnd)}");
context.AddParameter(paraNameBegin);
context.AddParameter(paraNameEnd);
return(true);
}
public bool Generate(ConditionGeneratorContext context)
{
string opr = context.Operator;
opr = operatorMapper.GetOperatorByText(opr);
if (string.IsNullOrEmpty(opr))
{
return(false);
}
context.SqlBuilder.Append($" [{context.FieldName}] {opr} {context.GetParameterCommand(context.ParameterName)}");
context.AddParameter(context.ParameterName);
return(true);
}