| | |
|---|
| | | if (shdh.Count < 1) |
|---|
| | | throw new Exception($"送货单号【{unity.shdh}】不存在或未同步!"); |
|---|
| | | |
|---|
| | | // var sql3 = @"SELECT ISNULL((SELECT SUM(delivery_qty) FROM DELIVERY_NOTICE_DETAIL WHERE delivery_no = @shdh), 0) - |
|---|
| | | //ISNULL((SELECT SUM(include_qty) FROM TBL_BARCODE_INFORMATION WHERE delivery_no = @shdh), 0) AS Diffnum "; |
|---|
| | | |
|---|
| | | // var diffNum = Db.Ado.SqlQuery<dynamic>(sql3, sqlParams).First(); |
|---|
| | | |
|---|
| | | // if (diffNum.Diffnum != 0) |
|---|
| | | // throw new Exception($"送货单号【{unity.shdh}】条码未全部打印或未同步，无法收货！"); |
|---|
| | | |
|---|
| | | var sql2 = @"select D.item_no, |
|---|
| | | D.item_name, |
|---|
| | |
|---|
| | | 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); |
|---|
