diff --git a/casic-metering-dao/src/main/resources/mapper/meter/MeterTraceSupplierMapper.xml b/casic-metering-dao/src/main/resources/mapper/meter/MeterTraceSupplierMapper.xml
index 3e3829a..7b9d598 100644
--- a/casic-metering-dao/src/main/resources/mapper/meter/MeterTraceSupplierMapper.xml
+++ b/casic-metering-dao/src/main/resources/mapper/meter/MeterTraceSupplierMapper.xml
@@ -65,7 +65,7 @@
         mtsp.job, mtsp.phone AS personPhone, mts.process_id
         FROM meter_trace_supplier mts
         LEFT JOIN meter_trace_supplier_person mtsp ON mts.id = mtsp.supplier_id
-        WHERE mts.id = #{id} AND mts.is_del = 0
+        WHERE mts.id = #{id} AND mts.is_del = 0 AND mtsp.is_del = 0
     </select>
 
     <select id="selectDraftListForApproval" resultType="com.casic.missiles.model.meter.MeterTraceSupplier">

diff --git a/casic-metering-dao/src/main/resources/mapper/meter/MeterTraceSupplierMapper.xml b/casic-metering-dao/src/main/resources/mapper/meter/MeterTraceSupplierMapper.xml
index 3e3829a..7b9d598 100644
--- a/casic-metering-dao/src/main/resources/mapper/meter/MeterTraceSupplierMapper.xml
+++ b/casic-metering-dao/src/main/resources/mapper/meter/MeterTraceSupplierMapper.xml
@@ -65,7 +65,7 @@
         mtsp.job, mtsp.phone AS personPhone, mts.process_id
         FROM meter_trace_supplier mts
         LEFT JOIN meter_trace_supplier_person mtsp ON mts.id = mtsp.supplier_id
-        WHERE mts.id = #{id} AND mts.is_del = 0
+        WHERE mts.id = #{id} AND mts.is_del = 0 AND mtsp.is_del = 0
     </select>
 
     <select id="selectDraftListForApproval" resultType="com.casic.missiles.model.meter.MeterTraceSupplier">
diff --git a/casic-metering-model/src/main/java/com/casic/missiles/model/meter/MeterOrganize.java b/casic-metering-model/src/main/java/com/casic/missiles/model/meter/MeterOrganize.java
index 0f3e84f..d392218 100644
--- a/casic-metering-model/src/main/java/com/casic/missiles/model/meter/MeterOrganize.java
+++ b/casic-metering-model/src/main/java/com/casic/missiles/model/meter/MeterOrganize.java
@@ -7,6 +7,7 @@
 import com.alibaba.excel.annotation.write.style.ContentStyle;
 import com.alibaba.excel.annotation.write.style.HeadRowHeight;
 import com.alibaba.excel.enums.poi.BorderStyleEnum;
+import com.baomidou.mybatisplus.annotation.FieldStrategy;
 import com.baomidou.mybatisplus.annotation.TableField;
 import com.baomidou.mybatisplus.annotation.TableId;
 import com.baomidou.mybatisplus.annotation.TableName;
@@ -101,7 +102,7 @@
      */
     @DictCodeField(message = "计量专业不合法", cacheName = MeterDictCode.MEASURE_MAJOR)
     @ApiModelProperty(value = "计量专业（字典code）", dataType = "String")
-    @TableField("meter_major")
+    @TableField(value = "meter_major", updateStrategy = FieldStrategy.IGNORED)
     private String meterMajor;
 
     @ExcelProperty("专业")
@@ -114,7 +115,7 @@
      */
     @ApiModelProperty(value = "技术职务（字典code）", dataType = "String")
     @DictCodeField(message = "技术职务不合法", cacheName = MeterDictCode.TECHNOLOGY_JOB)
-    @TableField("technology_job")
+    @TableField(value = "technology_job", updateStrategy = FieldStrategy.IGNORED)
     private String technologyJob;
 
     @ExcelProperty("技术职务")
@@ -127,7 +128,7 @@
      */
     @ApiModelProperty(value = "行政职务（字典code）", dataType = "String")
     @DictCodeField(message = "行政职务不合法", cacheName = MeterDictCode.ADMINISTRATION_JOB)
-    @TableField("administration_job")
+    @TableField(value = "administration_job", updateStrategy = FieldStrategy.IGNORED)
     private String administrationJob;
 
     @ExcelProperty("行政职务")