From d87f68eb535935814f287b3740474e7eb24b3643 Mon Sep 17 00:00:00 2001
From: zyx <zyx123456>
Date: 星期三, 22 十一月 2023 09:10:23 +0800
Subject: [PATCH] 自动补货流程更新
---
src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java | 3 +++
1 files changed, 3 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java
index 7523098..defa219 100644
--- a/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/AgvLocDetlMapper.java
@@ -37,6 +37,9 @@
@Select("SELECT SUM(anfme) FROM agv_loc_detl WHERE loc_no = #{locNo}")
Double sumByLocNo(@Param("locNo")String locNo);
+ @Select("SELECT SUM(anfme) FROM agv_loc_detl WHERE matnr = #{matnr}")
+ Double sumByMatnr(@Param("matnr")String matnr);
+
int updateAnfme(@Param("locNo")String locNo, @Param("anfme")Double anfme, @Param("matnr")String matnr, @Param("batch")String batch, @Param("csocode")String csocode, @Param("isocode")String isocode);
int deleteLocDetl(@Param("locNo")String locNo, @Param("anfme")Double anfme, @Param("matnr")String matnr, @Param("batch")String batch, @Param("csocode")String csocode, @Param("isocode")String isocode);
--
Gitblit v1.9.1