zjh20241205-3

zjh

2024-12-06 c42f62b32bac302a7ac9fcde7489f7c5fc6e11aa

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

@@ -3,10 +3,14 @@
import java.util.List;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ltkj.hosp.domain.DictZhengzhuang;
import com.ltkj.hosp.domain.TjAskMedicalHistory;
import com.ltkj.hosp.domain.TjAskHistorys;
import com.ltkj.hosp.domain.TjCatering;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;
import org.apache.ibatis.annotations.Update;

/**
 * 问诊Mapper接口
@@ -88,4 +92,28 @@
         * @return 结果
         */
        public int deleteTjAskHistorysByAskId(Long askId);

    @Update("UPDATE tj_ask_medical_history a SET \n" +
            "\n" +
            "a.tj_num=#{tjNum},\n" +
            "a.update_time=SYSDATE(),\n" +
            "a.update_by=#{userName},\n" +
            "a.update_id=#{userId}\n" +

            "WHERE" +

            " a.cus_id=#{cusId} \n" +
            "AND ISNULL(a.tj_num)")
    boolean updateTjAskMedicalHistoryByCusId(@Param("tjNum") String tjNum,@Param("userName") String userName,@Param("userId") String userId,@Param("cusId") String cusId);



    @Select("SELECT * FROM dict_zhengzhuang")
    List<DictZhengzhuang> getZhengZhuang();



//    @Select("SELECT * FROM tj_ask_medical_history a WHERE a.deleted=0 AND a.tj_num=#{tjNum}")
    TjAskMedicalHistory selectTjAskMedicalHistoryByTjNum(String tjNum);

}