From 7726f938fda4aee9dffd188c565e715a6f17a7ff Mon Sep 17 00:00:00 2001 From: pang.jiabao <pang_jiabao@163.com> Date: 星期五, 07 二月 2025 14:41:50 +0800 Subject: [PATCH] 单据管理一键导出所有数据 --- src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java | 10 ++++++++-- 1 files changed, 8 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 f3e7f83..2c6b748 100644 --- a/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java +++ b/src/main/java/com/zy/asrs/mapper/ManLocDetlMapper.java @@ -1,7 +1,9 @@ package com.zy.asrs.mapper; import com.baomidou.mybatisplus.mapper.BaseMapper; +import com.zy.asrs.entity.LocDetl; import com.zy.asrs.entity.LocDetlWarningDTO; +import com.zy.asrs.entity.LocMast; import com.zy.asrs.entity.ManLocDetl; import com.zy.asrs.entity.result.StockVo; import org.apache.ibatis.annotations.Mapper; @@ -53,7 +55,7 @@ // ------------------------------------------------- - List<ManLocDetl> queryStock(@Param("matnr")String matnr); + List<ManLocDetl> queryStock(@Param("matnr") String matnr,@Param("batch") String batch); Double queryStockAnfme(String matnr, String batch); @@ -84,11 +86,15 @@ long selectAllPageSize(Map<String, Object> condition); - ManLocDetl selectInventory(String LocNo, String Matnr, String batch); + ManLocDetl selectInventory(@Param("LocNo") String LocNo,@Param("matnr") String Matnr,@Param("batch") String batch); int deleteDatailed (String locNo, String matnr,String batch); int increase(Double anfme,String locNo, String matnr,String batch,Double weight); List<LocDetlWarningDTO> selectAllWarning(); + + int updateStockFreeze(String matnr, String locNo, Integer stockFreeze); + + List<LocDetl> selectByLocNo(String locNo);; } -- Gitblit v1.9.1