BUG #54262 销量日志报表请求数据库 SQL 异常 - 技术中心-需求池

重现步骤

[步骤]

[11:44:32] [200] [http://158-1.zhcxkj.com:8093/ASHX/IrobotBox/SalesDateReportHandler.ashx][10.17.8.6][10.17.8.6/ASHX/IrobotBox/SalesDateReportHandler.ashx]--Http_Referer[http://158-1.zhcxkj.com/IrobotBox/ReportSale/SalesDateReport.aspx]--Message: 数据库处理错误，请联系智汇技术！标识：N1144325--GetType(): Exception--Source: RB.DAL--StackTrace: 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
在 RB.DALExtend.Generate.RB_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters)
在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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)

content:

[11:44:32] ------------------------------------------------------------- CODE:N1144325 Error:15_102_1_-2146232060 SQL:select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,1 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.SettlementShortDate>=@StartDate and alias.SettlementShortDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND alias.PromotionType=1 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.SettlementShortDate>=@StartDate AND alias.SettlementShortDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND alias.PromotionType=1 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () union all select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,0 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.ShipDate>=@StartDate and alias.ShipDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND ISNULL(alias.PromotionType,0)=0 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.ShipDate>=@StartDate AND alias.ShipDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND ISNULL(alias.PromotionType,0)=0 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () PARAMS:@CustomerID = 1 ,@StartDate = 2024/12/1 0:00:00 ,@EndDate = 2024/12/22 0:00:00 ,@tb_OrderSourceIds = 20031,19885,19883,19882,19881,19880,19878,19877,19876,19873,19872,19895,19874,19875,19879,17329,11567,10351,9416,6872,6871,6870,12243,6869,6868,20158,20157, , MESSAGE:Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. TRACE: 在 System.Data.SqlClient.SqlConnection.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.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_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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

历史记录

2024-12-23 14:38:19, 由 袁慧斌 创建。
2024-12-23 14:40:01, 由 李乐同 指派给 何智军。
修改了 指派给，旧值为 "liletong"，新值为 "hezhijun"。
2024-12-24 18:35:31, 由 何智军 解决，方案为 程序BUG 。
修改了 解决方案，旧值为 ""，新值为 "code"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2024-12-24 18:34:06"。
修改了 指派给 ，旧值为 "hezhijun"，新值为 "zengqian"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "hezhijun"。

问题原因：订单利润报告选择销售人员维度，不选销售人员查询报错。

解决方案：当选择销售人员维度，不选择销售人员查询时，提示需要选择销售人员
2024-12-24 19:42:33, 由曾倩编辑。
修改了 开发责任人，旧值为 ""，新值为 "hezhijun"。
修改了 测试责任人，旧值为 ""，新值为 "zengqian"。
修改了 解决时效 ，旧值为 "0"，新值为 ""。
修改了 重现步骤 ，区别为：
002- [11:44:32] [200] [http://158-1.zhcxkj.com:8093/ASHX/IrobotBox/SalesDateReportHandler.ashx][10.17.8.6][10.17.8.6/ASHX/IrobotBox/SalesDateReportHandler.ashx]--Http_Referer[http://158-1.zhcxkj.com/IrobotBox/ReportSale/SalesDateReport.aspx]--Message: 数据库处理错误，请联系智汇技术！标识：N1144325--GetType(): Exception--Source: RB.DAL--StackTrace: 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtend.Generate.RB_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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)
002+ [11:44:32] [200] [http://158-1.zhcxkj.com:8093/ASHX/IrobotBox/SalesDateReportHandler.ashx][10.17.8.6][10.17.8.6/ASHX/IrobotBox/SalesDateReportHandler.ashx]--Http_Referer[http://158-1.zhcxkj.com/IrobotBox/ReportSale/SalesDateReport.aspx]--Message: 数据库处理错误，请联系智汇技术！标识：N1144325--GetType(): Exception--Source: RB.DAL--StackTrace: 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtend.Generate.RB_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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)
005- [11:44:32] ------------------------------------------------------------- CODE:N1144325 Error:15_102_1_-2146232060 SQL:select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,1 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.SettlementShortDate>=@StartDate and alias.SettlementShortDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND alias.PromotionType=1 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.SettlementShortDate>=@StartDate AND alias.SettlementShortDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND alias.PromotionType=1 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () union all select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,0 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.ShipDate>=@StartDate and alias.ShipDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND ISNULL(alias.PromotionType,0)=0 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.ShipDate>=@StartDate AND alias.ShipDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND ISNULL(alias.PromotionType,0)=0 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () PARAMS:@CustomerID = 1 ,@StartDate = 2024/12/1 0:00:00 ,@EndDate = 2024/12/22 0:00:00 ,@tb_OrderSourceIds = 20031,19885,19883,19882,19881,19880,19878,19877,19876,19873,19872,19895,19874,19875,19879,17329,11567,10351,9416,6872,6871,6870,12243,6869,6868,20158,20157, , MESSAGE:Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. TRACE: 在 System.Data.SqlClient.SqlConnection.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.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_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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
005+ [11:44:32] ------------------------------------------------------------- CODE:N1144325 Error:15_102_1_-2146232060 SQL:select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,1 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.SettlementShortDate>=@StartDate and alias.SettlementShortDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND alias.PromotionType=1 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.SettlementShortDate>=@StartDate AND alias.SettlementShortDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND alias.PromotionType=1 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () union all select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,0 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.ShipDate>=@StartDate and alias.ShipDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND ISNULL(alias.PromotionType,0)=0 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.ShipDate>=@StartDate AND alias.ShipDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND ISNULL(alias.PromotionType,0)=0 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () PARAMS:@CustomerID = 1 ,@StartDate = 2024/12/1 0:00:00 ,@EndDate = 2024/12/22 0:00:00 ,@tb_OrderSourceIds = 20031,19885,19883,19882,19881,19880,19878,19877,19876,19873,19872,19895,19874,19875,19879,17329,11567,10351,9416,6872,6871,6870,12243,6869,6868,20158,20157, , MESSAGE:Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. TRACE: 在 System.Data.SqlClient.SqlConnection.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.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_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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

002- [11:44:32] [200] [http://158-1.zhcxkj.com:8093/ASHX/IrobotBox/SalesDateReportHandler.ashx][10.17.8.6][10.17.8.6/ASHX/IrobotBox/SalesDateReportHandler.ashx]--Http_Referer[http://158-1.zhcxkj.com/IrobotBox/ReportSale/SalesDateReport.aspx]--Message: 数据库处理错误，请联系智汇技术！标识：N1144325--GetType(): Exception--Source: RB.DAL--StackTrace: 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtend.Generate.RB_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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) 
002+ [11:44:32] [200] [http://158-1.zhcxkj.com:8093/ASHX/IrobotBox/SalesDateReportHandler.ashx][10.17.8.6][10.17.8.6/ASHX/IrobotBox/SalesDateReportHandler.ashx]--Http_Referer[http://158-1.zhcxkj.com/IrobotBox/ReportSale/SalesDateReport.aspx]--Message: 数据库处理错误，请联系智汇技术！标识：N1144325--GetType(): Exception--Source: RB.DAL--StackTrace: 在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DALExtend.Generate.RB_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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)
005- [11:44:32] ------------------------------------------------------------- CODE:N1144325 Error:15_102_1_-2146232060 SQL:select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,1 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.SettlementShortDate>=@StartDate and alias.SettlementShortDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND alias.PromotionType=1 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.SettlementShortDate>=@StartDate AND alias.SettlementShortDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND alias.PromotionType=1 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () union all select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,0 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.ShipDate>=@StartDate and alias.ShipDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND ISNULL(alias.PromotionType,0)=0 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.ShipDate>=@StartDate AND alias.ShipDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND ISNULL(alias.PromotionType,0)=0 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () PARAMS:@CustomerID = 1 ,@StartDate = 2024/12/1 0:00:00 ,@EndDate = 2024/12/22 0:00:00 ,@tb_OrderSourceIds = 20031,19885,19883,19882,19881,19880,19878,19877,19876,19873,19872,19895,19874,19875,19879,17329,11567,10351,9416,6872,6871,6870,12243,6869,6868,20158,20157, , MESSAGE:Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. TRACE: 在 System.Data.SqlClient.SqlConnection.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.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_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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
005+ [11:44:32] ------------------------------------------------------------- CODE:N1144325 Error:15_102_1_-2146232060 SQL:select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,1 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.SettlementShortDate>=@StartDate and alias.SettlementShortDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND alias.PromotionType=1 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.SettlementShortDate>=@StartDate AND alias.SettlementShortDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND alias.PromotionType=1 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () union all select ra.UserName as XAxis ,isnull(tmpsale.Profits,0) as OperateFee ,isnull(tmpsale.SalesPrice,0) as SalesPrice ,isnull(tmpsale.SalesPrice+tmpsale.TransportPay+tmpsale.SalesRefunds+tmpsale.PromotionRebates+tmpsale.OtherCredits+tmpsale.TaxIncome,0) as TotalIncome ,isnull(tmpsale.OrderNum,0) as OrderNum ,isnull(tmpsale.ProdutNum,0) as ProdutNum ,isnull(tmpsale.TransportPay,0) as TransportPay ,isnull(tmpsale.SalesRefunds,0) as RefundPrice ,isnull(tmpsale.SalesRefundsV2,0) as SalesRefundsV2 ,isnull(tmpsale.PromotionRebates,0) as PromotionFee ,isnull(tmpsale.OtherCredits,0) as OtherIncomeAmount ,isnull(tmpsale.CommisionFee,0) as CommissionFee ,isnull(tmpsale.FBATransactionFees,0) as FBAOperateFee ,isnull(tmpsale.OrderSourceOtherDebits,0) as OrderSourceCost ,isnull(tmpsale.CostOfAdvertising,0) as CostOfAdvertising ,isnull(tmpsale.BuyPrice,0) as BuyPrice ,isnull(tmpsale.TaxRefundFee,0) as TaxRefundFee ,isnull(tmpsale.PackageFees,0) as PackageShipedPrice ,isnull(tmpsale.OverSeasShipFees,0) as OverseaShipPrice ,isnull(tmpsale.FirstLegFees,0) as FirstLegPrice ,isnull(tmpsale.TariffFees,0) as TraiffPrice ,isnull(tmpsale.ExchangeLost,0) as ExchangeLost ,isnull(tmpsale.SalesVatFees,0) as SalesVatFees ,isnull(tmpsale.SubsidyPrice,0) as SubsidyPrice ,isnull(tmpsale.PackagedCost,0) as PackagedCost ,isnull(tmpsale.WareHouseManagementPrice,0) as WareHouseManagementPrice ,isnull(tmpsale.CustomFeeOtherCostPrice,0) as CustomFeeOtherCostPrice ,isnull(tmpsale.TaxIncome,0) AS TaxIncome ,isnull(tmpsale.ImportFee,0) as ImportFee ,isnull(tmpsale.BreakageFee,0) as BreakageFee ,isnull(tmpsale.AffiliatePartnerCommissionFee,0) as AffiliatePartnerCommissionFee ,isnull(tmpsale.CustomStorageFee,0) as CustomStorageFee ,0 AS PromotionType ,isnull(tmpsale.FirstLegBreakageFee,0) as FirstLegBreakageFee from RB_Admin ra with(nolock) LEFT JOIN ( select tmpfee.BusinessAdminID,tmpfee.Profits,tmpfee.SalesPrice,tmprest.OrderNum,tmprest.ProdutNum,tmpfee.TransportPay ,tmpfee.SalesRefunds,tmpfee.PromotionRebates,tmpfee.OtherCredits,tmpfee.CommisionFee,tmpfee.FBATransactionFees ,tmpfee.SalesRefundsV2 ,tmpfee.OrderSourceOtherDebits ,tmpfee.CostOfAdvertising ,tmpfee.WareHouseManagementPrice ,tmpfee.CustomFeeOtherCostPrice ,tmpfee.TaxIncome ,tmpfee.ImportFee ,tmpfee.BreakageFee ,tmpfee.AffiliatePartnerCommissionFee ,tmpfee.CustomStorageFee ,tmpfee.BuyPrice,tmpfee.TaxRefundFee,tmpfee.PackagedCost,tmpfee.PackageFees,tmpfee.OverSeasShipFees,tmpfee.FirstLegFees,tmpfee.TariffFees,tmpfee.ExchangeLost,tmpfee.SalesVatFees,tmpfee.SubsidyPrice ,tmpfee.FirstLegBreakageFee from ( select alias.BusinessAdminID ,ABS(SUM((CASE WHEN ISNULL(alias.SalesRefunds,0)=0 THEN 0 ELSE ISNULL(alias.SalesRefunds,0)+ISNULL(alias.PromotionRebates,0)+ISNULL(alias.OtherCredits,0)+ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0) END))) SalesRefundsV2 ,SUM(alias.Profits) Profits,SUM(alias.SalesPrice) SalesPrice,SUM(alias.TransportPay) TransportPay,SUM(alias.SalesRefunds) SalesRefunds,SUM(alias.PromotionRebates) PromotionRebates,SUM(alias.OtherCredits) OtherCredits ,SUM(alias.CommisionFee) CommisionFee,SUM(alias.FBATransactionFees) FBATransactionFees ,SUM(alias.OrderSourceOtherDebits) OrderSourceOtherDebits ,SUM(alias.CostOfAdvertising) CostOfAdvertising ,SUM((alias.BuyPrice+ISNULL(alias.DistributionPrice,0))) BuyPrice ,SUM((alias.TaxRefundFee)) TaxRefundFee ,SUM(alias.PackagedCost) PackagedCost,SUM(alias.PackageFees) PackageFees ,SUM(alias.OverSeasShipFees) OverSeasShipFees,SUM(alias.FirstLegFees) FirstLegFees,SUM(alias.TariffFees) TariffFees,SUM(alias.ExchangeLost) ExchangeLost ,SUM(ISNULL(alias.SalesVatFee,0)) as SalesVatFees ,SUM(ISNULL(alias.SubsidyPrice,0)) as SubsidyPrice ,SUM(ISNULL(alias.WareHouseManagementPrice,0)) as WareHouseManagementPrice ,SUM(ISNULL(alias.CustomFeeOtherCostPrice,0)) as CustomFeeOtherCostPrice ,Sum((ISNULL(alias.Tax,0)+ISNULL(alias.MarketplaceFacilitatorTax,0))) as TaxIncome ,SUM(ISNULL(alias.ImportFee,0)) as ImportFee ,SUM(ISNULL(alias.BreakageFee,0)) as BreakageFee ,SUM(ISNULL(alias.AffiliatePartnerCommissionFee,0)) as AffiliatePartnerCommissionFee ,SUM(ISNULL(alias.CustomStorageFee,0)) as CustomStorageFee ,SUM(ISNULL(alias.FirstLegBreakageFee,0)) as FirstLegBreakageFee from RB_Report_OrderSettlement alias(nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID where alias.CustomerID=@CustomerID and alias.ShipDate>=@StartDate and alias.ShipDate<dateadd(day,1,@EndDate) and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) and alias.BusinessAdminID in() AND ISNULL(alias.PromotionType,0)=0 group by alias.BusinessAdminID ) as tmpfee full join ( select count(*) as OrderNum,SUM(ProdutNum)ProdutNum, tmporder.BusinessAdminID from ( SELECT * FROM ( SELECT *, ROW_NUMBER() OVER(PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) rn, SUM(ProdutNum2) OVER ( PARTITION BY OrderCode ORDER BY BusinessAdminID DESC) ProdutNum FROM ( SELECT alias.OrderCode,alias.ProductNum+alias.ProdutNumUpdate ProdutNum2, alias.BusinessAdminID FROM dbo.RB_Report_OrderSettlement alias (nolock) left join RB_OrderInfo oi(NOLOCK) ON oi.CustomerID=alias.CustomerID AND oi.OrderSourceID=alias.OrderSourceID AND oi.OrderCode=alias.OrderCode INNER JOIN @tb_OrderSourceIds tosi ON tosi.Id = alias.OrderSourceID WHERE alias.CustomerID=@CustomerID AND alias.ShipDate>=@StartDate AND alias.ShipDate<dateadd(day,1,@EndDate) AND alias.SalesRefunds=0 and alias.OrderSourceType in (1,2,3,4,9,19,23,24,25,26,27,28,29,30,31,32,33,34,35,36,37,38,39,40,41,42,43,44,45,46,47,48,49,50,51,52,53,54,55,56,57,58,59,60,61,62,63,64,65,66,67,68,69,70,71,72,73,74,75,76,77,78,79,80,81,82,83,84,85,86,87,88,89,90,91,92,93,94,95,96,97,98,99,100,101,102,103,104,105,106,107,108,109,110,111,112,114,115,116,117,118,119,120,121,124,125,126,127,128,129,130,131,132,133,134,135,10000000) AND alias.BusinessAdminID in () AND alias.OrderCode <> '' AND ISNULL(alias.PromotionType,0)=0 ) source ) rst WHERE rn = 1 ) as tmporder group by BusinessAdminID ) as tmprest on tmprest.BusinessAdminID = tmpfee.BusinessAdminID ) as tmpsale on tmpsale.BusinessAdminID=ra.ID WHERE ra.CustomerID=@CustomerID AND ra.ID IN () PARAMS:@CustomerID = 1 ,@StartDate = 2024/12/1 0:00:00 ,@EndDate = 2024/12/22 0:00:00 ,@tb_OrderSourceIds = 20031,19885,19883,19882,19881,19880,19878,19877,19876,19873,19872,19895,19874,19875,19879,17329,11567,10351,9416,6872,6871,6870,12243,6869,6868,20158,20157, , MESSAGE:Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. Incorrect syntax near ')'. TRACE: 在 System.Data.SqlClient.SqlConnection.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.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_Report_OrderSettlementExtend.GetCensusByBusinessAdmin(RB_Report_OrderSettlement_PSParameters parameters) 在 PandaBuy.ERP.Web.ASHX.IrobotBox.SalesDateReportHandler.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
2024-12-24 19:42:40, 由曾倩关闭。
修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "zengqian"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "zengqian"。
修改了 关闭日期，旧值为 ""，新值为 "2024-12-24 19:42:40"。

基本信息
迭代/需求/任务

所属项目	技术中心-需求池
所属模块	财务财务管理
所属计划
所属迭代
Bug类型
严重程度	一般
优先级	P1
Bug状态	已关闭
业务部门
影响功能
开发责任人	何智军
测试责任人	曾倩
解决时效	0
激活次数	0
激活日期
是否确认	是
当前指派	Closed 于 2024-12-24 19:42:40
截止日期	0000-00-00
上线时间	0000-00-00 00:00:00
上线时效	-1
操作系统
浏览器
关键词
抄送给

所属迭代
相关需求
相关任务

Bug的一生
其他相关

由谁创建	袁慧斌于 2024-12-23 14:38:18
影响环境	577
由谁解决	何智军于 2024-12-24 18:34:06
解决版本	主干
解决方案	程序BUG
由谁关闭	曾倩于 2024-12-24 19:42:40
最后修改	曾倩于 2024-12-24 19:42:40

相关Bug