20250102

zhaowenxuan

2025-01-02 53fd938642819ae69b1980126aa456d9a6cfd430

20250102

 ltkj-hosp/src/main/java/com/ltkj/hosp/mapper/TjProjectMapper.java

@@ -197,4 +197,6 @@

    void zdysqlxg(Map<String,Object> map);

    List<Map<String ,Object>> getLisViewList();

}

 ltkj-hosp/src/main/resources/mapper/TjProjectMapper.xml

@@ -227,4 +227,7 @@
                #{aaa,mode=IN,jdbcType=VARCHAR}
        )}
    </select>
    <select id="getLisViewList" resultType="java.util.Map">
        SELECT * FROM `v_examitem`
    </select>
</mapper>

 ltkj-hosp/src/main/resources/mapper/hosp/TjSamplingMapper.xml

@@ -26,6 +26,8 @@
        <result property="isMerge" column="is_merge"/>
        <result property="jyxmdm" column="jyxmdm"/>
        <result property="jxbz" column="jxbz"/>
        <result property="createId" column="create_id"/>
        <result property="updateId" column="update_id"/>
    </resultMap>

    <sql id="selectTjSamplingVo">
@@ -49,7 +51,9 @@
               specimen_type_code,
               is_merge,
               jyxmdm,
               jxbz
               jxbz,
               create_id,
               update_id
        from tj_sampling
    </sql>

@@ -137,6 +141,10 @@
            </if>
            <if test="jxbz != null">jxbz,
            </if>
            <if test="createId != null">create_id,
            </if>
            <if test="updateId != null">update_id,
            </if>
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="id != null">#{id},
@@ -180,6 +188,10 @@
            <if test="jyxmdm != null">#{jyxmdm},
            </if>
            <if test="jxbz != null">#{jxbz},
            </if>
            <if test="createId != null">#{createId},
            </if>
            <if test="updateId != null">#{updateId},
            </if>
        </trim>
    </insert>
@@ -246,6 +258,10 @@
            <if test="jxbz != null">jxbz =
                #{jxbz},
            </if>
            <if test="createId != null">create_id = #{createId},
            </if>
            <if test="updateId != null">update_id = #{updateId},
            </if>
        </trim>
        where id = #{id}
    </update>