From 2c4ea5d3017f227ad251e06b198733922cb9c301 Mon Sep 17 00:00:00 2001
From: DESKTOP-LMJ82IJ\Eno <creaycat@gmail.com>
Date: 星期二, 07 一月 2025 20:00:31 +0800
Subject: [PATCH] #添加拣货单
---
zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheet.java | 76 ++++++
zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheetDetl.java | 106 +++++++++
zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetDetlMapper.java | 21 +
zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetMapper.java | 21 +
zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetDetlMapper.xml | 253 +++++++++++++++++++++++
zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetMapper.xml | 182 ++++++++++++++++
6 files changed, 659 insertions(+), 0 deletions(-)
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheet.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheet.java
new file mode 100644
index 0000000..4e193e7
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheet.java
@@ -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;
+}
\ No newline at end of file
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheetDetl.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheetDetl.java
new file mode 100644
index 0000000..ac210fb
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/entity/ManPickSheetDetl.java
@@ -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;
+}
\ No newline at end of file
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetDetlMapper.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetDetlMapper.java
new file mode 100644
index 0000000..46d65f3
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetDetlMapper.java
@@ -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);
+}
\ No newline at end of file
diff --git a/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetMapper.java b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetMapper.java
new file mode 100644
index 0000000..6823002
--- /dev/null
+++ b/zy-asrs-wms/src/main/java/com/zy/asrs/wms/asrs/mapper/ManPickSheetMapper.java
@@ -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);
+}
\ No newline at end of file
diff --git a/zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetDetlMapper.xml b/zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetDetlMapper.xml
new file mode 100644
index 0000000..784323a
--- /dev/null
+++ b/zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetDetlMapper.xml
@@ -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>
\ No newline at end of file
diff --git a/zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetMapper.xml b/zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetMapper.xml
new file mode 100644
index 0000000..e6bd7f6
--- /dev/null
+++ b/zy-asrs-wms/src/main/resources/mapper/asrs/ManPickSheetMapper.xml
@@ -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>
\ No newline at end of file
--
Gitblit v1.9.1