帆软 下拉框

发布时间 2023-05-04 21:48:37作者: CHANG_09

代码

select
where data_mon = '${date}'
and ccy_unit = '${unit}'
and start_dt >= '${startdate}'
and start_dt <= '${enddate}'
and rpt_freq = '${rpt_freq}'
and 1=1 ${if(len(product_cd)==0,""," and prod_id ub("+"'"+treelayer(product_cd,true,"\',\'")+"'"+")")}