From 5e0261b4ea6c6079683a17d6c3c71fbdeef17e04 Mon Sep 17 00:00:00 2001
From: zhongrj <646384940@qq.com>
Date: Thu, 19 Oct 2023 21:45:45 +0800
Subject: [PATCH] 蓄水方式查询条件调整
---
skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/XsfsQktjServiceImpl.java | 10 +++++++---
1 files changed, 7 insertions(+), 3 deletions(-)
diff --git a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/XsfsQktjServiceImpl.java b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/XsfsQktjServiceImpl.java
index 081d104..89eeab8 100644
--- a/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/XsfsQktjServiceImpl.java
+++ b/skjcmanager/skjcmanager-service/skjcmanager-sm/src/main/java/cn/gistack/sm/sjztods/service/impl/XsfsQktjServiceImpl.java
@@ -13,6 +13,8 @@
import org.springblade.core.tool.utils.BeanUtil;
import org.springframework.stereotype.Service;
+import java.text.ParseException;
+import java.text.SimpleDateFormat;
import java.util.Date;
import java.util.List;
import java.util.Objects;
@@ -91,11 +93,13 @@
data.forEach(xsfsQktjExcel -> {
XsfsQktj xsfsQktj = Objects.requireNonNull(BeanUtil.copy(xsfsQktjExcel, XsfsQktj.class));
// 查询库中是否包含当前日期，当前行政区的数据，如果有，则更新，没有则新增
- QueryWrapper<XsfsQktj> wrapper = new QueryWrapper<>();
- wrapper.eq("\"statistic_time\"",xsfsQktj.getStatisticTime())
- .eq("\"ad_code\"",xsfsQktj.getAdCode());
XsfsQktj qkTj = baseMapper.selectXsfsQktj(xsfsQktjExcel);
// 设置更新人员，更新时间，来源信息
+ try {
+ xsfsQktj.setStatisticTime(new SimpleDateFormat("yyyy-MM-dd").parse(xsfsQktjExcel.getStatisticTime()));
+ } catch (ParseException e) {
+ e.printStackTrace();
+ }
xsfsQktj.setUpdateTime(new Date());
xsfsQktj.setUpdateUser(AuthUtil.getUserId());
xsfsQktj.setSysResource("sb");
--
Gitblit v1.9.3