From c773d0c150a4d90003bc7e3c776fe09e871cab30 Mon Sep 17 00:00:00 2001
From: whycrzg <ruanzhigang@whycst.com>
Date: 星期二, 06 四月 2021 14:12:20 +0800
Subject: [PATCH] 更新试验数据管理

---
 src/main/java/com/whyc/controller/ProjectManageController.java  |   14 +++++---------
 src/main/java/com/whyc/mapper/TestPlanMapper.java               |    4 ++++
 src/main/resources/mapper/TestPlanMapper.xml                    |    4 ++++
 src/main/java/com/whyc/service/ProjectArchiveManageService.java |   28 ++++++++++++++++++++++++++++
 4 files changed, 41 insertions(+), 9 deletions(-)

diff --git a/src/main/java/com/whyc/controller/ProjectManageController.java b/src/main/java/com/whyc/controller/ProjectManageController.java
index 055290c..e2f1c82 100644
--- a/src/main/java/com/whyc/controller/ProjectManageController.java
+++ b/src/main/java/com/whyc/controller/ProjectManageController.java
@@ -276,17 +276,13 @@
 
     /**
      * @param proNameCode
-     * @param proNum
-     * @return  瀹為獙鍚嶇О銆佷笂浼犳棩鏈熴�佸綊妗f棩鏈� (鎿嶄綔TODO)
+     * @return 瀹為獙鍚嶇О銆佽瘯楠屾棩鏈熴�佺粨璁哄瓧娈� etc
      */
     @GetMapping("archiveExperimentData")
-    @ApiOperation(notes = "(鎿嶄綔TODO)",value = "椤圭洰褰掓。绠$悊-璇曢獙鏁版嵁")
-    public Response searchArchiveExperimentData(@ApiParam(value = "椤圭洰鍚嶇О浠g爜", required = true) @RequestParam String proNameCode,
-                                                                 @ApiParam(value = "椤圭洰缂栧彿", required = true) @RequestParam String proNum) {
-        ProjectArchiveManage pam = new ProjectArchiveManage();
-        pam.setProNum(proNum);
-        pam.setProNameCode(proNameCode);
-        return archiveManageService.searchArchiveExperimentData(pam);
+    @ApiOperation(notes = "TODO 鏂囦欢鏍煎紡鍜屼笅杞藉湴鍧�", value = "椤圭洰褰掓。绠$悊-璇曢獙鏁版嵁")
+    public Response searchArchiveExperimentData(@ApiParam(value = "椤圭洰鍚嶇О浠g爜", required = true) @RequestParam String proNameCode) {
+    //TODO fileName file
+        return archiveManageService.searchArchiveExperimentData(proNameCode);
     }
 
     @GetMapping("archiveTechnologicalAchievements")
diff --git a/src/main/java/com/whyc/mapper/TestPlanMapper.java b/src/main/java/com/whyc/mapper/TestPlanMapper.java
index 4666f15..258a802 100644
--- a/src/main/java/com/whyc/mapper/TestPlanMapper.java
+++ b/src/main/java/com/whyc/mapper/TestPlanMapper.java
@@ -2,6 +2,10 @@
 
 import com.whyc.pojo.TestPlan;
 
+import java.util.List;
+
 public interface TestPlanMapper extends CustomMapper<TestPlan> {
 
+    //璇曢獙鏁版嵁
+     List<TestPlan> searchArchiveExperimentData(TestPlan testPlan);
 }
diff --git a/src/main/java/com/whyc/service/ProjectArchiveManageService.java b/src/main/java/com/whyc/service/ProjectArchiveManageService.java
index 977c6e8..b2ee024 100644
--- a/src/main/java/com/whyc/service/ProjectArchiveManageService.java
+++ b/src/main/java/com/whyc/service/ProjectArchiveManageService.java
@@ -5,9 +5,11 @@
 import com.whyc.dto.Response;
 import com.whyc.mapper.ProjectArchiveManageMapper;
 import com.whyc.mapper.ProjectManageMapper;
+import com.whyc.mapper.TestPlanMapper;
 import com.whyc.pojo.ProjectArchiveExperiment;
 import com.whyc.pojo.ProjectArchiveManage;
 import com.whyc.pojo.ProjectManage;
+import com.whyc.pojo.TestPlan;
 import org.springframework.stereotype.Service;
 
 import javax.annotation.Resource;
@@ -23,6 +25,7 @@
 
     @Resource
     private ProjectManageMapper projectManageMapper;
+
 
     public Response searchDocumentation(ProjectArchiveManage pam) {
 
@@ -169,6 +172,7 @@
      * @param pam
      * @return
      */
+    @Deprecated
     public Response searchArchiveExperimentData(ProjectArchiveManage pam) {
         Response<Object> response = new Response<>();
         List<ProjectArchiveExperiment> lists = projectArchiveManageMapper.searchArchiveExperimentData(pam);
@@ -245,4 +249,28 @@
         }
         return response;
     }
+
+
+
+    @Resource
+    private TestPlanMapper testPlanMapper;
+    /**
+     * 椤圭洰褰掓。绠$悊-璇曢獙鏁版嵁绠$悊
+     * @param proNameCode
+     * @return
+     */
+    public Response searchArchiveExperimentData(String proNameCode) {
+        Response<Object> response = new Response<>();
+        try {
+            TestPlan testPlan = new TestPlan();
+            testPlan.setProId(proNameCode);
+            List<TestPlan> lists =  testPlanMapper.searchArchiveExperimentData(testPlan);
+            response.setMsg(1, "鏌ヨ鎴愬姛");
+            response.setData(lists);
+        } catch (Exception e) {
+            e.printStackTrace();
+            return response.setMsg(0, "鏌ヨ澶辫触");
+        }
+        return response;
+    }
 }
diff --git a/src/main/resources/mapper/TestPlanMapper.xml b/src/main/resources/mapper/TestPlanMapper.xml
index d9002da..d222793 100644
--- a/src/main/resources/mapper/TestPlanMapper.xml
+++ b/src/main/resources/mapper/TestPlanMapper.xml
@@ -2,4 +2,8 @@
 <!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
 <mapper namespace="com.whyc.mapper.TestPlanMapper" >
 
+    <select id="searchArchiveExperimentData" resultType="com.whyc.pojo.TestPlan">
+        SELECT plan_name,create_time,conclusion FROM db_experiment.tb_test_plan WHERE pro_id = #{proId}
+
+    </select>
 </mapper>
\ No newline at end of file

--
Gitblit v1.9.1