From b743b62c7d57c84d16422841b0b51e85fe53a891 Mon Sep 17 00:00:00 2001
From: 18516761980 <56479841@qq.com>
Date: 星期五, 22 七月 2022 19:33:10 +0800
Subject: [PATCH] #
---
src/main/java/com/slcf/dao/WaitPakOutDao.java | 14 ++++++++++++++
1 files changed, 14 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/slcf/dao/WaitPakOutDao.java b/src/main/java/com/slcf/dao/WaitPakOutDao.java
index 90dfb5c..1904814 100644
--- a/src/main/java/com/slcf/dao/WaitPakOutDao.java
+++ b/src/main/java/com/slcf/dao/WaitPakOutDao.java
@@ -2,6 +2,8 @@
import java.util.List;
+import com.slcf.bean.WaitPakOutLogCondition;
+import com.slcf.pojo.WaitPakOutLogBean;
import org.apache.ibatis.annotations.Delete;
import org.apache.ibatis.annotations.Insert;
import org.apache.ibatis.annotations.Param;
@@ -31,6 +33,12 @@
// @Select("select top (#{epage}) a.*,b.loc_desc loc_sts_name from cust_wait_pakout a,asr_bas_loc_type b where a.loc_sts=b.loc_sts and loc_no not in "
// + " (select top (#{spage}) loc_no from cust_wait_pakout order by loc_no asc) order by loc_no asc")
public List<WaitPakOutBean> queryWaitPakOutList(WaitPakOutCondition waitPakOutCon);
+
+ public Integer waitPakOutSetEms(@Param("lgnum") String lgnum, @Param("tanum") int tanum, @Param("tapos") int tapos);
+
+ public Integer countEmsNum();
+
+ public List<WaitPakOutBean> queryWaitOutPak(@Param("vlpla") String vlpla, @Param("matnr") String matnr);
// //缁熻鎵�鏈夋暟鎹�绘暟閲�
// @Select("select count(*) from cust_wait_pakout")
@@ -121,4 +129,10 @@
*/
@Select("select top 1 * from cust_wait_pakout where status='Y' and io_status='N' and action=2 and prnstatus=1 order by io_status desc,modi_time asc")
public WaitPakOutBean getWaitPakOutPrint();
+
+ /**
+ * 涓嶅垎椤垫煡璇㈡墍鏈変俊鎭紝鐢ㄤ簬excel瀵煎嚭
+ * @return
+ */
+ public List<WaitPakOutBean> getWaitPakOutAll(WaitPakOutCondition condition);
}
--
Gitblit v1.9.1