| | |
| | | </resultMap> |
| | | |
| | | <sql id="selectApsWorkOrderJobLogVo"> |
| | | select id, page_num, page_count, response_data, result, order_id, request_data,create_time, update_time from aps_work_order_job_log |
| | | select id, page_num, page_count, response_data, result, order_id, request_data,create_time, |
| | | update_time ,biz_type |
| | | from aps_work_order_job_log |
| | | </sql> |
| | | |
| | | <select id="selectApsWorkOrderJobLogList" parameterType="ApsWorkOrderJobLog" resultMap="ApsWorkOrderJobLogResult"> |
| | |
| | | <if test="result != null and result != ''"> and result = #{result}</if> |
| | | <if test="orderId != null and orderId != ''"> and order_id = #{orderId}</if> |
| | | <if test="requestData != null and requestData != ''"> and request_data = #{requestData}</if> |
| | | <if test="bizType != null and bizType != ''"> and biz_type = #{bizType}</if> |
| | | </where> |
| | | </select> |
| | | |
| | |
| | | <if test="requestData != null">request_data,</if> |
| | | <if test="createTime != null">create_time,</if> |
| | | <if test="updateTime != null">update_time,</if> |
| | | <if test="bizType != null">biz_type,</if> |
| | | </trim> |
| | | <trim prefix="values (" suffix=")" suffixOverrides=","> |
| | | <if test="pageNum != null">#{pageNum},</if> |
| | |
| | | <if test="requestData != null">#{requestData},</if> |
| | | <if test="createTime != null">#{createTime},</if> |
| | | <if test="updateTime != null">#{updateTime},</if> |
| | | <if test="bizType != null">#{bizType},,</if> |
| | | </trim> |
| | | </insert> |
| | | |
| | |
| | | <if test="requestData != null">request_data = #{requestData},</if> |
| | | <if test="createTime != null">create_time = #{createTime},</if> |
| | | <if test="updateTime != null">update_time = #{updateTime},</if> |
| | | <if test="bizType != null">biz_type = #{bizType},</if> |
| | | </trim> |
| | | where id = #{id} |
| | | </update> |