package com.gkhy.labRiskManage.domain.basic.repository.jpa;

import com.gkhy.labRiskManage.domain.basic.entity.OldRiskAssess;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.JpaSpecificationExecutor;
import org.springframework.data.jpa.repository.Query;
import org.springframework.stereotype.Repository;

@Repository
public interface OldRiskAssessRepository  extends JpaRepository<OldRiskAssess, Long>, JpaSpecificationExecutor<OldRiskAssess> {


    @Query(value = "select t from OldRiskAssess t where t.id = :id and t.deleteStatus = 0")
    OldRiskAssess getOldRiskAssessById(Long id);
}