[步骤]
[结果]
CODE:N1608473Error:15_102_1_-2146232060
SQL:SELECT oi.CustomerID,
oi.WareHouseID,
ol.SKU,
ol.OrderStatus,
Sum(ol.ProductNum + ol.ProductNumUpdate - ol.LockNum) UnLockProductNum,oi.IsStockOrder
FROM RB_OrderInfo oi WITH(NOLOCK)
INNER LOOP JOIN RB_OrderList ol WITH(NOLOCK)
ON oi.CustomerID = ol.CustomerID
AND oi.OrderCode = ol.OrderCode
JOIN RB_WareHouse wh WITH(NOLOCK)
ON oi.CustomerID = wh.CustomerID
AND oi.WareHouseID = wh.ID
INNER LOOP JOIN RB_OrderSource os WITH(NOLOCK)
ON oi.CustomerID = os.CustomerID
AND oi.OrderSourceID = os.ID
WHERE oi.CustomerID IN ( 1 )
AND oi.AddTime >= Dateadd(MONTH, -2, Getdate())
AND oi.OrderState =0
AND oi.OrderStatus in(SELECT CAST(item AS int) FROM Charsplitforin(@OrderStatus','))
AND oi.IsPay = 1
AND ol.PurchaseType < 4
AND ol.ProductNum + ol.ProductNumUpdate - ol.LockNum > 0
AND ol.SKU > ''
AND oi.WareHouseID > 0
AND wh.WareHouseType = 1
AND OS.OrderSourceType <> 20
AND oi.OrderCode not in (SELECT item FROM Charsplitforin(@OrderCodes, ','))
GROUP BY oi.CustomerID,
oi.WareHouseID,
ol.SKU,oi.IsStockOrder,ol.OrderStatus
PARAMS:@OrderCodes = 202205211552825896 ,@OrderStatus = 1,6,0 ,
MESSAGE:“,”附近有语法错误。
关键字 'GROUP' 附近有语法错误。
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.DALExtend.Generate.RB_AutoMatchWarehouseAndTransportRuleExtend.GetLocalWarehouseUnLockProductNum(List`1 customerIDs, List`1 orderCodes, List`1 orderStatus)
在 Biz.OrderBusiness.OrderMatchRule.GetOrderOperateData(Int32 orderType, List`1 orderInfoListMapping)
在 Biz.OrderBusiness.OrderMatchRule.OrderMatchWarehouseRuleTask(List`1 ruleParams, List`1 orderMatchInfoResult, Boolean isCheckPortion, Int32 orderType, List`1 orderInfoListMapping)
在 Biz.PlatformUtil.OrderMatchRules.ProcessOrderMatchRules.DoProcessOrderMatchRules()
在 PandaBuy.ERP.Web.IrobotBox.Order.BatchAction.OrderOperatePlanV2()
在 PandaBuy.ERP.Web.IrobotBox.Order.BatchAction.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_order_batchaction_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)
[期望]
