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
|
¿ è¿ ' -3CreatedOrUpdated08/18/2025 10:16:10 'SchemaVersion1.3.5 } ÞË}´ -FileScannerCache Settingô SymbolDefinitio-SymbolDefinition®) ProviderEntity-FileSystemEntity Setting
|
Ú Úï -CreatedOrUpdated' SchemaVersion ßĬxdM2ýÛ½¡_G & ; WorkOrderWithItemDto.csÝÞ ÞV serviceÝÞ ÞR_ç + DbckaManager.csÝÞD2¬ / ZJdbController.cs ÝÞ;{gh #Controllers ÝÞ;tÈ ) MESApplicationÝÞ;tÈ / MesInvItemDbsq.cs
|
ÝÞÎÜj
|
ModesÝÞÎÕÌG ) ZjdbManager.csÝÞ ! ERPZJDB.csÝÝý@T webApiÝÝý@ð DtoÝÞ ÞR_ç - RetMatService.csÝgæq QCÝggb serviceÝÞD,< # MES.ServiceÝÞ ÞR_ç / StandardInterfaceÝÞ ÞR_ç
|
é ;«ÛK^tȳÏë é%~ ;WorkOrderWithItemDto.cs service+DbckaManager.cs/ZJdbController.cs#Controllers )MESApplication /MesInvItemDbsq.cs Modes
|
)ZjdbManager.cs !ERPZJDB.cs
|
webApiDto-RetMatService.csQC service#MES.Service/ StandardInterface
|
ü÷¼ñßÇëͪåÙ¤ÓÁ¶°
|
|
|
Ê $ö¡Ù6Jb«ËèêÊ n ;WorkOrderWithItemDto.cs service+DbckaManager.cs/ZJdbController.cs #Controllers ) MESApplication /MesInvItemDbsq.cs
|
Modes
|
)ZjdbManager.cs !ERPZJDB.cs webApi Dto-RetMatService.csQC service# MES.Service/ StandardInterface È È 6 U)7b3bd5d3-8362-427d-89a4-742f2e2256c217.10.24.56844
|
É É 6U) 7b3bd5d3-8362-427d-89a4-742f2e2256c217.10.24.56844 îÜʸ¦ ÝÞ ÞWà ÝÞ $Ì ÝÞ;}µ ÝÞ \ ÝÞ !> ÝÞ ¾
bE ÝgµÁ
|
× ûõïéãÝ× ô úô¥X ¾ M Ó - Û X $
|
å
|
¥
|
n
|
1 ö ¹ ~ C ÍW á¦k0õÀLØ^!à£b'ì·|EÔ`Â: ð ¢ K*
|
)k LastupdatKZ
|
)k LastupdateDateMES.Service.Modes.MesInvItemDbsq.LastupdateDate 5GY
|
%g LastupdateByMES.Service.Modes.MesInvItemDbsq.LastupdateBy 0CX
|
!c CreateDateMES.Service.Modes.MesInvItemDbsq.CreateDate +?W
|
_ CreateByMES.Service.Modes.MesInvItemDbsq.CreateBy &SV
|
1s InvDepotSectionsIdMES.Service.Modes.MesInvItemDbsq.InvDepotSectionsId !EU
|
#e InvDepotsIdMES.Service.Modes.MesInvItemDbsq.InvDepotsId ;T
|
[ BillNoMES.Service.Modes.MesInvItemDbsq.BillNo 3S
|
S IdMES.Service.Modes.MesInvItemDbsq.Id ;R
|
)M MesInvItemDbsqMES.Service.Modes.MesInvItemDbsq 0Q
|
//MES.Service.ModesMES.Service.Modes 4
|
S eidMES.Service.Dto.webApi.ERPZJDBB.eid /8
|
W erpidMES.Service.Dto.webApi.ERPZJDBB.erpid .2
|
Q bzMES.Service.Dto.webApi.ERPZJDBB.bz -8
|
W dr_hzMES.Service.Dto.webApi.ERPZJDBB.dr_hz ,8
|
W dc_hzMES.Service.Dto.webApi.ERPZJDBB.dc_hz +>
|
] dr_depotMES.Service.Dto.webApi.ERPZJDBB.dr_depot *:
|
Y dr_orgMES.Service.Dto.webApi.ERPZJDBB.dr_org )>
|
] dc_depotMES.Service.Dto.webApi.ERPZJDBB.dc_depot (:
|
Y dc_orgMES.Service.Dto.webApi.ERPZJDBB.dc_org '>
|
] quantityMES.Service.Dto.webApi.ERPZJDBB.quantity &6
|
U unitMES.Service.Dto.webApi.ERPZJDBB.unit %:
|
Y itemidMES.Service.Dto.webApi.ERPZJDBB.itemid $4
|
K ERPZJDBBMES.Service.Dto.webApi.ERPZJDBB"8
|
W erpidMES.Service.Dto.webApi.ERPZJDBA.erpid 6
|
U typeMES.Service.Dto.webApi.ERPZJDBA.type 2
|
Q bzMES.Service.Dto.webApi.ERPZJDBA.bz 8
|
W dr_bmMES.Service.Dto.webApi.ERPZJDBA.dr_bm 8
|
W dc_bmMES.Service.Dto.webApi.ERPZJDBA.dc_bm 8
|
W dr_ckMES.Service.Dto.webApi.ERPZJDBA.dr_ck 8
|
W dr_hzMES.Service.Dto.webApi.ERPZJDBA.dr_hz 8
|
W dc_hzMES.Service.Dto.webApi.ERPZJDBA.dc_hz 8
|
W dr_kcMES.Service.Dto.webApi.ERPZJDBA.dr_kc 8
|
|
W dc_kcMES.Service.Dto.webApi.ERPZJDBA.dc_kc 8
|
W sq_bmMES.Service.Dto.webApi.ERPZJDBA.sq_bm 8
|
W dj_ztMES.Service.Dto.webApi.ERPZJDBA.dj_zt 8
|
W yw_lxMES.Service.Dto.webApi.ERPZJDBA.yw_lx 8
|
W db_lxMES.Service.Dto.webApi.ERPZJDBA.db_lx 8
|
W db_fxMES.Service.Dto.webApi.ERPZJDBA.db_fx :
|
Y db_lx1MES.Service.Dto.webApi.ERPZJDBA.db_lx1 8
|
W dj_lxMES.Service.Dto.webApi.ERPZJDBA.dj_lx :
|
Y billnoMES.Service.Dto.webApi.ERPZJDBA.billno 4
|
K ERPZJDBAMES.Service.Dto.webApi.ERPZJDBA =
|
[ ERPZJDBBMES.Service.Dto.webApi.ERPZJDB.ERPZJDBB =
|
[ ERPZJDBAMES.Service.Dto.webApi.ERPZJDB.ERPZJDBA 2~
|
I ERPZJDBMES.Service.Dto.webApi.ERPZJDB:}
|
99MES.Service.Dto.webApiMES.Service.Dto.webApi E|
|
!cUpdateDataMES.Service.service.DbckaManager.UpdateData P{
|
-oSaveOrUpdateDataMES.Service.service.DbckaManager.SaveOrUpdateData nTz
|
1sMapErpDbckbToDbckbMES.Service.service.DbckaManager.MapErpDbckbToDbckb N+Ny
|
+mMapErpToMesHeadMES.Service.service.DbckaManager.MapErpToMesHead * 7x
|
W SaveMES.Service.service.DbckaManager.Save ?w
|
_ SaveListMES.Service.service.DbckaManager.SaveList 9v
|
%M DbckaManagerMES.Service.service.DbckaManager 4u
|
33MES.Service.serviceMES.Service.service G
|
!k SaveReviewMES.Service.service.QC.RetMatService.SaveReview _O
|
)s SaveReviewItemMES.Service.service.QC.RetMatService.SaveReviewItem PK
|
%o UpdateHeaderMES.Service.service.QC.RetMatService.UpdateHeader BM
|
'q GetDetailListMES.Service.service.QC.RetMatService.GetDetailList 1 E
|
i GetHeaderMES.Service.service.QC.RetMatService.GetHeader G
|
!k GetAllDocsMES.Service.service.QC.RetMatService.GetAllDocs >
|
'U RetMatServiceMES.Service.service.QC.RetMatService :
|
99MES.Service.service.QCMES.Service.se H
|
õ ¬
|
B
|
- óJ ^· - < z ¼ ¬ % õé( 3 Æ * dºNÛ)ñ\
|
|
Ø
|
Ã? 5 ¯Å4Ð æB
|
|
¥
|
¯
|
¹
|
Í 2 eVd
|
P È È Ù ? PÅ¥· ] ÿ Ê âÀÏÝ ³ A Ü Øæ
|
g
|
!h nÔ ½ ® ¡ ÿ
|
® ñ K ¸
krü
|
ø
|
â
|
î z
|
K í r¥¬v u [
|
1
|
Type2zbzI ItemModel% ItemName$ ItemNo# Daa020" Daa015! Daa008 Daa003 Daa002 Daa001 5WorkOrderWithItemDto SaveList}!UpdateData-SaveOrUpdateData1MapErpDbckbToDbckb+MapErpToMesHead Save SaveList
%DbckaManager3MES.Service.service SaveList
|
Save URL TableName METHOD+_messageManager _manager/ERPZJDBController AMESApplication.Controllers Save~ DrBmy DcBmx DrCkw DrHzv DrKcu DcKct
|
Erpids DcHzr SqTimeq SqZzp SqBmo DjZtn YwLxm DbLxl DbFxk
|
DbLx1j Djlxi#Fstockorgidh)Fstockoutorgidg DbStatusfTse Companyd Factoryc Saptextb Sapyeara Sapstatus`
|
Sapno_#FactoryCode^)FromDepotsCode]'TransactionNo\5InvDepotSectionsCode['InvDepotsCodeZ CheckdateY CheckuserX'TransactionIdW!BillTypeIdV RemarkU StatusT)LastupdateDateS%LastupdateByR!CreateDateQ CreateByP1InvDepotSectionsIdO#InvDepotsIdN BillNoMIdL)MesInvItemDbsqK/MES.Service.ModesJ ERPZJDBer9MES.Service.Dto.webApiId ERPZJDBAte!UpdateData-SaveOrUpdateData1MapErpDbckbToDbckb+MapErpToMesHead)ERPZJDBManager|3MES.Service.service{ erpidH eid®
|
erpidbz¬
|
dr_hz«
|
dc_hzª dr_depot© dr_org¨ dc_depot§ dc_org¦ quantity¥ unit¤ itemid£ ERPZJDBB¢
|
erpid¡ type
|
dr_bm
|
dc_bm
|
dr_ck
|
dr_hz
|
dc_hz
|
dr_kc
|
dc_kc
|
sq_bm
|
dj_zt
|
yw_lx
|
db_lx
|
db_fx db_lx1
|
dj_lx billno ERPZJDBA ERPZJDBB!SaveReview)SaveReviewItem%UpdateHeader'GetDetailList GetHeader!GetAllDocs'RetMatService9 MES.Service.service.QC
|
O v ûõïéãÝ×ÑÎÇÀ¹²Êüµ®§ }vohaZSLE>70)" ÿ v Ñ ÊøñêãÜÕ¥{tmf_XQJC<5.' ý ö ï è á Ú Ó Ì Å ¾ · ° © ¢ x q j c \ U H A : 3 , % û ô í æ ß Ø Ã ¼ µ ® § } ®%$#"! | {
|
¬ z y x w v u t s r q p o n m l k j i h g f e d c b a ` _ ^ ] \ [ Z Y X W V U T S R Q P O N M L K J ~ }¬«ª©¨§¦¥¤£¢¡
|
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 ö O1|ÇL¡ --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])
|
|
|
§ } Ä;ô¥X ¾
|
¯
|
b
|
µ jVË} 2 Ö¤r@ܪt< §á W erpidMES.Service.Dto.webApi.ERPZJDBB.erpid .§¦ Q bzMES.Service.Dto.webApi.ERPZJDBB.bz -§q W dr_hzMES.Service.Dto.webApi.ERPZJDBB.dr_hz ,§6 W dc_hzMES.Service.Dto.webApi.ERPZJDBB.dc_hz +§û ] dr_depotMES.Service.Dto.webApi.ERPZJDBB.dr_depot *§º Y dr_orgMES.Service.Dto.webApi.ERPZJDBB.dr_org )§} ] dc_depotMES.Service.Dto.webApi.ERPZJDBB.dc_depot (§< Y dc_orgMES.Service.Dto.webApi.ERPZJDBB.dc_org '§ÿ ] quantityMES.Service.Dto.webApi.ERPZJDBB.quantity &§¾ U unitMES.Service.Dto.webApi.ERPZJDBB.unit %§
Y itemidMES.Service.Dto.webApi.ERPZJDBB.itemid $§H K ERPZJDBBMES.Service.Dto.webApi.ERPZJDBB"§ W erpidMES.Service.Dto.webApi.ERPZJDBA.erpid §Ö U typeMES.Service.Dto.webApi.ERPZJDBA.type § W dr_bmMES.Service.Dto.webApi.ERPZJDBA.dr_bm §b W dc_bmMES.Service.Dto.webApi.ERPZJDBA.dc_bm §' W dr_ckMES.Service.Dto.webApi.ERPZJDBA.dr_ck § ì W dr_hzMES.Service.Dto.webApi.ERPZJDBA.dr_hz § ± W dc_hzMES.Service.Dto.webApi.ERPZJDBA.dc_hz § v W dr_kcMES.Service.Dto.webApi.ERPZJDBA.dr_kc § ; W dc_kcMES.Service.Dto.webApi.ERPZJDBA.dc_kc K
|
|
w SaveListMESApplication.Controllers.ERPZJDBController.SaveList D C
|
o SaveMESApplication.Controllers.ERPZJDBController.Save B
|
mURLMESApplication.Controllers.ERPZJDBController.URL N
|
yTableNameMESApplication.Controllers.ERPZJDBController.TableName
|
ô W DjZtMES.Service.Modes.2'
|
I ERPZJDBMES.Service.Dto.webApi.ERPZJDB = 99MES.Service.Dto.webApiMES.Service.Dto.webApi 5%
|
I ItemModelWorkOrderWithItemDto.ItemModel 83$
|
G ItemNameWorkOrderWithItemDto.ItemName 3/#
|
C ItemNoWorkOrderWithItemDto.ItemNo ./"
|
C Daa020WorkOrderWithItemDto.Daa020 )/!
|
C Daa015WorkOrderWithItemDto.Daa015 $/
|
C Daa008WorkOrderWithItemDto.Daa008 /
|
C Daa003WorkOrderWithItemDto.Daa003 /
|
C Daa002WorkOrderWithItemDto.Daa002 /
|
C Daa001WorkOrderWithItemDto.Daa001 '
|
; IdWorkOrderWithItemDto.Id 5
|
55 WorkOrderWithItemDtoWorkOrderWithItemDtoH
|
sMETHODMESApplication.Controllers.ERPZJDBController.METHOD [ +_messageManagerMESApplication.Controllers.ERPZJDBController._messageManager/L
|
w_managerMESApplication.Controllers.ERPZJDBController._manager)J
|
/e ERPZJDBControllerMESApplication.Controllers.ERPZJDBControllerB
|
AAMESApplication.ControllersMESApplication.Controllers Ê Q bzMES.Service.Dto.webApi.ERPZJDBA.bz e W sq_bmMES.Service.Dto.webApi.ERPZJDBA.sq_bm X W dj_ztMES.Service.Dto.webApi.ERPZJDBA.dj_zt W yw_lxMES.Service.Dto.webApi.ERPZJDBA.yw_lx â W db_lxMES.Service.Dto.webApi.ERPZJDBA.db_lx § W db_fxMES.Service.Dto.webApi.ERPZJDBA.db_fx l Y db_lx1MES.Service.Dto.webApi.ERPZJDBA.db_lx1 / W dj_lxMES.Service.Dto.webApi.ERPZJDBA.dj_lx ô Y billnoMES.Service.Dto.webApi.ERPZJDBA.billno · K ERPZJDBAMES.Service.Dto.webApi.ERPZJDBA [ ERPZJDBBMES.Service.Dto.webApi.ERPZJDB.ERPZJDBB @ [ ERPZJDBAMES.Service.Dto.webApi.ERPZJDB.ERPZJDBA G
|
!k SaveReviewMES.Service.service.QC.RetMatService.SaveReview _O
|
)s SaveReviewItemMES.Service.service.QC.RetMatService.SaveReviewItem PK
|
%o UpdateHeaderMES.Service.service.QC.RetMatService.UpdateHeader BM
|
'q GetDetailListMES.Service.service.QC.RetMatService.GetDetailList 1 E
|
i GetHeaderMES.Service.service.QC.RetMatService.GetHeader G
|
!k GetAllDocsMES.Service.service.QC.RetMatService.GetAllDocs >
|
'U RetMatServiceMES.Service.service.QC.RetMatService :
|
99MES.Service.service.QCMES.Service.service.QC ¿ ; NÚ<ú´j ÊÞL¼pÊ|4 ø ´ t 3 ò ± z 7 è d '
|
ì
|
±
|
v
|
;
|
Å K Ó]"ç¬o8ø´x%Ìw-ö 9
|
%M DbckaManagerMES.Service.service.DbckaManager ;T
|
[ StatusMES.Service.Modes.MesInvItemDbsq.Status :AX
|
a CheckuserMES.Service.Modes.MesInvItemDbsq.Checkuser NIW
|
'i TransactionIdMES.Service.Modes.MesInvItemDbsq.TransactionId ICV
|
!c BillTypeIdMES.Service.Modes.MesInvItemDbsq.BillTypeId D;U
|
[ RemarkMES.Service.Modes.MesInvItemDbsq.Remark ?KS
|
)k LastupdateDateMES.Service.Modes.MesInvItemDbsq.LastupdateDate 5GR
|
%g LastupdateByMES.Service.Modes.MesInvItemDbsq.LastupdateBy 0CQ
|
!c CreateDateMES.Service.Modes.MesInvItemDbsq.CreateDate +?P
|
_ CreateByMES.Service.Modes.MesInvItemDbsq.CreateBy &SO
|
1s InvDepotSectionsIdMES.Service.Modes.MesInvItemDbsq.InvDepotSectionsId !EN
|
#e InvDepotsIdMES.Service.Modes.MesInvItemDbsq.InvDepotsId ;M
|
[ BillNoMES.Service.Modes.MesInvItemDbsq.BillNo 3L
|
S IdMES.Service.Modes.MesInvItemDbsq.Id ;K
|
)M MesInvItemDbsqMES.Service.Modes.MesInvItemDbsq 0J
|
//MES.Service.ModesMES.Service.Modes 7 S eidMES.Service.Dto.webApi.ERPZJDBB.eid /4
|
33MES.Service.serviceMES.Service.service G
|
!gUpdateDataMES.Service.service.ERPZJDBManager.UpdateData R
|
-sSaveOrUpdateDataMES.Service.service.ERPZJDBManager.SaveOrUpdateData lV
|
1wMapErpDbckbToDbckbMES.Service.service.ERPZJDBManager.MapErpDbckbToDbckb M+P
|
+qMapErpToMesHeadMES.Service.service.ERPZJDBManager.MapErpToMesHead ( 9~
|
[ SaveMES.Service.service.ERPZJDBManager.Save A}
|
c SaveListMES.Service.service.ERPZJDBManager.SaveList =|
|
)Q ERPZJDBManagerMES.Service.service.ERPZJDBManager 4{
|
33MES.Service.serviceMES.Service.service :z
|
Y Type2MES.Service.Modes.MesInvItemDbsq.Type2 û8y
|
W DrBmMES.Service.Modes.MesInvItemDbsq.DrBm ö8x
|
W DcBmMES.Service.Modes.MesInvItemDbsq.DcBm ñ8w
|
W DrCkMES.Service.Modes.MesInvItemDbsq.DrCk ì8v
|
W DrHzMES.Service.Modes.MesInvItemDbsq.DrHz ç8u
|
W DrKcMES.Service.Modes.MesInvItemDbsq.DrKc à8t
|
W DcKcMES.Service.Modes.MesInvItemDbsq.DcKc Û:s
|
Y ErpidMES.Service.Modes.MesInvItemDbsq.Erpid Õ8r
|
W DcHzMES.Service.Modes.MesInvItemDbsq.DcHz Ð<q
|
[ SqTimeMES.Service.Modes.MesInvItemDbsq.SqTime Ë8p
|
W SqZzMES.Service.Modes.MesInvItemDbsq.SqZz Æ8o
|
W SqBmMES.Service.Modes.MesInvItemDbsq.SqBm Á8n
|
W DjZtMES.Service.Modes.MesInvItemDbsq.DjZt ¼8m
|
W YwLxMES.Service.Modes.MesInvItemDbsq.YwLx ·8l
|
W DbLxMES.Service.Modes.MesInvItemDbsq.DbLx ²8k
|
W DbFxMES.Service.Modes.MesInvItemDbsq.DbFx :j
|
Y DbLx1MES.Service.Modes.MesInvItemDbsq.DbLx1 ¨8i
|
W DjlxMES.Service.Modes.MesInvItemDbsq.Djlx £Fh
|
#e FstockorgidMES.Service.Modes.MesInvItemDbsq.Fstockorgid Lg
|
)k FstockoutorgidMES.Service.Modes.MesInvItemDbsq.Fstockoutorgid @f
|
_ DbStatusMES.Service.Modes.MesInvItemDbsq.DbStatus 4e
|
S TsMES.Service.Modes.MesInvItemDbsq.Ts >d
|
] CompanyMES.Service.Modes.MesInvItemDbsq.Company >c
|
] FactoryMES.Service.Modes.MesInvItemDbsq.Factory
>b
|
] SaptextMES.Service.Modes.MesInvItemDbsq.Saptext =a
|
] SapyearMES.Service.Modes.MesInvItemDbsq.Sapyear {A`
|
a SapstatusMES.Service.Modes.MesInvItemDbsq.Sapstatus v9_
|
Y SapnoMES.Service.Modes.MesInvItemDbsq.Sapno qE^
|
#e FactoryCodeMES.Service.Modes.MesInvItemDbsq.FactoryCode lK]
|
)k FromDepotsCodeMES.Service.Modes.MesInvItemDbsq.FromDepotsCode gI\
|
'i TransactionNoMES.Service.Modes.MesInvItemDbsq.TransactionNo bW[
|
5w InvDepotSectionsCodeMES.Service.Modes.MesInvItemDbsq.InvDepotSectionsCode ]IZ
|
'i InvDepotsCodeMES.Service.Modes.MesInvItemDbsq.InvDepotsCode XAY
|
a CheckdateMES.Service.Modes.MesInvItemDbsq.Checkdate S *ï ¾3ÜA Ï O Û c ( í ² w <
|
Æ
|
|
P
|
Ú j 1ö¿IËM Ña&ï¸c G
|
!gUpdateDataMES.Service.service.ERPZJDBManager.UpdateData R
|
-sSaveOrUpdateDataMES.Service.service.ERPZJDBManager.SaveOrUpdateData lV
|
1wMapErpDbckbToDbckbMES.Service.service.ERPZJDBManager.MapErpDbckbToDbckb M+P
|
+qMapErpToMesHeadMES.Service.service.ERPZJDBManager.MapErpToMesHead ( 9~
|
[ SaveMES.Service.service.ERPZJDBManager.Save A}
|
c SaveListMES.Service.service.ERPZJDBManager.SaveList =|
|
)Q 4.
|
S eidMES.Service.Dto.webApi.ERPZJDBB.eid /8-
|
W erpidMES.Service.Dto.webApi.ERPZJDBB.erpid .2,
|
Q bzMES.Service.Dto.webApi.ERPZJDBB.bz -8+
|
W dr_hzMES.Service.Dto.webApi.ERPZJDBB.dr_hz ,8*
|
W dc_hzMES.Service.Dto.webApi.ERPZJDBB.dc_hz +>)
|
] dr_depotMES.Service.Dto.webApi.ERPZJDBB.dr_depot *:(
|
Y dr_orgMES.Service.Dto.webApi.ERPZJDBB.dr_org )>'
|
] dc_depotMES.Service.Dto.webApi.ERPZJDBB.dc_depot (:&
|
Y dc_orgMES.Service.Dto.webApi.ERPZJDBB.dc_org '>%
|
] quantityMES.Service.Dto.webApi.ERPZJDBB.quantity &6$
|
U unitMES.Service.Dto.webApi.ERPZJDBB.unit %:#
|
Y itemidMES.Service.Dto.webApi.ERPZJDBB.itemid $4"
|
K ERPZJDBBMES.Service.Dto.webApi.ERPZJDBB"8!
|
W erpidMES.Service.Dto.webApi.ERPZJDBA.erpid 6
|
U typeMES.Service.Dto.webApi.ERPZJDBA.type 2
|
Q bzMES.Service.Dto.webApi.ERPZJDBA.bz 8
|
W dr_bmMES.Service.Dto.webApi.ERPZJDBA.dr_bm 8
|
W dc_bmMES.Service.Dto.webApi.ERPZJDBA.dc_bm 8
|
W dr_ckMES.Service.Dto.webApi.ERPZJDBA.dr_ck 8
|
W dr_hzMES.Service.Dto.webApi.ERPZJDBA.dr_hz 8
|
W dc_hzMES.Service.Dto.webApi.ERPZJDBA.dc_hz 8
|
W dr_kcMES.Service.Dto.webApi.ERPZJDBA.dr_kc 8
|
W dc_kcMES.Service.Dto.webApi.ERPZJDBA.dc_kc 8
|
W sq_bmMES.Service.Dto.webApi.ERPZJDBA.sq_bm 8
|
W dj_ztMES.Service.Dto.webApi.ERPZJDBA.dj_zt 8
|
W yw_lxMES.Service.Dto.webApi.ERPZJDBA.yw_lx 8
|
W db_lxMES.Service.Dto.webApi.ERPZJDBA.db_lx 8
|
W db_fxMES.Service.Dto.webApi.ERPZJDBA.db_fx :
|
Y db_lx1MES.Service.Dto.webApi.ERPZJDBA.db_lx1 8
|
W dj_lxMES.Service.Dto.webApi.ERPZJDBA.dj_lx :
|
Y billnoMES.Service.Dto.webApi.ERPZJDBA.billno 4
|
K ERPZJDBAMES.Service.Dto.webApi.ERPZJDBA =
|
[ ERPZJDBBMES.Service.Dto.webApi.ERPZJDB.ERPZJDBB =
|
[ ERPZJDBAMES.Service.Dto.webApi.ERPZJDB.ERPZJDBA 2
|
I ERPZJDBMES.Service.Dto.webApi.ERPZJDB:
|
99MES.Service.Dto.webApiMES.Service.Dto.webApi E
|
|
!cUpdateDataMES.Service.service.DbckaManager.UpdateData P
|
-oSaveOrUpdateDataMES.Service.service.DbckaManager.SaveOrUpdateData oT
|
1sMapErpDbckbToDbckbMES.Service.service.DbckaManager.MapErpDbckbToDbckb O+N
|
+mMapErpToMesHeadMES.Service.service.DbckaManager.MapErpToMesHead * 7
|
W SaveMES.Service.service.DbckaManager.Save ?
|
_ SaveListMES.Service.service.DbckaManager.SaveList
|
