增加公共组件HIS请求管理表

zhaowenxuan

2025-05-19 2b97a88ceb6e9d44505b8bfa64fe6ec79ea35166

增加公共组件HIS请求管理表

 src/main/java/com/example/domain/DictCommonHisConfig.java

New file
@@ -0,0 +1,105 @@
package com.example.domain;

import com.baomidou.mybatisplus.annotation.IdType;
import com.baomidou.mybatisplus.annotation.TableField;
import com.baomidou.mybatisplus.annotation.TableId;
import com.baomidou.mybatisplus.annotation.TableName;
import java.io.Serializable;
import lombok.Data;

/**
 *
 * @TableName dict_common_his_config
 */
@TableName(value ="dict_common_his_config")
@Data
public class DictCommonHisConfig implements Serializable {
    /**
     *
     */
    @TableId(type = IdType.AUTO)
    private Integer id;

    /**
     *
     */
    private String fullKey;

    /**
     *
     */
    private String province;

    /**
     *
     */
    private String region;

    /**
     *
     */
    private String city;

    /**
     *
     */
    private String hospital;

    /**
     *
     */
    private String tjUrl;

    /**
     *
     */
    private String hisApiUrl;

    /**
     *
     */
    private Integer hisApiPort;

    /**
     *
     */
    private String hisApiAppend;

    /**
     *
     */
    private String czy;

    /**
     *
     */
    private String czyId;

    /**
     *
     */
    private String dbIp;

    /**
     *
     */
    private Integer dbPort;

    /**
     *
     */
    private String dbName;

    /**
     *
     */
    private String dbUser;

    /**
     *
     */
    private String dbPassword;

    @TableField(exist = false)
    private String hisUrl;
}

 src/main/java/com/example/mapper/DictCommonHisConfigMapper.java

New file
@@ -0,0 +1,18 @@
package com.example.mapper;

import com.example.domain.DictCommonHisConfig;
import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
* @author w
* @description 针对表【dict_common_his_config】的数据库操作Mapper
* @createDate 2025-05-19 15:56:34
* @Entity com.example.domain.DictCommonHisConfig
*/
public interface DictCommonHisConfigMapper extends BaseMapper<DictCommonHisConfig> {

}





 src/main/java/com/example/service/DictCommonHisConfigService.java

New file
@@ -0,0 +1,14 @@
package com.example.service;

import com.example.domain.DictCommonHisConfig;
import com.baomidou.mybatisplus.extension.service.IService;

/**
* @author w
* @description 针对表【dict_common_his_config】的数据库操作Service
* @createDate 2025-05-19 15:56:34
*/
public interface DictCommonHisConfigService extends IService<DictCommonHisConfig> {
    DictCommonHisConfig getConfigByHospital(String id);
    String getConfigValByHospitalAndKey(String hospital,String key);
}

 src/main/java/com/example/service/impl/DictCommonHisConfigServiceImpl.java

New file
@@ -0,0 +1,48 @@
package com.example.service.impl;

import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper;
import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl;
import com.example.domain.DictCommonHisConfig;
import com.example.service.DictCommonHisConfigService;
import com.example.mapper.DictCommonHisConfigMapper;
import org.springframework.stereotype.Service;

/**
* @author w
* @description 针对表【dict_common_his_config】的数据库操作Service实现
* @createDate 2025-05-19 15:56:34
*/
@Service
public class DictCommonHisConfigServiceImpl extends ServiceImpl<DictCommonHisConfigMapper, DictCommonHisConfig>
    implements DictCommonHisConfigService{

    @Override
    public DictCommonHisConfig getConfigByHospital(String id) {
        LambdaQueryWrapper<DictCommonHisConfig> wrapper = new LambdaQueryWrapper<>();
        wrapper.eq(DictCommonHisConfig::getHospital,id);
        DictCommonHisConfig config = baseMapper.selectOne(wrapper);
        config.setHisUrl(config.getHisApiUrl()+":"+config.getHisApiPort()+config.getHisApiAppend());
        return config;
    }

    @Override
    public String getConfigValByHospitalAndKey(String hospital, String key) {
        DictCommonHisConfig config = getConfigByHospital(hospital);
        if (config != null){
            switch (key){
                case "HIS_URL":
                    return config.getHisApiUrl()+":"+config.getHisApiPort()+config.getHisApiAppend();
                case "TJ_URL":
                    return config.getTjUrl();
                case "CZY":
                    return config.getCzyId();
                default:
                    return null;
            }
        }else return null;
    }
}





 src/main/resources/mapper/DictCommonHisConfigMapper.xml

New file
@@ -0,0 +1,35 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper
        PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN"
        "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.example.mapper.DictCommonHisConfigMapper">

    <resultMap id="BaseResultMap" type="com.example.domain.DictCommonHisConfig">
            <id property="id" column="id" jdbcType="INTEGER"/>
            <result property="fullKey" column="full_key" jdbcType="VARCHAR"/>
            <result property="province" column="province" jdbcType="VARCHAR"/>
            <result property="region" column="region" jdbcType="VARCHAR"/>
            <result property="city" column="city" jdbcType="VARCHAR"/>
            <result property="hospital" column="hospital" jdbcType="VARCHAR"/>
            <result property="tjUrl" column="tj_url" jdbcType="VARCHAR"/>
            <result property="hisApiUrl" column="his_api_url" jdbcType="VARCHAR"/>
            <result property="hisApiPort" column="his_api_port" jdbcType="SMALLINT"/>
            <result property="hisApiAppend" column="his_api_append" jdbcType="VARCHAR"/>
            <result property="czy" column="czy" jdbcType="VARCHAR"/>
            <result property="czyId" column="czy_id" jdbcType="VARCHAR"/>
            <result property="dbIp" column="db_ip" jdbcType="VARCHAR"/>
            <result property="dbPort" column="db_port" jdbcType="SMALLINT"/>
            <result property="dbName" column="db_name" jdbcType="VARCHAR"/>
            <result property="dbUser" column="db_user" jdbcType="VARCHAR"/>
            <result property="dbPassword" column="db_password" jdbcType="VARCHAR"/>
    </resultMap>

    <sql id="Base_Column_List">
        id,full_key,province,
        region,city,hospital,
        tj_url,his_api_url,his_api_port,
        his_api_append,czy,czy_id,
        db_ip,db_port,db_name,
        db_user,db_password
    </sql>
</mapper>