| | |
|---|
| | | import com.alibaba.excel.EasyExcel; |
|---|
| | | import com.alibaba.excel.ExcelWriter; |
|---|
| | | import com.alibaba.excel.write.metadata.WriteSheet; |
|---|
| | | import com.baomidou.mybatisplus.core.conditions.query.LambdaQueryWrapper; |
|---|
| | | import com.baomidou.mybatisplus.core.metadata.IPage; |
|---|
| | | import com.baomidou.mybatisplus.extension.conditions.query.LambdaQueryChainWrapper; |
|---|
| | | import com.baomidou.mybatisplus.extension.conditions.update.LambdaUpdateChainWrapper; |
|---|
| | |
|---|
| | | headers.add(PointHeaderConstant.ID); |
|---|
| | | headers.add(PointHeaderConstant.Point_Name); |
|---|
| | | headers.add(PointHeaderConstant.Serial_Number); |
|---|
| | | headers.add(PointHeaderConstant.Area); |
|---|
| | | headers.add(PointHeaderConstant.IP); |
|---|
| | | headers.add(PointHeaderConstant.Province_Tag); |
|---|
| | | headers.add(PointHeaderConstant.Impotrant_Command_Image); |
|---|
| | |
|---|
| | | list.add(export.getId()); |
|---|
| | | list.add(export.getPointName()); |
|---|
| | | list.add(export.getSerialNumber()); |
|---|
| | | list.add(export.getArea()); |
|---|
| | | list.add(export.getPointIP()); |
|---|
| | | list.add(export.getProvinceTagString()); |
|---|
| | | list.add(export.getImportantCommandImageTagString()); |
|---|
| | |
|---|
| | | } |
|---|
| | | } |
|---|
| | | } |
|---|
| | | //mybaits方法 |
|---|
| | | //插入 |
|---|
| | | if(!CollectionUtils.isEmpty(insertList)) dynamicColumnMapper.saveBatch(insertList); |
|---|
| | | //更新 |
|---|
| | | if(!CollectionUtils.isEmpty(updateList)) dynamicColumnMapper.updateBatch(updateList); |
|---|
| | | //删除 |
|---|
| | | if(!CollectionUtils.isEmpty(deleteList)) dynamicColumnMapper.deleteBatchIds(deleteList); |
|---|
| | | if(!CollectionUtils.isEmpty(deleteList)) dynamicColumnMapper.deleteBatch(deleteList); |
|---|
| | | } |
|---|
| | | |
|---|
| | | /** |
|---|
| | | * 根据设备编码查询点位信息 |
|---|
| | | * |
|---|
| | | * @param serialNumber 序列号 |
|---|
| | | * @return {@link YwPoint } |
|---|
| | | * @author |
|---|
| | | */ |
|---|
| | | @Override |
|---|
| | | public YwPoint selectBySerialNumber(String serialNumber) { |
|---|
| | | return baseMapper.selectOne(new LambdaQueryWrapper<>(YwPoint.class).eq(YwPoint::getSerialNumber, serialNumber).eq(YwPoint::getDeleted, "0")); |
|---|
| | | } |
|---|
| | | |
|---|
| | | public void waitAllFinishAndGetResult(List<YwPoint> dataList) { |
|---|
