From f46a102b5f5ab7e2c74c9d05f9d6e06c358b8c02 Mon Sep 17 00:00:00 2001
From: jiazx0107@163.com <jiazx0107@163.com>
Date: 星期四, 29 六月 2023 20:29:53 +0800
Subject: [PATCH] 优化出入库信息2

---
 igds-doc/sql/update-v35-to-v40.sql |    3 +++
 1 files changed, 3 insertions(+), 0 deletions(-)

diff --git a/igds-doc/sql/update-v35-to-v40.sql b/igds-doc/sql/update-v35-to-v40.sql
index 8eb63a1..e67f078 100644
--- a/igds-doc/sql/update-v35-to-v40.sql
+++ b/igds-doc/sql/update-v35-to-v40.sql
@@ -45,3 +45,6 @@
 UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '33' WHERE DEPOT_STATUS_ ='07';
 UPDATE D_DEPOT_STORE SET DEPOT_STATUS_ = '34' WHERE DEPOT_STATUS_ ='09';
 
+-- 璋冩暣鍑哄叆搴撴暟鎹姸鎬�
+UPDATE D_INOUT_RECORD SET RECORD_STATUS_ ='DEL' WHERE RECORD_STATUS_='ERROR';
+

--
Gitblit v1.9.3