| | |
| | | import com.gkhy.labRiskManage.domain.riskReport.entity.ReportExperimentSite; |
| | | import org.springframework.data.jpa.repository.JpaRepository; |
| | | import org.springframework.data.jpa.repository.JpaSpecificationExecutor; |
| | | import org.springframework.data.jpa.repository.Modifying; |
| | | import org.springframework.data.jpa.repository.Query; |
| | | import org.springframework.stereotype.Repository; |
| | | |
| | |
| | | |
| | | @Query(value = "select t from ReportExperimentSite t where t.reportId = :id and t.deleteStatus = 0") |
| | | List<ReportExperimentSite> getSiteByReportId(Long id); |
| | | |
| | | @Query(value = "update ReportExperimentSite set deleteStatus = 1 where reportId = :reportId") |
| | | @Modifying |
| | | Integer delReportData(Long reportId); |
| | | |
| | | } |