hbghj/gkaq/yjpt-java/trunk/java_src/com/jtgh/cjhs/dao/DtywCbsbDao.java

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<DtywCbsbEntity, String> {

	@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<DtywCbsbEntity> 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<Object[]> 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<Object[]> 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<Object[]> 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<Object[]> 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<Object[]> 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<Object[]> findCbsbytHwBySbdbhAndBsxhAndXh(String sbdbh,
			Long bsxh, Long xh);
}