diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.java index 0e59662..2fe0f5f 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.java @@ -22,5 +22,7 @@ Long selectMaxNo(); + Integer updateCertificate(@Param("id") Long id, @Param("certificateFile") String certificateFile); + BizEquipmentStandardCheckRecordApproval selectDetailById(@Param("id") Long id); } diff --git a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.java b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.java index 0e59662..2fe0f5f 100644 --- a/casic-metering-dao/src/main/java/com/casic/missiles/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.java +++ b/casic-metering-dao/src/main/java/com/casic/missiles/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.java @@ -22,5 +22,7 @@ Long selectMaxNo(); + Integer updateCertificate(@Param("id") Long id, @Param("certificateFile") String certificateFile); + BizEquipmentStandardCheckRecordApproval selectDetailById(@Param("id") Long id); } diff --git a/casic-metering-dao/src/main/resources/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.xml b/casic-metering-dao/src/main/resources/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.xml index 9651a57..dd5a3ba 100644 --- a/casic-metering-dao/src/main/resources/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.xml +++ b/casic-metering-dao/src/main/resources/mapper/equipment/BizEquipmentStandardCheckRecordApprovalMapper.xml @@ -87,6 +87,12 @@ SELECT IFNULL(max(RIGHT(record_no, 3)), 0) from biz_equipment_standard_check_record_approval + + update biz_equipment_standard_check_record_approval + set check_record_file=#{certificateFile} + where id=#{id} + + + + update biz_equipment_standard_check_record_approval + set check_record_file=#{certificateFile} + where id=#{id} + + + + update biz_equipment_standard_check_record_approval + set check_record_file=#{certificateFile} + where id=#{id} + + + + update biz_equipment_standard_check_record_approval + set check_record_file=#{certificateFile} + where id=#{id} + +