package com.ltkj.hosp.mapper;
|
|
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接口
|
*
|
* @author ltkj_赵佳豪&李格
|
* @date 2023-04-11
|
*/
|
@Mapper
|
public interface TjAskMedicalHistoryMapper extends BaseMapper<TjAskMedicalHistory> {
|
/**
|
* 查询问诊
|
*
|
* @param askId 问诊主键
|
* @return 问诊
|
*/
|
public TjAskMedicalHistory selectTjAskMedicalHistoryByAskId(Long askId);
|
|
/**
|
* 查询问诊列表
|
*
|
* @param tjAskMedicalHistory 问诊
|
* @return 问诊集合
|
*/
|
public List<TjAskMedicalHistory> selectTjAskMedicalHistoryList(TjAskMedicalHistory tjAskMedicalHistory);
|
|
/**
|
* 新增问诊
|
*
|
* @param tjAskMedicalHistory 问诊
|
* @return 结果
|
*/
|
public int insertTjAskMedicalHistory(TjAskMedicalHistory tjAskMedicalHistory);
|
|
/**
|
* 修改问诊
|
*
|
* @param tjAskMedicalHistory 问诊
|
* @return 结果
|
*/
|
public int updateTjAskMedicalHistory(TjAskMedicalHistory tjAskMedicalHistory);
|
|
/**
|
* 删除问诊
|
*
|
* @param askId 问诊主键
|
* @return 结果
|
*/
|
public int deleteTjAskMedicalHistoryByAskId(Long askId);
|
|
/**
|
* 批量删除问诊
|
*
|
* @param askIds 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteTjAskMedicalHistoryByAskIds(Long[] askIds);
|
|
/**
|
* 批量删除${subTable.functionName}
|
*
|
* @param askIds 需要删除的数据主键集合
|
* @return 结果
|
*/
|
public int deleteTjAskHistorysByAskIds(Long[] askIds);
|
|
/**
|
* 批量新增${subTable.functionName}
|
*
|
* @param tjAskHistorysList ${subTable.functionName}列表
|
* @return 结果
|
*/
|
public int batchTjAskHistorys(List<TjAskHistorys> tjAskHistorysList);
|
|
|
/**
|
* 通过问诊主键删除${subTable.functionName}信息
|
*
|
* @param askId 问诊ID
|
* @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);
|
|
}
|
