CODE:N1531483

Error:15_102_1_-2146232060

SQL:DELETE a FROM RB_Responsible_OrderDistributeDetail a INNER JOIN RB_Procurement_Order_PositionCode b ON a.LocalStockOrderCode=b.OrderCode

AND a.SKU=b.SKU

WHERE b.P_Code=@P_Code b.SKU IN ( SELECT item FROM dbo.CharSplitForIn(@Skus, ',') )

PARAMS:@P_Code = 20008364018 ,@Skus = 10664904,13935879 ,

MESSAGE:Incorrect syntax near 'b'.

TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action1 wrapCloseInAction) 在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action1 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.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, TaskCompletionSource1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry) 在 System.Data.SqlClient.SqlCommand.InternalExecuteNonQuery(TaskCompletionSource1 completion, String methodName, Boolean sendToPipe, Int32 timeout, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)

在 System.Data.SqlClient.SqlCommand.ExecuteNonQuery()

在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)

在 RB.DAL.DBOperator.ExecuteSql(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms)

在 RB.DAL.RB_Responsible_OrderDistributeDetail.DeleteByCode(String code, List`1 skus)

在 Biz.Irobotbox.ProcurementV2.ProcurementRepulse.Procurement_List_ReBuy_New(Int32 CustomerID, String P_Code, String[] arrIDs, Int32 AdminID, String AdminName, Boolean IsProcurementBackDefault)

在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.Repulse()

在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.OnPreInit(EventArgs e)

在 System.Web.UI.Page.PerformPreInit()

在 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_procurementv2_procurementlist_new_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)