20231116_qiuyh_调整sql

邱宇豪

2023-11-16 163256ddbc6f0c78ba0f986013fd7327a07db362

20231116_qiuyh_调整sql

 hd/pipe/materialsManage/src/main/resources/mapping/SuMaterialWarehouseMapper.xml

@@ -6,12 +6,12 @@
  <insert id="insertAndUpdate">
    insert into t_su_material_warehouse_record
    <trim prefix="(" suffix=")" suffixOverrides=",">
        <if test="id != null">
            id,
        </if>
        <if test="nameOfOrigin != null">
            name_of_origin,
        </if>
      <if test="id != null">
        id,
      </if>
      <if test="nameOfOrigin != null">
        name_of_origin,
      </if>
      <if test="tableNum != null">
        table_num,
      </if>
@@ -53,12 +53,12 @@
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
        <if test="id != null">
            #{id,jdbcType=VARCHAR},
        </if>
        <if test="nameOfOrigin != null">
            #{nameOfOrigin,jdbcType=VARCHAR},
        </if>
      <if test="id != null">
        #{id,jdbcType=VARCHAR},
      </if>
      <if test="nameOfOrigin != null">
        #{nameOfOrigin,jdbcType=VARCHAR},
      </if>
      <if test="tableNum != null">
        #{tableNum,jdbcType=INTEGER},
      </if>
@@ -101,9 +101,9 @@
    </trim>
    on duplicate key update
    <trim suffixOverrides=",">
        <if test="nameOfOrigin != null">
      <if test="nameOfOrigin != null">
            name_of_origin = #{nameOfOrigin,jdbcType=VARCHAR},
        </if>
      </if>
      <if test="tableNum != null">
        table_num = #{tableNum,jdbcType=INTEGER},
      </if>