package com.panzhihua.service_community.dao;
|
|
import java.util.List;
|
|
import org.apache.ibatis.annotations.Mapper;
|
import org.apache.ibatis.annotations.Param;
|
import org.apache.ibatis.annotations.Select;
|
|
import com.baomidou.mybatisplus.core.mapper.BaseMapper;
|
import com.panzhihua.service_community.model.dos.BcDictionaryItemDO;
|
|
/**
|
* 字典项
|
*
|
* @author xyh
|
* @since 2021-06-11
|
*/
|
@Mapper
|
public interface BcDictionaryItemDAO extends BaseMapper<BcDictionaryItemDO> {
|
|
@Select("SELECT d.dict_name,di.dict_value,di.dict_item_name,di.mnemonic_code "
|
+ "FROM bc_dictionary d INNER JOIN bc_dictionary_item di ON d.id = di.dict_id "
|
+ "WHERE di.enabled = 1 AND di.delete_flag = 0 AND d.enabled = 1 AND d.delete_flag = 0 "
|
+ "AND d.dict_key = #{key} ")
|
List<BcDictionaryItemDO> getDictionaryByKey(@Param("key") String key);
|
}
|
