④内部公开请勿外传SETNOCOUNTONDECLARE@STRITEMNUMBERNVARCHAR(700)DECLARE@STRSTOCKNONVARCHAR(100)DECLARE@STRSELECTSQLVARCHAR(3000)SET@STRITEMNUMBER='*FItemLongNo*'SET@STRSTOCKNO='*FStockLongNo*'SET@STRITEMNUMBER=''+@STRITEMNUMBER+''SET@STRSTOCKNO=''+@STRSTOCKNO+''SET@STRSELECTSQL='CREATETABLE#TEMPINVENTORY([FBRNO][VARCHAR](10)NOTNULL,[FITEMID][INT]NOTNULL,[FBATCHNO][VARCHAR](200)NOTNULL,[FSTOCKID][INT]NOTNULL,[FQTY][DECIMAL](28,10)NOTNULL)INSERTINTO#TEMPINVENTORYSELECTU1.FBRNO,U1.FITEMID,U1.FBATCHNO,U1.FSTOCKID,U1.FQTYFROMICINVENTORYU1WHEREU1.FQTY<>0INSERTINTO#TEMPINVENTORYSELECTU1.FBRNO,U1.FITEMID,U1.FBATCHNO,U1.FSTOCKID,U1.FQTYFROMPOINVENTORYU1WHEREU1.FQTY<>0SELECTT1.FNUMBERASFMATERIALNUMBER,T1.FNAMEASFMATERIALNAME,T1.FMODELASFMATERIALMODEL,T2.FNUMBERASFSTOCKNUMBER,T2.FNAMEASFSTOCKNAME,T3.FNAMEASFUNITNAME,T4.FNAMEASFCUUNITNAME,SUM(U1.FQTY)ASFBUQTY,SUM(U1.FQTY/T4.FCOEFFICIENT)ASFCUUQTYFROM#TEMPINVENTORYU1LEFTJOINT_ICITEMT1ONU1.FITEMID=T1.FITEMIDLEFTJOINT_STOCKT2ONU1.FSTOCKID=T2.FITEMIDLEFTJOINT_MEASUREUNITT3ONT1.FUNITID=T3.FMEASUREUNITIDLEFTJOINT_MEASUREUNITT4ONT1.FSTOREUNITID=T4.FMEASUREUNITIDLEFTJOINT_MEASUREUNITT19ONT1.FSECUNITID=T19.FMEASUREUNITIDWHERE(ROUND(U1.FQTY,T1.FQTYDECIMAL)<>0ORROUND(U1.FQTY/T4.FCOEFFICIENT,T1.FQTYDECIMAL)<>0)ANDT1.FDELETED=0'IF(ISNULL(@STRITEMNUMBER,'')<>''andISNULL(@STRSTOCKNO,'')<>'')BEGINSET@STRSELECTSQL=@STRSELECTSQL+'ANDT1.FNUMBERIN('+''''+@STRITEMNUMBER+''''+')ANDT2.FNUMBERIN('+''''+@STRSTOCKNO+''''+')'ENDELSEIF(ISNULL(@STRITEMNUMBER,'')<>''ANDISNULL(@STRSTOCKNO,'')='')BEGINSET@STRSELECTSQL=@STRSELECTSQL+'ANDT1.FNUMBERIN('+''''+@STRITEMNUMBER+''''+')'ENDELSEBEGINSET@STRSELECTSQL=@STRSELECTSQL+'ANDT2.FNUMBERIN('+''''+@STRSTOCKNO+''''+')'ENDSET@STRSELECTSQL=@STRSELECTSQL+'GROUPBYU1.FITEMID,T1.FNUMBER,T1.FNAME,T1.FMODEL,T2.FNUMBER,T2.FNAME,T3.FNAME,T4.FNAME1/2④内部公开请勿外传ORDERBYT1.FNUMBERDROPTABLE#TEMPINVENTORY'EXEC(@STRSELECTSQL)2/2
