From c560649e37ab5a5bc29c47a3fa7309dc912b48cb Mon Sep 17 00:00:00 2001
From: 李天宇 <876263681@qq.com>
Date: 星期五, 25 十月 2024 09:33:08 +0800
Subject: [PATCH] #update 修复wms库存明细统计bug，实现客户导出需求
---
src/main/java/com/zy/asrs/mapper/RowLastnoMapper.java | 7 +++++++
1 files changed, 7 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/RowLastnoMapper.java b/src/main/java/com/zy/asrs/mapper/RowLastnoMapper.java
index 1a1ca80..f683f26 100644
--- a/src/main/java/com/zy/asrs/mapper/RowLastnoMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/RowLastnoMapper.java
@@ -3,6 +3,8 @@
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.RowLastno;
import org.apache.ibatis.annotations.Mapper;
+import org.apache.ibatis.annotations.Param;
+import org.apache.ibatis.annotations.Update;
import org.springframework.stereotype.Repository;
@Mapper
@@ -11,4 +13,9 @@
RowLastno findBySection(Integer row);
+ @Update("update asr_row_lastno set wrk_mk = 1 where whs_type = 1")
+ void updateInitWrkMk();
+
+ @Update("update asr_row_lastno set wrk_mk = 1 where whs_type = #{whs}")
+ void updateNextWrkMk(@Param("whs") int i);
}
--
Gitblit v1.9.1