[步骤]

[结果]

CODE:N1556491
Error:16_207_1_-2146232060
SQL:
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY  ID ASC ) AS [PageIndex] ,* FROM ( SELECT A.FNSKU,
                                             A.MNSKU,
                                             A.SKU,
                                             A.SellableQuantity,
                                             A.UnsellableQuantity,
                                             A.CostDestroyed,
                                             reOrd.carrier AS Carrier,
                                             arod.RequestedQuantity,
                                             arod.CancelledQuantity,
                                             arod.DisposedQuantity,
                                             arod.ShippedQuantity,
                                             arod.InProcessQuantity,
                                             aro.TrackingNumber,
                                             rocr.ShippingNotes AS DestroyedReason,
                                             Isnull(( CASE  WHEN po.LastBuyPrice > 0 THEN po.LastBuyPrice
                                                      ELSE po.LastSupplierPrice
                                                      END ), 0) * arod.DisposedQuantity as TotalPurchasePrice,
                                             B.ProductNameCN
                                        FROM RB_RemovalOrderCreateRecordSkuItems A (NOLOCK)
                                   LEFT JOIN RB_RemovalOrderCreateRecord rocr (NOLOCK)
                                          ON A.CustomerID = rocr.CustomerID
                                         AND A.RecordID = rocr.ID
                                   LEFT JOIN RB_Product B (NOLOCK)
                                          ON A.CustomerID = B.CustomerID
                                         AND A.SKU = B.SKU
                                   LEFT JOIN RB_Amazon_Removal_Order_Detail arod ( NOLOCK )
                                          ON rocr.CustomerID = arod.CustomerID
                                         AND rocr.OrderSourceID = arod.OrderSourceID
                                         AND rocr.RemovalOrderCode = arod.OrderID
                                   LEFT JOIN RB_Amazon_Product_Base po ( NOLOCK )
                                          ON po.CustomerID = arod.CustomerID
                                         AND po.OrderSourceID = arod.OrderSourceID
                                         AND po.OrderSourceSKU = arod.SKU and po.IsDelete=0
                                   LEFT JOIN RB_Amazon_RemovalOrder aro ( NOLOCK )
                                          ON arod.CustomerID = aro.CustomerID
                                         AND aro.ToOrderSourceID = arod.OrderSourceID
                                         AND aro.MerchantRemovalOrderID = arod.OrderID
                                   LEFT JOIN RB_Report_FULFILLMENT_REMOVAL_SHIPMENT_DETAIL reOrd ( NOLOCK )
                                          ON rocr.CustomerID = reOrd.CustomerID
                                         AND rocr.OrderSourceID = reOrd.OrderSourceID
                                         AND rocr.RemovalOrderCode = reOrd.[order-id]
                                       WHERE A.CustomerID=@CustomerID
                                         AND A.RecordID = @RecordID ) AS TempTable ) AS  PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20
PARAMS:@CustomerID = 1 ,@RecordID = 21 ,
MESSAGE:列名 'ID' 无效。
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.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.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms)
   在 RB.DALExtendV2.RB_RemovalOrderCreateRecordSkuItemsExtendV2.GetPagerModelsToRemoveOrderDetail(CM_GetRemovalOrderCreateRecordSkuItemsParam parameters, Int32& recordCount)
   在 PandaBuy.ERP.Web.IrobotBox.RemoveOrder.RemoveOrderDetail.Page_Load(Object sender, EventArgs e)
   在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   在 System.Web.UI.Control.OnLoad(EventArgs e)
   在 System.Web.UI.Control.LoadRecursive()
   在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest()
   在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   在 System.Web.UI.Page.ProcessRequest(HttpContext context)
   在 ASP.irobotbox_removeorder_removeorderdetail_aspx.ProcessRequest(HttpContext context)
   在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
   在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
   在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

[期望]