| | |
|---|
| | | 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, |
|---|
