a.id AS "id",
a.show_level AS "showLevel",
a.mobile AS "mobile",
a.gender AS "gender",
a.name AS "name",
a.card_no AS "cardNo",
a.province AS "province",
a.city AS "city",
a.area AS "area",
a.street AS "street",
a.address AS "address",
a.dog_breed AS "dogBreed",
a.avatar AS "avatar",
a.member_code AS "memberCode",
a.school_name_cn AS "schoolNameCn",
a.order_price AS "orderPrice",
a.running_number AS "runningNumber",
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.apply_code AS "applyCode",
a.grade AS "grade",
a.del_flag AS "delFlag"
INSERT INTO groomer_package(
id,
show_level,
apply_code,
mobile,
gender,
name,
card_no,
province,
city,
area,
street,
address,
dog_breed,
avatar,
member_code,
school_name_cn,
order_price,
running_number,
payment_state,
payment_time,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{id},
#{showLevel},
#{applyCode},
#{mobile},
#{gender},
#{name},
#{cardNo},
#{province},
#{city},
#{area},
#{street},
#{address},
#{dogBreed},
#{avatar},
#{memberCode},
#{schoolNameCn},
#{orderPrice},
#{runningNumber},
#{paymentState},
#{paymentTime},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE groomer_package SET
show_level = #{showLevel},
apply_code = #{applyCode},
mobile = #{mobile},
gender = #{gender},
name = #{name},
card_no = #{cardNo},
province = #{province},
city = #{city},
area = #{area},
street = #{street},
address = #{address},
dog_breed = #{dogBreed},
avatar = #{avatar},
member_code = #{memberCode},
school_name_cn = #{schoolNameCn},
order_price = #{orderPrice},
running_number = #{runningNumber},
payment_state = #{paymentState},
payment_time = #{paymentTime},
update_by = #{updateBy.id},
update_date = #{updateDate},
grade = #{grade},
remarks = #{remarks}
WHERE id = #{id}
UPDATE groomer_package SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}