一层包装明细表

 SELECT A.PackNumber AS 一层包装号码,case when A.IsPartitial = 1

THEN '部分包' ELSE'整包' END AS 一层是否整包,

A.SNQty AS 一层产品数量,B.SN AS序列号,M.Code AS 生产料号,M.Name AS 品名,so.Code AS工单,

A.ModifiedTime as 包装时间,A.ModifierName as 操作人,

CASE WHEN A.status = 1 AND 

A.productionstatus <6 THEN'在线WIP' when A.status = 1 AND

A.productionstatus = 6 THEN'已入库' WHEN A.productionstatus = 10 THEN '已出货'

WHEN A. status = 2 THEN'已包装' END AS 包装状态

FROM PackageStatus AS A INNER JOIN

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

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

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

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

Terminal AS t ON A.TerminalID = t.ID

WHERE (A.Status > 0) AND (A.PackLevel = 1)

and 1= 1 ${if(len(开始日期) == 0,"","and CONVERT(VARCHAR(10),A.ModifiedTime,120)>=('" +开始日期 +"')")} and 1 = 1 $ {if(len(截止日期) == 0, " "," and CONVERT(VARCHAR(10),A.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 so.Code in (' "+replace(工单单号, ",", " ',' ")+" ')"," ")}

and 1=1 ${if(len(序列号)==0," "," and B.SN in(' "+ replace(序列号,"," ," ',' ")+" ')"," ")}

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

and 1=1 ${if(len(工单单号)==0," "," and so.Code in('" +replace(工单单号,"," ," ',' ")+"')","")}

order by CONVERT(VARCHAR(10),A.ModifiedTime,120),A.PackNumber,A.ModifierName