帆软——添加单选和多选框查询

1.定义参数 area和 area1

select *from dbo.systemusers
where 1=1
${if(len(id) == 0,"","and id<= '" + id+ "'")}
${if(len(name) == 0,"","and name = '" + name + "'")}
${if(len(area) == 0,"","and name = '" + area + "'")}
${if(len(area1) == 0,"","and name in ('"+area1+"')")}

 

 2.单选下拉框，设置组件名称为area,和参数里的一致，绑定下拉列表数据源

 

 3.多选下拉框，配置下拉列表数据源，设置组件名称为area1,和参数中相同，设置返回值类型为字符串，分隔符为：','

 

 4.运行可查看筛选效果