From 43727df73e52cc00a1f1aee3c20a1aec8db1b92f Mon Sep 17 00:00:00 2001
From: zhaowenxuan <chacca165@163.com>
Date: 星期四, 27 二月 2025 08:45:25 +0800
Subject: [PATCH] 修改查询

---
 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java |   73 ++++++++++++++++++++++++++++++++++--
 1 files changed, 68 insertions(+), 5 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 987748f..6182d21 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
@@ -1,17 +1,27 @@
 package com.ltkj.hosp.service.impl;
 
 import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
-import com.ltkj.hosp.mapper.LtkjExamJcbgdMapper;
+import com.ltkj.common.core.domain.AjaxResult;
 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 lombok.extern.slf4j.Slf4j;
+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;
 
 /**
  * 鐥呯+鎰忚Service涓氬姟灞傚鐞�
@@ -20,10 +30,15 @@
  * @date 2023-08-30
  */
 @Service
+@Slf4j
 public class LtkjExamJcsqdServiceImpl extends ServiceImpl<LtkjExamJcsqdMapper, LtkjExamJcsqd> implements LtkjExamJcsqdService {
 
     @Resource
     private LtkjExamJcsqdMapper mapper;
+
+    @Qualifier(value = "slaveHisDataSource")
+    @Autowired
+    private DataSource dataSource;
 
 
     @Override
@@ -32,8 +47,8 @@
     }
 
     @Override
-    public void deletedLtkjJcsqdByTjhAndTmh(String tjh, String tmh) {
-            mapper.deletedLtkjJcsqdByTjhAndTmh(tjh,tmh);
+    public void deletedLtkjJcsqdByTjhAndTmh(String tjh) {
+            mapper.deletedLtkjJcsqdByTjhAndTmh(tjh);
     }
 
     @Override
@@ -42,7 +57,55 @@
     }
 
     @Override
+    public List<LtkjExamJcbgd> queryLtkjExamJcsqdByTjh(String tjh) {
+        return mapper.queryLtkjExamJcsqdByTjh(tjh);
+    }
+
+    @Override
     public void saveLtkjExamJcsqd(String tjh) {
         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(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();
+//            log.info("鏌ヨ妫�鏌ユ姤鍛� ResultSet:   "+query.toString());
+//            ResultSetMetaData data = query.getMetaData();
+//            log.info("鏌ヨ妫�鏌ユ姤鍛� ResultSetMetaData:   "+data.toString());
+//            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();
+//        }
+//        log.info("鏌ヨ妫�鏌ユ姤鍛婅繑鍥炲��:   "+list.toString());
+//        return AjaxResult.success().put("data",list);
+//    }
 }

--
Gitblit v1.8.0