ÿþUSE [WIDESEAWMS_FG] GO /****** Object: Table [dbo].[Dt_AreaInfo] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_AreaInfo]( [AreaID] [int] IDENTITY(1,1) NOT NULL, [AreaCode] [varchar](255) NOT NULL, [AreaName] [varchar](255) NOT NULL, [AreaType] [varchar](255) NULL, [AreaDesc] [varchar](255) NULL, [AreaStatus] [int] NULL, [Spare1] [varchar](255) NULL, [Spare2] [varchar](255) NULL, [Spare3] [varchar](255) NULL, [Spare4] [varchar](255) NULL, [Spare5] [varchar](255) NULL, [Creater] [varchar](255) NULL, [CreateDate] [datetime] NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_AreaInfo_AreaID] PRIMARY KEY CLUSTERED ( [AreaID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_MaterielInfo] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_MaterielInfo]( [MaterielID] [int] IDENTITY(1,1) NOT NULL, [MaterielCode] [varchar](255) NOT NULL, [MaterielName] [varchar](255) NOT NULL, [MaterielDesc] [varchar](255) NULL, [Status] [int] NOT NULL, [MinpackQty] [decimal](18, 4) NULL, [Mfacturer] [varchar](255) NULL, [Netweight] [decimal](18, 4) NULL, [Grossweight] [decimal](18, 4) NULL, [Validity] [int] NULL, [Safety] [decimal](18, 4) NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_MaterielInfo_MaterielID] PRIMARY KEY CLUSTERED ( [MaterielID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_StationManager] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_StationManager]( [stationID] [int] IDENTITY(1,1) NOT NULL, [stationType] [int] NOT NULL, [stationDeviceCode] [varchar](50) NULL, [Roadway] [varchar](100) NULL, [stationChildCode] [varchar](255) NULL, [stationRemark] [varchar](255) NULL, [stationArea] [varchar](20) NULL, [stationLocation] [varchar](20) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, [remark] [varchar](255) NULL, [stationStatus] [varchar](20) NULL, [stationFloor] [varchar](255) NULL, CONSTRAINT [PK_Dt_StationManager_stationID] PRIMARY KEY CLUSTERED ( [stationID] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_Task] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Task]( [TaskId] [int] IDENTITY(1,1) NOT NULL, [TaskNum] [int] NOT NULL, [PalletCode] [varchar](30) NOT NULL, [OrderNo] [varchar](30) NULL, [Roadway] [varchar](30) NULL, [TaskType] [int] NOT NULL, [TaskState] [int] NOT NULL, [MaterialNo] [varchar](30) NULL, [SourceAddress] [varchar](30) NOT NULL, [TargetAddress] [varchar](30) NOT NULL, [CurrentAddress] [varchar](30) NOT NULL, [NextAddress] [varchar](30) NOT NULL, [Grade] [int] NOT NULL, [Dispatchertime] [datetime] NOT NULL, [Remark] [varchar](100) NULL, [ErrorMessage] [varchar](100) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_Task_TaskId] PRIMARY KEY CLUSTERED ( [TaskId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_Task_Hty] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_Task_Hty]( [TaskId] [int] IDENTITY(1,1) NOT NULL, [FinishTime] [datetime] NOT NULL, [OperateType] [int] NOT NULL, [SourceId] [int] NOT NULL, [TaskNum] [int] NOT NULL, [PalletCode] [varchar](30) NOT NULL, [OrderNo] [varchar](30) NULL, [Roadway] [varchar](30) NULL, [TaskType] [int] NOT NULL, [TaskState] [int] NOT NULL, [MaterialNo] [varchar](30) NULL, [SourceAddress] [varchar](30) NOT NULL, [TargetAddress] [varchar](30) NOT NULL, [CurrentAddress] [varchar](30) NOT NULL, [NextAddress] [varchar](30) NOT NULL, [Grade] [int] NOT NULL, [Dispatchertime] [datetime] NOT NULL, [Remark] [varchar](100) NULL, [ErrorMessage] [varchar](100) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_Task_Hty_TaskId] PRIMARY KEY CLUSTERED ( [TaskId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_TaskExecuteDetail] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_TaskExecuteDetail]( [TaskDetailId] [int] IDENTITY(1,1) NOT NULL, [TaskId] [int] NOT NULL, [TaskNum] [int] NOT NULL, [TaskState] [int] NOT NULL, [IsManual] [bit] NOT NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_TaskExecuteDetail_TaskDetailId] PRIMARY KEY CLUSTERED ( [TaskDetailId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Dt_WareAreaInfo] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Dt_WareAreaInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [WareAreaCode] [varchar](255) NOT NULL, [WareAreaName] [varchar](255) NOT NULL, [WareAreaId] [varchar](255) NULL, [Status] [int] NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Dt_WareAreaInfo_WareAreaID] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DtBoxingInfo] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtBoxingInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [PalletCode] [varchar](255) NULL, [LocationCode] [varchar](255) NULL, [IsFullExit] [bit] NULL, [StockStatus] [int] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NULL, [CreateDate] [datetime] NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK__DtStockI__3214EC07CDA31A83] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DtBoxingInfo_Hty] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtBoxingInfo_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [PalletCode] [varchar](255) NULL, [LocationCode] [varchar](255) NULL, [IsFullExit] [bit] NULL, [StockStatus] [int] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NULL, [CreateDate] [datetime] NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK__DtBoxing__3214EC07A10B65FE] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DtBoxingInfoDetail] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtBoxingInfoDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [BoxingInfoId] [int] NOT NULL, [MaterielCode] [varchar](50) NULL, [MaterielName] [varchar](200) NULL, [DemandClassification] [varchar](200) NULL, [WareHouseId] [varchar](255) NULL, [Warehouse] [varchar](200) NULL, [OrderNo] [varchar](50) NULL, [Unit] [varchar](50) NULL, [Specs] [varchar](50) NULL, [Weight] [decimal](10, 4) NULL, [DrawingNumber] [varchar](200) NULL, [Quantity] [decimal](10, 4) NULL, [Status] [int] NULL, [Date] [varchar](200) NULL, [Remark] [varchar](max) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_DtBoxingInfoDetail_Id] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[DtBoxingInfoDetail_Hty] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtBoxingInfoDetail_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [BoxingInfoId] [int] NOT NULL, [MaterielCode] [varchar](50) NULL, [MaterielName] [varchar](200) NULL, [DemandClassification] [varchar](200) NULL, [WareHouseId] [varchar](255) NULL, [Warehouse] [varchar](200) NULL, [OrderNo] [varchar](50) NULL, [Unit] [varchar](50) NULL, [Specs] [varchar](50) NULL, [Weight] [decimal](10, 4) NULL, [DrawingNumber] [varchar](200) NULL, [Quantity] [decimal](10, 4) NULL, [Status] [int] NULL, [Date] [varchar](200) NULL, [Remark] [varchar](max) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK__DtBoxing__3214EC0777AFB174] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[DtLocationInfo] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtLocationInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [AreaId] [int] NULL, [LocationCode] [varchar](20) NULL, [LocationName] [varchar](50) NULL, [RoadwayNo] [varchar](20) NULL, [Floor] [varchar](20) NULL, [Row] [int] NULL, [Column] [int] NULL, [Layer] [int] NULL, [Depth] [int] NULL, [LocationType] [int] NULL, [LocationStatus] [int] NULL, [EnalbeStatus] [int] NULL, [Remark] [varchar](200) NULL, [Creater] [varchar](255) NULL, [CreateDate] [datetime] NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_DtLocationInfo_Id] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DtLocationStatusChangeRecord] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtLocationStatusChangeRecord]( [Id] [int] IDENTITY(1,1) NOT NULL, [LocationId] [int] NOT NULL, [LocationCode] [varchar](20) NULL, [BeforeStatus] [int] NOT NULL, [AfterStatus] [int] NOT NULL, [ChangeType] [int] NOT NULL, [OrderId] [int] NULL, [OrderNo] [varchar](50) NULL, [OrderDetailId] [int] NULL, [TaskNum] [int] NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_DtLocationStatusChangeRecord_Id] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DtStockInfo] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtStockInfo]( [Id] [int] IDENTITY(1,1) NOT NULL, [PalletCode] [varchar](255) NULL, [LocationCode] [varchar](255) NULL, [IsFullExit] [bit] NULL, [StockStatus] [int] NULL, [OrderNo] [varchar](255) NULL, [OrderType] [varchar](255) NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NULL, [CreateDate] [datetime] NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK__DtStockI__3214EC07B7B5AEBD] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DtStockInfo_Hty] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtStockInfo_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [PalletCode] [varchar](255) NULL, [LocationCode] [varchar](255) NULL, [IsFullExit] [bit] NULL, [StockStatus] [int] NULL, [OrderNo] [varchar](255) NULL, [OrderType] [varchar](255) NULL, [Remark] [varchar](255) NULL, [Creater] [varchar](255) NULL, [CreateDate] [datetime] NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK__DtStockI__3214EC0733A0638B] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[DtStockInfoDetail] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtStockInfoDetail]( [Id] [int] IDENTITY(1,1) NOT NULL, [StockId] [int] NOT NULL, [MaterielCode] [varchar](50) NULL, [MaterielName] [varchar](200) NULL, [DemandClassification] [varchar](200) NULL, [WareHouseId] [varchar](255) NULL, [Warehouse] [varchar](200) NULL, [OrderNo] [varchar](50) NULL, [Unit] [varchar](50) NULL, [Specs] [varchar](50) NULL, [Weight] [decimal](10, 4) NULL, [DrawingNumber] [varchar](200) NULL, [Quantity] [decimal](10, 4) NULL, [OutboundQuantity] [decimal](10, 4) NULL, [Status] [int] NULL, [Date] [varchar](200) NULL, [AllocateWarehouse] [varchar](200) NULL, [Remark] [varchar](max) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK__DtBoxing__3214EC07BE13036D] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[DtStockInfoDetail_Hty] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[DtStockInfoDetail_Hty]( [Id] [int] IDENTITY(1,1) NOT NULL, [StockId] [int] NOT NULL, [MaterielCode] [varchar](50) NULL, [MaterielName] [varchar](200) NULL, [DemandClassification] [varchar](200) NULL, [WareHouseId] [varchar](255) NULL, [Warehouse] [varchar](200) NULL, [OrderNo] [varchar](50) NULL, [Unit] [varchar](50) NULL, [Specs] [varchar](50) NULL, [Weight] [decimal](10, 4) NULL, [DrawingNumber] [varchar](200) NULL, [Quantity] [decimal](10, 4) NULL, [OutboundQuantity] [decimal](10, 4) NULL, [Status] [int] NULL, [Date] [varchar](200) NULL, [AllocateWarehouse] [varchar](200) NULL, [Remark] [varchar](max) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK__DtStockI__3214EC0774756A66] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Config] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Config]( [Id] [int] IDENTITY(1,1) NOT NULL, [ConfigKey] [varchar](255) NOT NULL, [ConfigValue] [text] NOT NULL, [Category] [varchar](255) NOT NULL, [Remark] [varchar](255) NULL, [SortCode] [int] NULL, [Status] [varchar](20) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Config_Id] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Department] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Department]( [DepartmentId] [int] IDENTITY(1,1) NOT NULL, [DepartmentName] [varchar](50) NULL, [DepartmentCode] [varchar](50) NULL, [ParentId] [int] NOT NULL, [DepartmentType] [varchar](50) NULL, [Enable] [int] NOT NULL, [Remark] [varchar](2000) NULL, [CreateID] [int] NOT NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [ModifyID] [int] NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Department_DepartmentId] PRIMARY KEY CLUSTERED ( [DepartmentId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Dictionary] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Dictionary]( [DicId] [int] IDENTITY(1,1) NOT NULL, [Config] [varchar](200) NULL, [DBServer] [varchar](50) NULL, [DBSql] [varchar](500) NULL, [DicName] [varchar](50) NULL, [DicNo] [varchar](50) NULL, [Enable] [tinyint] NULL, [OrderNo] [int] NULL, [ParentId] [int] NULL, [Remark] [varchar](2000) NULL, [SystemType] [int] NOT NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Dictionary_DicId] PRIMARY KEY CLUSTERED ( [DicId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_DictionaryList] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_DictionaryList]( [DicListId] [int] IDENTITY(1,1) NOT NULL, [DicName] [varchar](50) NULL, [DicValue] [varchar](50) NULL, [DicId] [int] NOT NULL, [Enable] [tinyint] NULL, [OrderNo] [int] NULL, [Remark] [varchar](2000) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_DictionaryList_DicListId] PRIMARY KEY CLUSTERED ( [DicListId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Log] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Log]( [Id] [int] IDENTITY(1,1) NOT FOR REPLICATION NOT NULL, [BeginDate] [datetime] NULL, [ElapsedTime] [int] NULL, [EndDate] [datetime] NULL, [RequestParam] [varchar](max) NULL, [ResponseParam] [varchar](max) NULL, [Success] [int] NULL, [Url] [varchar](max) NULL, [UserIP] [varchar](200) NULL, [UserName] [varchar](200) NULL, [User_Id] [int] NULL, PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] TEXTIMAGE_ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Menu] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Menu]( [MenuId] [int] IDENTITY(1,1) NOT NULL, [MenuName] [varchar](50) NULL, [Auth] [varchar](2000) NULL, [Icon] [varchar](200) NULL, [Description] [varchar](2000) NULL, [Enable] [tinyint] NULL, [TableName] [varchar](50) NULL, [ParentId] [int] NOT NULL, [Url] [varchar](50) NULL, [OrderNo] [int] NULL, [MenuType] [int] NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Menu_MenuId] PRIMARY KEY CLUSTERED ( [MenuId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Role] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Role]( [RoleId] [int] IDENTITY(1,1) NOT NULL, [DeptId] [int] NULL, [Enable] [tinyint] NOT NULL, [ParentId] [int] NOT NULL, [RoleName] [varchar](50) NOT NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Role_RoleId] PRIMARY KEY CLUSTERED ( [RoleId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_RoleAuth] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_RoleAuth]( [AuthId] [int] IDENTITY(1,1) NOT NULL, [AuthValue] [varchar](500) NULL, [MenuId] [int] NOT NULL, [RoleId] [int] NULL, [UserId] [int] NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_RoleAuth_AuthId] PRIMARY KEY CLUSTERED ( [AuthId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Tenant] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Tenant]( [TenantId] [int] IDENTITY(1,1) NOT NULL, [TenantName] [varchar](200) NOT NULL, [TenantType] [int] NOT NULL, [DbType] [int] NOT NULL, [ConnectionString] [varchar](1000) NOT NULL, [Status] [int] NOT NULL, [Remark] [varchar](2000) NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Tenant_TenantId] PRIMARY KEY CLUSTERED ( [TenantId] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_Test] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_Test]( [Id] [int] IDENTITY(1,1) NOT NULL, [TestContent] [varchar](50) NOT NULL, [TestCount] [int] NOT NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_Test_Id] PRIMARY KEY CLUSTERED ( [Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO /****** Object: Table [dbo].[Sys_User] Script Date: 2026/4/2 13:23:32 ******/ SET ANSI_NULLS ON GO SET QUOTED_IDENTIFIER ON GO CREATE TABLE [dbo].[Sys_User]( [User_Id] [int] IDENTITY(1,1) NOT NULL, [UserName] [varchar](100) NOT NULL, [Role_Id] [int] NOT NULL, [RoleName] [varchar](100) NULL, [PhoneNo] [varchar](11) NULL, [Remark] [varchar](200) NULL, [UserPwd] [varchar](200) NOT NULL, [UserTrueName] [varchar](100) NOT NULL, [DeptName] [varchar](100) NULL, [Dept_Id] [int] NULL, [Email] [varchar](100) NULL, [Enable] [tinyint] NOT NULL, [Gender] [int] NULL, [HeadImageUrl] [varchar](500) NULL, [LastModifyPwdDate] [datetime] NULL, [Address] [varchar](200) NULL, [AuditDate] [datetime] NULL, [AuditStatus] [int] NULL, [Auditor] [varchar](100) NULL, [Token] [varchar](500) NULL, [SystemType] [int] NOT NULL, [TenantId] [bigint] NOT NULL, [Creater] [varchar](255) NOT NULL, [CreateDate] [datetime] NOT NULL, [Modifier] [varchar](255) NULL, [ModifyDate] [datetime] NULL, CONSTRAINT [PK_Sys_User_User_Id] PRIMARY KEY CLUSTERED ( [User_Id] ASC )WITH (PAD_INDEX = OFF, STATISTICS_NORECOMPUTE = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS = ON, ALLOW_PAGE_LOCKS = ON, OPTIMIZE_FOR_SEQUENTIAL_KEY = OFF) ON [PRIMARY] ) ON [PRIMARY] GO SET IDENTITY_INSERT [dbo].[Dt_Task] ON INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [OrderNo], [Roadway], [TaskType], [TaskState], [MaterialNo], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [Grade], [Dispatchertime], [Remark], [ErrorMessage], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1365, 628, N'M1129125040-345', NULL, N'AGV', 300, 325, N'', N'CK-2-2', N'CK-1-1', N'CK-2-2', N'CK-1-1', 2, CAST(N'2025-11-29T12:50:40.397' AS DateTime), N'2', NULL, N'System', CAST(N'2025-11-29T12:50:40.417' AS DateTime), NULL, CAST(N'2025-11-29T12:51:01.833' AS DateTime)) INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [OrderNo], [Roadway], [TaskType], [TaskState], [MaterialNo], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [Grade], [Dispatchertime], [Remark], [ErrorMessage], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1366, 629, N'2025111000001', NULL, N'AGV', 200, 525, N'', N'CK-1-1', N'B4-1-5', N'TSJ-2', N'B4-1-5', 1, CAST(N'2025-11-29T13:03:11.763' AS DateTime), NULL, NULL, N'System', CAST(N'2025-11-29T13:03:12.210' AS DateTime), NULL, CAST(N'2025-11-29T13:07:16.820' AS DateTime)) INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [OrderNo], [Roadway], [TaskType], [TaskState], [MaterialNo], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [Grade], [Dispatchertime], [Remark], [ErrorMessage], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1367, 630, N'2025111000012', NULL, N'AGV', 200, 525, N'', N'CK-2-1', N'B4-2-5', N'TSJ-2', N'B4-2-5', 1, CAST(N'2025-11-29T13:03:34.577' AS DateTime), NULL, NULL, N'System', CAST(N'2025-11-29T13:03:34.630' AS DateTime), NULL, CAST(N'2025-11-29T13:07:51.390' AS DateTime)) INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [OrderNo], [Roadway], [TaskType], [TaskState], [MaterialNo], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [Grade], [Dispatchertime], [Remark], [ErrorMessage], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1368, 631, N'2025111000011', NULL, N'AGV', 100, 510, NULL, N'B5-9-7', N'N|iAGVúQ“^X[:S', N'B5-9-7', N'TSJ-2', 7, CAST(N'2025-11-29T16:50:48.360' AS DateTime), N'6', NULL, N'admin', CAST(N'2025-11-29T16:50:48.473' AS DateTime), NULL, CAST(N'2025-11-29T16:51:12.983' AS DateTime)) INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [OrderNo], [Roadway], [TaskType], [TaskState], [MaterialNo], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [Grade], [Dispatchertime], [Remark], [ErrorMessage], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1370, 631, N'20251110000111', NULL, N'AGV', 100, 510, NULL, N'B5-9-7', N'N|iAGVúQ“^X[:S', N'B5-9-7', N'TSJ-2', 7, CAST(N'2025-11-29T16:50:48.360' AS DateTime), N'6', NULL, N'admin', CAST(N'2025-11-29T16:50:48.473' AS DateTime), NULL, CAST(N'2025-11-29T16:51:12.983' AS DateTime)) INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [OrderNo], [Roadway], [TaskType], [TaskState], [MaterialNo], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [Grade], [Dispatchertime], [Remark], [ErrorMessage], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1371, 631, N'20251112000011', NULL, N'AGV', 100, 510, NULL, N'B5-9-7', N'N|iAGVúQ“^X[:S', N'B5-9-7', N'TSJ-2', 7, CAST(N'2025-11-29T16:50:48.360' AS DateTime), N'6', NULL, N'admin', CAST(N'2025-11-29T16:50:48.473' AS DateTime), NULL, CAST(N'2025-11-29T16:51:12.983' AS DateTime)) INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [OrderNo], [Roadway], [TaskType], [TaskState], [MaterialNo], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [Grade], [Dispatchertime], [Remark], [ErrorMessage], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1372, 631, N'20251211000011', NULL, N'AGV', 100, 510, NULL, N'B5-9-7', N'N|iAGVúQ“^X[:S', N'B5-9-7', N'TSJ-2', 7, CAST(N'2025-11-29T16:50:48.360' AS DateTime), N'6', NULL, N'admin', CAST(N'2025-11-29T16:50:48.473' AS DateTime), NULL, CAST(N'2025-11-29T16:51:12.983' AS DateTime)) INSERT [dbo].[Dt_Task] ([TaskId], [TaskNum], [PalletCode], [OrderNo], [Roadway], [TaskType], [TaskState], [MaterialNo], [SourceAddress], [TargetAddress], [CurrentAddress], [NextAddress], [Grade], [Dispatchertime], [Remark], [ErrorMessage], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (1373, 631, N'202511102300011', NULL, N'AGV', 100, 510, NULL, N'B5-9-7', N'N|iAGVúQ“^X[:S', N'B5-9-7', N'TSJ-2', 7, CAST(N'2025-11-29T16:50:48.360' AS DateTime), N'6', NULL, N'admin', CAST(N'2025-11-29T16:50:48.473' AS DateTime), NULL, CAST(N'2025-11-29T16:51:12.983' AS DateTime)) SET IDENTITY_INSERT [dbo].[Dt_Task] OFF GO SET IDENTITY_INSERT [dbo].[Sys_Config] ON INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2011, N'WCSIPAddress', N'http://127.0.0.1:9291', N'SYS_IPAddress', N'', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:00.283' AS DateTime), N'', CAST(N'2024-11-04T14:17:00.283' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2012, N'CompleteTask', N'/api/Task/CompleteTask', N'SYS_IPAddress', N'', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2013, N'ReceiveTask', N'/api/Task/ReceiveTask', N'SYS_IPAddress', N'', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:14.733' AS DateTime), N'', CAST(N'2024-11-04T14:17:14.733' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2015, N'ERPIPAddress', N'http://192.168.117.109/U9', N'SYS_IPAddress', N'', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:00.283' AS DateTime), N'', CAST(N'2024-11-04T14:17:00.283' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2017, N'MaterialRequisition', N'/RestServices/UFIDA.U9.Cust.MH.IssueSV.ICreateIssueSV.svc/Do', N'SYS_IPAddress', N'u§N†˜™e', NULL, NULL, N'admin', CAST(N'2025-10-16T13:34:53.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2018, N'MixedSend', N'/RestServices/UFIDA.U9.Cust.MH.MiscShipSV.ICreateMiscShipSV.svc/Do', N'SYS_IPAddress', N'BgÑS', NULL, NULL, N'admin', CAST(N'2025-10-16T13:34:53.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2019, N'MixedReceive', N'/RestServices/UFIDA.U9.Cust.MH.MiscRcvTransSV.ICreateMiscRcvSV.svc/Do', N'SYS_IPAddress', N'Bg6e', NULL, NULL, N'admin', CAST(N'2025-10-16T13:34:53.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2020, N'ReturnMaterials', N'/RestServices/UFIDA.U9.Cust.MH.RecedeIssueSV.ICreateRecedeIssueSV.svc/Do', N'SYS_IPAddress', N'u§N™e', NULL, NULL, N'admin', CAST(N'2025-10-16T13:34:53.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2021, N'Allocate', N'/RestServices/UFIDA.U9.Cust.MH.TransferInSV.ICreateTransferInSV.svc/Do', N'SYS_IPAddress', N'Œèb', NULL, NULL, N'admin', CAST(N'2025-10-16T13:34:53.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2022, N'PrintIPAddress', N'http://10.31.3.22:8098', N'SYS_IPAddress', N'http://10.31.3.22:8098', NULL, NULL, N'admin', CAST(N'2024-11-04T14:17:00.283' AS DateTime), N'', CAST(N'2024-11-04T14:17:00.283' AS DateTime)) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2023, N'PrintInboundOrder', N'/Print/PrintInboundOrder', N'SYS_IPAddress', N'eQ“^USncSbpS', NULL, NULL, N'admin', CAST(N'2025-10-16T13:34:53.000' AS DateTime), NULL, NULL) INSERT [dbo].[Sys_Config] ([Id], [ConfigKey], [ConfigValue], [Category], [Remark], [SortCode], [Status], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (2026, N'PrintPalletCodes', N'/Print/PrintPalletCode', N'SYS_IPAddress', N'XbØv÷SSbpS', NULL, NULL, N'admin', CAST(N'2025-10-16T13:34:53.000' AS DateTime), NULL, NULL) SET IDENTITY_INSERT [dbo].[Sys_Config] OFF GO SET IDENTITY_INSERT [dbo].[Sys_Department] ON INSERT [dbo].[Sys_Department] ([DepartmentId], [DepartmentName], [DepartmentCode], [ParentId], [DepartmentType], [Enable], [Remark], [CreateID], [Creater], [CreateDate], [ModifyID], [Modifier], [ModifyDate]) VALUES (4, N'Ym_lRè', N'002', 1, NULL, 1, NULL, 1, N'…§~¡{tXT', CAST(N'2023-07-27T10:10:41.000' AS DateTime), 1, N'…§~¡{tXT', CAST(N'2023-07-27T10:17:00.000' AS DateTime)) SET IDENTITY_INSERT [dbo].[Sys_Department] OFF GO SET IDENTITY_INSERT [dbo].[Sys_Dictionary] ON INSERT [dbo].[Sys_Dictionary] ([DicId], [Config], [DBServer], [DBSql], [DicName], [DicNo], [Enable], [OrderNo], [ParentId], [Remark], [SystemType], [Creater], [CreateDate], [Modifier], [ModifyDate]) VALUES (3, N'{valueField: ''Enable'', textField: ''Enable'', containField: null, handler: null }', N'1', NULL, N'/f&T