From 2fcd97552d16718cc7997629fd637a73a5a4483f Mon Sep 17 00:00:00 2001 From: 郑永安 <zyazyz250@sina.com> Date: 星期一, 19 六月 2023 14:44:19 +0800 Subject: [PATCH] 删除 --- src/main/java/com/gk/firework/Service/ServiceImpl/ProductCategoryServiceImpl.java | 69 ++++++++++++++++++++++++++++++++++ 1 files changed, 69 insertions(+), 0 deletions(-) diff --git a/src/main/java/com/gk/firework/Service/ServiceImpl/ProductCategoryServiceImpl.java b/src/main/java/com/gk/firework/Service/ServiceImpl/ProductCategoryServiceImpl.java new file mode 100644 index 0000000..7f9798d --- /dev/null +++ b/src/main/java/com/gk/firework/Service/ServiceImpl/ProductCategoryServiceImpl.java @@ -0,0 +1,69 @@ +package com.gk.firework.Service.ServiceImpl; + +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.gk.firework.Domain.ProductCategory; +import com.gk.firework.Domain.Utils.StringUtils; +import com.gk.firework.Mapper.ProductCategoryMapper; +import com.gk.firework.Service.ProductCategoryService; +import org.springframework.beans.factory.annotation.Autowired; +import org.springframework.stereotype.Service; + +import java.util.List; + +/** + * @author : jingjy + * @date : 2021/4/22 9:56 + */ +@Service("ProductCategoryService") +public class ProductCategoryServiceImpl extends ServiceImpl<ProductCategoryMapper, ProductCategory> implements ProductCategoryService { + @Autowired + private ProductCategoryMapper productCategoryMapper; + @Override + public List<ProductCategory> selectAllOrByName(String name) { + LambdaQueryWrapper<ProductCategory> wrapper = new LambdaQueryWrapper<>(); + if (StringUtils.isNotBlank(name)){ + wrapper.like(ProductCategory::getName, name); + } + return productCategoryMapper.selectList(wrapper); + } + + @Override + public List<ProductCategory> selectCategoryByType(byte type) { + LambdaQueryWrapper<ProductCategory> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(ProductCategory::getType, type); + return productCategoryMapper.selectList(wrapper); + } + + @Override + public List<ProductCategory> selectCategoryByTypeAndName(ProductCategory category) { + LambdaQueryWrapper<ProductCategory> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(ProductCategory::getType, category.getType()); + wrapper.eq(ProductCategory::getName, category.getName()); + return productCategoryMapper.selectList(wrapper); + } + + @Override + public List<ProductCategory> selectCategoryByMajorType(String major) { + LambdaQueryWrapper<ProductCategory> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(ProductCategory::getType, (byte)2); + wrapper.eq(ProductCategory::getParentname, major); + wrapper.groupBy(ProductCategory::getName); + return productCategoryMapper.selectList(wrapper); + } + + @Override + public ProductCategory selectCategoryByLevelAndName(String level, String secondaryType) { + LambdaQueryWrapper<ProductCategory> wrapper = new LambdaQueryWrapper<>(); + wrapper.eq(ProductCategory::getLevel, level); + wrapper.eq(ProductCategory::getName,secondaryType); + return productCategoryMapper.selectOne(wrapper); + } + + + //查询是否存在一条数据 + @Override + public boolean selectOne(String type, String secondaryType, String level) { + return productCategoryMapper.countOne(type,secondaryType,level) == 1; + } +} -- Gitblit v1.9.2