From 4fd5d868a3e3b28bf6f55a1aa12212db70e1550f Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期五, 07 四月 2023 18:27:34 +0800
Subject: [PATCH] 修改 微服务新增报错
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComFmsServiceServiceImpl.java | 2
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComFmsServiceDAO.java | 2 +
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComFmsServiceMapper.xml | 92 ++++++++++++++++++++++++++++++++++++++++++++++
3 files changed, 95 insertions(+), 1 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComFmsServiceDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComFmsServiceDAO.java
index b074f6d..8856182 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComFmsServiceDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComFmsServiceDAO.java
@@ -14,6 +14,7 @@
import com.panzhihua.common.model.vos.community.fms.ComFmsTeamVO;
import com.panzhihua.common.model.vos.community.fms.FmsServiceTopStatisticsVO;
import com.panzhihua.common.model.vos.grid.EventVO;
+import com.panzhihua.service_community.entity.ComFmsServiceRecord;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Mapper;
import com.panzhihua.service_community.entity.ComFmsService;
@@ -36,6 +37,7 @@
*/
int insertBatch(@Param("entities") List<ComFmsService> entities);
+ int addBracelet(@Param("entitie") ComFmsService entities);
/**
* 批量新增或按主键更新数据（MyBatis原生foreach方法）
*
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComFmsServiceServiceImpl.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComFmsServiceServiceImpl.java
index 0ee4814..f724134 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComFmsServiceServiceImpl.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/service/impl/ComFmsServiceServiceImpl.java
@@ -294,7 +294,7 @@
comFmsService.setUserId(userInfo.getUserId());
comFmsService.setUserName(userInfo.getNickName());
comFmsService.setPhone(userInfo.getPhone());
- int num = this.baseMapper.insert(comFmsService);
+ int num = this.baseMapper.addBracelet(comFmsService);
if (num > 0) {
// ComFmsServiceRecord comFmsServiceRecord = new ComFmsServiceRecord();
// comFmsServiceRecord.setServiceId(comFmsService.getId());
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComFmsServiceMapper.xml b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComFmsServiceMapper.xml
index e8d8aca..0423093 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComFmsServiceMapper.xml
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/resources/mapper/ComFmsServiceMapper.xml
@@ -29,6 +29,98 @@
(#{entity.userName}, #{entity.userId}, #{entity.phone}, #{entity.serviceContent}, #{entity.serviceImage}, #{entity.approvalContent}, #{entity.approvalAt}, #{entity.memberId}, #{entity.serviceStatus}, #{entity.serviceAt}, #{entity.createdAt}, #{entity.createdBy}, #{entity.updatedAt}, #{entity.updatedBy}, #{entity.communityId})
</foreach>
</insert>
+
+
+ <insert id="addBracelet" parameterType="com.panzhihua.service_community.entity.ComFmsService" >
+ insert into bracelet_user_data
+ <trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="entitie.userName != null">
+ user_name,
+ </if>
+ <if test="entitie.userId != null">
+ user_id,
+ </if>
+ <if test="entitie.phone != null">
+ phone,
+ </if>
+ <if test="entitie.serviceContent != null">
+ service_content,
+ </if>
+ <if test="entitie.serviceImage != null">
+ service_image,
+ </if>
+ <if test="entitie.approvalContent != null">
+ approval_content,
+ </if>
+ <if test="entitie.approvalAt != null">
+ approval_at,
+ </if>
+ <if test="entitie.memberId != null">
+ member_id,
+ </if>
+ <if test="entitie.serviceStatus != null">
+ service_status,
+ </if>
+ <if test="entitie.serviceAt != null">
+ service_at,
+ </if>
+ <if test="entitie.createdBy != null">
+ created_by,
+ </if>
+ <if test="entitie.updatedBy != null">
+ updated_by,
+ </if>
+ <if test="entitie.communityId != null">
+ community_id,
+ </if>
+ created_at
+ </trim>
+ <trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="entitie.userName != null">
+ #{entitie.userName},
+ </if>
+ <if test="entitie.userId != null">
+ #{entitie.userId},
+ </if>
+ <if test="entitie.phone != null">
+ #{entitie.phone},
+ </if>
+ <if test="entitie.serviceContent != null">
+ #{entitie.serviceContent},
+ </if>
+ <if test="entitie.serviceImage != null">
+ #{entitie.serviceImage},
+ </if>
+ <if test="entitie.approvalContent != null">
+ #{entitie.approvalContent},
+ </if>
+ <if test="entitie.approvalAt != null">
+ #{entitie.approvalAt},
+ </if>
+ <if test="entitie.memberId != null">
+ #{entitie.memberId},
+ </if>
+ <if test="entitie.serviceStatus != null">
+ #{entitie.serviceStatus},
+ </if>
+ <if test="entitie.serviceAt != null">
+ #{entitie.serviceAt},
+ </if>
+ <if test="entitie.createdBy != null">
+ #{entitie.createdBy},
+ </if>
+ <if test="entitie.updatedBy != null">
+ #{entitie.updatedBy},
+ </if>
+ <if test="entitie.communityId != null">
+ #{entitie.communityId},
+ </if>
+ sysdate()
+ </trim>
+ </insert>
+
+
+
<!-- 批量插入或按主键更新 -->
<insert id="insertOrUpdateBatch" keyProperty="id" useGeneratedKeys="true">
insert into smart_life.com_fms_service(user_name, user_id, phone, service_content, service_image, approval_content, approval_at, member_id, service_status, service_at, created_at, created_by, updated_at, updated_by, community_id)
--
Gitblit v1.7.1