From ce1292c9cf37195b6abd2699dfc5d6cb3e143c9b Mon Sep 17 00:00:00 2001
From: wanshenmean <cathay_xy@163.com>
Date: 星期日, 12 四月 2026 23:38:19 +0800
Subject: [PATCH] feat(MES): 添加MES接口相关实体和DTO JS扩展文件至JSX格式并更新配置
---
Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260412_MesApiLog.sql | 92 ++++++++++++++++++++++++++++++++++++++++++++++
1 files changed, 92 insertions(+), 0 deletions(-)
diff --git a/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260412_MesApiLog.sql b/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260412_MesApiLog.sql
new file mode 100644
index 0000000..384f089
--- /dev/null
+++ b/Code/WMS/WIDESEA_WMSServer/Database/Scripts/20260412_MesApiLog.sql
@@ -0,0 +1,92 @@
+-- =============================================
+-- WMS MES鎺ュ彛璋冪敤鏃ュ織琛�
+-- 鍒涘缓鏃ユ湡: 2026-04-12
+-- 鎻忚堪: 璁板綍鎵�鏈塎ES鎺ュ彛鐨勮皟鐢ㄦ棩蹇楋紝鍖呮嫭璇锋眰銆佸搷搴斻�佽�楁椂銆佹垚鍔�/澶辫触鐘舵�佺瓑淇℃伅
+-- =============================================
+
+IF NOT EXISTS (SELECT * FROM sys.tables WHERE name = 'Dt_MesApiLog')
+BEGIN
+ CREATE TABLE Dt_MesApiLog (
+ Id BIGINT PRIMARY KEY IDENTITY(1,1),
+ ApiType NVARCHAR(50) NOT NULL, -- 鎺ュ彛绫诲瀷
+ RequestJson NVARCHAR(MAX) NULL, -- 璇锋眰JSON
+ ResponseJson NVARCHAR(MAX) NULL, -- 鍝嶅簲JSON
+ IsSuccess BIT NOT NULL DEFAULT 0, -- 鏄惁鎴愬姛
+ ErrorMessage NVARCHAR(500) NULL, -- 閿欒淇℃伅
+ ElapsedMs INT NOT NULL DEFAULT 0, -- 鑰楁椂(姣)
+ CreateDate DATETIME NOT NULL, -- 鍒涘缓鏃堕棿
+ Creator NVARCHAR(50) NULL, -- 鍒涘缓浜�
+ ModifyDate DATETIME NULL, -- 淇敼鏃堕棿
+ Modifier NVARCHAR(50) NULL -- 淇敼浜�
+ );
+
+ -- 鍒涘缓绱㈠紩
+ CREATE INDEX IX_MesApiLog_ApiType ON Dt_MesApiLog(ApiType);
+ CREATE INDEX IX_MesApiLog_CreateDate ON Dt_MesApiLog(CreateDate);
+ CREATE INDEX IX_MesApiLog_IsSuccess ON Dt_MesApiLog(IsSuccess);
+
+ PRINT 'MES鎺ュ彛鏃ュ織琛� Dt_MesApiLog 鍒涘缓鎴愬姛';
+END
+ELSE
+BEGIN
+ PRINT 'MES鎺ュ彛鏃ュ織琛� Dt_MesApiLog 宸插瓨鍦�';
+END
+GO
+
+-- =============================================
+-- 鎻掑叆MES绯荤粺閰嶇疆
+-- =============================================
+
+-- 妫�鏌ュ苟鎻掑叆MES璁惧缂栫爜閰嶇疆
+IF NOT EXISTS (SELECT * FROM Dt_SystemConfig WHERE ConfigKey = 'MES_EquipmentCode')
+BEGIN
+ INSERT INTO Dt_SystemConfig (ConfigKey, ConfigValue, Description, CreateDate, Modifier)
+ VALUES ('MES_EquipmentCode', 'WCS_001', 'MES璁惧缂栫爜', GETDATE(), 'System');
+ PRINT 'MES璁惧缂栫爜閰嶇疆鎻掑叆鎴愬姛';
+END
+ELSE
+BEGIN
+ PRINT 'MES璁惧缂栫爜閰嶇疆宸插瓨鍦�';
+END
+GO
+
+-- 妫�鏌ュ苟鎻掑叆MES璧勬簮缂栫爜閰嶇疆
+IF NOT EXISTS (SELECT * FROM Dt_SystemConfig WHERE ConfigKey = 'MES_ResourceCode')
+BEGIN
+ INSERT INTO Dt_SystemConfig (ConfigKey, ConfigValue, Description, CreateDate, Modifier)
+ VALUES ('MES_ResourceCode', 'RESOURCE_001', 'MES璧勬簮缂栫爜', GETDATE(), 'System');
+ PRINT 'MES璧勬簮缂栫爜閰嶇疆鎻掑叆鎴愬姛';
+END
+ELSE
+BEGIN
+ PRINT 'MES璧勬簮缂栫爜閰嶇疆宸插瓨鍦�';
+END
+GO
+
+-- 妫�鏌ュ苟鎻掑叆MES鎺ュ彛鍦板潃閰嶇疆
+IF NOT EXISTS (SELECT * FROM Dt_SystemConfig WHERE ConfigKey = 'MES_ApiBaseUrl')
+BEGIN
+ INSERT INTO Dt_SystemConfig (ConfigKey, ConfigValue, Description, CreateDate, Modifier)
+ VALUES ('MES_ApiBaseUrl', 'http://mes-server/api', 'MES鎺ュ彛鍦板潃', GETDATE(), 'System');
+ PRINT 'MES鎺ュ彛鍦板潃閰嶇疆鎻掑叆鎴愬姛';
+END
+ELSE
+BEGIN
+ PRINT 'MES鎺ュ彛鍦板潃閰嶇疆宸插瓨鍦�';
+END
+GO
+
+-- 妫�鏌ュ苟鎻掑叆MES鎺ュ彛瓒呮椂鏃堕棿閰嶇疆
+IF NOT EXISTS (SELECT * FROM Dt_SystemConfig WHERE ConfigKey = 'MES_TimeoutSeconds')
+BEGIN
+ INSERT INTO Dt_SystemConfig (ConfigKey, ConfigValue, Description, CreateDate, Modifier)
+ VALUES ('MES_TimeoutSeconds', '30', 'MES鎺ュ彛瓒呮椂鏃堕棿(绉�)', GETDATE(), 'System');
+ PRINT 'MES鎺ュ彛瓒呮椂鏃堕棿閰嶇疆鎻掑叆鎴愬姛';
+END
+ELSE
+BEGIN
+ PRINT 'MES鎺ュ彛瓒呮椂鏃堕棿閰嶇疆宸插瓨鍦�';
+END
+GO
+
+PRINT 'MES鎺ュ彛鏃ュ織琛ㄥ拰绯荤粺閰嶇疆鑴氭湰鎵ц瀹屾垚';
--
Gitblit v1.9.3