zjh20250120

zjh

2025-01-20 73a816fd2b1e29c25d615c85ce34b12b55c16ccf

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

@@ -75,8 +75,23 @@
    List<TjRules> getTjRulesListByTjNumAndProId(@Param("tjNum") String tjNum,@Param("proId") Long proId);


    @Select("SELECT a.advice_bt bt, a.advice_nr nr FROM tj_rules a JOIN tj_project b ON b.pro_id=a.pro_id\n" +
            "         \n" +
            "            WHERE (b.lis_xmbm= #{xmbm} OR a.pro_id=#{proId}) AND a.sign= #{ycbz}")
    List<Map<String,Object>> getyichangxiangmujianyiguize(@Param("xmbm") String xmbm,@Param("proId") String proId,@Param("ycbz") String ycbz);
//    @Select("SELECT a.advice_bt bt, a.advice_nr nr FROM tj_rules a JOIN tj_project b ON b.pro_id=a.pro_id\n" +
//            "         \n" +
//            "            WHERE (b.lis_xmbm= #{xmbm} OR a.pro_id=#{proId}) AND a.sign= #{ycbz}")
    List<Map<String,Object>> getyichangxiangmujianyiguize(Map<String, Object> map);


        @Select("call tj_ycjgjy(\n" +
                "                #{xmbm,mode=IN,jdbcType=VARCHAR},\n" +
                "                #{proId,mode=IN,jdbcType=VARCHAR},\n" +
                "                #{ycbz,mode=IN,jdbcType=VARCHAR},\n" +
                "                #{tjnum,mode=IN,jdbcType=VARCHAR}," +
                "                #{xmm,mode=IN,jdbcType=VARCHAR}," +
                "                #{jyjg,mode=IN,jdbcType=VARCHAR} )")
    List<Map<String,Object>> getyichangxiangmujianyiguize1(@Param("xmbm") String xmbm,@Param("proId")String proId,
                                                           @Param("ycbz")String ycbz,@Param("tjnum")String tjnum,@Param("xmm") String xmm,@Param("jyjg") String jyjg);

    @Select("call tj_ycjgjy_jc(\n" +
            "                #{jcjg,mode=IN,jdbcType=VARCHAR} )")
    Map<String, Object> getyichangxiangmujianyiguizeJianCha(String jcjg);
}