From d0bff7a4d7e0bd53f11ea629df20e48c3f72a0e6 Mon Sep 17 00:00:00 2001 From: xyc <jc_xiong@hotmail.com> Date: 星期一, 14 十月 2024 10:09:00 +0800 Subject: [PATCH] 修改RBD识别算法 --- modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java | 77 +++++++++++++++++++++++--------------- 1 files changed, 47 insertions(+), 30 deletions(-) diff --git a/modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java b/modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java index 7aa9a65..b62fc7b 100644 --- a/modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java +++ b/modules/mainPart/src/main/java/com/zt/life/modules/mainPart/basicInfo/service/XhProductModelService.java @@ -159,7 +159,7 @@ Long curXtId = null; Long curFxtId = null; - Long curSbId = null; + Long curSbId; String curXtName = ""; String curFxtName = ""; @@ -194,22 +194,23 @@ String xt = com.zt.core.shiro.ImportUtil.getCellValue(row, 1, pattern); //绯荤粺 String fxt = com.zt.core.shiro.ImportUtil.getCellValue(row, 2, pattern); String sb = com.zt.core.shiro.ImportUtil.getCellValue(row, 3, pattern); //璁惧 - String equipType = com.zt.core.shiro.ImportUtil.getCellValue(row, 4, pattern); //璁惧绫诲瀷 - String reliabDistribType = com.zt.core.shiro.ImportUtil.getCellValue(row, 5, pattern); //鍙潬鎬у垎甯冪被鍨� - String basicJoinCompute = com.zt.core.shiro.ImportUtil.getCellValue(row, 6, pattern); //鍙傚姞璁$畻 - String basicMtbfRegulate = com.zt.core.shiro.ImportUtil.getCellValue(row, 7, pattern); //mtbf - String basicMtbfRegulSuccRate = com.zt.core.shiro.ImportUtil.getCellValue(row, 8, pattern); //鎴愬姛鐜� - String basicMtbfOperatingRatio = com.zt.core.shiro.ImportUtil.getCellValue(row, 9, pattern); //杩愯姣� - String taskMtbcfRegulate = com.zt.core.shiro.ImportUtil.getCellValue(row, 10, pattern); //mtbcf - String taskMtbcfOtherParams2 = com.zt.core.shiro.ImportUtil.getCellValue(row, 11, pattern); //mtbcf鍏朵粬鍙傛暟2 - String taskMtbcfOtherParams3 = com.zt.core.shiro.ImportUtil.getCellValue(row, 12, pattern); //mtbcf鍏朵粬鍙傛暟3 - String taskMtbcfRegulSuccRate = com.zt.core.shiro.ImportUtil.getCellValue(row, 13, pattern); //mtbcf鎴愬姛鐜� - String taskMtbcfOperatingRatio = com.zt.core.shiro.ImportUtil.getCellValue(row, 14, pattern); //mtbcf杩愯姣� - String repairable = com.zt.core.shiro.ImportUtil.getCellValue(row, 15, pattern); //鏄惁鍙淮淇� - String repairDistribType = com.zt.core.shiro.ImportUtil.getCellValue(row, 16, pattern); //缁翠慨鍙戝竷绫诲瀷 - String repairMttcr = com.zt.core.shiro.ImportUtil.getCellValue(row, 17, pattern); //mttcr - String repairMttcrOtherParams2 = com.zt.core.shiro.ImportUtil.getCellValue(row, 18, pattern); //mttcr鍏朵粬鍙傛暟2 - String repairMttcrOtherParams3 = com.zt.core.shiro.ImportUtil.getCellValue(row, 19, pattern); //mttcr鍏朵粬鍙傛暟3 + String sameSbName = com.zt.core.shiro.ImportUtil.getCellValue(row, 4, pattern); //鍚岀被璁惧鍚嶇О + String equipType = com.zt.core.shiro.ImportUtil.getCellValue(row, 5, pattern); //璁惧绫诲瀷 + String reliabDistribType = com.zt.core.shiro.ImportUtil.getCellValue(row, 6, pattern); //鍙潬鎬у垎甯冪被鍨� + String basicJoinCompute = com.zt.core.shiro.ImportUtil.getCellValue(row, 7, pattern); //鍙傚姞璁$畻 + String basicMtbfRegulate = com.zt.core.shiro.ImportUtil.getCellValue(row, 8, pattern); //mtbf + String basicMtbfRegulSuccRate = com.zt.core.shiro.ImportUtil.getCellValue(row, 9, pattern); //鎴愬姛鐜� + String basicMtbfOperatingRatio = com.zt.core.shiro.ImportUtil.getCellValue(row, 10, pattern); //杩愯姣� + String taskMtbcfRegulate = com.zt.core.shiro.ImportUtil.getCellValue(row, 11, pattern); //mtbcf + String taskMtbcfOtherParams2 = com.zt.core.shiro.ImportUtil.getCellValue(row, 12, pattern); //mtbcf鍏朵粬鍙傛暟2 + String taskMtbcfOtherParams3 = com.zt.core.shiro.ImportUtil.getCellValue(row, 13, pattern); //mtbcf鍏朵粬鍙傛暟3 + String taskMtbcfRegulSuccRate = com.zt.core.shiro.ImportUtil.getCellValue(row, 14, pattern); //mtbcf鎴愬姛鐜� + String taskMtbcfOperatingRatio = com.zt.core.shiro.ImportUtil.getCellValue(row, 15, pattern); //mtbcf杩愯姣� + String repairable = com.zt.core.shiro.ImportUtil.getCellValue(row, 16, pattern); //鏄惁鍙淮淇� + String repairDistribType = com.zt.core.shiro.ImportUtil.getCellValue(row, 17, pattern); //缁翠慨鍙戝竷绫诲瀷 + String repairMttcr = com.zt.core.shiro.ImportUtil.getCellValue(row, 18, pattern); //mttcr + String repairMttcrOtherParams2 = com.zt.core.shiro.ImportUtil.getCellValue(row, 19, pattern); //mttcr鍏朵粬鍙傛暟2 + String repairMttcrOtherParams3 = com.zt.core.shiro.ImportUtil.getCellValue(row, 20, pattern); //mttcr鍏朵粬鍙傛暟3 if (StringUtils.isBlank(sb)) continue; @@ -254,6 +255,10 @@ paramId = modelMap.get(sbPath).getParamId(); } + if(StringUtils.isBlank(sameSbName)){ + sameSbName = sb; + } + if (StringUtils.isEmpty(sb)) { com.zt.life.util.ImportUtil.updateErrMap(errMap, "娌℃湁濉啓璁惧鍚嶇О", sheetName, row1); continue; @@ -281,7 +286,6 @@ ParamData itemEntity = new ParamData(); itemEntity.setShipId(shipId); itemEntity.setProductId(curXtId); - itemEntity.setPageCode("expect"); paramDataService.insert(itemEntity); } @@ -301,21 +305,23 @@ ParamData itemEntity = new ParamData(); itemEntity.setShipId(shipId); itemEntity.setProductId(curFxtId); - itemEntity.setPageCode("expect"); paramDataService.insert(itemEntity); } + xhProductModel.setPid(curFxtId == null ? curXtId : curFxtId); + xhProductModel.setId(curSbId); + xhProductModel.setName(sb); + xhProductModel.setSameSbName(sameSbName); + xhProductModel.setEquipType(equipType); + xhProductModel.setProductType("5"); + xhProductModel.setSort(Integer.valueOf(sort)); + defultImg = sysPictureBaseService.getDefaultImg(5).getId(); + xhProductModel.setOperatImg(defultImg); + xhProductModel.setNamePath(sbPath); if (insertSb) { - xhProductModel.setPid(curFxtId == null ? curXtId : curFxtId); - xhProductModel.setId(curSbId); - xhProductModel.setName(sb); - xhProductModel.setEquipType(equipType); - xhProductModel.setProductType("5"); - xhProductModel.setSort(Integer.valueOf(sort)); - defultImg = sysPictureBaseService.getDefaultImg(5).getId(); - xhProductModel.setOperatImg(defultImg); - xhProductModel.setNamePath(sbPath); this.insert(xhProductModel); + }else{ + this.update(xhProductModel); } //瀵煎叆棰勮鍙傛暟 @@ -323,7 +329,6 @@ //缁戝畾璁惧ID itemEntity.setShipId(shipId); itemEntity.setProductId(curSbId); - itemEntity.setPageCode("expect"); itemEntity.setReliabDistribType(reliabType.get(reliabDistribType)); itemEntity.setBasicJoinCompute(isOrNot.get(basicJoinCompute)); if (StringUtils.isNotBlank(basicMtbfRegulate)) { @@ -393,11 +398,23 @@ return list; } - private void deleteByShipId(Long shipId) { + public void deleteByShipId(Long shipId) { baseDao.deleteByShipId(shipId); } private List<XhProductModel> getByShipId(Long shipId) { return baseDao.getByShipId(shipId); } + + public void deleteByPid(Long id) { + baseDao.deleteByPid(id); + } + + public Long[] getByPid(Long id) { + return baseDao.getByPid(id); + } + + public void exportDataExcel(Long shipId) { + baseDao.getProductByShip(shipId); + } } -- Gitblit v1.9.1