From 2262618a51134d89b0d9390eaff152c7a9dc1f5d Mon Sep 17 00:00:00 2001
From: whyclxw <810412026@qq.com>
Date: 星期五, 20 六月 2025 11:42:17 +0800
Subject: [PATCH] Merge branch 'master' of http://118.89.139.230:10101/r/powerIntelligenceSystem
---
src/main/java/com/whyc/service/DeviceSpareService.java | 29 +++++++++++++++++++++++++++++
1 files changed, 29 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/DeviceSpareService.java b/src/main/java/com/whyc/service/DeviceSpareService.java
index 86e560d..5dd1598 100644
--- a/src/main/java/com/whyc/service/DeviceSpareService.java
+++ b/src/main/java/com/whyc/service/DeviceSpareService.java
@@ -1,6 +1,7 @@
package com.whyc.service;
import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper;
+import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper;
import com.baomidou.mybatisplus.core.toolkit.Wrappers;
import com.github.pagehelper.PageHelper;
import com.github.pagehelper.PageInfo;
@@ -158,4 +159,32 @@
List<DeviceSpare> deviceSpares = mapper.selectList(query);
return new Response<List<DeviceSpare>>().set(1,deviceSpares);
}
+
+ public void add(List<DeviceSpare> spareList) {
+ mapper.insertBatchSomeColumn(spareList);
+ }
+
+ public void addOrUpdate(List<DeviceSpare> spareList) {
+ //鏌ヨ搴撲腑鏄惁瀛樺湪璇ヨ澶�,瀛樺湪鍒欏鍔犳暟閲�.
+ for (DeviceSpare spare : spareList) {
+ QueryWrapper<DeviceSpare> query = Wrappers.query();
+ query.eq("name",spare.getName());
+ query.eq("model",spare.getModel());
+ query.eq("version",spare.getVersion());
+ query.eq("brand",spare.getBrand());
+ query.eq("type",spare.getType());
+ query.eq("supplier",spare.getSupplier());
+ query.last(" limit 1");
+ DeviceSpare spareInDB = mapper.selectOne(query);
+ if(spareInDB != null){
+ spareInDB.setQuantity(spareInDB.getQuantity()+spare.getQuantity());
+ mapper.updateById(spareInDB);
+
+ }else{
+ //涓嶅瓨鍦ㄥ垯鏂板
+ mapper.insert(spare);
+ }
+ }
+
+ }
}
--
Gitblit v1.9.1