diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java
index 55b2895..81d229a 100644
--- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java
+++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java
@@ -36,6 +36,8 @@
String customTemplateByCategory(@Param("templateType") String templateType,
@Param("itemCategoryId") Long itemCategoryId);
+ String getMeasureAddress(@Param("addressId")String addressId);
+
@Select("SELECT count(id) from biz_business_device_measure_approval where approval_status = 4 and sample_id = #{sampleId} and order_id=#{orderId}")
Long selectSampleCertifications(@Param("sampleId") Long sampleId, @Param("orderId") Long orderId);
diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java
index 55b2895..81d229a 100644
--- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java
+++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/business/BizBusinessDeviceMeasureApprovalMapper.java
@@ -36,6 +36,8 @@
String customTemplateByCategory(@Param("templateType") String templateType,
@Param("itemCategoryId") Long itemCategoryId);
+ String getMeasureAddress(@Param("addressId")String addressId);
+
@Select("SELECT count(id) from biz_business_device_measure_approval where approval_status = 4 and sample_id = #{sampleId} and order_id=#{orderId}")
Long selectSampleCertifications(@Param("sampleId") Long sampleId, @Param("orderId") Long orderId);
diff --git a/casic-metering-dao/src/main/resources/mapper/business/BizBusinessDeviceMeasureApprovalMapper.xml b/casic-metering-dao/src/main/resources/mapper/business/BizBusinessDeviceMeasureApprovalMapper.xml
index 7af9cb9..390f354 100644
--- a/casic-metering-dao/src/main/resources/mapper/business/BizBusinessDeviceMeasureApprovalMapper.xml
+++ b/casic-metering-dao/src/main/resources/mapper/business/BizBusinessDeviceMeasureApprovalMapper.xml
@@ -102,6 +102,12 @@
AND template_type= #{templateType}
+
+
+
+
+
+
+
+