a.id AS "id", a.breed_certified_code AS "breedCertifiedCode", a.breeder_member_code AS "breederMemberCode", a.breeder AS "breeder", a.second_breeder_member_code AS "secondBreederMemberCode", a.second_breeder AS "secondBreeder", a.payment_state AS "paymentState", a.payment_time AS "paymentTime", a.review_state AS "reviewState", a.review_time AS "reviewTime", a.review_remarks AS "reviewRemarks", a.running_number AS "runningNumber", a.process_state AS "processState", a.process_time AS "processTime", 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" SELECT FROM dog_second_breeder a WHERE a.id = #{id} SELECT FROM dog_second_breeder a WHERE a.del_flag = '0' AND a.breed_certified_code = #{breedCertifiedCode} SELECT FROM dog_second_breeder a WHERE a.del_flag = '0' AND a.breed_certified_code = #{breedCertifiedCode} AND a.running_number = #{orderCode} SELECT FROM dog_second_breeder a WHERE a.del_flag = '0' AND a.breed_certified_code IN #{item} SELECT FROM dog_second_breeder a WHERE a.del_flag = '0' AND a.running_number = #{runningNumber} SELECT FROM dog_second_breeder a a.del_flag = #{DEL_FLAG_NORMAL} AND a.breed_certified_code = #{breedCertifiedCode} AND (a.breeder_member_code = #{breederMemberCode} OR a.second_breeder_member_code = #{breederMemberCode} OR a.breeder LIKE concat(#{breederMemberCode},'%') OR a.second_breeder LIKE concat(#{breederMemberCode},'%') ) AND a.running_number = #{runningNumber} 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_second_breeder a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_second_breeder( id, breed_certified_code, breeder_member_code, breeder, second_breeder_member_code, second_breeder, payment_state, payment_time, review_state, review_time, review_remarks, running_number, process_state, process_time, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{breedCertifiedCode}, #{breederMemberCode}, #{breeder}, #{secondBreederMemberCode}, #{secondBreeder}, #{paymentState}, #{paymentTime}, #{reviewState}, #{reviewTime}, #{reviewRemarks}, #{runningNumber}, #{processState}, #{processTime}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE dog_second_breeder SET breed_certified_code = #{breedCertifiedCode}, breeder_member_code = #{breederMemberCode}, breeder = #{breeder}, second_breeder_member_code = #{secondBreederMemberCode}, second_breeder = #{secondBreeder}, payment_state = #{paymentState}, payment_time = #{paymentTime}, review_state = #{reviewState}, review_time = #{reviewTime}, review_remarks = #{reviewRemarks}, running_number = #{runningNumber}, process_state = #{processState}, process_time = #{processTime}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE dog_second_breeder SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}