From f2f83ca83f31f9a9cd0e78d394000c08f5434cdd Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期五, 19 七月 2024 13:35:31 +0800
Subject: [PATCH] zjh 2024/07/19-1
---
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java | 58 +++++++++++++++++++++++++++++++++++++++++++++++++++-------
1 files changed, 51 insertions(+), 7 deletions(-)
diff --git a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
index 6e95761..24c35cf 100644
--- a/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
+++ b/ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java
@@ -2,16 +2,22 @@
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.ltkj.common.core.domain.AjaxResult;
-import com.ltkj.hosp.mapper.LtkjExamJcbgdMapper;
import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
-import com.ltkj.hosp.service.LtkjExamJcbgdService;
import com.ltkj.hosp.service.LtkjExamJcsqdService;
-import com.ltkj.hosp.sqlDomain.LtkjExamJcbgd;
import com.ltkj.hosp.sqlDomain.LtkjExamJcsqd;
-import com.ltkj.hosp.sqlDomain.LtkjHysqd;
+import org.springframework.beans.factory.annotation.Autowired;
+import org.springframework.beans.factory.annotation.Qualifier;
+import org.springframework.jdbc.core.JdbcTemplate;
+import org.springframework.jdbc.core.namedparam.MapSqlParameterSource;
+import org.springframework.jdbc.core.namedparam.NamedParameterJdbcTemplate;
+import org.springframework.jdbc.core.namedparam.SqlParameterSource;
import org.springframework.stereotype.Service;
import javax.annotation.Resource;
+import javax.sql.DataSource;
+import java.sql.*;
+import java.util.ArrayList;
+import java.util.HashMap;
import java.util.List;
import java.util.Map;
@@ -26,6 +32,10 @@
@Resource
private LtkjExamJcsqdMapper mapper;
+
+ @Qualifier(value = "slaveHisDataSource")
+ @Autowired
+ private DataSource dataSource;
@Override
@@ -48,9 +58,43 @@
mapper.saveLtkjExamJcsqd(tjh);
}
+// @Override
+// public AjaxResult getTjJcProByHisCall(String ksmc,String strIn,String brid,int pagecount,int page,String status) {
+// List<Map<String, Object>> tjJcProByHisCall = mapper.getTjJcProByHisCall(ksmc,strIn,brid,pagecount,page,status);
+// return AjaxResult.success().put("data",tjJcProByHisCall);
+// }
+
+
@Override
- public AjaxResult getTjJcProByHisCall(Map<String, Object> map) {
- List<Map<String, Object>> tjJcProByHisCall = mapper.getTjJcProByHisCall(map);
- return AjaxResult.success().put("data",tjJcProByHisCall);
+ public AjaxResult getTjJcProByHisCall(String ksmc,String strIn,String brid,int pagecount,int page,String status) {
+ String sql="{exec usp_his_getexamreportinfo(?,?,?,?,?,?)}";
+ Connection connection = null;
+ List<Map<String,Object>> list=new ArrayList<>();
+ try {
+ connection = dataSource.getConnection();
+ CallableStatement call = connection.prepareCall(sql);
+ call.setString(1,ksmc);
+ call.setString(2,strIn);
+ call.setString(3,brid);
+ call.setInt(4,pagecount);
+ call.setInt(5,page);
+ call.setString(6,status);
+ call.execute();
+ ResultSet query = call.executeQuery();
+ ResultSetMetaData data = query.getMetaData();
+ int count = data.getColumnCount();
+ while (query.next()) {
+ Map<String,Object>map=new HashMap<>();
+ for (int i = 0; i < count; i++) {
+ String s = data.getColumnLabel(i);
+ Object object = query.getObject(i);
+ map.put(s,object);
+ }
+ list.add(map);
+ }
+ } catch (SQLException throwables) {
+ throwables.printStackTrace();
+ }
+ return AjaxResult.success().put("data",list);
}
}
--
Gitblit v1.8.0