LanTianZhiNeng/YanTaiLiKu.git

Admin
2026-02-09 6316d516b8a25a294ee149f23c54750c87f1bff7
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
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
345
346
347
348
349
350
351
352
353
354
355
356
357
358
359
360
361
362
363
364
365
366
367
368
369
370
371
372
373
374
375
376
377
378
379
380
381
382
383
384
385
386
387
388
389
390
391
392
393
394
395
396
397
398
399
400
401
402
403
404
405
406
407
408
409
410
411
412
413
414
415
416
417
418
419
420
421
422
423
424
425
426
427
428
429
430
431
432
433
434
435
436
437
438
439
440
441
442
443
444
445
446
447
448
449
450
451
452
453
454
455
456
457
458
459
460
461
462
463
464
465
466
467
468
469
470
471
472
473
474
475
476
477
478
479
480
481
482
483
484
485
486
487
488
489
490
491
492
493
494
495
496
497
498
499
500
501
502
503
504
505
506
507
508
509
510
511
512
513
514
515
516
517
518
519
520
521
522
523
524
525
526
527
528
529
530
531
532
533
534
535
536
537
538
539
540
541
542
543
544
545
546
547
548
549
550
551
552
553
554
555
556
557
558
559
560
561
562
563
564
565
566
567
568
569
570
571
572
573
574
575
576
577
578
579
580
581
582
583
584
585
586
587
588
589
590
591
592
593
594
595
596
597
598
599
600
601
602
603
604
605
606
607
608
609
610
611
612
613
614
615
616
617
618
619
620
621
622
623
624
625
626
627
628
629
630
631
632
633
634
635
636
637
638
639
640
641
642
643
644
645
646
647
648
649
650
651
652
653
654
655
656
657
658
659
660
661
662
663
664
665
666
667
668
669
670
671
672
673
674
675
676
677
678
679
680
681
682
683
684
685
686
687
688
689
690
691
692
693
694
695
696
697
698
699
700
701
702
703
704
705
706
707
708
709
710
711
712
713
714
715
716
717
718
719
720
721
722
723
724
725
726
727
728
729
730
731
732
733
734
735
736
737
738
739
740
741
742
743
744
745
746
747
748
749
750
751
752
753
754
755
756
757
758
759
760
761
762
763
764
765
766
767
768
769
770
771
772
773
774
775
776
777
778
779
780
781
782
783
784
785
786
787
788
789
790
791
792
793
794
795
796
797
798
799
800
801
802
803
804
805
806
807
808
809
810
811
812
813
814
815
816
817
818
819
820
821
822
823
824
825
826
827
828
829
830
831
832
833
834
835
836
837
838
839
840
841
842
843
844
845
846
847
848
849
850
851
852
853
854
855
856
857
858
859
860
861
862
863
864
865
866
867
868
869
870
871
872
873
874
875
876
877
878
879
880
881
882
883
884
885
886
887
888
889
890
891
892
893
894
895
896
897
898
899
900
901
902
903
904
905
906
907
908
909
910
911
912
913
914
915
916
917
918
919
920
921
922
923
924
925
926
927
928
929
930
931
932
933
934
935
936
937
938
939
940
941
942
943
944
945
946
947
948
949
950
951
952
953
954
955
956
957
958
959
960
961
962
963
964
965
966
967
968
969
970
971
972
973
974
975
976
977
978
979
980
981
982
983
984
985
986
987
988
989
990
991
992
993
994
995
996
997
998
999
1000
1001
1002
1003
1004
1005
1006
1007
1008
1009
1010
1011
1012
1013
1014
1015
1016
1017
1018
1019
1020
1021
1022
1023
1024
1025
1026
1027
1028
1029
1030
1031
1032
1033
1034
1035
1036
1037
1038
1039
1040
1041
1042
1043
1044
1045
1046
1047
1048
1049
1050
1051
1052
1053
1054
1055
1056
1057
1058
1059
1060
1061
1062
1063
1064
1065
1066
1067
1068
1069
1070
1071
1072
1073
1074
1075
1076
1077
1078
1079
1080
1081
1082
1083
1084
1085
1086
1087
1088
1089
1090
1091
1092
1093
1094
1095
1096
1097
1098
1099
1100
1101
1102
1103
1104
1105
1106
1107
1108
1109
1110
1111
1112
1113
1114
1115
1116
1117
1118
1119
1120
1121
1122
1123
1124
1125
1126
1127
1128
1129
1130
1131
1132
1133
1134
1135
1136
1137
1138
1139
1140
1141
1142
1143
1144
1145
1146
1147
1148
1149
1150
1151
1152
1153
1154
1155
1156
1157
1158
1159
1160
1161
1162
1163
1164
1165
1166
1167
1168
1169
1170
1171
1172
1173
1174
1175
1176
1177
1178
1179
1180
1181
1182
1183
1184
1185
1186
1187
1188
1189
1190
1191
1192
1193
1194
1195
1196
1197
1198
1199
1200
1201
1202
1203
1204
1205
1206
1207
1208
1209
1210
1211
1212
1213
1214
1215
1216
1217
1218
1219
1220
1221
1222
1223
1224
1225
1226
1227
1228
1229
1230
1231
1232
1233
1234
1235
1236
1237
1238
1239
1240
1241
1242
1243
1244
1245
1246
1247
1248
1249
1250
1251
1252
1253
1254
1255
1256
1257
1258
1259
1260
1261
1262
1263
1264
1265
1266
1267
1268
1269
1270
1271
1272
1273
1274
1275
1276
1277
1278
1279
1280
1281
1282
1283
1284
1285
1286
1287
1288
1289
1290
1291
1292
1293
1294
1295
1296
1297
1298
1299
1300
1301
1302
1303
1304
1305
1306
1307
1308
1309
1310
1311
1312
1313
1314
1315
1316
1317
1318
1319
1320
ÿþUSE [master] 
GO 
/****** Object:  Database [YT_WIDESEA_WCS]    Script Date: 2026/2/9 12:34:30 ******/ 
CREATE DATABASE [YT_WIDESEA_WCS] 
 CONTAINMENT = NONE 
 ON  PRIMARY  
( NAME = N'YT_WIDESEA_WMS', FILENAME = N'E:\SQLserver\R\MSSQL15.MSSQLSERVER\MSSQL\DATA\YT_WIDESEA_WMS.ndf' , SIZE = 8192KB , MAXSIZE = UNLIMITED, FILEGROWTH = 65536KB ) 
 LOG ON  
( NAME = N'YT_WIDESEA_WMS_log', FILENAME = N'E:\SQLserver\R\MSSQL15.MSSQLSERVER\MSSQL\DATA\YT_WIDESEA_WMS_log.ldf' , SIZE = 8192KB , MAXSIZE = 2048GB , FILEGROWTH = 65536KB ) 
 WITH CATALOG_COLLATION = DATABASE_DEFAULT 
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET COMPATIBILITY_LEVEL = 150 
GO 
IF (1 = FULLTEXTSERVICEPROPERTY('IsFullTextInstalled')) 
begin 
EXEC [YT_WIDESEA_WCS].[dbo].[sp_fulltext_database] @action = 'enable' 
end 
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET ANSI_NULL_DEFAULT OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET ANSI_NULLS OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET ANSI_PADDING OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET ANSI_WARNINGS OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET ARITHABORT OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET AUTO_CLOSE OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET AUTO_SHRINK OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET AUTO_UPDATE_STATISTICS ON  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET CURSOR_CLOSE_ON_COMMIT OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET CURSOR_DEFAULT  GLOBAL  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET CONCAT_NULL_YIELDS_NULL OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET NUMERIC_ROUNDABORT OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET QUOTED_IDENTIFIER OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET RECURSIVE_TRIGGERS OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET  ENABLE_BROKER  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET AUTO_UPDATE_STATISTICS_ASYNC OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET DATE_CORRELATION_OPTIMIZATION OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET TRUSTWORTHY OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET ALLOW_SNAPSHOT_ISOLATION OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET PARAMETERIZATION SIMPLE  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET READ_COMMITTED_SNAPSHOT OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET HONOR_BROKER_PRIORITY OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET RECOVERY FULL  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET  MULTI_USER  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET PAGE_VERIFY CHECKSUM   
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET DB_CHAINING OFF  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET FILESTREAM( NON_TRANSACTED_ACCESS = OFF )  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET TARGET_RECOVERY_TIME = 60 SECONDS  
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET DELAYED_DURABILITY = DISABLED  
GO 
EXEC sys.sp_db_vardecimal_storage_format N'YT_WIDESEA_WCS', N'ON' 
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET QUERY_STORE = OFF 
GO 
USE [YT_WIDESEA_WCS] 
GO 
USE [YT_WIDESEA_WCS] 
GO 
/****** Object:  Sequence [dbo].[SeqTaskNum]    Script Date: 2026/2/9 12:34:31 ******/ 
CREATE SEQUENCE [dbo].[SeqTaskNum]  
 AS [int] 
 START WITH 1 
 INCREMENT BY 1 
 MINVALUE 1 
 MAXVALUE 99999 
 CYCLE  
 CACHE  
GO 
/****** Object:  Table [dbo].[Dt_DeviceInfo]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_DeviceInfo]( 
    [Id] [int] IDENTITY(1,1) NOT NULL, 
    [DeviceCode] [varchar](20) NOT NULL, 
    [DeviceName] [varchar](50) NOT NULL, 
    [DeviceType] [varchar](50) NOT NULL, 
    [DeviceStatus] [varchar](20) NOT NULL, 
    [DeviceIp] [varchar](20) NOT NULL, 
    [DevicePort] [int] NOT NULL, 
    [DevicePlcType] [varchar](50) NOT NULL, 
    [DeviceRemark] [varchar](200) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
    [DispatchId] [int] NULL, 
 CONSTRAINT [PK_Dt_DeviceInfo_Id] PRIMARY KEY CLUSTERED  
( 
    [Id] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Dt_DeviceProtocol]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_DeviceProtocol]( 
    [Id] [int] IDENTITY(1,1) NOT NULL, 
    [DeviceId] [int] NOT NULL, 
    [DeviceChildCode] [varchar](20) NOT NULL, 
    [DeviceProDataBlock] [varchar](50) NOT NULL, 
    [DeviceProOffset] [decimal](10, 1) NOT NULL, 
    [DeviceProDataType] [varchar](10) NOT NULL, 
    [DeviceProDataLength] [int] NOT NULL, 
    [DeviceProParamName] [varchar](50) NOT NULL, 
    [DeviceProParamType] [varchar](50) NOT NULL, 
    [DeviceProParamDes] [varchar](50) NULL, 
    [DeviceProRemark] [varchar](200) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Dt_DeviceProtocol_Id] PRIMARY KEY CLUSTERED  
( 
    [Id] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Dt_DeviceProtocolDetail]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_DeviceProtocolDetail]( 
    [Id] [int] IDENTITY(1,1) NOT NULL, 
    [DeviceType] [varchar](20) NOT NULL, 
    [DeviceProParamName] [varchar](255) NOT NULL, 
    [ProtocolDetailType] [varchar](50) NOT NULL, 
    [ProtocalDetailValue] [varchar](50) NOT NULL, 
    [ProtocolDetailDes] [varchar](500) NULL, 
    [Remark] [varchar](200) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Dt_DeviceProtocolDetail_Id] PRIMARY KEY CLUSTERED  
( 
    [Id] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Dt_DispatchInfo]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_DispatchInfo]( 
    [Id] [int] IDENTITY(1,1) NOT NULL, 
    [Name] [varchar](50) NOT NULL, 
    [JobGroup] [varchar](50) NOT NULL, 
    [AssemblyName] [varchar](50) NOT NULL, 
    [ClassName] [varchar](50) NOT NULL, 
    [IntervalSecond] [int] NOT NULL, 
    [BeginTime] [datetime] NULL, 
    [EndTime] [datetime] NULL, 
    [Remark] [varchar](1000) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Dt_DispatchInfo_Id] PRIMARY KEY CLUSTERED  
( 
    [Id] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Dt_roadwayinfo]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_roadwayinfo]( 
    [Id] [int] NOT NULL, 
    [WarehouseName] [varchar](255) NULL, 
    [WarehouseNumber] [varchar](100) NULL, 
    [WarehouseInvType] [varchar](100) NULL, 
    [RoadwayNo] [nvarchar](20) NULL, 
    [EnableStatus] [int] NULL, 
    [InStationCode] [nvarchar](20) NULL, 
    [InSCStationCode] [nvarchar](20) NULL, 
    [OutStationCode] [nvarchar](20) NULL, 
    [OutSCStationCode] [nvarchar](20) NULL, 
    [Remark] [nvarchar](200) NULL, 
    [Creater] [nvarchar](50) NULL, 
    [CreateDate] [datetime2](0) NULL, 
    [Modifier] [nvarchar](50) NULL, 
    [ModifyDate] [datetime2](0) NULL, 
 CONSTRAINT [PK__dt_roadw__3214EC07DCDD1448] PRIMARY KEY CLUSTERED  
( 
    [Id] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Dt_Router]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_Router]( 
    [Id] [int] IDENTITY(1,1) NOT NULL, 
    [StartPosi] [varchar](50) NOT NULL, 
    [NextPosi] [varchar](50) NOT NULL, 
    [InOutType] [bigint] NOT NULL, 
    [ChildPosi] [varchar](50) NOT NULL, 
    [ChildPosiDeviceCode] [varchar](50) NOT NULL, 
    [SrmRow] [int] NULL, 
    [SrmColumn] [int] NULL, 
    [SrmLayer] [int] NULL, 
    [Depth] [int] NULL, 
    [IsEnd] [bit] NOT NULL, 
    [Remark] [varchar](255) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Dt_Router_Id] PRIMARY KEY CLUSTERED  
( 
    [Id] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Dt_Task]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_Task]( 
    [TaskId] [int] IDENTITY(1,1) NOT NULL, 
    [TaskNum] [int] NOT NULL, 
    [PalletCode] [varchar](50) NOT NULL, 
    [Roadway] [varchar](10) NOT NULL, 
    [TaskType] [int] NOT NULL, 
    [TaskState] [int] NOT NULL, 
    [SourceAddress] [varchar](20) NOT NULL, 
    [TargetAddress] [varchar](20) NOT NULL, 
    [CurrentAddress] [varchar](20) NOT NULL, 
    [NextAddress] [varchar](20) NOT NULL, 
    [ExceptionMessage] [varchar](500) NULL, 
    [Grade] [int] NULL, 
    [WMSId] [int] NULL, 
    [Dispatchertime] [datetime] NULL, 
    [Remark] [varchar](255) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
    [PalletCodequantity] [varchar](200) NULL, 
    [WMStaskid] [varchar](200) NULL, 
    [deviceuuid] [varchar](255) NULL, 
 CONSTRAINT [PK_Dt_Task_TaskId] PRIMARY KEY CLUSTERED  
( 
    [TaskId] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Dt_Task_hty]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_Task_hty]( 
    [TaskId] [int] IDENTITY(1,1) NOT NULL, 
    [TaskNum] [int] NOT NULL, 
    [PalletCode] [varchar](50) NOT NULL, 
    [Roadway] [varchar](10) NOT NULL, 
    [TaskType] [int] NOT NULL, 
    [TaskState] [int] NOT NULL, 
    [SourceAddress] [varchar](20) NOT NULL, 
    [TargetAddress] [varchar](20) NOT NULL, 
    [CurrentAddress] [varchar](20) NOT NULL, 
    [NextAddress] [varchar](20) NOT NULL, 
    [ExceptionMessage] [varchar](500) NULL, 
    [Grade] [int] NULL, 
    [WMSId] [int] NULL, 
    [Dispatchertime] [datetime] NULL, 
    [Remark] [varchar](255) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
    [WMStaskid] [varchar](200) NULL, 
    [deviceuuid] [varchar](200) NULL, 
    [PalletCodequantity] [varchar](200) NULL, 
 CONSTRAINT [PK_Dt_Task_TaskId_copy1] PRIMARY KEY CLUSTERED  
( 
    [TaskId] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Dt_TaskExecuteDetail]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Dt_TaskExecuteDetail]( 
    [TaskDetailId] [int] IDENTITY(1,1) NOT NULL, 
    [TaskId] [int] NOT NULL, 
    [TaskNum] [int] NOT NULL, 
    [TaskState] [int] NOT NULL, 
    [CurrentAddress] [varchar](20) NOT NULL, 
    [NextAddress] [varchar](20) NOT NULL, 
    [IsManual] [bit] NOT NULL, 
    [IsNormal] [bit] NOT NULL, 
    [Description] [varchar](max) NOT NULL, 
    [Remark] [varchar](255) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL 
) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_Department]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_Department]( 
    [DepartmentId] [int] IDENTITY(1,1) NOT NULL, 
    [DepartmentName] [varchar](50) NULL, 
    [DepartmentCode] [varchar](50) NULL, 
    [ParentId] [int] NOT NULL, 
    [DepartmentType] [varchar](50) NULL, 
    [Enable] [int] NOT NULL, 
    [Remark] [varchar](2000) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Sys_Department_DepartmentId] PRIMARY KEY CLUSTERED  
( 
    [DepartmentId] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_Dictionary]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_Dictionary]( 
    [DicId] [int] IDENTITY(1,1) NOT NULL, 
    [Config] [varchar](200) NULL, 
    [DBServer] [varchar](50) NULL, 
    [DBSql] [varchar](500) NULL, 
    [DicName] [varchar](50) NULL, 
    [DicNo] [varchar](50) NULL, 
    [Enable] [tinyint] NULL, 
    [OrderNo] [int] NULL, 
    [ParentId] [int] NULL, 
    [Remark] [varchar](2000) NULL, 
    [SystemType] [int] NOT NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Sys_Dictionary_DicId] PRIMARY KEY CLUSTERED  
( 
    [DicId] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_DictionaryList]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_DictionaryList]( 
    [DicListId] [int] IDENTITY(1,1) NOT NULL, 
    [DicName] [varchar](50) NULL, 
    [DicValue] [varchar](50) NULL, 
    [DicId] [int] NOT NULL, 
    [Enable] [tinyint] NULL, 
    [OrderNo] [int] NULL, 
    [Remark] [varchar](2000) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Sys_DictionaryList_DicListId] PRIMARY KEY CLUSTERED  
( 
    [DicListId] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_Log]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_Log]( 
    [Id] [int] IDENTITY(1,1) NOT NULL, 
    [BeginDate] [datetime] NULL, 
    [ElapsedTime] [int] NULL, 
    [EndDate] [datetime] NULL, 
    [RequestParam] [varchar](2000) NULL, 
    [ResponseParam] [varchar](2000) NULL, 
    [Success] [int] NULL, 
    [Url] [varchar](2000) NULL, 
    [UserIP] [varchar](20) NULL, 
    [UserName] [varchar](50) NULL, 
    [User_Id] [int] NULL, 
 CONSTRAINT [PK_Sys_Log_Id] PRIMARY KEY CLUSTERED  
( 
    [Id] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_Menu]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_Menu]( 
    [MenuId] [int] IDENTITY(1,1) NOT NULL, 
    [MenuName] [varchar](50) NULL, 
    [Auth] [varchar](2000) NULL, 
    [Icon] [varchar](200) NULL, 
    [Description] [varchar](2000) NULL, 
    [Enable] [tinyint] NULL, 
    [TableName] [varchar](50) NULL, 
    [ParentId] [int] NOT NULL, 
    [Url] [varchar](50) NULL, 
    [OrderNo] [int] NULL, 
    [MenuType] [int] NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Sys_Menu_MenuId] PRIMARY KEY CLUSTERED  
( 
    [MenuId] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_Role]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_Role]( 
    [RoleId] [int] IDENTITY(1,1) NOT NULL, 
    [DeptId] [int] NULL, 
    [Enable] [tinyint] NOT NULL, 
    [ParentId] [int] NOT NULL, 
    [RoleName] [varchar](50) NOT NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL, 
 CONSTRAINT [PK_Sys_Role_RoleId] PRIMARY KEY CLUSTERED  
( 
    [RoleId] ASC 
)WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_RoleAuth]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_RoleAuth]( 
    [AuthId] [int] IDENTITY(1,1) NOT NULL, 
    [AuthValue] [varchar](500) NULL, 
    [MenuId] [int] NOT NULL, 
    [RoleId] [int] NULL, 
    [UserId] [int] NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_Tenant]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_Tenant]( 
    [TenantId] [int] IDENTITY(1,1) NOT NULL, 
    [TenantName] [varchar](200) NOT NULL, 
    [TenantType] [int] NOT NULL, 
    [DbType] [int] NOT NULL, 
    [ConnectionString] [varchar](1000) NOT NULL, 
    [Status] [int] NOT NULL, 
    [Remark] [varchar](2000) NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL 
) ON [PRIMARY] 
GO 
/****** Object:  Table [dbo].[Sys_User]    Script Date: 2026/2/9 12:34:31 ******/ 
SET ANSI_NULLS ON 
GO 
SET QUOTED_IDENTIFIER ON 
GO 
CREATE TABLE [dbo].[Sys_User]( 
    [User_Id] [int] IDENTITY(1,1) NOT NULL, 
    [UserName] [varchar](100) NOT NULL, 
    [Role_Id] [int] NOT NULL, 
    [RoleName] [varchar](100) NULL, 
    [PhoneNo] [varchar](11) NULL, 
    [Remark] [varchar](200) NULL, 
    [UserPwd] [varchar](200) NOT NULL, 
    [UserTrueName] [varchar](100) NOT NULL, 
    [DeptName] [varchar](100) NULL, 
    [Dept_Id] [int] NULL, 
    [Email] [varchar](100) NULL, 
    [Enable] [tinyint] NOT NULL, 
    [Gender] [int] NULL, 
    [HeadImageUrl] [varchar](500) NULL, 
    [LastModifyPwdDate] [datetime] NULL, 
    [Address] [varchar](200) NULL, 
    [AuditDate] [datetime] NULL, 
    [AuditStatus] [int] NULL, 
    [Auditor] [varchar](100) NULL, 
    [Token] [varchar](500) NULL, 
    [TenantId] [bigint] NOT NULL, 
    [Creater] [varchar](255) NOT NULL, 
    [CreateDate] [datetime] NOT NULL, 
    [Modifier] [varchar](255) NULL, 
    [ModifyDate] [datetime] NULL 
) ON [PRIMARY] 
GO 
SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] ON  
 
INSERT [dbo].[Dt_DeviceInfo] ([Id], [DeviceCode], [DeviceName], [DeviceType], [DeviceStatus], [DeviceIp], [DevicePort], [DevicePlcType], [DeviceRemark], [Creater], [CreateDate], [Modifier], [ModifyDate], [DispatchId]) VALUES (1, N'SC01', N'1÷SXW:g', N'CommonStackerCrane', N'0', N'10.50.11.79', 102, N'SiemensS7', N'', N'1', CAST(N'2024-10-29T15:21:11.013' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.257' AS DateTime), 1) 
INSERT [dbo].[Dt_DeviceInfo] ([Id], [DeviceCode], [DeviceName], [DeviceType], [DeviceStatus], [DeviceIp], [DevicePort], [DevicePlcType], [DeviceRemark], [Creater], [CreateDate], [Modifier], [ModifyDate], [DispatchId]) VALUES (2, N'SC02', N'2÷SXW:g', N'CommonStackerCrane', N'0', N'10.50.11.69', 102, N'SiemensS7', N'1', N'1', CAST(N'2024-10-29T15:21:11.013' AS DateTime), N'admin', CAST(N'2024-10-29T16:03:59.823' AS DateTime), 1) 
SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] OFF 
SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] ON  
 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, 1, N'SC01', N'DB106', CAST(2.0 AS Decimal(10, 1)), N'byte', 1, N'StackerCraneStatus', N'StackerCraneStatus', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.260' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, 1, N'SC01', N'DB106', CAST(3.0 AS Decimal(10, 1)), N'byte', 1, N'StackerCraneAutoStatus', N'StackerCraneAutoStatus', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.260' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, 1, N'SC01', N'DB106', CAST(18.0 AS Decimal(10, 1)), N'dint', 1, N'CurrentTaskNum', N'CurrentTaskNum', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, 1, N'SC01', N'DB106', CAST(22.0 AS Decimal(10, 1)), N'byte', 1, N'StackerCraneWorkStatus', N'StackerCraneWorkStatus', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, 1, N'SC01', N'DB105', CAST(2.0 AS Decimal(10, 1)), N'dint', 1, N'TaskNum', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, 1, N'SC01', N'DB105', CAST(6.0 AS Decimal(10, 1)), N'int', 1, N'WorkType', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, 1, N'SC01', N'DB105', CAST(8.0 AS Decimal(10, 1)), N'int', 1, N'TrayType', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, 1, N'SC01', N'DB105', CAST(10.0 AS Decimal(10, 1)), N'int', 1, N'StartRow', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, 1, N'SC01', N'DB105', CAST(12.0 AS Decimal(10, 1)), N'int', 1, N'StartColumn', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.263' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, 1, N'SC01', N'DB105', CAST(14.0 AS Decimal(10, 1)), N'int', 1, N'StartLayer', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, 1, N'SC01', N'DB105', CAST(16.0 AS Decimal(10, 1)), N'int', 1, N'EndRow', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, 1, N'SC01', N'DB105', CAST(18.0 AS Decimal(10, 1)), N'int', 1, N'EndColumn', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, 1, N'SC01', N'DB105', CAST(20.0 AS Decimal(10, 1)), N'int', 1, N'EndLayer', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime)) 
INSERT [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, 1, N'SC01', N'DB105', CAST(22.0 AS Decimal(10, 1)), N'string', 25, N'Barcode', N'DeviceCommand', NULL, NULL, N'admin', CAST(N'2024-10-29T15:21:11.413' AS DateTime), N'admin', CAST(N'2024-11-18T14:13:21.267' AS DateTime)) 
SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] OFF 
SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] ON  
 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'CommonStackerCrane', N'StackerCraneStatus', N'Normal', N'1', N'¾Y¶r`(1:ck8^)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'CommonStackerCrane', N'StackerCraneStatus', N'Fault', N'2', N'¾Y¶r`(2:Ee)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'CommonStackerCrane', N'StackerCraneStatus', N'EmergencyStop', N'3', N'¾Y¶r`(3:%`\P)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'CommonStackerCrane', N'StackerCraneAutoStatus', N'Maintenance', N'0', N'å]\O!j_(0:ô~îO)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'CommonStackerCrane', N'StackerCraneAutoStatus', N'Manual', N'1', N'å]\O!j_(1:Kb¨R', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, N'CommonStackerCrane', N'StackerCraneAutoStatus', N'SemiAutomatic', N'2', N'å]\O!j_(2:JSê¨R)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, N'CommonStackerCrane', N'StackerCraneAutoStatus', N'Automatic', N'3', N'å]\O!j_(3:ê¨R)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'Standby', N'0', N'\ON¶r`(0:_:g)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PickUp', N'1', N'\ON¶r`(1:ÖS'-N)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PickUpCompleted', N'2', N'\ON¶r`(2:ÖS'[b)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'Putting', N'4', N'\ON¶r`(4:>e'-N)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PutCompleted', N'5', N'\ON¶r`(5:>e'[b)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, N'CommonStackerCrane', N'StackerCraneWorkStatus', N'WorkCompleted', N'6', N'\ON¶r`(6:ûN¡R[b)', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, N'CommonConveyorLine', N'InteractiveSignal', N'RequestInbound', N'1', N'1', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (15, N'CommonConveyorLine', N'InteractiveSignal', N'RequestInNextAddress', N'2', N'2', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (32, N'CommonConveyorLine', N'InteractiveSignal', N'ConveyorLineInFinish', N'3', N'3', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (34, N'CommonConveyorLine', N'IsOccupied', N'IsOccupied', N'0', N'0', NULL, N'1', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (35, N'CommonConveyorLine', N'InteractiveSignal', N'RequestOutbound', N'4', N'4', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (36, N'CommonConveyorLine', N'InteractiveSignal', N'RequestOutNextAddress', N'5', N'5', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (37, N'CommonConveyorLine', N'InteractiveSignal', N'ConveyorLineOutFinish', N'6', N'6', NULL, N'admin', CAST(N'2024-10-29T15:21:11.733' AS DateTime), NULL, NULL) 
SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] OFF 
SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] ON  
 
INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'XW:g¦^', N'CommonStackerCrane', N'WIDESEAWCS_Tasks', N'CommonStackerCraneJob', 1, NULL, NULL, NULL, N'1', CAST(N'2024-10-29T15:21:12.043' AS DateTime), NULL, NULL) 
INSERT [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1002, N'åe×_nd', N'LogJob', N'WIDESEAWCS_Tasks', N'LogJob', 1, NULL, NULL, N'43200', N'1', CAST(N'2024-12-24T21:21:11.000' AS DateTime), NULL, NULL) 
SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] OFF 
INSERT [dbo].[Dt_roadwayinfo] ([Id], [WarehouseName], [WarehouseNumber], [WarehouseInvType], [RoadwayNo], [EnableStatus], [InStationCode], [InSCStationCode], [OutStationCode], [OutSCStationCode], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'íp    N!jwQ^', N'ZR16', N'invmd', N'C', 1, N'1112', N'YMYL00103700220', N'1109', N'YMYL00103700320', NULL, N'1', CAST(N'2026-01-12T17:13:58.0000000' AS DateTime2), N'1', CAST(N'2026-01-12T17:14:03.0000000' AS DateTime2)) 
INSERT [dbo].[Dt_roadwayinfo] ([Id], [WarehouseName], [WarehouseNumber], [WarehouseInvType], [RoadwayNo], [EnableStatus], [InStationCode], [InSCStationCode], [OutStationCode], [OutSCStationCode], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'íp    N¯Òv^', N'ZR17', N'invxh', N'B', 1, N'1108', N'YMYL00103700620', N'1105', N'YMYL00103700720', NULL, N'1', CAST(N'2026-01-12T17:15:15.0000000' AS DateTime2), NULL, NULL) 
INSERT [dbo].[Dt_roadwayinfo] ([Id], [WarehouseName], [WarehouseNumber], [WarehouseInvType], [RoadwayNo], [EnableStatus], [InStationCode], [InSCStationCode], [OutStationCode], [OutSCStationCode], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'íp    NxÒv^', N'ZR18', N'invsc', N'F', 1, N'1211', N'YMCP00104500306', N'1210', N'YMCP00104500206', NULL, N'1', CAST(N'2026-01-12T17:15:41.0000000' AS DateTime2), NULL, NULL) 
SET IDENTITY_INSERT [dbo].[Dt_Task] ON  
 
INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [PalletCodequantity], [WMStaskid], [deviceuuid]) VALUES (16738, 2, N'22004213289', N'W', 200, 200, N'W01-019-006', N'T07', N'W01-019-006', N'T07', NULL, 1, 0, NULL, NULL, N'System', CAST(N'2026-02-09T12:25:08.297' AS DateTime), NULL, NULL, NULL, NULL, N'3F72-A854-62DA-EE51') 
SET IDENTITY_INSERT [dbo].[Dt_Task] OFF 
SET IDENTITY_INSERT [dbo].[Sys_Dictionary] ON  
 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'{valueField: ''Enable'', 
textField: ''Enable'', 
 containField: null, 
  handler: null }', N'1', NULL, N'/f&T<P', N'enable', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2022-01-03T18:30:18.113' AS DateTime)) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (30, N'{valueField: ''Success'', 
 textField: ''Success'',  
 containField: null, 
 handler: null } 
', NULL, NULL, N'ÍT^¶r`', N'restatus', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-06-12T10:21:48.000' AS DateTime)) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (31, N'{valueField: ''LogType'', 
 textField: ''LogType'',  
 containField: null, 
 handler: null } 
', NULL, NULL, N'åe×_{|W', N'log', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.927' AS DateTime)) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (32, N'{valueField: ''Role_Id'', 
 textField: ''RoleName'',  
 containField: [''Role_Id'',''RoleName''], 
 handler: null } 
', NULL, N'SELECT RoleId as ''key'',RoleName as ''value'' FROM Sys_Role WHERE Enable=1', N'ÒrRh', N'roles', 1, 123, 0, N'sqlíåSkey,valueRÿLubMbýÑ~[pencn', 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-07-13T15:03:53.000' AS DateTime)) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (35, N'{ 
 valueField: ''AuditStatus'', 
 textField: ''AuditStatus'', 
  containField:null  
}', NULL, NULL, N'¡[8h¶r`', N'audit', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime)) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (49, N'{ 
 valueField: ''Gender'', 
 textField: ''Gender'', 
  containField:null  
}', NULL, NULL, N''`+R', N'gender', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-07-23T11:10:28.000' AS DateTime)) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (50, N'{ 
 valueField: ''Enable'', 
 textField: ''Enable'', 
  containField:null  
}', NULL, NULL, N'/T(u¶r`', N'status', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (59, N'{ 
 valueField: ''IsRegregisterPhone'', 
 textField: ''IsRegregisterPhone'', 
  containField:null  
}', NULL, NULL, N'Kb:g(u7b', N'isphone', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2020-11-20T23:05:48.303' AS DateTime)) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (66, NULL, NULL, N'SELECT RoleId AS id,parentId,RoleId AS [key],RoleName AS value FROM Sys_Role', N'§~TÒr', N'tree_roles', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), N'§~¡{tXT', CAST(N'2020-11-20T23:08:03.217' AS DateTime)) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (67, NULL, NULL, NULL, N'nav', N'nav', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (70, NULL, NULL, NULL, N'÷Bl¹e_', N'÷Bl¹e_', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (71, NULL, NULL, NULL, N'[öeûN¡R¶r`', N'[öeûN¡R¶r`', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (72, NULL, NULL, N'SELECT DepartmentId AS ''key'',DepartmentId AS ''id'',ParentId AS parentId,DepartmentName as ''value'' FROM Sys_Department', N'Ä~Ç~:gg', N'Ä~Ç~:gg', 1, NULL, 0, NULL, 10, N'system', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (75, NULL, NULL, NULL, N'åe×_¶r`', N'LogState', 1, NULL, 0, NULL, 1, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.600' AS DateTime), NULL, NULL) 
SET IDENTITY_INSERT [dbo].[Sys_Dictionary] OFF 
SET IDENTITY_INSERT [dbo].[Sys_DictionaryList] ON  
 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'&T', N'0', 3, NULL, 2, NULL, N'admin', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-01-03T18:30:18.113' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'/f', N'1', 3, NULL, 1, NULL, N'xxx', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-01-03T18:30:18.113' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (22, N'vQÖN', N'0', 30, NULL, 10, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-21T16:49:43.000' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (23, N'bR', N'1', 30, NULL, 100, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-21T16:49:43.000' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (24, N'_8^', N'2', 30, NULL, 50, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-21T16:49:43.000' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (25, N'û|ß~', N'System', 31, NULL, 100, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.947' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (26, N'{vF', N'Login', 31, NULL, 90, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.947' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (27, N'°eú^', N'Add', 31, NULL, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.943' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (28, N' Rd', N'Del', 31, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.943' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (29, N'', N'Edit', 31, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.943' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (37, N'_¡[8h', N'0', 35, 0, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (38, N'¡[8hÇ', N'1', 35, NULL, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (39, N'¡[8h-N', N'2', 35, 0, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (71, N'_8^', N'Exception', 31, 0, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.943' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (90, N'7u', N'0', 49, NULL, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-07-23T11:10:28.000' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (91, N'sY', N'1', 49, NULL, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'KmÕ§~¡{tXT', CAST(N'2018-07-23T11:10:28.000' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (96, N'*g/T(u', N'0', 50, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-16T18:17:47.000' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (97, N'ò]/T(u', N'1', 50, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-16T18:17:47.000' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (98, N'ò] Rd', N'2', 50, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2019-08-16T18:17:47.000' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (128, N'/f', N'1', 59, 0, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2020-11-20T23:05:48.303' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (129, N'&T', N'0', 59, 1, NULL, NULL, N'KmÕ§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2020-11-20T23:05:48.303' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (144, N'7R°eToken', N'ReplaceToeken', 31, NULL, 110, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2022-04-04T13:21:54.937' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (145, N'Info', N'3', 30, NULL, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (423, N'/f', N'1', 67, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (424, N'&T', N'0', 67, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (435, N'¡[8h*gÇ', N'3', 35, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-05-08T01:05:44.193' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (436, N'get', N'get', 70, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (437, N'post', N'post', 70, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (438, N'ck8^', N'0', 71, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (439, N'f\P', N'1', 71, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (442, N'sÞV', N'4', 35, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (443, N'y(u', N'DisEnable', 73, 1, 1, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'_ÑS', CAST(N'2023-07-14T14:17:01.037' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (444, N'/T(u', N'Enable', 73, 1, 0, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'_ÑS', CAST(N'2023-07-14T14:17:01.017' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (449, N'áOo`', N'Info', 75, 0, 1, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (450, N'bR', N'Sucess', 75, 0, 2, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (451, N'1Y%', N'Error', 75, 0, 3, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (452, N'1', N'1', 80, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-12-12T10:28:05.550' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (453, N'2', N'2', 80, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-12-12T10:28:05.550' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (454, N'3', N'3', 80, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-12-12T10:28:05.550' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (455, N'4', N'4', 80, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), N'§~¡{tXT', CAST(N'2023-12-12T10:28:05.550' AS DateTime)) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (456, N'*g¡[8h', N'OrderState_Unaudited', 84, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (457, N'ò]¡[8h', N'OrderState_Audited', 84, 0, NULL, NULL, N'§~¡{tXT', CAST(N'2024-10-29T15:21:06.900' AS DateTime), NULL, NULL) 
SET IDENTITY_INSERT [dbo].[Sys_DictionaryList] OFF 
SET IDENTITY_INSERT [dbo].[Sys_Log] ON  
 
INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4662, CAST(N'2026-02-06T14:39:35.297' AS DateTime), 323, CAST(N'2026-02-06T14:39:35.623' AS DateTime), N'{"QueryString":"","BodyData":"{\n? ? \"taskType\": \"in\",\n? ? \"barCode\": \"0000000000001509634\",\n? ? \"original_barCode\": \"22004213289\",\n? ? \"from\": {\n? ? ? ? \"code\": \"W01-019-006\"\n? ? },\n? ? \"to\": {\n? ? ? ? \"code\": \"T07\"\n? ? },\n? ? \"device\": {\n? ? ? ? \"uuid\": \"3F72-A854-62DA-EE51\"\n? ? }\n}"}', N'{"success":true,"datas":null,"messages":["Íd\ObR"]}', NULL, N'http://127.0.0.1:9291/api/WMSTask/saveTask', N'127.0.0.1', N'', NULL) 
INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4663, CAST(N'2026-02-06T14:49:44.833' AS DateTime), 155, CAST(N'2026-02-06T14:49:44.987' AS DateTime), N'{"QueryString":"","BodyData":"{\"userName\":\"admin\",\"password\":\"123456\",\"verificationCode\":\"1234\",\"UUID\":\"4960af55-e47a-4fca-8ee1-ed7e2e0a39ba\"}"}', N'{"status":true,"code":0,"message":null,"data":{"token":"eyJhbGciOiJIUzI1NiIsInR5cCI6IkpXVCJ9.eyJqdGkiOiIxIiwiaWF0IjoiMTc3MDM2MDU4NCIsIm5iZiI6IjE3NzAzNjA1ODQiLCJleHAiOiIxNzcwMzY3Nzg0IiwiaXNzIjoiV0lERVNFQVdDU19XTVNfT3duZXIiLCJhdWQiOiJXSURFU0VBV0NTX1dNUyIsImh0dHA6Ly9zY2hlbWFzLm1pY3Jvc29mdC5jb20vd3MvMjAwOC8wNi9pZGVudGl0eS9jbGFpbXMvcm9sZSI6IjEiLCJodHRwOi8vc2NoZW1hcy54bWxzb2FwLm9yZy93cy8yMDA1LzA1L2lkZW50aXR5L2NsYWltcy9uYW1lIjoiYWRtaW4iLCJUZW5hbnRJZCI6IjAifQ.UemHEUq2MPZGfsaZX9gtLa81ozPJSNrMI4xMqax-syo","userName":"§~¡{tXT","img":""},"devMessage":null}', NULL, N'http://127.0.0.1:9291/api/User/login', N'127.0.0.1', N'', NULL) 
INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4664, CAST(N'2026-02-06T14:50:30.950' AS DateTime), 741, CAST(N'2026-02-06T14:50:31.693' AS DateTime), N'{"QueryString":"","BodyData":"[\"taskType\",\"taskState\"]"}', N'[{"dicNo":"deviceType","config":"","data":[{"key":"CommonConveyorLine","value":"¿~"},{"key":"OtherDevice","value":"OtherDevice"},{"key":"ShuttleCar","value":"zhf"},{"key":"CommonStackerCrane","value":"XW:g"},{"key":"SpeStackerCrane","value":"XW:g2"}],"saveCache":true},{"dicNo":"devicePlcType","config":"","data":[{"key":"AllenBrandlyEtherNetCommunicator","value":"WKQæ\(AB)EtherNet/IP(CIP)"},{"key":"InovanceTcp","value":"GlÝ]Tcp"},{"key":"ModbusTcp","value":"ModbusTcp"},{"key":"OmronEtherNetCommunicator","value":"'kÆYEtherNet/IP(CIP)"},{"key":"SiemensS7","value":"èP[S7"}],"saveCache":true},{"dicNo":"jobAssembly","config":"","data":[{"key":"WIDESEAWCS_Tasks","value":"WIDESEAWCS_Tasks"}],"saveCache":true},{"dicNo":"jobClassName","config":"","data":[{"key":"LogJob","value":"LogJob"},{"key":"CommonStackerCraneJob","value":"CommonStackerCraneJob"}],"saveCache":true},{"dicNo":"deviceStatus","config":"","data":[{"key":"0","value":"y(u"},{"key":"1","value":"/T(u"}],"saveCache":true},{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true},{"dicNo":"inOutType","config":"","data":[{"key":"1","value":"eQ^ï1u"},{"key":"2","value":"úQ^ï1u"}],"saveCache":true}]', NULL, N'http://127.0.0.1:9291/api/Sys_Dictionary/GetVueDictionary', N'127.0.0.1', N'admin', NULL) 
INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4665, CAST(N'2026-02-06T14:51:23.897' AS DateTime), 38, CAST(N'2026-02-06T14:51:23.933' AS DateTime), N'{"QueryString":"","BodyData":"[\"taskType\",\"taskState\"]"}', N'[{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true},{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true}]', NULL, N'http://127.0.0.1:9291/api/Sys_Dictionary/GetVueDictionary', N'127.0.0.1', N'admin', NULL) 
INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4666, CAST(N'2026-02-06T14:52:27.643' AS DateTime), 2, CAST(N'2026-02-06T14:52:27.647' AS DateTime), N'{"QueryString":"","BodyData":"[\"taskType\",\"taskState\"]"}', N'[{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true},{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true}]', NULL, N'http://127.0.0.1:9291/api/Sys_Dictionary/GetVueDictionary', N'127.0.0.1', N'admin', NULL) 
INSERT [dbo].[Sys_Log] ([Id], [BeginDate], [ElapsedTime], [EndDate], [RequestParam], [ResponseParam], [Success], [Url], [UserIP], [UserName], [User_Id]) VALUES (4667, CAST(N'2026-02-06T14:52:30.373' AS DateTime), 2, CAST(N'2026-02-06T14:52:30.377' AS DateTime), N'{"QueryString":"","BodyData":"[\"taskType\",\"taskState\"]"}', N'[{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true},{"dicNo":"taskType","config":"","data":[{"key":"200","value":"eQ^"},{"key":"100","value":"úQ^"}],"saveCache":true},{"dicNo":"taskState","config":"","data":[{"key":"200","value":"°eú^eQ^ûN¡R"},{"key":"210","value":"XW:geQ^gbL-N"},{"key":"290","value":"eQ^ûN¡R[b"},{"key":"298","value":"eQ^ûN¡Rcw"},{"key":"299","value":"eQ^ûN¡RÖSm"},{"key":"100","value":"°eú^úQ^ûN¡R"},{"key":"110","value":"XW:gúQ^gbL-N"},{"key":"190","value":"úQ^ûN¡R[b"},{"key":"198","value":"úQ^ûN¡Rcw"},{"key":"199","value":"úQ^ûN¡RÖSm"}],"saveCache":true}]', NULL, N'http://127.0.0.1:9291/api/Sys_Dictionary/GetVueDictionary', N'127.0.0.1', N'admin', NULL) 
SET IDENTITY_INSERT [dbo].[Sys_Log] OFF 
SET IDENTITY_INSERT [dbo].[Sys_Menu] ON  
 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'(u7b¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-user', NULL, 1, N'.', 0, NULL, 4000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:07.567' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2, N'(u7b¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_User', 1, N'/Sys_User', 2000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:14.030' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'CgP¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'ivu-icon ivu-icon-ios-boat', NULL, 1, N',', 1, N'/permission', 1000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:20.727' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (4, N'Òr¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_Role', 1, N'/Sys_Role', 900, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:23.177' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (5, N'û|ß~¾n', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-setting', NULL, 1, N'û|ß~¾n', 0, N'/', 0, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:38.703' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (6, N'ÜUS¾n', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_Menu', 5, N'/sysmenu', 10, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:42.007' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (7, N'NÉbFhÑ~[¾n', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', NULL, NULL, 1, N'Sys_Dictionary', 5, N'/Sys_Dictionary', 10, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (8, N'åe×_¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-date', NULL, 1, N'xxx', 0, N'/', 500, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:30.557' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (9, N'¥cãSåe×_', N'[{"text":"ågâ","value":"Search"}]', NULL, NULL, 0, N'Sys_Log', 8, N'/Sys_Log/Manager', 0, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-12-08T18:33:41.437' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (10, N'¾Y¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-date', NULL, 1, N'', 0, N'/', 8000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:30.557' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (11, N'¾YáOo`', N'[{"text":"ågâ","value":"Search"},{"text":"","value":"Update"}]', N'el-icon-date', NULL, 1, N'Dt_DeviceInfo', 10, N'/deviceInfo', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:20.613' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (12, N'ûN¡R¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-date', NULL, 1, N'', 0, N'/', 7000, 99, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-05-09T15:50:30.557' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (13, N'ûN¡RáOo`', N'[{"text":"ågâ","value":"Search"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"}]', N'el-icon-date', NULL, 1, N'Dt_Task', 12, N'/task', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:54.960' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (14, N'¾YOS®áOo`', N'[{"text":"ågâ","value":"Search"}]', N'el-icon-date', NULL, 1, N'Dt_DeviceProtocol', 10, N'/deviceProtocol', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:39.360' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (15, N'¾YOS®fÆ~áOo`', N'[{"text":"ågâ","value":"Search"}]', N'el-icon-date', NULL, 1, N'Dt_DeviceProtocolDetail', 10, N'/deviceProtocolDetail', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:36.457' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (16, N'¦^ g¡RMnáOo`', N'[{"text":"ågâ","value":"Search"}]', N'el-icon-date', NULL, 1, N'Dt_DispatchInfo', 10, N'/dispatchInfo', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:34:44.470' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (17, N'úW@x¡{t', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"}]', N'el-icon-date', NULL, 0, N'Dt_Router', 0, N'/', 7000, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:36:03.787' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (18, N'ï1uMnáOo`', N'[{"text":"ågâ","value":"Search"},{"text":"°eú^","value":"Add"},{"text":" Rd","value":"Delete"},{"text":"","value":"Update"},{"text":"ü[eQ","value":"Import"},{"text":"ü[úQ","value":"Export"},{"text":"ågwhQèï1u","value":"ViewAllRouter"},{"text":"ï1uMn","value":"AddRouters"}]', N'el-icon-date', NULL, 1, N'Dt_Router', 17, N'/router', 500, NULL, N'admin', CAST(N'2024-10-29T15:21:07.273' AS DateTime), N'admin', CAST(N'2024-11-23T11:35:35.280' AS DateTime)) 
INSERT [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1001, N'åe×_e,g', N'[{"text":"ågâ","value":"Search"}]', N'', NULL, 1, N'txt_log', 8, N'/txt_log', 3, NULL, N'admin', CAST(N'2024-12-08T18:34:10.633' AS DateTime), N'admin', CAST(N'2024-12-08T18:37:08.167' AS DateTime)) 
SET IDENTITY_INSERT [dbo].[Sys_Menu] OFF 
SET IDENTITY_INSERT [dbo].[Sys_Role] ON  
 
INSERT [dbo].[Sys_Role] ([RoleId], [DeptId], [Enable], [ParentId], [RoleName], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, 111, 1, 0, N'§~¡{tXT', N'§~¡{tXT', CAST(N'2024-10-29T15:21:07.510' AS DateTime), N'admin', CAST(N'2024-04-29T13:53:44.717' AS DateTime)) 
SET IDENTITY_INSERT [dbo].[Sys_Role] OFF 
SET IDENTITY_INSERT [dbo].[Sys_RoleAuth] ON  
 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (136, N'Search,Add,Delete,Update,Import,Export', 1, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (137, N'Search,Add,Delete,Update,Import,Export', 2, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-04-29T15:04:07.830' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (138, N'Search,Add,Delete,Update,Import,Export', 3, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (140, N'Search,Add,Delete,Update,Import,Export', 4, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (141, N'Search,Add,Delete,Update,Import,Export', 5, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (143, N'Search,Add,Delete,Update,Import,Export', 6, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (144, N'Search,Add,Delete,Update,Import,Export', 7, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-04-29T15:00:47.033' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (146, N'Search,Add,Delete,Update,Import,Export', 8, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-04-29T15:04:07.830' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (148, N'Search,Add,Delete,Update,Import,Export', 9, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), N'admin', CAST(N'2024-02-22T09:31:16.363' AS DateTime)) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (153, N'Search,Add,Delete,Update,Import,Export', 10, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (154, N'Search,Add,Delete,Update,Import,Export', 12, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (155, N'Search,Add,Delete,Update,Import,Export', 13, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (156, N'Search', 11, 1, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (157, N'Search', 11, 2, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL) 
INSERT [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (158, N'Search,Add,Delete,Update,Import,Export', 10, 2, NULL, N'admin', CAST(N'2024-10-29T15:21:07.753' AS DateTime), NULL, NULL) 
SET IDENTITY_INSERT [dbo].[Sys_RoleAuth] OFF 
SET IDENTITY_INSERT [dbo].[Sys_User] ON  
 
INSERT [dbo].[Sys_User] ([User_Id], [UserName], [Role_Id], [RoleName], [PhoneNo], [Remark], [UserPwd], [UserTrueName], [DeptName], [Dept_Id], [Email], [Enable], [Gender], [HeadImageUrl], [LastModifyPwdDate], [Address], [AuditDate], [AuditStatus], [Auditor], [Token], [TenantId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1, N'admin', 1, N'§~¡{tXT', N'', N'', N'j79rYYvCz4vdhcboB1Ausg==', N'§~¡{tXT', N'', 0, N'', 1, 1, N'', CAST(N'2024-04-16T19:58:55.000' AS DateTime), N'û|ß~ g¡RhV', CAST(N'2024-04-16T00:54:06.000' AS DateTime), 1, N'§~¡{tXT', N'', 0, N'û|ß~', CAST(N'2024-10-29T15:21:08.487' AS DateTime), NULL, NULL) 
SET IDENTITY_INSERT [dbo].[Sys_User] OFF 
ALTER TABLE [dbo].[Dt_DeviceProtocol] ADD  DEFAULT ('1') FOR [DeviceProDataLength] 
GO 
ALTER TABLE [dbo].[Sys_User] ADD  DEFAULT ('0') FOR [TenantId] 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceStatus' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YIP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceIp' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YïzãS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DevicePort' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'PLC{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DevicePlcType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'DeviceRemark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceInfo' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YP[÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceChildCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OS®pencWW' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataBlock' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OPûyÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProOffset' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc¦^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProDataLength' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpe Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpe{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÂSpeôf' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProParamDes' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'DeviceProRemark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocol' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Y{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'DeviceType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®ÂSpe Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'DeviceProParamName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocolDetailType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~ÖS<P' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocalDetailValue' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~ôf' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ProtocolDetailDes' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YOS®fÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DeviceProtocolDetail' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Name' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RRÄ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'JobGroup' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R@b(WDLLù[^vz^Æ Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'AssemblyName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R@b(W{|' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'ClassName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'gbLôöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'IntervalSecond' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_ËYöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'BeginTime' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó~_göeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'EndTime' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RÏcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¦^ g¡RMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_DispatchInfo' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN^ Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'WarehouseName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN^ãNx' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'WarehouseNumber' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÓN^{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'WarehouseInvType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷]S÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'RoadwayNo' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'y(u¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'EnableStatus' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'eQ^ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'InStationCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:geQ^ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'InSCStationCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'úQ^ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'OutStationCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gúQ^ÙzðS÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'OutSCStationCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_roadwayinfo', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'w¹pMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'StartPosi' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'È~¹pMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'NextPosi' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ï1u{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'InOutType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P[MOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ChildPosi' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'P[MOn@b^\¾Y' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ChildPosiDeviceCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'L' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmRow' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmColumn' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XW:gÖS'/>e'B\' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'SrmLayer' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ñm¦^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Depth' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/fgÈ~¹p' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'IsEnd' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾Yï1uMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Router' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskNum' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'PalletCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷]S÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Roadway' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TaskState' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'wËY0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'SourceAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îvh0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'TargetAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'CurrentAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'NextAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_8^áOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'ExceptionMessage' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OHQ§~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Grade' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'WMSûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'WMSId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RNÑSöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Dispatchertime' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Y(uW[µk' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'PalletCodequantity' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N8nûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'WMStaskid' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YUID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task', @level2type=N'COLUMN',@level2name=N'deviceuuid' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskNum' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØv÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'PalletCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷]S÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Roadway' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TaskState' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'wËY0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'SourceAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îvh0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'TargetAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'CurrentAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'NextAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_8^áOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'ExceptionMessage' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'OHQ§~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Grade' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'WMSûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'WMSId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RNÑSöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Dispatchertime' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N8nûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'WMStaskid' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¾YUID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'deviceuuid' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'XbØvpeÏ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty', @level2type=N'COLUMN',@level2name=N'PalletCodequantity' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RáOo`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_Task_hty' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskDetailId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskNum' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡R¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'TaskState' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'S_MRMOn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'CurrentAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'NN0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'NextAddress' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TºNå]Íd\O' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'IsManual' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&Tck8^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'IsNormal' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ïcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Description' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ûN¡RgbLfÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Dt_TaskExecuteDetail' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~ Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentCode' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'
N§~Ä~Ç~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'ParentId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'DepartmentType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Enable' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ä~Ç~¶gg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Department' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Mny' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Config' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc^ g¡R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DBServer' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'SqlíåS' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DBSql' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQ Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQ÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'DicNo' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Enable' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'OrderNo' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6r§~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'ParentId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'û|ß~{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'SystemType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQpenc' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Dictionary' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQRhID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicListId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnText' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnValue' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicValue' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'pencnID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'DicId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Enable' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'OrderNo' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'W[xQfÆ~' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_DictionaryList' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'_ËYöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'BeginDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'öe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'ElapsedTime' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ó~_göeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'EndDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷BlÂSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'RequestParam' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÍT^ÂSpe' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'ResponseParam' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÍT^¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Success' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'÷Bl0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'Url' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bIP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'UserIP' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'UserName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7b;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Log', @level2type=N'COLUMN',@level2name=N'User_Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUS Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'CgP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Auth' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'þVh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Icon' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Ïcð' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Description' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Enable' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'h T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'TableName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6r§~ID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'ParentId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ï_' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Url' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'c^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'OrderNo' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUS{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'MenuType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSMn' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Menu' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N';N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'RoleId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè;N.' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'DeptId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&T/T(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Enable' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'6rID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ParentId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'RoleName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òrh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Role' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr«ýNÁID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'AuthId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bCgP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'AuthValue' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÜUSID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'MenuId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÒrID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'RoleId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'UserId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr«ýNÁ¡{t' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_RoleAuth' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'TenantType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'penc^{|W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'DbType' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Þ¥cW[&{2N' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'ConnectionString' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Status' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7b' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_Tenant' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'User_Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'^÷S' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ÒrID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Role_Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Òr Tðy' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'RoleName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'5uÝ' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'PhoneNo' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Yèl' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Remark' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Æ[x' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserPwd' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'w[ÓY T' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'UserTrueName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èè' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'DeptName' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'èèID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Dept_Id' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'®±{' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Email' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'/f&TïS(u' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Enable' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N''`+R' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Gender' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'4YÏP' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'HeadImageUrl' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'gTÆ[xîO9eöeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'LastModifyPwdDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'0W@W' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Address' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8höeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'AuditDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8h¶r`' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'AuditStatus' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'¡[8hºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Auditor' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'äNLr' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Token' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'ßy7bID' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'TenantId' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Creater' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'Rú^öeô' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'CreateDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eºN' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'Modifier' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'îO9eåeg' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User', @level2type=N'COLUMN',@level2name=N'ModifyDate' 
GO 
EXEC sys.sp_addextendedproperty @name=N'MS_Description', @value=N'(u7bh' , @level0type=N'SCHEMA',@level0name=N'dbo', @level1type=N'TABLE',@level1name=N'Sys_User' 
GO 
USE [master] 
GO 
ALTER DATABASE [YT_WIDESEA_WCS] SET  READ_WRITE  
GO