a.banner_id AS "bannerId",
a.banner_name AS "bannerName",
a.banner_sort AS "bannerSort",
a.banner_place AS "bannerPlace",
a.banner_type AS "bannerType",
a.banner_action AS "bannerAction",
a.banner_route AS "bannerRoute",
a.kennel_name AS "kennelName",
a.kennel_manager AS "kennelManager",
a.kennel_breed AS "kennelBreed",
a.kennel_breed_desc AS "kennelBreedDesc",
a.kennel_province AS
"kennelProvince",
a.kennel_city AS "kennelCity",
a.kennel_area AS
"kennelArea",
a.banner_img AS "bannerImg",
a.start_date AS "startDate",
a.end_date AS "endDate",
a.banner_status AS "bannerStatus",
a.kennel_code AS "kennelCode",
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 app_banner(
banner_id,
banner_name,
banner_sort,
banner_place,
banner_type,
banner_action,
banner_route,
kennel_name,
kennel_manager,
kennel_breed,
kennel_breed_desc,
kennel_province,
kennel_city,
kennel_area,
banner_img,
start_date,
end_date,
banner_status,
kennel_code,
create_by,
create_date,
update_by,
update_date,
remarks,
del_flag
) VALUES (
#{bannerId},
#{bannerName},
#{bannerSort},
#{bannerPlace},
#{bannerType},
#{bannerAction},
#{bannerRoute},
#{kennelName},
#{kennelManager},
#{kennelBreed},
#{kennelBreedDesc},
#{kennelProvince},
#{kennelCity},
#{kennelArea},
#{bannerImg},
#{startDate},
#{endDate},
#{bannerStatus},
#{kennelCode},
#{createBy.id},
#{createDate},
#{updateBy.id},
#{updateDate},
#{remarks},
#{delFlag}
)
UPDATE app_banner SET
banner_id = #{bannerId},
banner_name = #{bannerName},
banner_sort = #{bannerSort},
banner_place = #{bannerPlace},
banner_type = #{bannerType},
banner_action = #{bannerAction},
banner_route = #{bannerRoute},
kennel_name = #{kennelName},
kennel_manager = #{kennelManager},
kennel_breed = #{kennelBreed},
kennel_breed_desc = #{kennelBreedDesc},
kennel_province = #{kennelProvince},
kennel_city = #{kennelCity},
kennel_area = #{kennelArea},
banner_img = #{bannerImg},
start_date = #{startDate},
end_date = #{endDate},
banner_status = #{bannerStatus},
kennel_code = #{kennelCode},
update_by = #{updateBy.id},
update_date = #{updateDate},
remarks = #{remarks}
WHERE banner_id = #{id}
UPDATE app_banner SET
del_flag = #{DEL_FLAG_DELETE}
WHERE banner_id = #{id}
UPDATE app_banner SET
banner_status = #{bannerStatus}
WHERE banner_id = #{id}