| | |
| | | */ |
| | | int updateTaskResultById(GdTaskResultEntity taskResult); |
| | | |
| | | /** |
| | | * 批量插入成果信息 |
| | | * |
| | | * @param list 成果实体列表 |
| | | * @return 影响行数 |
| | | */ |
| | | int insertBatch(List<GdTaskResultEntity> list); |
| | | |
| | | } |
| | |
| | | WHERE id = #{id} |
| | | </update> |
| | | |
| | | <!-- 批量插入成果信息 --> |
| | | <insert id="insertBatch" parameterType="java.util.List"> |
| | | INSERT INTO ja_gd_task_result ( |
| | | patrol_task_id, result_code, result_url, shoot_time, |
| | | photo_data, longitude, latitude, distribute_status, area_code, |
| | | create_user, create_dept, create_time, update_user, update_time, |
| | | status, is_deleted |
| | | ) VALUES |
| | | <foreach collection="list" item="item" separator=","> |
| | | ( |
| | | #{item.patrolTaskId}, #{item.resultCode}, #{item.resultUrl}, #{item.shootTime}, |
| | | #{item.photoData}::jsonb, #{item.longitude}, #{item.latitude}, #{item.distributeStatus}, #{item.areaCode}, |
| | | #{item.createUser}, #{item.createDept}, #{item.createTime}, #{item.updateUser}, #{item.updateTime}, |
| | | #{item.status}, #{item.isDeleted} |
| | | ) |
| | | </foreach> |
| | | </insert> |
| | | |
| | | </mapper> |
| | |
| | | gdTaskResult.setAreaCode(processedAreaCode); |
| | | }); |
| | | // 执行批量保存并返回结果 |
| | | return saveBatch(gdTaskResultEntities); |
| | | int result = baseMapper.insertBatch(gdTaskResultEntities); |
| | | return result > 0; |
| | | } |
| | | |
| | | @Override |