a.id AS "id",
a.dna_archive_id AS "dnaArchiveId",
a.sampling_code AS "samplingCode",
a.old_sampling_code AS "oldSamplingCode",
a.operator AS "operator",
a.running_number AS "runningNumber",
a.source AS "source",
a.price AS "price",
a.payment_member_code AS "paymentMemberCode",
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",
sm.name AS "paymentMemberName"
left join sys_member sm on a.payment_member_code = sm.member_code
INSERT INTO dog_dna_archive_reissue_sampling(
id,
dna_archive_id,
sampling_code,
old_sampling_code,
operator,
running_number,
source,
price,
payment_member_code,
payment_state,
payment_time,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{dnaArchiveId},
#{samplingCode},
#{oldSamplingCode},
#{operator},
#{runningNumber},
#{source},
#{price},
#{paymentMemberCode},
#{paymentState},
#{paymentTime},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE dog_dna_archive_reissue_sampling SET
dna_archive_id = #{dnaArchiveId},
sampling_code = #{samplingCode},
old_sampling_code = #{oldSamplingCode},
operator = #{operator},
running_number = #{runningNumber},
source = #{source},
price = #{price},
payment_member_code = #{paymentMemberCode},
payment_state = #{paymentState},
payment_time = #{paymentTime},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE dog_dna_archive_reissue_sampling SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}