[步骤]
CODE:N1721061Error:15_137_2_-2146232060
SQL:SELECT temptab.Text AS SupplierType ,
ISNULL(tmp1.ProcurementNum, 0) AS ProcurementNum ,
ISNULL(tmp1.ProductPrice, 0) AS ProductPrice ,
ISNULL(tmp1.ProductNum, 0) AS ProductNum ,
0.0 as ProductPercent,
0.0 as PricePercent,
0.0 as SKUPercent,
ISNULL(tmp1.SKUNum, 0) AS SKUNum
FROM ( SELECT 1 AS [Type] ,
'市场采购' AS [Text]
UNION ALL
SELECT 2 AS [Type] ,
'网络采购' AS [Text]
UNION ALL
SELECT 3 AS [Type] ,
'工厂采购' AS [Text]
UNION ALL
SELECT 4 AS [Type] ,
'自主生产' AS [Text]
) temptab
LEFT JOIN ( SELECT SupplierType ,
ISNULL(COUNT(DISTINCT RB_Procurement_List.P_Code), 0) AS ProcurementNum ,
ISNULL(SUM(ProductPrice * ProductNum), 0) AS ProductPrice , ISNULL(SUM(ProductNum), 0) AS ProductNum , COUNT(DISTINCT SKU) AS SKUNum FROM RB_Procurement_List (NOLOCK) LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode LEFT JOIN RB_Procurement_Detail (NOLOCK) t1 ON RB_Procurement_List.P_Code = t1.P_Code AND t1.CustomerID = RB_Procurement_List.CustomerID WHERE 1=1 AND RB_Procurement_List.CustomerID = 1 AND RB_Procurement_List.P_Code IN ( SELECT P_Code FROM ( SELECT P_Code , SUM(ProductNum) AS sumProductNum FROM RB_Procurement_Detail WITH ( NOLOCK ) WHERE CustomerID=1 GROUP BY P_Code ) AS TTsumProductNum WHERE sumProductNum >= 10 ) AND RB_Procurement_List.P_Code in ( select RB_Procurement_Detail.P_Code from RB_Procurement_Detail with(nolock) where CustomerID=1 and SKU IN (select item from CharSplitForIn(@stringSku,',')) ) AND RB_Procurement_List.AddTime >= '2023-05-14 00:00:00' AND RB_Procurement_List.AddTime <= '2023-08-14 23:59:59' AND RB_Procurement_List.P_Code IN ( SELECT RB_Procurement_Detail.P_Code FROM RB_Procurement_Detail (NOLOCK) LEFT JOIN RB_Product_SalesStatus (NOLOCK) ON RB_Product_SalesStatus.CustomerID = RB_Procurement_Detail.CustomerID AND RB_Product_SalesStatus.SKU = RB_Procurement_Detail.SKU WHERE RB_Procurement_Detail.CustomerID = 1 AND RB_Product_SalesStatus.ProductVitalityType IN (3)) GROUP BY SupplierType ) tmp1 ON temptab.Type = tmp1.SupplierType; PARAMS: MESSAGE:Must declare the scalar variable "@stringSku". Incorrect syntax near the keyword '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.DALExtendV2.RB_Procurement_ListExtendV2.GetProcurementBySupplierType(RB_Procurement_List_PSParametersExtend parameters) 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.GetProcurementBySupplierType() 在 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)
[结果]
[期望]
修复SQL 异常
sql拼接问题；触发页面：采购单管理批量搜索后点统计