[2024-06-25 17:17:20] local.ERROR: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 (SQL: select top 1 * from [barcodefile] where ([rescode] = 16922522300004) and [startno] <= A1234000 and [endno] >= A1234000) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 (SQL: select top 1 * from [barcodefile] where ([rescode] = 16922522300004) and [startno] <= A1234000 and [endno] >= A1234000) at D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select top 1 * ...', Array, Object(Closure)) #1 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run('select top 1 * ...', Array, Object(Closure)) #2 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2414): Illuminate\\Database\\Connection->select('select top 1 * ...', Array, true) #3 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2403): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Query\\Builder->get(Array) #7 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(576): Illuminate\\Database\\Query\\Builder->first() #8 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(564): codeTracing('011692252230000...', 4, false, Array, 'A1234000') #9 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Controllers\\Code\\CodeSearchController.php(78): codeTracingUdi('011692252230000...', 4) #10 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\Code\\CodeSearchController->udiCodeSearch(Object(Illuminate\\Http\\Request)) #11 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('udiCodeSearch', Array) #12 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\Code\\CodeSearchController), 'udiCodeSearch') #13 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #14 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #15 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Middleware\\GetUserFromToken.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #17 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\GetUserFromToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #18 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(103): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #22 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(55): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\\Http\\Request), Object(Closure), 'api', Object(Closure)) #23 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'api') #24 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #26 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #27 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #28 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #29 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #30 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #31 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #33 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #34 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #35 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #38 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #47 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #48 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #49 {main} [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 at D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select top 1 * ...', Array) #2 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select top 1 * ...', Array, Object(Closure)) #3 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run('select top 1 * ...', Array, Object(Closure)) #4 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2414): Illuminate\\Database\\Connection->select('select top 1 * ...', Array, true) #5 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2403): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Query\\Builder->get(Array) #9 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(576): Illuminate\\Database\\Query\\Builder->first() #10 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(564): codeTracing('011692252230000...', 4, false, Array, 'A1234000') #11 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Controllers\\Code\\CodeSearchController.php(78): codeTracingUdi('011692252230000...', 4) #12 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\Code\\CodeSearchController->udiCodeSearch(Object(Illuminate\\Http\\Request)) #13 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('udiCodeSearch', Array) #14 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\Code\\CodeSearchController), 'udiCodeSearch') #15 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #16 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #17 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #18 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Middleware\\GetUserFromToken.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\GetUserFromToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(103): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #24 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(55): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\\Http\\Request), Object(Closure), 'api', Object(Closure)) #25 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'api') #26 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #28 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #29 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #30 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #31 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #32 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #33 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #49 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #50 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #51 {main} "} [2024-06-25 17:26:28] local.ERROR: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 (SQL: select top 1 * from [barcodefile] where ([rescode] = 16922522300004) and [startno] <= A123400003401 and [endno] >= A123400003401) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 (SQL: select top 1 * from [barcodefile] where ([rescode] = 16922522300004) and [startno] <= A123400003401 and [endno] >= A123400003401) at D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select top 1 * ...', Array, Object(Closure)) #1 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run('select top 1 * ...', Array, Object(Closure)) #2 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2414): Illuminate\\Database\\Connection->select('select top 1 * ...', Array, true) #3 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2403): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Query\\Builder->get(Array) #7 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(576): Illuminate\\Database\\Query\\Builder->first() #8 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(564): codeTracing('011692252230000...', 4, false, Array, 'A123400003401') #9 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Controllers\\Code\\CodeSearchController.php(78): codeTracingUdi('011692252230000...', 4) #10 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\Code\\CodeSearchController->udiCodeSearch(Object(Illuminate\\Http\\Request)) #11 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('udiCodeSearch', Array) #12 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\Code\\CodeSearchController), 'udiCodeSearch') #13 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #14 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #15 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Middleware\\GetUserFromToken.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #17 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\GetUserFromToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #18 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(103): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #22 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(55): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\\Http\\Request), Object(Closure), 'api', Object(Closure)) #23 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'api') #24 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #26 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #27 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #28 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #29 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #30 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #31 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #33 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #34 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #35 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #38 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #47 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #48 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #49 {main} [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 at D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select top 1 * ...', Array) #2 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select top 1 * ...', Array, Object(Closure)) #3 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run('select top 1 * ...', Array, Object(Closure)) #4 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2414): Illuminate\\Database\\Connection->select('select top 1 * ...', Array, true) #5 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2403): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Query\\Builder->get(Array) #9 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(576): Illuminate\\Database\\Query\\Builder->first() #10 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(564): codeTracing('011692252230000...', 4, false, Array, 'A123400003401') #11 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Controllers\\Code\\CodeSearchController.php(78): codeTracingUdi('011692252230000...', 4) #12 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\Code\\CodeSearchController->udiCodeSearch(Object(Illuminate\\Http\\Request)) #13 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('udiCodeSearch', Array) #14 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\Code\\CodeSearchController), 'udiCodeSearch') #15 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #16 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #17 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #18 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Middleware\\GetUserFromToken.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\GetUserFromToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(103): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #24 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(55): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\\Http\\Request), Object(Closure), 'api', Object(Closure)) #25 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'api') #26 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #28 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #29 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #30 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #31 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #32 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #33 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #49 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #50 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #51 {main} "} [2024-06-25 17:31:19] local.ERROR: SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 (SQL: select top 1 * from [barcodefile] where ([rescode] = 16922522300004) and [startno] <= A1234000 and [endno] >= A1234000) {"exception":"[object] (Illuminate\\Database\\QueryException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 (SQL: select top 1 * from [barcodefile] where ([rescode] = 16922522300004) and [startno] <= A1234000 and [endno] >= A1234000) at D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:712) [stacktrace] #0 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select top 1 * ...', Array, Object(Closure)) #1 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run('select top 1 * ...', Array, Object(Closure)) #2 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2414): Illuminate\\Database\\Connection->select('select top 1 * ...', Array, true) #3 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #4 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #5 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2403): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #6 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Query\\Builder->get(Array) #7 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(577): Illuminate\\Database\\Query\\Builder->first() #8 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(565): codeTracing('011692252230000...', 4, false, Array, 'A1234000') #9 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Controllers\\Code\\CodeSearchController.php(78): codeTracingUdi('011692252230000...', 4) #10 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\Code\\CodeSearchController->udiCodeSearch(Object(Illuminate\\Http\\Request)) #11 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('udiCodeSearch', Array) #12 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\Code\\CodeSearchController), 'udiCodeSearch') #13 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #14 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #15 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #16 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Middleware\\GetUserFromToken.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #17 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\GetUserFromToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #18 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(103): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #22 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(55): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\\Http\\Request), Object(Closure), 'api', Object(Closure)) #23 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'api') #24 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #25 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #26 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #27 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #28 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #29 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #30 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #31 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #32 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #33 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #34 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #35 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #37 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #38 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #47 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #48 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #49 {main} [previous exception] [object] (PDOException(code: 42000): SQLSTATE[42000]: [Microsoft][ODBC Driver 18 for SQL Server][SQL Server]从数据类型 nvarchar 转换为 bigint 时出错。 at D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php:373) [stacktrace] #0 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(373): PDOStatement->execute() #1 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(705): Illuminate\\Database\\Connection->Illuminate\\Database\\{closure}('select top 1 * ...', Array) #2 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(672): Illuminate\\Database\\Connection->runQueryCallback('select top 1 * ...', Array, Object(Closure)) #3 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Connection.php(376): Illuminate\\Database\\Connection->run('select top 1 * ...', Array, Object(Closure)) #4 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2414): Illuminate\\Database\\Connection->select('select top 1 * ...', Array, true) #5 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2402): Illuminate\\Database\\Query\\Builder->runSelect() #6 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2936): Illuminate\\Database\\Query\\Builder->Illuminate\\Database\\Query\\{closure}() #7 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Query\\Builder.php(2403): Illuminate\\Database\\Query\\Builder->onceWithColumns(Array, Object(Closure)) #8 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Database\\Concerns\\BuildsQueries.php(294): Illuminate\\Database\\Query\\Builder->get(Array) #9 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(577): Illuminate\\Database\\Query\\Builder->first() #10 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\functions.php(565): codeTracing('011692252230000...', 4, false, Array, 'A1234000') #11 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Controllers\\Code\\CodeSearchController.php(78): codeTracingUdi('011692252230000...', 4) #12 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Controller.php(54): App\\Http\\Controllers\\Code\\CodeSearchController->udiCodeSearch(Object(Illuminate\\Http\\Request)) #13 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\ControllerDispatcher.php(45): Illuminate\\Routing\\Controller->callAction('udiCodeSearch', Array) #14 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(262): Illuminate\\Routing\\ControllerDispatcher->dispatch(Object(Illuminate\\Routing\\Route), Object(App\\Http\\Controllers\\Code\\CodeSearchController), 'udiCodeSearch') #15 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Route.php(205): Illuminate\\Routing\\Route->runController() #16 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(721): Illuminate\\Routing\\Route->run() #17 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Routing\\Router->Illuminate\\Routing\\{closure}(Object(Illuminate\\Http\\Request)) #18 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\app\\Http\\Middleware\\GetUserFromToken.php(49): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #19 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): App\\Http\\Middleware\\GetUserFromToken->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #20 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\SubstituteBindings.php(50): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #21 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\SubstituteBindings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #22 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(127): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #23 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(103): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequest(Object(Illuminate\\Http\\Request), Object(Closure), Array) #24 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Middleware\\ThrottleRequests.php(55): Illuminate\\Routing\\Middleware\\ThrottleRequests->handleRequestUsingNamedLimiter(Object(Illuminate\\Http\\Request), Object(Closure), 'api', Object(Closure)) #25 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Routing\\Middleware\\ThrottleRequests->handle(Object(Illuminate\\Http\\Request), Object(Closure), 'api') #26 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #27 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(723): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #28 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(698): Illuminate\\Routing\\Router->runRouteWithinStack(Object(Illuminate\\Routing\\Route), Object(Illuminate\\Http\\Request)) #29 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(662): Illuminate\\Routing\\Router->runRoute(Object(Illuminate\\Http\\Request), Object(Illuminate\\Routing\\Route)) #30 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Routing\\Router.php(651): Illuminate\\Routing\\Router->dispatchToRoute(Object(Illuminate\\Http\\Request)) #31 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(167): Illuminate\\Routing\\Router->dispatch(Object(Illuminate\\Http\\Request)) #32 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(128): Illuminate\\Foundation\\Http\\Kernel->Illuminate\\Foundation\\Http\\{closure}(Object(Illuminate\\Http\\Request)) #33 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #34 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull.php(31): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #35 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ConvertEmptyStringsToNull->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #36 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest.php(21): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #37 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\TrimStrings.php(40): Illuminate\\Foundation\\Http\\Middleware\\TransformsRequest->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #38 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\TrimStrings->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #39 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize.php(27): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #40 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\ValidatePostSize->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #41 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance.php(86): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #42 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Foundation\\Http\\Middleware\\PreventRequestsDuringMaintenance->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #43 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\fruitcake\\laravel-cors\\src\\HandleCors.php(52): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #44 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Fruitcake\\Cors\\HandleCors->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #45 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Http\\Middleware\\TrustProxies.php(39): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #46 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(167): Illuminate\\Http\\Middleware\\TrustProxies->handle(Object(Illuminate\\Http\\Request), Object(Closure)) #47 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Pipeline\\Pipeline.php(103): Illuminate\\Pipeline\\Pipeline->Illuminate\\Pipeline\\{closure}(Object(Illuminate\\Http\\Request)) #48 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(142): Illuminate\\Pipeline\\Pipeline->then(Object(Closure)) #49 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\vendor\\laravel\\framework\\src\\Illuminate\\Foundation\\Http\\Kernel.php(111): Illuminate\\Foundation\\Http\\Kernel->sendRequestThroughRouter(Object(Illuminate\\Http\\Request)) #50 D:\\soft\\project\\svn\\udi\\trace_client\\pesticide-back-end\\public\\index.php(52): Illuminate\\Foundation\\Http\\Kernel->handle(Object(Illuminate\\Http\\Request)) #51 {main} "}