package com.slcf.dao;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Select;
|
import org.springframework.stereotype.Repository;
|
|
import com.slcf.bean.WaitPakInLogCondition;
|
import com.slcf.pojo.WaitPakInLogBean;
|
|
@Repository
|
public interface WaitPakInLogDao {
|
|
//分页查询所有信息
|
// @Select("select top (#{epage}) * from cust_wait_pakin where loc_no not in "
|
// @Select("select top (#{epage}) a.*,b.loc_desc loc_sts_name from cust_wait_pakin a,asr_bas_loc_type b where a.loc_sts=b.loc_sts and loc_no not in "
|
// + " (select top (#{spage}) loc_no from cust_wait_pakin order by loc_no asc) order by loc_no asc")
|
public List<WaitPakInLogBean> queryWaitPakInLogList(WaitPakInLogCondition waitPakInCon);
|
|
//根据过滤条件统计总数量
|
public int getWaitPakInLogCount(WaitPakInLogCondition waitPakInCon);
|
|
/**
|
* 查询所有
|
* @return
|
*/
|
@Select("select * from cust_wait_pakin_log order by sheet_no,mat_no desc")
|
public List<WaitPakInLogBean> getWaitPakInLogList();
|
|
/**
|
* 不分页查询所有信息，用于excel导出
|
* @return
|
*/
|
public List<WaitPakInLogBean> getWaitPakInLogAll(WaitPakInLogCondition condition);
|
|
}
|
