select a.*,b.cinvname,c.materialnum,d.department from (select clfa,ioflag,cinvcode,batchno,opdate,opuser,case when ioflag=1 then storeinnum else 0-storeinnum end as num from pro_inoutstores where ioflag<>0) a left join (select cinvcode,cinvname from ..dbo.inventory) b on a.cinvcode=b.cinvcode left join pro_ordercards c on c.cinvcode=b.cinvcode left join pro_ordercard d on c.ordercardno=d.ordercardnowhere 1=1 ${if(len(department)==0,"","and department=('"+department+"')")}${if(len(opdate)==0,"","and LEFT(opdate, 7)=('"+opdate+"')")}order by opdate 其中${if(len(opdate)==0,"","and LEFT(opdate, 7)=('"+opdate+"')")}不起作用