From 5e851678cc02257bbbd179446de36082430ca5bc Mon Sep 17 00:00:00 2001
From: wanshenmean <cathay_xy@163.com>
Date: 星期一, 13 四月 2026 15:12:04 +0800
Subject: [PATCH] feat(MES): 添加Mes_Log扩展逻辑
---
Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260413_MesLogPage_Config.sql | 189 +++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 189 insertions(+), 0 deletions(-)
diff --git a/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260413_MesLogPage_Config.sql b/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260413_MesLogPage_Config.sql
new file mode 100644
index 0000000..9009709
--- /dev/null
+++ b/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260413_MesLogPage_Config.sql
@@ -0,0 +1,189 @@
+-- =============================================
+-- MES 鎺ュ彛鏃ュ織椤甸潰鏁版嵁搴撻厤缃剼鏈�
+-- 鍒涘缓鏃ユ湡: 2026-04-13
+-- 璇存槑: 鍒涘缓鎬ц兘绱㈠紩銆佽彍鍗曡褰曘�佹暟鎹瓧鍏�
+-- =============================================
+
+-- =============================================
+-- Step 1: 鍒涘缓鎬ц兘绱㈠紩
+-- =============================================
+
+-- 鎺ュ彛绫诲瀷绱㈠紩
+IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name = 'IX_MesApiLog_ApiType' AND object_id = OBJECT_ID('Dt_MesApiLog'))
+BEGIN
+ CREATE INDEX IX_MesApiLog_ApiType ON Dt_MesApiLog(ApiType);
+ PRINT '绱㈠紩 IX_MesApiLog_ApiType 宸插垱寤�';
+END
+ELSE
+ PRINT '绱㈠紩 IX_MesApiLog_ApiType 宸插瓨鍦�';
+
+-- 鍒涘缓鏃堕棿绱㈠紩
+IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name = 'IX_MesApiLog_CreateDate' AND object_id = OBJECT_ID('Dt_MesApiLog'))
+BEGIN
+ CREATE INDEX IX_MesApiLog_CreateDate ON Dt_MesApiLog(CreateDate DESC);
+ PRINT '绱㈠紩 IX_MesApiLog_CreateDate 宸插垱寤�';
+END
+ELSE
+ PRINT '绱㈠紩 IX_MesApiLog_CreateDate 宸插瓨鍦�';
+
+-- 鎴愬姛鐘舵�佺储寮�
+IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name = 'IX_MesApiLog_IsSuccess' AND object_id = OBJECT_ID('Dt_MesApiLog'))
+BEGIN
+ CREATE INDEX IX_MesApiLog_IsSuccess ON Dt_MesApiLog(IsSuccess);
+ PRINT '绱㈠紩 IX_MesApiLog_IsSuccess 宸插垱寤�';
+END
+ELSE
+ PRINT '绱㈠紩 IX_MesApiLog_IsSuccess 宸插瓨鍦�';
+
+-- 鍒涘缓浜虹储寮�
+IF NOT EXISTS (SELECT * FROM sys.indexes WHERE name = 'IX_MesApiLog_Creator' AND object_id = OBJECT_ID('Dt_MesApiLog'))
+BEGIN
+ CREATE INDEX IX_MesApiLog_Creator ON Dt_MesApiLog(Creator);
+ PRINT '绱㈠紩 IX_MesApiLog_Creator 宸插垱寤�';
+END
+ELSE
+ PRINT '绱㈠紩 IX_MesApiLog_Creator 宸插瓨鍦�';
+
+PRINT '=====================================';
+PRINT '绱㈠紩鍒涘缓瀹屾垚';
+PRINT '=====================================';
+GO
+
+-- =============================================
+-- Step 2: 娣诲姞鑿滃崟璁板綍
+-- =============================================
+
+-- 鏌ヨ绯荤粺绠＄悊鑿滃崟鐨� ID
+DECLARE @SystemMenuId INT;
+SELECT TOP 1 @SystemMenuId = Id FROM Dt_Menu WHERE MenuName LIKE '%绯荤粺%' OR MenuName LIKE '%System%';
+
+IF @SystemMenuId IS NULL
+BEGIN
+ PRINT '璀﹀憡: 鏈壘鍒扮郴缁熺鐞嗚彍鍗曪紝璇锋墜鍔ㄧ‘璁よ彍鍗� ID';
+END
+ELSE
+BEGIN
+ PRINT '绯荤粺绠＄悊鑿滃崟 ID: ' + CAST(@SystemMenuId AS VARCHAR(10));
+
+ -- 妫�鏌� MES 鎺ュ彛鏃ュ織鑿滃崟鏄惁宸插瓨鍦�
+ IF NOT EXISTS (SELECT 1 FROM Dt_Menu WHERE Url = '/Mes_Log')
+ BEGIN
+ INSERT INTO Dt_Menu (ParentId, MenuName, Url, Component, Permission, Sort, Icon, CreateDate, Modifier)
+ VALUES (
+ @SystemMenuId,
+ 'MES鎺ュ彛鏃ュ織',
+ '/Mes_Log',
+ 'views/system/Mes_Log',
+ 'Mes_Log:view',
+ (SELECT ISNULL(MAX(Sort), 0) + 1 FROM Dt_Menu WHERE ParentId = @SystemMenuId),
+ 'el-icon-document',
+ GETDATE(),
+ 'System'
+ );
+ PRINT 'MES鎺ュ彛鏃ュ織鑿滃崟宸叉坊鍔狅紝ID: ' + CAST(SCOPE_IDENTITY() AS VARCHAR(10));
+ END
+ ELSE
+ BEGIN
+ PRINT 'MES鎺ュ彛鏃ュ織鑿滃崟宸插瓨鍦�';
+ END
+END
+GO
+
+-- =============================================
+-- Step 3: 娣诲姞鏁版嵁瀛楀吀璁板綍
+-- =============================================
+
+-- 鎺ュ彛绫诲瀷瀛楀吀
+DECLARE @DictId INT;
+SELECT @DictId = Id FROM Dt_Dictionary WHERE DictKey = 'mesApiType';
+
+IF @DictId IS NULL
+BEGIN
+ INSERT INTO Dt_Dictionary (DictKey, DictValue, CreateDate, Modifier)
+ VALUES ('mesApiType', 'MES鎺ュ彛绫诲瀷', GETDATE(), 'System');
+ SET @DictId = SCOPE_IDENTITY();
+ PRINT 'MES鎺ュ彛绫诲瀷瀛楀吀宸插垱寤猴紝ID: ' + CAST(@DictId AS VARCHAR(10));
+END
+ELSE
+BEGIN
+ PRINT 'MES鎺ュ彛绫诲瀷瀛楀吀宸插瓨鍦紝ID: ' + CAST(@DictId AS VARCHAR(10));
+END
+
+-- 娣诲姞鎺ュ彛绫诲瀷閫夐」
+IF NOT EXISTS (SELECT 1 FROM Dt_DictionaryList WHERE DictId = @DictId AND [Key] = 'BindContainer')
+BEGIN
+ INSERT INTO Dt_DictionaryList (DictId, Value, [Key], DisplayOrder, CreateDate, Modifier)
+ VALUES (@DictId, '鐢佃姱缁戝畾', 'BindContainer', 1, GETDATE(), 'System');
+ PRINT '鎺ュ彛绫诲瀷閫夐」宸叉坊鍔�: BindContainer (鐢佃姱缁戝畾)';
+END
+
+IF NOT EXISTS (SELECT 1 FROM Dt_DictionaryList WHERE DictId = @DictId AND [Key] = 'UnBindContainer')
+BEGIN
+ INSERT INTO Dt_DictionaryList (DictId, Value, [Key], DisplayOrder, CreateDate, Modifier)
+ VALUES (@DictId, '鐢佃姱瑙ｇ粦', 'UnBindContainer', 2, GETDATE(), 'System');
+ PRINT '鎺ュ彛绫诲瀷閫夐」宸叉坊鍔�: UnBindContainer (鐢佃姱瑙ｇ粦)';
+END
+
+IF NOT EXISTS (SELECT 1 FROM Dt_DictionaryList WHERE DictId = @DictId AND [Key] = 'ContainerNgReport')
+BEGIN
+ INSERT INTO Dt_DictionaryList (DictId, Value, [Key], DisplayOrder, CreateDate, Modifier)
+ VALUES (@DictId, 'NG涓婃姤', 'ContainerNgReport', 3, GETDATE(), 'System');
+ PRINT '鎺ュ彛绫诲瀷閫夐」宸叉坊鍔�: ContainerNgReport (NG涓婃姤)';
+END
+
+IF NOT EXISTS (SELECT 1 FROM Dt_DictionaryList WHERE DictId = @DictId AND [Key] = 'InboundInContainer')
+BEGIN
+ INSERT INTO Dt_DictionaryList (DictId, Value, [Key], DisplayOrder, CreateDate, Modifier)
+ VALUES (@DictId, '鎵樼洏杩涚珯', 'InboundInContainer', 4, GETDATE(), 'System');
+ PRINT '鎺ュ彛绫诲瀷閫夐」宸叉坊鍔�: InboundInContainer (鎵樼洏杩涚珯)';
+END
+
+IF NOT EXISTS (SELECT 1 FROM Dt_DictionaryList WHERE DictId = @DictId AND [Key] = 'OutboundInContainer')
+BEGIN
+ INSERT INTO Dt_DictionaryList (DictId, Value, [Key], DisplayOrder, CreateDate, Modifier)
+ VALUES (@DictId, '鎵樼洏鍑虹珯', 'OutboundInContainer', 5, GETDATE(), 'System');
+ PRINT '鎺ュ彛绫诲瀷閫夐」宸叉坊鍔�: OutboundInContainer (鎵樼洏鍑虹珯)';
+END
+
+-- 璋冪敤鐘舵�佸瓧鍏�
+DECLARE @StatusDictId INT;
+SELECT @StatusDictId = Id FROM Dt_Dictionary WHERE DictKey = 'mesApiStatus';
+
+IF @StatusDictId IS NULL
+BEGIN
+ INSERT INTO Dt_Dictionary (DictKey, DictValue, CreateDate, Modifier)
+ VALUES ('mesApiStatus', 'MES鎺ュ彛鐘舵��', GETDATE(), 'System');
+ SET @StatusDictId = SCOPE_IDENTITY();
+ PRINT 'MES鎺ュ彛鐘舵�佸瓧鍏稿凡鍒涘缓锛孖D: ' + CAST(@StatusDictId AS VARCHAR(10));
+END
+ELSE
+BEGIN
+ PRINT 'MES鎺ュ彛鐘舵�佸瓧鍏稿凡瀛樺湪锛孖D: ' + CAST(@StatusDictId AS VARCHAR(10));
+END
+
+-- 娣诲姞鐘舵�侀�夐」
+IF NOT EXISTS (SELECT 1 FROM Dt_DictionaryList WHERE DictId = @StatusDictId AND [Key] = 'true')
+BEGIN
+ INSERT INTO Dt_DictionaryList (DictId, Value, [Key], DisplayOrder, CreateDate, Modifier)
+ VALUES (@StatusDictId, '鎴愬姛', 'true', 1, GETDATE(), 'System');
+ PRINT '鐘舵�侀�夐」宸叉坊鍔�: true (鎴愬姛)';
+END
+
+IF NOT EXISTS (SELECT 1 FROM Dt_DictionaryList WHERE DictId = @StatusDictId AND [Key] = 'false')
+BEGIN
+ INSERT INTO Dt_DictionaryList (DictId, Value, [Key], DisplayOrder, CreateDate, Modifier)
+ VALUES (@StatusDictId, '澶辫触', 'false', 2, GETDATE(), 'System');
+ PRINT '鐘舵�侀�夐」宸叉坊鍔�: false (澶辫触)';
+END
+
+PRINT '=====================================';
+PRINT '鏁版嵁瀛楀吀閰嶇疆瀹屾垚';
+PRINT '=====================================';
+GO
+
+-- =============================================
+-- 鎵ц瀹屾瘯
+-- =============================================
+PRINT '=====================================';
+PRINT 'MES 鎺ュ彛鏃ュ織椤甸潰鏁版嵁搴撻厤缃墽琛屽畬姣�';
+PRINT '=====================================';
--
Gitblit v1.9.3