From 9fcc7df37205632d94665af7fc7ea56650e79789 Mon Sep 17 00:00:00 2001
From: schangxiang@126.com <schangxiang@126.com>
Date: 周四, 04 9月 2025 10:50:55 +0800
Subject: [PATCH] 支持库位删选
---
sql/DBScript/01_DDL/03_DDL_VIEW_YunNeiDongLi.sql | 42 ++++++++++++++++++++++--------------------
1 files changed, 22 insertions(+), 20 deletions(-)
diff --git a/sql/DBScript/01_DDL/03_DDL_VIEW_YunNeiDongLi.sql b/sql/DBScript/01_DDL/03_DDL_VIEW_YunNeiDongLi.sql
index 2649e60..9f683ae 100644
--- a/sql/DBScript/01_DDL/03_DDL_VIEW_YunNeiDongLi.sql
+++ b/sql/DBScript/01_DDL/03_DDL_VIEW_YunNeiDongLi.sql
@@ -90,17 +90,13 @@
GO
-
-
-
-
/**
** 绔嬩綋搴撳簱瀛�
**/
-IF EXISTS(SELECT 1 FROM sys.views WHERE name='v_srmStock')
- DROP VIEW v_srmStock
+IF EXISTS(SELECT 1 FROM sys.views WHERE name='VproductStock')
+ DROP VIEW VproductStock
GO
-CREATE VIEW v_srmStock
+CREATE VIEW VproductStock
AS
SELECT dbo.productStock.stockId, dbo.position.positionName, dbo.position.isLock, dbo.position.isfree,
@@ -108,39 +104,45 @@
dbo.productStock.status, dbo.productStock.createTime, dbo.productStock.updateTime, dbo.position.enable,
dbo.productStock.positionId, dbo.productStock.materialId, dbo.productStock.productCode,
dbo.productStock.containerCode, dbo.position.positionType, dbo.productStock.supplier, dbo.material.version
-FROM dbo.position LEFT JOIN
- dbo.productStock ON dbo.position.positionId = dbo.productStock.positionId LEFT JOIN
+FROM dbo.position INNER JOIN
+ dbo.productStock ON dbo.position.positionId = dbo.productStock.positionId INNER JOIN
dbo.material ON dbo.productStock.materialId = dbo.material.materialId
- WHERE [position].row=1 OR [position].row=2
-
GO
+
+
+
+
+
+
/**
- ** 绔嬩綋搴撳簱瀛樻槑缁嗭紙绮剧‘鍒版祦姘村彿锛�
+ ** 绔嬩綋搴撳簱瀛樻槑缁嗭紙绮剧‘鍒版祦姘村彿锛� [Editby shaocx,2025-09-02]
**/
-IF EXISTS(SELECT 1 FROM sys.views WHERE name='v_srmStock_details')
- DROP VIEW v_srmStock_details
+IF EXISTS(SELECT 1 FROM sys.views WHERE name='v_srmStockdetails')
+ DROP VIEW v_srmStockdetails
GO
-CREATE VIEW v_srmStock_details
+CREATE VIEW v_srmStockdetails
AS
-SELECT prodList.productName,prodList.serialNumber,
+SELECT prodList.stockListId,prodList.productName,prodList.serialNumber,
dbo.productStock.stockId, dbo.position.positionName, dbo.position.isLock, dbo.position.isfree,
dbo.material.materialCode, dbo.material.materialName, dbo.productStock.quantity, dbo.productStock.taskType,
dbo.productStock.status, dbo.productStock.createTime, dbo.productStock.updateTime, dbo.position.enable,
dbo.productStock.positionId, dbo.productStock.materialId, dbo.productStock.productCode,
dbo.productStock.containerCode, dbo.position.positionType, dbo.productStock.supplier, dbo.material.version
-FROM dbo.position LEFT JOIN
- dbo.productStock ON dbo.position.positionId = dbo.productStock.positionId
- LEFT JOIN productStockList as prodList on prodList.stockId=dbo.productStock.positionId
+FROM productStockList as prodList
+ LEFT JOIN dbo.position on prodList.stockId=dbo.position.positionId
+ LEFT JOIN dbo.productStock ON dbo.position.positionId = dbo.productStock.positionId
+
LEFT JOIN dbo.material ON dbo.productStock.materialId = dbo.material.materialId
WHERE [position].row=1 OR [position].row=2
+ and prodList.stockListId is not null
-GO
+GO
\ No newline at end of file
--
Gitblit v1.9.3