明和堆垛机立库与二楼平库
blame | 历史 | 原始文档
1
yangpeixing
3 天以前 07b56c461476f7d580318749b2cd5f752aa38f3a 
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142

SQLite format 3@  


 


.fê ø¸èÇ–&„


ý


‡Ý\Æ>ºÒ¸K%%[tablesqlite_stat1sqlite_stat1 CREATE TABLE sqlite_stat1(tbl,idx,stat)J+‚[triggerTrgSymbolInsertSymbolCREATE TRIGGER TrgSymbolInsert AFTER INSERT ON Symbol 


BEGIN 


    INSERT INTO SymbolCompletion(rowid, UnqualifiedName)  


    VALUES (new.Id, new.UnqualifiedName); 


ENDe +ƒtriggerTrgSymbolDeleteSymbolCREATE TRIGGER TrgSymbolDelete AFTER DELETE ON Symbol 


BEGIN 


    INSERT INTO SymbolCompletion(SymbolCompletion, rowid, UnqualifiedName) 


    VALUES ('delete', old.Id, old.UnqualifiedName); 


END;;tableSymbolCompletion_configSymbolCompletion_configCREATE TABLE 'SymbolCompletion_config'(k PRIMARY KEY, v) WITHOUT ROWID==tableSymbolCompletion_docsizeSymbolCompletion_docsizeCREATE TABLE 'SymbolCompletion_docsize'(id INTEGER PRIMARY KEY, sz BLOB)


55ItableSymbolCompletion_idxSymbolCompletion_idx


CREATE TABLE 'SymbolCompletion_idx'(segid, term, pgno, PRIMARY KEY(segid, term)) WITHOUT ROWID    77tableSymbolCompletion_dataSymbolCompletion_data    CREATE TABLE 'SymbolCompletion_data'(id INTEGER PRIMARY KEY, block BLOB)ƒ'--†tableSymbolCompletionSymbolCompletionCREATE VIRTUAL TABLE 'SymbolCompletion' USING fts5( 


    'UnqualifiedName', 


    content = '', -- Creates a contentless table  to save database space: https://www.sqlite.org/fts5.html#external_content_and_contentless_tables 


    tokenize = "trigram" -- Built-in tokenizer that allows FTS5 to support more general substring matching: https://www.sqlite.org/fts5.html#tokenizers 


)t?indexIX_Symbol_UnqualifiedNameSymbolCREATE INDEX 'IX_Symbol_UnqualifiedName' ON 'Symbol' ('UnqualifiedName')5GindexIX_Symbol_DocumentIdSymbolCREATE INDEX 'IX_Symbol_DocumentId' ON 'Symbol' ('DocumentId', 'ExtentStart', 'ExtentLength')…ŠtableSymbolSymbolCREATE TABLE 'Symbol' ( 


    'Id' INTEGER PRIMARY KEY AUTOINCREMENT, 


    'DocumentId' INTEGER, 


    'FullyQualifiedName' VARCHAR(500) NOT NULL, 


    'UnqualifiedName' VARCHAR(500) COLLATE NOCASE NOT NULL, 


    'CommentStart' INTEGER NOT NULL, 


    'CommentLength' INTEGER NOT NULL, 


    'NameStart' INTEGER NOT NULL, 


    'NameLength' INTEGER NOT NULL, 


    'BodyStart' INTEGER NOT NULL, 


    'BodyLength' INTEGER NOT NULL, 


    'ExtentStart' INTEGER NOT NULL, 


    'ExtentLength' INTEGER NOT NULL, 


    'SymbolKind' INTEGER NOT NULL, 


    'MethodSignature' VARCHAR(500), 


    FOREIGN KEY(DocumentId) REFERENCES Document(Id) ON DELETE CASCADE 


)n5indexIX_Document_FilePathDocumentCREATE UNIQUE INDEX 'IX_Document_FilePath' ON 'Document' ('FilePath')P++Ytablesqlite_sequencesqlite_sequenceCREATE TABLE sqlite_sequence(name,seq)\ƒtableDocumentDocumentCREATE TABLE 'Document' ( 


    'Id' INTEGER PRIMARY KEY AUTOINCREMENT, 


    'FilePath' VARCHAR(500) NOT NULL COLLATE NOCASE, 


    'LastWriteTimeUtc' INTEGER NOT NULL, 


    UNIQUE(FilePath) 


)/Cindexsqlite_autoindex_Document_1Document      Š§«7 OŠí ñDa5D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Properties\launchSettings.jsonÜeŠîDS    UD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\frx\PalletCode.frxÜeŠîDŽÞa5D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Controllers\PrintController.csÜeŠîD+ù_1D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\appsettings.Development.jsonÜeŠîDz ªG D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Program.csW!D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\frx\InboundOrder.frxÜeŠîDŽÞcsBGD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Print.csprOD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Print.csprojÜeŠîD+ùî[5D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Properties\launchSettings.jsonM     D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Program.csÜeŠîD+ùrxIWD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Properties\PrWD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Properties\PublishProfiles\FolderProfile.pubxmlÜeŠîDS    SD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\appsettings.jsonÜeŠîDŽÞ


     ©] X¢ ú ² HòE D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Program.cs    Y5D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Controllers\PrintController.csGD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Print.csprojMD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\frx\PalletCode.frxY5D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Properties\launchSettings.jsonO!D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\frx\InboundOrder.frxjWD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Properties\PublishProfiles\FolderProfile.pubxmlKD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\appsettings.jsonV1    D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\appsettings.Development.json æòæ


SymbolDocument    


     ©] X¢ ú ² HòE D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Program.cs    Y5D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Controllers\PrintController.csGD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Print.csprojMD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\frx\PalletCode.frxY5D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Properties\launchSettings.jsonO!D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\frx\InboundOrder.frxjWD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\Properties\PublishProfiles\FolderProfile.pubxmlKD:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\appsettings.jsonV1    D:\明和\DuiDuoJiLiKu\项目代码\Print\Print\Print\appsettings.Development.json     "Às&ƒ ü ¥ LØt¯K


ö


£


H    Ô    y    "UwPrint.Controllers.PrintController.InboundOrder.WeightWeight ð$Y{Print.Controllers.PrintController.InboundOrder.DatetimeDatetimeÌÕ ½%r5Print.Controllers.PrintController.InboundOrder.ProductDrawingNumberProductDrawingNumber¢ ~1Y{Print.Controllers.PrintController.InboundOrder.QuantityQuantityZc K%QsPrint.Controllers.PrintController.InboundOrder.UnitUnit+0 !S uPrint.Controllers.PrintController.InboundOrder.SpecsSpecsû ì"b%Print.Controllers.PrintController.InboundOrder.MaterialNameMaterialNameÄÑ µ)]!Print.Controllers.PrintController.InboundOrder.MaterialNoMaterialNo


š &d


'Print.Controllers.PrintController.InboundOrder.WarehouseNameWarehouseNameX f J)b    %Print.Controllers.PrintController.InboundOrder.UpperOrderNoUpperOrderNo"/ (r5Print.Controllers.PrintController.InboundOrder.DemandClassificationDemandClassificationäù Õ1WyPrint.Controllers.PrintController.InboundOrder.OrderNoOrderNo²º ¤#Ui%Print.Controllers.PrintController.InboundOrderInboundOrder•Šr­o+]Print.Controllers.PrintController.PrintPalletCodePrintPalletCodeQÕüh    PrintPalletCode([FromBody] List<string>) s/Print.Controllers.PrintController.PrintInboundOrderPrintInboundOrder,~rÕ    PrintInboundOrder([FromBody][ValidateNever] List<InboundOrder>)KcPrint.Controllers.PrintController.PrintNamePrintName«    ž-KO+Print.Controllers.PrintControllerPrintControllerq““2ô>//Print.ControllersPrint.Controllers+þ


 


6õéÞÒƺ¯¤™ŽƒxmbWLA6


ð$


½%


~1


K%


!


ì" 


µ)


&


J)


 


(    


Õ1


¤#r­ühÕ


ž-2ô


    


ÕàiŽ&7‚ë׳ɟíXFÕ


WeightDatetime5ProductDrawingNumberQuantityUnit    Specs %MaterialName!MaterialNo'WarehouseName


%UpperOrderNo    5DemandClassificationOrderNo%InboundOrder+PrintPalletCode/PrintInboundOrder PrintName+PrintController/    Print.Controllers êÆ


`    ©


 


    ÂÆÆÆÆÆÆÆÆÆÆÆÆÆÆƈĀ€€€<¨0.coallnmendtre


ss


teiwiberou    catlaod ntddclemr    or ra    ucecs ho


mana


 


rin


o    stcficgnuhou


ialcafi nbg tontylas    ert


le     na    o    mantbenam


bodcognitt.cinpr


    umodeull nt    rd    un


s


palec r    pe    rioquaraw


de


eh


iannoodlr    sen


    ifpe sit.ccodrerinotnaparo


uanctmbndipp    se


war


in     


 


    


 


    


 


     


            


 


 


 


 


    


 


 


 


    ô¿€€€‚P0awiberctddra    ucgnuing mbengnumoduproraw


odtdructmbwin9


x    


 


h€€40antityntiquatituan


hHr    


 `°€€€€DR0alnmeteeriiallna    matnam


riate


4+ˆ€€€€\$0eigghtighwei


M.<„€€€€~30atedatetiimetetim


h(.˜€€VZ0ame


re


eho


na


 


hou


nam


ous


reh


sen


    use


war


(T                ]¤€€€€>O0der        ern    


o    ord    per    pe    rde    no    or    upp    ›N# €€€€‚J0andss


ticatladclememaficicafi onlas    manndcsifsitioÊH3œ€€€€l+0derernordrdenomB_˜€€€€BQ0bouderorinbnbodoord    unrde


undç<z”€€€€xi0allcod etcintlet


le    ntpodepalririntcopaI6€€€€‚u0bou    deror inbtnbodotiordun


prirdeintinundŸ0FŒ€€€€;0ameintnamtnpririntna;*wˆ€€€€rf0conintlerle ntcr    ollntpririnoltcoro


©€€€‚v0.coconersintlerlent.r


oll nt    pririnolt.cro}$


‘ŠúóŠŠŠŠŠŠŠŠŠŠŠŠŠŠŠbhaZ SLE


>    70)"     ”úôîèâÜÖÐÊľ¸²¬¦ š” 


 


    


 


 


ôôversion {ͤ{'5SymbolIX_Symbol_DocumentId18 18 1 1'?SymbolIX_Symbol_UnqualifiedName18 1155SymbolCompletion_idxSymbolCompletion_idx3 1 1