From 5a075cfe18c3d910ecad5e6e65b4c5c519276663 Mon Sep 17 00:00:00 2001
From: whycxzp <perryhsu@163.com>
Date: 星期五, 09 九月 2022 16:46:31 +0800
Subject: [PATCH] 更新软件适用机型
---
src/main/java/com/whyc/service/SoftwareService.java | 24 ++++++++++++++++++++++++
1 files changed, 24 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/whyc/service/SoftwareService.java b/src/main/java/com/whyc/service/SoftwareService.java
index a795e7a..e916675 100644
--- a/src/main/java/com/whyc/service/SoftwareService.java
+++ b/src/main/java/com/whyc/service/SoftwareService.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;
@@ -21,6 +22,7 @@
import org.springframework.beans.BeanUtils;
import org.springframework.beans.factory.annotation.Autowired;
import org.springframework.stereotype.Service;
+import org.springframework.transaction.annotation.Transactional;
import org.springframework.web.multipart.MultipartFile;
import javax.servlet.http.HttpServletRequest;
@@ -198,4 +200,26 @@
private void insertBatch(List<Software> softwareList){
mapper.insertBatchSomeColumn(softwareList);
}
+
+ @Transactional
+ public Response updateApplyModel(List<Software> softwareList) {
+ QueryWrapper<Software> query = Wrappers.query();
+ query.eq("file_name",softwareList.get(0).getFileName()).last(" limit 1");
+ Software softwareDB = mapper.selectOne(query);
+ if(softwareDB == null){
+ return new Response().set(1,false,"瀵瑰簲鐨勮蒋浠跺苟鏈笂浼犺繃,鏃犳硶鏇存柊閫傜敤鏈哄瀷");
+ }else{
+ //鍏堝垹闄ゅ搴旂殑閫傜敤鏈哄瀷,鍐嶆柊澧為�傜敤鏈哄瀷璁板綍
+ UpdateWrapper<Software> update = Wrappers.update();
+ update.eq("file_name",softwareDB.getFileName());
+ mapper.delete(update);
+ softwareList.forEach(software -> {
+ software.setFileUrl(softwareDB.getFileUrl());
+ software.setExcelUrl(softwareDB.getExcelUrl());
+ software.setCreateTime(new Date());
+ });
+ mapper.insertBatchSomeColumn(softwareList);
+ return new Response().set(1,true,"鏇存柊瀹屾垚");
+ }
+ }
}
--
Gitblit v1.9.1