| | |
| | | package com.yeshi.fanli.dao.mybatis;
|
| | |
|
| | | import java.util.List;
|
| | |
|
| | | import com.yeshi.fanli.entity.bus.clazz.GoodsClass;
|
| | | import com.yeshi.fanli.entity.bus.clazz.GoodsSubClass;
|
| | |
|
| | | public interface GoodsClassMapper {
|
| | |
|
| | | String getKwById(Long id);
|
| | | |
| | | GoodsClass selectByPrimaryKey(Long id);
|
| | | |
| | | // 查询所有
|
| | | List<GoodsClass> queryAll();
|
| | | |
| | | int updateByPrimaryKeySelective(GoodsClass record);
|
| | | }
|
| | | package com.yeshi.fanli.dao.mybatis; |
| | | |
| | | import java.util.List; |
| | | |
| | | import org.apache.ibatis.annotations.Param; |
| | | |
| | | import com.yeshi.fanli.dao.BaseMapper; |
| | | import com.yeshi.fanli.entity.bus.clazz.GoodsClass; |
| | | |
| | | public interface GoodsClassMapper extends BaseMapper<GoodsClass>{ |
| | | |
| | | /** |
| | | * 查询搜索关键词 |
| | | * @param id |
| | | * @return |
| | | */ |
| | | String getKeysById(Long id); |
| | | |
| | | |
| | | /** |
| | | * 根据名称模糊搜索 |
| | | * @param id |
| | | * @return |
| | | */ |
| | | List<GoodsClass> listByName(@Param("start") long start, @Param("count") int count, @Param("name")String name); |
| | | |
| | | |
| | | /** |
| | | * 根据名称模糊搜索 |
| | | * @param id |
| | | * @return |
| | | */ |
| | | int countByName(@Param("name")String name, @Param("systemId")Long systemId); |
| | | |
| | | /** |
| | | * 根据系统id查询分类 |
| | | * @param systemId |
| | | * @return |
| | | */ |
| | | List<GoodsClass> listGoodsClassBySystemId(@Param("systemId") Long systemId); |
| | | |
| | | /** |
| | | * 根据排序查询 |
| | | * @param orderby |
| | | * @return |
| | | */ |
| | | GoodsClass getByAdjoinOrder(@Param("order") Integer order, @Param("type") Integer type); |
| | | |
| | | |
| | | List<GoodsClass> getGoodsClassAll(@Param("sex")Integer sex); |
| | | |
| | | /** |
| | | * 获取最大排序值 |
| | | * @return |
| | | */ |
| | | int getMaxOrder(); |
| | | |
| | | /** |
| | | * 获取有效分类 |
| | | * @return |
| | | */ |
| | | List<GoodsClass> getEffectiveClass(); |
| | | |
| | | } |