package com.slcf.dao;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.springframework.stereotype.Repository;

import com.slcf.bean.WaitPakOutLogCondition;
import com.slcf.pojo.WaitPakOutLogBean;

@Repository
public interface WaitPakOutLogDao {

	//分页查询所有信息
//	@Select("select top (#{epage}) * from cust_wait_pakout_log where loc_no not in "
//	@Select("select top (#{epage}) a.*,b.loc_desc loc_sts_name from cust_wait_pakout_log 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_pakout_log order by loc_no asc) order by loc_no asc")
	public List<WaitPakOutLogBean> queryWaitPakOutLogList(WaitPakOutLogCondition waitPakOutCon);

	//根据过滤条件统计总数量
	public int getWaitPakOutLogCount(WaitPakOutLogCondition waitPakOutCon);

	/**
	 * 查询所有
	 * @return
	 */
	@Select("select * from cust_wait_pakout_log order by sheet_no,mat_no desc")
	public List<WaitPakOutLogBean> getWaitPakOutLogList();

	/**
	 * 不分页查询所有信息，用于excel导出
	 * @return
	 */
	public List<WaitPakOutLogBean> getWaitPakOutLogAll(WaitPakOutLogCondition condition);

}