[步骤]

[结果]

 CODE:N0931216
Error:15_156_1_-2146232060
SQL:SELECT COUNT(1) FROM ( select  A.ID ,
                                 A.CustomerID ,
                                 A.RemovalOrderCode ,
                                 A.RemovalOrderType ,
                                 A.RemovalOrderStatus ,
                                 A.AddAdminName ,
                                 A.OrderSourceID ,
                                 A.AddTime ,
                                 'ERP' OrderSource,
                                 A.CreatMsg ,
                                 os.OrderSourceName ,
                                 arod.AuditStatus,
                                 arod.OrderStatus,
                                 dp.DepartmentName,
                                 ra.EmpoyeeNumber,
                                 arods.Status as SyncStatus,
                                 arods.SyncLog as SyncLog,
                                 wh.WareHouseName as OverseaWareHouseName
                           from  RB_RemovalOrderCreateRecord (nolock) A
                      left join  RB_OrderSource (nolock) os
                             on  os.CustomerID = A.CustomerID
                            and  os.ID = A.OrderSourceID
                      left join  RB_WareHouse (nolock) wh
                             on  A.CustomerID = wh.CustomerID
                            and  A.OverseaWareHouseId = wh.ID
                      left join  RB_Amazon_Removal_Order_Detail (nolock) arod
                             on  A.CustomerID = arod.CustomerID
                            and  A.OrderSourceID = arod.OrderSourceID
                            and  A.RemovalOrderCode = arod.OrderID
                      left join  RB_Amazon_Removal_Order_Detail_SyncStatus (nolock) arods
                             on  arod.CustomerID = arods.CustomerID
                            and  arod.OrderSourceID = arods.OrderSourceID
                            and  arod.OrderID = arods.OrderID
                      left join  RB_Admin (nolock) ra
                             on  A.CustomerID = ra.CustomerID
                            and  A.AddAdminId = ra.ID
                      left join  RB_Department (nolock) dp
                             on  ra.CustomerID = dp.CustomerID
                            and  ra.DepartmentID = dp.ID
                          where  A.CustomerID = @CustomerID  and A.ID in (select RecordID from RB_RemovalOrderCreateRecordSkuItems (nolock)
                                                                  where CustomerID = @CustomerID
                                                                    and MNSKU in (select distinct(OrderSourceSKU) from RB_WareHouse_Product (nolock)  
                                                                                                                 where CustomerID = @CustomerID
                                                                                                                   and ASIN = @Keyword)) union all select DISTINCT
                                 arod.ID ,
                                 arod.CustomerID ,
                                 arod.OrderID as RemovalOrderCode,
                                 arod.OrderType as RemovalOrderType ,
                                 'Success' as RemovalOrderStatus ,
                                 os.SaleAdminName as AddAdminName ,
                                 arod.OrderSourceID ,
                                 arod.AddTime ,
                                 '平台' OrderSource,
                                 '' as CreatMsg ,
                                 os.OrderSourceName ,
                                 arod.AuditStatus,
                                 arod.OrderStatus ,
                                 dp.DepartmentName,
                                 ra.EmpoyeeNumber,
                                 arods.Status as SyncStatus,
                                 arods.SyncLog as SyncLog,
                                 wh.WareHouseName as OverseaWareHouseName
                           from  RB_Amazon_Removal_Order_Detail (nolock) arod
                      left join  RB_OrderSource (nolock) os
                             on  os.CustomerID = arod.CustomerID
                            and  os.ID = arod.OrderSourceID
                      left join  RB_WareHouse (nolock) wh
                             on  os.CustomerID = wh.CustomerID
                            and  os.RemovalOrderDefaultWareHouseID = wh.ID
                      left join  RB_Amazon_Removal_Order_Detail_SyncStatus (nolock) arods
                             on  arod.CustomerID = arods.CustomerID
                            and  arod.OrderSourceID = arods.OrderSourceID
                            and  arod.OrderID = arods.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_Admin (nolock) ra
                             on  os.CustomerID = ra.CustomerID
                            and  os.SaleAdminID = ra.ID
                      left join  RB_Department (nolock) dp
                             on  ra.CustomerID = dp.CustomerID
                            and  ra.DepartmentID = dp.ID
                          where  arod.CustomerID = @CustomerID  and po.ASINorItemID = @Keyword)  and not exists(select 1 from  RB_RemovalOrderCreateRecord (nolock) rocr
                                                            where  rocr.CustomerID = arod.CustomerID
                                                              and  rocr.OrderSourceID = arod.OrderSourceID
                                                              and  rocr.RemovalOrderCode = arod.OrderID) ) AS PagerTable
PARAMS:@CustomerID = 1 ,@Keyword = X002YKTJLB ,
MESSAGE:关键字 'and' 附近有语法错误。
“)”附近有语法错误。
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.ExecuteScalar()
   在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.GetSingle(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.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, SqlParameter[] cmdParms)
   在 RB.DALExtendV2.RB_RemovalOrderCreateRecordExtendV2.GetPagerModelsManualToRemoveOrderList(CM_GetRemoveOrderListParam param, Int32& recordCount)
   在 PandaBuy.ERP.Web.IrobotBox.RemoveOrder.RemoveOrderList.BindData()
   在 PandaBuy.ERP.Web.IrobotBox.RemoveOrder.RemoveOrderList.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_removeorderlist_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)

[期望]