From fc8a5f61874a2f2c40f470d745fff0072d49d9c6 Mon Sep 17 00:00:00 2001
From: 13693261870 <252740454@qq.com>
Date: 星期四, 05 十月 2023 17:25:41 +0800
Subject: [PATCH] 完成入库代码

---
 src/main/java/com/smartearth/poiexcel/service/EntService.java |  109 +++++++++++++++++++++++++++++++++++++++++++++++++++---
 1 files changed, 102 insertions(+), 7 deletions(-)

diff --git a/src/main/java/com/smartearth/poiexcel/service/EntService.java b/src/main/java/com/smartearth/poiexcel/service/EntService.java
index 218c467..ab9f5c3 100644
--- a/src/main/java/com/smartearth/poiexcel/service/EntService.java
+++ b/src/main/java/com/smartearth/poiexcel/service/EntService.java
@@ -1,5 +1,9 @@
 package com.smartearth.poiexcel.service;
 
+import com.alibaba.fastjson.JSONObject;
+import com.google.common.collect.Lists;
+import com.smartearth.poiexcel.entity.*;
+import com.smartearth.poiexcel.mapper.BasicMapper;
 import com.smartearth.poiexcel.mapper.EntMapper;
 import com.smartearth.poiexcel.utils.RestHelper;
 import org.apache.commons.logging.Log;
@@ -12,6 +16,7 @@
 import javax.annotation.Resource;
 import java.lang.reflect.Field;
 import java.util.HashMap;
+import java.util.List;
 import java.util.Map;
 
 /**
@@ -20,12 +25,12 @@
  * @date 2023-10-05
  */
 @Service
-public class EntService implements EntMapper {
+public class EntService {
     @Resource
     EntMapper entMapper;
 
-    @Value("${qylweb.url}")
-    String url;
+    @Value("${qylweb.host}")
+    String host;
 
     @Value("${qylweb.user}")
     String user;
@@ -37,12 +42,102 @@
 
     private final static String generateToken = "%s/yqfwg/app/generateToken";
 
-    private final static String getEntBaseInfo = "%s/yqfwg/api/project/getEntBaseInfoForOtherSysListPage?ctoken=%s&buildDate_startdate=%s&buildDate_enddate=%s&qylabel=%s&showCount=%d&currentPage=%d";
+    private final static String getEntBaseInfo = "%s/yqfwg/api/project/getEntBaseInfoForOtherSysListPage?ctoken=%s&showCount=%d&currentPage=%d";
+
+    /**
+     * 鑾峰彇浠ょ墝
+     */
+    public String selectToken() {
+        try {
+            String url = String.format(generateToken, host);
+
+            Map<String, String> map = new HashMap<>(2);
+            map.put("userName", user);
+            map.put("passWord", pwd);
+            //String map = "userName=shikong001&passWord=123!@#qwe";
+
+            // String str = RestHelper.postForRest(url, map)
+            Result rs = postForRest(url, map, Result.class);
+            if (null == rs || StaticData.I200 != rs.getCode()) {
+                return null;
+            }
+
+            // TokenResult tr = JSONObject.parseObject(rs.getData().toJSONString(), TokenResult.class)
+            TokenResult tr = rs.getData().toJavaObject(TokenResult.class);
+
+            return tr.getCtoken();
+        } catch (Exception ex) {
+            log.error(ex.getMessage(), ex);
+            return null;
+        }
+    }
+
+    /**
+     * 鏌ヨ浼佷笟
+     */
+    public List<EntEntity> selectEnts(String token, String startDate, String endDate, String qylabel, Integer showCount, Integer currentPage) {
+        try {
+            String url = String.format(getEntBaseInfo, host, token, showCount, currentPage);
+            if (null != startDate) {
+                url += "&buildDate_startdate=" + startDate;
+            }
+            if (null != endDate) {
+                url += "&buildDate_enddate=" + endDate;
+            }
+            if (null != qylabel) {
+                url += "&qylabel=" + qylabel;
+            }
+
+            Result rs = getForRest(url, Result.class);
+            if (null == rs || StaticData.I200 != rs.getCode()) {
+                return null;
+            }
+
+            // EntResult er = JSONObject.parseObject(rs.getData().toJSONString(), EntResult.class)
+            EntResult er = rs.getData().toJavaObject(EntResult.class);
+
+            return er.getPd().getList();
+        } catch (Exception ex) {
+            log.error(ex.getMessage(), ex);
+            return null;
+        }
+    }
+
+    /**
+     * 鎻掑叆浼佷笟
+     */
+    public Integer insertEnts(List<EntEntity> list) {
+        try {
+            int rows = 0;
+            List<List<EntEntity>> subLists = Lists.partition(list, StaticData.I200);
+            for (List<EntEntity> sub : subLists) {
+                try {
+                    rows += entMapper.insertBatch(sub);
+                } catch (Exception ex) {
+                    log.error(ex);
+                }
+            }
+
+            return rows;
+        } catch (Exception ex) {
+            log.error(ex.getMessage(), ex);
+            return 0;
+        }
+    }
+
+    /**
+     * get璇锋眰锛圧est锛�
+     */
+    public <T> T getForRest(String url, Class<T> clazz) {
+        RestTemplate rest = RestHelper.getRestTemplate();
+
+        return rest.getForObject(url, clazz);
+    }
 
     /**
      * post璇锋眰锛圧est锛�
      */
-    public <T> T postForRest(String url, Map<String, Object> map, Class<T> clazz) {
+    public <T> T postForRest(String url, Object map, Class<T> clazz) {
         RestTemplate rest = RestHelper.getRestTemplate();
 
         return rest.postForObject(url, map, clazz);
@@ -51,14 +146,14 @@
     /**
      * delete璇锋眰锛圧est锛�
      */
-    public Object deleteForRest(String url, Map<String, Object> map) {
+    public <T> T deleteForRest(String url, Map<String, T> map, Class<T> clazz) {
         HttpHeaders headers = new HttpHeaders();
         headers.setContentType(MediaType.APPLICATION_JSON);
 
         HttpEntity<?> entity = new HttpEntity<>(map, headers);
 
         RestTemplate rest = RestHelper.getRestTemplate();
-        ResponseEntity<Object> rs = rest.exchange(url, HttpMethod.DELETE, entity, Object.class);
+        ResponseEntity<T> rs = rest.exchange(url, HttpMethod.DELETE, entity, clazz);
 
         return rs.getBody();
     }

--
Gitblit v1.9.3