service/Warehouse/MesXkyShdManager.cs
@@ -44,7 +44,7 @@ LEFT JOIN dbo.MES_INV_ITEM_ARN B on B.paper_bill_no = A.delivery_no LEFT JOIN MES_ROH_IN_DATA C ON A.po_line_no = C.EBELN_K3ID LEFT JOIN MES_ITEMS D ON C.ITEM_ID = D.item_id LEFT JOIN dbo.MES_INV_ITEM_ARN_DETAIL E on E.parent_Guid = B.guid AND E.line_k3id = A.po_line_no RIGHT JOIN dbo.MES_INV_ITEM_ARN_DETAIL E on E.parent_Guid = B.guid AND E.line_k3id = A.po_line_no WHERE A.delivery_no = @shdh"; var XcslItem = Db.Ado.SqlQuery<dynamic>(sql2, sqlParams);