From 80baf88fae7bb8ba8dc8be9919e51b817726e394 Mon Sep 17 00:00:00 2001 From: zjj <3272660260@qq.com> Date: 星期三, 26 三月 2025 16:57:10 +0800 Subject: [PATCH] # --- src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java | 5 +++-- 1 files changed, 3 insertions(+), 2 deletions(-) diff --git a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java index 4eac4f1..d89349d 100644 --- a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java @@ -1,6 +1,7 @@ package com.zy.asrs.mapper; import com.baomidou.mybatisplus.mapper.BaseMapper; +import com.zy.asrs.entity.LocDetl; import com.zy.asrs.entity.ManLocDetl; import com.zy.asrs.entity.result.StockVo; import org.apache.ibatis.annotations.Mapper; @@ -42,7 +43,7 @@ List<ManLocDetl> getStockStatisExcel(); - @Select("select sum(a.anfme) as sum from man_loc_detl where matnr = #{matnr}") + @Select("select sum(anfme) as sum from man_loc_detl where matnr = #{matnr}") Double selectSumAnfmeByMatnr(@Param("matnr") String matnr); List<ManLocDetl> selectPakoutByRule(String matnr); @@ -53,7 +54,7 @@ // ------------------------------------------------- - List<ManLocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos); + List<LocDetl> queryStock(@Param("matnr")String matnr, @Param("batch")String batch, @Param("orderNo")String orderNo, @Param("locNos") Set<String> locNos, @Param("supp")String supp, @Param("temp1")String temp1, @Param("temp2")String temp2); Double queryStockAnfme(String matnr, String batch); -- Gitblit v1.9.1