a.id AS "id", a.venue_name AS "venueName", a.venue_address AS "venueAddress", a.venue_longitude AS "venueLongitude", a.venue_latitude AS "venueLatitude", a.venue_phone AS "venuePhone", 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.venue_info AS "venueInfo", a.del_flag AS "delFlag" SELECT FROM show_venue a WHERE a.id = #{id} SELECT FROM show_venue a a.del_flag = #{DEL_FLAG_NORMAL} AND a.venue_name LIKE CONCAT('%',#{venueName},'%') AND a.venue_address LIKE CONCAT('%',#{venueAddress},'%') ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM show_venue a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC INSERT INTO show_venue( id, venue_name, venue_address, venue_longitude, venue_latitude, venue_phone, create_by, create_date, update_by, update_date, remarks, venue_info, del_flag ) VALUES ( #{id}, #{venueName}, #{venueAddress}, #{venueLongitude}, #{venueLatitude}, #{venuePhone}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{venueInfo}, #{delFlag} ) UPDATE show_venue SET venue_name = #{venueName}, venue_address = #{venueAddress}, venue_longitude = #{venueLongitude}, venue_latitude = #{venueLatitude}, venue_phone = #{venuePhone}, update_by = #{updateBy.id}, update_date = #{updateDate}, venue_info = #{venueInfo}, remarks = #{remarks} WHERE id = #{id} UPDATE show_venue SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}