From 60c9b50a2f883e8a5f22a4bc21618c509e2bb76b Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Mon, 01 Aug 2022 10:52:46 +0800
Subject: [PATCH] 更新当删除出库记录时，已出库数量和库存数量会相对应改变
---
src/main/java/org/springblade/modules/soldr/mapper/SoldrMapper.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/org/springblade/modules/soldr/mapper/SoldrMapper.java b/src/main/java/org/springblade/modules/soldr/mapper/SoldrMapper.java
index 1def817..b6b17d4 100644
--- a/src/main/java/org/springblade/modules/soldr/mapper/SoldrMapper.java
+++ b/src/main/java/org/springblade/modules/soldr/mapper/SoldrMapper.java
@@ -16,6 +16,7 @@
*/
package org.springblade.modules.soldr.mapper;
+import org.apache.ibatis.annotations.Param;
import org.springblade.modules.soldr.entity.Soldr;
import org.springblade.modules.soldr.vo.SoldrVO;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
@@ -46,4 +47,21 @@
void dels(Long id);
List<SoldrVO> selectSol();
List<Map<String, Object>> selectCz(Long sid);
+ /**
+ * 根据stockId、specs1、specs_val1、specs_val2、sid 找到soldr表中对应的数据
+ * @param stockId1 种类id
+ * @param specs1 规格
+ * @param specsVal1 规格值（0：克 1：斤 2：公斤 3：吨 4：毫升 5：升 ）
+ * @param specsVal2 规格值2( 0:袋 1：包 2：瓶 3：盒 4：箱 5：桶 6:支)
+ * @param sid 农资库存表主键
+ * @param type 出库类型
+ */
+ Soldr getByServalParam(@Param("stockId1") String stockId1,
+ @Param("specs1") String specs1,
+ @Param("specsVal1") Integer specsVal1,
+ @Param("specsVal2") Integer specsVal2,
+ @Param("sid") Long sid,
+ @Param("type") String type);
+
+ void cancelDel(Long id);
}
--
Gitblit v1.9.3