From ae228435d4bda5baf0d7e6f2f3196a690c70ceb0 Mon Sep 17 00:00:00 2001
From: zhangc <zc@123>
Date: 星期六, 30 十一月 2024 12:45:17 +0800
Subject: [PATCH] json 优化LKInTBScheduler SQL查询并修正数量逻辑
---
src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java | 8 ++++++--
1 files changed, 6 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java
index 4842f5a..612f4d3 100644
--- a/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/OrderDetlMapper.java
@@ -27,13 +27,17 @@
int decrease(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty);
+ int decrease2(@Param("id")Long id, @Param("qty")Double qty);
+
int modifyStatus(@Param("orderId") Long orderId, @Param("status")Integer status);
int addToLogTable(OrderDetl orderDetl);
- int increaseQtyByOrderNo(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty);
+ //int increaseQtyByOrderNo(@Param("orderNo")String orderNo, @Param("matnr")String matnr, @Param("batch")String batch, @Param("qty")Double qty);
- int increaseWorkQty(@Param("orderId")Long orderId, @Param("matnr")String matnr, @Param("batch")String batch, @Param("workQty")Double workQty);
+ int increaseQtyById(@Param("id")Long id, @Param("qty")Double qty);
+
+ int increaseWorkQty(@Param("id")Long id, @Param("workQty")Double workQty);
List<OrderDetl> listByOrderNo(@Param("orderNo") String orderNo);
--
Gitblit v1.9.1