a.id AS "id", a.payout_state AS "payoutState", a.review_state AS "reviewState", a.process_state AS "processState", a.now_state AS "nowState", a.error_info AS "errorInfo", a.success_info AS "successInfo", a.operator AS "operator", a.censor AS "censor", a.add_time AS "addTime", a.review_remarks AS "reviewRemarks", a.member_code AS "memberCode", a.table_name AS "tableName", a.business_id AS "businessId", a.running_number AS "runningNumber" SELECT FROM sys_za_log a WHERE a.id = #{id} SELECT FROM sys_za_log a ORDER BY ${page.orderBy} SELECT FROM sys_za_log a ORDER BY ${page.orderBy} INSERT INTO sys_za_log( id, payout_state, review_state, process_state, now_state, error_info, success_info, operator, censor, add_time, member_code, table_name, business_id, running_number, review_remarks ) VALUES ( #{id}, #{payoutState}, #{reviewState}, #{processState}, #{nowState}, #{errorInfo}, #{successInfo}, #{operator}, #{censor}, #{addTime}, #{memberCode}, #{tableName}, #{businessId}, #{runningNumber}, #{reviewRemarks} ) UPDATE sys_za_log SET payout_state = #{payoutState}, review_state = #{reviewState}, process_state = #{processState}, now_state = #{nowState}, error_info = #{errorInfo}, success_info = #{successInfo}, operator = #{operator}, censor = #{censor}, add_time = #{addTime}, member_code = #{memberCode}, table_name = #{tableName}, business_id = #{businessId}, running_number = #{runningNumber}, review_remarks = #{reviewRemarks} WHERE id = #{id} DELETE FROM sys_za_log WHERE id = #{id}