diff --git a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierMapper.xml b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierMapper.xml
index dcfcb02..c357b85 100644
--- a/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierMapper.xml
+++ b/casic-metering-dao/src/main/resources/mapper/resource/BizResourceStaffVerifierMapper.xml
@@ -36,19 +36,19 @@
             and brsi.station like concat('%',#{request.station},'%')
         </if>
         <if test="request.certType != null and request.certType !=''">
-            and brsv.certType  =  #{request.certType}
+            and brsv.cert_type  =  #{request.certType}
         </if>
         <if test="request.certNo != null and request.certNo !=''">
-            and brsv.certNo like concat('%',#{request.certNo},'%')
+            and brsv.cert_no like concat('%',#{request.certNo},'%')
         </if>
         <if test="request.certName != null and request.certName !=''">
-            and brsv.certName like concat('%',#{request.certName},'%')
+            and brsv.cert_name like concat('%',#{request.certName},'%')
         </if>
         <if test="request.beginTime != null and request.beginTime !=''">
-            and brsv.beginTime  >= #{request.beginTime}
+            and brsv.effective_date  >= #{request.beginTime}
         </if>
         <if test="request.endTime != null and request.endTime !=''">
-            and brsv.endTime &lt;= #{request.endTime}
+            and brsv.effective_date &lt;= #{request.endTime}
         </if>
         <if test="request.ids != null">
             and brsv.id in