帆软 下拉框

CHANG_09 / 2023-05-04 / 原文

代码

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,"\',\'")+"'"+")")}