a.id AS "id", a.dog_nose AS "dogNose", a.dog_chip AS "dogChip", a.nose_type AS "noseType", a.del_flag AS "delFlag", a.create_by AS "createBy.id", a.create_date AS "createDate", a.update_by AS "updateBy.id", a.update_date AS "updateDate", a.device_type AS "deviceType", a.device_model AS "deviceModel", a.club_code AS "clubCode", a.nose_result AS "noseResult", a.success_sort AS "successSort", a.nose_result_info AS "noseResultInfo" SELECT FROM dog_nose_result a WHERE a.id = #{id} SELECT FROM dog_nose_result a a.del_flag = #{DEL_FLAG_NORMAL} AND (a.dog_chip =#{dogChip} or a.dog_nose =#{dogChip}) AND a.nose_type =#{noseType} AND a.device_type =#{deviceType} AND a.nose_result =#{noseResult} AND a.success_sort =#{successSort} AND date_format(a.create_date, '%Y-%m-%d') = ]]> date_format(#{beginCreateDate}, '%Y-%m-%d') AND date_format(a.create_date, '%Y-%m-%d') date_format(#{endCreateDate}, '%Y-%m-%d') ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_nose_result a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_nose_result( id, dog_nose, dog_chip, nose_type, del_flag, create_by, create_date, update_by, update_date, device_type, device_model, club_code, nose_result, success_sort, nose_result_info ) VALUES ( #{id}, #{dogNose}, #{dogChip}, #{noseType}, #{delFlag}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{deviceType}, #{deviceModel}, #{clubCode}, #{noseResult}, #{successSort}, #{noseResultInfo} ) UPDATE dog_nose_result SET dog_nose = #{dogNose}, dog_chip = #{dogChip}, nose_type = #{noseType}, update_by = #{updateBy.id}, update_date = #{updateDate}, device_type = #{deviceType}, device_model = #{deviceModel}, club_code = #{clubCode}, nose_result = #{noseResult}, success_sort = #{successSort}, nose_result_info = #{noseResultInfo} WHERE id = #{id} UPDATE dog_nose_result SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}