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