From 59f80df1e377e8775969ca4acadfa2eadd6e37ae Mon Sep 17 00:00:00 2001
From: zhangchao <zc857179121@qq.com>
Date: 星期一, 04 十一月 2024 19:01:38 +0800
Subject: [PATCH] excel导出优化
---
src/main/java/com/zy/asrs/mapper/AgvWrkMastMapper.java | 18 ++++++++++++++++++
1 files changed, 18 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/mapper/AgvWrkMastMapper.java b/src/main/java/com/zy/asrs/mapper/AgvWrkMastMapper.java
index 46ca27e..2b0f3f6 100644
--- a/src/main/java/com/zy/asrs/mapper/AgvWrkMastMapper.java
+++ b/src/main/java/com/zy/asrs/mapper/AgvWrkMastMapper.java
@@ -2,9 +2,27 @@
import com.baomidou.mybatisplus.mapper.BaseMapper;
import com.zy.asrs.entity.AgvWrkMast;
+import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Mapper;
@Mapper
public interface AgvWrkMastMapper extends BaseMapper<AgvWrkMast> {
+ @Insert("INSERT INTO agv_wrk_mast(wrk_sts," +
+ "io_type," +
+ "io_time," +
+ "io_pri," +
+ "source_loc_no," +
+ "loc_no," +
+ "crn_no," +
+ "barcode," +
+ "whs_type," +
+ "manu_type," +
+ "appe_user," +
+ "appe_time," +
+ "modi_user," +
+ "modi_time) " +
+ "VALUES(#{wrkSts},#{ioType},#{ioTime},#{ioPri},#{sourceLocNo},#{locNo},#{crnNo},#{barcode},#{whsType},#{manuType},#{appeUser},#{appeTime},#{modiUser},#{modiTime})")
+ public int insertByIncrease(AgvWrkMast agvWrkMast);
+
}
--
Gitblit v1.9.1