package com.zy.asrs.service.impl; import com.baomidou.mybatisplus.mapper.EntityWrapper; import com.baomidou.mybatisplus.mapper.Wrapper; import com.core.common.BaseRes; import com.core.common.Cools; import com.core.exception.CoolException; import com.zy.asrs.entity.*; import com.zy.asrs.entity.param.EmptyPlateOutParam; import com.zy.asrs.entity.param.FullStoreParam; import com.zy.asrs.entity.param.LocDetlAdjustParam; import com.zy.asrs.entity.param.StockOutParam; import com.zy.asrs.service.*; import com.zy.common.model.LocDetlDto; import com.zy.common.model.OutLocDto; import com.zy.common.model.StartupDto; import com.zy.common.service.CommonService; import org.springframework.beans.factory.annotation.Autowired; import org.springframework.stereotype.Service; import org.springframework.transaction.annotation.Transactional; import java.util.*; /** * Created by vincent on 2020/6/11 */ @Service public class WorkServiceImpl implements WorkService { // 工作号生成规则默认类型 private static final int DEFAULT_WORK_NO_TYPE = 0; @Autowired private WrkMastService wrkMastService; @Autowired private BasDevpService basDevpService; @Autowired private CommonService commonService; @Autowired private WrkDetlService wrkDetlService; @Autowired private LocMastService locMastService; @Autowired private StaDescService staDescService; @Autowired private LocDetlService locDetlService; @Autowired private MatCodeService matCodeService; @Autowired private AdjDetlService adjDetlService; @Override @Transactional public String startupFullPutStore(FullStoreParam param, Long userId) { // 参数非空判断 if (Cools.isEmpty(param.getDevpNo(), param.getList())) { throw new CoolException(BaseRes.PARAM); } // 源站点状态检测 BasDevp sourceStaNo = basDevpService.checkSiteStatus(param.getDevpNo()); // 生成工作号 int workNo = commonService.getWorkNo(DEFAULT_WORK_NO_TYPE); // 检索库位 StartupDto dto = commonService.getLocNo(1, 1, param.getDevpNo()); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(1L); // 工作状态:生成入库ID wrkMast.setIoType(1); // 入出库状态:1.入库 wrkMast.setIoPri(13D); // 优先级:10 wrkMast.setCrnNo(dto.getCrnNo()); wrkMast.setSourceStaNo(dto.getSourceStaNo()); wrkMast.setStaNo(dto.getStaNo()); wrkMast.setLocNo(dto.getLocNo()); wrkMast.setBarcode(param.getBarcode()); // 托盘码 wrkMast.setFullPlt("Y"); // 满板:Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("N"); wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型 // 操作人员数据 wrkMast.setAppeUser(userId); wrkMast.setAppeTime(new Date()); wrkMast.setModiUser(userId); wrkMast.setModiTime(new Date()); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } // 生成工作档明细 List matDtos = new ArrayList<>(); param.getList().forEach(elem -> { matDtos.add(new MatCodeCountDto(elem.getMatNo(), elem.getCount())); }); wrkDetlService.createWorkDetail(workNo, matDtos, param.getBarcode(), userId); // 更新源站点信息 sourceStaNo.setWrkNo(workNo); sourceStaNo.setModiUser(userId); sourceStaNo.setModiTime(new Date()); if (!basDevpService.updateById(sourceStaNo)){ throw new CoolException("更新源站失败"); } // 更新目标库位状态 LocMast locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocType().equals("O")){ locMast.setLocType("S"); // S.入库预约 locMast.setModiUser(userId); locMast.setModiTime(new Date()); if (!locMastService.updateById(locMast)){ throw new CoolException("改变库位状态失败"); } } else { throw new CoolException(dto.getLocNo()+"目标库位已被占用"); } return dto.getLocNo(); } @Override @Transactional public void startupFullTakeStore(StockOutParam param, Long userId) { // 目标站点状态检测 BasDevp staNo = basDevpService.checkSiteStatus(param.getOutSite()); // 获取库位明细 List locDetlDtos = new ArrayList<>(); for (StockOutParam.LocDetl paramLocDetl : param.getLocDetls()) { if (!Cools.isEmpty(paramLocDetl.getLocNo(), paramLocDetl.getMatnr(), paramLocDetl.getCount())) { LocDetl sqlParam = new LocDetl(); sqlParam.setLocNo(paramLocDetl.getLocNo()); sqlParam.setMatnr(paramLocDetl.getMatnr()); LocDetl one = locDetlService.selectOne(new EntityWrapper<>(sqlParam)); if (null != one) locDetlDtos.add(new LocDetlDto(one, paramLocDetl.getCount())); } } if (!locDetlDtos.isEmpty()) { // 启动出库开始 101.出库 stockOut(staNo, locDetlDtos, 101, userId); } else { throw new CoolException("库位物料不存在"); } } @Override @Transactional public void stockOut(BasDevp staNo, List locDetlDtos, Integer ioType, Long userId) { // 合并同类项 Set locNos = new HashSet<>(); locDetlDtos.forEach(dto -> locNos.add(dto.getLocDetl().getLocNo())); List dtos = new ArrayList<>(); for (String locNo : locNos) { List list = new ArrayList<>(); Iterator iterator = locDetlDtos.iterator(); while (iterator.hasNext()) { LocDetlDto dto = iterator.next(); if (locNo.equals(dto.getLocDetl().getLocNo())) { list.add(dto); iterator.remove(); } } dtos.add(new OutLocDto(locNo, list)); } // 生成工作档 for (OutLocDto dto : dtos) { // 获取库位 LocMast locMast = locMastService.selectById(dto.getLocNo()); // 获取路径 Wrapper wrapper = new EntityWrapper() .eq("type_no", ioType) .eq("stn_no", staNo.getDevNo()) .eq("crn_no", locMast.getCrnNo()); StaDesc staDesc = staDescService.selectOne(wrapper); if (Cools.isEmpty(staDesc)) { throw new CoolException("出库路径不存在"); } // 生成工作号 int workNo = commonService.getWorkNo(DEFAULT_WORK_NO_TYPE); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(11L); // 工作状态:11.生成出库ID wrkMast.setIoType(ioType); // 入出库状态:101.出库 wrkMast.setIoPri(13D); // 优先级:13 wrkMast.setCrnNo(locMast.getCrnNo()); wrkMast.setSourceStaNo(staDesc.getCrnStn()); // 源站 wrkMast.setStaNo(staDesc.getStnNo()); // 目标站 wrkMast.setSourceLocNo(dto.getLocNo()); // 源库位 wrkMast.setFullPlt("Y"); // 满板:Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("N"); // 空板 wrkMast.setLinkMis("N"); wrkMast.setAppeUser(userId); // 操作人员数据 wrkMast.setAppeTime(new Date()); wrkMast.setModiUser(userId); wrkMast.setModiTime(new Date()); if (!wrkMastService.insert(wrkMast)) { throw new CoolException("保存工作档失败,出库库位号:"+dto.getLocNo()); } // 生成工作档明细 for (LocDetlDto detlDto : dto.getLocDetlDtos()) { // 出库时,数量为0的直接忽略 if (detlDto.getCount()==null || detlDto.getCount() <= 0.0D) {continue;} WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(workNo); wrkDetl.setIoTime(new Date()); wrkDetl.setMatnr(detlDto.getLocDetl().getMatnr()); Double anfme = ioType==101?detlDto.getCount():detlDto.getLocDetl().getAnfme(); wrkDetl.setAnfme(anfme); // 数量 wrkDetl.setZmatid(detlDto.getLocDetl().getZmatid()); wrkDetl.setTbpos(detlDto.getLocDetl().getTbpos()); wrkDetl.setTbnum(detlDto.getLocDetl().getTbnum()); wrkDetl.setLgnum(detlDto.getLocDetl().getLgnum()); wrkDetl.setAltme(detlDto.getLocDetl().getAltme()); wrkDetl.setBname(detlDto.getLocDetl().getBname()); wrkDetl.setMaktx(detlDto.getLocDetl().getMaktx()); wrkDetl.setAppeTime(new Date()); wrkDetl.setAppeUser(userId); wrkDetl.setModiTime(new Date()); wrkDetl.setModiUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作档明细失败"); } } // 修改库位状态: F.在库 ====>>> R.出库预约 locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocType().equals("F")) { locMast.setLocType("R"); locMast.setModiUser(userId); locMast.setModiTime(new Date()); if (!locMastService.updateById(locMast)) { throw new CoolException("预约库位状态失败,库位号:"+dto.getLocNo()); } } else { throw new CoolException(dto.getLocNo() + "库位不是在库状态"); } } } @Override @Transactional public String emptyPlateIn(Integer devpNo, Long userId) { // 源站点状态检测 BasDevp sourceStaNo = basDevpService.checkSiteStatus(devpNo); // 生成工作号 int workNo = commonService.getWorkNo(DEFAULT_WORK_NO_TYPE); // 检索库位 StartupDto dto = commonService.getLocNo(1, 10, devpNo); // 生成工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(1L); // 工作状态:生成入库ID wrkMast.setIoType(10); // 入出库状态:10.空板入库 wrkMast.setIoPri(13D); // 优先级:10 wrkMast.setCrnNo(dto.getCrnNo()); wrkMast.setSourceStaNo(dto.getSourceStaNo()); wrkMast.setStaNo(dto.getStaNo()); wrkMast.setLocNo(dto.getLocNo()); wrkMast.setFullPlt("N"); // 满板:Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("Y"); // 空板 wrkMast.setLinkMis("N"); wrkMast.setCtnType(sourceStaNo.getCtnType()); // 容器类型 // 操作人员数据 wrkMast.setAppeUser(userId); wrkMast.setAppeTime(new Date()); wrkMast.setModiUser(userId); wrkMast.setModiTime(new Date()); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } // 更新源站点信息 sourceStaNo.setWrkNo(workNo); sourceStaNo.setModiUser(userId); sourceStaNo.setModiTime(new Date()); if (!basDevpService.updateById(sourceStaNo)){ throw new CoolException("更新源站失败"); } // 更新目标库位状态 LocMast locMast = locMastService.selectById(dto.getLocNo()); if (locMast.getLocType().equals("O")){ locMast.setLocType("S"); // S.入库预约 locMast.setModiUser(userId); locMast.setModiTime(new Date()); if (!locMastService.updateById(locMast)){ throw new CoolException("改变库位状态失败"); } } else { throw new CoolException(dto.getLocNo()+"目标库位已被占用"); } return dto.getLocNo(); } @Override @Transactional public void emptyPlateOut(EmptyPlateOutParam param, Long userId) { if (Cools.isEmpty(param.getOutSite())) { throw new CoolException("站点不存在"); } for (String locNo : param.getLocNos()) { // 获取工作号 int workNo = commonService.getWorkNo(DEFAULT_WORK_NO_TYPE); // 获取库位 LocMast locMast = locMastService.selectById(locNo); if (Cools.isEmpty(locMast)) { throw new CoolException(locNo+"库位不存在"); } // 获取源站 Wrapper wrapper = new EntityWrapper() .eq("type_no", 110) .eq("stn_no", param.getOutSite()) .eq("crn_no", locMast.getCrnNo()); StaDesc staDesc = staDescService.selectOne(wrapper); Integer sourceStaNo = staDesc.getCrnStn(); if (Cools.isEmpty(sourceStaNo)) { throw new CoolException("检索源站失败"); } // 保存工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(11L); // 工作状态:11.生成出库ID wrkMast.setIoType(110); // 入出库状态: 110.空板出库 wrkMast.setIoPri(10D); wrkMast.setSourceStaNo(sourceStaNo); // 源站 wrkMast.setStaNo(param.getOutSite()); // 目标站 wrkMast.setCrnNo(locMast.getCrnNo()); wrkMast.setSourceLocNo(locNo); // 源库位 wrkMast.setFullPlt("N"); // 满板:Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk("Y"); // 空板 wrkMast.setLinkMis("N"); wrkMast.setAppeUser(userId); wrkMast.setAppeTime(new Date()); wrkMast.setModiUser(userId); wrkMast.setModiTime(new Date()); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } // 更新库位状态 D.空板 -> R.出库预约 if (locMast.getLocType().equals("D")){ locMast.setLocType("R"); locMast.setModiUser(userId); locMast.setModiTime(new Date()); if (!locMastService.updateById(locMast)) { throw new CoolException("更新库位状态失败"); } } // todo 更新站点信息(工作号) } } @Override @Transactional public void locCheckOut(StockOutParam param, Long userId) { // 目标站点状态检测 BasDevp staNo = basDevpService.checkSiteStatus(param.getOutSite()); // 获取库位明细 List locDetlDtos = new ArrayList<>(); for (StockOutParam.LocDetl paramLocDetl : param.getLocDetls()) { if (!Cools.isEmpty(paramLocDetl.getLocNo(), paramLocDetl.getMatnr())) { LocDetl sqlParam = new LocDetl(); sqlParam.setLocNo(paramLocDetl.getLocNo()); sqlParam.setMatnr(paramLocDetl.getMatnr()); LocDetl one = locDetlService.selectOne(new EntityWrapper<>(sqlParam)); if (null != one) locDetlDtos.add(new LocDetlDto(one, one.getAnfme())); } } if (!locDetlDtos.isEmpty()) { // 启动出库开始 107.盘点出库 stockOut(staNo, locDetlDtos, 107, userId); } else { throw new CoolException("库位物料不存在"); } } @Override @Transactional public void locMove(String sourceLocNo, String locNo, Long userId) { LocMast sourceLoc = locMastService.selectById(sourceLocNo); if (Cools.isEmpty(sourceLoc)){ throw new CoolException("未找到库位"); } LocMast loc = locMastService.selectById(locNo); if (Cools.isEmpty(loc)){ throw new CoolException("未找到库位"); } if (!sourceLoc.getCrnNo().equals(loc.getCrnNo())) { throw new CoolException("移转库位属于不同堆垛机"); } // 获取工作号 int workNo = commonService.getWorkNo(DEFAULT_WORK_NO_TYPE); // 保存工作档 WrkMast wrkMast = new WrkMast(); wrkMast.setWrkNo(workNo); wrkMast.setIoTime(new Date()); wrkMast.setWrkSts(11L); // 工作状态:11.生成出库ID wrkMast.setIoType(110); // 入出库状态: 110.空板出库 wrkMast.setIoPri(10D); wrkMast.setCrnNo(sourceLoc.getCrnNo()); wrkMast.setSourceLocNo(sourceLocNo); // 源库位 wrkMast.setLocNo(locNo); // 目标库位 wrkMast.setFullPlt("N"); // 满板:Y wrkMast.setPicking("N"); // 拣料 wrkMast.setExitMk("N"); // 退出 wrkMast.setEmptyMk(sourceLoc.getLocType().equals("D")?"Y":"N"); // 空板 wrkMast.setLinkMis("N"); wrkMast.setAppeUser(userId); wrkMast.setAppeTime(new Date()); wrkMast.setModiUser(userId); wrkMast.setModiTime(new Date()); boolean res = wrkMastService.insert(wrkMast); if (!res) { throw new CoolException("保存工作档失败"); } // 工作档明细保存 List locDetls = locDetlService.selectList(new EntityWrapper().eq("loc_no", sourceLocNo)); for (LocDetl locDetl : locDetls) { WrkDetl wrkDetl = new WrkDetl(); wrkDetl.setWrkNo(workNo); wrkDetl.setIoTime(new Date()); wrkDetl.setMatnr(locDetl.getMatnr()); wrkDetl.setAnfme(locDetl.getAnfme()); wrkDetl.setZmatid(locDetl.getZmatid()); wrkDetl.setTbpos(locDetl.getTbpos()); wrkDetl.setTbnum(locDetl.getTbnum()); wrkDetl.setLgnum(locDetl.getLgnum()); wrkDetl.setAltme(locDetl.getAltme()); wrkDetl.setBname(locDetl.getBname()); wrkDetl.setMaktx(locDetl.getMaktx()); wrkDetl.setAppeTime(new Date()); wrkDetl.setAppeUser(userId); wrkDetl.setModiTime(new Date()); wrkDetl.setModiUser(userId); if (!wrkDetlService.insert(wrkDetl)) { throw new CoolException("保存工作档明细失败"); } } // 修改源库位状态 if (sourceLoc.getLocType().equals("D") || sourceLoc.getLocType().equals("F")) { sourceLoc.setLocType("R"); // R.出库预约 sourceLoc.setModiUser(userId); sourceLoc.setModiTime(new Date()); if (!locMastService.updateById(sourceLoc)){ throw new CoolException("更新源库位状态失败"); } } else { throw new CoolException("源库位出库失败,状态:"+sourceLoc.getLocType$()); } // 修改目标库位状态 if (loc.getLocType().equals("O")) { loc.setLocType("S"); // S.入库预约 loc.setModiTime(new Date()); loc.setModiUser(userId); if (!locMastService.updateById(loc)) { throw new CoolException("更新目标库位状态失败"); } } else { throw new CoolException("移转失败,目标库位状态:"+loc.getLocType$()); } } @Override @Transactional public void completeWrkMast(String workNo, Long userId) { WrkMast wrkMast = wrkMastService.selectById(workNo); if (Cools.isEmpty(wrkMast)){ throw new CoolException(workNo+"工作档不存在"); } if (wrkMast.getWrkSts() == 4 || wrkMast.getWrkSts() == 14) { throw new CoolException("当前工作档已完成"); } // 入库 + 库位转移 if (wrkMast.getWrkSts() < 4 || (wrkMast.getWrkSts() > 10 && wrkMast.getIoType()==11)) { wrkMast.setWrkSts(4L); // 出库 } else if (wrkMast.getWrkSts() > 10) { wrkMast.setWrkSts(14L); } wrkMast.setModiTime(new Date()); wrkMast.setModiUser(userId); if (!wrkMastService.updateById(wrkMast)) { throw new CoolException("修改工作档失败"); } } @Override @Transactional public void adjustLocDetl(LocDetlAdjustParam param, Long userId) { LocMast locMast = locMastService.selectById(param.getLocNo()); if (Cools.isEmpty(locMast)) { throw new CoolException("库位不存在"); } for (LocDetlAdjustParam.LocDetlAdjust adjust : param.getList()) { if (Cools.isEmpty(adjust.getMatnr())) { throw new CoolException(BaseRes.PARAM); } LocDetl sqlParam = new LocDetl(); sqlParam.setLocNo(locMast.getLocNo()); sqlParam.setMatnr(adjust.getMatnr()); LocDetl one = locDetlService.selectOne(new EntityWrapper<>(sqlParam)); // 保存新库存明细 if (Cools.isEmpty(one)) { if (adjust.getCount() == 0){ continue; } MatCode matCode = matCodeService.selectById(adjust.getMatnr()); LocDetl locDetl = new LocDetl(); locDetl.setLocNo(locMast.getLocNo()); locDetl.setMatnr(matCode.getMatNo()); locDetl.setMaktx(matCode.getMatName()); // 物料描述 locDetl.setAnfme(adjust.getCount()); // 数量 locDetl.setAltme(matCode.getStr1()); // 单位 // todo:luxiaoao locDetl.setLgnum("待定"); // 仓库号 locDetl.setTbnum(0); // 转储请求编号 locDetl.setTbpos(0); // 行项目 locDetl.setZmatid("待定"); // 物料标签ID locDetl.setZpallet("待定"); // 托盘条码 locDetl.setModiUser(userId); // 操作人员信息 locDetl.setModiTime(new Date()); locDetl.setAppeUser(userId); locDetl.setAppeTime(new Date()); if (!locDetlService.insert(locDetl)) { throw new CoolException("保存库存明细失败"); } // 保存调整记录 AdjDetl adjDetl = new AdjDetl(); adjDetl.setLocNo(locDetl.getLocNo()); adjDetl.setMatNo(locDetl.getMatnr()); adjDetl.setOriQty(0.0D); adjDetl.setAdjQty(adjust.getCount()); adjDetlService.save(adjDetl, userId); // 修改原库存明细 } else { // 如果数量修改,则更新库存明细 if (!adjust.getCount().equals(one.getAnfme())) { // 当数量被修改为 0 时,直接清除库存明细 if (adjust.getCount() == 0) { if (!locDetlService.delete(new EntityWrapper<>(one))) { throw new CoolException("清除库存明细失败"); } } else { LocDetl sqlParam1 = new LocDetl(); sqlParam1.setAnfme(adjust.getCount()); sqlParam1.setModiTime(new Date()); sqlParam1.setModiUser(userId); if (!locDetlService.update(sqlParam1, new EntityWrapper() .eq("loc_no", locMast.getLocNo()) .eq("matnr", adjust.getMatnr()))) { throw new CoolException("修改库存明细失败"); } } // 保存调整记录 AdjDetl adjDetl = new AdjDetl(); adjDetl.setLocNo(locMast.getLocNo()); adjDetl.setMatNo(adjust.getMatnr()); adjDetl.setOriQty(one.getAnfme()); adjDetl.setAdjQty(adjust.getCount()); adjDetlService.save(adjDetl, userId); } } } } @Override @Transactional public void cancelWrkMast(String workNo, Long userId) { WrkMast wrkMast = wrkMastService.selectById(workNo); if (Cools.isEmpty(wrkMast)){ throw new CoolException(workNo+"工作档不存在"); } String locNo = ""; // 待修改目标库位 String locType = ""; // 待修改目标库位状态 // 入库取消(修改目标库位) if (wrkMast.getWrkSts() < 4) { locNo = wrkMast.getLocNo(); locType = "O"; /** * 库位转移 * 取消后 源库位 ==>> F.在库 * 目标库位 ===>> O.空库位 **/ if (wrkMast.getIoType() == 11) { // 库位转移:源库位 LocMast locMast = locMastService.selectById(wrkMast.getSourceLocNo()); if (Cools.isEmpty(locMast)) { throw new CoolException("取消库位转移失败,源库位不存在:"+ wrkMast.getSourceLocNo()); } locMast.setLocType("F"); locMast.setModiTime(new Date()); locMast.setModiUser(userId); locMastService.updateById(locMast); } // 出库取消(修改源库位) } else if (wrkMast.getWrkSts() > 10 && wrkMast.getWrkSts() != 14) { locNo = wrkMast.getSourceLocNo(); // 出库 ===>> F.在库 if (wrkMast.getIoType() > 100 && wrkMast.getIoType() != 110) { locType = "F"; // 空板出库 ===>> D.空桶/空栈板 } else if (wrkMast.getIoType() == 110) { locType = "D"; // 库位转移 ===>> D.空桶/空栈板 } else if (wrkMast.getIoType() == 11) { locType = "F"; // 库位转移:目标库位 LocMast locMast = locMastService.selectById(wrkMast.getLocNo()); if (Cools.isEmpty(locMast)) { throw new CoolException("取消库位转移失败,目标库位不存在:"+ wrkMast.getSourceLocNo()); } locMast.setLocType("O"); locMast.setModiTime(new Date()); locMast.setModiUser(userId); locMastService.updateById(locMast); } } else { throw new CoolException("当前工作状态无法取消"); } // 删除工作档 boolean wrkMastRes = wrkMastService.deleteById(wrkMast); // 删除工作档明细 boolean wrkDetlRes = wrkDetlService.delete(new EntityWrapper().eq("wrk_no", workNo)); // 修改库位状态 LocMast locMast = locMastService.selectById(locNo); if (Cools.isEmpty(locMast)) { throw new CoolException("取消工作档失败,库位不存在:"+ locNo); } locMast.setLocType(locType); locMast.setModiTime(new Date()); locMast.setModiUser(userId); boolean locMastRes = locMastService.updateById(locMast); if (!wrkMastRes || !wrkDetlRes || !locMastRes) { throw new CoolException("保存数据失败"); } } }