a.id AS "id", a.member_code AS "memberCode", a.identification_flag AS "identificationFlag", a.lock_state AS "lockState", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.remarks AS "remarks", a.del_flag AS "delFlag" m.name AS "memberName", m.province AS "province", m.city AS "city", m.area AS "area", m.street AS "street" LEFT JOIN sys_member m ON m.member_code = a.member_code SELECT FROM dog_chip_member_lock a WHERE a.id = #{id} SELECT , FROM dog_chip_member_lock a a.del_flag = #{DEL_FLAG_NORMAL} AND a.member_code = #{memberCode} AND a.identification_flag = #{identificationFlag} AND a.lock_state = #{lockState} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_chip_member_lock a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT count(a.id) FROM dog_chip_member_lock a a.del_flag = #{DEL_FLAG_NORMAL} AND a.member_code = #{memberCode} AND a.identification_flag = #{identificationFlag} AND a.id != #{id} SELECT FROM dog_chip_member_lock a WHERE a.identification_flag = #{identificationFlag} AND a.lock_state = #{lockState} SELECT FROM dog_chip_member_lock a WHERE a.member_code = #{memberCode} INSERT INTO dog_chip_member_lock (id, member_code, identification_flag, lock_state, create_by, create_date, update_by, update_date, remarks, del_flag) VALUES (#{id}, #{memberCode}, #{identificationFlag}, #{lockState}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag}) UPDATE dog_chip_member_lock SET member_code = #{memberCode}, identification_flag = #{identificationFlag}, lock_state = #{lockState}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE dog_chip_member_lock SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}