a.id AS "id",
a.commodity_name AS "commodityName",
a.commodity_id AS "commodityId",
a.dog_type AS "dogType",
a.member_code AS "memberCode",
a.name AS "name",
a.mobile AS "mobile",
a.payment_state AS "paymentState",
a.payment_time AS "paymentTime",
a.price AS "price",
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",
a.running_number AS "runningNumber",
a.del_time AS "delTime",
a.version AS "version"
INSERT INTO buying_order(
id,
commodity_name,
commodity_id,
dog_type,
member_code,
name,
mobile,
payment_state,
payment_time,
price,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
running_number,
del_time,
version
) VALUES (
#{id},
#{commodityName},
#{commodityId},
#{dogType},
#{memberCode},
#{name},
#{mobile},
#{paymentState},
#{paymentTime},
#{price},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{runningNumber},
#{delTime},
#{version}
)
UPDATE buying_order SET
commodity_name = #{commodityName},
commodity_id = #{commodityId},
dog_type = #{dogType},
member_code = #{memberCode},
name = #{name},
mobile = #{mobile},
payment_state = #{paymentState},
payment_time = #{paymentTime},
price = #{price},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks},
running_number = #{runningNumber},
del_time = #{delTime},
version = #{version}
WHERE id = #{id}
UPDATE buying_order SET
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}