/*
 Navicat Premium Data Transfer

 Source Server         : 1
 Source Server Type    : SQL Server
 Source Server Version : 16001000
 Source Host           : Asuna\LIULEI:1433
 Source Catalog        : LP_WIDESEAWCS
 Source Schema         : dbo

 Target Server Type    : SQL Server
 Target Server Version : 16001000
 File Encoding         : 65001

 Date: 07/11/2025 09:00:12
*/


-- ----------------------------
-- Table structure for Dt_DeviceInfo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_DeviceInfo]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_DeviceInfo]
GO

CREATE TABLE [dbo].[Dt_DeviceInfo] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [DeviceCode] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceType] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceStatus] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceIp] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DevicePort] int  NOT NULL,
  [DevicePlcType] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceRemark] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Dt_DeviceInfo] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备编号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'DeviceCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备名称',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'DeviceName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'DeviceType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备状态',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'DeviceStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备IP',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'DeviceIp'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备端口',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'DevicePort'
GO

EXEC sp_addextendedproperty
'MS_Description', N'PLC类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'DevicePlcType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'DeviceRemark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备信息',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceInfo'
GO


-- ----------------------------
-- Records of Dt_DeviceInfo
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] ON
GO

INSERT INTO [dbo].[Dt_DeviceInfo] ([Id], [DeviceCode], [DeviceName], [DeviceType], [DeviceStatus], [DeviceIp], [DevicePort], [DevicePlcType], [DeviceRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1', N'SC01', N'1号堆垛机', N'CommonStackerCrane', N'1', N'127.0.0.1', N'102', N'SiemensS7', N'1', N'1', N'2025-09-17 11:20:24.433', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceInfo] ([Id], [DeviceCode], [DeviceName], [DeviceType], [DeviceStatus], [DeviceIp], [DevicePort], [DevicePlcType], [DeviceRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'3', N'1002', N'输送线', N'CommonConveyorLine', N'1', N'127.0.0.1', N'102', N'SiemensS7', N'1', N'1', N'2025-09-17 11:20:24.433', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Dt_DeviceInfo] OFF
GO


-- ----------------------------
-- Table structure for Dt_DeviceProtocol
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_DeviceProtocol]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_DeviceProtocol]
GO

CREATE TABLE [dbo].[Dt_DeviceProtocol] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [DeviceId] int  NOT NULL,
  [DeviceChildCode] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceProDataBlock] varchar(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceProOffset] decimal(10,1)  NOT NULL,
  [DeviceProDataType] varchar(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceProDataLength] int DEFAULT '1' NOT NULL,
  [DeviceProParamName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceProParamType] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceProParamDes] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DeviceProRemark] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Dt_DeviceProtocol] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备子编号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceChildCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'协议数据块',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceProDataBlock'
GO

EXEC sp_addextendedproperty
'MS_Description', N'偏移量',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceProOffset'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceProDataType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据长度',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceProDataLength'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数名称',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceProParamName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceProParamType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'参数说明',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceProParamDes'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'DeviceProRemark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备协议',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocol'
GO


-- ----------------------------
-- Records of Dt_DeviceProtocol
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] ON
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1', N'1', N'SC01', N'DB41', N'.1', N'bool', N'1', N'Free', N'StackerCraneStatus', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'2', N'1', N'SC01', N'DB41', N'.2', N'bool', N'1', N'Online', N'StackerCraneAutoStatus', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'3', N'1', N'SC01', N'DB41', N'10.0', N'dint', N'1', N'CurrentTaskNum', N'CurrentTaskNum', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'4', N'1', N'SC01', N'DB41', N'6.0', N'byte', N'1', N'StackerCraneWorkStatus', N'StackerCraneWorkStatus', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'5', N'1', N'SC01', N'DB31', N'.0', N'dint', N'1', N'CMD', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'6', N'1', N'SC01', N'DB31', N'2.0', N'int', N'1', N'TaskType', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'7', N'1', N'SC01', N'DB31', N'4.0', N'int', N'1', N'TaskNo', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'8', N'1', N'SC01', N'DB31', N'8.0', N'int', N'1', N'S_Row', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'9', N'1', N'SC01', N'DB31', N'10.0', N'int', N'1', N'S_Bay', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'10', N'1', N'SC01', N'DB31', N'12.0', N'int', N'1', N'S_level', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'11', N'1', N'SC01', N'DB31', N'14.0', N'int', N'1', N'E_Row', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'12', N'1', N'SC01', N'DB31', N'16.0', N'int', N'1', N'E_Bay', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'13', N'1', N'SC01', N'DB31', N'18.0', N'int', N'1', N'E_level', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'14', N'1', N'SC01', N'DB31', N'20.0', N'int', N'1', N'Goods_Type', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'15', N'3', N'1001', N'DB1', N'2000.0', N'int', N'2', N'TaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'16', N'3', N'1001', N'DB1', N'2002.0', N'int', N'2', N'TargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'17', N'3', N'1001', N'DB1', N'2004.0', N'int', N'2', N'RequestTask', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'18', N'3', N'1001', N'DB1', N'2004.1', N'int', N'2', N'ResponState', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'19', N'3', N'102', N'DB80', N'50.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'20', N'3', N'102', N'DB80', N'52.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'21', N'3', N'102', N'DB80', N'80.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'22', N'3', N'102', N'DB80', N'84.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'23', N'3', N'103', N'DB80', N'100.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'24', N'3', N'103', N'DB80', N'102.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'25', N'3', N'103', N'DB80', N'130.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'26', N'3', N'103', N'DB80', N'134.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'27', N'3', N'104', N'DB80', N'150.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'28', N'3', N'104', N'DB80', N'152.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'29', N'3', N'104', N'DB80', N'180.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'30', N'3', N'104', N'DB80', N'184.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'31', N'3', N'105', N'DB80', N'200.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'32', N'3', N'105', N'DB80', N'202.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'33', N'3', N'105', N'DB80', N'230.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'34', N'3', N'105', N'DB80', N'234.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'35', N'3', N'106', N'DB80', N'250.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'36', N'3', N'106', N'DB80', N'252.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'37', N'3', N'106', N'DB80', N'280.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'38', N'3', N'106', N'DB80', N'284.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'39', N'3', N'107', N'DB80', N'300.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'40', N'3', N'107', N'DB80', N'302.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'41', N'3', N'107', N'DB80', N'330.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'42', N'3', N'107', N'DB80', N'334.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'43', N'3', N'108', N'DB80', N'350.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'44', N'3', N'108', N'DB80', N'352.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'45', N'3', N'108', N'DB80', N'380.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'46', N'3', N'108', N'DB80', N'384.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'47', N'3', N'109', N'DB80', N'400.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'48', N'3', N'109', N'DB80', N'402.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'49', N'3', N'109', N'DB80', N'430.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'50', N'3', N'109', N'DB80', N'438.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'51', N'3', N'110', N'DB80', N'450.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'52', N'3', N'110', N'DB80', N'452.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'53', N'3', N'110', N'DB80', N'480.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'54', N'3', N'110', N'DB80', N'484.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'55', N'3', N'111', N'DB80', N'500.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'56', N'3', N'111', N'DB80', N'502.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'57', N'3', N'111', N'DB80', N'530.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'58', N'3', N'111', N'DB80', N'534.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'59', N'3', N'112', N'DB80', N'550.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'60', N'3', N'112', N'DB80', N'552.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'61', N'3', N'112', N'DB80', N'580.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'62', N'3', N'112', N'DB80', N'584.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'63', N'3', N'113', N'DB80', N'600.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'64', N'3', N'113', N'DB80', N'602.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'65', N'3', N'113', N'DB80', N'630.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'66', N'3', N'113', N'DB80', N'634.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'67', N'3', N'114', N'DB80', N'650.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'68', N'3', N'114', N'DB80', N'652.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'69', N'3', N'114', N'DB80', N'680.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'70', N'3', N'114', N'DB80', N'684.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'71', N'3', N'115', N'DB80', N'700.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'72', N'3', N'115', N'DB80', N'702.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'73', N'3', N'115', N'DB80', N'730.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'74', N'3', N'115', N'DB80', N'734.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'75', N'3', N'116', N'DB80', N'750.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'76', N'3', N'116', N'DB80', N'752.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'77', N'3', N'116', N'DB80', N'780.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'78', N'3', N'116', N'DB80', N'784.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'79', N'3', N'117', N'DB80', N'800.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'80', N'3', N'117', N'DB80', N'802.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'81', N'3', N'117', N'DB80', N'830.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'82', N'3', N'117', N'DB80', N'834.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'83', N'3', N'118', N'DB80', N'850.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'84', N'3', N'118', N'DB80', N'852.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'85', N'3', N'118', N'DB80', N'880.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'86', N'3', N'118', N'DB80', N'884.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'87', N'3', N'119', N'DB80', N'900.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'88', N'3', N'119', N'DB80', N'902.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'89', N'3', N'119', N'DB80', N'930.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'90', N'3', N'119', N'DB80', N'934.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'91', N'3', N'120', N'DB80', N'950.0', N'w', N'1', N'InteractiveSignal', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'92', N'3', N'120', N'DB80', N'952.0', N'string', N'25', N'ConveyorLineBarcode', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'93', N'3', N'120', N'DB80', N'980.0', N'dint', N'1', N'ConveyorLineTargetAddress', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'94', N'3', N'120', N'DB80', N'984.0', N'dint', N'1', N'ConveyorLineTaskNum', N'ReadDeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'95', N'3', N'1001', N'DB1', N'2004.2', N'int', N'2', N'RequestPut', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'96', N'3', N'1001', N'DB1', N'2004.3', N'int', N'2', N'PutFinish', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'97', N'3', N'1001', N'DB1', N'2006.0', N'string', N'10', N'Barcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'98', N'3', N'1001', N'DB1', N'2016.0', N'int', N'2', N'Spare', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'99', N'3', N'102', N'DB90', N'50.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'100', N'3', N'102', N'DB90', N'52.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'101', N'3', N'102', N'DB90', N'80.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'102', N'3', N'102', N'DB90', N'84.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'103', N'3', N'103', N'DB90', N'100.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'104', N'3', N'103', N'DB90', N'102.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'105', N'3', N'103', N'DB90', N'130.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'106', N'3', N'103', N'DB90', N'134.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'107', N'3', N'104', N'DB90', N'150.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'108', N'3', N'104', N'DB90', N'152.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'109', N'3', N'104', N'DB90', N'180.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'110', N'3', N'104', N'DB90', N'184.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'111', N'3', N'105', N'DB90', N'200.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'112', N'3', N'105', N'DB90', N'202.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'113', N'3', N'105', N'DB90', N'230.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'114', N'3', N'105', N'DB90', N'234.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'115', N'3', N'106', N'DB90', N'250.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'116', N'3', N'106', N'DB90', N'252.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'117', N'3', N'106', N'DB90', N'280.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'118', N'3', N'106', N'DB90', N'284.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'119', N'3', N'107', N'DB90', N'300.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'120', N'3', N'107', N'DB90', N'302.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'121', N'3', N'107', N'DB90', N'330.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'122', N'3', N'107', N'DB90', N'334.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'123', N'3', N'108', N'DB90', N'350.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'124', N'3', N'108', N'DB90', N'352.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'125', N'3', N'108', N'DB90', N'380.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'126', N'3', N'108', N'DB90', N'384.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'127', N'3', N'109', N'DB90', N'400.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'128', N'3', N'109', N'DB90', N'402.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'129', N'3', N'109', N'DB90', N'430.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'130', N'3', N'109', N'DB90', N'438.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'131', N'3', N'110', N'DB90', N'450.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'132', N'3', N'110', N'DB90', N'452.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'133', N'3', N'110', N'DB90', N'480.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'134', N'3', N'110', N'DB90', N'484.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'135', N'3', N'111', N'DB90', N'500.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'136', N'3', N'111', N'DB90', N'502.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'137', N'3', N'111', N'DB90', N'530.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'138', N'3', N'111', N'DB90', N'534.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'139', N'3', N'112', N'DB90', N'550.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'140', N'3', N'112', N'DB90', N'552.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'141', N'3', N'112', N'DB90', N'580.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'142', N'3', N'112', N'DB90', N'584.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'143', N'3', N'113', N'DB90', N'600.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'144', N'3', N'113', N'DB90', N'602.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'145', N'3', N'113', N'DB90', N'630.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'146', N'3', N'113', N'DB90', N'634.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'147', N'3', N'114', N'DB90', N'650.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'148', N'3', N'114', N'DB90', N'652.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'149', N'3', N'114', N'DB90', N'680.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'150', N'3', N'114', N'DB90', N'684.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'151', N'3', N'115', N'DB90', N'700.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'152', N'3', N'115', N'DB90', N'702.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'153', N'3', N'115', N'DB90', N'730.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'154', N'3', N'115', N'DB90', N'734.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'155', N'3', N'116', N'DB90', N'750.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'156', N'3', N'116', N'DB90', N'752.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'157', N'3', N'116', N'DB90', N'780.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'158', N'3', N'116', N'DB90', N'784.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'159', N'3', N'117', N'DB90', N'800.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'160', N'3', N'117', N'DB90', N'802.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'161', N'3', N'117', N'DB90', N'830.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'162', N'3', N'117', N'DB90', N'834.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'163', N'3', N'118', N'DB90', N'850.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'164', N'3', N'118', N'DB90', N'852.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'165', N'3', N'118', N'DB90', N'880.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'166', N'3', N'118', N'DB90', N'884.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'167', N'3', N'119', N'DB90', N'900.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'168', N'3', N'119', N'DB90', N'902.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'169', N'3', N'119', N'DB90', N'930.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'170', N'3', N'119', N'DB90', N'934.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'171', N'3', N'120', N'DB90', N'950.0', N'w', N'1', N'WriteInteractiveSignal', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'172', N'3', N'120', N'DB90', N'952.0', N'string', N'25', N'WriteConveyorLineBarcode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'173', N'3', N'120', N'DB90', N'980.0', N'dint', N'1', N'WriteConveyorLineTargetAddress', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'174', N'3', N'120', N'DB90', N'984.0', N'dint', N'1', N'WriteConveyorLineTaskNum', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'175', N'3', N'111', N'DB80', N'500.0', N'w', N'1', N'IsOccupied', N'IsOccupied', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1001', N'1', N'SC01', N'DB41', N'.4', N'bool', N'1', N'Alarm', N'StackerCraneStatus', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1002', N'1', N'SC01', N'DB41', N'.5', N'bool', N'1', N'Goods', N'StackerCraneStatus', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1003', N'1', N'SC01', N'DB41', N'2.0', N'bool', N'1', N'Flag', N'StackerCraneStatus', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocol] ([Id], [DeviceId], [DeviceChildCode], [DeviceProDataBlock], [DeviceProOffset], [DeviceProDataType], [DeviceProDataLength], [DeviceProParamName], [DeviceProParamType], [DeviceProParamDes], [DeviceProRemark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'2001', N'1', N'SC01', N'DB31', N'22.0', N'string', N'20', N'TrayCode', N'DeviceCommand', N'1', NULL, N'admin', N'2025-09-17 11:20:25.710', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocol] OFF
GO


-- ----------------------------
-- Table structure for Dt_DeviceProtocolDetail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_DeviceProtocolDetail]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_DeviceProtocolDetail]
GO

CREATE TABLE [dbo].[Dt_DeviceProtocolDetail] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [DeviceType] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeviceProParamName] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ProtocolDetailType] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ProtocalDetailValue] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ProtocolDetailDes] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [Remark] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Dt_DeviceProtocolDetail] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'DeviceType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备协议参数名称',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'DeviceProParamName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备协议明细类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'ProtocolDetailType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备协议明细取值',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'ProtocalDetailValue'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备协议明细说明',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'ProtocolDetailDes'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备协议明细',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DeviceProtocolDetail'
GO


-- ----------------------------
-- Records of Dt_DeviceProtocolDetail
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] ON
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1', N'CommonStackerCrane', N'StackerCraneStatus', N'Normal', N'true', N'设备状态(1:正常)', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'7', N'CommonStackerCrane', N'StackerCraneAutoStatus', N'Automatic', N'true', N'工作模式(3:自动)', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'8', N'CommonStackerCrane', N'StackerCraneWorkStatus', N'Standby', N'0', N'作业状态(0:待机)', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'9', N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PickUp', N'1', N'作业状态(1:取货中)', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'10', N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PickUpCompleted', N'2', N'作业状态(2:取货完成)', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'11', N'CommonStackerCrane', N'StackerCraneWorkStatus', N'Putting', N'4', N'作业状态(4:放货中)', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'12', N'CommonStackerCrane', N'StackerCraneWorkStatus', N'PutCompleted', N'5', N'作业状态(5:放货完成)', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'13', N'CommonStackerCrane', N'StackerCraneWorkStatus', N'WorkCompleted', N'6', N'作业状态(6:任务完成)', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'14', N'CommonConveyorLine', N'1001', N'RequestInbound', N'1', N'1', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'15', N'CommonConveyorLine', N'InteractiveSignal', N'RequestInNextAddress', N'2', N'2', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'32', N'CommonConveyorLine', N'InteractiveSignal', N'ConveyorLineInFinish', N'3', N'3', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'34', N'CommonConveyorLine', N'IsOccupied', N'IsOccupied', N'0', N'0', NULL, N'1', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'35', N'CommonConveyorLine', N'InteractiveSignal', N'RequestOutbound', N'4', N'4', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'36', N'CommonConveyorLine', N'InteractiveSignal', N'RequestOutNextAddress', N'5', N'5', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DeviceProtocolDetail] ([Id], [DeviceType], [DeviceProParamName], [ProtocolDetailType], [ProtocalDetailValue], [ProtocolDetailDes], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'37', N'CommonConveyorLine', N'InteractiveSignal', N'ConveyorLineOutFinish', N'6', N'6', NULL, N'admin', N'2025-09-17 11:20:27.037', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Dt_DeviceProtocolDetail] OFF
GO


-- ----------------------------
-- Table structure for Dt_DispatchInfo
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_DispatchInfo]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_DispatchInfo]
GO

CREATE TABLE [dbo].[Dt_DispatchInfo] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [Name] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [JobGroup] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [AssemblyName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ClassName] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [IntervalSecond] int  NOT NULL,
  [BeginTime] datetime  NULL,
  [EndTime] datetime  NULL,
  [Remark] varchar(1000) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Dt_DispatchInfo] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务名称',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'Name'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务分组',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'JobGroup'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务所在DLL对应的程序集名称',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'AssemblyName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务所在类',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'ClassName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'执行间隔时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'IntervalSecond'
GO

EXEC sp_addextendedproperty
'MS_Description', N'开始时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'BeginTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'结束时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'EndTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务描述',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'调度服务配置',
'SCHEMA', N'dbo',
'TABLE', N'Dt_DispatchInfo'
GO


-- ----------------------------
-- Records of Dt_DispatchInfo
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] ON
GO

INSERT INTO [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1', N'堆垛机', N'CommonStackerCrane', N'WIDESEAWCS_Tasks', N'CommonStackerCraneJob', N'1', NULL, NULL, NULL, N'1', N'2025-09-17 11:20:28.037', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_DispatchInfo] ([Id], [Name], [JobGroup], [AssemblyName], [ClassName], [IntervalSecond], [BeginTime], [EndTime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'3', N'输送线', N'CommonConveyorLine', N'WIDESEAWCS_Tasks', N'CommonConveyorLineJob', N'3', NULL, NULL, NULL, N'1', N'2025-09-17 11:20:28.037', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Dt_DispatchInfo] OFF
GO


-- ----------------------------
-- Table structure for Dt_Router
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_Router]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_Router]
GO

CREATE TABLE [dbo].[Dt_Router] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [StartPosi] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [NextPosi] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [InOutType] bigint  NOT NULL,
  [ChildPosi] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ChildPosiDeviceCode] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [SrmRow] int  NULL,
  [SrmColumn] int  NULL,
  [SrmLayer] int  NULL,
  [Depth] int  NULL,
  [IsEnd] bit  NOT NULL,
  [Remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Dt_Router] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'起点位置',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'StartPosi'
GO

EXEC sp_addextendedproperty
'MS_Description', N'终点位置',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'NextPosi'
GO

EXEC sp_addextendedproperty
'MS_Description', N'路由类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'InOutType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'子位置',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'ChildPosi'
GO

EXEC sp_addextendedproperty
'MS_Description', N'子位置所属设备',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'ChildPosiDeviceCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'堆垛机取货/放货行',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'SrmRow'
GO

EXEC sp_addextendedproperty
'MS_Description', N'堆垛机取货/放货列',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'SrmColumn'
GO

EXEC sp_addextendedproperty
'MS_Description', N'堆垛机取货/放货层',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'SrmLayer'
GO

EXEC sp_addextendedproperty
'MS_Description', N'深度',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'Depth'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否是最终点',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'IsEnd'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备路由配置',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Router'
GO


-- ----------------------------
-- Records of Dt_Router
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_Router] ON
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'42', N'101', N'102', N'1', N'102', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'43', N'102', N'103', N'1', N'103', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'44', N'103', N'104', N'1', N'104', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'45', N'104', N'105', N'1', N'105', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'46', N'105', N'106', N'1', N'106', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'47', N'106', N'107', N'1', N'107', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'48', N'107', N'108', N'1', N'108', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'49', N'108', N'109', N'1', N'109', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'50', N'109', N'110', N'1', N'110', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'51', N'110', N'SC01', N'1', N'SC01', N'1002', N'1', N'100', N'1', N'1', N'1', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'52', N'SC01', N'111', N'2', N'111', N'1002', N'2', N'100', N'1', N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'53', N'111', N'112', N'2', N'112', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'54', N'112', N'113', N'2', N'113', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'55', N'113', N'114', N'2', N'114', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'56', N'114', N'115', N'2', N'115', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'57', N'115', N'116', N'2', N'116', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'58', N'116', N'117', N'2', N'117', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'59', N'117', N'118', N'2', N'118', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'60', N'118', N'119', N'2', N'119', N'1002', NULL, NULL, NULL, N'1', N'0', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'61', N'119', N'CLOutAreaA', N'2', N'120', N'1002', NULL, NULL, NULL, N'1', N'1', NULL, N'admin', N'2025-09-17 11:20:29.280', NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Router] ([Id], [StartPosi], [NextPosi], [InOutType], [ChildPosi], [ChildPosiDeviceCode], [SrmRow], [SrmColumn], [SrmLayer], [Depth], [IsEnd], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1042', N'SC01', N'1001', N'2', N'1001', N'1002', N'1', N'100', N'1', N'1', N'1', NULL, N'admin', N'2025-10-19 16:04:29.757', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Dt_Router] OFF
GO


-- ----------------------------
-- Table structure for Dt_StationManager
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_StationManager]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_StationManager]
GO

CREATE TABLE [dbo].[Dt_StationManager] (
  [stationID] int  IDENTITY(1,1) NOT NULL,
  [stationType] int  NOT NULL,
  [stationPLC] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Roadway] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [stationRemark] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [stationChildCode] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [stationArea] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [stationLocation] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL,
  [stationNGChildCode] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [stationNGLocation] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [stationStatus] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[Dt_StationManager] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationID'
GO

EXEC sp_addextendedproperty
'MS_Description', N'站台类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'所属PLC',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationPLC'
GO

EXEC sp_addextendedproperty
'MS_Description', N'巷道号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'Roadway'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationRemark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'线体编号(子设备编号)',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationChildCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'设备区域',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationArea'
GO

EXEC sp_addextendedproperty
'MS_Description', N'坐标地址',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationLocation'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'对应NG口',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationNGChildCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'NG口坐标',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'stationNGLocation'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager',
'COLUMN', N'remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务信息',
'SCHEMA', N'dbo',
'TABLE', N'Dt_StationManager'
GO


-- ----------------------------
-- Records of Dt_StationManager
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_StationManager] ON
GO

INSERT INTO [dbo].[Dt_StationManager] ([stationID], [stationType], [stationPLC], [Roadway], [stationRemark], [stationChildCode], [stationArea], [stationLocation], [Creater], [CreateDate], [Modifier], [ModifyDate], [stationNGChildCode], [stationNGLocation], [remark], [stationStatus]) VALUES (N'1', N'1', N'1002', N'SC1', N'焊装入口', N'1001', N'3', N'1001', N'1', N'2024-11-19 15:38:16.000', N'1', N'2024-11-19 15:38:20.000', NULL, NULL, N'立库上料口', N'1')
GO

INSERT INTO [dbo].[Dt_StationManager] ([stationID], [stationType], [stationPLC], [Roadway], [stationRemark], [stationChildCode], [stationArea], [stationLocation], [Creater], [CreateDate], [Modifier], [ModifyDate], [stationNGChildCode], [stationNGLocation], [remark], [stationStatus]) VALUES (N'2', N'2', N'1003', N'SC1', N'涂装直通口', N'1010', N'3', N'1010', N'1', N'2024-11-19 15:38:16.000', N'1', N'2024-11-19 15:38:20.000', NULL, NULL, N'立库取料口', N'1')
GO

INSERT INTO [dbo].[Dt_StationManager] ([stationID], [stationType], [stationPLC], [Roadway], [stationRemark], [stationChildCode], [stationArea], [stationLocation], [Creater], [CreateDate], [Modifier], [ModifyDate], [stationNGChildCode], [stationNGLocation], [remark], [stationStatus]) VALUES (N'3', N'3', N'1003', N'SC1', N'1巷道入库口', N'2010', N'3', N'002-011-002', N'1', N'2024-11-19 15:38:16.000', N'1', N'2024-11-19 15:38:20.000', NULL, NULL, N'立库放料口', N'1')
GO

SET IDENTITY_INSERT [dbo].[Dt_StationManager] OFF
GO


-- ----------------------------
-- Table structure for Dt_Task
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_Task]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_Task]
GO

CREATE TABLE [dbo].[Dt_Task] (
  [TaskId] int  IDENTITY(1,1) NOT NULL,
  [TaskNum] int  NULL,
  [PalletCode] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Roadway] varchar(10) COLLATE Chinese_PRC_CI_AS  NULL,
  [TaskType] int  NULL,
  [TaskState] int  NULL,
  [SourceAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [TargetAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [CurrentAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [NextAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [ExceptionMessage] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [Grade] int  NULL,
  [WMSId] int  NULL,
  [Dispatchertime] datetime  NULL,
  [Remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL,
  [CarType] varchar(40) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[Dt_Task] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'TaskId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'TaskNum'
GO

EXEC sp_addextendedproperty
'MS_Description', N'托盘编号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'PalletCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'巷道号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'Roadway'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'TaskType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务状态',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'TaskState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'起始地址',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'SourceAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'目标地址',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'TargetAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'当前位置',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'CurrentAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'下一地址',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'NextAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'异常信息',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'ExceptionMessage'
GO

EXEC sp_addextendedproperty
'MS_Description', N'优先级',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'Grade'
GO

EXEC sp_addextendedproperty
'MS_Description', N'WMS任务主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'WMSId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务下发时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'Dispatchertime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务信息',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task'
GO


-- ----------------------------
-- Records of Dt_Task
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_Task] ON
GO

INSERT INTO [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [CarType]) VALUES (N'24053', N'10006', N'Q123456', N'SC01', N'100', N'110', N'001-001-002', N'1001', N'001-001-002', N'1001', NULL, N'2', N'0', NULL, NULL, N'System', N'2025-10-15 17:03:01.697', N'System', N'2025-10-19 16:36:07.617', NULL)
GO

SET IDENTITY_INSERT [dbo].[Dt_Task] OFF
GO


-- ----------------------------
-- Table structure for Dt_Task_Hty
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_Task_Hty]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_Task_Hty]
GO

CREATE TABLE [dbo].[Dt_Task_Hty] (
  [TaskId] int  IDENTITY(1,1) NOT NULL,
  [TaskNum] int  NOT NULL,
  [PalletCode] varchar(50) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Roadway] varchar(10) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TaskType] int  NOT NULL,
  [TaskState] int  NOT NULL,
  [SourceAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TargetAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CurrentAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [NextAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ExceptionMessage] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [Grade] int  NOT NULL,
  [WMSId] int  NOT NULL,
  [Dispatchertime] datetime  NULL,
  [Remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL,
  [task_bak1] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [task_CZInfo] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [CarType] varchar(40) COLLATE Chinese_PRC_CI_AS  NULL,
  [wheels_gkcc] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [WheelsNewOrOld] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [wheels_mttype] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [WheelsLX] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL
)
GO

ALTER TABLE [dbo].[Dt_Task_Hty] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'TaskId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'TaskNum'
GO

EXEC sp_addextendedproperty
'MS_Description', N'托盘编号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'PalletCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'巷道号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'Roadway'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务类型',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'TaskType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务状态',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'TaskState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'起始地址',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'SourceAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'目标地址',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'TargetAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'当前位置',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'CurrentAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'下一地址',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'NextAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'异常信息',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'ExceptionMessage'
GO

EXEC sp_addextendedproperty
'MS_Description', N'优先级',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'Grade'
GO

EXEC sp_addextendedproperty
'MS_Description', N'WMS任务主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'WMSId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务下发时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'Dispatchertime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务历史信息',
'SCHEMA', N'dbo',
'TABLE', N'Dt_Task_Hty'
GO


-- ----------------------------
-- Records of Dt_Task_Hty
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_Task_Hty] ON
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'1', N'510', N'CS00010', N'SC1', N'206', N'235', N'2009', N'002-006-004', N'1010', N'002-006-004', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 13:48:32.240', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'2', N'511', N'CS0003', N'SC1', N'100', N'125', N'004-003-002', N'2009', N'2010', N'', N'   任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 13:52:21.640', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'3', N'512', N'BFCS001', N'SC1', N'100', N'125', N'002-003-001', N'2009', N'2010', N'', N'   任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 14:06:48.640', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'4', N'513', N'BF', N'SC1', N'206', N'235', N'2009', N'004-009-007', N'1010', N'004-009-007', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 14:28:15.860', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'5', N'514', N'CL0001', N'SC1', N'100', N'125', N'004-009-006', N'2042', N'2015', N'2021', N'   任务完成成功', N'1', N'0', NULL, NULL, N'admin', N'2025-03-26 14:40:20.197', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'6', N'516', N'X00001', N'SC1', N'206', N'235', N'2009', N'002-004-004', N'1010', N'002-004-004', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 15:22:16.863', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'7', N'517', N'CS001', N'SC1', N'100', N'125', N'003-010-001', N'2009', N'2010', N'', N'   任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 15:25:04.787', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'8', N'515', N'BF0009', N'SC1', N'100', N'125', N'002-004-004', N'2042', N'2010', N'2015', N'   任务完成成功', N'1', N'0', NULL, NULL, N'admin', N'2025-03-26 15:29:44.930', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'9', N'519', N'CS001', N'SC1', N'206', N'235', N'2009', N'003-010-001', N'1010', N'003-010-001', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 15:51:30.133', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'10', N'520', N'CS0007', N'SC1', N'100', N'125', N'001-008-001', N'2032', N'2010', N'2015', N'   任务完成成功', N'1', N'0', NULL, NULL, N'admin', N'2025-03-26 16:22:10.663', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'11', N'521', N'CS002', N'SC1', N'100', N'125', N'004-002-002', N'2009', N'2010', N'2009', N'   任务完成成功', N'1', N'0', NULL, NULL, N'admin', N'2025-03-26 16:33:55.013', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'12', N'522', N'CS001', N'SC1', N'100', N'125', N'003-010-001', N'2009', N'2010', N'2009', N'   任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 17:49:25.530', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'13', N'523', N'CS0001', N'SC1', N'206', N'235', N'2009', N'001-008-001', N'1010', N'001-008-001', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 19:08:54.397', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'14', N'524', N'SZ0001', N'SC1', N'206', N'235', N'2009', N'003-010-001', N'1010', N'003-010-001', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 19:13:48.357', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'15', N'525', N'SZ00002', N'SC1', N'206', N'235', N'2009', N'004-002-002', N'1010', N'004-002-002', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 19:18:54.733', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'16', N'526', N'SZ00003', N'SC1', N'206', N'235', N'2009', N'004-009-006', N'1010', N'004-009-006', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-26 19:23:54.897', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'17', N'551', N'X00001', N'SC1', N'100', N'125', N'002-004-004', N'2042', N'2015', N'2021', N'   任务完成成功', N'1', N'0', NULL, NULL, N'admin', N'2025-03-27 11:35:39.057', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'18', N'552', N'CRH400AF', N'SC1', N'206', N'235', N'2009', N'002-004-004', N'1010', N'002-004-004', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-27 11:37:31.407', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

INSERT INTO [dbo].[Dt_Task_Hty] ([TaskId], [TaskNum], [PalletCode], [Roadway], [TaskType], [TaskState], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [ExceptionMessage], [Grade], [WMSId], [Dispatchertime], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate], [task_bak1], [task_CZInfo], [CarType], [wheels_gkcc], [WheelsNewOrOld], [wheels_mttype], [WheelsLX]) VALUES (N'19', N'555', N'NEWWheels', N'SC1', N'206', N'235', N'2009', N'001-007-001', N'1010', N'001-007-001', N'   入库任务完成成功', N'1', N'0', NULL, NULL, N'System', N'2025-03-27 17:25:08.050', NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Dt_Task_Hty] OFF
GO


-- ----------------------------
-- Table structure for Dt_TaskExecuteDetail
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Dt_TaskExecuteDetail]') AND type IN ('U'))
	DROP TABLE [dbo].[Dt_TaskExecuteDetail]
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) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [NextAddress] varchar(20) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [IsManual] bit  NOT NULL,
  [IsNormal] bit  NOT NULL,
  [Description] varchar(max) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Dt_TaskExecuteDetail] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'TaskDetailId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务主键',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'TaskId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务号',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'TaskNum'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务状态',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'TaskState'
GO

EXEC sp_addextendedproperty
'MS_Description', N'当前位置',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'CurrentAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'下一地址',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'NextAddress'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否人工操作',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'IsManual'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否正常',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'IsNormal'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'Description'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'任务执行明细',
'SCHEMA', N'dbo',
'TABLE', N'Dt_TaskExecuteDetail'
GO


-- ----------------------------
-- Records of Dt_TaskExecuteDetail
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Dt_TaskExecuteDetail] ON
GO

INSERT INTO [dbo].[Dt_TaskExecuteDetail] ([TaskDetailId], [TaskId], [TaskNum], [TaskState], [CurrentAddress], [NextAddress], [IsManual], [IsNormal], [Description], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1004', N'24053', N'10006', N'110', N'001-001-002', N'1001', N'0', N'1', N'系统自动流程，任务状态从【100】转到【110】', NULL, N'System', N'2025-10-19 16:36:07.650', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Dt_TaskExecuteDetail] OFF
GO


-- ----------------------------
-- Table structure for Sys_Config
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_Config]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_Config]
GO

CREATE TABLE [dbo].[Sys_Config] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [ConfigKey] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [ConfigValue] text COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Category] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Remark] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [SortCode] int  NULL,
  [Status] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Sys_Config] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'配置键',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'ConfigKey'
GO

EXEC sp_addextendedproperty
'MS_Description', N'配置值',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'ConfigValue'
GO

EXEC sp_addextendedproperty
'MS_Description', N'分类',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'Category'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序码',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'SortCode'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'Status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统配置表',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Config'
GO


-- ----------------------------
-- Records of Sys_Config
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_Config] ON
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1', N'WCSIPAddress', N'http://localhost:8088/api/', N'SYS_IPAddress', N'', N'1', N'1', N'', N'2024-11-04 14:17:00.283', N'', N'2024-11-04 14:17:00.283')
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'2', N'RequestTask', N'/api/Task/RequestTaskAsync', N'SYS_IPAddress', N'', N'1', N'1', N'', N'2024-11-04 14:17:14.733', N'', N'2024-11-04 14:17:14.733')
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'3', N'RequestLocation', N'/api/Task/RequestLocationTaskAsync', N'SYS_IPAddress', N'', N'1', N'1', N'', N'2024-11-04 14:17:14.733', N'', N'2024-11-04 14:17:14.733')
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'4', N'UpdateTask', N'/api/Task/UpdateTaskStatus', N'SYS_IPAddress', N'', N'1', N'1', N'', N'2024-11-04 14:17:14.733', N'', N'2024-11-04 14:17:14.733')
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'5', N'WMSIPBASE', N'http://localhost:5000', N'SYS_IPAddress', N'', N'1', N'1', N'', N'2024-11-04 14:17:14.733', N'', N'2024-11-04 14:17:14.733')
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'6', N'RequestInTask', N'/api/Task/RequestInTask', N'SYS_IPAddress', N'', N'1', N'1', N'', N'2024-11-04 14:17:14.733', N'', N'2024-11-04 14:17:14.733')
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'7', N'CompleteTask', N'/api/Task/CompleteTaskAsync', N'SYS_IPAddress', N'', N'1', N'1', N'', N'2024-11-04 14:17:14.733', N'', N'2024-11-04 14:17:14.733')
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'8', N'UpdateCheckTask', N'/api/Task/UpdateCheckTask', N'SYS_IPAddress', N'更新为测量任务', NULL, NULL, N'systeam', N'2024-11-18 17:07:38.000', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'9', N'TransferCheck', N'/api/Task/TransferCheckAsync', N'SYS_IPAddress', N'移库检测', NULL, NULL, N'systeam', N'2024-11-18 17:07:38.000', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'10', N'RequestWheelsFlow', N'/api/Task/RequestWheelsFlow', N'SYS_IPAddress', N'流向分配', NULL, NULL, N'systeam', N'2024-11-18 17:07:38.000', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Sys_Config] OFF
GO


-- ----------------------------
-- Table structure for Sys_Dictionary
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_Dictionary]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_Dictionary]
GO

CREATE TABLE [dbo].[Sys_Dictionary] (
  [DicId] int  IDENTITY(1,1) NOT NULL,
  [Config] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [DBServer] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DBSql] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [DicName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DicNo] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Enable] tinyint  NULL,
  [OrderNo] int  NULL,
  [ParentId] int  NULL,
  [Remark] varchar(2000) COLLATE Chinese_PRC_CI_AS  NULL,
  [SystemType] int  NOT NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Sys_Dictionary] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'DicId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'配置项',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'Config'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据库服务',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'DBServer'
GO

EXEC sp_addextendedproperty
'MS_Description', N'Sql语句',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'DBSql'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典名称',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'DicName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典编号',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'DicNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否启用',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'Enable'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序号',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'OrderNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父级ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'ParentId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'系统类型',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'SystemType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典数据',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Dictionary'
GO


-- ----------------------------
-- Records of Sys_Dictionary
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_Dictionary] ON
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'3', N'{valueField: ''Enable'',
textField: ''Enable'',
 containField: null,
  handler: null }', N'1', NULL, N'是否值', N'enable', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', N'超级管理员', N'2022-01-03 18:30:18.113')
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'30', N'{valueField: ''Success'',
 textField: ''Success'', 
 containField: null,
 handler: null }
', NULL, NULL, N'响应状态', N'restatus', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', N'测试超级管理员', N'2018-06-12 10:21:48.000')
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'31', N'{valueField: ''LogType'',
 textField: ''LogType'', 
 containField: null,
 handler: null }
', NULL, NULL, N'日志类型', N'log', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', N'超级管理员', N'2022-04-04 13:21:54.927')
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'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'角色列表', N'roles', N'1', N'123', N'0', N'sql语句需要key,value列，界面才能绑定数据源', N'10', N'system', N'2024-09-02 15:11:30.070', N'测试超级管理员', N'2018-07-13 15:03:53.000')
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'35', N'{
 valueField: ''AuditStatus'',
 textField: ''AuditStatus'',
  containField:null 
}', NULL, NULL, N'审核状态', N'audit', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', N'超级管理员', N'2023-05-08 01:05:44.193')
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'49', N'{
 valueField: ''Gender'',
 textField: ''Gender'',
  containField:null 
}', NULL, NULL, N'性别', N'gender', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', N'测试超级管理员', N'2018-07-23 11:10:28.000')
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'50', N'{
 valueField: ''Enable'',
 textField: ''Enable'',
  containField:null 
}', NULL, NULL, N'启用状态', N'status', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'59', N'{
 valueField: ''IsRegregisterPhone'',
 textField: ''IsRegregisterPhone'',
  containField:null 
}', NULL, NULL, N'手机用户', N'isphone', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', N'超级管理员', N'2020-11-20 23:05:48.303')
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'66', NULL, NULL, N'SELECT RoleId AS id,parentId,RoleId AS [Key],RoleName AS [Value] FROM Sys_Role', N'级联角色', N'tree_roles', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', N'超级管理员', N'2020-11-20 23:08:03.217')
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'67', NULL, NULL, NULL, N'nav', N'nav', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'70', NULL, NULL, NULL, N'请求方式', N'请求方式', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'71', NULL, NULL, NULL, N'定时任务状态', N'定时任务状态', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'72', NULL, NULL, N'SELECT DepartmentId AS ''key'',DepartmentId AS ''id'',ParentId AS parentId,DepartmentName as ''value'' FROM Sys_Department', N'组织机构', N'组织机构', N'1', NULL, N'0', NULL, N'10', N'system', N'2024-09-02 15:11:30.070', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'75', NULL, NULL, NULL, N'日志状态', N'LogState', N'1', NULL, N'0', NULL, N'1', N'超级管理员', N'2024-09-02 15:11:30.070', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Sys_Dictionary] OFF
GO


-- ----------------------------
-- Table structure for Sys_DictionaryList
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_DictionaryList]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_DictionaryList]
GO

CREATE TABLE [dbo].[Sys_DictionaryList] (
  [DicListId] int  IDENTITY(1,1) NOT NULL,
  [DicName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DicValue] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [DicId] int  NOT NULL,
  [Enable] tinyint  NULL,
  [OrderNo] int  NULL,
  [Remark] varchar(2000) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Sys_DictionaryList] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典列表ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'DicListId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据源Text',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'DicName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据源Value',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'DicValue'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据源ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'DicId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否可用',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'Enable'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序号',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'OrderNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'字典明细',
'SCHEMA', N'dbo',
'TABLE', N'Sys_DictionaryList'
GO


-- ----------------------------
-- Records of Sys_DictionaryList
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_DictionaryList] ON
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'3', N'否', N'0', N'3', NULL, N'2', NULL, N'admin', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-01-03 18:30:18.113')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'4', N'是', N'1', N'3', NULL, N'1', NULL, N'xxx', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-01-03 18:30:18.113')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'22', N'其他', N'0', N'30', NULL, N'10', NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2019-08-21 16:49:43.000')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'23', N'成功', N'1', N'30', NULL, N'100', NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2019-08-21 16:49:43.000')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'24', N'异常', N'2', N'30', NULL, N'50', NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2019-08-21 16:49:43.000')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'25', N'系统', N'System', N'31', NULL, N'100', NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-04-04 13:21:54.947')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'26', N'登陆', N'Login', N'31', NULL, N'90', NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-04-04 13:21:54.947')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'27', N'新建', N'Add', N'31', NULL, NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-04-04 13:21:54.943')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'28', N'删除', N'Del', N'31', N'1', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-04-04 13:21:54.943')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'29', N'编辑', N'Edit', N'31', N'1', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-04-04 13:21:54.943')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'37', N'待审核', N'0', N'35', N'0', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2023-05-08 01:05:44.193')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'38', N'审核通过', N'1', N'35', NULL, NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2023-05-08 01:05:44.193')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'39', N'审核中', N'2', N'35', N'0', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2023-05-08 01:05:44.193')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'71', N'异常', N'Exception', N'31', N'0', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-04-04 13:21:54.943')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'90', N'男', N'0', N'49', NULL, NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'测试超级管理员', N'2018-07-23 11:10:28.000')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'91', N'女', N'1', N'49', NULL, NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'测试超级管理员', N'2018-07-23 11:10:28.000')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'96', N'未启用', N'0', N'50', N'1', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2019-08-16 18:17:47.000')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'97', N'已启用', N'1', N'50', N'1', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2019-08-16 18:17:47.000')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'98', N'已删除', N'2', N'50', N'1', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2019-08-16 18:17:47.000')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'128', N'是', N'1', N'59', N'0', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2020-11-20 23:05:48.303')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'129', N'否', N'0', N'59', N'1', NULL, NULL, N'测试超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2020-11-20 23:05:48.303')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'144', N'刷新Token', N'ReplaceToeken', N'31', NULL, N'110', NULL, N'超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2022-04-04 13:21:54.937')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'145', N'Info', N'3', N'30', NULL, NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'423', N'是', N'1', N'67', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'424', N'否', N'0', N'67', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'435', N'审核未通过', N'3', N'35', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2023-05-08 01:05:44.193')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'436', N'get', N'get', N'70', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'437', N'post', N'post', N'70', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'438', N'正常', N'0', N'71', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'439', N'暂停', N'1', N'71', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'442', N'驳回', N'4', N'35', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'443', N'禁用', N'DisEnable', N'73', N'1', N'1', NULL, N'超级管理员', N'2024-09-02 15:11:31.613', N'开发', N'2023-07-14 14:17:01.037')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'444', N'启用', N'Enable', N'73', N'1', N'0', NULL, N'超级管理员', N'2024-09-02 15:11:31.613', N'开发', N'2023-07-14 14:17:01.017')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'449', N'信息', N'Info', N'75', N'0', N'1', NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'450', N'成功', N'Sucess', N'75', N'0', N'2', NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'451', N'失败', N'Error', N'75', N'0', N'3', NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'452', N'1', N'1', N'80', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2023-12-12 10:28:05.550')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'453', N'2', N'2', N'80', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2023-12-12 10:28:05.550')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'454', N'3', N'3', N'80', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2023-12-12 10:28:05.550')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'455', N'4', N'4', N'80', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', N'超级管理员', N'2023-12-12 10:28:05.550')
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'456', N'未审核', N'OrderState_Unaudited', N'84', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_DictionaryList] ([DicListId], [DicName], [DicValue], [DicId], [Enable], [OrderNo], [Remark], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'457', N'已审核', N'OrderState_Audited', N'84', N'0', NULL, NULL, N'超级管理员', N'2024-09-02 15:11:31.613', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Sys_DictionaryList] OFF
GO


-- ----------------------------
-- Table structure for Sys_Log
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_Log]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_Log]
GO

CREATE TABLE [dbo].[Sys_Log] (
  [Id] int  IDENTITY(1,1) NOT NULL,
  [BeginDate] datetime  NULL,
  [ElapsedTime] int  NULL,
  [EndDate] datetime  NULL,
  [RequestParam] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [ResponseParam] varchar(max) COLLATE Chinese_PRC_CI_AS  NULL,
  [Success] int  NULL,
  [Url] varchar(2000) COLLATE Chinese_PRC_CI_AS  NULL,
  [UserIP] varchar(20) COLLATE Chinese_PRC_CI_AS  NULL,
  [UserName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [UserId] int  NULL
)
GO

ALTER TABLE [dbo].[Sys_Log] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'开始时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'BeginDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'时长',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'ElapsedTime'
GO

EXEC sp_addextendedproperty
'MS_Description', N'结束时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'EndDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'请求参数',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'RequestParam'
GO

EXEC sp_addextendedproperty
'MS_Description', N'响应参数',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'ResponseParam'
GO

EXEC sp_addextendedproperty
'MS_Description', N'响应状态',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'Success'
GO

EXEC sp_addextendedproperty
'MS_Description', N'请求地址',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'Url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户IP',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'UserIP'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户名称',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'UserName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户主键',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Log',
'COLUMN', N'UserId'
GO


-- ----------------------------
-- Records of Sys_Log
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_Log] ON
GO

SET IDENTITY_INSERT [dbo].[Sys_Log] OFF
GO


-- ----------------------------
-- Table structure for Sys_Menu
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_Menu]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_Menu]
GO

CREATE TABLE [dbo].[Sys_Menu] (
  [MenuId] int  IDENTITY(1,1) NOT NULL,
  [MenuName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [Auth] varchar(2000) COLLATE Chinese_PRC_CI_AS  NULL,
  [Icon] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [Description] varchar(2000) COLLATE Chinese_PRC_CI_AS  NULL,
  [Enable] tinyint  NULL,
  [TableName] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [ParentId] int  NOT NULL,
  [Url] varchar(50) COLLATE Chinese_PRC_CI_AS  NULL,
  [OrderNo] int  NULL,
  [MenuType] int  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Sys_Menu] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'MenuId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单名称',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'MenuName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'权限',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'Auth'
GO

EXEC sp_addextendedproperty
'MS_Description', N'图标',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'Icon'
GO

EXEC sp_addextendedproperty
'MS_Description', N'描述',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'Description'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否启用',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'Enable'
GO

EXEC sp_addextendedproperty
'MS_Description', N'表名',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'TableName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父级ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'ParentId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'路径',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'Url'
GO

EXEC sp_addextendedproperty
'MS_Description', N'排序号',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'OrderNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单类型',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'MenuType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单配置',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Menu'
GO


-- ----------------------------
-- Records of Sys_Menu
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_Menu] ON
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1', N'用户管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-user', NULL, N'1', N'.', N'0', NULL, N'4000', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:07.567')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'2', N'用户管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', NULL, NULL, N'1', N'Sys_User', N'1', N'/Sys_User', N'2000', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:14.030')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'3', N'权限管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'ivu-icon ivu-icon-ios-boat', NULL, N'1', N',', N'1', N'/permission', N'1000', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:20.727')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'4', N'角色管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', NULL, NULL, N'1', N'Sys_Role', N'1', N'/Sys_Role', N'900', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:23.177')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'5', N'系统设置', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-setting', NULL, N'1', N'系统设置', N'0', N'/', N'0', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:38.703')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'6', N'菜单设置', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', NULL, NULL, N'1', N'Sys_Menu', N'5', N'/sysmenu', N'10', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:42.007')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'7', N'下拉框绑定设置', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', NULL, NULL, N'1', N'Sys_Dictionary', N'5', N'/Sys_Dictionary', N'10', N'99', N'admin', N'2024-09-02 15:11:32.987', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'8', N'日志管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'xxx', N'0', N'/', N'500', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'9', N'接口日志', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', NULL, NULL, N'1', N'Sys_Log', N'8', N'/Sys_Log/Manager', N'0', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:34.273')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'10', N'设备管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'', N'0', N'/', N'8000', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'11', N'设备信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'Dt_DeviceInfo', N'10', N'/deviceInfo', N'500', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'12', N'任务管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'', N'0', N'/', N'7000', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'13', N'任务信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"回滚到上一步","value":"Previous"},{"text":"跳转到下一步","value":"Next"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'Dt_Task', N'12', N'/task', N'500', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'14', N'设备协议信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'Dt_DeviceProtocol', N'10', N'/deviceProtocol', N'500', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'15', N'设备协议明细信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'Dt_DeviceProtocolDetail', N'10', N'/deviceProtocolDetail', N'500', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'16', N'调度服务配置信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'Dt_DispatchInfo', N'10', N'/dispatchInfo', N'500', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'17', N'基础管理', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'', N'0', N'/', N'7000', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

INSERT INTO [dbo].[Sys_Menu] ([MenuId], [MenuName], [Auth], [Icon], [Description], [Enable], [TableName], [ParentId], [Url], [OrderNo], [MenuType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'18', N'路由配置信息', N'[{"text":"查询","value":"Search"},{"text":"新建","value":"Add"},{"text":"删除","value":"Delete"},{"text":"编辑","value":"Update"},{"text":"查看全部路由","value":"ViewAllRouter"},{"text":"路由配置","value":"AddRouters"},{"text":"导入","value":"Import"},{"text":"导出","value":"Export"}]', N'el-icon-date', NULL, N'1', N'Dt_Router', N'17', N'/router', N'500', N'99', N'admin', N'2024-09-02 15:11:32.987', N'admin', N'2024-05-09 15:50:30.557')
GO

SET IDENTITY_INSERT [dbo].[Sys_Menu] OFF
GO


-- ----------------------------
-- Table structure for Sys_Role
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_Role]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_Role]
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) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Sys_Role] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'主键',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'RoleId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门主键',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'DeptId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否启用',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'Enable'
GO

EXEC sp_addextendedproperty
'MS_Description', N'父ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'ParentId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'RoleName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色表',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Role'
GO


-- ----------------------------
-- Records of Sys_Role
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_Role] ON
GO

INSERT INTO [dbo].[Sys_Role] ([RoleId], [DeptId], [Enable], [ParentId], [RoleName], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1', N'111', N'1', N'0', N'超级管理员', N'超级管理员', N'2024-09-02 15:11:34.210', N'admin', N'2024-04-29 13:53:44.717')
GO

SET IDENTITY_INSERT [dbo].[Sys_Role] OFF
GO


-- ----------------------------
-- Table structure for Sys_RoleAuth
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_RoleAuth]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_RoleAuth]
GO

CREATE TABLE [dbo].[Sys_RoleAuth] (
  [AuthId] int  IDENTITY(1,1) NOT NULL,
  [AuthValue] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [MenuId] int  NOT NULL,
  [RoleId] int  NULL,
  [UserId] int  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Sys_RoleAuth] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色身份验证ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'AuthId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户权限',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'AuthValue'
GO

EXEC sp_addextendedproperty
'MS_Description', N'菜单ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'MenuId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'RoleId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'UserId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色身份验证管理',
'SCHEMA', N'dbo',
'TABLE', N'Sys_RoleAuth'
GO


-- ----------------------------
-- Records of Sys_RoleAuth
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_RoleAuth] ON
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'136', N'Search,Add,Delete,Update,Import,Export', N'1', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-02-22 09:31:16.363')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'137', N'Search,Add,Delete,Update,Import,Export', N'2', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-04-29 15:04:07.830')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'138', N'Search,Add,Delete,Update,Import,Export', N'3', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-02-22 09:31:16.363')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'140', N'Search,Add,Delete,Update,Import,Export', N'4', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-02-22 09:31:16.363')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'141', N'Search,Add,Delete,Update,Import,Export', N'5', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-02-22 09:31:16.363')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'143', N'Search,Add,Delete,Update,Import,Export', N'6', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-02-22 09:31:16.363')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'144', N'Search,Add,Delete,Update,Import,Export', N'7', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-04-29 15:00:47.033')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'146', N'Search,Add,Delete,Update,Import,Export', N'8', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-04-29 15:04:07.830')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'148', N'Search,Add,Delete,Update,Import,Export', N'9', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2024-02-22 09:31:16.363')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'153', N'Search,Add,Delete,Update,Import,Export', N'10', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'154', N'Search,Add,Delete,Update,Import,Export', N'12', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'155', N'Search,Add,Previous,Next,Delete,Update,Import,Export', N'13', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2025-03-21 14:19:23.120')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'156', N'Search,Add,Delete,Update,Import,Export', N'11', N'1', NULL, N'admin', N'2024-09-02 15:11:35.220', N'admin', N'2025-03-21 14:19:23.120')
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'157', N'Search', N'11', N'2', NULL, N'admin', N'2024-09-02 15:11:35.220', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'158', N'Search,Add,Delete,Update,Import,Export', N'10', N'2', NULL, N'admin', N'2024-09-02 15:11:35.220', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1136', N'Search,Add,Delete,Update,Import,Export', N'17', N'1', NULL, N'admin', N'2025-03-21 14:19:23.200', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1137', N'Search,Add,Delete,Update,ViewAllRouter,AddRouters,Import,Export', N'18', N'1', NULL, N'admin', N'2025-03-21 14:19:23.207', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1138', N'Search,Add,Previous,Next,Delete,Update,Import,Export', N'13', N'1', NULL, N'admin', N'2025-03-21 14:19:23.207', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1139', N'Search,Add,Delete,Update,Import,Export', N'11', N'1', NULL, N'admin', N'2025-03-21 14:19:23.207', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1140', N'Search,Add,Delete,Update,Import,Export', N'14', N'1', NULL, N'admin', N'2025-03-21 14:19:23.207', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1141', N'Search,Add,Delete,Update,Import,Export', N'15', N'1', NULL, N'admin', N'2025-03-21 14:19:23.207', NULL, NULL)
GO

INSERT INTO [dbo].[Sys_RoleAuth] ([AuthId], [AuthValue], [MenuId], [RoleId], [UserId], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (N'1142', N'Search,Add,Delete,Update,Import,Export', N'16', N'1', NULL, N'admin', N'2025-03-21 14:19:23.207', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Sys_RoleAuth] OFF
GO


-- ----------------------------
-- Table structure for Sys_Tenant
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_Tenant]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_Tenant]
GO

CREATE TABLE [dbo].[Sys_Tenant] (
  [TenantId] int  IDENTITY(1,1) NOT NULL,
  [TenantName] varchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [TenantType] int  NOT NULL,
  [DbType] int  NOT NULL,
  [ConnectionString] varchar(1000) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Status] int  NOT NULL,
  [Remark] varchar(2000) COLLATE Chinese_PRC_CI_AS  NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Sys_Tenant] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'租户ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'TenantId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'租户名称',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'TenantName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'租户类型',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'TenantType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'数据库类型',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'DbType'
GO

EXEC sp_addextendedproperty
'MS_Description', N'连接字符串',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'ConnectionString'
GO

EXEC sp_addextendedproperty
'MS_Description', N'状态',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'Status'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'租户',
'SCHEMA', N'dbo',
'TABLE', N'Sys_Tenant'
GO


-- ----------------------------
-- Records of Sys_Tenant
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_Tenant] ON
GO

SET IDENTITY_INSERT [dbo].[Sys_Tenant] OFF
GO


-- ----------------------------
-- Table structure for Sys_User
-- ----------------------------
IF EXISTS (SELECT * FROM sys.all_objects WHERE object_id = OBJECT_ID(N'[dbo].[Sys_User]') AND type IN ('U'))
	DROP TABLE [dbo].[Sys_User]
GO

CREATE TABLE [dbo].[Sys_User] (
  [User_Id] int  IDENTITY(1,1) NOT NULL,
  [UserName] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [Role_Id] int  NOT NULL,
  [RoleName] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [PhoneNo] varchar(11) COLLATE Chinese_PRC_CI_AS  NULL,
  [Remark] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [UserPwd] varchar(200) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [UserTrueName] varchar(100) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [DeptName] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [Dept_Id] int  NULL,
  [Email] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [Enable] tinyint  NOT NULL,
  [Gender] int  NULL,
  [HeadImageUrl] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [LastModifyPwdDate] datetime  NULL,
  [Address] varchar(200) COLLATE Chinese_PRC_CI_AS  NULL,
  [AuditDate] datetime  NULL,
  [AuditStatus] int  NULL,
  [Auditor] varchar(100) COLLATE Chinese_PRC_CI_AS  NULL,
  [Token] varchar(500) COLLATE Chinese_PRC_CI_AS  NULL,
  [TenantId] bigint DEFAULT '0' NOT NULL,
  [Creater] varchar(255) COLLATE Chinese_PRC_CI_AS  NOT NULL,
  [CreateDate] datetime  NOT NULL,
  [Modifier] varchar(255) COLLATE Chinese_PRC_CI_AS  NULL,
  [ModifyDate] datetime  NULL
)
GO

ALTER TABLE [dbo].[Sys_User] SET (LOCK_ESCALATION = TABLE)
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'User_Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'帐号',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'UserName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Role_Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'角色名称',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'RoleName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'电话',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'PhoneNo'
GO

EXEC sp_addextendedproperty
'MS_Description', N'备注',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Remark'
GO

EXEC sp_addextendedproperty
'MS_Description', N'密码',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'UserPwd'
GO

EXEC sp_addextendedproperty
'MS_Description', N'真实姓名',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'UserTrueName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'DeptName'
GO

EXEC sp_addextendedproperty
'MS_Description', N'部门ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Dept_Id'
GO

EXEC sp_addextendedproperty
'MS_Description', N'邮箱',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Email'
GO

EXEC sp_addextendedproperty
'MS_Description', N'是否可用',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Enable'
GO

EXEC sp_addextendedproperty
'MS_Description', N'性别',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Gender'
GO

EXEC sp_addextendedproperty
'MS_Description', N'头像',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'HeadImageUrl'
GO

EXEC sp_addextendedproperty
'MS_Description', N'最后密码修改时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'LastModifyPwdDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'地址',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Address'
GO

EXEC sp_addextendedproperty
'MS_Description', N'审核时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'AuditDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'审核状态',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'AuditStatus'
GO

EXEC sp_addextendedproperty
'MS_Description', N'审核人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Auditor'
GO

EXEC sp_addextendedproperty
'MS_Description', N'令牌',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Token'
GO

EXEC sp_addextendedproperty
'MS_Description', N'租户ID',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'TenantId'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建者',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Creater'
GO

EXEC sp_addextendedproperty
'MS_Description', N'创建时间',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'CreateDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改人',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'Modifier'
GO

EXEC sp_addextendedproperty
'MS_Description', N'修改日期',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User',
'COLUMN', N'ModifyDate'
GO

EXEC sp_addextendedproperty
'MS_Description', N'用户表',
'SCHEMA', N'dbo',
'TABLE', N'Sys_User'
GO


-- ----------------------------
-- Records of Sys_User
-- ----------------------------
SET IDENTITY_INSERT [dbo].[Sys_User] ON
GO

INSERT INTO [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 (N'1', N'admin', N'1', N'超级管理员', N'', N'', N'j79rYYvCz4vdhcboB1Ausg==', N'超级管理员', N'', N'0', N'', N'1', N'1', N'', N'2024-04-16 19:58:55.000', N'系统服务器', N'2024-04-16 00:54:06.000', N'1', N'超级管理员', N'', N'0', N'系统', N'2024-09-02 15:11:38.617', NULL, NULL)
GO

SET IDENTITY_INSERT [dbo].[Sys_User] OFF
GO


-- ----------------------------
-- Auto increment value for Dt_DeviceInfo
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_DeviceInfo]', RESEED, 1000)
GO


-- ----------------------------
-- Primary Key structure for table Dt_DeviceInfo
-- ----------------------------
ALTER TABLE [dbo].[Dt_DeviceInfo] ADD CONSTRAINT [PK_Dt_DeviceInfo_Id] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Dt_DeviceProtocol
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_DeviceProtocol]', RESEED, 3000)
GO


-- ----------------------------
-- Primary Key structure for table Dt_DeviceProtocol
-- ----------------------------
ALTER TABLE [dbo].[Dt_DeviceProtocol] ADD CONSTRAINT [PK_Dt_DeviceProtocol_Id] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Dt_DeviceProtocolDetail
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_DeviceProtocolDetail]', RESEED, 1000)
GO


-- ----------------------------
-- Primary Key structure for table Dt_DeviceProtocolDetail
-- ----------------------------
ALTER TABLE [dbo].[Dt_DeviceProtocolDetail] ADD CONSTRAINT [PK_Dt_DeviceProtocolDetail_Id] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Dt_DispatchInfo
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_DispatchInfo]', RESEED, 1000)
GO


-- ----------------------------
-- Primary Key structure for table Dt_DispatchInfo
-- ----------------------------
ALTER TABLE [dbo].[Dt_DispatchInfo] ADD CONSTRAINT [PK_Dt_DispatchInfo_Id] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Dt_Router
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_Router]', RESEED, 2041)
GO


-- ----------------------------
-- Primary Key structure for table Dt_Router
-- ----------------------------
ALTER TABLE [dbo].[Dt_Router] ADD CONSTRAINT [PK_Dt_Router_Id] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Dt_StationManager
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_StationManager]', RESEED, 1001)
GO


-- ----------------------------
-- Primary Key structure for table Dt_StationManager
-- ----------------------------
ALTER TABLE [dbo].[Dt_StationManager] ADD CONSTRAINT [PK_Dt_StationManager_stationID] PRIMARY KEY CLUSTERED ([stationID])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Dt_Task
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_Task]', RESEED, 25051)
GO


-- ----------------------------
-- Primary Key structure for table Dt_Task
-- ----------------------------
ALTER TABLE [dbo].[Dt_Task] ADD CONSTRAINT [PK_Dt_Task_TaskId] PRIMARY KEY CLUSTERED ([TaskId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Dt_Task_Hty
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_Task_Hty]', RESEED, 19)
GO


-- ----------------------------
-- Primary Key structure for table Dt_Task_Hty
-- ----------------------------
ALTER TABLE [dbo].[Dt_Task_Hty] ADD CONSTRAINT [PK_Dt_Task_Hty_TaskId] PRIMARY KEY CLUSTERED ([TaskId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Dt_TaskExecuteDetail
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Dt_TaskExecuteDetail]', RESEED, 2001)
GO


-- ----------------------------
-- Auto increment value for Sys_Config
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_Config]', RESEED, 1001)
GO


-- ----------------------------
-- Primary Key structure for table Sys_Config
-- ----------------------------
ALTER TABLE [dbo].[Sys_Config] ADD CONSTRAINT [PK_Sys_Config_Id] PRIMARY KEY CLUSTERED ([Id])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Sys_Dictionary
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_Dictionary]', RESEED, 1002)
GO


-- ----------------------------
-- Primary Key structure for table Sys_Dictionary
-- ----------------------------
ALTER TABLE [dbo].[Sys_Dictionary] ADD CONSTRAINT [PK_Sys_Dictionary_DicId] PRIMARY KEY CLUSTERED ([DicId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Sys_DictionaryList
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_DictionaryList]', RESEED, 1002)
GO


-- ----------------------------
-- Auto increment value for Sys_Log
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_Log]', RESEED, 1)
GO


-- ----------------------------
-- Auto increment value for Sys_Menu
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_Menu]', RESEED, 1000)
GO


-- ----------------------------
-- Primary Key structure for table Sys_Menu
-- ----------------------------
ALTER TABLE [dbo].[Sys_Menu] ADD CONSTRAINT [PK_Sys_Menu_MenuId] PRIMARY KEY CLUSTERED ([MenuId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Sys_Role
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_Role]', RESEED, 1000)
GO


-- ----------------------------
-- Primary Key structure for table Sys_Role
-- ----------------------------
ALTER TABLE [dbo].[Sys_Role] ADD CONSTRAINT [PK_Sys_Role_RoleId] PRIMARY KEY CLUSTERED ([RoleId])
WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON)  
ON [PRIMARY]
GO


-- ----------------------------
-- Auto increment value for Sys_RoleAuth
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_RoleAuth]', RESEED, 2135)
GO


-- ----------------------------
-- Auto increment value for Sys_Tenant
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_Tenant]', RESEED, 1)
GO


-- ----------------------------
-- Auto increment value for Sys_User
-- ----------------------------
DBCC CHECKIDENT ('[dbo].[Sys_User]', RESEED, 1000)
GO

