package com.yeshi.fanli.dao.mybatis;

import java.util.List;

import org.apache.ibatis.annotations.Param;

import com.yeshi.fanli.entity.bus.user.UserRankings;

public interface UserRankingsMapper {

	int deleteByPrimaryKey(Long id);

	int insert(UserRankings record);

	int insertSelective(UserRankings record);

	UserRankings selectByPrimaryKey(Long id);

	int updateByPrimaryKeySelective(UserRankings record);

	int updateByPrimaryKey(UserRankings record);
	
	
	/**
	 * 批量插入
	 * @param list
	 * @return
	 */
	int insertBatch(List<UserRankings> list);
	
	
	/**
	 * 批量选择更新
	 * @param list
	 * @return
	 */
	int updateBatchSelective(List<UserRankings> list);
	
	
	List<UserRankings> queryAll();
	
	/**
	 * 清空自购榜状态以及金额
	 */
	void updateClearTradeState();
	
	// 根据名称查询
	List<UserRankings> selectByNickName(String nickName);
	
	// 根据展示ID查询
	List<UserRankings> selectByShowId(String showId);
		
		
	// 查询列表
	List<UserRankings> query(@Param("start") long start, @Param("count") int count, @Param("key") String key,
			 @Param("tradeState") Integer tradeState, @Param("shareState") Integer shareState, @Param("sort") Integer sort);
	
	// 查询列表统计
	long queryCount(@Param("key") String key,  @Param("tradeState") Integer tradeState, @Param("shareState") Integer shareState);
	
	// 奖金榜 随机id查询
	public List<UserRankings> listQueryByIds(List<Long> list);
}