From 73a816fd2b1e29c25d615c85ce34b12b55c16ccf Mon Sep 17 00:00:00 2001
From: zjh <1084500556@qq.com>
Date: 星期一, 20 一月 2025 13:41:45 +0800
Subject: [PATCH] zjh20250120
---
ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java | 94 ++++++++++++++++++++++++++++++++++++++++++++++-
1 files changed, 92 insertions(+), 2 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 e3ab2cc..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,13 +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 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涓氬姟灞傚鐞�
@@ -16,6 +30,82 @@
* @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
+ public LtkjExamJcsqd getLtkjJcsqdByTjhAndTmh(String tjh, String tmh) {
+ return mapper.getLtkjJcsqdByTjhAndTmh(tjh,tmh);
+ }
+
+ @Override
+ public void deletedLtkjJcsqdByTjhAndTmh(String tjh) {
+ mapper.deletedLtkjJcsqdByTjhAndTmh(tjh);
+ }
+
+ @Override
+ public List<LtkjExamJcsqd> getLtkjJcsqdByTjh(String tjh) {
+ return mapper.getLtkjJcsqdByTjh(tjh);
+ }
+
+ @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