package org.jeecg.modules.mdc.service.impl; import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; import com.baomidou.mybatisplus.core.metadata.IPage; import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; import org.apache.commons.lang3.StringUtils; import org.jeecg.modules.mdc.entity.MdcEquipmentType; import org.jeecg.modules.mdc.mapper.MdcEquipmentTypeMapper; import org.jeecg.modules.mdc.service.IMdcEquipmentTypeService; import org.springframework.stereotype.Service; import javax.servlet.http.HttpServletRequest; import java.util.Arrays; import java.util.List; /** * @Description: 设备类型 * @Author: Sake * @Date: 2023-03-28 15:30 */ @Service public class MdcEquipmentTypeServiceImpl extends ServiceImpl implements IMdcEquipmentTypeService { @Override public MdcEquipmentType queryById(String id) { return this.getById(id); } @Override public List queryEquipmentType() { //创建查询器 QueryWrapper queryWrapper = new QueryWrapper<>(); //只查询表内指定字段 queryWrapper.select("id", "equipment_type_name"); List mdcEquipmentTypes = baseMapper.selectList(queryWrapper); return mdcEquipmentTypes; } @Override public IPage queryPageList(Page page, HttpServletRequest req) { QueryWrapper queryWrapper = new QueryWrapper(); //检查请求体中是否存在设备类型的字段 存在则返回true if(req.getParameterMap().containsKey("equipmentTypeName")){ //获取设备类型的值 不为空则添加到查询 String equipmentTypeName = req.getParameterMap().get("equipmentTypeName")[0]; queryWrapper.eq(StringUtils.isNotBlank(equipmentTypeName), "equipment_type_name", equipmentTypeName); } //根据设备类型排序 queryWrapper.orderByAsc("equipment_type_name"); return this.page(page, queryWrapper); } @Override public boolean addEquipmentType(MdcEquipmentType mdcEquipmentType) { return this.save(mdcEquipmentType); } @Override public boolean editEquipmentType(MdcEquipmentType mdcEquipmentType) { return this.updateById(mdcEquipmentType); } @Override public boolean deleteEquipmentType(String id) { return this.removeById(id); } @Override public boolean deleteBatchEquipmentType(String ids) { return this.removeByIds(Arrays.asList(ids.split(","))); } }