|
|
��¼ʱ�䣺2025-05-15 15:22:13,805 �߳�ID:[6] ��־������INFO �ࣺNFine.Web.Areas.SRM.Controllers.CartonNoManageController - ���������洫�Σ�1��¼ʱ�䣺2025-05-15 15:22:13,825 �߳�ID:[6] ��־������INFO �ࣺNFine.Web.Areas.SRM.Controllers.CartonNoManageController - ��������ȡsql�� SELECT DISTINCT f.VenCode,f.VenName, e.EATTRIBUTE4 as PODXEATTRIBUTE4,ContainerCode as QRLotNo,g.invcode,g.invname,g.invstd,e.pocode,CONVERT(varchar(100), a.MTIME, 112) AS BatchCode,g.InvUnit,SUM(c.Quantity) AS Quantity ,CAST(f.VenCode+'_'+g.InvCode+'_'+CAST(SUM(c.Quantity) AS NVARCHAR(20))+'_'+g.InvUnit+'_'+CONVERT(varchar(100), a.MTIME, 112) AS NVARCHAR(100)) AS erweima,g.EATTRIBUTE11,g.EATTRIBUTE12,g.EATTRIBUTE13,g.EATTRIBUTE14,g.EATTRIBUTE15,g.EATTRIBUTE16,g.EATTRIBUTE17,g.EATTRIBUTE18, CASE WHEN g.EATTRIBUTE19='1'THEN'ʳƷ������'WHEN g.EATTRIBUTE19='0'THEN'��ʳƷ������' END EATTRIBUTE19,c.ProductDate FROM ICSContainer a LEFT JOIN ICSContainerLot b ON a.ID=b.ContainerID AND a.WorkPOint=b.WorkPOint LEFT JOIN ICSInventoryLot c ON b.lotno=c.lotno AND b.WorkPOint=c.WorkPOint left join ICSInventoryLotDetail d on c.lotNo=d.LotNo and c.WorkPoint=d.WorkPoint LEFT JOIN dbo.ICSPurchaseOrder e ON e.POCode=d.TransCode AND e.Sequence=d.TransSequence AND e.WorkPoint=d.WorkPoint LEFT JOIN icsVendor f ON f.VenCode=e.VenCode AND f.WorkPoint=e.WorkPoint LEFT JOIN ICSInventory g ON e.InvCode=g.INvCode AND e.WorkPoint=g.WorkPoint WHERE 1=1 and a.ContainerCode IN ('C01000000250508001') and a.WorkPoint in ('UFDATA_106_2019') GROUP BY f.VenCode,f.VenName, e.EATTRIBUTE4 ,ContainerCode,g.INVCode,g.INvName,g.INvStd,e.POCode,g.InvUnit,CONVERT(varchar(100), a.MTIME, 112), g.EATTRIBUTE11,g.EATTRIBUTE12,g.EATTRIBUTE13,g.EATTRIBUTE14,g.EATTRIBUTE15,g.EATTRIBUTE16,g.EATTRIBUTE17,g.EATTRIBUTE18,g.EATTRIBUTE19,c.ProductDate
|
