From 0db27b2ea4752d71db98745b76a1805db8f57aaf Mon Sep 17 00:00:00 2001 From: payne <bzrlw2012@163.com> Date: 周四, 25 4月 2024 16:10:49 +0800 Subject: [PATCH] 修改 --- DBScript/02_DML/01_InitData.sql | 43 +++++++++++++++++++++++++++++++++++++++++++ 1 files changed, 43 insertions(+), 0 deletions(-) diff --git a/DBScript/02_DML/01_InitData.sql b/DBScript/02_DML/01_InitData.sql index f2613a0..6e36df0 100644 --- a/DBScript/02_DML/01_InitData.sql +++ b/DBScript/02_DML/01_InitData.sql @@ -20,3 +20,46 @@ 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); + -- Gitblit v1.9.3