1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
| /* 这里写 初始化的数据 */
|
|
| -- 初始化 编号 【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
| );
|
|
