From 82c1b82a6d46620a5ae493353c37d40da691f716 Mon Sep 17 00:00:00 2001
From: lyh <925863403@qq.com>
Date: 星期四, 11 九月 2025 10:57:03 +0800
Subject: [PATCH] 优化sql
---
lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java | 6 +++++-
1 files changed, 5 insertions(+), 1 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java
index 377f682..0b25e95 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/eam/controller/EamSparePartsController.java
@@ -64,7 +64,11 @@
QueryWrapper<EamSparePartInventory> wrapper = new QueryWrapper<>();
wrapper.eq("spare_part_id",record.getId()).select("sum(inventory) as inventory");
EamSparePartInventory one = eamSparePartInventoryService.getOne(wrapper);
- record.setTotalQuantity(one.getInventory().toString());
+ if(one == null){
+ record.setTotalQuantity("0");
+ }else{
+ record.setTotalQuantity(one.getInventory().toString());
+ }
}
return Result.OK(pageList);
}
--
Gitblit v1.9.3