From e78e79a565184e0d89124abbcb5bf3200c2cb8f6 Mon Sep 17 00:00:00 2001
From: zenglf <18502938215@163.com>
Date: 星期一, 04 九月 2023 14:19:43 +0800
Subject: [PATCH] 增加数据库厂商标识 ，支持在SQL中设置不同数据databaseId,进行多数据库支持。（主要用于应对不同数据库间的函数差异）
---
lxzn-module-eam/src/main/java/org/jeecg/modules/spare/controller/SparePartController.java | 35 ++++++++++++++++++++++-------------
1 files changed, 22 insertions(+), 13 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 a3ed76e..0cba905 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
@@ -56,6 +56,7 @@
private IConstructorService constructorService;
@Autowired
private IUnitService unitService;
+
/**
* 鍒嗛〉鍒楄〃鏌ヨ
*
@@ -233,31 +234,39 @@
for (int i = 0; i < list.size(); i++) {
SparePart sparePart = list.get(i);
- String constructorName=sparePart.getConstructorId();
+ String constructorName = sparePart.getConstructorId();
String mainUnitName = sparePart.getMainUnitId();
- String validityPeriodUnitName= sparePart.getValidityPeriodUnitId();
- Constructor constructor = constructorService.getByName(constructorName);
+ String validityPeriodUnitName = sparePart.getValidityPeriodUnitId();
+ Constructor constructor = constructorService.getByName(constructorName);
Unit unit = unitService.getUnitByName(mainUnitName);
Unit validityPeriodUnit = unitService.getUnitByName(validityPeriodUnitName);
- if (!StringUtils.isNotEmpty(validityPeriodUnit.getId()))
- return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屾湁鏁堟湡鍗曚綅涓嶅瓨鍦�");
- if (!StringUtils.isNotEmpty(constructor.getId()))
- return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽埗閫犲晢涓嶅瓨鍦�");
- if (!StringUtils.isNotEmpty(unit.getId()))
- return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽崟浣嶄笉瀛樺湪");
+
+
+ if (unit != null) {
+ if (!StringUtils.isNotEmpty(validityPeriodUnit.getId()))
+ return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屾湁鏁堟湡鍗曚綅涓嶅瓨鍦�");
+ list.get(i).setValidityPeriodUnitId(validityPeriodUnit.getId());
+ }
+ if (constructor != null) {
+ if (!StringUtils.isNotEmpty(constructor.getId()))
+ return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽埗閫犲晢涓嶅瓨鍦�");
+ list.get(i).setConstructorId(constructor.getId());
+ }
+ if (unit != null) {
+ if (!StringUtils.isNotEmpty(unit.getId()))
+ return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽崟浣嶄笉瀛樺湪");
+ list.get(i).setMainUnitId(unit.getId());
+ }
if (!StringUtils.isNotEmpty(sparePart.getName()))
return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽浠跺悕绉颁笉鑳戒负绌�");
if (!StringUtils.isNotEmpty(sparePart.getNum()))
return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽浠剁紪鐮佷笉鑳戒负绌�");
if (!StringUtils.isNotEmpty(sparePart.getSpecification()))
return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽浠惰鏍间笉鑳戒负绌�");
+
if (!StringUtils.isNotEmpty(sparePart.getModel()))
return Result.error("鏂囦欢瀵煎叆澶辫触: 绗�" + (i + 1) + "琛屽浠跺瀷鍙蜂笉鑳戒负绌�");
- list.get(i).setConstructorId(constructor.getId());
- list.get(i).setMainUnitId(unit.getId());
- list.get(i).setValidityPeriodUnitId(validityPeriodUnit.getId());
}
-
sparePartService.saveBatch(list);
log.info("娑堣�楁椂闂�" + (System.currentTimeMillis() - start) + "姣");
return Result.OK("鏂囦欢瀵煎叆鎴愬姛锛佹暟鎹鏁帮細" + list.size());
--
Gitblit v1.9.3