#

zwl

2025-10-15 bcd046ee24ce63d23827f724697457012cf7ca81

#

 src/main/java/com/zy/asrs/task/handler/WorkMastHandler.java

@@ -446,10 +446,9 @@
        int i = -1;
        for (WrkDetl wrkDetl : wrkDetls) {
            if (Cools.isEmpty(wrkDetl.getOrderNo()) && !Cools.isEmpty(wrkDetl.getInspect()) && wrkDetl.getInspect() == 1) {
                continue;
            }
            ExdvYanbu bacode = exdMaterialMapper.getBacode(wrkDetl.getBatch());
                ExdvYanbu bacode = exdMaterialMapper.getBacode(wrkDetl.getThreeCode());
            if (bacode == null) {
                    log.info("验布数据没有，{}", wrkDetl.getThreeCode());
                return;
            }
            exdInstockTarge = new ExdInstockTarget();
@@ -480,11 +479,12 @@
            exdInstockTarge.setWritetime(new Date());
            exdInstockTarge.setWritor("WMS");
            exdInstockTarge.setStatus(0);
            exdInstockTarge.setProdInKind("成品库");
                exdInstockTarge.setProdinkind("成品库");
            //exdInstockTarge.setProdInKind("特采库");
            exdInstockTargetService.insert(exdInstockTarge);
            i++;
        }
    }
    }

}

 src/main/java/com/zy/third/entity/ExdInstockTarget.java

@@ -222,7 +222,7 @@
    /**
     *
     */
    private String ProdInKind;
    private String prodinkind;

    @TableField(exist = false)
    private static final long serialVersionUID = 1L;

 src/main/resources/application.yml

@@ -33,12 +33,12 @@
    #    password: root
    #driver-class-name: com.mysql.cj.jdbc.Driver
    driver-class-name: com.microsoft.sqlserver.jdbc.SQLServerDriver
#    jdbc-url: jdbc:sqlserver://192.168.3.148:1433;databasename=wms_middle
#    username: wms
#    password: wms@aunde
    jdbc-url: jdbc:sqlserver://127.0.0.1:1433;databasename=wms_middle
    username: sa
    password: sa@123
    jdbc-url: jdbc:sqlserver://192.168.3.148:1433;databasename=wms_middle
    username: wms
    password: wms@aunde
#    jdbc-url: jdbc:sqlserver://127.0.0.1:1433;databasename=wms_middle
#    username: sa
#    password: sa@123

mybatis-plus:
  mapper-locations: classpath:mapper/*.xml 

 src/main/resources/mapper/third/ExdInstockTargetMapper.xml

@@ -45,6 +45,7 @@
            <result property="reador" column="Reador" />
            <result property="writormsg" column="WritorMsg" />
            <result property="readormsg" column="ReadorMsg" />
            <result property="prodinkind" column="ProdInKind" />
    </resultMap>

    <sql id="Base_Column_List">

 src/main/resources/mapper/third/ExdMaterialMapper.xml

@@ -30,12 +30,12 @@
    </select>

    <select id="getBacode" resultType="com.zy.third.entity.ExdvYanbu" parameterType="string">
        <!--         SELECT top 1 *
      FROM [Textile].[trade].[TianfuQcResult]
      where Barcode = #{barcode}  -->
    SELECT top 1 *
      FROM TianfuQcResult
      FROM [Textile].[trade].[TianfuQcResult]
      where Barcode = #{barcode}
        <!--    SELECT top 1 *
         FROM TianfuQcResult
         where Barcode = #{barcode}-->

    </select>