Merge remote-tracking branch 'origin/master'

zhaowenxuan

7 天以前 0892d843cd394f383ff50f480f7f22f2ec3829bc

 ltkj-hosp/src/main/java/com/ltkj/hosp/service/impl/LtkjExamJcsqdServiceImpl.java

@@ -4,7 +4,9 @@
import com.ltkj.common.core.domain.AjaxResult;
import com.ltkj.hosp.mapper.LtkjExamJcsqdMapper;
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;
@@ -28,6 +30,7 @@
 * @date 2023-08-30
 */
@Service
@Slf4j
public class LtkjExamJcsqdServiceImpl extends ServiceImpl<LtkjExamJcsqdMapper, LtkjExamJcsqd> implements LtkjExamJcsqdService {

    @Resource
@@ -44,8 +47,28 @@
    }

    @Override
    public void deletedLtkjJcsqdByTjhAndTmh(String tjh, String tmh) {
            mapper.deletedLtkjJcsqdByTjhAndTmh(tjh,tmh);
    public void deletedLtkjJcsqdByTjhAndXmId(String tjh,String xmid) {
        mapper.deletedLtkjJcsqdByTjhAndProId(tjh,xmid);
    }

    @Override
    public void deletedLtkjJcsqdByTjhAndTmh(String tjh) {
            mapper.deletedLtkjJcsqdByTjhAndTmh(tjh);
    }

    @Override
    public void deletedLtkjJcsqdByTjhandtmh(String tjh, String tmh) {
        mapper.deletedLtkjJcsqdByTjhandtmh(tjh,tmh);
    }

    @Override
    public void sdtbdeletedLtkjJcsqdByTjhandtmh(String tjh, String tmh) {
        mapper.sdtbdeletedLtkjJcsqdByTjhandtmh(tjh,tmh);
    }

    @Override
    public void deletedLtkjJcsqdByTjhandtmh1(String tjh) {
        mapper.deletedLtkjJcsqdByTjhandtmh1(tjh);
    }

    @Override
@@ -54,47 +77,60 @@
    }

    @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 void saveXdtLtkjExamJcsqd(String tjh, String tmh) {
        mapper.saveXdtLtkjExamJcsqd(tjh,tmh);
    }

    @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();
            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);
        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);
//    }
}