From d9c38fdd6af4285e38cbd3917352ff3fea18ea2c Mon Sep 17 00:00:00 2001
From: houjie <714924425@qq.com>
Date: 星期一, 21 八月 2023 09:43:00 +0800
Subject: [PATCH] 设备使用 优化sql查询语句
---
lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparePartController.java | 8 ++++----
1 files changed, 4 insertions(+), 4 deletions(-)
diff --git a/lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparePartController.java b/lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparePartController.java
index 0424252..bfdd198 100644
--- a/lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparePartController.java
+++ b/lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparePartController.java
@@ -110,9 +110,9 @@
.eq("del_flag", 0);
wrapper.select("sum(main_quantity) as totalMainQuantity");
Map<String, Object> map = sparesPartInventoryService.getMap(wrapper);
- Double totalMainQuantity = new Double(0);
+ BigDecimal totalMainQuantity = new BigDecimal(0);
if (map != null) {
- totalMainQuantity = (Double)map.get("totalMainQuantity");
+ totalMainQuantity = (BigDecimal)map.get("totalMainQuantity");
}
record.setTotalMainQuantity(totalMainQuantity);
@@ -120,9 +120,9 @@
.eq("del_flag", 0);
wrapper.select("sum(auxiliary_quantity) as totalAuxiliaryQuantity");
Map<String, Object> map2 = sparesPartInventoryService.getMap(wrapper);
- Double totalAuxiliaryQuantity = new Double(0);
+ BigDecimal totalAuxiliaryQuantity = new BigDecimal(0);
if (map != null) {
- totalAuxiliaryQuantity = (Double)map2.get("totalAuxiliaryQuantity");
+ totalAuxiliaryQuantity = (BigDecimal)map2.get("totalAuxiliaryQuantity");
}
record.setTotalAuxiliaryQuantity(totalAuxiliaryQuantity);
--
Gitblit v1.9.3