2025/10/28 0:00:02 api生成订单开始：F20251028001，D2510271540404 2025/10/28 0:00:02 api生成订单结束：F20251028001，D2510271540404 2025/10/28 0:00:02 OrdersJson：{"Orders":{"PONo":"TES25073114816555","OrderDate":"2025-07-31 13:54:08","InputTime":"2025-07-31 13:54:08","ExpectDate":"2025-07-31 13:54:08","TotalPrice":"719.00","CurrencyCode":"EUR","OrderRemark":"","CCountry":"ES","CProvince":"PO","CCity":"Redondela","CAddressLineOne":"Camiño dos olmos 6","CAddressLineTwo":"","CPostalCode":"36320","CContact":"German Portela González","Ctel":"679 209 650","CFax":"","OrderType":1,"OrderSourceType":0,"DropShopping":0,"MangoFlag":0,"Itemtype":"Self_built_station","CusEmail":"germancook@hotmail.com","CCityCode":"","HouseNumber":"","Freight":"0","Name":"Envío gratuito","RPayMethod":"eh_paypal_express"},"CODetails":[{"ProductCode":"1069867","ProductName":"Touroll J1 ST","UnitPrice":"879.00","itemid":"1069867","IsGift":"0","TotalPrice":"0","MangoFlag":"","COQuantity":1}],"Token":"5c2dcfb9460259a518f7beeb687f3aa2"} 2025/10/28 0:00:02 api生成订单开始：F20251028002，G19084090 2025/10/28 0:00:03 api生成订单开始：F20251028003，T25102714045633 2025/10/28 0:00:03 api生成订单结束：F20251028002，G19084090 2025/10/28 0:00:03 api生成订单结束：F20251028003，T25102714045633 2025/10/28 0:00:05 OrdersJson：{"Orders":{"PONo":"G19083885","InputTime":"2025-10-27 16:24:36","OrderDate":"2025-10-27 16:25:38","ExpectDate":"2025-10-27 16:24:36","TotalPrice":"1869.660000","CurrencyCode":"PLN","OrderRemark":"","CCountry":"PL","CProvince":null,"CCity":"Cieszyn","CAddressLineOne":"Błogocka","CAddressLineTwo":"","CPostalCode":"43-400","CContact":"Bożena Heler","Ctel":"506313802","CFax":"","OrderType":1,"OrderSourceType":0,"DropShopping":0,"MangoFlag":0,"Itemtype":"geekbuyingpl","CusEmail":"bozenaheler0@gmail.com","CCityCode":null,"HouseNumber":"30","Freight":"0.000000","Name":"DPD","RPayMethod":"PP-Creditcard","transaction_id":"25V80524LC738212V"},"CODetails":[{"ProductCode":"7760","ProductName":"Składana hulajnoga elektryczna Ausom L1, silnik 800W, 45km\/h, bateria litowa 48V 15,6Ah, zasięg 70km, NFC","COQuantity":"1","UnitPrice":"1989.000000","itemid":"","IsGift":"0","TotalPrice":"0","MangoFlag":""}],"Token":"sUClZO1mtUK38hGUrjsg"} 2025/10/28 0:00:05 api生成订单开始：F20251028004，G19083885 2025/10/28 0:00:05 api生成订单结束：F20251028004，G19083885 2025/10/28 0:01:02 api生成订单开始：F20251028006，G19083780 2025/10/28 0:01:02 api生成订单结束：F20251028006，G19083780 2025/10/28 0:05:03 api生成订单开始：F20251028013，U25102713023932 2025/10/28 0:05:03 api生成订单结束：F20251028013，U25102713023932 2025/10/28 0:05:04 api生成订单开始：F20251028014，U25102713051194 2025/10/28 0:05:04 api生成订单结束：F20251028014，U25102713051194 2025/10/28 0:05:05 api生成订单开始：F20251028015，U25102713151988 2025/10/28 0:05:05 api生成订单结束：F20251028015，U25102713151988 2025/10/28 0:05:08 api生成订单开始：F20251028017，U25102713204577 2025/10/28 0:05:09 api生成订单结束：F20251028017，U25102713204577 2025/10/28 0:05:10 api生成订单开始：F20251028018，U25102713441086 2025/10/28 0:05:10 api生成订单结束：F20251028018，U25102713441086 2025/10/28 0:05:11 api生成订单开始：F20251028019，U25102713454323 2025/10/28 0:05:12 api生成订单结束：F20251028019，U25102713454323 2025/10/28 0:05:13 api生成订单开始：F20251028020，U25102713551887 2025/10/28 0:05:14 api生成订单结束：F20251028020，U25102713551887 2025/10/28 0:05:15 api生成订单开始：F20251028021，U25102714381257 2025/10/28 0:05:15 api生成订单结束：F20251028021，U25102714381257 2025/10/28 0:05:16 api生成订单开始：F20251028022，U25102714374381 2025/10/28 0:05:17 api生成订单结束：F20251028022，U25102714374381 2025/10/28 0:05:18 api生成订单开始：F20251028023，U25102714421089 2025/10/28 0:05:18 api生成订单结束：F20251028023，U25102714421089 2025/10/28 0:05:19 api生成订单开始：F20251028024，U25102714470326 2025/10/28 0:05:19 api生成订单结束：F20251028024，U25102714470326 2025/10/28 0:05:21 api生成订单开始：F20251028025，U25102715165449 2025/10/28 0:05:21 api生成订单结束：F20251028025，U25102715165449 2025/10/28 0:05:23 api生成订单开始：F20251028026，U25102715174326 2025/10/28 0:05:23 api生成订单结束：F20251028026，U25102715174326 2025/10/28 0:05:25 api生成订单开始：F20251028027，U25102715374961 2025/10/28 0:05:25 api生成订单结束：F20251028027，U25102715374961 2025/10/28 0:05:27 api生成订单开始：F20251028028，U25102715420466 2025/10/28 0:05:27 api生成订单结束：F20251028028，U25102715420466 2025/10/28 0:05:28 api生成订单开始：F20251028029，U25102715493566 2025/10/28 0:05:28 api生成订单结束：F20251028029，U25102715493566 2025/10/28 0:05:30 api生成订单开始：F20251028030，U25102715554482 2025/10/28 0:05:30 api生成订单结束：F20251028030，U25102715554482 2025/10/28 0:05:31 api生成订单开始：F20251028031，U25102716010371 2025/10/28 0:05:31 api生成订单结束：F20251028031，U25102716010371 2025/10/28 0:05:33 api生成订单开始：F20251028032，U25102716031528 2025/10/28 0:05:33 api生成订单结束：F20251028032，U25102716031528 2025/10/28 0:05:34 api生成订单开始：F20251028033，U25102716164545 2025/10/28 0:05:34 api生成订单结束：F20251028033，U25102716164545 2025/10/28 0:05:35 api生成订单开始：F20251028034，U25102716173329 2025/10/28 0:05:36 api生成订单结束：F20251028034，U25102716173329 2025/10/28 0:05:37 api生成订单开始：F20251028035，U25102716184466 2025/10/28 0:05:37 api生成订单结束：F20251028035，U25102716184466 2025/10/28 0:05:38 api生成订单开始：F20251028036，U25102716335560 2025/10/28 0:05:38 api生成订单结束：F20251028036，U25102716335560 2025/10/28 0:10:11 api生成订单开始：F20251028042，K25102769830391 2025/10/28 0:10:12 api生成订单结束：F20251028042，K25102769830391 2025/10/28 0:10:18 api生成订单开始：F20251028043，K25102759030394 2025/10/28 0:10:18 api生成订单结束：F20251028043，K25102759030394 2025/10/28 0:10:22 api生成订单开始：F20251028045，K25102759030397 2025/10/28 0:10:23 api生成订单结束：F20251028045，K25102759030397 2025/10/28 0:10:26 api生成订单开始：F20251028046，K25102756530399 2025/10/28 0:10:27 api生成订单结束：F20251028046，K25102756530399 2025/10/28 0:10:30 api生成订单开始：F20251028047，K25102716630400 2025/10/28 0:10:31 api生成订单结束：F20251028047，K25102716630400 2025/10/28 0:10:33 api生成订单开始：F20251028048，K25102773330402 2025/10/28 0:10:34 api生成订单结束：F20251028048，K25102773330402 2025/10/28 0:10:37 api生成订单开始：F20251028049，K25102785530403 2025/10/28 0:10:38 api生成订单结束：F20251028049，K25102785530403 2025/10/28 1:00:02 api生成订单开始：F20251028088，G19084270 2025/10/28 1:00:02 api生成订单结束：F20251028088，G19084270 2025/10/28 1:00:06 api生成订单开始：F20251028089，G19083903 2025/10/28 1:00:07 api生成订单结束：F20251028089，G19083903 2025/10/28 2:00:05 api生成订单开始：F20251028151，G19084553 2025/10/28 2:00:05 api生成订单结束：F20251028151，G19084553 2025/10/28 2:00:11 api生成订单开始：F20251028152，G19084425 2025/10/28 2:00:11 api生成订单结束：F20251028152，G19084425 2025/10/28 2:00:19 api生成订单开始：F20251028153，G19084364 2025/10/28 2:00:20 api生成订单结束：F20251028153，G19084364 2025/10/28 3:00:02 api生成订单开始：F20251028237，T25102718014823 2025/10/28 3:00:03 api生成订单开始：F20251028238，G19084776 2025/10/28 3:00:03 api生成订单结束：F20251028238，G19084776 2025/10/28 3:00:03 api生成订单结束：F20251028237，T25102718014823 2025/10/28 3:00:03 api生成订单开始：F20251028239，N2510271720301 2025/10/28 3:00:03 api生成订单结束：F20251028239，N2510271720301 2025/10/28 3:00:06 api生成订单开始：F20251028240，G19084677 2025/10/28 3:00:07 api生成订单结束：F20251028240，G19084677 2025/10/28 3:08:05 api生成订单开始：F20251028248，KPT25102735226591 2025/10/28 3:08:05 api生成订单结束：F20251028248，KPT25102735226591 2025/10/28 4:00:01 api生成订单开始：F20251028299，G19085321 2025/10/28 4:00:01 api生成订单结束：F20251028299，G19085321 2025/10/28 4:10:04 api生成订单开始：F20251028321，K25102717330404 2025/10/28 4:10:05 api生成订单结束：F20251028321，K25102717330404 2025/10/28 4:10:07 api生成订单开始：F20251028322，K25102752130405 2025/10/28 4:10:07 api生成订单结束：F20251028322，K25102752130405 2025/10/28 4:10:09 api生成订单开始：F20251028323，K25102770430406 2025/10/28 4:10:09 api生成订单结束：F20251028323，K25102770430406 2025/10/28 4:10:10 api生成订单开始：F20251028324，K25102718330407 2025/10/28 4:10:10 api生成订单结束：F20251028324，K25102718330407 2025/10/28 4:10:12 api生成订单开始：F20251028326，K25102733630408 2025/10/28 4:10:12 api生成订单结束：F20251028326，K25102733630408 2025/10/28 4:10:13 api生成订单开始：F20251028327，K25102731630409 2025/10/28 4:10:13 api生成订单结束：F20251028327，K25102731630409 2025/10/28 4:10:14 api生成订单开始：F20251028328，K25102747630410 2025/10/28 4:10:14 api生成订单结束：F20251028328，K25102747630410 2025/10/28 4:10:16 api生成订单开始：F20251028329，K25102756430412 2025/10/28 4:10:16 api生成订单结束：F20251028329，K25102756430412 2025/10/28 4:10:18 api生成订单开始：F20251028330，K25102735630414 2025/10/28 4:10:18 api生成订单结束：F20251028330，K25102735630414 2025/10/28 4:10:20 api生成订单开始：F20251028331，K25102740630415 2025/10/28 4:10:20 api生成订单结束：F20251028331，K25102740630415 2025/10/28 4:10:22 api生成订单开始：F20251028332，K25102753330416 2025/10/28 4:10:22 api生成订单结束：F20251028332，K25102753330416 2025/10/28 5:00:02 api生成订单开始：F20251028381，G19085650 2025/10/28 5:00:02 api生成订单结束：F20251028381，G19085650 2025/10/28 5:00:09 api生成订单开始：F20251028383，TES25102735516926 2025/10/28 5:00:09 api生成订单结束：F20251028383，TES25102735516926 2025/10/28 6:00:01 api生成订单开始：F20251028445，D2510272014201 2025/10/28 6:00:01 api生成订单开始：F20251028446，G19086373 2025/10/28 6:00:01 api生成订单结束：F20251028445，D2510272014201 2025/10/28 6:00:01 api生成订单结束：F20251028446，G19086373 2025/10/28 6:00:02 api生成订单开始：F20251028447，T25102719595787 2025/10/28 6:00:02 用户：admin，订单号：F20251028445执行开始执行审单流程，操作类型：服务自动审单 2025/10/28 6:00:02 api生成订单结束：F20251028447，T25102719595787 2025/10/28 6:00:08 api生成订单开始：F20251028450，D2510272235674 2025/10/28 6:00:09 api生成订单结束：F20251028450，D2510272235674 2025/10/28 6:00:11 api生成订单开始：F20251028451，T25102722092197 2025/10/28 6:00:11 api生成订单结束：F20251028451，T25102722092197 2025/10/28 6:00:12 api生成订单开始：F20251028452，G19085768 2025/10/28 6:00:12 api生成订单结束：F20251028452，G19085768 2025/10/28 6:00:21 api生成订单开始：F20251028453，T25102722334638 2025/10/28 6:00:21 api生成订单结束：F20251028453，T25102722334638 2025/10/28 8:05:02 api生成订单开始：F20251028557，U25102721410381 2025/10/28 8:05:03 api生成订单结束：F20251028557，U25102721410381 2025/10/28 8:05:04 api生成订单开始：F20251028558，U25102721545521 2025/10/28 8:05:05 api生成订单结束：F20251028558，U25102721545521 2025/10/28 8:05:07 api生成订单开始：F20251028559，305-3552086-2349137 2025/10/28 8:05:07 api生成订单结束：F20251028559，305-3552086-2349137 2025/10/28 8:05:10 api生成订单开始：F20251028560，406-5986869-6043517 2025/10/28 8:05:10 api生成订单结束：F20251028560，406-5986869-6043517 2025/10/28 8:05:13 api生成订单开始：F20251028561，202-0967798-9585935 2025/10/28 8:05:13 api生成订单结束：F20251028561，202-0967798-9585935 2025/10/28 8:05:15 api生成订单开始：F20251028562，205-1982505-9336358 2025/10/28 8:05:15 api生成订单结束：F20251028562，205-1982505-9336358 2025/10/28 8:05:20 api生成订单开始：F20251028563，204-1608855-1716333 2025/10/28 8:05:20 api生成订单结束：F20251028563，204-1608855-1716333 2025/10/28 8:05:25 api生成订单开始：F20251028564，407-4767469-6365942 2025/10/28 8:05:25 api生成订单结束：F20251028564，407-4767469-6365942 2025/10/28 8:05:28 api生成订单开始：F20251028565，204-9615996-1612350 2025/10/28 8:05:28 api生成订单结束：F20251028565，204-9615996-1612350 2025/10/28 8:05:31 api生成订单开始：F20251028566，302-3369655-0853125 2025/10/28 8:05:31 api生成订单结束：F20251028566，302-3369655-0853125 2025/10/28 8:05:35 api生成订单开始：F20251028567，205-8651696-5333949 2025/10/28 8:05:36 api生成订单结束：F20251028567，205-8651696-5333949 2025/10/28 8:05:45 api生成订单开始：F20251028568，403-6730345-5107552 2025/10/28 8:05:45 api生成订单结束：F20251028568，403-6730345-5107552 2025/10/28 8:05:47 api生成订单开始：F20251028569，202-6251690-8417156 2025/10/28 8:05:47 api生成订单结束：F20251028569，202-6251690-8417156 2025/10/28 8:05:49 api生成订单开始：F20251028570，028-0105830-1998725 2025/10/28 8:05:50 api生成订单结束：F20251028570，028-0105830-1998725 2025/10/28 8:05:52 api生成订单开始：F20251028571，403-4834304-7814738 2025/10/28 8:05:52 api生成订单结束：F20251028571，403-4834304-7814738 2025/10/28 8:05:57 api生成订单开始：F20251028572，403-3989667-8980321 2025/10/28 8:05:57 api生成订单结束：F20251028572，403-3989667-8980321 2025/10/28 8:05:59 api生成订单开始：F20251028573，205-6631490-9472319 2025/10/28 8:05:59 api生成订单结束：F20251028573，205-6631490-9472319 2025/10/28 8:06:02 api生成订单开始：F20251028574，405-3162377-0037120 2025/10/28 8:06:02 api生成订单结束：F20251028574，405-3162377-0037120 2025/10/28 8:06:04 api生成订单开始：F20251028575，203-4179259-7916356 2025/10/28 8:06:04 api生成订单结束：F20251028575，203-4179259-7916356 2025/10/28 8:06:08 api生成订单开始：F20251028576，306-5910033-0685949 2025/10/28 8:06:08 api生成订单结束：F20251028576，306-5910033-0685949 2025/10/28 8:06:12 api生成订单开始：F20251028577，302-8940208-4469144 2025/10/28 8:06:12 api生成订单结束：F20251028577，302-8940208-4469144 2025/10/28 8:06:16 api生成订单开始：F20251028578，408-7195058-0163564 2025/10/28 8:06:16 api生成订单结束：F20251028578，408-7195058-0163564 2025/10/28 8:06:23 api生成订单开始：F20251028579，304-9765047-3905902 2025/10/28 8:06:23 api生成订单结束：F20251028579，304-9765047-3905902 2025/10/28 8:06:26 api生成订单开始：F20251028580，406-9359750-8453126 2025/10/28 8:06:26 api生成订单结束：F20251028580，406-9359750-8453126 2025/10/28 8:06:29 api生成订单开始：F20251028581，171-6491805-5332323 2025/10/28 8:06:29 api生成订单结束：F20251028581，171-6491805-5332323 2025/10/28 8:06:34 api生成订单开始：F20251028582，406-4463017-4405149 2025/10/28 8:06:34 api生成订单结束：F20251028582，406-4463017-4405149 2025/10/28 8:06:39 api生成订单开始：F20251028583，171-8488731-0746754 2025/10/28 8:06:39 api生成订单结束：F20251028583，171-8488731-0746754 2025/10/28 8:06:42 api生成订单开始：F20251028584，302-4156005-2646711 2025/10/28 8:06:42 api生成订单结束：F20251028584，302-4156005-2646711 2025/10/28 8:06:45 api生成订单开始：F20251028585，408-8419593-5014762 2025/10/28 8:06:46 api生成订单结束：F20251028585，408-8419593-5014762 2025/10/28 8:06:52 api生成订单开始：F20251028586，113-6590608-7186627 2025/10/28 8:06:52 api生成订单结束：F20251028586，113-6590608-7186627 2025/10/28 8:06:54 api生成订单开始：F20251028587，406-2817387-5156365 2025/10/28 8:06:54 api生成订单结束：F20251028587，406-2817387-5156365 2025/10/28 8:06:56 api生成订单开始：F20251028588，028-1439215-9106703 2025/10/28 8:06:56 api生成订单结束：F20251028588，028-1439215-9106703 2025/10/28 8:06:59 api生成订单开始：F20251028589，305-3485167-7120344 2025/10/28 8:06:59 api生成订单结束：F20251028589，305-3485167-7120344 2025/10/28 8:07:00 api生成订单开始：F20251028590，405-4039531-1318769 2025/10/28 8:07:00 api生成订单结束：F20251028590，405-4039531-1318769 2025/10/28 8:10:04 api生成订单开始：F20251028594，K25102721530417 2025/10/28 8:10:05 api生成订单结束：F20251028594，K25102721530417 2025/10/28 8:15:04 api生成订单开始：F20251028599，EL2510276368132 2025/10/28 8:15:04 api生成订单结束：F20251028599，EL2510276368132 2025/10/28 8:17:13 api生成订单开始：F20251028601，AUS25102712717408 2025/10/28 8:17:14 api生成订单结束：F20251028601，AUS25102712717408 2025/10/28 8:17:15 api生成订单开始：F20251028602，AUS25102710317409 2025/10/28 8:17:15 api生成订单结束：F20251028602，AUS25102710317409 2025/10/28 8:17:16 api生成订单开始：F20251028603，AUS25102715017410 2025/10/28 8:17:16 api生成订单结束：F20251028603，AUS25102715017410 2025/10/28 8:17:18 api生成订单开始：F20251028604，AUS25102797717411 2025/10/28 8:17:18 api生成订单结束：F20251028604，AUS25102797717411 2025/10/28 8:20:08 api生成订单开始：F20251028611，ES25102758827678 2025/10/28 8:20:08 api生成订单结束：F20251028611，ES25102758827678 2025/10/28 8:20:09 api生成订单开始：F20251028612，ES25102764127679 2025/10/28 8:20:10 api生成订单结束：F20251028612，ES25102764127679 2025/10/28 8:20:12 api生成订单开始：F20251028613，ES25102735327680 2025/10/28 8:20:12 api生成订单结束：F20251028613，ES25102735327680 2025/10/28 9:30:01 消息确认完成，自动销毁 2025/10/28 9:30:01 ========================ReceiveEnd======================== 2025/10/28 9:30:01 PackageSyncFromOMSToWMS UpdateElasticsearchOrder 订单："F20251024241"异常：{"Status":500,"Msg":"System.Exception: \r\n if OBJECT_ID('tempdb.dbo.#tmp') is not null\r\n begin\r\n \tdrop table #tmp;\r\n end\r\n\r\n select * into #tmp from(\r\n select ROW_NUMBER() over(order by inputtime) rowid,t.FulfillmentChannel,p.RecordId platformid,p.PlatformName platform,a.RecordId accountid,a.Accounts account,a.TenantCode TenantCode,a.IsApplyInvoice,t.HoldOn,t.TotalPrice,t.Name,t.OrderSourceType,t.[InputTime],t.InputUserID,t.statetime,t.OrderRemark,t.COID,t.CContact,t.OrderDate,t.Creator,t.StoreManager,t.CreatedDate,t.RPayMethod,t.Email,t.GoodsTotalSalesAmount,t.AdjustThePriceOfGoods,t.Freight,t.AdjustTheShippingFee,t.CurrencyShorts,t.OrderType,t.[PONo],t.PARecordID,t.costate,t.SalesType,t.ApprovalStatus,t.CCountry,t.IsSubOrder from SinadealTradeDB..tdCOMain t with(nolock)\r\n inner join ServiceCenter..PlatformAccounts a with(nolock) on t.PARecordID = a.RecordId\r\n inner join ServiceCenter..Platform p with(nolock) on p.RecordId = a.PlatformId \r\n where 1=1 and t.COID in ('F20251024241')\r\n ) t where t.rowid between 0 and 30000\r\n\r\n select \r\n rowid,t.platformid,t.platform,t.accountid,t.account,t.TenantCode,b1.[Value] costateid,b1.[Key] as costate,b2.[Value] saletypeid,b2.[Key] as saletype\r\n \t,t.HoldOn holdonid,(case when t.HoldOn=0 then '未冻结' else '已冻结' end) holdon,t.TotalPrice,c.Code countryid,c.CNDesc country,t.Name nameid,t.Name name\r\n \t,(case when (ISNULL(b3.[Value],'')='' or b3.[Value]=0) then 1 else b3.[Value] end) approvalStatusid,(case when ISNULL(b3.[Value],'')='' then '未提交审批' else b3.[key] end) approvalStatus\r\n \t,t.OrderSourceType ordersourcetypeid,(case t.OrderSourceType when 1 then 'API对接' when 2 then '订单手动录入' when 3 then '补单录入' when 4 then '返修重发' when 5 then 'EXECl导入' when 6 then '海外补货'end) ordersourcetype,t.[InputTime],t.statetime\r\n \t,o.[Value] ordertagid,o.[Key] ordertag\r\n \t,stuff(\r\n \t(\r\n\t \tselect DISTINCT\r\n\t \t'@'\r\n\t \t+CAST(r.PackageID as varchar(10))\r\n\t \t+'#'\r\n\t \t+fpd.DepartureNO \r\n\t \t+'#'\r\n\t \t+(case when ISNULL(r.WmsState,'')='' then '0' else CAST(r.WmsState as varchar(5)) end) \r\n\t \t+'#'\r\n\t \t+(case r.WmsState when null then '未上传' when 0 then '未上传' when 1 then '已上传' when 2 then '已发运' when 3 then '冻结' when 4 then '解冻' when 5 then '已取消' end)\r\n\t \t+'#'\r\n\t \t+(case when ISNULL(fpsr .ShipDate,'')='' then '' else CAST(fpsr .ShipDate as varchar(20)) end) \r\n\t \t+'#'\r\n\t \t+(case when ISNULL(rr.[Message] ,'')='' then '' else REPLACE(rr.[Message],'#','') end) \r\n\t \tfrom SinadealTradeDB.dbo.FMS_Package r with(nolock) \r\n \t\tleft join SinadealTradeDB.dbo.FMS_PackageDetail fpd on r.PackageID = fpd .PackageID \r\n \t\tleft join SinadealTradeDB.dbo.FMS_PackageShipRecord fpsr on r.PackageID = fpsr .PackageID \r\n \t\tleft join pdsys.dbo.RecordProductReplace rr on rr.InfoID = r.PackageID\r\n \t\twhere r.Coids =t.COID \r\n \t\tfor xml path('')\r\n \t\t),1,1,'') PackageInfoVM\r\n \t,stuff(\r\n \t(\r\n\t \tselect DISTINCT\r\n\t \t'@'\r\n\t \t+td.DepartureNO\r\n\t \tfrom SinadealTradeDB.dbo.tdCODetail td with(nolock) where td.COID =t.COID \r\n \t\tfor xml path('')\r\n \t\t),1,1,'') DepartureNOs\r\n \t,y.InputUser inputuser,t.InputUserID inputuserid\r\n \t,(case when ISNULL(t.OrderRemark,'')='' then 0 else 1 end) orderremarkid,(case when ISNULL(t.OrderRemark,'')='' then '无备注' else t.OrderRemark end) orderremark,t.CContact ccontact\r\n \t,holdonreason=stuff((select '；'+r.HoldonType+':'+r.Remark from SinadealTradeDB.dbo.OrderHoldonReason r with(nolock) where r.Coid=t.COID for xml path('')),1,1,'')\r\n\t\t\t,ProductBrandStr=stuff((select ','+b.BrandEName\r\n from SinadealTradeDB..tdCODetail td\r\n inner join PDSYS..tProduct p on cast(p.ProductId as varchar(50))=td.ProductCode\r\n inner join ServiceCenter..Brand b on b.Id=p.BrandId and b.Valid=1 \r\n where td.Coid=t.COID and td.COQuantity>0 group by b.BrandEName for xml path('')),1,1,'')\r\n ,OrderRemarkStr=(select bc.[Key]\r\n from SinadealTradeDB.dbo.OrderHoldonReason hr\r\n inner join ServiceCenter..BasicDataConfig bc on bc.[Value]=hr.ReasonId and [Type]='OrderHoldReason' and bc.Valid=1\r\n where hr.HoldonType='冻结' and hr.Coid=t.COID),t.OrderRemark OrderRemarkStr1\r\n \t,t.OrderDate orderdate,t.Creator creator,t.StoreManager storemanager,t.CreatedDate createddate,t.RPayMethod rpaymethod,t.Email email,t.GoodsTotalSalesAmount goodstotalsalesamount,t.AdjustThePriceOfGoods adjustthepriceofgoods,t.Freight freight,t.AdjustTheShippingFee adjusttheshippingfee,t.CurrencyShorts currencyshorts\r\n \t,(case t.OrderType when 0 then '普通订单' when 1 then '补发订单' when 2 then '返修订单' when 3 then '调拨订单' when 4 then '样品订单' end) ordertype,t.OrderType ordertypeid\r\n \t,t.[COID],[PONo]\r\n ,a.ToExamineOrderResult ruletypeid,(case when a.ToExamineOrderResult=1 then '自动下单' else '人工审核' end) ruletype,a.CauseOfAuditFailure causeofauditfailure,oa.[Status] OrderAfterSaleStatus,t.* \r\n from #tmp t\r\n left join ServiceCenter..BasicDataConfig b1 with(nolock) on t.costate = b1.value and b1.type='OrderCOState'\r\n \tleft join ServiceCenter..BasicDataConfig b2 with(nolock) on t.SalesType = b2.value and b2.type='SaleType'\r\n \tleft join ServiceCenter..BasicDataConfig b3 with(nolock) on t.ApprovalStatus = b3.value and b3.type='OrderApprovalStatus'\r\n \tleft join ServiceCenter..Country c with(nolock) on t.CCountry=c.Code\r\n \tleft join(\r\n \t\tselect tg.COID,b.* from SinadealTradeDB..OrderTags tg with(nolock)\r\n \t\tinner join ServiceCenter..BasicDataConfig b with(nolock) on tg.Tag=b.Value and b.Type='OrderTag'\r\n \t) o on t.COID=o.COID\r\n \tleft join ServiceCenter..YS_ItemMall y with(nolock) on t.PARecordID=y.PARecordId\r\n left join SinadealTradeDB.dbo.AutomaticToExamineOrderRecord a with(nolock) on t.PONo=a.OrderId\r\n left join (select distinct OrderId,Status from SinadealTradeDB..OrderAfterSale where [Status]=0) oa on oa.OrderId=t.PONo无法继续执行，因为会话处于终止状态。\r\n当前命令发生了严重错误。应放弃任何可能产生的结果。\r\n 在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\\Jenkins\\.jenkins\\workspace\\OMS_Master_WebSite\\src\\Core\\Common\\Vayava.Common\\DBUtility\\DbHelperSQL.cs:行号 435\r\n 在 Vayava.Erp.Dal.InputOrderService.InitElasticsearchOrders(String baseQql, Int32 page, Int32 limit) 位置 E:\\Jenkins\\.jenkins\\workspace\\OMS_Master_WebSite\\src\\Core\\ERP\\ERP.Service.DataAccess\\Vayava.Erp.Dal\\Order\\InputOrderService.cs:行号 12708\r\n 在 Vayava.Erp.Bll.InputOrderManager.InitElasticsearchOrders(String baseQql, Int32 page, Int32 limit) 位置 E:\\Jenkins\\.jenkins\\workspace\\OMS_Master_WebSite\\src\\Core\\ERP\\ERP.Service.DataAccess\\Vayava.Erp.Bll\\Order\\InputOrderManager.cs:行号 9551\r\n 在 CalculateFreightAPI.Controllers.ElasticsearchController.CreateOrderPrivate(CreateOrderParam parameter, String type) 位置 E:\\Jenkins\\.jenkins\\workspace\\OMS_Master_WebSite\\src\\PDSys\\WebService\\CalculateFreightAPI\\Controllers\\ElasticsearchController.cs:行号 1698","Result":null} 2025/10/28 12:00:02 api生成订单开始：F202510281184，G19086516 2025/10/28 12:00:02 api生成订单结束：F202510281184，G19086516 2025/10/28 12:00:05 api生成订单开始：F202510281185，G19086416 2025/10/28 12:00:06 api生成订单结束：F202510281185，G19086416 2025/10/28 16:00:05 api生成订单开始：F202510281384，G19087223 2025/10/28 16:00:05 api生成订单结束：F202510281384，G19087223 2025/10/28 16:00:11 api生成订单开始：F202510281385，G19087114 2025/10/28 16:00:11 api生成订单结束：F202510281385，G19087114 2025/10/28 16:00:19 api生成订单开始：F202510281387，G19086908 2025/10/28 16:00:20 api生成订单结束：F202510281387，G19086908 2025/10/28 16:00:33 api生成订单开始：F202510281388，G19086847 2025/10/28 16:00:34 api生成订单结束：F202510281388，G19086847 2025/10/28 16:08:05 api生成订单开始：F202510281401，KPT25102897626594 2025/10/28 16:08:05 api生成订单结束：F202510281401，KPT25102897626594 2025/10/28 16:10:04 api生成订单开始：F202510281403，K25102814430427 2025/10/28 16:10:04 api生成订单结束：F202510281403，K25102814430427 2025/10/28 18:00:02 api生成订单开始：F202510281675，D2510280926520 2025/10/28 18:00:02 api生成订单开始：F202510281676，T25102809253261 2025/10/28 18:00:02 api生成订单结束：F202510281675，D2510280926520 2025/10/28 18:00:02 api生成订单结束：F202510281676，T25102809253261 2025/10/28 18:00:11 api生成订单开始：F202510281677，T25102810191761 2025/10/28 18:00:12 api生成订单结束：F202510281677，T25102810191761 2025/10/28 18:00:14 api生成订单开始：F202510281678，N2510280913127 2025/10/28 18:00:14 api生成订单结束：F202510281678，N2510280913127 2025/10/28 18:00:23 api生成订单开始：F202510281679，S2510281028680 2025/10/28 18:00:23 api生成订单结束：F202510281679，S2510281028680 2025/10/28 19:00:02 api生成订单开始：F202510281785，G19087381 2025/10/28 19:00:03 api生成订单结束：F202510281785，G19087381 2025/10/28 20:00:02 api生成订单开始：F202510281856，G19087559 2025/10/28 20:00:02 api生成订单结束：F202510281856，G19087559 2025/10/28 20:05:02 api生成订单开始：F202510281867，U25102809325992 2025/10/28 20:05:03 api生成订单结束：F202510281867，U25102809325992 2025/10/28 20:05:04 api生成订单开始：F202510281868，U25102811582174 2025/10/28 20:05:04 api生成订单结束：F202510281868，U25102811582174 2025/10/28 20:08:04 api生成订单开始：F202510281870，KPT25102848826612 2025/10/28 20:08:04 api生成订单结束：F202510281870，KPT25102848826612 2025/10/28 20:10:06 api生成订单开始：F202510281874，K25102812930428 2025/10/28 20:10:06 api生成订单结束：F202510281874，K25102812930428 2025/10/28 20:10:08 api生成订单开始：F202510281875，K25102821630430 2025/10/28 20:10:08 api生成订单结束：F202510281875，K25102821630430 2025/10/28 20:10:10 api生成订单开始：F202510281876，K25102826130431 2025/10/28 20:10:10 api生成订单结束：F202510281876，K25102826130431 2025/10/28 20:10:11 api生成订单开始：F202510281877，K25102842430432 2025/10/28 20:10:12 api生成订单结束：F202510281877，K25102842430432 2025/10/28 20:10:14 api生成订单开始：F202510281878，K25102847230434 2025/10/28 20:10:14 api生成订单结束：F202510281878，K25102847230434 2025/10/28 21:00:02 api生成订单开始：F202510281916，D2510281334631 2025/10/28 21:00:02 api生成订单结束：F202510281916，D2510281334631 2025/10/28 21:00:02 api生成订单开始：F202510281917，T25102811154390 2025/10/28 21:00:03 api生成订单结束：F202510281917，T25102811154390 2025/10/28 21:00:06 api生成订单开始：F202510281918，T25102812333355 2025/10/28 21:00:06 api生成订单结束：F202510281918，T25102812333355 2025/10/28 21:00:08 api生成订单开始：F202510281919，T25102813255728 2025/10/28 21:00:08 api生成订单结束：F202510281919，T25102813255728 2025/10/28 22:00:06 api生成订单开始：F202510281958，G19087690 2025/10/28 22:00:06 api生成订单结束：F202510281958，G19087690