${}里面就能在${}了

语句拷贝出来，我给你改

===============

${if(OA='1',"select * from newsoft_cs.oa_wt_temp tmp left join newsoft_cs.oa_wt t on tmp.file_id = t.file_id where t.status in ('S','A','ST')"+ 

if(len(zt) == 0,""," and t.status in ('" + zt + "')")+

if(len(dybh) == 0,""," and tmp.print_code in ('" + dybh + "')")+

if(len(sfz) == 0,""," and tmp.user_id in ('" + sfz + "')") +

if(len(khmc) == 0,""," and tmp.customer_name in ('" + khmc + "')") +

if(len(strxm) == 0,""," and tmp.user_name in ('" + strxm + "')") +

if(len(stime) == 0,""," and tmp.begin_time >= ('" + stime + "')") +

if(len(etime) == 0,""," and tmp.end_time < ('" + etime + "')"), 

"select * from newsoft_cs.oa_wt_view WHERE 1=1"+ 

if(len(zt) == 0,""," and t.status in ('" + zt + "')")+

if(len(dybh) == 0,""," and tmp.print_code in ('" + dybh + "')")+

if(len(sfz) == 0,""," and tmp.user_id in ('" + sfz + "')") +

if(len(khmc) == 0,""," and tmp.customer_name in ('" + khmc + "')") +

if(len(strxm) == 0,""," and tmp.user_name in ('" + strxm + "')") +

if(len(stime) == 0,""," and tmp.begin_time >= ('" + stime + "')") +

if(len(etime) == 0,""," and tmp.end_time < ('" + etime + "')")

)

}

因为后面的${}条件实际上是一样的，所以只需要对不一样的部分判断就行了的，亲测没问题

${if((OA='1'),"select * from newsoft_cs.oa_wt_temp tmp

left join newsoft_cs.oa_wt t on tmp.file_id = t.file_id

where t.status in ('S','A','ST') 

",

"select * from newsoft_cs.oa_wt_view 

WHERE 1=1"

)}

${if(len(zt) == 0,"","and t.status in ('" + zt + "')")}

${if(len(dybh) == 0,"","and tmp.print_code in ('" + dybh + "')")}

${if(len(sfz) == 0,"","and tmp.user_id in ('" + sfz + "')")}

${if(len(khmc) == 0,"","and tmp.customer_name in ('" + khmc + "')")}

${if(len(strxm) == 0,"","and tmp.user_name in ('" + strxm + "')")}

${if(len(stime) == 0,"","and tmp.begin_time >= ('" + stime + "')")}

${if(len(etime) == 0,"","and tmp.end_time < ('" + etime + "')")}

~~