From 8ba4f65089aef9ab488574a70a0738f45ce4ab10 Mon Sep 17 00:00:00 2001
From: zjj <3272660260@qq.com>
Date: 星期一, 01 四月 2024 08:50:55 +0800
Subject: [PATCH] #立库转平库
---
src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java | 8 ++++++++
1 files changed, 8 insertions(+), 0 deletions(-)
diff --git a/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java b/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java
index 62b7596..8de1f19 100644
--- a/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java
+++ b/src/main/java/com/zy/asrs/task/handler/OverYearLogHandler.java
@@ -26,6 +26,14 @@
jdbcTemplate.update("delete from asr_wrk_mast_log where dateadd(day,360,appe_time) <= getdate();");
jdbcTemplate.update("delete from cust_wait_pakin_log where dateadd(day,360,appe_time) <= getdate();");
+ //鍒犻櫎鍑哄簱閫氱煡鏄庣粏妗ｆ暟鎹紝鏃ユ湡瓒呰繃180澶╋紝鎴栬�呭凡鍑哄簱鏁伴噺澶т簬绛変簬閫氱煡鍑哄簱閲忥紝涓旀棩鏈熻秴杩�7澶�
+ String sql = "delete ise from OutStockBillEntry ise left join OutStockbill isb on isb.FInterID = ise.FInterID where 1=1 ";
+ sql += "and (dateadd(day,180,ise.FFetchDate) <= getdate() or (ise.FAuxCommitQty>=ise.FQty and dateadd(day,7,ise.FFetchDate) <= getdate()) )";
+ jdbcTemplate.update(sql);
+
+ //鍒犻櫎娌℃湁鏄庣粏鐨勫嚭搴撻�氱煡涓绘。鏁版嵁
+ sql = "delete OutStockbill from OutStockbill where FInterID not in (select FInterID from OutStockBillEntry)";
+ jdbcTemplate.update(sql);
} catch (Exception e) {
e.printStackTrace();
TransactionAspectSupport.currentTransactionStatus().setRollbackOnly();
--
Gitblit v1.9.1