a.id AS "id", a.page_name AS "pageName", a.product_name AS "productName", a.service_cycle AS "serviceCycle", a.charging_item_id AS "chargingItemId", a.charging_item_name AS "chargingItemName", a.sale_start_time AS "saleStartTime", a.page_item AS "pageItem", a.valid_start_time AS "validStartTime", a.valid_end_time AS "validEndTime", a.product_detail AS "productDetail", a.expect_count AS "expectCount", a.most_count AS "mostCount", 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.version AS "version", a.del_flag AS "delFlag" SELECT FROM cku_advertisement a WHERE a.id = #{id} SELECT FROM cku_advertisement a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM cku_advertisement a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO cku_advertisement( id, page_name, product_name, service_cycle, charging_item_id, charging_item_name, sale_start_time, page_item, valid_start_time, valid_end_time, product_detail, expect_count, most_count, create_by, create_date, update_by, update_date, remarks, version, del_flag ) VALUES ( #{id}, #{pageName}, #{productName}, #{serviceCycle}, #{chargingItemId}, #{chargingItemName}, #{saleStartTime}, #{pageItem}, #{validStartTime}, #{validEndTime}, #{productDetail}, #{expectCount}, #{mostCount}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{version}, #{delFlag} ) UPDATE cku_advertisement SET page_name = #{pageName}, product_name = #{productName}, service_cycle = #{serviceCycle}, charging_item_id = #{chargingItemId}, charging_item_name = #{chargingItemName}, sale_start_time = #{saleStartTime}, page_item = #{pageItem}, valid_start_time = #{validStartTime}, valid_end_time = #{validEndTime}, product_detail = #{productDetail}, expect_count = #{expectCount}, most_count = #{mostCount}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE cku_advertisement SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id} SELECT FROM cku_advertisement a WHERE page_item = #{pageItem}