2025/11/16 0:00:06 api生成订单开始：F20251116001，D2511151516449 2025/11/16 0:00:06 api生成订单开始：F20251116001，G19202737 2025/11/16 0:00:06 api生成订单开始：F20251116001，T25111515152082 2025/11/16 0:00:07 api生成订单结束：F20251116001，D2511151516449 2025/11/16 0:00:07 api生成订单结束：F20251116001，G19202737 2025/11/16 0:00:07 api生成订单结束：F20251116001，T25111515152082 2025/11/16 0:00:19 api生成订单开始：F20251116002，G19186184 2025/11/16 0:00:23 api生成订单结束：F20251116002，G19186184 2025/11/16 0:01:03 api生成订单开始：F20251116003，D2511151526324 2025/11/16 0:01:03 api生成订单开始：F20251116004，D2511151526324 2025/11/16 0:01:03 PackageSyncFromOMSToWMS UpdateElasticsearchOrder 订单："F20251116004"异常：{"Status":200,"Msg":"没有符合条件的订单，请检查传递参数","Result":null} 2025/11/16 0:01:03 api生成订单结束：F20251116004，D2511151526324 2025/11/16 0:01:04 api生成订单结束：F20251116003，D2511151526324 2025/11/16 0:01:08 api生成订单开始：F20251116005，N2511151602543 2025/11/16 0:01:09 api生成订单结束：F20251116005，N2511151602543 2025/11/16 0:10:20 api生成订单开始：F20251116020，K25111530131046 2025/11/16 0:10:21 api生成订单结束：F20251116020，K25111530131046 2025/11/16 0:10:37 api生成订单开始：F20251116021，K25111598231048 2025/11/16 0:10:40 api生成订单结束：F20251116021，K25111598231048 2025/11/16 0:10:45 api生成订单开始：F20251116022，K25111560531053 2025/11/16 0:10:46 api生成订单结束：F20251116022，K25111560531053 2025/11/16 0:10:54 api生成订单开始：F20251116023，K25111520231054 2025/11/16 0:10:55 api生成订单结束：F20251116023，K25111520231054 2025/11/16 0:11:00 api生成订单开始：F20251116024，K25111575331055 2025/11/16 0:11:01 api生成订单结束：F20251116024，K25111575331055 2025/11/16 0:11:08 api生成订单开始：F20251116025，K25111515131056 2025/11/16 0:11:09 api生成订单结束：F20251116025，K25111515131056 2025/11/16 0:11:17 api生成订单开始：F20251116026，K25111561231057 2025/11/16 0:11:19 api生成订单结束：F20251116026，K25111561231057 2025/11/16 0:15:18 api生成订单开始：F20251116033，EL2511158358230 2025/11/16 0:15:20 api生成订单结束：F20251116033，EL2511158358230 2025/11/16 0:15:31 api生成订单开始：F20251116034，EL2511157548231 2025/11/16 0:15:33 api生成订单结束：F20251116034，EL2511157548231 2025/11/16 0:17:33 api生成订单开始：F20251116035，AUS25111514117641 2025/11/16 0:17:34 api生成订单结束：F20251116035，AUS25111514117641 2025/11/16 1:00:13 api生成订单开始：F20251116101，G19203594 2025/11/16 1:00:16 api生成订单结束：F20251116101，G19203594 2025/11/16 1:01:06 api生成订单开始：F20251116103，G19202737 2025/11/16 1:01:08 api生成订单结束：F20251116103，G19202737 2025/11/16 1:01:30 api生成订单开始：F20251116102，G19202737 2025/11/16 1:01:30 api生成订单结束：F20251116102，G19202737 2025/11/16 1:01:30 PackageSyncFromOMSToWMS UpdateElasticsearchOrder 订单："F20251116102"异常：{"Status":200,"Msg":"没有符合条件的订单，请检查传递参数","Result":null} 2025/11/16 2:00:19 api生成订单开始：F20251116118，G19204322 2025/11/16 2:00:22 api生成订单结束：F20251116118，G19204322 2025/11/16 2:00:36 api生成订单开始：F20251116119，G19204197 2025/11/16 2:00:37 api生成订单结束：F20251116119，G19204197 2025/11/16 2:00:52 api生成订单开始：F20251116120，G19204033 2025/11/16 2:00:54 api生成订单结束：F20251116120，G19204033 2025/11/16 2:01:06 api生成订单开始：F20251116121，G19203805 2025/11/16 2:01:08 api生成订单结束：F20251116121，G19203805 2025/11/16 2:01:19 api生成订单开始：F20251116122，G19203697 2025/11/16 2:01:20 api生成订单结束：F20251116122，G19203697 2025/11/16 2:08:06 api生成订单开始：F20251116123，KPT25111547626741 2025/11/16 2:08:06 api生成订单结束：F20251116123，KPT25111547626741 2025/11/16 3:00:08 api生成订单开始：F20251116125，G19204629 2025/11/16 3:00:08 api生成订单开始：F20251116124，D2511151856264 2025/11/16 3:00:08 api生成订单开始：F20251116126，T25111515152082 2025/11/16 3:00:09 api生成订单结束：F20251116126，T25111515152082 2025/11/16 3:00:09 api生成订单结束：F20251116125，G19204629 2025/11/16 3:00:09 api生成订单结束：F20251116124，D2511151856264 2025/11/16 3:00:32 api生成订单开始：F20251116127，T25111517052149 2025/11/16 3:00:35 api生成订单结束：F20251116127，T25111517052149 2025/11/16 3:00:39 api生成订单开始：F20251116128，G19204554 2025/11/16 3:00:42 api生成订单结束：F20251116128，G19204554 2025/11/16 3:01:21 api生成订单开始：F20251116129，T25111517082494 2025/11/16 3:01:22 api生成订单结束：F20251116129，T25111517082494 2025/11/16 3:01:35 api生成订单开始：F20251116130，T25111517253649 2025/11/16 3:01:36 api生成订单结束：F20251116130，T25111517253649 2025/11/16 3:01:42 api生成订单开始：F20251116131，T25111517350328 2025/11/16 3:01:42 api生成订单结束：F20251116131，T25111517350328 2025/11/16 3:01:54 api生成订单开始：F20251116132，T25111518124138 2025/11/16 3:01:55 api生成订单结束：F20251116132，T25111518124138 2025/11/16 3:02:05 api生成订单开始：F20251116133，T25111519025775 2025/11/16 3:02:06 api生成订单结束：F20251116133，T25111519025775 2025/11/16 4:00:14 api生成订单开始：F20251116134，G19205186 2025/11/16 4:00:17 api生成订单结束：F20251116134，G19205186 2025/11/16 4:00:42 api生成订单开始：F20251116135，G19205070 2025/11/16 4:00:43 api生成订单结束：F20251116135，G19205070 2025/11/16 4:00:58 api生成订单开始：F20251116136，G19204953 2025/11/16 4:00:59 api生成订单结束：F20251116136，G19204953 2025/11/16 4:01:02 api生成订单开始：F20251116137，G19204811 2025/11/16 4:01:02 api生成订单结束：F20251116137，G19204811 2025/11/16 4:05:03 api生成订单开始：F20251116138，U25111518483395 2025/11/16 4:05:04 api生成订单结束：F20251116138，U25111518483395 2025/11/16 4:08:08 api生成订单开始：F20251116139，KPT25111541426742 2025/11/16 4:08:08 api生成订单结束：F20251116139，KPT25111541426742 2025/11/16 4:10:03 api生成订单开始：F20251116140，K25111566931058 2025/11/16 4:10:03 api生成订单结束：F20251116140，K25111566931058 2025/11/16 4:10:13 api生成订单开始：F20251116141，K25111582131059 2025/11/16 4:10:13 api生成订单结束：F20251116141，K25111582131059 2025/11/16 4:10:15 api生成订单开始：F20251116142，K25111518131060 2025/11/16 4:10:15 api生成订单结束：F20251116142，K25111518131060 2025/11/16 4:10:16 api生成订单开始：F20251116143，K25111528631061 2025/11/16 4:10:16 api生成订单结束：F20251116143，K25111528631061 2025/11/16 4:10:18 api生成订单开始：F20251116144，K25111575831063 2025/11/16 4:10:18 api生成订单结束：F20251116144，K25111575831063 2025/11/16 4:10:19 api生成订单开始：F20251116145，K25111538931064 2025/11/16 4:10:19 api生成订单结束：F20251116145，K25111538931064 2025/11/16 4:10:20 api生成订单开始：F20251116146，K25111529531066 2025/11/16 4:10:20 api生成订单结束：F20251116146，K25111529531066 2025/11/16 4:15:09 api生成订单开始：F20251116147，EL2511151158232 2025/11/16 4:15:10 api生成订单结束：F20251116147，EL2511151158232 2025/11/16 4:15:15 api生成订单开始：F20251116148，EL2511151528233 2025/11/16 4:15:15 api生成订单结束：F20251116148，EL2511151528233 2025/11/16 4:15:16 api生成订单开始：F20251116149，EL2511151358234 2025/11/16 4:15:16 api生成订单结束：F20251116149，EL2511151358234 2025/11/16 5:00:02 api生成订单开始：F20251116151，G19205812 2025/11/16 5:00:03 api生成订单结束：F20251116151，G19205812 2025/11/16 5:00:05 api生成订单开始：F20251116152，TES25111514416970 2025/11/16 5:00:05 api生成订单结束：F20251116152，TES25111514416970 2025/11/16 5:00:33 api生成订单开始：F20251116153，G19205781 2025/11/16 5:00:34 api生成订单结束：F20251116153，G19205781 2025/11/16 5:01:03 api生成订单开始：F20251116154，G19205619 2025/11/16 5:01:03 api生成订单开始：F20251116155，G19205619 2025/11/16 5:01:03 PackageSyncFromOMSToWMS UpdateElasticsearchOrder 订单："F20251116155"异常：{"Status":200,"Msg":"没有符合条件的订单，请检查传递参数","Result":null} 2025/11/16 5:01:03 api生成订单结束：F20251116155，G19205619 2025/11/16 5:01:04 api生成订单结束：F20251116154，G19205619 2025/11/16 5:01:06 api生成订单开始：F20251116156，G19205503 2025/11/16 5:01:06 api生成订单结束：F20251116156，G19205503 2025/11/16 5:08:05 api生成订单开始：F20251116157，KPT25111541926744 2025/11/16 5:08:05 api生成订单结束：F20251116157，KPT25111541926744 2025/11/16 6:00:04 api生成订单开始：F20251116160，G19205936 2025/11/16 6:00:04 api生成订单开始：F20251116162，D2511152223964 2025/11/16 6:00:04 api生成订单开始：F20251116162，T25111520111452 2025/11/16 6:00:05 api生成订单结束：F20251116160，G19205936 2025/11/16 6:00:05 api生成订单结束：F20251116162，D2511152223964 2025/11/16 6:00:05 api生成订单结束：F20251116162，T25111520111452 2025/11/16 6:00:06 api生成订单开始：F20251116163，T25111520563154 2025/11/16 6:00:06 api生成订单结束：F20251116163，T25111520563154 2025/11/16 6:00:53 api生成订单开始：F20251116164，D2511152247399 2025/11/16 6:00:54 api生成订单结束：F20251116164，D2511152247399 2025/11/16 6:01:03 api生成订单开始：F20251116165，N2511152227795 2025/11/16 6:01:04 api生成订单结束：F20251116165，N2511152227795 2025/11/16 6:01:19 api生成订单开始：F20251116166，S2511152124895 2025/11/16 6:01:22 api生成订单结束：F20251116166，S2511152124895 2025/11/16 6:01:38 api生成订单开始：F20251116168，S2511152136903 2025/11/16 6:01:38 api生成订单开始：F20251116167，S2511152136903 2025/11/16 6:01:38 PackageSyncFromOMSToWMS UpdateElasticsearchOrder 订单："F20251116167"异常：{"Status":200,"Msg":"没有符合条件的订单，请检查传递参数","Result":null} 2025/11/16 6:01:38 api生成订单结束：F20251116167，S2511152136903 2025/11/16 6:01:39 api生成订单结束：F20251116168，S2511152136903 2025/11/16 7:05:05 api生成订单开始：F20251116191，406-4345090-0221936 2025/11/16 7:05:05 api生成订单结束：F20251116191，406-4345090-0221936 2025/11/16 7:05:15 api生成订单开始：F20251116192，303-9315674-2249921 2025/11/16 7:05:16 api生成订单结束：F20251116192，303-9315674-2249921 2025/11/16 7:05:25 api生成订单开始：F20251116193，026-1716376-9132352 2025/11/16 7:05:25 api生成订单结束：F20251116193，026-1716376-9132352 2025/11/16 7:05:28 api生成订单开始：F20251116194，407-5134695-4853967 2025/11/16 7:05:29 api生成订单结束：F20251116194，407-5134695-4853967 2025/11/16 7:05:32 api生成订单开始：F20251116195，405-7138308-5573920 2025/11/16 7:05:33 api生成订单结束：F20251116195，405-7138308-5573920 2025/11/16 7:05:36 api生成订单开始：F20251116196，306-3428705-8428340 2025/11/16 7:05:37 api生成订单结束：F20251116196，306-3428705-8428340 2025/11/16 7:05:40 api生成订单开始：F20251116197，407-3273353-5551554 2025/11/16 7:05:40 api生成订单结束：F20251116197，407-3273353-5551554 2025/11/16 7:05:43 api生成订单开始：F20251116198，408-8841489-8152352 2025/11/16 7:05:43 api生成订单结束：F20251116198，408-8841489-8152352 2025/11/16 7:05:50 api生成订单开始：F20251116199，304-2061213-7332364 2025/11/16 7:05:50 api生成订单结束：F20251116199，304-2061213-7332364 2025/11/16 7:05:52 api生成订单开始：F20251116200，407-4391669-0831566 2025/11/16 7:05:52 api生成订单结束：F20251116200，407-4391669-0831566 2025/11/16 7:05:54 api生成订单开始：F20251116201，404-8382172-3320341 2025/11/16 7:05:55 api生成订单结束：F20251116201，404-8382172-3320341 2025/11/16 7:06:03 api生成订单开始：F20251116202，403-6785849-9785157 2025/11/16 7:06:04 api生成订单结束：F20251116202，403-6785849-9785157 2025/11/16 7:06:06 api生成订单开始：F20251116203，405-3364981-0217934 2025/11/16 7:06:07 api生成订单结束：F20251116203，405-3364981-0217934 2025/11/16 7:06:08 api生成订单开始：F20251116204，112-2949970-7230642 2025/11/16 7:06:09 api生成订单结束：F20251116204，112-2949970-7230642 2025/11/16 7:06:11 api生成订单开始：F20251116205，406-6465151-4092303 2025/11/16 7:06:11 api生成订单结束：F20251116205，406-6465151-4092303 2025/11/16 7:06:13 api生成订单开始：F20251116206，028-0143091-9505150 2025/11/16 7:06:13 api生成订单结束：F20251116206，028-0143091-9505150 2025/11/16 7:06:15 api生成订单开始：F20251116207，171-2596441-7711521 2025/11/16 7:06:15 api生成订单结束：F20251116207，171-2596441-7711521 2025/11/16 7:06:17 api生成订单开始：F20251116208，404-2514313-0916360 2025/11/16 7:06:17 api生成订单结束：F20251116208，404-2514313-0916360 2025/11/16 7:06:19 api生成订单开始：F20251116209，405-5300070-1137907 2025/11/16 7:06:19 api生成订单结束：F20251116209，405-5300070-1137907 2025/11/16 7:06:21 api生成订单开始：F20251116210，303-2407570-0599556 2025/11/16 7:06:21 api生成订单结束：F20251116210，303-2407570-0599556 2025/11/16 7:06:23 api生成订单开始：F20251116211，407-4135759-7197159 2025/11/16 7:06:23 api生成订单结束：F20251116211，407-4135759-7197159 2025/11/16 7:06:25 api生成订单开始：F20251116212，205-0300622-6848345 2025/11/16 7:06:25 api生成订单结束：F20251116212，205-0300622-6848345 2025/11/16 7:06:27 api生成订单开始：F20251116213，114-3831392-7009842 2025/11/16 7:06:27 api生成订单结束：F20251116213，114-3831392-7009842 2025/11/16 7:06:29 api生成订单开始：F20251116214，404-2583167-4421162 2025/11/16 7:06:29 api生成订单结束：F20251116214，404-2583167-4421162 2025/11/16 7:08:04 api生成订单开始：F20251116215，KPT25111540826745 2025/11/16 7:08:04 api生成订单结束：F20251116215，KPT25111540826745 2025/11/16 8:10:02 api生成订单开始：F20251116607，K25111524231067 2025/11/16 8:10:02 api生成订单结束：F20251116607，K25111524231067 2025/11/16 8:10:03 api生成订单开始：F20251116608，K25111566331068 2025/11/16 8:10:03 api生成订单结束：F20251116608，K25111566331068 2025/11/16 8:10:04 api生成订单开始：F20251116609，K25111557731070 2025/11/16 8:10:04 api生成订单结束：F20251116609，K25111557731070 2025/11/16 8:10:05 api生成订单开始：F20251116610，K25111581931071 2025/11/16 8:10:05 api生成订单结束：F20251116610，K25111581931071 2025/11/16 8:10:06 api生成订单开始：F20251116611，K25111580231072 2025/11/16 8:10:06 api生成订单结束：F20251116611，K25111580231072 2025/11/16 8:15:05 api生成订单开始：F20251116616，EL2511158938235 2025/11/16 8:15:05 api生成订单结束：F20251116616，EL2511158938235 2025/11/16 9:00:05 api生成订单开始：F20251116921，D2511152300972 2025/11/16 9:00:05 api生成订单开始：F20251116922，T25111520111452 2025/11/16 9:00:05 api生成订单结束：F20251116921，D2511152300972 2025/11/16 9:00:05 api生成订单结束：F20251116922，T25111520111452 2025/11/16 9:00:08 api生成订单开始：F20251116923，T25111523492896 2025/11/16 9:00:08 api生成订单结束：F20251116923，T25111523492896 2025/11/16 9:00:10 api生成订单开始：F20251116924，D2511160042181 2025/11/16 9:00:10 api生成订单结束：F20251116924，D2511160042181 2025/11/16 14:30:01 PackageSyncFromOMSToWMS UpdateElasticsearchOrder 订单："F202511161396"异常：{"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 ('F202511161396')\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 在 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:行号 9703\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/11/16 16:00:03 api生成订单开始：F202511161497，G19206308 2025/11/16 16:00:03 api生成订单结束：F202511161497，G19206308 2025/11/16 18:00:04 api生成订单开始：F202511161716，G19206596 2025/11/16 18:00:04 api生成订单结束：F202511161716，G19206596 2025/11/16 19:00:02 api生成订单开始：F202511161893，G19206042 2025/11/16 19:00:02 api生成订单结束：F202511161893，G19206042 2025/11/16 20:00:02 api生成订单开始：F202511161989，G19208796 2025/11/16 20:00:02 api生成订单结束：F202511161989，G19208796 2025/11/16 20:00:04 api生成订单开始：F202511161990，G19208699 2025/11/16 20:00:05 api生成订单结束：F202511161990，G19208699 2025/11/16 20:00:08 api生成订单开始：F202511161991，G19208482 2025/11/16 20:00:09 api生成订单结束：F202511161991，G19208482 2025/11/16 20:00:10 api生成订单开始：F202511161992，G19208379 2025/11/16 20:00:11 api生成订单结束：F202511161992，G19208379 2025/11/16 20:00:15 api生成订单开始：F202511161993，G19208270 2025/11/16 20:00:15 api生成订单结束：F202511161993，G19208270 2025/11/16 20:00:23 api生成订单开始：F202511161994，G19207980 2025/11/16 20:00:24 api生成订单结束：F202511161994，G19207980 2025/11/16 20:00:35 api生成订单开始：F202511161995，G19207799 2025/11/16 20:00:35 api生成订单结束：F202511161995，G19207799 2025/11/16 20:00:47 api生成订单开始：F202511161996，G19207653 2025/11/16 20:00:47 api生成订单结束：F202511161996，G19207653 2025/11/16 20:00:49 api生成订单开始：F202511161997，G19207451 2025/11/16 20:00:50 api生成订单结束：F202511161997，G19207451 2025/11/16 20:00:54 api生成订单开始：F202511161998，G19207360 2025/11/16 20:00:54 api生成订单结束：F202511161998，G19207360 2025/11/16 20:10:04 api生成订单开始：F202511162018，K25111650231074 2025/11/16 20:10:04 api生成订单结束：F202511162018，K25111650231074 2025/11/16 20:10:06 api生成订单开始：F202511162020，K25111690631077 2025/11/16 20:10:06 api生成订单结束：F202511162020，K25111690631077 2025/11/16 20:10:09 api生成订单开始：F202511162021，K25111657131078 2025/11/16 20:10:09 api生成订单结束：F202511162021，K25111657131078 2025/11/16 20:10:10 api生成订单开始：F202511162022，K25111672131079 2025/11/16 20:10:10 api生成订单结束：F202511162022，K25111672131079 2025/11/16 21:00:01 api生成订单开始：F202511162118，D2511161129469 2025/11/16 21:00:02 api生成订单结束：F202511162118，D2511161129469 2025/11/16 21:00:02 api生成订单开始：F202511162119，G19209066 2025/11/16 21:00:02 api生成订单结束：F202511162119，G19209066 2025/11/16 21:00:02 api生成订单开始：F202511162120，T25111612360289 2025/11/16 21:00:02 api生成订单结束：F202511162120，T25111612360289 2025/11/16 21:00:05 api生成订单开始：F202511162121，G19208915 2025/11/16 21:00:05 api生成订单结束：F202511162121，G19208915 2025/11/16 21:00:06 api生成订单开始：F202511162122，S2511161124463 2025/11/16 21:00:06 api生成订单结束：F202511162122，S2511161124463 2025/11/16 21:00:11 api生成订单开始：F202511162123，S2511161229202 2025/11/16 21:00:11 api生成订单结束：F202511162123，S2511161229202 2025/11/16 21:08:04 api生成订单开始：F202511162145，KPT25111658726746 2025/11/16 21:08:04 api生成订单结束：F202511162145，KPT25111658726746 2025/11/16 22:00:02 api生成订单开始：F202511162213，G19209705 2025/11/16 22:00:02 api生成订单结束：F202511162213，G19209705 2025/11/16 22:00:31 api生成订单开始：F202511162214，G19209239 2025/11/16 22:00:31 api生成订单结束：F202511162214，G19209239 2025/11/16 23:00:01 api生成订单开始：F202511162332，G19210781 2025/11/16 23:00:02 api生成订单结束：F202511162332，G19210781 2025/11/16 23:00:05 api生成订单开始：F202511162333，G19210613 2025/11/16 23:00:06 api生成订单结束：F202511162333，G19210613 2025/11/16 23:00:08 api生成订单开始：F202511162334，G19210491 2025/11/16 23:00:09 api生成订单结束：F202511162334，G19210491 2025/11/16 23:00:12 api生成订单开始：F202511162337，G19210300 2025/11/16 23:00:12 api生成订单结束：F202511162337，G19210300 2025/11/16 23:00:15 api生成订单开始：F202511162338，G19210202 2025/11/16 23:00:15 api生成订单结束：F202511162338，G19210202 2025/11/16 23:00:17 api生成订单开始：F202511162339，G19210191 2025/11/16 23:00:17 api生成订单结束：F202511162339，G19210191 2025/11/16 23:00:22 api生成订单开始：F202511162340，G19210005 2025/11/16 23:00:22 api生成订单结束：F202511162340，G19210005