a.id AS "id",
a.name AS "name",
a.manager AS "manager",
a.phone AS "phone",
a.office_phone AS "officePhone",
a.address AS "address",
a.zip_code AS "zipCode",
a.responsible_area AS "responsibleArea",
a.foreign_apply_email AS "foreignApplyEmail",
a.working_time AS "workingTime",
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 show_office(
id,
name,
manager,
phone,
office_phone,
address,
zip_code,
responsible_area,
foreign_apply_email,
working_time,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{name},
#{manager},
#{phone},
#{officePhone},
#{address},
#{zipCode},
#{responsibleArea},
#{foreignApplyEmail},
#{workingTime},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE show_office SET
name = #{name},
manager = #{manager},
phone = #{phone},
office_phone = #{officePhone},
address = #{address},
zip_code = #{zipCode},
responsible_area = #{responsibleArea},
foreign_apply_email = #{foreignApplyEmail},
working_time = #{workingTime},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE show_office SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}