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 [ITSV ].[UFDATA_102_2017].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.ordercardno where 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+"')")}不起作用 |
1min目标场景问卷
立即参与
