#添加拣货单

DESKTOP-LMJ82IJ\Eno

2025-01-07 2c4ea5d3017f227ad251e06b198733922cb9c301

#添加拣货单

 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheet.java

New file
@@ -0,0 +1,76 @@
package com.zy.asrs.wms.asrs.entity;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
import lombok.Data;

/**
 * man_pick_sheet
 */
@Data
public class ManPickSheet implements Serializable {
    /**
     * 主键
     */
    private Long id;

    /**
     * 单据编号
     */
    private String pickNo;

    /**
     * 波次标识
     */
    private Long waveId;

    /**
     * 波次号
     */
    private String waveNo;

    /**
     * 数量
     */
    private BigDecimal anfme;

    /**
     * 备注
     */
    private String memo;

    /**
     * 创建时间
     */
    private Date createdTime;

    /**
     * 修改时间
     */
    private Date updatedTime;

    private Long hostId;

    /**
     * 创建人
     */
    private String createdBy;

    /**
     * 修改人
     */
    private String updatedBy;

    /**
     * 状态： 1正常  0禁用
     */
    private Integer status;

    /**
     * 是否删除  1：是， 0否
     */
    private Integer deleted;

    private static final long serialVersionUID = 1L;
}

 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheetDetl.java

New file
@@ -0,0 +1,106 @@
package com.zy.asrs.wms.asrs.entity;

import java.io.Serializable;
import java.math.BigDecimal;
import java.util.Date;
import lombok.Data;

/**
 * man_pick_sheet_detl
 */
@Data
public class ManPickSheetDetl implements Serializable {
    /**
     * 主键
     */
    private Long id;

    /**
     * 拣货单标识
     */
    private Long pickId;

    /**
     * 订单标识
     */
    private Long orderId;

    /**
     * 订单明细标识
     */
    private Long orderDetlId;

    /**
     * 物料主键标识
     */
    private Long matId;

    /**
     * 库位主键标识
     */
    private Long locId;

    /**
     * 物料名称
     */
    private String maktx;

    /**
     * 物料编码
     */
    private String matnr;

    /**
     * 批号
     */
    private Long batch;

    /**
     * 数量
     */
    private BigDecimal anfme;

    /**
     * 库位编码
     */
    private String locNo;

    /**
     * 容器编码
     */
    private String barcode;

    /**
     * 创建时间
     */
    private Date createdTime;

    /**
     * 修改时间
     */
    private Date updatedTime;

    private Long hostId;

    /**
     * 创建人
     */
    private String createdBy;

    /**
     * 修改人
     */
    private String updatedBy;

    /**
     * 状态： 1正常  0禁用
     */
    private Integer status;

    /**
     * 是否删除  1：是， 0否
     */
    private Integer deleted;

    private static final long serialVersionUID = 1L;
}

 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetDetlMapper.java

New file
@@ -0,0 +1,21 @@
package com.zy.asrs.wms.asrs.mapper;

import com.zy.asrs.wms.asrs.entity.ManPickSheetDetl;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface ManPickSheetDetlMapper {
    int deleteByPrimaryKey(Long id);

    int insert(ManPickSheetDetl record);

    int insertSelective(ManPickSheetDetl record);

    ManPickSheetDetl selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(ManPickSheetDetl record);

    int updateByPrimaryKey(ManPickSheetDetl record);
}

 zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetMapper.java

New file
@@ -0,0 +1,21 @@
package com.zy.asrs.wms.asrs.mapper;

import com.zy.asrs.wms.asrs.entity.ManPickSheet;
import org.apache.ibatis.annotations.Mapper;
import org.springframework.stereotype.Repository;

@Mapper
@Repository
public interface ManPickSheetMapper {
    int deleteByPrimaryKey(Long id);

    int insert(ManPickSheet record);

    int insertSelective(ManPickSheet record);

    ManPickSheet selectByPrimaryKey(Long id);

    int updateByPrimaryKeySelective(ManPickSheet record);

    int updateByPrimaryKey(ManPickSheet record);
}

 zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetDetlMapper.xml

New file
@@ -0,0 +1,253 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.asrs.wms.asrs.mapper.ManPickSheetDetlMapper">
  <resultMap id="BaseResultMap" type="com.zy.asrs.wms.asrs.entity.ManPickSheetDetl">
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="pick_id" jdbcType="BIGINT" property="pickId" />
    <result column="order_id" jdbcType="BIGINT" property="orderId" />
    <result column="order_detl_id" jdbcType="BIGINT" property="orderDetlId" />
    <result column="mat_id" jdbcType="BIGINT" property="matId" />
    <result column="loc_id" jdbcType="BIGINT" property="locId" />
    <result column="maktx" jdbcType="VARCHAR" property="maktx" />
    <result column="matnr" jdbcType="VARCHAR" property="matnr" />
    <result column="batch" jdbcType="BIGINT" property="batch" />
    <result column="anfme" jdbcType="DECIMAL" property="anfme" />
    <result column="loc_no" jdbcType="VARCHAR" property="locNo" />
    <result column="barcode" jdbcType="VARCHAR" property="barcode" />
    <result column="created_time" jdbcType="TIMESTAMP" property="createdTime" />
    <result column="updated_time" jdbcType="TIMESTAMP" property="updatedTime" />
    <result column="host_id" jdbcType="BIGINT" property="hostId" />
    <result column="created_by" jdbcType="VARCHAR" property="createdBy" />
    <result column="updated_by" jdbcType="VARCHAR" property="updatedBy" />
    <result column="status" jdbcType="INTEGER" property="status" />
    <result column="deleted" jdbcType="INTEGER" property="deleted" />
  </resultMap>
  <sql id="Base_Column_List">
    id, pick_id, order_id, order_detl_id, mat_id, loc_id, maktx, matnr, batch, anfme, 
    loc_no, barcode, created_time, updated_time, host_id, created_by, updated_by, `status`, 
    deleted
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from man_pick_sheet_detl
    where id = #{id,jdbcType=BIGINT}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
    delete from man_pick_sheet_detl
    where id = #{id,jdbcType=BIGINT}
  </delete>
  <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.zy.asrs.wms.asrs.entity.ManPickSheetDetl" useGeneratedKeys="true">
    insert into man_pick_sheet_detl (pick_id, order_id, order_detl_id, 
      mat_id, loc_id, maktx, 
      matnr, batch, anfme, 
      loc_no, barcode, created_time, 
      updated_time, host_id, created_by, 
      updated_by, `status`, deleted
      )
    values (#{pickId,jdbcType=BIGINT}, #{orderId,jdbcType=BIGINT}, #{orderDetlId,jdbcType=BIGINT}, 
      #{matId,jdbcType=BIGINT}, #{locId,jdbcType=BIGINT}, #{maktx,jdbcType=VARCHAR}, 
      #{matnr,jdbcType=VARCHAR}, #{batch,jdbcType=BIGINT}, #{anfme,jdbcType=DECIMAL}, 
      #{locNo,jdbcType=VARCHAR}, #{barcode,jdbcType=VARCHAR}, #{createdTime,jdbcType=TIMESTAMP}, 
      #{updatedTime,jdbcType=TIMESTAMP}, #{hostId,jdbcType=BIGINT}, #{createdBy,jdbcType=VARCHAR}, 
      #{updatedBy,jdbcType=VARCHAR}, #{status,jdbcType=INTEGER}, #{deleted,jdbcType=INTEGER}
      )
  </insert>
  <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.zy.asrs.wms.asrs.entity.ManPickSheetDetl" useGeneratedKeys="true">
    insert into man_pick_sheet_detl
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="pickId != null">
        pick_id,
      </if>
      <if test="orderId != null">
        order_id,
      </if>
      <if test="orderDetlId != null">
        order_detl_id,
      </if>
      <if test="matId != null">
        mat_id,
      </if>
      <if test="locId != null">
        loc_id,
      </if>
      <if test="maktx != null">
        maktx,
      </if>
      <if test="matnr != null">
        matnr,
      </if>
      <if test="batch != null">
        batch,
      </if>
      <if test="anfme != null">
        anfme,
      </if>
      <if test="locNo != null">
        loc_no,
      </if>
      <if test="barcode != null">
        barcode,
      </if>
      <if test="createdTime != null">
        created_time,
      </if>
      <if test="updatedTime != null">
        updated_time,
      </if>
      <if test="hostId != null">
        host_id,
      </if>
      <if test="createdBy != null">
        created_by,
      </if>
      <if test="updatedBy != null">
        updated_by,
      </if>
      <if test="status != null">
        `status`,
      </if>
      <if test="deleted != null">
        deleted,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="pickId != null">
        #{pickId,jdbcType=BIGINT},
      </if>
      <if test="orderId != null">
        #{orderId,jdbcType=BIGINT},
      </if>
      <if test="orderDetlId != null">
        #{orderDetlId,jdbcType=BIGINT},
      </if>
      <if test="matId != null">
        #{matId,jdbcType=BIGINT},
      </if>
      <if test="locId != null">
        #{locId,jdbcType=BIGINT},
      </if>
      <if test="maktx != null">
        #{maktx,jdbcType=VARCHAR},
      </if>
      <if test="matnr != null">
        #{matnr,jdbcType=VARCHAR},
      </if>
      <if test="batch != null">
        #{batch,jdbcType=BIGINT},
      </if>
      <if test="anfme != null">
        #{anfme,jdbcType=DECIMAL},
      </if>
      <if test="locNo != null">
        #{locNo,jdbcType=VARCHAR},
      </if>
      <if test="barcode != null">
        #{barcode,jdbcType=VARCHAR},
      </if>
      <if test="createdTime != null">
        #{createdTime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatedTime != null">
        #{updatedTime,jdbcType=TIMESTAMP},
      </if>
      <if test="hostId != null">
        #{hostId,jdbcType=BIGINT},
      </if>
      <if test="createdBy != null">
        #{createdBy,jdbcType=VARCHAR},
      </if>
      <if test="updatedBy != null">
        #{updatedBy,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        #{status,jdbcType=INTEGER},
      </if>
      <if test="deleted != null">
        #{deleted,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.zy.asrs.wms.asrs.entity.ManPickSheetDetl">
    update man_pick_sheet_detl
    <set>
      <if test="pickId != null">
        pick_id = #{pickId,jdbcType=BIGINT},
      </if>
      <if test="orderId != null">
        order_id = #{orderId,jdbcType=BIGINT},
      </if>
      <if test="orderDetlId != null">
        order_detl_id = #{orderDetlId,jdbcType=BIGINT},
      </if>
      <if test="matId != null">
        mat_id = #{matId,jdbcType=BIGINT},
      </if>
      <if test="locId != null">
        loc_id = #{locId,jdbcType=BIGINT},
      </if>
      <if test="maktx != null">
        maktx = #{maktx,jdbcType=VARCHAR},
      </if>
      <if test="matnr != null">
        matnr = #{matnr,jdbcType=VARCHAR},
      </if>
      <if test="batch != null">
        batch = #{batch,jdbcType=BIGINT},
      </if>
      <if test="anfme != null">
        anfme = #{anfme,jdbcType=DECIMAL},
      </if>
      <if test="locNo != null">
        loc_no = #{locNo,jdbcType=VARCHAR},
      </if>
      <if test="barcode != null">
        barcode = #{barcode,jdbcType=VARCHAR},
      </if>
      <if test="createdTime != null">
        created_time = #{createdTime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatedTime != null">
        updated_time = #{updatedTime,jdbcType=TIMESTAMP},
      </if>
      <if test="hostId != null">
        host_id = #{hostId,jdbcType=BIGINT},
      </if>
      <if test="createdBy != null">
        created_by = #{createdBy,jdbcType=VARCHAR},
      </if>
      <if test="updatedBy != null">
        updated_by = #{updatedBy,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        `status` = #{status,jdbcType=INTEGER},
      </if>
      <if test="deleted != null">
        deleted = #{deleted,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=BIGINT}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.zy.asrs.wms.asrs.entity.ManPickSheetDetl">
    update man_pick_sheet_detl
    set pick_id = #{pickId,jdbcType=BIGINT},
      order_id = #{orderId,jdbcType=BIGINT},
      order_detl_id = #{orderDetlId,jdbcType=BIGINT},
      mat_id = #{matId,jdbcType=BIGINT},
      loc_id = #{locId,jdbcType=BIGINT},
      maktx = #{maktx,jdbcType=VARCHAR},
      matnr = #{matnr,jdbcType=VARCHAR},
      batch = #{batch,jdbcType=BIGINT},
      anfme = #{anfme,jdbcType=DECIMAL},
      loc_no = #{locNo,jdbcType=VARCHAR},
      barcode = #{barcode,jdbcType=VARCHAR},
      created_time = #{createdTime,jdbcType=TIMESTAMP},
      updated_time = #{updatedTime,jdbcType=TIMESTAMP},
      host_id = #{hostId,jdbcType=BIGINT},
      created_by = #{createdBy,jdbcType=VARCHAR},
      updated_by = #{updatedBy,jdbcType=VARCHAR},
      `status` = #{status,jdbcType=INTEGER},
      deleted = #{deleted,jdbcType=INTEGER}
    where id = #{id,jdbcType=BIGINT}
  </update>
</mapper>

 zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetMapper.xml

New file
@@ -0,0 +1,182 @@
<?xml version="1.0" encoding="UTF-8"?>
<!DOCTYPE mapper PUBLIC "-//mybatis.org//DTD Mapper 3.0//EN" "http://mybatis.org/dtd/mybatis-3-mapper.dtd">
<mapper namespace="com.zy.asrs.wms.asrs.mapper.ManPickSheetMapper">
  <resultMap id="BaseResultMap" type="com.zy.asrs.wms.asrs.entity.ManPickSheet">
    <id column="id" jdbcType="BIGINT" property="id" />
    <result column="pick_no" jdbcType="VARCHAR" property="pickNo" />
    <result column="wave_id" jdbcType="BIGINT" property="waveId" />
    <result column="wave_no" jdbcType="VARCHAR" property="waveNo" />
    <result column="anfme" jdbcType="DECIMAL" property="anfme" />
    <result column="memo" jdbcType="VARCHAR" property="memo" />
    <result column="created_time" jdbcType="TIMESTAMP" property="createdTime" />
    <result column="updated_time" jdbcType="TIMESTAMP" property="updatedTime" />
    <result column="host_id" jdbcType="BIGINT" property="hostId" />
    <result column="created_by" jdbcType="VARCHAR" property="createdBy" />
    <result column="updated_by" jdbcType="VARCHAR" property="updatedBy" />
    <result column="status" jdbcType="INTEGER" property="status" />
    <result column="deleted" jdbcType="INTEGER" property="deleted" />
  </resultMap>
  <sql id="Base_Column_List">
    id, pick_no, wave_id, wave_no, anfme, memo, created_time, updated_time, host_id, 
    created_by, updated_by, `status`, deleted
  </sql>
  <select id="selectByPrimaryKey" parameterType="java.lang.Long" resultMap="BaseResultMap">
    select 
    <include refid="Base_Column_List" />
    from man_pick_sheet
    where id = #{id,jdbcType=BIGINT}
  </select>
  <delete id="deleteByPrimaryKey" parameterType="java.lang.Long">
    delete from man_pick_sheet
    where id = #{id,jdbcType=BIGINT}
  </delete>
  <insert id="insert" keyColumn="id" keyProperty="id" parameterType="com.zy.asrs.wms.asrs.entity.ManPickSheet" useGeneratedKeys="true">
    insert into man_pick_sheet (pick_no, wave_id, wave_no, 
      anfme, memo, created_time, 
      updated_time, host_id, created_by, 
      updated_by, `status`, deleted
      )
    values (#{pickNo,jdbcType=VARCHAR}, #{waveId,jdbcType=BIGINT}, #{waveNo,jdbcType=VARCHAR}, 
      #{anfme,jdbcType=DECIMAL}, #{memo,jdbcType=VARCHAR}, #{createdTime,jdbcType=TIMESTAMP}, 
      #{updatedTime,jdbcType=TIMESTAMP}, #{hostId,jdbcType=BIGINT}, #{createdBy,jdbcType=VARCHAR}, 
      #{updatedBy,jdbcType=VARCHAR}, #{status,jdbcType=INTEGER}, #{deleted,jdbcType=INTEGER}
      )
  </insert>
  <insert id="insertSelective" keyColumn="id" keyProperty="id" parameterType="com.zy.asrs.wms.asrs.entity.ManPickSheet" useGeneratedKeys="true">
    insert into man_pick_sheet
    <trim prefix="(" suffix=")" suffixOverrides=",">
      <if test="pickNo != null">
        pick_no,
      </if>
      <if test="waveId != null">
        wave_id,
      </if>
      <if test="waveNo != null">
        wave_no,
      </if>
      <if test="anfme != null">
        anfme,
      </if>
      <if test="memo != null">
        memo,
      </if>
      <if test="createdTime != null">
        created_time,
      </if>
      <if test="updatedTime != null">
        updated_time,
      </if>
      <if test="hostId != null">
        host_id,
      </if>
      <if test="createdBy != null">
        created_by,
      </if>
      <if test="updatedBy != null">
        updated_by,
      </if>
      <if test="status != null">
        `status`,
      </if>
      <if test="deleted != null">
        deleted,
      </if>
    </trim>
    <trim prefix="values (" suffix=")" suffixOverrides=",">
      <if test="pickNo != null">
        #{pickNo,jdbcType=VARCHAR},
      </if>
      <if test="waveId != null">
        #{waveId,jdbcType=BIGINT},
      </if>
      <if test="waveNo != null">
        #{waveNo,jdbcType=VARCHAR},
      </if>
      <if test="anfme != null">
        #{anfme,jdbcType=DECIMAL},
      </if>
      <if test="memo != null">
        #{memo,jdbcType=VARCHAR},
      </if>
      <if test="createdTime != null">
        #{createdTime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatedTime != null">
        #{updatedTime,jdbcType=TIMESTAMP},
      </if>
      <if test="hostId != null">
        #{hostId,jdbcType=BIGINT},
      </if>
      <if test="createdBy != null">
        #{createdBy,jdbcType=VARCHAR},
      </if>
      <if test="updatedBy != null">
        #{updatedBy,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        #{status,jdbcType=INTEGER},
      </if>
      <if test="deleted != null">
        #{deleted,jdbcType=INTEGER},
      </if>
    </trim>
  </insert>
  <update id="updateByPrimaryKeySelective" parameterType="com.zy.asrs.wms.asrs.entity.ManPickSheet">
    update man_pick_sheet
    <set>
      <if test="pickNo != null">
        pick_no = #{pickNo,jdbcType=VARCHAR},
      </if>
      <if test="waveId != null">
        wave_id = #{waveId,jdbcType=BIGINT},
      </if>
      <if test="waveNo != null">
        wave_no = #{waveNo,jdbcType=VARCHAR},
      </if>
      <if test="anfme != null">
        anfme = #{anfme,jdbcType=DECIMAL},
      </if>
      <if test="memo != null">
        memo = #{memo,jdbcType=VARCHAR},
      </if>
      <if test="createdTime != null">
        created_time = #{createdTime,jdbcType=TIMESTAMP},
      </if>
      <if test="updatedTime != null">
        updated_time = #{updatedTime,jdbcType=TIMESTAMP},
      </if>
      <if test="hostId != null">
        host_id = #{hostId,jdbcType=BIGINT},
      </if>
      <if test="createdBy != null">
        created_by = #{createdBy,jdbcType=VARCHAR},
      </if>
      <if test="updatedBy != null">
        updated_by = #{updatedBy,jdbcType=VARCHAR},
      </if>
      <if test="status != null">
        `status` = #{status,jdbcType=INTEGER},
      </if>
      <if test="deleted != null">
        deleted = #{deleted,jdbcType=INTEGER},
      </if>
    </set>
    where id = #{id,jdbcType=BIGINT}
  </update>
  <update id="updateByPrimaryKey" parameterType="com.zy.asrs.wms.asrs.entity.ManPickSheet">
    update man_pick_sheet
    set pick_no = #{pickNo,jdbcType=VARCHAR},
      wave_id = #{waveId,jdbcType=BIGINT},
      wave_no = #{waveNo,jdbcType=VARCHAR},
      anfme = #{anfme,jdbcType=DECIMAL},
      memo = #{memo,jdbcType=VARCHAR},
      created_time = #{createdTime,jdbcType=TIMESTAMP},
      updated_time = #{updatedTime,jdbcType=TIMESTAMP},
      host_id = #{hostId,jdbcType=BIGINT},
      created_by = #{createdBy,jdbcType=VARCHAR},
      updated_by = #{updatedBy,jdbcType=VARCHAR},
      `status` = #{status,jdbcType=INTEGER},
      deleted = #{deleted,jdbcType=INTEGER}
    where id = #{id,jdbcType=BIGINT}
  </update>
</mapper>