深圳智汇创想科技有限公司

[步骤]

[结果]

 CODE:N1936035
Error:11_-2_0_-2146232060
SQL:
SELECT * FROM (
SELECT
ROW_NUMBER() OVER (ORDER BY  WareHouseID) AS [PageIndex] ,* FROM (
                           select  
                            temp.WareHouseID,
                            temp.WareHouseName,
                            temp.CancelCount,
                            temp.PCount,
                            temp.MaxDay,
                            isnull(pu.OutPutNumZ,0) OutPutNumZ,
                            isnull(pu.InPutNumZ,0) InPutNumZ,
                            isnull(pu.OutPutNump,0) OutPutNump,
                            isnull(pu.InPutNumP,0) InPutNumP,
                            isnull(pu.OutPutNumM,0) OutPutNumM,
                            isnull(pu.InPutNumM,0) InPutNumM,
                            isnull(pu.OutPutNumB,0) OutPutNumB,
                            isnull(pu.InPutNumB,0) InPutNumB
                            from
                            (select  
                            isnull(wh.ID,0) WareHouseID,
                            wh.WareHouseName,
                            ISNULL(tep.CancelCount,0) CancelCount,
                            ISNULL(tep.PCount,0) PCount,
                            ISNULL(tep.MaxDay,0) MaxDay
                            from RB_WareHouse wh
                            full join
                            (select
                            wk.WareHouseID,
                            wk.CancelCount,
                            wk.PCount,
                            wk.MaxDay
                            from
                               (select
                               WareHouseID,
                               SUM(case when Status=3 then 1 else 0 end ) CancelCount,  
                               SUM(case when Status=4 then 1 else 0 end ) PCount,       
                               MAX(case when Status<>4 then 0 else DATEDIFF(day,AddTime,GETDATE()) end ) MaxDay
                               from
                               RB_Inventory_InOutBallance with(NOLOCK)
                               where CustomerID=@CustomerID    and AddTime >='2022-06-12'  and AddTime< DATEADD(DAY,1,'2022-07-12') group by WareHouseID
                               ) wk
                            ) tep on wh.ID=tep.WareHouseID
                            ) temp left join                          
                            (select
                            WareHouseID,
                            sum(case when InOutType=0 and OperateType in (13,23) then abs(Number) else 0 end ) InPutNumZ,
                            sum(case when InOutType=1 and OperateType in (13,23) then abs(Number) else 0 end ) OutPutNumZ,
                            sum(case when InOutType=0 and OperateType in (11,20) then abs(Number) else 0 end ) InPutNumP,
                            sum(case when InOutType=1 and OperateType in (11,20) then abs(Number) else 0 end ) OutPutNump,
                            sum(case when InOutType=0 and OperateType in (21,12) then abs(Number) else 0 end ) InPutNumM,
                            sum(case when InOutType=1 and OperateType in (21,12) then abs(Number) else 0 end ) OutPutNumM,
                            sum(case when InOutType=0 and OperateType in (19,17) then abs(Number) else 0 end ) InPutNumB,
                            sum(case when InOutType=1 and OperateType in (19,17) then abs(Number) else 0 end ) OutPutNumB
                            from  
                            RB_Inventory_InOutBallance with (NOLOCK)  where  Status=5 and CustomerID=@CustomerID  and AddTime >='2022-06-12'  and AddTime< DATEADD(DAY,1,'2022-07-12')  group by WareHouseID
                             ) pu on temp.WareHouseID=pu.WareHouseID
                             where temp.CancelCount<>0 or temp.PCount<>0 or pu.InPutNumB<>0 or pu.InPutNumM<>0 or pu.InPutNumP<>0 or pu.InPutNumZ<>0
                                   or pu.OutPutNumB<>0 or pu.OutPutNumM<>0 or pu.OutPutNumZ<>0 or pu.OutPutNump<>0  ) AS TempTable ) AS  PagerTable WHERE PagerTable.[PageIndex] BETWEEN 1 AND 20
PARAMS:@CustomerID = 1 ,
MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。
TRACE:   在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)
   在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)
   在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean& dataReady)
   在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()
   在 System.Data.SqlClient.SqlDataReader.get_MetaData()
   在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task& task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task& task, Boolean& usedCache, Boolean asyncWrite, Boolean inRetry)
   在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteReader(CommandBehavior behavior, String method)
   在 System.Data.SqlClient.SqlCommand.ExecuteDbDataReader(CommandBehavior behavior)
   在 System.Data.Common.DbCommand.System.Data.IDbCommand.ExecuteReader(CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.FillInternal(DataSet dataset, DataTable[] datatables, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, Int32 startRecord, Int32 maxRecords, String srcTable, IDbCommand command, CommandBehavior behavior)
   在 System.Data.Common.DbDataAdapter.Fill(DataSet dataSet, String srcTable)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)   在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)
   在 RB.DAL.DBOperator.Query(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)
   在 RB.DAL.DBOperator.QueryPager(String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, SqlParameter[] cmdParms)
   在 RB.DALExtend.Generate.RB_Inventory_InOutBallanceExtend.GetDiffControlList(Difference_Control_Hand_Para para, Int32& recordCount)
   在 PandaBuy.ERP.Web.IrobotBox.WareHouse.Difference_Control_handStock.SearchData(Difference_Control_Hand_Para para, Pager pager)
   在 PandaBuy.ERP.Web.IrobotBox.WareHouse.Difference_Control_handStock.Page_Load(Object sender, EventArgs e)
   在 System.Web.Util.CalliEventHandlerDelegateProxy.Callback(Object sender, EventArgs e)
   在 System.Web.UI.Control.OnLoad(EventArgs e)
   在 System.Web.UI.Control.LoadRecursive()
   在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)
   在 System.Web.UI.Page.ProcessRequest()
   在 System.Web.UI.Page.ProcessRequestWithNoAssert(HttpContext context)
   在 System.Web.UI.Page.ProcessRequest(HttpContext context)
   在 ASP.irobotbox_warehouse_difference_control_handstock_aspx.ProcessRequest(HttpContext context)
   在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()
   在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)
   在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously)
   在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)
   在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)
   在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)
   在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)

[期望]