第一个文本框是参数je第二个是参数je2,想要实现输入0-200可以查询合同额在0-200万之间的合同,输入0-(不填数值)可以查询合同额0元以上的合同
SELECT * FROM TABLE WHERE 1=1 ${IF(LEN(JE)==0,""," AND 合同金额>='"+JE+"'")}${IF(LEN(JE2)==0,""," AND 合同金额<='"+JE2+"'")}