SQLite format 3 @ % % .fê û û ¨ K
|
ÛQùRJ $W-QindexSymbolDefinition_DefiningFileId_IndexSymbolDefinitionCREATE INDEX [SymbolDefinition_DefiningFileId_Index]
|
ON [SymbolDefinition] ([DefiningFileId]) C-GindexSymbolDefinition_Name_IndexSymbolDefinitionCREATE INDEX [SymbolDefinition_Name_Index]
|
ON [SymbolDefinition] ([Name] COLLATE NOCASE)
= ---tableSymbolDefinitionSymbolDefinition CREATE TABLE [SymbolDefinition]
|
(
|
[SymbolDefinitionId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL
|
REFERENCES [ProviderEntity]([ProviderId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[FullyQualifiedName] NVARCHAR(255) COLLATE NOCASE,
|
[Kind] INTEGER NOT NULL,
|
[Accessibility] INTEGER NOT NULL,
|
[DefiningFileId] INTEGER NOT NULL
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[LocationRow] INTEGER NOT NULL,
|
[LocationColumn] INTEGER NOT NULL
|
)/ _-_indexFileScannerCache_FileSystemEntityId_IndexFileScannerCache CREATE INDEX [FileScannerCache_FileSystemEntityId_Index]
|
ON [FileScannerCache]([FileSystemEntityId])U
|
--]tableFileScannerCacheFileScannerCache CREATE TABLE [FileScannerCache]
|
(
|
[FileScannerCacheId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[FileSystemEntityId] INTEGER NOT NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
|
ON DELETE CASCADE,
|
[Type] INTEGER NOT NULL,
|
[Timestamp] DATETIME NULL
|
)- /)indexProviderType_TypeProviderEntity
|
CREATE UNIQUE INDEX [ProviderType_Type]
|
ON [ProviderEntity] ([ProviderType] COLLATE NOCASE,[ProviderVersion] COLLATE NOCASE) ));tableProviderEntityProviderEntity CREATE TABLE [ProviderEntity]
|
(
|
[ProviderId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderType] NVARCHAR(20) NOT NULL COLLATE NOCASE,
|
[ProviderVersion] NVARCHAR(20) NOT NULL COLLATE NOCASE
|
):E-indexFileSystemEntity_Parent_NameFileSystemEntityCREATE UNIQUE INDEX [FileSystemEntity_Parent_Name]
|
ON [FileSystemEntity] ([Name] COLLATE NOCASE, [ParentFileSystemEntityId])Bk-yindexFileSystemEntity_ParentFileSystemEntityId_IndexFileSystemEntityCREATE INDEX [FileSystemEntity_ParentFileSystemEntityId_Index]
|
ON [FileSystemEntity] ([ParentFileSystemEntityId])C-GindexFileSystemEntity_Name_IndexFileSystemEntityCREATE INDEX [FileSystemEntity_Name_Index]
|
ON [FileSystemEntity] ([Name] COLLATE NOCASE)H--CtableFileSystemEntityFileSystemEntityCREATE TABLE [FileSystemEntity]
|
(
|
[FileSystemEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[ParentFileSystemEntityId] INTEGER NULL
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[IsFile] BIT NOT NULL,
|
[LastObserved] DATETIME NOT NULL DEFAULT current_timestamp
|
)o1 indexSetting_Name_IndexSettingCREATE INDEX [Setting_Name_Index]
|
ON [Setting] ([Name] COLLATE NOCASE)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)GetableSettingSettingCREATE TABLE [Setting]
|
(
|
[SettingId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[Value] NVARCHAR(255) NU
|
Ç èÇ ;LastIndexSymbolScanners3eec062c-1463-4780-a3cd-e651e09576e3-3f204174-4693-4e54-8361-bb99c2a95280-4b32c687-281c-4c6d-a2a1-3d874bfa2d4d-7b3bd5d3-8362-427d-89a4-742f2e2256c2-c62867cc-67a8-49c6-a9d0-2bef369d8bf7-d9212c5d-975a-49e6-a753-2f586bfbf077-dfc75919-8da2-4b4c-bd45-165d2bcf6f61 'SchemaVersion1.3.5 ª } Òê¿} -FileScannerCache-SymbolDefinitionðß FileScannerCache) ProviderEntity Setting FileSy-FileSystemEntity
|
Ó Óï ;LastIndexSymbolScanners' SchemaVersion ` íѽyQ2ÿà̪` ) TaskService.cs ÞBÁk1!) AWIDESEAWCS_TaskInfoService ÞBÁk!tg /WIDESEAWCS_Server ÞBÁk!tg WCSÞBÁk!tg
|
) ConfigConst.cs ÞB£mæâ ConstÞB£mxÎ %WIDESEA_CoreÞB£mxÎ ) TaskService.csÞB¤DÝ¡& ;WIDESEA_TaskInfoServiceÞB¤3bÝ /WIDESEA_WMSServerÞB£mxÎ /WIDESEA_WMSServerÞB£mxÎ WMSÞB£mxÎ % 项ç®ä»£ç ÞBÁk!tg .vsÞBi®ù
|
ùWj
OtÊ´9àè )TaskService.cs AWIDESEAWCS_TaskInfoService /WIDESEAWCS_Server WCS )ConfigConst.cs
|
Const %WIDESEA_Core)TaskService.cs;WIDESEA_TaskInfoService/WIDESEA_WMSServer/WIDESEA_WMSServerWMS%项ç®ä»£ç .vs
|
¯ ü÷ñÁëåßÓÙÍÇ»µ¯
|
|
í øEZyí;fĬ#Üæ )TaskService.cs AWIDESEAWCS_TaskInfoService /WIDESEAWCS_Server WCS )ConfigConst.cs
|
Const %WIDESEA_Core)TaskService.cs ;WIDESEA_TaskInfoService/WIDESEA_WMSServer/WIDESEA_WMSServer WMS% 项ç®ä»£ç .vs É É 5 U'7b3bd5d3-8362-427d-89a4-742f2e2256c217.14.4.40987
|
Ê Ê 5U' 7b3bd5d3-8362-427d-89a4-742f2e2256c217.14.4.40987 Ê îÜÊ ÞBÁliX¿
|
ÞB£mk* ÞB¤d(§
|
ï ûõï
|
ô úôêDåw&ÙÁ?ç3 Î k Á F æ O
|
»
|
j
|
Ê a £0Í-Û7ë«OC R
|
)w_routerServiceWIDESEAWCS_TaskInfoService.TaskService._routerService+)>
|
#Y TaskServiceWIDESEAWCS_TaskInfoService.TaskService)B
|
AAWIDESEAWCS_TaskInfoServiceWIDESEAWCS_TaskInfoService ' NZ
|
+o MESmockCompleteWIDESEA_Core.Const.SysConfigConst.MESmockComplete
|
5 JY
|
'k MEScancelTaskWIDESEA_Core.Const.SysConfigConst.MEScancelTask
|
/ NX
|
+o MESTaskFeedbackWIDESEA_Core.Const.SysConfigConst.MESTaskFeedback
|
' kW G MESTransferCompletionFeedbackWIDESEA_Core.Const.SysConfigConst.MESTransferCompletionFeedback
|
% \V
|
9} WCSManualTaskCompletedWIDESEA_Core.Const.SysConfigConst.WCSManualTaskCompleted
|
TU
|
1u WCSCancelinventoryWIDESEA_Core.Const.SysConfigConst.WCSCancelinventory
|
LT
|
)m WCSReceiveTaskWIDESEA_Core.Const.SysConfigConst.WCSReceiveTask
|
<S
|
)O SysConfigConstWIDESEA_Core.Const.SysConfigConst
|
WR
|
5w CONFIG_MES_IPAddressWIDESEA_Core.Const.CateGoryConst.CONFIG_MES_IPAddress
|
WQ
|
5w CONFIG_WCS_IPAddressWIDESEA_Core.Const.CateGoryConst.CONFIG_WCS_IPAddress
|
:P
|
'M CateGoryConstWIDESEA_Core.Const.CateGoryConst
|
2O
|
11WIDESEA_Core.ConstWIDESEA_Core.Const
|
Y
|
3{ ManualTaskCompletedWIDESEA_TaskInfoService.TaskService.ManualTaskCompleted t#=
|
_ chukuWIDESEA_TaskInfoService.TaskService.chuku "#I
|
#k GetLastPartWIDESEA_TaskInfoService.TaskService.GetLastPart O
|
)q deleteLocationWIDESEA_TaskInfoService.TaskService.deleteLocation $O~
|
)q updateLocationWIDESEA_TaskInfoService.TaskService.updateLocation è$O}
|
)q createLocationWIDESEA_TaskInfoService.TaskService.createLocation Ã$Q|
|
+s CancelinventoryWIDESEA_TaskInfoService.TaskService.Cancelinventory .#I{
|
#k MESresponseWIDESEA_TaskInfoService.TaskService.MESresponse $`z 9 TaskCompletionFeedbackWIDESEA_TaskInfoService.TaskService.TaskCompletionFeedback Þ#py I MES_TransferCompletionFeedbackWIDESEA_TaskInfoService.TaskService.MES_TransferCompletionFeedback #]x
|
7 OutboundTaskCompletedWIDESEA_TaskInfoService.TaskService.OutboundTaskCompleted a#[w
|
5} InboundTaskCompletedWIDESEA_TaskInfoService.TaskService.InboundTaskCompleted (#fv ? RelocationInTaskCompletedWIDESEA_TaskInfoService.TaskService.RelocationInTaskCompleted ø#Mu
|
'o TaskCompletedWIDESEA_TaskInfoService.TaskService.TaskCompleted á#Mt
|
'o IsRelocationsWIDESEA_TaskInfoService.TaskService.IsRelocations #Ns
|
)q PushTasksToWCSWIDESEA_TaskInfoService.TaskService.PushTasksToWCS ^#Fr
|
!i GetTaskNumWIDESEA_TaskInfoService.TaskService.GetTaskNum UHq
|
#k TaskServiceWIDESEA_TaskInfoService.TaskService.TaskService HKp
|
%m_taskOrderByWIDESEA_TaskInfoService.TaskService._taskOrderByB1Fo
|
!i RepositoryWIDESEA_TaskInfoService.TaskService.Repository @%]n
|
7_stationMangerServiceWIDESEA_TaskInfoService.TaskService._stationMangerService>0xm Q_locationStatusChangeRecordServiceWIDESEA_TaskInfoService.TaskService._locationStatusChangeRecordService==Wl
|
1y_dt_ApiInfoServiceWIDESEA_TaskInfoService.TaskService._dt_ApiInfoService<-Mk
|
'o_basicServiceWIDESEA_TaskInfoService.TaskService._basicService;(`j 9_roadwayInforepositoryWIDESEA_TaskInfoService.TaskService._roadwayInforepository:6bi ;_locationInfoRepositoryWIDESEA_TaskInfoService.TaskService._locationInfoRepository97[h
|
5}_warehouseRepositoryWIDESEA_TaskInfoService.TaskService._warehouseRepository84Sg
|
-u_stockRepositoryWIDESEA_TaskInfoService.TaskService._stockRepository74Uf
|
/w_unitOfWorkManageWIDESEA_TaskInfoService.TaskService._unitOfWorkManage6,Ae
|
c_mapperWIDESEA_TaskInfoService.TaskService._mapper5";d
|
#S TaskServiceWIDESEA_TaskInfoService.TaskService3<c
|
;;WIDESEA_TaskInfoServiceWIDESEA_TaskInf T q
|
c« 2aòÅ 5E ` Ï B× ° µ ® w~Ç H Ð ê d S&!mt / â ) µ < QÜ(õY Å à
|
(
|
s U 6 óY
|
j;Ç
|
|
C: «¦ ¼Z
|
W Æ
|
ç
|
ý
|
ÐÒ¤ ã
|
~Ä x´A } äÈ
|
|
µ Û t« ¨ ã ô 9WCSManualTaskCompletedð)AddTaskHistoryï1WCSCancelinventoryî =QueryStackerCraneYKTasksí+GetOutTaskInfo2ì)GetOutTaskInfoë ?RequestWMSTaskMovelibraryê#IQueryStationIsOccupiedOutTasksé-UpdateTaskIninfoè'GetTaskIninfoç =RollbackTaskStatusToLastæ1TaskStatusRecoveryå3NotifyTaskCompletedä7ProcessRelocationTaskã1ProcessInboundTaskâ3ProcessOutboundTaská1UpdateTaskBaseInfoà7ProcessTaskCompletionß"GIsTaskStateValidForCompletionÞ ;StackCraneTaskCompletedÝ)UpdatePositionÜ9UpdateTaskStatusToNextÛ9UpdateTaskStatusToNextÚ-UpdateTaskStatusÙ AUpdateTaskExceptionMessageØ ?QueryStackerCraneOutTasks× =QueryStackerCraneOutTaskÖ ;QueryStackerCraneInTaskÕ7QueryStackerCraneTaskÔ5RequestWMSTaskSimpleÓ7QuertStackerCraneTaskÒ#IQueryCompletedConveyorLineTaskÑ#IQueryExecutingConveyorLineTaskÐ7QueryConveyorLineTaskÏ)RequestWMSTaskÎ'TaskCompletedÍ)ReceiveWMSTaskÌ#TaskServiceË!RepositoryÊ-urlTaskCompletedÉ7urlWMSMovelibraryTaskÈ/TaskOutboundTypesÇ-TaskInboundTypesÆ#TaskOrderByÅ%_taskOrderByÄ+_taskHtyServiceà _mapper =_stationMangerRepositoryÁ/_routerRepositoryÀ/_unitOfWorkManage¿!E_taskExecuteDetailRepository¾ ?_taskExecuteDetailService½)_routerService¼#TaskService» AWIDESEAWCS_TaskInfoServiceº+MESmockComplete Ú'MEScancelTask Ù+MESTaskFeedback Ø"GMESTransferCompletionFeedback ×9WCSManualTaskCompleted Ö1WCSCancelinventory Õ)WCSReceiveTask Ô)SysConfigConst Ó5CONFIG_MES_IPAddress Ò5CONFIG_WCS_IPAddress Ñ'CateGoryConst Ð1WIDESEA_Core.Const Ï3ManualTaskCompleted
|
chuku#GetLastPart)deleteLocation)updateLocation~)createLocation}+Cancelinventory|#MESresponse{9TaskCompletionFeedbackz#IMES_TransferCompletionFeedbacky7OutboundTaskCompletedx5InboundTaskCompletedw ?RelocationInTaskCompletedv'TaskCompletedu'IsRelocationst)PushTasksToWCSs!GetTaskNumr#TaskServiceq%_taskOrderByp!Repositoryo7_stationMangerServicen'Q_locationStatusChangeRecordServicem1_dt_ApiInfoServicel'_basicServicek9_roadwayInforepositoryj ;_locationInfoRepositoryi5_warehouseRepositoryh-_stockRepositoryg/_unitOfWorkManagef _mappere#TaskServiced ;WIDESEA_TaskInfoServicec
|
c K ùòëäÝÖÏÈÁº³¬¥{tmf_XQJC<5.' ýöïèáÚÓÌž·°©¢xqjc\UNG@92+$ ú ó ì å Þ × Ð É Â » ´ ¦ | u n g ` Y R K ðïîíìëêéèçæåäãâáàßÞÝÜÛÚÙØ×ÖÕÔÓÒÑÐÏÎÍÌËÊÉÈÇÆÅÄÃÂÁÀ¿¾½¼»º
|
Ú
|
Ù
|
Ø
|
×
|
Ö
|
Õ
|
Ô
|
Ó
|
Ò
|
Ñ
|
Ð
|
Ï~}|{zyxwvutsrqponmlkjihgfedc
|
6äs ¨ K
|
ÛQùRJ ±W-QindexSymbolDefinition_DefiningFileId_IndexSymbolDefinitionCREATE INDEX [SymbolDefinition_DefiningFileId_Index]
|
ON [SymbolDefinition] ([DefiningFileId]) C-GindexSymbolDefinition_Name_IndexSymbolDefinitionCREATE INDEX [SymbolDefinition_Name_Index]
|
ON [SymbolDefinition] ([Name] COLLATE NOCASE)
= ---tableSymbolDefinitionSymbolDefinition CREATE TABLE [SymbolDefinition]
|
(
|
[SymbolDefinitionId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL
|
REFERENCES [ProviderEntity]([ProviderId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[FullyQualifiedName] NVARCHAR(255) COLLATE NOCASE,
|
[Kind] INTEGER NOT NULL,
|
[Accessibility] INTEGER NOT NULL,
|
[DefiningFileId] INTEGER NOT NULL
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[LocationRow] INTEGER NOT NULL,
|
[LocationColumn] INTEGER NOT NULL
|
)/ _-_indexFileScannerCache_FileSystemEntityId_IndexFileScannerCache CREATE INDEX [FileScannerCache_FileSystemEntityId_Index]
|
ON [FileScannerCache]([FileSystemEntityId])U
|
--]tableFileScannerCacheFileScannerCache CREATE TABLE [FileScannerCache]
|
(
|
[FileScannerCacheId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[FileSystemEntityId] INTEGER NOT NULL REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
|
ON DELETE CASCADE,
|
[Type] INTEGER NOT NULL,
|
[Timestamp] DATETIME NULL
|
)- /)indexProviderType_TypeProviderEntity
|
CREATE UNIQUE INDEX [ProviderType_Type]
|
ON [ProviderEntity] ([ProviderType] COLLATE NOCASE,[ProviderVersion] COLLATE NOCASE) ));tableProviderEntityProviderEntity CREATE TABLE [ProviderEntity]
|
(
|
[ProviderId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderType] NVARCHAR(20) NOT NULL COLLATE NOCASE,
|
[ProviderVersion] NVARCHAR(20) NOT NULL COLLATE NOCASE
|
):E-indexFileSystemEntity_Parent_NameFileSystemEntityCREATE UNIQUE INDEX [FileSystemEntity_Parent_Name]
|
ON [FileSystemEntity] ([Name] COLLATE NOCASE, [ParentFileSystemEntityId])Bk-yindexFileSystemEntity_ParentFileSystemEntityId_IndexFileSystemEntityCREATE INDEX [FileSystemEntity_ParentFileSystemEntityId_Index]
|
ON [FileSystemEntity] ([ParentFileSystemEntityId])C-GindexFileSystemEntity_Name_IndexFileSystemEntityCREATE INDEX [FileSystemEntity_Name_Index]
|
ON [FileSystemEntity] ([Name] COLLATE NOCASE)H--CtableFileSystemEntityFileSystemEntityCREATE TABLE [FileSystemEntity]
|
(
|
[FileSystemEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[ParentFileSystemEntityId] INTEGER NULL
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[IsFile] BIT NOT NULL,
|
[LastObserved] DATETIME NOT NULL DEFAULT current_timestamp
|
)o1 indexSetting_Name_IndexSettingCREATE INDEX [Setting_Name_Index]
|
ON [Setting] ([Name] COLLATE NOCASE)P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)GetableSettingSettingCREATE TABLE [Setting]
|
(
|
[SettingId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[Value] NVARCHAR(255) NULL
|
)
|
N ö O2}ÈM¢ --aviewFullPathEntitiesFullPathEntitiesCREATE VIEW FullPathEntities as
|
WITH RECURSIVE FullPathEntities AS(
|
SELECT FileSystemEntityId AS BaseSystemEntityId, ParentFileSystemEntityId AS CurrentParentEntityId, Name AS CurrentPath FROM FileSystemEntity
|
UNION ALL
|
SELECT
|
FS.FileSystemEntityId,
|
FS.ParentFileSystemEntityId AS CurrentParentEntityId,
|
FS.Name || '\' || P.CurrentPath AS CurrentPath
|
FROM FullPathEntities AS P
|
INNER JOIN FileSystemEntity AS FS ON
|
FS.FileSystemEntityId = P.CurrentParentEntityId
|
)
|
SELECT FS.*,P.CurrentPath As FullPath
|
FROM FullPathEntities AS P
|
INNER JOIN FileSystemEntity AS FS ON FS.FileSystemEntityId = P.BaseSystemEntityId
|
WHERE CurrentParentEntityId IS NULL([)YindexFileSystemData_FileSystemEntityId_IndexFileSystemDataCREATE INDEX [FileSystemData_FileSystemEntityId_Index]
|
ON [FileSystemData] ([FileSystemEntityId])x))+tableFileSystemDataFileSystemDataCREATE TABLE [FileSystemData]
|
(
|
[FileSystemDataId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[FileSystemEntityId] INTEGER NOT NULL
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ProviderId] INTEGER NOT NULL REFERENCES [ProviderEntity]([ProviderId])
|
ON DELETE CASCADE,
|
[Type] NVARCHAR(20) NOT NULL COLLATE NOCASE,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[Value] TEXT NULL,
|
[Target] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Context] NVARCHAR(255) NULL COLLATE NOCASE
|
)2_3_indexFileSystemReference_ReferenceFileId_IndexFileSystemReferenceCREATE INDEX [FileSystemReference_ReferenceFileId_Index]
|
ON [FileSystemReference]([ReferenceFileId])2_3_indexFileSystemReference_DependantFileId_IndexFileSystemReferenceCREATE INDEX [FileSystemReference_DependantFileId_Index]
|
ON [FileSystemReference]([DependantFileId])33[tableFileSystemReferenceFileSystemReferenceCREATE TABLE [FileSystemReference]
|
(
|
[FileSystemReferenceEntityId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL
|
REFERENCES [ProviderEntity]([ProviderId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[DependantFileId] INTEGER NOT NULL
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ReferenceFileId] INTEGER NULL
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[ReferenceFilePath] TEXT NULL COLLATE NOCASE,
|
[Target] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Context] NVARCHAR(255) NULL COLLATE NOCASE,
|
[Type] INTEGER NULL
|
)$W-QindexSymbolDefinition_DefiningFileId_IndexSymbolDefinitionCREATE INDEX [SymbolDefinition_DefiningFileId_Index]
|
ON [SymbolDefinition] ([DefiningFileId]) C-GindexSymbolDefinition_Name_IndexSymbolDefinitionCREATE INDEX [SymbolDefinition_Name_Index]
|
ON [SymbolDefinition] ([Name] COLLATE NOCASE)
= ---tableSymbolDefinitionSymbolDefinition CREATE TABLE [SymbolDefinition]
|
(
|
[SymbolDefinitionId] INTEGER PRIMARY KEY AUTOINCREMENT NOT NULL,
|
[ProviderId] INTEGER NOT NULL
|
REFERENCES [ProviderEntity]([ProviderId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[Name] NVARCHAR(255) NOT NULL COLLATE NOCASE,
|
[FullyQualifiedName] NVARCHAR(255) COLLATE NOCASE,
|
[Kind] INTEGER NOT NULL,
|
[Accessibility] INTEGER NOT NULL,
|
[DefiningFileId] INTEGER NOT NULL
|
REFERENCES [FileSystemEntity]([FileSystemEntityId])
|
ON UPDATE CASCADE
|
ON DELETE CASCADE,
|
[LocationRow] INTEGER NOT NULL,
|
[LocationColumn] INTEGER NOT NULL
|
)/ _-_indexFileScannerCache_FileSystemEntityId_IndexFileScannerCache CREATE INDEX [FileScannerCache_FileSystemEntityId_Index]
|
ON [FileScannerCache]([FileSystemEntityId])
|
|
|
O Ý)êDåw&ÙÁ?ç3 Î k Á F æ O
|
»
|
j
|
Ê a £0Í-Û7ë«O Û )w_routerServiceWIDESEAWCS_TaskInfoService.TaskService._routerService+) #Y TaskServiceWIDESEAWCS_TaskInfoService.TaskService) E AAWIDESEAWCS_TaskInfoServiceWIDESEAWCS_TaskInfoService ' NZ
|
+o MESmockCompleteWIDESEA_Core.Const.SysConfigConst.MESmockComplete
|
5 JY
|
'k MEScancelTaskWIDESEA_Core.Const.SysConfigConst.MEScancelTask
|
/ NX
|
+o MESTaskFeedbackWIDESEA_Core.Const.SysConfigConst.MESTaskFeedback
|
' kW G MESTransferCompletionFeedbackWIDESEA_Core.Const.SysConfigConst.MESTransferCompletionFeedback
|
% \V
|
9} WCSManualTaskCompletedWIDESEA_Core.Const.SysConfigConst.WCSManualTaskCompleted
|
TU
|
1u WCSCancelinventoryWIDESEA_Core.Const.SysConfigConst.WCSCancelinventory
|
LT
|
)m WCSReceiveTaskWIDESEA_Core.Const.SysConfigConst.WCSReceiveTask
|
<S
|
)O SysConfigConstWIDESEA_Core.Const.SysConfigConst
|
WR
|
5w CONFIG_MES_IPAddressWIDESEA_Core.Const.CateGoryConst.CONFIG_MES_IPAddress
|
WQ
|
5w CONFIG_WCS_IPAddressWIDESEA_Core.Const.CateGoryConst.CONFIG_WCS_IPAddress
|
:P
|
'M CateGoryConstWIDESEA_Core.Const.CateGoryConst
|
2O
|
11WIDESEA_Core.ConstWIDESEA_Core.Const
|
µ 3{ ManualTaskCompletedWIDESEA_TaskInfoService.TaskService.ManualTaskCompleted t#=
|
_ chukuWIDESEA_TaskInfoService.TaskService.chuku "#I
|
#k GetLastPartWIDESEA_TaskInfoService.TaskService.GetLastPart O
|
)q deleteLocationWIDESEA_TaskInfoService.TaskService.deleteLocation $O~
|
)q updateLocationWIDESEA_TaskInfoService.TaskService.updateLocation è$O}
|
)q createLocationWIDESEA_TaskInfoService.TaskService.createLocation Ã$Q|
|
+s CancelinventoryWIDESEA_TaskInfoService.TaskService.Cancelinventory .#I{
|
#k MESresponseWIDESEA_TaskInfoService.TaskService.MESresponse $`z 9 TaskCompletionFeedbackWIDESEA_TaskInfoService.TaskService.TaskCompletionFeedback Þ#py I MES_TransferCompletionFeedbackWIDESEA_TaskInfoService.TaskService.MES_TransferCompletionFeedback #]x
|
7 OutboundTaskCompletedWIDESEA_TaskInfoService.TaskService.OutboundTaskCompleted a#[w
|
5} InboundTaskCompletedWIDESEA_TaskInfoService.TaskService.InboundTaskCompleted (#fv ? RelocationInTaskCompletedWIDESEA_TaskInfoService.TaskService.RelocationInTaskCompleted ø#Mu
|
'o TaskCompletedWIDESEA_TaskInfoService.TaskService.TaskCompleted á#Mt
|
'o IsRelocationsWIDESEA_TaskInfoService.TaskService.IsRelocations #Ns
|
)q PushTasksToWCSWIDESEA_TaskInfoService.TaskService.PushTasksToWCS ^#Fr
|
!i GetTaskNumWIDESEA_TaskInfoService.TaskService.GetTaskNum UHq
|
#k TaskServiceWIDESEA_TaskInfoService.TaskService.TaskService HKp
|
%m_taskOrderByWIDESEA_TaskInfoService.TaskService._taskOrderByB1Fo
|
!i RepositoryWIDESEA_TaskInfoService.TaskService.Repository @%]n
|
7_stationMangerServiceWIDESEA_TaskInfoService.TaskService._stationMangerService>0xm Q_locationStatusChangeRecordServiceWIDESEA_TaskInfoService.TaskService._locationStatusChangeRecordService==Wl
|
1y_dt_ApiInfoServiceWIDESEA_TaskInfoService.TaskService._dt_ApiInfoService<-Mk
|
'o_basicServiceWIDESEA_TaskInfoService.TaskService._basicService;(`j 9_roadwayInforepositoryWIDESEA_TaskInfoService.TaskService._roadwayInforepository:6bi ;_locationInfoRepositoryWIDESEA_TaskInfoService.TaskService._locationInfoRepository97[h
|
5}_warehouseRepositoryWIDESEA_TaskInfoService.TaskService._warehouseRepository84Sg
|
-u_stockRepositoryWIDESEA_TaskInfoService.TaskService._stockRepository74Uf
|
/w_unitOfWorkManageWIDESEA_TaskInfoService.TaskService._unitOfWorkManage6,Ae
|
c_mapperWIDESEA_TaskInfoService.TaskService._mapper5";d
|
#S TaskServiceWIDESEA_TaskInfoService.TaskService3<c
|
;;WIDESEA_TaskInfoServiceWIDESEA_TaskInfoService 1 \ , ¥ 9 è Hó5Â_´`¼j Þ Â m
|
|
4 Ù oÁp"Êp µiÇt »EÏk ¥ ¼ aT 7 QueryStackerCraneTaskWIDESEAWCS_TaskInfoService.TaskService.QueryStackerCraneTask _S 5 RequestWMSTaskSimpleWIDESEAWCS_TaskInfoService.TaskService.RequestWMSTaskSimple ÷#aR 7 QuertStackerCraneTaskWIDESEAWCS_TaskInfoService.TaskService.QuertStackerCraneTask ésQ I QueryCompletedConveyorLineTaskWIDESEAWCS_TaskInfoService.TaskService.QueryCompletedConveyorLineTask ÞsP I QueryExecutingConveyorLineTaskWIDESEAWCS_TaskInfoService.TaskService.QueryExecutingConveyorLineTask ÓaO 7 QueryConveyorLineTaskWIDESEAWCS_TaskInfoService.TaskService.QueryConveyorLineTask ÈRN
|
)w RequestWMSTaskWIDESEAWCS_TaskInfoService.TaskService.RequestWMSTask §#PM
|
'u TaskCompletedWIDESEAWCS_TaskInfoService.TaskService.TaskCompleted #QL
|
)w ReceiveWMSTaskWIDESEAWCS_TaskInfoService.TaskService.ReceiveWMSTask Z#KK
|
#q TaskServiceWIDESEAWCS_TaskInfoService.TaskService.TaskService IIJ
|
!o RepositoryWIDESEAWCS_TaskInfoService.TaskService.Repository G%UI
|
-{ urlTaskCompletedWIDESEAWCS_TaskInfoService.TaskService.urlTaskCompletedB`H 7 urlWMSMovelibraryTaskWIDESEAWCS_TaskInfoService.TaskService.urlWMSMovelibraryTaskAWG
|
/} TaskOutboundTypesWIDESEAWCS_TaskInfoService.TaskService.TaskOutboundTypes ?UF
|
-{ TaskInboundTypesWIDESEAWCS_TaskInfoService.TaskService.TaskInboundTypes =KE
|
#q TaskOrderByWIDESEAWCS_TaskInfoService.TaskService.TaskOrderBy ;0ND
|
%s_taskOrderByWIDESEAWCS_TaskInfoService.TaskService._taskOrderBy51TC
|
+y_taskHtyServiceWIDESEAWCS_TaskInfoService.TaskService._taskHtyService2*DB
|
i_mapperWIDESEAWCS_TaskInfoService.TaskService._mapper1"`z 9 TaskCompletionFeedbackWIDESEA_TaskInfoService.TaskService.TaskCompletionFeedback Þ#py I MES_TransferCompletionFeedbackWIDESEA_TaskInfoService.TaskService.MES_TransferCompletionFeedback #]x
|
7 OutboundTaskCompletedWIDESEA_TaskInfoService.TaskService.OutboundTaskCompleted a#[w
|
5} InboundTaskCompletedWIDESEA_TaskInfoService.TaskService.InboundTaskCompleted (#fv ? RelocationInTaskCompletedWIDESEA_TaskInfoService.TaskService.RelocationInTaskCompleted ø# 9 WCSMagA = _stationMangerRepositoryWIDESEAWCS_TaskInfoService.TaskService._stationMangerRepository08X@
|
/}_routerRepositoryWIDESEAWCS_TaskInfoService.TaskService._routerRepository/1X?
|
/}_unitOfWorkManageWIDESEAWCS_TaskInfoService.TaskService._unitOfWorkManage.,o> E_taskExecuteDetailRepositoryWIDESEAWCS_TaskInfoService.TaskService._taskExecuteDetailRepository-<i= ? _taskExecuteDetailServiceWIDESEAWCS_TaskInfoService.TaskService._taskExecuteDetailService,4R<
|
)w_routerServiceWIDESEAWCS_TaskInfoService.TaskService._routerService+)>;
|
#Y TaskServiceWIDESEAWCS_TaskInfoService.TaskService)B:
|
AAWIDESEAWCS_TaskInfoServiceWIDESEAWCS_TaskInfoService ' Mu
|
'o TaskCompletedWIDESEA_TaskInfoService.TaskService.TaskCompleted á#Mt
|
'o IsRelocationsWIDESEA_TaskInfoService.TaskService.IsRelocations #Ns
|
)q PushTasksToWCSWIDESEA_TaskInfoService.TaskService.PushTasksToWCS ^#Fr
|
!i GetTaskNumWIDESEA_TaskInfoService.TaskService.GetTaskNum UY
|
3{ ManualTaskCompletedWIDESEA_TaskInfoService.TaskService.ManualTaskCompleted t#=
|
_ chukuWIDESEA_TaskInfoService.TaskService.chuku "#I
|
#k GetLastPartWIDESEA_TaskInfoService.TaskService.GetLastPart O
|
)q deleteLocationWIDESEA_TaskInfoService.TaskService.deleteLocation $O~
|
)q updateLocationWIDESEA_TaskInfoService.TaskService.updateLocation è$O}
|
)q createLocationWIDESEA_TaskInfoService.TaskService.createLocation Ã$Q|
|
+s CancelinventoryWIDESEA_TaskInfoService.TaskService.Cancelinventory .#I{
|
#k MESresponseWIDESEA_TaskInfoService.TaskService.MESresponse $ 2 .ÂT û / Ú r ý :
|
Ù
|
{
|
µ XîBÌ` ´Jí2 cp 9 WCSManualTaskCompletedWIDESEAWCS_TaskInfoService.TaskService.WCSManualTaskCompleted #Ro
|
)w AddTaskHistoryWIDESEAWCS_TaskInfoService.TaskService.AddTaskHistory {Zn
|
1 WCSCancelinventoryWIDESEAWCS_TaskInfoService.TaskService.WCSCancelinventory k#gm = QueryStackerCraneYKTasksWIDESEAWCS_TaskInfoService.TaskService.QueryStackerCraneYKTasks e Tl
|
+y GetOutTaskInfo2WIDESEAWCS_TaskInfoService.TaskService.GetOutTaskInfo2 `Rk
|
)w GetOutTaskInfoWIDESEAWCS_TaskInfoService.TaskService.GetOutTaskInfo [ij ? RequestWMSTaskMovelibraryWIDESEAWCS_TaskInfoService.TaskService.RequestWMSTaskMovelibrary ?si I QueryStationIsOccupiedOutTasksWIDESEAWCS_TaskInfoService.TaskService.QueryStationIsOccupiedOutTasks 4Vh
|
-{ UpdateTaskIninfoWIDESEAWCS_TaskInfoService.TaskService.UpdateTaskIninfo #Pg
|
'u GetTaskIninfoWIDESEAWCS_TaskInfoService.TaskService.GetTaskIninfo gf = RollbackTaskStatusToLastWIDESEAWCS_TaskInfoService.TaskService.RollbackTaskStatusToLast õ#Ze
|
1 TaskStatusRecoveryWIDESEAWCS_TaskInfoService.TaskService.TaskStatusRecovery Ç#^d 3NotifyTaskCompletedWIDESEAWCS_TaskInfoService.TaskService.NotifyTaskCompleted °bc 7ProcessRelocationTaskWIDESEAWCS_TaskInfoService.TaskService.ProcessRelocationTask [b
|
1ProcessInboundTaskWIDESEAWCS_TaskInfoService.TaskService.ProcessInboundTask ^a 3ProcessOutboundTaskWIDESEAWCS_TaskInfoService.TaskService.ProcessOutboundTask [`
|
1UpdateTaskBaseInfoWIDESEAWCS_TaskInfoService.TaskService.UpdateTaskBaseInfo vb_ 7ProcessTaskCompletionWIDESEAWCS_TaskInfoService.TaskService.ProcessTaskCompletion ]r^ GIsTaskStateValidForCompletionWIDESEAWCS_TaskInfoService.TaskService.IsTaskStateValidForCompletion Oe] ; StackCraneTaskCompletedWIDESEAWCS_TaskInfoService.TaskService.StackCraneTaskCompleted 5R\
|
)w UpdatePositionWIDESEAWCS_TaskInfoService.TaskService.UpdatePosition Ýc[ 9 UpdateTaskStatusToNextWIDESEAWCS_TaskInfoService.TaskService.UpdateTaskStatusToNext #cZ 9 UpdateTaskStatusToNextWIDESEAWCS_TaskInfoService.TaskService.UpdateTaskStatusToNext x#VY
|
-{ UpdateTaskStatusWIDESEAWCS_TaskInfoService.TaskService.UpdateTaskStatus kkX A UpdateTaskExceptionMessageWIDESEAWCS_TaskInfoService.TaskService.UpdateTaskExceptionMessage H#iW ? QueryStackerCraneOutTasksWIDESEAWCS_TaskInfoService.TaskService.QueryStackerCraneOutTasks > gV = QueryStackerCraneOutTaskWIDESEAWCS_TaskInfoService.TaskService.QueryStackerCraneOutTask 3eU ; QueryStackerCraneInTaskWIDESEAWCS_TaskInfoService.TaskService.QueryStackerCraneInTask (
|
