where (
1=1 ${if(len(starttime) == 0,"","and 制单日期>='"+starttime+"'")}
and
1=1 ${if(len(endtime) == 0,"","and 制单日期<='"+endtime+"'")}
)
and
(
1=1 ${if(len(starttime1) == 0,"","and 交货日期>='"+starttime1+"'")}
and
1=1 ${if(len(endtime1) == 0,"","and 交货日期<='"+endtime1+"'")}
)
参照修改下