finereport 带多参数查询

1、sql语句

SELECT * FROM 订单 as dt where 1=1
${if(len(comboBox0)==0,""," and dt.货主地区='"+comboBox0+"'")}
${if(len(comboBox1)==0,""," and dt.货主省份='"+comboBox1+"'")}
${if(len(comboBox2)==0,""," and dt.货主城市='"+comboBox2+"'")}

2、模型是试图

 

posted @ 2019-07-25 16:13  洺剑残虹  阅读(2067)  评论(0编辑  收藏  举报