From 6e6b156bb0100043214c170d7171eb79e0d7e344 Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周五, 26 4月 2024 13:48:42 +0800 Subject: [PATCH] 时间查询 选完时间再清除掉 接口报错 --- DBScript/02_DML/01_InitData.sql | 65 ++++++++++++++++++++++++++++++++ 1 files changed, 65 insertions(+), 0 deletions(-) diff --git a/DBScript/02_DML/01_InitData.sql b/DBScript/02_DML/01_InitData.sql index f2613a0..fc7829d 100644 --- a/DBScript/02_DML/01_InitData.sql +++ b/DBScript/02_DML/01_InitData.sql @@ -20,3 +20,68 @@ INSERT INTO dbo.Base_SerialRuleDetail (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) VALUES(14, N'1', 10, 5, N'SN', 3, 0, 1, NULL, 0, N'娴嬭瘯缂栧彿缂栧彿-娴佹按鍙�', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); + + +-- 鍒濆鍖� 鏇夸唬鍝佺紪鍙� 銆怑ditby liuwq,2024-04-25銆� + DELETE Base_SerialRuleDetail where SerialType =20; + GO + + INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(20, N'1', 20, 1, N'UD', 15, 0, 1, N'SC_', 0, N'鏇夸唬鍝佺紪鍙�-鍓嶇紑', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(21, N'1', 20, 2, N'Y4', 4, 0, 1, NULL, 0, N'鏇夸唬鍝佺紪鍙�-骞翠唤', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(22, N'1', 20, 3, N'M2', 4, 0, 1, NULL, 0, N'鏇夸唬鍝佺紪鍙�-鏈堜唤', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(23, N'1', 20, 4, N'D2', 4, 0, 1, NULL, 0, N'鏇夸唬鍝佺紪鍙�-鏃�', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(24, N'1', 20, 5, N'SN', 3, 0, 1, NULL, 0, N'鏇夸唬鍝佺紪鍙�-娴佹按鍙�', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); + + +-- 鍒濆鍖� 瀹㈡埛缂栧彿 銆怑ditby liuwq,2024-04-25銆� + DELETE Base_SerialRuleDetail where SerialType =30; + GO + + INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(30, N'1', 30, 1, N'UD', 15, 0, 1, N'BC_', 0, N'瀹㈡埛缂栧彿-鍓嶇紑', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(31, N'1', 30, 2, N'Y4', 4, 0, 1, NULL, 0, N'瀹㈡埛缂栧彿-骞翠唤', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(32, N'1', 30, 3, N'M2', 4, 0, 1, NULL, 0, N'瀹㈡埛缂栧彿-鏈堜唤', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(33, N'1', 30, 4, N'D2', 4, 0, 1, NULL, 0, N'瀹㈡埛缂栧彿-鏃�', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(34, N'1', 30, 5, N'SN', 3, 0, 1, NULL, 0, N'瀹㈡埛缂栧彿-娴佹按鍙�', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); + + + +-- 鍒濆鍖� 搴撲綅缂栧彿 銆怑ditby liuwq,2024-04-25銆� + DELETE Base_SerialRuleDetail where SerialType =40; + GO + + INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(40, N'1', 40, 1, N'UD', 15, 0, 1, N'PL_', 0, N'搴撲綅缂栧彿-鍓嶇紑', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(41, N'1', 40, 2, N'Y4', 4, 0, 1, NULL, 0, N'搴撲綅缂栧彿-骞翠唤', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(42, N'1', 40, 3, N'M2', 4, 0, 1, NULL, 0, N'搴撲綅缂栧彿-鏈堜唤', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(43, N'1', 40, 4, N'D2', 4, 0, 1, NULL, 0, N'搴撲綅缂栧彿-鏃�', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); +INSERT INTO dbo.Base_SerialRuleDetail +(Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreatedTime, UpdatedTime, CreatedUserId, CreatedUserName, UpdatedUserId, UpdatedUserName, IsDeleted) +VALUES(44, N'1', 40, 5, N'SN', 3, 0, 1, NULL, 0, N'搴撲綅缂栧彿-娴佹按鍙�', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); + -- Gitblit v1.9.3