package cn.com.lzt.demotetransfer.dao;

import java.util.Date;
import java.util.List;

import org.jeecgframework.minidao.annotation.Arguments;
import org.jeecgframework.minidao.annotation.MiniDao;
import org.jeecgframework.minidao.annotation.Param;
import org.jeecgframework.minidao.annotation.ResultType;
import org.jeecgframework.minidao.annotation.Sql;
import org.jeecgframework.minidao.pojo.MiniDaoPage;

import cn.com.lzt.sameleveltransfer.entity.SamelevelTransferDaoEntity;

/**
 * Minidao例子
 * 
 */
@MiniDao
public interface DemotetransferMinidaoDao {
	
	@Arguments({"samelevelTransferDao","useridList","useridList1","orgidList","page", "rows","authSql"})
	@ResultType(SamelevelTransferDaoEntity.class)
	public MiniDaoPage<SamelevelTransferDaoEntity> getAllEntities(SamelevelTransferDaoEntity samelevelTransferDao,List<String> useridList,List<String> useridList1,List<String> orgidList, int page, int rows,String authSql);

	/**
	 * 通过时间查询工作流已完成的数据
	 * @param userid 用户id
	 * @param inTime 调入日期
	 */
	@Sql("select * from t_bus_demote_transfer where bpm_status = 3 and to_days(in_time) = to_days(:inTime) and delete_flag = 0")
	public List<SamelevelTransferDaoEntity> getByDate(@Param("inTime")Date inTime);
}