深圳智汇创想科技有限公司

[步骤]

[结果]

[期望]

CODE:N1524163
Error:15_156_1_-2146232060
SQL: SELECT sas.Id,
       sas.CustomerId,
       sas.OrderSourceID,
       sas.RemovalOrderCode,
       sas.AuditSatus,
       sas.AuditRemark,
       sas.ReportID,
       os.OrderSourceName,
       si.SKU,
       si.MNSKU,
       si.SellableQuantity,
       si.UnsellableQuantity,
       sas.SourceType
FROM RB_RemovalOrder_SkuItem_AuditSatusExtend (NOLOCK) sas
    LEFT JOIN dbo.RB_RemovalOrderCreateRecordSkuItems (NOLOCK) si
        ON si.CustomerID = sas.CustomerId
           AND si.ID = sas.ReportID
    LEFT JOIN dbo.RB_OrderSource (NOLOCK) os
        ON os.CustomerID = sas.CustomerId
           AND sas.OrderSourceID = os.ID
WHERE sas.CustomerId = @CustomerID
      AND sas.ReportID IN (
                              SELECT CAST(item AS INT)FROM dbo.CharSplitForIn(@RecordIdStr, ',')
                          )
      AND sas.SourceType = 0; UNION ALL SELECT sas.Id,
                                   sas.CustomerId,
                                   sas.OrderSourceID,
                                   sas.RemovalOrderCode,
                                   sas.AuditSatus,
                                   sas.AuditRemark,
                                   sas.ReportID,
                                   os.OrderSourceName,
                                   pos.SKU,
                                   pos.OrderSourceSKU AS MNSKU,
                                   CASE WHEN rod.Disposition='Sellable' THEN rod.ShippedQuantity ELSE 0 END SellableQuantity,
                                   CASE WHEN rod.Disposition='Unsellable' THEN rod.ShippedQuantity ELSE 0 END UnsellableQuantity,
                                   sas.SourceType
                            FROM RB_RemovalOrder_SkuItem_AuditSatusExtend (NOLOCK) sas
                                LEFT JOIN dbo.RB_Amazon_Removal_Order_Detail (NOLOCK) rod
                                    ON rod.CustomerID = sas.CustomerId
                                       AND rod.ID = sas.ReportID
                                LEFT JOIN dbo.RB_Product_OrderSourceSKU (NOLOCK) pos
                                    ON pos.CustomerID = rod.CustomerID
                                       AND pos.OrderSourceSKU = rod.SKU
                                       AND rod.OrderSourceID = pos.OrderSourceID
                                LEFT JOIN dbo.RB_OrderSource (NOLOCK) os
                                    ON os.CustomerID = sas.CustomerId
                                       AND sas.OrderSourceID = os.ID
                            WHERE sas.CustomerId = @CustomerID
                                  AND sas.SourceType = 1
                                  AND sas.ReportID IN (
                                                          SELECT CAST(item AS INT)FROM dbo.CharSplitForIn(@PlaftRecordIdStr, ',')
                                                      );
PARAMS:@CustomerID = 1 ,@RecordIdStr = 59292,59293,59294,59297,59299,59295,59298,59296,59300,59303,59301,59304,59302,59305,59306,59307,59308,59309,59310,59368,59370,59367,59369,59371,59372 ,@PlaftRecordIdStr = 1778481 ,
MESSAGE:Incorrect syntax near the keyword 'UNION'.
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.DALExtendV2.RB_RemovalOrder_SkuItem_AuditSatusExtendExtendV2.GetRemovalOrderForAuditProduct(Int32 customerId, List`1 erpRecordIdList, List`1 plaftRecordIdList)
   在 PandaBuy.ERP.Web.IrobotBox.RemovalOrder.RemovalOrderByProductAudit.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_removalorder_removalorderbyproductaudit_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)