a.id AS "id",
a.name AS "name",
a.price AS "price",
a.coupon_def_id AS "couponDefId",
a.business_refund AS "businessRefund",
a.create_date AS "createDate",
a.create_by AS "createBy.id",
a.update_by AS "updateBy.id",
a.update_date AS "updateDate",
a.remarks AS "remarks",
a.expansion1 AS "expansion1",
a.expansion2 AS "expansion2",
a.del_flag AS "delFlag"
INSERT INTO payment_charging_item_group(
name,
price,
coupon_def_id,
num,
create_date,
create_by,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{name},
#{price},
#{couponDefId},
#{num},
#{createDate},
#{createBy.id},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE payment_charging_item_group SET
name = #{name},
price = #{price},
coupon_def_id = #{couponDefId},
num = #{num},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE payment_charging_item_group SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}