| | |
|---|
| | | A.delivery_qty - ISNULL(dhmx.quantity, 0) as dssl, |
|---|
| | | A.po_erp_no, |
|---|
| | | C.PURCHASE_ORDER_LINE_NUMBER, |
|---|
| | | dhmx.GUID AS DDHID |
|---|
| | | dhmx.GUID AS DDHID, |
|---|
| | | A.erpline_id |
|---|
| | | from DELIVERY_NOTICE_DETAIL A |
|---|
| | | 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 MES_ITEMS D ON A.product_code = D.item_id |
|---|
| | | LEFT JOIN dhmx ON dhmx.line_k3id = A.po_line_no AND dhmx.paper_bill_no = A.delivery_no |
|---|
| | | WHERE A.delivery_no = @shdh"; |
|---|
| | | |
|---|
| | |
|---|
| | | //// 使用参数化查询防止SQL注入 |
|---|
| | | var sqlParams = new List<SugarParameter> { new("@shdh", unity.shdh) }; |
|---|
| | | |
|---|
| | | var sql2 = @"SELECT A.small_barcode, |
|---|
| | | D.item_no, |
|---|
| | | var sql2 = @"SELECT A.small_barcode, |
|---|
| | | D.item_no, |
|---|
| | | D.item_name, |
|---|
| | | D.item_model, |
|---|
| | | A.include_qty, |
|---|
