a.id AS "id",
a.dna_parents_compare_id AS "dnaParentsCompareId",
a.breed_advise AS "breedAdvise",
a.merit_assessment AS "meritAssessment",
a.payment_member_code AS "paymentMemberCode",
a.operator AS "operator",
a.price AS "price",
a.del_time AS "delTime",
a.running_number AS "runningNumber",
a.payment_state AS "paymentState",
a.payment_time AS "paymentTime",
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"
INSERT INTO dog_chip_insurance(
id,
dna_parents_compare_id,
birth_code,
pedigree_certified,
breed_advise,
merit_assessment,
payment_member_code,
operator,
price,
del_time,
running_number,
payment_state,
payment_time,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{dnaParentsCompareId},
#{birthCode},
#{pedigreeCertified},
#{breedAdvise},
#{meritAssessment},
#{paymentMemberCode},
#{operator},
#{price},
#{delTime},
#{runningNumber},
#{paymentState},
#{paymentTime},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE dog_chip_insurance SET
dna_parents_compare_id = #{dnaParentsCompareId}
birth_code = #{birthCode},
pedigree_certified = #{pedigreeCertified},
breed_advise = #{breedAdvise},
merit_assessment = #{meritAssessment},
payment_member_code = #{paymentMemberCode},
operator = #{operator},
price = #{price},
del_time = #{delTime},
running_number = #{runningNumber},
payment_state = #{paymentState},
payment_time = #{paymentTime},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE dog_chip_insurance SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE dog_chip_insurance
SET breed_advise = #{fileUrl}
SET merit_assessment = #{fileUrl}
WHERE id = #{id}