${if(1=1,if(),if())}

-------------------------------------------

一个${}可以写多个参数

举例

 and 1=1 ${if(all_qx == "1" ,"",

    if( len(jd) == 0 ,"and p.MASS_NO in ('" + ARRAY(replace(user1,",","','")) + "')",

    if(len(user1) == 0 ,"and p.PROJECT_JD in ('" + ARRAY(replace(jd,",","','")) + "')",

    "and p.PROJECT_JD in ('" + ARRAY(replace(jd,",","','")) + "') 

    and p.MASS_NO in ('" + ARRAY(replace(user1,",","','")) + "')" ) ))}

-----------

 你的参数写法有问题，携程这样的

可以嵌套 里面的不需要用${}

例如

SELECT * FROM TABLE WHERE 1=1 ${LEN(参数A)==0,IF(len(参数B)==0,""," and ZD='"+参数B+"'")," and ZD='"+参数A+"'"}

很多问题的，但是你的逻辑有问题，要有一个优先级的判断。比如时间录入了，其它参数没有录入，它走不到这个时间的限制的。反正我只改了你能够看到参数出来的界面，if的判断级判断我不知道你的具体应用 

select * from T_ARTICALINPICK_INTF  

where 1=1 

${if(len(barcode)> 0,"and longbarcode ='"+barcode+"'",

if(len(fxjid)=0 &&len(brandcode)=0, "",       

if(len(fxjid)=0 , "and substr(longbarcode,1,32)='"+brandcode+"'",

if(len(brandcode)=0,"and fxjid='"+fxjid+"'",

if(len(brandcode)>0&&len(fxjid)>0,"and substr(longbarcode,1,32)='"+brandcode+"' and fxjid='"+fxjid+"'" ,

if(len(starttime)>0&&len(endtime)>0,

  "and to_char(inserttime,'yyyy-mm-dd hh24:mi:ss') between '"+starttime +"'"+" and"+ "'"+endtime+"'"

,""))))))}

你多个判断在一起的话。它就会有优先级了！！！，不然就要每一个参数都单独写，而不是像现达样