From c488d63b58458ea0dee56ffbb4c5b66b2141d4f1 Mon Sep 17 00:00:00 2001
From: liurunyu <lry9898@163.com>
Date: 星期五, 30 五月 2025 09:59:30 +0800
Subject: [PATCH] 去除画蛇添足代码
---
pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/PrBatchNumberMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/StaWipSnExMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/PrBillOfMaterialMapper.xml | 14 +++-
pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/OthFileManageMapper.xml | 14 +++-
pms-parent/pms-global/src/main/resources/mapper/PltProductFileMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/PltProductionLineMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml | 10 ++
pms-parent/pms-global/src/main/resources/mapper/PltMaterialMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/StaDevOpsTaskClaimInfoMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/OthStatisticDeviceMapper.xml | 14 +++-
pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/PltProductUnqualifiedReasonMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/StaDeviceLastMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/OthStatisticWorkloadMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/PrDevOpsPlanMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeLastMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/PrOrderItemMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/PltProductMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/StaRepairInfoMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkLastMapper.xml | 8 +-
pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkHistoryMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/StaDeviceProductionLogMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/PrProductionProcessMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/PrProductionNodeMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/PrDeviceMapper.xml | 4
pms-parent/pms-global/src/main/resources/mapper/PrWorkingInstructionMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/PrOrderMapper.xml | 2
pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml | 8 +-
34 files changed, 91 insertions(+), 67 deletions(-)
diff --git a/pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml
index 7ba5226..eb61a0b 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/BaLogMapper.xml
@@ -24,7 +24,7 @@
from ba_log
where id = #{id,jdbcType=BIGINT}
</select>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoBa.BaLog" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoBa.BaLog">
<!--@mbg.generated-->
insert into ba_log (id, user_id,user_name, content, ip,code,msg
)
@@ -37,10 +37,13 @@
#{msg,jdbcType=VARCHAR}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoBa.BaLog" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoBa.BaLog">
<!--@mbg.generated-->
insert into ba_log
<trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ id,
+ </if>
<if test="userId != null">
user_id,
</if>
@@ -61,6 +64,9 @@
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ #{id,jdbcType=BIGINT},
+ </if>
<if test="userId != null">
#{userId,jdbcType=BIGINT},
</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml
index ce6fba1..237d292 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/MpOpenIdMapper.xml
@@ -39,7 +39,7 @@
delete from mp_open_id
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoMp.MpOpenId" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoMp.MpOpenId">
insert into mp_open_id
( id,open_id,session_key
,nick_name,head_img_url,phone
@@ -50,7 +50,7 @@
,#{gender,jdbcType=VARCHAR},#{province,jdbcType=VARCHAR},#{createTime,jdbcType=TIMESTAMP}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoMp.MpOpenId" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoMp.MpOpenId">
insert into mp_open_id
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/OthFileManageMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/OthFileManageMapper.xml
index d7dc4e0..7566219 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/OthFileManageMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/OthFileManageMapper.xml
@@ -28,16 +28,19 @@
delete from oth_file_manage
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoOth.OthFileManage" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoOth.OthFileManage">
<!--@mbg.generated-->
- insert into oth_file_manage (user_id, file_id, deleted, dt)
- values (#{userId,jdbcType=BIGINT}, #{fileId,jdbcType=BIGINT}, #{deleted,jdbcType=TINYINT},
+ insert into oth_file_manage (id, user_id, file_id, deleted, dt)
+ values (#{id,jdbcType=BIGINT},#{userId,jdbcType=BIGINT}, #{fileId,jdbcType=BIGINT}, #{deleted,jdbcType=TINYINT},
#{dt,jdbcType=TIMESTAMP})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoOth.OthFileManage" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoOth.OthFileManage">
<!--@mbg.generated-->
insert into oth_file_manage
<trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ id,
+ </if>
<if test="userId != null">
user_id,
</if>
@@ -52,6 +55,9 @@
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ #{id,jdbcType=BIGINT},
+ </if>
<if test="userId != null">
#{userId,jdbcType=BIGINT},
</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/OthStatisticDeviceMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/OthStatisticDeviceMapper.xml
index c25f811..224d4b3 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/OthStatisticDeviceMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/OthStatisticDeviceMapper.xml
@@ -27,17 +27,20 @@
delete from oth_statistic_device
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoOth.OthStatisticDevice" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoOth.OthStatisticDevice">
<!--@mbg.generated-->
- insert into oth_statistic_device (statistic_date, plan_id, pro_id,
+ insert into oth_statistic_device (id,statistic_date, plan_id, pro_id,
`number`, dt)
- values (#{statisticDate,jdbcType=VARCHAR}, #{planId,jdbcType=BIGINT}, #{proId,jdbcType=BIGINT},
+ values (#{id,jdbcType=BIGINT}, #{statisticDate,jdbcType=VARCHAR}, #{planId,jdbcType=BIGINT}, #{proId,jdbcType=BIGINT},
#{number,jdbcType=INTEGER}, #{dt,jdbcType=TIMESTAMP})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoOth.OthStatisticDevice" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoOth.OthStatisticDevice">
<!--@mbg.generated-->
insert into oth_statistic_device
<trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ id,
+ </if>
<if test="statisticDate != null">
statistic_date,
</if>
@@ -55,6 +58,9 @@
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ #{id,jdbcType=BIGINT},
+ </if>
<if test="statisticDate != null">
#{statisticDate,jdbcType=VARCHAR},
</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/OthStatisticWorkloadMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/OthStatisticWorkloadMapper.xml
index f4c89a9..728956c 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/OthStatisticWorkloadMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/OthStatisticWorkloadMapper.xml
@@ -77,7 +77,7 @@
delete from oth_statistic_workload
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoOth.OthStatisticWorkload" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoOth.OthStatisticWorkload">
insert into oth_statistic_workload
( id,statistic_date,user_id
,user_name,type,node_content
@@ -86,7 +86,7 @@
,#{userName,jdbcType=VARCHAR},#{type,jdbcType=VARCHAR},#{nodeContent,jdbcType=VARCHAR}
,#{number,jdbcType=INTEGER})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoOth.OthStatisticWorkload" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoOth.OthStatisticWorkload">
insert into oth_statistic_workload
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltMaterialMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltMaterialMapper.xml
index 17ae9b9..9c48dc1 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltMaterialMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltMaterialMapper.xml
@@ -42,7 +42,7 @@
delete from plt_material
where id = #{id,jdbcType=INTEGER}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltMaterial" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoPlt.PltMaterial">
insert into plt_material
( id,pro_id,name
,type,length,factory
@@ -51,7 +51,7 @@
,#{type,jdbcType=VARCHAR},#{length,jdbcType=VARCHAR},#{factory,jdbcType=VARCHAR}
,#{deleted,jdbcType=TINYINT},#{remark,jdbcType=VARCHAR})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltMaterial" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltMaterial">
insert into plt_material
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductFileMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductFileMapper.xml
index c6f343a..8bc0ee2 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductFileMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductFileMapper.xml
@@ -36,7 +36,7 @@
delete from plt_product_file
where pro_id = #{proId,jdbcType=BIGINT}
</delete>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductFile" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductFile">
insert into plt_product_file
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductMapper.xml
index 2f1a20d..df91a4f 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductMapper.xml
@@ -52,7 +52,7 @@
where id = #{id,jdbcType=BIGINT}
</select>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProduct" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltProduct">
<!--@mbg.generated-->
insert into plt_product
<trim prefix="(" suffix=")" suffixOverrides=",">
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml
index 6790dd9..bd839ce 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductQualityInspectionItemsMapper.xml
@@ -36,7 +36,7 @@
where id = #{id,jdbcType=BIGINT}
</select>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductQualityInspectionItems" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductQualityInspectionItems">
insert into plt_product_quality_inspection_items
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml
index 83e13dd..917f1bb 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductScrappingReasonMapper.xml
@@ -41,7 +41,7 @@
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductScrappingReason" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductScrappingReason">
insert into plt_product_scrapping_reason
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml
index 439a8bb..f3a6c4c 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductTestInspectionItemsMapper.xml
@@ -75,7 +75,7 @@
delete from plt_product_test_inspection_items
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductTestInspectionItems" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductTestInspectionItems">
insert into plt_product_test_inspection_items
( id,pro_id,item
,deleted,disabled,sort
@@ -84,7 +84,7 @@
,#{deleted,jdbcType=TINYINT},#{disabled,jdbcType=TINYINT},#{sort,jdbcType=INTEGER}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductTestInspectionItems" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductTestInspectionItems">
insert into plt_product_test_inspection_items
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductUnqualifiedReasonMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductUnqualifiedReasonMapper.xml
index 929e460..2f1a70e 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductUnqualifiedReasonMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductUnqualifiedReasonMapper.xml
@@ -28,7 +28,7 @@
where id = #{id,jdbcType=BIGINT}
</select>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductUnqualifiedReason" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductUnqualifiedReason">
insert into plt_product_unqualified_reason
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltProductionLineMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltProductionLineMapper.xml
index 3eeff2e..129923b 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltProductionLineMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltProductionLineMapper.xml
@@ -37,7 +37,7 @@
delete from plt_production_line
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductionLine" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductionLine">
insert into plt_production_line
( id,name,type
,factory,director,d_mobile
@@ -48,7 +48,7 @@
,#{installTime,jdbcType=VARCHAR},#{deleted,jdbcType=TINYINT},#{remark,jdbcType=VARCHAR}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductionLine" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltProductionLine">
insert into plt_production_line
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml
index b412596..191a34c 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PltStationMapper.xml
@@ -38,7 +38,7 @@
<include refid="Base_Column_List" />
from plt_station where name = #{name,jdbcType=VARCHAR} and deleted!=1
</select>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPlt.PltStation" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPlt.PltStation">
insert into plt_station
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml
index a57b77b..7c0bbe5 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrAssemblyPlanMapper.xml
@@ -236,8 +236,8 @@
from pr_assembly_plan
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrAssemblyPlan"
- useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoPr.PrAssemblyPlan"
+ >
insert into pr_assembly_plan
( id,order_id, pro_id, batch_id
, process_id, name, number
@@ -251,8 +251,8 @@
, #{deleted,jdbcType=TINYINT}, #{content,jdbcType=VARCHAR}, #{inputNumber,jdbcType=INTEGER}
, #{outputNumber,jdbcType=INTEGER})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrAssemblyPlan"
- useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrAssemblyPlan"
+ >
insert into pr_assembly_plan
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrBatchNumberMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrBatchNumberMapper.xml
index c1178b4..39efd40 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrBatchNumberMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrBatchNumberMapper.xml
@@ -33,7 +33,7 @@
delete from pr_batch_number
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrBatchNumber" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoPr.PrBatchNumber">
insert into pr_batch_number
( id,batch_number,pro_id
,creator,dt,remark
@@ -42,7 +42,7 @@
,#{creator,jdbcType=VARCHAR},#{dt,jdbcType=TIMESTAMP},#{remark,jdbcType=VARCHAR}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrBatchNumber" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrBatchNumber">
insert into pr_batch_number
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrBillOfMaterialMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrBillOfMaterialMapper.xml
index b3a55e0..3e4a6b2 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrBillOfMaterialMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrBillOfMaterialMapper.xml
@@ -44,15 +44,18 @@
)
</foreach>
</insert>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrBillOfMaterial" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoPr.PrBillOfMaterial">
<!--@mbg.generated-->
- insert into pr_bill_of_material (node_id, file_id)
- values (#{nodeId,jdbcType=BIGINT}, #{fileId,jdbcType=BIGINT})
+ insert into pr_bill_of_material (id, node_id, file_id)
+ values (#{id,jdbcType=BIGINT}, #{nodeId,jdbcType=BIGINT}, #{fileId,jdbcType=BIGINT})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrBillOfMaterial" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrBillOfMaterial">
<!--@mbg.generated-->
insert into pr_bill_of_material
<trim prefix="(" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ id,
+ </if>
<if test="nodeId != null">
node_id,
</if>
@@ -61,6 +64,9 @@
</if>
</trim>
<trim prefix="values (" suffix=")" suffixOverrides=",">
+ <if test="id != null">
+ #{id,jdbcType=BIGINT},
+ </if>
<if test="nodeId != null">
#{nodeId,jdbcType=BIGINT},
</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrDevOpsPlanMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrDevOpsPlanMapper.xml
index 7f8266e..e160be9 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrDevOpsPlanMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrDevOpsPlanMapper.xml
@@ -37,7 +37,7 @@
delete from pr_dev_ops_plan
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrDevOpsPlan" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoPr.PrDevOpsPlan">
insert into pr_dev_ops_plan
( id,name,status,creator,dt
,start_date,end_date,deleted
@@ -47,7 +47,7 @@
,#{startDate,jdbcType=VARCHAR},#{endDate,jdbcType=VARCHAR},#{deleted,jdbcType=TINYINT}
,#{content,jdbcType=VARCHAR})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrDevOpsPlan" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrDevOpsPlan">
insert into pr_dev_ops_plan
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrDeviceMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrDeviceMapper.xml
index 8a1b2e7..2bd1653 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrDeviceMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrDeviceMapper.xml
@@ -32,14 +32,14 @@
delete from pr_device
where batch_id = #{batchId,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrDevice" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoPr.PrDevice">
insert into pr_device
( id,pro_id,batch_id
,device_no,status)
values (#{id,jdbcType=BIGINT},#{proId,jdbcType=BIGINT},#{batchId,jdbcType=BIGINT}
,#{deviceNo,jdbcType=BIGINT},#{status,jdbcType=TINYINT})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrDevice" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrDevice">
insert into pr_device
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrOrderItemMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrOrderItemMapper.xml
index f55383b..d8f5a69 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrOrderItemMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrOrderItemMapper.xml
@@ -61,7 +61,7 @@
#{completeNumber,jdbcType=INTEGER}, #{deleted,jdbcType=TINYINT}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrOrderItem" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrOrderItem">
insert into pr_order_item
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrOrderMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrOrderMapper.xml
index 3a63783..be6909b 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrOrderMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrOrderMapper.xml
@@ -169,7 +169,7 @@
update pr_order set deleted = 1
where id = #{id}
</update>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrOrder" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrOrder">
insert into pr_order
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrProductionNodeMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrProductionNodeMapper.xml
index 39c17fd..b03fdfa 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrProductionNodeMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrProductionNodeMapper.xml
@@ -64,7 +64,7 @@
#{item}
</foreach>
</delete>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrProductionNode" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrProductionNode">
insert into pr_production_node
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrProductionProcessMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrProductionProcessMapper.xml
index 08e0e9d..fe70390 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrProductionProcessMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrProductionProcessMapper.xml
@@ -75,7 +75,7 @@
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrProductionProcess" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrProductionProcess">
insert into pr_production_process
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/PrWorkingInstructionMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/PrWorkingInstructionMapper.xml
index 037176a..694f268 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/PrWorkingInstructionMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/PrWorkingInstructionMapper.xml
@@ -38,7 +38,7 @@
#{item}
</foreach>
</delete>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoPr.PrWorkingInstruction" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoPr.PrWorkingInstruction">
insert into pr_working_instruction
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkHistoryMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkHistoryMapper.xml
index c744afe..b0662c4 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkHistoryMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkHistoryMapper.xml
@@ -38,7 +38,7 @@
delete from sta_assembly_work_history
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory">
insert into sta_assembly_work_history
( id,work_id,user_id,line_id
,station_id,plan_id,process_id
@@ -51,7 +51,7 @@
,#{startTime,jdbcType=TIMESTAMP},#{endTime,jdbcType=TIMESTAMP},#{assistants,jdbcType=VARCHAR}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkHistory">
insert into sta_assembly_work_history
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkLastMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkLastMapper.xml
index 2e4be54..3abbda8 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkLastMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaAssemblyWorkLastMapper.xml
@@ -394,8 +394,8 @@
from sta_assembly_work_last
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast"
- useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast"
+ >
insert into sta_assembly_work_last
( id, user_id, line_id
, station_id, plan_id, process_id
@@ -407,8 +407,8 @@
, #{status,jdbcType=TINYINT}
, #{startTime,jdbcType=TIMESTAMP}, #{endTime,jdbcType=TIMESTAMP}, #{assistants,jdbcType=VARCHAR})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id"
- parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast" useGeneratedKeys="true">
+ <insert id="insertSelective"
+ parameterType="com.dy.pmsGlobal.pojoSta.StaAssemblyWorkLast">
insert into sta_assembly_work_last
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaDevOpsTaskClaimInfoMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaDevOpsTaskClaimInfoMapper.xml
index 5317d88..032ec14 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaDevOpsTaskClaimInfoMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaDevOpsTaskClaimInfoMapper.xml
@@ -28,14 +28,14 @@
delete from sta_dev_ops_task_claim_info
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo">
insert into sta_dev_ops_task_claim_info
( id,user_id,plan_id
,dt,status)
values (#{id,jdbcType=BIGINT},#{userId,jdbcType=BIGINT},#{planId,jdbcType=BIGINT}
,#{dt,jdbcType=TIMESTAMP},#{status,jdbcType=TINYINT})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDevOpsTaskClaimInfo">
insert into sta_dev_ops_task_claim_info
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLastMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLastMapper.xml
index 74a4b78..54d2ce4 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLastMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLastMapper.xml
@@ -67,7 +67,7 @@
delete from sta_device_last
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLast" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLast">
insert into sta_device_last
( id,device_no,work_id
,repair_id,plan_id,station_id
@@ -86,7 +86,7 @@
,#{inLineTime,jdbcType=TIMESTAMP},#{outLineTime,jdbcType=TIMESTAMP}
,#{memo,jdbcType=VARCHAR})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLast" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLast">
insert into sta_device_last
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeLastMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeLastMapper.xml
index 519a9f8..0b7521b 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeLastMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeLastMapper.xml
@@ -63,7 +63,7 @@
delete from sta_device_life_last
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLifeLast" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLifeLast">
insert into sta_device_life_last
( id,device_no,work_id
,repair_id,plan_id,station_id
@@ -78,7 +78,7 @@
,#{inTime,jdbcType=TIMESTAMP},#{outTime,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=BIGINT}
,#{memo,jdbcType=VARCHAR})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLifeLast" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLifeLast">
insert into sta_device_life_last
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeMapper.xml
index 939f3d1..9e65852 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaDeviceLifeMapper.xml
@@ -64,7 +64,7 @@
delete from sta_device_life
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLife" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLife">
insert into sta_device_life
( id,device_no,work_id
,repair_id,plan_id,station_id
@@ -81,7 +81,7 @@
,#{outTime,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=BIGINT},#{memo,jdbcType=VARCHAR}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLife" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceLife">
insert into sta_device_life
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaDeviceProductionLogMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaDeviceProductionLogMapper.xml
index a61c09f..045a50a 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaDeviceProductionLogMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaDeviceProductionLogMapper.xml
@@ -122,7 +122,7 @@
delete from sta_device_production_log
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog">
insert into sta_device_production_log
( id,device_no,work_id
,repair_id,plan_id,station_id
@@ -139,7 +139,7 @@
,#{outTime,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=BIGINT},#{memo,jdbcType=VARCHAR}, #{number,jdbcType=INTEGER}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoSta.StaDeviceProductionLog">
insert into sta_device_production_log
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaRepairInfoMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaRepairInfoMapper.xml
index 12e4b6a..6732d16 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaRepairInfoMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaRepairInfoMapper.xml
@@ -36,7 +36,7 @@
delete from sta_repair_info
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaRepairInfo" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaRepairInfo">
insert into sta_repair_info
( id,device_no,work_id
,from_node,repair_reason,repair_by
@@ -45,7 +45,7 @@
,#{fromNode,jdbcType=BIGINT},#{repairReason,jdbcType=VARCHAR},#{repairBy,jdbcType=BIGINT}
,#{repairTime,jdbcType=TIMESTAMP})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaRepairInfo" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoSta.StaRepairInfo">
insert into sta_repair_info
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/StaWipSnExMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/StaWipSnExMapper.xml
index f5c4ff1..3a3c564 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/StaWipSnExMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/StaWipSnExMapper.xml
@@ -42,7 +42,7 @@
delete from sta_wip_sn_ex
where id = #{id,jdbcType=BIGINT}
</delete>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaWipSnEx" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoSta.StaWipSnEx">
insert into sta_wip_sn_ex
( id,device_no,product_id
,product_name,product_no,create_time
@@ -51,7 +51,7 @@
,#{productName,jdbcType=VARCHAR},#{productNo,jdbcType=VARCHAR},#{createTime,jdbcType=TIMESTAMP}
,#{createBy,jdbcType=BIGINT})
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoSta.StaWipSnEx" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoSta.StaWipSnEx">
insert into sta_wip_sn_ex
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
diff --git a/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml b/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml
index 67550f4..2c10d1d 100644
--- a/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml
+++ b/pms-parent/pms-global/src/main/resources/mapper/TstCommandMapper.xml
@@ -101,7 +101,7 @@
update tst_command set deleted = 1
where id = #{id}
</update>
- <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoTst.TstCommand" useGeneratedKeys="true">
+ <insert id="insert" parameterType="com.dy.pmsGlobal.pojoTst.TstCommand">
insert into tst_command
( id,pro_id,type
,name,value,deleted
@@ -114,7 +114,7 @@
,#{dt,jdbcType=TIMESTAMP},#{updatedBy,jdbcType=BIGINT},#{updatedDate,jdbcType=TIMESTAMP}
)
</insert>
- <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.dy.pmsGlobal.pojoTst.TstCommand" useGeneratedKeys="true">
+ <insert id="insertSelective" parameterType="com.dy.pmsGlobal.pojoTst.TstCommand">
insert into tst_command
<trim prefix="(" suffix=")" suffixOverrides=",">
<if test="id != null">id,</if>
--
Gitblit v1.8.0