package com.jsh.erp.datasource.mappers;
|
|
import com.jsh.erp.datasource.entities.SysDictItem;
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import java.util.List;
|
|
@Mapper
|
public interface SysDictItemMapper {
|
List<SysDictItem> selectByDictId(Long dictId);
|
|
SysDictItem selectById(Long id);
|
|
int insert(SysDictItem sysDictItem);
|
|
int update(SysDictItem sysDictItem);
|
|
int deleteById(Long id);
|
|
int deleteByDictId(Long dictId);
|
|
//通过字典类型和字典code查询具体一条
|
@Select("SELECT * FROM sys_dict_item di LEFT JOIN sys_dict d ON di.dict_id = d.id WHERE d.dict_code = #{dictCode} AND di.item_text = #{itemText}")
|
SysDictItem getByDictCodeAndItemText(String dictCode, String itemText);
|
|
List<SysDictItem> getItemsByDictCode(@Param("dictCode") String dictCode);
|
}
|
