package com.jtgh.cjhs.dao; import java.util.Date; import java.util.List; import org.springframework.data.jpa.repository.Query; import com.jtgh.cjhs.dao.common.CjhsRepository; import com.jtgh.cjhs.entity.DtywCbsbEntity; /** * 长江海事DAO * * @author 刘福亮 * */ public interface DtywCbsbDao extends CjhsRepository { @Query(value = " SELECT * FROM (SELECT * FROM DTYW_CBSB WHERE ZWCM=?1 AND ?2-1<=KSZYSJ AND KSZYSJ<=?2+1 ORDER BY MRUT DESC)WHERE ROWNUM<2 ", nativeQuery = true) public List findByZwcm(String zwcm,Date bgsj); /** * 固体货物表 * @param sbdbh * @return */ @Query(value = " SELECT SBDBH,HWLX,WGBH,ZQYSMCZW,WXLB,ZZL,LZBZ,WXHWBZ,BSXH,XH FROM DTYW_CBSBGT_HW H WHERE H.SBDBH=?1 ", nativeQuery = true) public List findCbsbgtHwBySbdbh(String sbdbh); /** * 散装货物表 * @param sbdbh * @return */ @Query(value = " SELECT SBDBH,HWLX,WGBH,ZQYSMCZW,WXLB,ZZL,LZBZ,WXHWBZ,BSXH,XH FROM DTYW_CBSBSZ_HW H WHERE H.SBDBH=?1", nativeQuery = true) public List findCbsbszHwBySbdbh(String sbdbh); /** * 液体货物表 * @param sbdbh * @return */ @Query(value = " SELECT SBDBH,HWLX,WGBH,ZQYSMCZW,WXLB,SL,LZBZ,WXHWBZ,BSXH,XH FROM DTYW_CBSBYT_HW H WHERE H.SBDBH=?1 ", nativeQuery = true) public List findCbsbytHwBySbdbh(String sbdbh); @Query(value = " SELECT SBDBH,HWLX,WGBH,ZQYSMCZW,WXLB,ZZL,LZBZ,WXHWBZ,BSXH,XH FROM DTYW_CBSBGT_HW H " + " WHERE H.SBDBH=?1 AND H.BSXH=?2 AND H.XH=?3 ", nativeQuery = true) public List findCbsbgtHwBySbdbhAndBsxhAndXh(String sbdbh, Long bsxh, Long xh); @Query(value = " SELECT SBDBH,HWLX,WGBH,ZQYSMCZW,WXLB,ZZL,LZBZ,WXHWBZ,BSXH,XH FROM DTYW_CBSBSZ_HW H " + " WHERE H.SBDBH=?1 AND H.BSXH=?2 AND H.XH=?3 ", nativeQuery = true) public List findCbsbszHwBySbdbhAndBsxhAndXh(String sbdbh, Long bsxh, Long xh); @Query(value = " SELECT SBDBH,HWLX,WGBH,ZQYSMCZW,WXLB,SL,LZBZ,WXHWBZ,BSXH,XH FROM DTYW_CBSBYT_HW H " + " WHERE H.SBDBH=?1 AND H.BSXH=?2 AND H.XH=?3 ", nativeQuery = true) public List findCbsbytHwBySbdbhAndBsxhAndXh(String sbdbh, Long bsxh, Long xh); }