a.id AS "id", a.member_code AS "memberCode", a.member_name AS "memberName", a.order_code AS "orderCode", a.refund_order_code AS "refundOrderCode", a.total_price AS "totalPrice", a.part_refund_flag AS "partRefundFlag", a.part_refund_price AS "partRefundPrice", a.charging_item_id AS "chargingItemId", a.refund_remark AS "refundRemark", a.charging_item_name AS "chargingItemName", a.review_state AS "reviewState", a.review_time AS "reviewTime", a.review_remarks AS "reviewRemarks", a.process_state AS "processState", a.process_time AS "processTime", a.process_person AS "processPerson", 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" SELECT FROM payment_order_refund a WHERE a.id = #{id} SELECT FROM payment_order_refund a a.del_flag = #{DEL_FLAG_NORMAL} AND a.member_code = #{memberCode} AND a.member_name LIKE '%'||#{memberName}||'%' '%'+#{memberName}+'%' concat('%',#{memberName},'%') AND a.order_code = #{orderCode} AND a.refund_order_code = #{refundOrderCode} AND a.part_refund_flag = #{partRefundFlag} AND a.charging_item_id = #{chargingItemId} AND a.review_state = #{reviewState} AND a.process_state = #{processState} AND a.process_time = #{processTime} AND a.process_person = #{processPerson} AND a.create_by = #{createBy.id} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM payment_order_refund a a.del_flag = #{DEL_FLAG_NORMAL} ORDER BY ${page.orderBy} ORDER BY a.update_date DESC SELECT FROM payment_order_refund a a.del_flag = '0' AND a.id in #{item} SELECT FROM payment_order_refund a a.del_flag = '0' AND a.order_code in #{item} INSERT INTO payment_order_refund( id, member_code, member_name, order_code, refund_order_code, total_price, part_refund_flag, part_refund_price, charging_item_id, refund_remark, charging_item_name, review_state, review_time, review_remarks, process_state, process_time, process_person, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{id}, #{memberCode}, #{memberName}, #{orderCode}, #{refundOrderCode}, #{totalPrice}, #{partRefundFlag}, #{partRefundPrice}, #{chargingItemId}, #{refundRemark}, #{chargingItemName}, #{reviewState}, #{reviewTime}, #{reviewRemarks}, #{processState}, #{processTime}, #{processPerson}, #{createBy.id}, #{createDate}, #{updateBy.id}, #{updateDate}, #{remarks}, #{delFlag} ) INSERT INTO payment_order_refund( id, member_code, member_name, order_code, refund_order_code, total_price, part_refund_flag, part_refund_price, charging_item_id, refund_remark, charging_item_name, review_state, review_time, review_remarks, process_state, process_time, process_person, create_by, create_date, update_by, update_date, remarks, del_flag ) VALUES ( #{data.id}, #{data.memberCode}, #{data.memberName}, #{data.orderCode}, #{data.refundOrderCode}, #{data.totalPrice}, #{data.partRefundFlag}, #{data.partRefundPrice}, #{data.chargingItemId}, #{data.refundRemark}, #{data.chargingItemName}, #{data.reviewState}, #{data.reviewTime}, #{data.reviewRemarks}, #{data.processState}, #{data.processTime}, #{data.processPerson}, #{data.createBy.id}, #{data.createDate}, #{data.updateBy.id}, #{data.updateDate}, #{data.remarks}, #{data.delFlag} ) UPDATE payment_order_refund SET member_code = #{memberCode}, member_name = #{memberName}, order_code = #{orderCode}, refund_order_code = #{refundOrderCode}, total_price = #{totalPrice}, part_refund_flag = #{partRefundFlag}, part_refund_price = #{partRefundPrice}, charging_item_id = #{chargingItemId}, refund_remark = #{refundRemark}, charging_item_name = #{chargingItemName}, review_state = #{reviewState}, review_time = #{reviewTime}, review_remarks = #{reviewRemarks}, process_state = #{processState}, process_time = #{processTime}, process_person = #{processPerson}, update_by = #{updateBy.id}, update_date = #{updateDate}, remarks = #{remarks} WHERE id = #{id} UPDATE payment_order_refund SET refund_order_code = #{data.refundOrderCode}, process_state = #{data.processState}, process_time = #{data.processTime}, process_person = #{data.processPerson}, update_by = #{data.updateBy.id}, update_date = #{data.updateDate} WHERE id = #{data.id} UPDATE payment_order_refund SET process_state = #{data.processState}, process_time = #{data.processTime}, process_person = #{data.processPerson}, update_by = #{data.updateBy.id}, update_date = #{data.updateDate} WHERE id in #{item} UPDATE payment_order_refund SET del_flag = #{DEL_FLAG_DELETE} WHERE id = #{id}