${IF(参数="A",xxxxx其它SQL语句xxxxx if(len(客户规格)>0," AND mes_ms09.PK_MS09 in ('"+客户规格+"')",""),IF(参数="B",xxxxx其它SQL语句xxxxx if(len(客户规格)>0," AND mes_ms09.PK_MS09 in ('"+客户规格+"')",""),""))
${IF(参数=A,"SELECT * FROM TABLE1",IF(参数=B,"SELECT * FROM TABLE2",IF(参数=C,"SELECT * FROM TABLE3","")))}比如: IF(参数=A,"SELECT * FROM TABLE1 where 客户='${客户}' and 开始时间='${开始时间}' "
where (mes_saleswarehouseing_b2.dr = '0') and (mes_transcripts_h.dr = '0') and (mes_saleswarehouseing_h.dr = '0') and (mes_saleswarehouseing_h.FORDERTYPE = '1') and (mes_SalesWarehouseing_h.ccustomerid='${客户}') and (mes_SalesWarehouseing_h.ddeliverdate>='${开始日期}') and (mes_SalesWarehouseing_h.ddeliverdate<='${结束日期}')以下是改写前的固定条件and (mes_SalesWarehouseing_h.ccustomerid='00016610000000003I9S') and (mes_SalesWarehouseing_h.ddeliverdate>='2020-01-01') and (mes_SalesWarehouseing_h.ddeliverdate<='2020-11-30')