From f6389cceb8f63b677eec5823a86c39ce31176aa6 Mon Sep 17 00:00:00 2001
From: 18516761980 <4761516tqsxp>
Date: 星期六, 26 三月 2022 17:04:06 +0800
Subject: [PATCH] #
---
src/main/java/com/slcf/dao/WaitCheckDao.java | 12 ++++++++++--
1 files changed, 10 insertions(+), 2 deletions(-)
diff --git a/src/main/java/com/slcf/dao/WaitCheckDao.java b/src/main/java/com/slcf/dao/WaitCheckDao.java
index 6e4494e..64fdc76 100644
--- a/src/main/java/com/slcf/dao/WaitCheckDao.java
+++ b/src/main/java/com/slcf/dao/WaitCheckDao.java
@@ -21,9 +21,9 @@
* @return
*/
@Insert("insert into cust_wait_check(lgnum,ivnum,ivpos,lqnum,matnr,maktx,werks,lgtyp,lgpla, "
- + " memo,modi_time) "
+ + " memo,modi_time,modi_user) "
+ " values(#{lgnum},#{ivnum},#{ivpos},#{lqnum},#{matnr},#{maktx},#{werks},#{lgtyp},#{lgpla}, "
- + " #{memo},getdate())")
+ + " #{memo},getdate(),#{modi_user})")
public int insertWaitCheck(WaitCheckBean waitCheck);
//鍒嗛〉鏌ヨ鎵�鏈変俊鎭�
@@ -72,4 +72,12 @@
@Select("select * from cust_wait_check a left join bas_mat_code b on a.mat_no=b.mat_no "
+ "where barcode=#{barcode} order by sheet_no,a.mat_no desc")
public List<WaitCheckBean> getApiWaitCheckList(@Param("barcode")String barcode);
+
+ /**
+ * 鏌ヨ淇℃伅
+ * @param
+ * @return
+ */
+ @Select("select * from cust_wait_check where lgpla=#{locNo}")
+ public WaitCheckBean getWaitCheckByLoc(@Param("locNo")String locNo);
}
--
Gitblit v1.9.1