去除画蛇添足代码

liurunyu

3 天以前 c488d63b58458ea0dee56ffbb4c5b66b2141d4f1

去除画蛇添足代码

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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=",">

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>

 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>