yzm244954(提问者)select *
from kc_differ
where status not in (\'正常\') and 1=1
${if(len(商品代码) == 0,\"\",\"and spdm in (\'\" + 商品代码 + \"\')\")}
${if(len(spmc) == 0,\"\",\"and spmc in (\'\" + spmc + \"\')\")}
${if(len(cy1)=0 || len(cy2)=0,\"\",\" and cy BETWEEN \'\"+cy1+\"\' AND \'\"+cy2+\"\'\")}
${if(len(status) == 0,\"\",\"and status in (\'\" + status + \"\')\")}
应该跟这没关系吧 最后一个选中的再取消 他就传过去了 但是选中就没传过去