package com.ruoyi.waterrecord.service.impl;
|
|
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.common.utils.poi.ExcelUtil;
|
import com.ruoyi.equipmentenergyconsumption.pojo.EquipmentEnergyConsumption;
|
import com.ruoyi.framework.web.domain.AjaxResult;
|
import com.ruoyi.waterrecord.mapper.WaterRecordMapper;
|
import com.ruoyi.waterrecord.pojo.WaterRecord;
|
import com.ruoyi.waterrecord.service.WaterRecordService;
|
import lombok.extern.slf4j.Slf4j;
|
import org.springframework.beans.factory.annotation.Autowired;
|
import org.springframework.stereotype.Service;
|
import org.springframework.util.CollectionUtils;
|
import org.springframework.web.multipart.MultipartFile;
|
|
import java.util.List;
|
|
/**
|
* @author :yys
|
* @date : 2025/8/11 10:08
|
*/
|
@Service
|
@Slf4j
|
public class WaterRecordServiceImpl extends ServiceImpl<WaterRecordMapper, WaterRecord> implements WaterRecordService {
|
|
@Autowired
|
private WaterRecordMapper waterRecordMapper;
|
|
|
@Override
|
public IPage<WaterRecord> listPage(Page page, WaterRecord waterRecord) {
|
return waterRecordMapper.listPage(page,waterRecord);
|
}
|
|
@Override
|
public AjaxResult importData(MultipartFile file) {
|
try {
|
ExcelUtil<WaterRecord> util = new ExcelUtil<WaterRecord>(WaterRecord.class);
|
List<WaterRecord> userList = util.importExcel(file.getInputStream());
|
if(CollectionUtils.isEmpty(userList)){
|
return AjaxResult.warn("模板错误或导入数据为空");
|
}
|
this.saveOrUpdateBatch(userList);
|
return AjaxResult.success(true);
|
}catch (Exception e){
|
e.printStackTrace();
|
return AjaxResult.error("导入失败");
|
}
|
}
|
}
|
