package org.springblade.dataextraction.mapper;

import java.util.List;

import org.apache.ibatis.annotations.Select;
import org.springblade.dataextraction.enity.DimCType;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;

/**
 * @Desc
 * @Author William
 * @DateTime 2022 下午4:30:42
 */
public interface DimCTypeMapper extends BaseMapper<DimCType> {
	@Select("select cptype, categoryname  \r\n"
			+ "from DIM_CPTYPE where cptype in('0','1','3')\r\n"
			+ "order by cptype")
	public List<DimCType> listBigCate();
}
