yzmBraJi9494674(提问者) 回复 yzm180820select xh1,txrq,txbm,wjmc,xljb,bfjg,wjbh,bbrq,ssrq,fwzxqk,sytk,sybm,zt,bz
from formtable_main_272_dt1
where xh1 is not null
and 1=1
${if(len(序号) == 0,\"\",\"and xh1 in (\'\" + 序号 + \"\')\")}
and 1=1
${if(len(填写日期) == 0,\"\",\"and txrq in (\'\" + 填写日期 + \"\')\")}
and 1=1
${if(len(填写部门) == 0,\"\",\"and txbM in (\'\" + 填写部门 + \"\')\")}
and 1=1
${if(len(文件名称) == 0,\"\",\"and wjmc in (\'\" + 文件名称 + \"\')\")}
order by xh1 asc