这是我想实现的效果
34884
这是我写的过滤,哪里不对吗,为什么没有可用的过滤控件跳出来呢
select * from dbo.human_科技奖励信息填报 where 1=1 ${if(len(awardName)==0&&len(programName)==0&&len(awardClass)==0,"","")} ${if(len(awardName)==0&&len(programName)==0&&len(awardClass)!=0,"and awardName='"+awardName+"'","")} ${if(len(programName)!=0," and programName='"+programName+"'","")} ${if(len(awardClass)!=0," and awardClass='"+awardClass+"'","")}