a.id AS "id",
a.show_main_id AS "showMainId",
a.show_apply_id AS "showApplyId",
a.running_number AS "runningNumber",
a.discount_sign AS "discountSign",
a.cycle_sign AS "cycleSign",
a.is_discount AS "isDiscount",
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_apply_discount(
id,
show_main_id,
show_apply_id,
running_number,
discount_sign,
cycle_sign,
cycle_sign_no,
is_discount,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{showMainId},
#{showApplyId},
#{runningNumber},
#{discountSign},
#{cycleSign},
#{cycleSignNo},
#{isDiscount},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE show_apply_discount SET
show_main_id = #{showMainId},
show_apply_id = #{showApplyId},
running_number = #{runningNumber},
discount_sign = #{discountSign},
cycle_sign = #{cycleSign},
is_discount = #{isDiscount},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE show_apply_discount SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}