二层包装明细表

SELECT distinct A2.PackNumber AS 二层包装号码,CASE WHEN A2.IsPartitial

 = 1 THEN '部分包' ELSE '整包'END AS 二层是否整包,A2.StandardSNQty AS

下阶数量,A2.SNQty AS 包装产品数量, CASE WHEN A2.status = 1 AND

A2.productionstatus < 6 THEN '在线WIP' WHEN A2.status = 1 AND 

A2.productionstatus = 6 THEN '已入库' WHEN A2.productionstatus = 10 THEN '已出货' WHEN A2.status = 2 THEN '已包装' END AS 二层包装状态,

A1.PackNumber AS 一层包装号码,

CASE WHEN A1.IsPartitial = 1 THEN '部分包' ELSE '整包' END AS 一层是否整包,

A1.SNQty AS 一层产品数量,

M.Code AS 生产料号,

M.Name AS 品名,

A1.ModifiedTime as 包装时间,

A1.ModifierName as 操作人,

FROM PackageStatus AS A2 INNER JOIN 

PackageStatus AS A1 ON A2.ID = A1.PackID INNER JOIN 

PackagePrint AS B ON A1.PackNumber = B.BarCode INNER JOIN

Material AS so ON B.MaterialID = M.ID INNER JOIN

ShopOrder AS so ON B.ShopOrderID = so.ID INNER JOIN

Process AS P ON A2.ProcessID = P.ID INNER JOIN

Terminal AS t ON A2.TerminalID = t.ID

WHERE  (A2.status > 0) AND(A2.PackLevel = 2)

and 1 = 1 ${if(len(开始日期)==0," ","and

CONVERT(VARCHAR(10),A1.ModifiedTime,120)>=(' " +开始日期+"')")} and 1=1${if(len(截止日期)==0," ","and CONVERT(VARCHAR(10),A1.ModifiedTime,120)<=(' "+截止日期+" ')")}

and 1=1 ${if(len(生产料号)==0," "," and M.Code in (' "+replace(生产料号, ",","','")+"')","")}

and 1=1 ${if(len(品名)==0," ","and M.Name in(' "+replace(品名, ",", "','")+" ')"," ")}

and 1=1 ${if(len(二层包装号码)==0," "," and A2.PackNumber in (' "+replace(二层包装号码,",","','")+" ')"," ")}

and 1=1 ${if(len(一层包装号码)==0," "," and A1.PackNumber in(' "+replace(一层包装号码,",","','")+"')","")}