From f60476d8753efa5e94a5aab08964c74bd491a618 Mon Sep 17 00:00:00 2001
From: zyx <zyx123456>
Date: 星期二, 28 十一月 2023 13:43:34 +0800
Subject: [PATCH] 新建分支 用于AGV新的出库任务下发模式
---
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