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.运行可查看筛选效果
标签：name,area,数据源,len,单选,选框,area1,帆软 From： https://www.cnblogs.com/luoxiaoxiao102/p/18205524