From 274a61f398e1d7b4ae63208897b70b3a73b30805 Mon Sep 17 00:00:00 2001 From: liyong <18434998025@163.com> Date: 星期三, 18 六月 2025 09:14:24 +0800 Subject: [PATCH] 非空校验 --- src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java | 102 ++++++++++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 101 insertions(+), 1 deletions(-) diff --git a/src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java b/src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java index 8b07b9f..816fe04 100644 --- a/src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java +++ b/src/main/java/com/ruoyi/basic/service/impl/SupplierServiceImpl.java @@ -1,11 +1,27 @@ package com.ruoyi.basic.service.impl; +import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; +import com.baomidou.mybatisplus.core.metadata.IPage; +import com.baomidou.mybatisplus.extension.plugins.pagination.Page; import com.baomidou.mybatisplus.extension.service.impl.ServiceImpl; +import com.ruoyi.basic.dto.SupplierManageDto; +import com.ruoyi.basic.excel.SupplierManageExcelDto; import com.ruoyi.basic.mapper.SupplierManageMapper; +import com.ruoyi.basic.pojo.Customer; import com.ruoyi.basic.pojo.SupplierManage; import com.ruoyi.basic.service.ISupplierService; +import com.ruoyi.common.utils.SecurityUtils; +import com.ruoyi.common.utils.poi.ExcelUtil; +import com.ruoyi.framework.web.domain.AjaxResult; +import org.springframework.beans.BeanUtils; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; +import org.springframework.web.multipart.MultipartFile; + +import javax.servlet.http.HttpServletResponse; +import java.time.LocalDate; +import java.util.ArrayList; +import java.util.List; @Service public class SupplierServiceImpl extends ServiceImpl<SupplierManageMapper,SupplierManage> implements ISupplierService { @@ -13,9 +29,93 @@ @Autowired private SupplierManageMapper supplierMapper; + /** + * 渚涘簲鍟嗘柊澧� + * @param supplierManage + * @return + */ @Override public void saveSupplier(SupplierManage supplierManage) { - int i = supplierMapper.selectAll(); supplierMapper.insert(supplierManage); } + + /** + * 渚涘簲鍟嗗垹闄� + * @param ids + * @return + */ + @Override + public int delSupplier(List<Integer> ids) { + LambdaQueryWrapper<SupplierManage> delWrapper = new LambdaQueryWrapper<>(); + delWrapper.in(SupplierManage::getId, ids); + return supplierMapper.delete(delWrapper); + } + + /** + * 渚涘簲鍟嗚鎯� + * @param id + * @return + */ + @Override + public SupplierManage supplierDetail(Integer id) { + return supplierMapper.selectById(id); + } + + /** + * 渚涘簲鍟嗕慨鏀� + * @param supplierManage + * @return + */ + @Override + public int supplierUpdate(SupplierManage supplierManage) { + return supplierMapper.updateById(supplierManage); + } + + /** + * 渚涘簲鍟嗗垎椤垫煡璇� + * @param page + * @param supplierManageDto + * @return + */ + @Override + public IPage<SupplierManage> supplierListPage(Page page, SupplierManageDto supplierManageDto) { + return supplierMapper.supplierListPage(page,supplierManageDto); + } + + /** + * 渚涘簲鍟嗗鍑� + * @param response + * @param supplierManageDto + */ + @Override + public void supplierExport(HttpServletResponse response, SupplierManageDto supplierManageDto) { + List<SupplierManageExcelDto> supplierManageList = supplierMapper.supplierExportList(supplierManageDto); + ExcelUtil<SupplierManageExcelDto> util = new ExcelUtil<SupplierManageExcelDto>(SupplierManageExcelDto.class); + util.exportExcel(response, supplierManageList, "渚涘簲鍟嗗鍑�"); + } + + @Override + public Boolean importData(MultipartFile file) { + + try { + ExcelUtil<SupplierManageExcelDto> util = new ExcelUtil<SupplierManageExcelDto>(SupplierManageExcelDto.class); + List<SupplierManageExcelDto> list = util.importExcel(file.getInputStream()); + ArrayList<SupplierManage> supplierManages = new ArrayList<>(); + list.stream().forEach(dto -> { + SupplierManage supplierManage = new SupplierManage(); + BeanUtils.copyProperties(dto,supplierManage); + supplierManage.setMaintainTime(LocalDate.now()); + Long userId = SecurityUtils.getLoginUser().getUser().getUserId(); + + supplierManage.setMaintainUserId(Integer.parseInt(userId+"")); + supplierManages.add(supplierManage); + }); + + this.saveOrUpdateBatch(supplierManages); + return true; + }catch (Exception e){ + e.printStackTrace(); + } + return false; + } } -- Gitblit v1.9.3