修改 微服务新增报错

lidongdong

2023-04-07 500fea8d096b7e6edd2c4f177c4c18b896156e38

修改  微服务新增报错

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComFmsServiceRecordDAO.java

@@ -25,6 +25,8 @@
     */
    int insertBatch(@Param("entities") List<ComFmsServiceRecord> entities);

    int insertOneBatch(@Param("entitie") ComFmsServiceRecord entities);

    /**
     * 批量新增或按主键更新数据（MyBatis原生foreach方法）
     *

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComFmsServiceServiceImpl.java

@@ -302,7 +302,7 @@
            comFmsServiceRecord.setImage(adminDTO.getServiceImage());
            comFmsServiceRecord.setStage(ComFmsServiceRecord.Stage.TJFWSQ);
            comFmsServiceRecord.setCreatedBy(userInfo.getUserId());
            comFmsServiceRecordDAO.insert(comFmsServiceRecord);
            comFmsServiceRecordDAO.insertOneBatch(comFmsServiceRecord);
            return R.ok();
        }
        return R.fail("操作失败，请重新尝试");

 springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComFmsServiceRecordMapper.xml

@@ -21,6 +21,51 @@
            #{entity.createdBy})
        </foreach>
    </insert>


    <insert id="insertOneBatch" parameterType="com.panzhihua.service_community.entity.ComFmsServiceRecord">
        insert into smart_life.com_fms_service_record
        <trim prefix="(" suffix=")" suffixOverrides=",">
            <if test="entitie.serviceId != null">
                service_id,
            </if>
            <if test="entitie.stage != null">
                stage,
            </if>
            <if test="entitie.content != null">
                content,
            </if>
            <if test="entitie.image != null">
                image,
            </if>
            <if test="entitie.createdBy != null">
                created_by,
            </if>
            created_at
        </trim>
        <trim prefix="values (" suffix=")" suffixOverrides=",">
            <if test="entitie.serviceId != null">
                #{entitie.serviceId},
            </if>
            <if test="entitie.stage != null">
                #{entitie.stage},
            </if>
            <if test="entitie.content != null">
                #{entitie.content},
            </if>
            <if test="entitie.image != null">
                #{entitie.image},
            </if>
            <if test="entitie.createdBy != null">
                #{entitie.createdBy},
            </if>
            sysdate()
        </trim>
    </insert>




    <!-- 批量插入或按主键更新 -->
    <insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
        insert into smart_life.com_fms_service_record(service_id, stage, content, image, created_at, created_by)