| | |
| | | package com.whyc.service; |
| | | |
| | | import com.baomidou.mybatisplus.core.conditions.query.QueryWrapper; |
| | | import com.baomidou.mybatisplus.core.conditions.update.UpdateWrapper; |
| | | import com.github.pagehelper.PageHelper; |
| | | import com.github.pagehelper.PageInfo; |
| | | import com.whyc.dto.FileDirPath; |
| | | import com.whyc.dto.Response; |
| | | import com.whyc.mapper.ECRMapper; |
| | | import com.whyc.pojo.ECR; |
| | |
| | | import javax.annotation.Resource; |
| | | import javax.servlet.http.HttpServletResponse; |
| | | import java.io.File; |
| | | import java.io.FileInputStream; |
| | | import java.io.IOException; |
| | | import java.io.InputStream; |
| | | import java.text.ParseException; |
| | |
| | | String dateFormat = DateUtil.YYYY_MM_DD_HH_MM_SS.format(new Date()); |
| | | ExcelUtil.exportExcel("变更记录清单_"+dateFormat,"清单",title,values,null,response); |
| | | } |
| | | //删除ECR记录 |
| | | public Response deleteEcr(int id, String filePath) { |
| | | if(!filePath.isEmpty()){ |
| | | String fileDirName = FileDirPath.getFileDirName(); |
| | | File file = new File(fileDirName+File.separator+filePath); |
| | | if(!file.isDirectory()){ |
| | | file.delete(); |
| | | } |
| | | } |
| | | //删除表记录 |
| | | UpdateWrapper wrapper=new UpdateWrapper(); |
| | | wrapper.eq("id",id); |
| | | int delFlag=mapper.delete(wrapper); |
| | | return new Response().set(1,delFlag>0,"删除ECR"); |
| | | } |
| | | } |