a.id AS "id", a.fmdog_breed_certified_code AS "fmdogBreedCertifiedCode", a.dog_breed AS "dogBreed", a.amphimixis_date AS "amphimixisDate", a.fdog_pedigree_certified AS "fdogPedigreeCertified", a.mdog_pedigree_certified AS "mdogPedigreeCertified", a.kennel_name AS "kennelName", a.number_births AS "numberBirths", a.number_stillbirths AS "numberStillbirths", a.number_abort AS "numberAbort", a.number_deaths_puppies AS "numberDeathsPuppies", a.number_foster_dogs AS "numberFosterDogs", a.number_herds_dogs AS "numberHerdsDogs", a.number_registered_dogs AS "numberRegisteredDogs", a.same_fetal_dog AS "sameFetalDog", a.breeder AS "breeder", a.breeder_address AS "breederAddress", a.breeder_member_code AS "breederMemberCode", 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_amphimixis_prove a WHERE a.id = #{id} SELECT FROM dog_amphimixis_prove a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM dog_amphimixis_prove a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO dog_amphimixis_prove( id, fmdog_breed_certified_code, dog_breed, amphimixis_date, fdog_pedigree_certified, mdog_pedigree_certified, kennel_name, number_births, number_stillbirths, number_abort, number_deaths_puppies, number_foster_dogs, number_herds_dogs, number_registered_dogs, same_fetal_dog, breeder, breeder_address, breeder_member_code, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{fmdogBreedCertifiedCode}, #{dogBreed}, #{amphimixisDate}, #{fdogPedigreeCertified}, #{mdogPedigreeCertified}, #{kennelName}, #{numberBirths}, #{numberStillbirths}, #{numberAbort}, #{numberDeathsPuppies}, #{numberFosterDogs}, #{numberHerdsDogs}, #{numberRegisteredDogs}, #{sameFetalDog}, #{breeder}, #{breederAddress}, #{breederMemberCode}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) UPDATE dog_amphimixis_prove SET fmdog_breed_certified_code = #{fmdogBreedCertifiedCode}, dog_breed = #{dogBreed}, amphimixis_date = #{amphimixisDate}, fdog_pedigree_certified = #{fdogPedigreeCertified}, mdog_pedigree_certified = #{mdogPedigreeCertified}, kennel_name = #{kennelName}, number_births = #{numberBirths}, number_stillbirths = #{numberStillbirths}, number_abort = #{numberAbort}, number_deaths_puppies = #{numberDeathsPuppies}, number_foster_dogs = #{numberFosterDogs}, number_herds_dogs = #{numberHerdsDogs}, number_registered_dogs = #{numberRegisteredDogs}, same_fetal_dog = #{sameFetalDog}, breeder = #{breeder}, breeder_address = #{breederAddress}, breeder_member_code = #{breederMemberCode}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE dog_amphimixis_prove SET remarks = concat(IFNULL(remarks,''),#{remarks}), del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} select id, fmdog_breed_certified_code, dog_breed, amphimixis_date, fdog_pedigree_certified, mdog_pedigree_certified, kennel_name, number_births, number_stillbirths, number_abort, number_deaths_puppies, number_foster_dogs, number_herds_dogs, number_registered_dogs, same_fetal_dog, breeder, breeder_address, breeder_member_code, create_by, create_date, update_by, update_date, remarks, del_flag from dog_amphimixis_prove where fmdog_breed_certified_code=#{fmdogBreedCertifiedCode} order by update_date desc UPDATE dog SET fdog_pedigree_certified = #{fdogPedigreeCertified}, mdog_pedigree_certified = #{mdogPedigreeCertified}, breeder = #{breeder} WHERE fmdog_breed_certified_code = #{fmdogBreedCertifiedCode}