${if(A=="角色1","select 字段1，字段2 from 表 aa where 1=1"+ IF(len(状态)==0,""," AND type='"+状态+"'"),if(A=="角色2","select 字段1，字段2 from 表bb ",""))}

${IF(pRESOURCE_TYPE = '现存已配车',"

select 

calculation_method,

car_series,

car_model,

sum(allocation_predict_qty) as qty

from 

dal.dal_dvmp_delivery_forecast_fr

where 1=1 "

+if(len(pMETHOD) == 0,"","and calculation_method  IN ('" +pMETHOD + "')")+

"group by car_series,calculation_method,

car_model",

"select 

car_series,

car_model,

sum(allocation_predict_qty) as qty

from

dal.dal_dvmp_delivery_forecast_fr

group by car_series,

car_model

"

)}

替换一下即可

${if(and(A=="角色1",len(状态)>0),"select 字段1，字段2 from 表 aa where type='"+状态+"'",if(and(A=="角色1",len(状态)=0),"select 字段1，字段2 from 表 aa",if(A=="角色2","select 字段1，字段2 from 表bb ","")))}