From 58f6d099d3ba1a0c995efc52ba8558be838322d6 Mon Sep 17 00:00:00 2001
From: 354798ggg <1074825718@qq.com>
Date: 星期日, 08 十月 2023 16:32:21 +0800
Subject: [PATCH] 代码优化
---
product-server-project-base/src/main/java/com/product/base/service/MaterialManagerService.java | 4 ++--
1 files changed, 2 insertions(+), 2 deletions(-)
diff --git a/product-server-project-base/src/main/java/com/product/base/service/MaterialManagerService.java b/product-server-project-base/src/main/java/com/product/base/service/MaterialManagerService.java
index 482b519..3865a6c 100644
--- a/product-server-project-base/src/main/java/com/product/base/service/MaterialManagerService.java
+++ b/product-server-project-base/src/main/java/com/product/base/service/MaterialManagerService.java
@@ -43,7 +43,7 @@
*/
public String saveMaterialType(FieldSetEntity fse) {
if (BaseUtil.strIsNull(fse.getUUID())) {
- FieldSetEntity fseMaxValue = baseDao.getFieldSetEntityBySQL("SELECT (MAX(material_type_value) + 1) material_type_value FROM product_project_base_material_type", new Object[] {}, false);
+ FieldSetEntity fseMaxValue = baseDao.getFieldSetEntityBySQL("SELECT IFNULL((MAX(material_type_value) + 1),0) material_type_value FROM product_project_base_material_type", new Object[] {}, false);
fse.setValue(CmnConst.MATERIAL_TYPE_VALUE, fseMaxValue.getString(CmnConst.MATERIAL_TYPE_VALUE));
} else {
if ("0".equals(fse.getString(CmnConst.IS_USED))) {
@@ -62,7 +62,7 @@
}
baseDao.saveFieldSetEntity(fse);
return fse.getUUID();
- }
+ }
/**
* 鍒嗛〉鑾峰彇鏉愭枡淇℃伅
--
Gitblit v1.9.2