/* 这里写 初始化的数据 */ -- 初始化 编号 【Editby shaocx,2023-08-18】 DELETE wms_config_serial_rule where SerialType =10; GO INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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); -- 初始化 替代品编号 【Editby liuwq,2024-04-25】 DELETE wms_config_serial_rule where SerialType =20; GO INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(20, N'1', 20, 1, N'UD', 15, 0, 1, N'SG', 0, N'替代品编号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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); -- 初始化 控制属性规则编号 【Editby liuwq,2024-04-25】 DELETE wms_config_serial_rule where SerialType =30; GO INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(30, N'1', 30, 1, N'UD', 15, 0, 1, N'CR', 0, N'控制属性规则编号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) 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); -- 初始化 ASN单号 【Editby liuwq,2024-06-24】 DELETE wms_config_serial_rule where SerialType =40; GO INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(40, N'1', 40, 1, N'UD', 15, 0, 1, N'ASN', 0, N'ASN单号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(41, N'1', 40, 2, N'BT', 15, 0, 1, N'101', 0, N'业务类型-采购收货', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(42, N'1', 40, 3, N'Y4', 4, 0, 1, NULL, 0, N'ASN单号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(43, N'1', 40, 4, N'M2', 4, 0, 1, NULL, 0, N'ASN单号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(44, N'1', 40, 5, N'D2', 4, 0, 1, NULL, 0, N'ASN单号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(45, N'1', 40, 6, N'SN', 4, 0, 1, NULL, 0, N'ASN单号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); -- 初始化 上架单号 【Editby liuwq,2024-06-24】 DELETE wms_config_serial_rule where SerialType =50; GO INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(50, N'1', 50, 1, N'UD', 15, 0, 1, N'MOVE', 0, N'上架单号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(51, N'1', 50, 2, N'BT', 15, 0, 1, N'301', 0, N'业务类型-组盘上架', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(52, N'1', 50, 3, N'Y4', 4, 0, 1, NULL, 0, N'上架单号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(53, N'1', 50, 4, N'M2', 4, 0, 1, NULL, 0, N'上架单号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(54, N'1', 50, 5, N'D2', 4, 0, 1, NULL, 0, N'上架单号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(55, N'1', 50, 6, N'SN', 4, 0, 1, NULL, 0, N'上架单号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); -- 初始化 下架单号 【Editby liuwq,2024-06-24】 DELETE wms_config_serial_rule where SerialType =60; GO INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(60, N'1', 60, 1, N'UD', 15, 0, 1, N'MOVE', 0, N'下架单号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(61, N'1', 60, 2, N'BT', 15, 0, 1, N'201', 0, N'业务类型-组盘上架', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(62, N'1', 60, 3, N'Y4', 4, 0, 1, NULL, 0, N'下架单号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(63, N'1', 60, 4, N'M2', 4, 0, 1, NULL, 0, N'下架单号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(64, N'1', 60, 5, N'D2', 4, 0, 1, NULL, 0, N'下架单号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(65, N'1', 60, 6, N'SN', 4, 0, 1, NULL, 0, N'下架单号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); -- 初始化 报检单号 【Editby liuwq,2024-06-24】 DELETE wms_config_serial_rule where SerialType =70; GO INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(70, N'1', 70, 1, N'UD', 15, 0, 1, N'QC', 0, N'报检单号-前缀', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(71, N'1', 70, 2, N'BT', 15, 0, 1, N'401', 0, N'业务类型-进料检验', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(72, N'1', 70, 3, N'Y4', 4, 0, 1, NULL, 0, N'报检单号-年份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(73, N'1', 70, 4, N'M2', 4, 0, 1, NULL, 0, N'报检单号-月份', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(74, N'1', 70, 5, N'D2', 4, 0, 1, NULL, 0, N'报检单号-日', NULL, 1, 0, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); INSERT INTO dbo.wms_config_serial_rule (Id, SerialRuleNo, SerialType, ItemNo, SourceType, SerialLength, SearchStart, DecimalType, UserDefine, SerialCodeFlag, Description, SerialTypeNo, GetData, PadLeft, IssueStatus, CreateTime, UpdateTime, CreateUserId, CreateUserName, UpdateUserId, UpdateUserName, IsDelete) VALUES(75, N'1', 70, 6, N'SN', 4, 0, 1, NULL, 0, N'报检单号-流水号', NULL, 1, 1, NULL, NULL, NULL, NULL, NULL, NULL, NULL, 0); DELETE wms_sys_basic_data where BasicDataType='1'; INSERT INTO wms_sys_basic_data( [Id], [BasicDataType], [BasicDataValue], [BasicDataUnit], [OperationRemark], [CreateUserName], [CreateTime], [UpdateUserName], [UpdateTime], [IsDelete] ) VALUES ( '576489124704338', '1', -- 调度系统启动相关 '000000', -- 有值就代表有机器启动了调度系统 （000000是默认的空值） '', '调度系统启动相关', 'sys', getdate(), 'sys', getdate(), 0 );