| | |
|---|
| | | private List<MesInvItemOutItems> GetItemOutItems(WarehouseQuery query) |
|---|
| | | { |
|---|
| | | var sql = string.Format( |
|---|
| | | "SELECT C.ITEM_NO, C.QUANTITY, C.REMARK, C.REMARK, S.ITEM_NAME, S.ITEM_MODEL, U.FNAME ITEM_UNIT, D.QUANTITY_OK, NVL(ST.QUANTITY, 0) WLKC FROM MES_INV_ITEM_OUT_ITEMS C JOIN MES_ITEMS S ON C.ITEM_ID = S.ID LEFT JOIN MES_UNIT U ON U.ID = S.ITEM_UNIT LEFT JOIN MES_DEPOTS P ON P.DEPOT_CODE = C.DEPOT_CODE LEFT JOIN MES_DEPOT_SECTIONS E ON E.DEPOT_SECTION_CODE = C.DEPOT_SECTION_CODE LEFT JOIN (SELECT ITEM_MOVE_ID, ITEM_NO, SUM(QUANTITY) QUANTITY_OK FROM MES_INV_ITEM_MOVES_C_DETAILS GROUP BY ITEM_MOVE_ID, ITEM_NO) D ON D.ITEM_MOVE_ID = C.ITEM_OUT_ID AND D.ITEM_NO = C.ITEM_NO LEFT JOIN MES_INV_ITEM_MOVES A ON A.ID = C.ITEM_OUT_ID left join (SELECT ITEM_ID, SUM(QUANTITY) QUANTITY, DEPOTS_CODE FROM MES_INV_ITEM_STOCKS GROUP BY ITEM_ID, DEPOTS_CODE) ST ON C.ITEM_ID = ST.ITEM_ID AND ST.DEPOTS_CODE = A.FROM_DEPOTS_CODE where C.ITEM_OUT_ID = {0}", |
|---|
| | | "SELECT C.ITEM_NO,C.QUANTITY, C.REMARK,C.REMARK,S.ITEM_NAME, S.ITEM_MODEL, U.FNAME ITEM_UNIT, D.QUANTITY_OK,NVL(ST.QUANTITY, 0) WLKC FROM MES_INV_ITEM_OUT_ITEMS C JOIN MES_ITEMS S ON C.ITEM_ID = S.ID LEFT JOIN MES_UNIT U ON U.ID = S.ITEM_UNIT LEFT JOIN MES_DEPOTS P ON P.DEPOT_CODE = C.DEPOT_CODE LEFT JOIN MES_DEPOT_SECTIONS E ON E.DEPOT_SECTION_CODE = C.DEPOT_SECTION_CODE LEFT JOIN (SELECT ITEM_MOVE_ID, ITEM_NO, SUM(QUANTITY) QUANTITY_OK FROM MES_INV_ITEM_MOVES_C_DETAILS GROUP BY ITEM_MOVE_ID, ITEM_NO) D ON D.ITEM_MOVE_ID = C.ITEM_OUT_ID AND D.ITEM_NO = C.ITEM_NO LEFT JOIN MES_INV_ITEM_MOVES A ON A.ID = C.ITEM_OUT_ID left join (SELECT ITEM_ID, SUM(QUANTITY) QUANTITY, DEPOTS_CODE FROM MES_INV_ITEM_STOCKS GROUP BY ITEM_ID, DEPOTS_CODE) ST ON C.ITEM_ID = ST.ITEM_ID AND ST.DEPOTS_CODE = A.FROM_DEPOTS_CODE where C.ITEM_OUT_ID = {0}", |
|---|
| | | query.id); |
|---|
| | | |
|---|
| | | return Db.Ado.SqlQuery<MesInvItemOutItems>(sql); |
|---|
| | |
|---|
| | | if (sumqty > quantity) |
|---|
| | | throw new Exception( |
|---|
| | | "已扫条码数量或本次扫码数量：" + sumqty + " 大于申请数量：" + quantity + "，请核对！"); |
|---|
| | | |
|---|
| | | List<InventoryItem> scanOutShowDb = null; |
|---|
| | | |
|---|
| | | |
|---|
| | | UseTransaction(db => |
|---|
| | | { |
|---|
| | | SaveMesInvItemMovesCDetails(db, query, mesInvItemMoves, |
|---|
| | |
|---|
| | | .Where(s => s.Id == mesInvItemStocks.Id) |
|---|
| | | .ExecuteCommand(); |
|---|
| | | |
|---|
| | | scanOutShowDb = ScanOutShowDb(query); |
|---|
| | | var scanOutShowDb = ScanOutShowDb(query); |
|---|
| | | if (CollectionUtil.IsNullOrEmpty(scanOutShowDb)) |
|---|
| | | db.Updateable<MesInvItemMoves>() |
|---|
| | | .SetColumns(s => s.Status == 1) |
|---|
| | |
|---|
| | | }); |
|---|
| | | |
|---|
| | | var itemDto = new OutItemDto(); |
|---|
| | | itemDto.SumItem = scanOutShowDb; |
|---|
| | | //itemDto.SumItem = scanOutShowDb; |
|---|
| | | |
|---|
| | | if (TransctionNo == 201) itemDto.Quantity = mesInvItemStocks.Quantity; |
|---|
| | | |
|---|
