[步骤]
CODE:N1714411
Error:15_137_2_-2146232060
SQL: -- DECLARE @StartTime datetime = '2024-08-09';
-- DECLARE @EndTime datetime = '2024-09-10';
-- DECLARE @CustomerId int = 1;
SELECT
a.ShipTime AS '发货时间',
a.OrderCode AS '系统订单号',
a.TrackNumbers AS '上传追踪号',
a.MainOrderCode AS '海外仓订单号',
d.Country_cn AS '国家',
e.WareHouseName AS '发货仓库',
c.TransportName AS '运输方式',
ISNULL(MAX(PredFreight), 0) AS '系统预估运费',
-SUM(b.OverSeasShipFees + b.FBATransactionFees)AS '海外仓返回运费',
min(TotalFee) '同步海外仓费用'
FROM
dbo.RB_OrderInfo(NOLOCK) AS a
LEFT JOIN dbo.RB_Report_OrderSettlement(NOLOCK) AS b
ON a.CustomerID = b.CustomerID AND a.OrderCode = b.OrderCode
LEFT JOIN dbo.RB_Transport(NOLOCK) AS c ON a.TransportID = c.ID
LEFT JOIN dbo.E_Country(NOLOCK) AS d ON a.Country = d.Shorthand
LEFT JOIN dbo.RB_WareHouse(NOLOCK) AS e ON a.CustomerID = e.CustomerID AND a.WareHouseID = e.ID
LEFT JOIN RB_OverseaOrderFee(NOLOCK) as f on a.OrderCode=f.OrderCode and a.CustomerID = f.CustomerID
LEFT JOIN RB_OrderInfo_Expand(NOLOCK) as opf on a.OrderCode=opf.OrderCode and a.CustomerID = opf.CustomerID
WHERE a.CustomerID = @CustomerID AND a.OrderStatus !=2 AND a.IsStockOrder = 0 AND e.WareHouseType NOT IN (1,3) AND IsFBAOrder = 0
AND a.ShipTime >= @StartTime AND a.ShipTime <= @EndTime
GROUP BY
a.ShipTime,
a.TrackNumbers,
a.OrderCode,
a.MainOrderCode,
d.Country_cn,
e.WareHouseName,
c.TransportName
PARAMS:@StartTime = 2025-05-01 ,@CustomerId = 1 ,
MESSAGE:Must declare the scalar variable "@EndTime".
TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
在 System.Data.SqlClient.SqlDataReader.get_MetaData()
在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior)
在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
在 RB.DAL.DBOperator.ExecuteReader(String SQLString, SqlParameter[] cmdParms, Boolean IsWriteDB, Int32 Timeout)
在 Biz.Irobotbox.ReportCentre.CustomReportService.GetPageDataForCustomReportToSqlDataReader(String firstFileFullPath, RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramList, List`1 exportFields, String orderBy, Int32 timeOut)
在 Biz.Irobotbox.ReportCentre.CustomReportService.ExportCSVBySteam(RB_CustomReportTask customReportTask, String[] noPermsissionfields, Dictionary`2 paramValues, List`1 exportFields, String orderField, Int32 timeOut)
在 Biz.Irobotbox.ReportCentre.CustomReportService.ExecuteCustomReportTask(List`1 customReportList)
在 System.Threading.Tasks.Task.Execute()
在 System.Threading.ExecutionContext.RunInternal(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
在 System.Threading.ExecutionContext.Run(ExecutionContext executionContext, ContextCallback callback, Object state, Boolean preserveSyncCtx)
在 System.Threading.Tasks.Task.ExecuteWithThreadLocal(Task& currentTaskSlot)
在 System.Threading.Tasks.Task.ExecuteEntry(Boolean bPreventDoubleExecution)
在 System.Threading.Tasks.Schedulers.LimitedConcurrencyLevelTaskScheduler.<NotifyThreadPoolOfPendingWork>b__6_0(Object _)
在 System.Threading.QueueUserWorkItemCallback.System.Threading.IThreadPoolWorkItem.ExecuteWorkItem()
在 System.Threading.ThreadPoolWorkQueue.Dispatch()
[结果]
[期望]
自定义报告未设置必填 已调整