a.id AS "id",
a.dog_owner AS "dogOwner",
a.member_code AS "memberCode",
a.dog_name AS "dogName",
a.birthdate AS "birthdate",
a.gender AS "gender",
a.color_flag AS "colorFlag",
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.review_state AS "reviewState",
a.review_time AS "reviewTime",
a.review_remarks AS "reviewRemarks",
a.running_number AS "runningNumber",
a.payment_state AS "paymentState",
a.payment_time AS "paymentTime",
a.process_time AS "processTime",
a.process_state AS "processState"
INSERT INTO dog_tibetan_mastiff(
id,
dog_owner,
member_code,
dog_name,
birthdate,
gender,
color_flag,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag,
review_state,
review_time,
review_remarks
) VALUES (
#{id},
#{dogOwner},
#{memberCode},
#{dogName},
#{birthdate},
#{gender},
#{colorFlag},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag},
#{reviewState},
#{reviewTime},
#{reviewRemarks}
)
UPDATE dog_tibetan_mastiff SET
dog_owner = #{dogOwner},
member_code = #{memberCode},
dog_name = #{dogName},
birthdate = #{birthdate},
gender = #{gender},
color_flag = #{colorFlag},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE id = #{id}
UPDATE dog_tibetan_mastiff SET
remarks = concat(IFNULL(remarks,''),#{remarks}),
del_flag = #{DEL_FLAG_DELETE}
WHERE id = #{id}
UPDATE dog_tibetan_mastiff SET
review_state = #{reviewState},
review_remarks = #{reviewRemarks},
review_time = #{reviewTime}
where id = #{id}