a.id AS "id",
a.referee_name_cn AS "refereeNameCn",
a.referee_name_en AS "refereeNameEn",
a.referee_sex AS "refereeSex",
a.referee_citizenship AS "refereeCitizenship",
a.referee_picture AS "refereePicture",
a.referee_introduce AS "refereeIntroduce",
a.referee_type AS "refereeType",
a.referee_title AS "refereeTitle",
a.referee_link_order AS "refereeLinkOrder",
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.type AS "type",
a.del_flag AS "delFlag",
a.referee_signature_photo AS "refereeSignaturePhoto"
INSERT INTO groomer_show_referee(
id,
referee_name_cn,
referee_name_en,
referee_sex,
referee_citizenship,
referee_picture,
referee_introduce,
referee_type,
referee_title,
referee_link_order,
create_by,
create_date,
update_by,
update_date,
remarks,
type,
del_flag,
referee_signature_photo
) VALUES (
#{id},
#{refereeNameCn},
#{refereeNameEn},
#{refereeSex},
#{refereeCitizenship},
#{refereePicture},
#{refereeIntroduce},
#{refereeType},
#{refereeTitle},
#{refereeLinkOrder},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{type},
#{delFlag},
#{refereeSignaturePhoto}
)
UPDATE groomer_show_referee SET
referee_name_cn = #{refereeNameCn},
referee_name_en = #{refereeNameEn},
referee_sex = #{refereeSex},
referee_citizenship = #{refereeCitizenship},
referee_picture = #{refereePicture},
referee_introduce = #{refereeIntroduce},
referee_type = #{refereeType},
referee_title = #{refereeTitle},
referee_link_order = #{refereeLinkOrder},
type = #{type},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
referee_signature_photo = #{refereeSignaturePhoto}
WHERE id = #{id}
UPDATE groomer_show_referee SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}