From bdeb03a42dace46b1211bf12f3ad66837814035d Mon Sep 17 00:00:00 2001
From: kongdeqiang <123456>
Date: 星期一, 23 三月 2026 11:39:01 +0800
Subject: [PATCH] feat: 更新系统
---
src/main/java/com/example/service/impl/DataExcelServiceImpl.java | 19 ++++++++++---------
1 files changed, 10 insertions(+), 9 deletions(-)
diff --git a/src/main/java/com/example/service/impl/DataExcelServiceImpl.java b/src/main/java/com/example/service/impl/DataExcelServiceImpl.java
index 7d99fd8..634bb2f 100644
--- a/src/main/java/com/example/service/impl/DataExcelServiceImpl.java
+++ b/src/main/java/com/example/service/impl/DataExcelServiceImpl.java
@@ -22,12 +22,12 @@
public class DataExcelServiceImpl extends ServiceImpl<DataExcelMapper, DataExcel> implements DataExcelService {
@Override
- public IPage<DataExcel> getDataExcelPage(Long current, Long size, String unitName, String transactionNo, String accountingPeriod, List<String> permissionDeptCodes) {
+ public IPage<DataExcel> getDataExcelPage(Long current, Long size, String unitCode, String transactionNo, String accountingPeriod, List<String> permissionDeptCodes) {
Page<DataExcel> page = new Page<>(current, size);
page.setOptimizeJoinOfCountSql(false);
page.setOptimizeCountSql(false);
LambdaQueryWrapper<DataExcel> wrapper = new LambdaQueryWrapper<>();
- wrapper.like(unitName != null && !unitName.isEmpty(), DataExcel::getUnitName, unitName)
+ wrapper.eq(unitCode != null && !unitCode.isEmpty(), DataExcel::getUnitCode, unitCode)
.like(transactionNo != null && !transactionNo.isEmpty(), DataExcel::getTransactionNo, transactionNo)
.eq(accountingPeriod != null && !accountingPeriod.isEmpty(), DataExcel::getAccountingPeriod, accountingPeriod)
.in(permissionDeptCodes != null && !permissionDeptCodes.isEmpty(), DataExcel::getUnitCode, permissionDeptCodes)
@@ -41,6 +41,7 @@
List<DataExcel> updateList = new ArrayList<>();
List<String> errorMsgs = new ArrayList<>();
int[] counts = new int[2];
+ int[] counts2 = new int[2];
try {
EasyExcel.read(file.getInputStream(), DataExcelImport.class, new ReadListener<DataExcelImport>() {
@@ -54,7 +55,7 @@
errorMsgs.add("绗�" + data.getSeqNo() + "琛屾棤鏉冮檺瀵煎叆閮ㄩ棬缂栫爜: " + data.getUnitCode());
return;
}
-
+
DataExcel entity = new DataExcel();
entity.setSortNo(data.getSortNo());
entity.setSeqNo(data.getSeqNo());
@@ -73,13 +74,13 @@
entity.setBusinessRelation(data.getBusinessRelation());
entity.setRemark(data.getRemark());
entity.setStatus(1);
-
+
if (data.getSortNo() != null) {
DataExcel existData = baseMapper.selectBySortNo(data.getSortNo());
if (existData != null) {
entity.setId(existData.getId());
updateList.add(entity);
- counts[1]++;
+ counts2[0]++;
} else {
insertList.add(entity);
counts[0]++;
@@ -109,11 +110,11 @@
if (counts[0] > 0) {
result.append("鎴愬姛鏂板 ").append(counts[0]).append(" 鏉¤褰�");
}
- if (counts[1] > 0) {
+ if (counts2[0] > 0) {
if (result.length() > 0) {
result.append("锛�");
}
- result.append("鎴愬姛鏇存柊 ").append(counts[1]).append(" 鏉¤褰�");
+ result.append("鎴愬姛鏇存柊 ").append(counts2[0]).append(" 鏉¤褰�");
}
if (!errorMsgs.isEmpty()) {
if (result.length() > 0) {
@@ -121,11 +122,11 @@
}
result.append("瀵煎叆閮ㄥ垎澶辫触: ").append(String.join(", ", errorMsgs));
}
-
+
if (result.length() == 0) {
return "瀵煎叆澶辫触";
}
-
+
return result.toString();
}
}
--
Gitblit v1.9.1