From 8b36859fbe464c43fbfb8b2e8ef9ba4327d2d041 Mon Sep 17 00:00:00 2001
From: guoshilong <123456>
Date: Fri, 09 Sep 2022 09:40:35 +0800
Subject: [PATCH] 加工记录删除报错修复

---
 src/main/java/org/springblade/modules/processInv/service/impl/ProcessInvServiceImpl.java |    4 ++--
 src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java            |    2 +-
 src/main/java/org/springblade/modules/processInv/service/IProcessInvService.java         |    2 +-
 src/main/java/org/springblade/modules/process/controller/ProcessController.java          |    4 ++--
 src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.xml             |    4 ++--
 5 files changed, 8 insertions(+), 8 deletions(-)

diff --git a/src/main/java/org/springblade/modules/process/controller/ProcessController.java b/src/main/java/org/springblade/modules/process/controller/ProcessController.java
index 878c2e9..6367c02 100644
--- a/src/main/java/org/springblade/modules/process/controller/ProcessController.java
+++ b/src/main/java/org/springblade/modules/process/controller/ProcessController.java
@@ -148,14 +148,14 @@
 		//通过strainId和landId 确定是由哪一个品种库存加工而来
 		FarmProductStock farmProductStock = farmProductStockService.selectBy2Id(process.getStrainId(),process.getLandId());
 		//通过strainId和processId(processId为产品id)确定对应的加工库存
-		ProcessInv processInv = processInvService.selectBySPId(process.getStrainId(),process.getProcessId());
+		ProcessInv processInv = processInvService.selectBySPId(process.getStrainId(),process.getProcessId(),farmProductStock.getId());
 		//农产品增加相应库存
 		Double weight = Double.parseDouble(farmProductStock.getWeight())+process.getSaleNum();
 		farmProductStock.setWeight(weight.toString());
 		farmProductStockService.updateById(farmProductStock);
 		//加工产品减少对应库存
 		Double num = processInv.getProductInventoryNum()-process.getProcessNum();
-		if (num<=0){
+		if (num<0){
 			//删除对应库存
 //			processInvService.del(processInv.getId());
 			throw new org.springblade.core.log.exception.ServiceException(StringUtil.format("当前库存不足,不能删除数据!"));
diff --git a/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java b/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
index c19f03b..7b2049f 100644
--- a/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
+++ b/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.java
@@ -41,7 +41,7 @@
 	 */
 	List<ProcessInvVO> selectProcessInvPage(IPage page, @Param("processInv") ProcessInvVO processInv);
 
-	ProcessInv selectBySPId(@Param("strainId") Long strainId, @Param("productId") Long productId);
+	ProcessInv selectBySPId(@Param("strainId") Long strainId, @Param("productId") Long productId,@Param("fpsId") Long fpsId);
 
 	ProcessInv selectBySFId(@Param("strainId")Long strainId, @Param("fpsId")String fpsId);
 
diff --git a/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.xml b/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.xml
index 1c254b3..fc2c821 100644
--- a/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.xml
+++ b/src/main/java/org/springblade/modules/processInv/mapper/ProcessInvMapper.xml
@@ -38,13 +38,13 @@
     <select id="selectBySPId" resultType="org.springblade.modules.processInv.entity.ProcessInv">
         SELECT id,strain_id,product_id,product_inventory_num,create_time,update_user,update_time,status,is_deleted
         FROM sys_process_inv
-        WHERE is_deleted = 0 AND strain_id = #{strainId} AND product_id = #{productId}
+        WHERE is_deleted = 0 AND strain_id = #{strainId} AND product_id = #{productId} AND fps_id = #{fpsId}
     </select>
 
     <select id="selectBySFId" resultType="org.springblade.modules.processInv.entity.ProcessInv">
         SELECT id,strain_id,product_id,product_inventory_num,create_time,update_user,update_time,status,is_deleted
         FROM sys_process_inv
-        WHERE is_deleted = 0 AND strain_id = #{strainId} AND product_id = #{fpsId}
+        WHERE is_deleted = 0 AND strain_id = #{strainId} AND fps_id = #{fpsId}
     </select>
 
     <insert id="add">
diff --git a/src/main/java/org/springblade/modules/processInv/service/IProcessInvService.java b/src/main/java/org/springblade/modules/processInv/service/IProcessInvService.java
index 9641635..b4ecf19 100644
--- a/src/main/java/org/springblade/modules/processInv/service/IProcessInvService.java
+++ b/src/main/java/org/springblade/modules/processInv/service/IProcessInvService.java
@@ -52,7 +52,7 @@
 	 * @param processId	产品id
 	 * @return
 	 */
-	ProcessInv selectBySPId(String strainId, String processId);
+	ProcessInv selectBySPId(String strainId, String processId,Long fpsId);
 
 	/**
 	 * 彻底删除
diff --git a/src/main/java/org/springblade/modules/processInv/service/impl/ProcessInvServiceImpl.java b/src/main/java/org/springblade/modules/processInv/service/impl/ProcessInvServiceImpl.java
index c0d86ad..18695ec 100644
--- a/src/main/java/org/springblade/modules/processInv/service/impl/ProcessInvServiceImpl.java
+++ b/src/main/java/org/springblade/modules/processInv/service/impl/ProcessInvServiceImpl.java
@@ -69,8 +69,8 @@
 	}
 
 	@Override
-	public ProcessInv selectBySPId(String strainId, String processId) {
-		return baseMapper.selectBySPId(Long.parseLong(strainId),Long.parseLong(processId));
+	public ProcessInv selectBySPId(String strainId, String processId,Long fpsId) {
+		return baseMapper.selectBySPId(Long.parseLong(strainId),Long.parseLong(processId),fpsId);
 	}
 
 	@Override

--
Gitblit v1.9.3