From a811176f1b310bc0f58b994c42789ad2ca3ac721 Mon Sep 17 00:00:00 2001 From: Crunchy <3114200645@qq.com> Date: 星期四, 11 七月 2024 18:02:08 +0800 Subject: [PATCH] 标准库导入添加检验判断 --- inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardTreeMapper.java | 2 +- inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java | 13 ++++++------- inspect-server/src/main/resources/mapper/StandardProductListMapper.xml | 3 +++ inspect-server/src/main/resources/mapper/StandardTreeMapper.xml | 3 +++ inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardProductListMapper.java | 2 +- 5 files changed, 14 insertions(+), 9 deletions(-) diff --git a/inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardProductListMapper.java b/inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardProductListMapper.java index 95b38a9..a95a131 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardProductListMapper.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardProductListMapper.java @@ -17,7 +17,7 @@ IPage<StandardProductList> standardProductListIPage(Integer id, String tree, IPage<StandardProductList> page, String laboratory, String insItem, String insItems); - StandardProductList getOne(Integer standardMethodListId, String inspectionItem, String sample, String inspectionItemSubclass, String model); + StandardProductList getOne(Integer standardMethodListId, String inspectionItem, String sample, String inspectionItemSubclass, String model, String inspectionItemClass); List<StandardProductList> selectDetail(@Param("standardMethodListId") Integer standardMethodListId, @Param("state") int state, @Param("model") String model); diff --git a/inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardTreeMapper.java b/inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardTreeMapper.java index 496ea7b..be5575d 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardTreeMapper.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/mapper/StandardTreeMapper.java @@ -41,7 +41,7 @@ String getLaboratory(String str); - Integer getStructureItemParameterId(String sampleType, String item, String itemChild); + Integer getStructureItemParameterId(String sampleType, String item, String itemChild, String inspectionItemClass); List<ProductDto> selectPList(String name); diff --git a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java index 8a3deb0..9ea8481 100644 --- a/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java +++ b/inspect-server/src/main/java/com/yuanchu/mom/service/impl/StandardTreeServiceImpl.java @@ -222,7 +222,7 @@ } StandardProductList db_str; try { - db_str = standardProductListMapper.getOne(str.getStandardMethodListId(), str.getInspectionItem(), str.getSample(), str.getInspectionItemSubclass(), str.getModel()); + db_str = standardProductListMapper.getOne(str.getStandardMethodListId(), str.getInspectionItem(), str.getSample(), str.getInspectionItemSubclass(), str.getModel(), str.getInspectionItemClass()); } catch (Exception e) { throw new ErrorException("閲嶅鏌ヨ锛�" + str.getInspectionItem() + " " + str.getInspectionItemSubclass()); } @@ -269,9 +269,9 @@ str.setState(1); str.setTree(str.getFactory() + " - " + str.getLaboratory() + " - " + str.getSampleType() + " - " + str.getSample() + " - " + (str.getModel() == null ? "" : str.getModel())); try { - str.setStructureItemParameterId(standardTreeMapper.getStructureItemParameterId("\"" + str.getSampleType() + "\"", str.getInspectionItem(), str.getInspectionItemSubclass())); + str.setStructureItemParameterId(standardTreeMapper.getStructureItemParameterId("\"" + str.getSampleType() + "\"", str.getInspectionItem(), str.getInspectionItemSubclass(), str.getInspectionItemClass())); } catch (Exception e) { - str.setStructureItemParameterId(standardTreeMapper.getStructureItemParameterId("\"" + str.getSampleType() + "\",\"" + str.getSample() + "\"", str.getInspectionItem(), str.getInspectionItemSubclass())); + str.setStructureItemParameterId(standardTreeMapper.getStructureItemParameterId("\"" + str.getSampleType() + "\",\"" + str.getSample() + "\"", str.getInspectionItem(), str.getInspectionItemSubclass(), str.getInspectionItemClass())); } if (str.getStructureItemParameterId() == null) { throw new ErrorException("妫�楠岄」鐩笉瀛樺湪锛�" + str.getInspectionItem() + " " + str.getInspectionItemSubclass()); @@ -350,7 +350,7 @@ } StandardProductList db_str; try { - db_str = standardProductListMapper.getOne(str.getStandardMethodListId(), str.getInspectionItem(), str.getSample(), str.getInspectionItemSubclass(), str.getModel()); + db_str = standardProductListMapper.getOne(str.getStandardMethodListId(), str.getInspectionItem(), str.getSample(), str.getInspectionItemSubclass(), str.getModel(), str.getInspectionItemClass()); } catch (Exception e) { throw new ErrorException("閲嶅鏌ヨ锛�" + str.getInspectionItem() + " " + str.getInspectionItemSubclass()); } @@ -361,7 +361,6 @@ if (list.get(10) != null) { str.setMethodS(list.get(10) + ""); } - if (list.get(13) == null) { str.setTell(null); } else { @@ -397,9 +396,9 @@ str.setState(1); str.setTree(str.getFactory() + " - " + str.getLaboratory() + " - " + str.getSampleType() + " - " + str.getSample() + " - " + (str.getModel() == null ? "" : str.getModel())); try { - str.setStructureItemParameterId(standardTreeMapper.getStructureItemParameterId("\"" + str.getSampleType() + "\"", str.getInspectionItem(), str.getInspectionItemSubclass())); + str.setStructureItemParameterId(standardTreeMapper.getStructureItemParameterId("\"" + str.getSampleType() + "\"", str.getInspectionItem(), str.getInspectionItemSubclass(), str.getInspectionItemClass())); } catch (Exception e) { - str.setStructureItemParameterId(standardTreeMapper.getStructureItemParameterId("\"" + str.getSampleType() + "\",\"" + str.getSample() + "\"", str.getInspectionItem(), str.getInspectionItemSubclass())); + str.setStructureItemParameterId(standardTreeMapper.getStructureItemParameterId("\"" + str.getSampleType() + "\",\"" + str.getSample() + "\"", str.getInspectionItem(), str.getInspectionItemSubclass(), str.getInspectionItemClass())); } if (str.getStructureItemParameterId() == null) { throw new ErrorException("妫�楠岄」鐩笉瀛樺湪锛�" + str.getInspectionItem() + " " + str.getInspectionItemSubclass()); diff --git a/inspect-server/src/main/resources/mapper/StandardProductListMapper.xml b/inspect-server/src/main/resources/mapper/StandardProductListMapper.xml index 932e582..3202056 100644 --- a/inspect-server/src/main/resources/mapper/StandardProductListMapper.xml +++ b/inspect-server/src/main/resources/mapper/StandardProductListMapper.xml @@ -61,6 +61,9 @@ <if test="model!=null"> and model = #{model} </if> + <if test="inspectionItemClass != null and inspectionItemClass != ''"> + and inspection_item_class = #{inspectionItemClass} + </if> </select> <select id="selectDetail" resultType="com.yuanchu.mom.pojo.StandardProductList"> select * from standard_product_list diff --git a/inspect-server/src/main/resources/mapper/StandardTreeMapper.xml b/inspect-server/src/main/resources/mapper/StandardTreeMapper.xml index 47e1cc0..90f8e50 100644 --- a/inspect-server/src/main/resources/mapper/StandardTreeMapper.xml +++ b/inspect-server/src/main/resources/mapper/StandardTreeMapper.xml @@ -308,6 +308,9 @@ <if test="itemChild != null and itemChild != ''"> and inspection_item_subclass = #{itemChild} </if> + <if test="inspectionItemClass != null and inspectionItemClass != ''"> + and inspection_item_class = #{inspectionItemClass} + </if> <if test="itemChild == null or itemChild == ''"> and (inspection_item_subclass is null or inspection_item_subclass = '') </if> -- Gitblit v1.9.3