From dd18485d5e6a7605b58d667bab2e315fc33a3d4a Mon Sep 17 00:00:00 2001 From: schangxiang@126.com <schangxiang@126.com> Date: 周四, 25 4月 2024 13:40:22 +0800 Subject: [PATCH] 编号自动生成 公共 方法 --- DBScript/02_DML/01_InitData.sql | 23 ++++++++++++++++++++++- 1 files changed, 22 insertions(+), 1 deletions(-) diff --git a/DBScript/02_DML/01_InitData.sql b/DBScript/02_DML/01_InitData.sql index c1f41a9..f2613a0 100644 --- a/DBScript/02_DML/01_InitData.sql +++ b/DBScript/02_DML/01_InitData.sql @@ -1 +1,22 @@ -/* 杩欓噷鍐� 鍒濆鍖栫殑鏁版嵁 */ \ No newline at end of file +/* 杩欓噷鍐� 鍒濆鍖栫殑鏁版嵁 */ + + +-- 鍒濆鍖� 缂栧彿 銆怑ditby shaocx,2023-08-18銆� + DELETE Base_SerialRuleDetail where SerialType =10; + 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(10, N'1', 10, 1, N'UD', 15, 0, 1, N'UndoStoRec_', 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(11, N'1', 10, 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(12, N'1', 10, 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(13, N'1', 10, 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(14, N'1', 10, 5, N'SN', 3, 0, 1, NULL, 0, N'娴嬭瘯缂栧彿缂栧彿-娴佹按鍙�', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); -- Gitblit v1.9.3