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);
|
}
|