修改了 指派给，旧值为 "liletong"，新值为 "hejianbao"。

修改了 解决时效，旧值为 "0"，新值为 "-1"。
修改了 指派给 ，旧值为 "hejianbao"，新值为 "liletong"。
修改了 重现步骤，区别为：

002- CODE:N1123054Error:11_-2_0_-2146232060SQL:CREATE TABLE #tempSku(item VARCHAR(400));INSERT INTO #tempSkuEXEC proc_string_split @stringSku,',';CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (SELECT RB_Product_Supplier.SupplierType , RB_Product_Supplier.Remark, CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款' WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款' WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款' WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款' ELSE '未知类型' END AS PaymentDayCn , RB_Product_Supplier.QQ , RB_Product_Supplier.WangWang , ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID , RB_Product_Supplier.LoginSupplyType , WareHouseName , RB_Procurement_List.WareHouseID, RB_Procurement_List.AOrderCode , ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree , E_Website.Domain , RB_Procurement_List.ID , RB_Procurement_List.P_Code , RB_Procurement_List.AddTime , RB_Procurement_List.PrintTime , RB_Procurement_List.FinishTime , RB_Procurement_List.ProcPayType , RB_Procurement_List.BuyerId , RB_Procurement_List.BuyerName , RB_Procurement_List.DevelopAdminName , RB_Procurement_List.ProcurementListState , RB_Procurement_List.FinishStatus , RB_Procurement_List.ProcurementLocation , RB_Procurement_List.SupplierName , RB_Procurement_List.ExpectedTimeOfDelivery , RB_Procurement_List.IsUrgent , RB_Procurement_List.IsFirstOrder , RB_Procurement_List.IsFirstSupplierOrder , RB_Procurement_List.IsFirstOrderWithinYear , ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus , '' AS SingleInfo , RB_Product_Supplier.NetFromType, RB_Product_Supplier.IsFBABarCode, 0 AS StillNeedNum, --还需 0 AS DemandNum,--需求数量 0 AS ActualBuyNum,--销单数量 0 AS SingleNum, --下单数量 0 AS PutNum, --入库数量 0.0000 AS EstimatedAmount, --预计金额 0.0000 AS ActualProductPrice,--实际金额 '' AS LastSingleTime,--最后下单实际 RB_OrderInfo.ClientOrderCode, --客户订单号 RB_Procurement_List.AutomaticOrderResult,--自动下单结果 RB_Procurement_List.IsAutomaticOrder,--是否自动下单 RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注 RB_Procurement_List.IsSample, --样品 RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝 ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrderFROM RB_Procurement_List (NOLOCK) LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode WHERE ( RB_Procurement_List.CustomerID = 1 ) AND RB_Procurement_List.FinishStatus=0 AND ( RB_Procurement_List.P_Code IN ( SELECT P_Code FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK ) WHERE StepState IN ( 0, -1 ) AND IsDelete IS NULL AND CustomerID = 1 ) ) AND RB_Procurement_List.AddTime >= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime <= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;PARAMS:@stringSku = null ,@listIds = null ,MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。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.ExecuteScalar() 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.QueryTemporaryTablePager(String sqlDeclare, String sqlRecycle, String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, Boolean IsWriteDB, SqlParameter[] cmdParms) 在 RB.DALExtendV2.RB_Procurement_ListExtendV2.GetProcurementPageList(RB_Procurement_List_PSParametersExtend parameters, Int32& recordCount) 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.InitData() 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.Page_Load(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.ProcessRequest(HttpContext context) 在 ASP.irobotbox_procurementv2_procurementlist_new_aspx.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) 在 System.Web.Hosting.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)
002+ CODE:N1123054Error:11_-2_0_-2146232060SQL:CREATE TABLE #tempSku(item VARCHAR(400));INSERT INTO #tempSkuEXEC proc_string_split @stringSku,',';CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (SELECT RB_Product_Supplier.SupplierType , RB_Product_Supplier.Remark, CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款' WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款' WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款' WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款' ELSE '未知类型' END AS PaymentDayCn , RB_Product_Supplier.QQ , RB_Product_Supplier.WangWang , ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID , RB_Product_Supplier.LoginSupplyType , WareHouseName , RB_Procurement_List.WareHouseID, RB_Procurement_List.AOrderCode , ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree , E_Website.Domain , RB_Procurement_List.ID , RB_Procurement_List.P_Code , RB_Procurement_List.AddTime , RB_Procurement_List.PrintTime , RB_Procurement_List.FinishTime , RB_Procurement_List.ProcPayType , RB_Procurement_List.BuyerId , RB_Procurement_List.BuyerName , RB_Procurement_List.DevelopAdminName , RB_Procurement_List.ProcurementListState , RB_Procurement_List.FinishStatus , RB_Procurement_List.ProcurementLocation , RB_Procurement_List.SupplierName , RB_Procurement_List.ExpectedTimeOfDelivery , RB_Procurement_List.IsUrgent , RB_Procurement_List.IsFirstOrder , RB_Procurement_List.IsFirstSupplierOrder , RB_Procurement_List.IsFirstOrderWithinYear , ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus , '' AS SingleInfo , RB_Product_Supplier.NetFromType, RB_Product_Supplier.IsFBABarCode, 0 AS StillNeedNum, --还需 0 AS DemandNum,--需求数量 0 AS ActualBuyNum,--销单数量 0 AS SingleNum, --下单数量 0 AS PutNum, --入库数量 0.0000 AS EstimatedAmount, --预计金额 0.0000 AS ActualProductPrice,--实际金额 '' AS LastSingleTime,--最后下单实际 RB_OrderInfo.ClientOrderCode, --客户订单号 RB_Procurement_List.AutomaticOrderResult,--自动下单结果 RB_Procurement_List.IsAutomaticOrder,--是否自动下单 RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注 RB_Procurement_List.IsSample, --样品 RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝 ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrderFROM RB_Procurement_List (NOLOCK) LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode WHERE ( RB_Procurement_List.CustomerID = 1 ) AND RB_Procurement_List.FinishStatus=0 AND ( RB_Procurement_List.P_Code IN ( SELECT P_Code FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK ) WHERE StepState IN ( 0, -1 ) AND IsDelete IS NULL AND CustomerID = 1 ) ) AND RB_Procurement_List.AddTime >= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime <= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;PARAMS:@stringSku = null ,@listIds = null ,MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。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.ExecuteScalar() 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms) 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.QueryTemporaryTablePager(String sqlDeclare, String sqlRecycle, String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32& recordCount, Int32 times, Boolean IsWriteDB, SqlParameter[] cmdParms) 在 RB.DALExtendV2.RB_Procurement_ListExtendV2.GetProcurementPageList(RB_Procurement_List_PSParametersExtend parameters, Int32& recordCount) 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.InitData() 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.Page_Load(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.ProcessRequest(HttpContext context) 在 ASP.irobotbox_procurementv2_procurementlist_new_aspx.ProcessRequest(HttpContext context) 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute() 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step) 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean& completedSynchronously) 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error) 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb) 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags) 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus& notificationStatus) 在 System.Web.Hosting.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)
005- [期望结果]
005+ [期望结果]
006+
007+ 包含有时间条件的情况下 建议 把 SELECT P_Code FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK ) WHERE StepState IN ( 0, -1 ) AND IsDelete IS NULL
008+ AND CustomerID = 1
009+
010+ 加入AddTime>= '2025-03-07 00:00:00'
011+
012+
013+ 整体情况
014+ declare @stringSku varchar(200)= '' ,@listIds varchar(200)= ''CREATE TABLE #tempSku(item VARCHAR(400));INSERT INTO #tempSkuEXEC proc_string_split @stringSku,',';CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (SELECT RB_Product_Supplier.SupplierType , RB_Product_Supplier.Remark, CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款' WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款' WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款' WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款' ELSE '未知类型' END AS PaymentDayCn , RB_Product_Supplier.QQ , RB_Product_Supplier.WangWang , ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID , RB_Product_Supplier.LoginSupplyType , WareHouseName , RB_Procurement_List.WareHouseID, RB_Procurement_List.AOrderCode , ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree , E_Website.Domain , RB_Procurement_List.ID , RB_Procurement_List.P_Code , RB_Procurement_List.AddTime , RB_Procurement_List.PrintTime , RB_Procurement_List.FinishTime , RB_Procurement_List.ProcPayType , RB_Procurement_List.BuyerId , RB_Procurement_List.BuyerName , RB_Procurement_List.DevelopAdminName , RB_Procurement_List.ProcurementListState , RB_Procurement_List.FinishStatus , RB_Procurement_List.ProcurementLocation , RB_Procurement_List.SupplierName , RB_Procurement_List.ExpectedTimeOfDelivery , RB_Procurement_List.IsUrgent , RB_Procurement_List.IsFirstOrder , RB_Procurement_List.IsFirstSupplierOrder , RB_Procurement_List.IsFirstOrderWithinYear , ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus , '' AS SingleInfo , RB_Product_Supplier.NetFromType, RB_Product_Supplier.IsFBABarCode, 0 AS StillNeedNum, --还需 0 AS DemandNum,--需求数量 0 AS ActualBuyNum,--销单数量 0 AS SingleNum, --下单数量 0 AS PutNum, --入库数量 0.0000 AS EstimatedAmount, --预计金额 0.0000 AS ActualProductPrice,--实际金额 '' AS LastSingleTime,--最后下单实际 RB_OrderInfo.ClientOrderCode, --客户订单号 RB_Procurement_List.AutomaticOrderResult,--自动下单结果 RB_Procurement_List.IsAutomaticOrder,--是否自动下单 RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注 RB_Procurement_List.IsSample, --样品 RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝 ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrderFROM RB_Procurement_List (NOLOCK) LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode WHERE ( RB_Procurement_List.CustomerID = 1 ) AND RB_Procurement_List.FinishStatus=0 AND ( RB_Procurement_List.P_Code IN ( SELECT P_Code FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK ) WHERE StepState IN ( 0, -1 ) AND IsDelete IS NULL AND CustomerID = 1and AddTime>= '2025-03-07 00:00:00' ) ) AND RB_Procurement_List.AddTime >= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime <= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;

002- <p>CODE:N1123054<br /><br />Error:11_-2_0_-2146232060<br /><br />SQL:CREATE TABLE #tempSku(item VARCHAR(400));<br /><br />INSERT INTO #tempSku<br /><br />EXEC proc_string_split @stringSku,',';<br /><br />CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (<br /><br />SELECT RB_Product_Supplier.SupplierType ,<br /><br /> RB_Product_Supplier.Remark,<br /><br /> CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款'<br /><br /> ELSE '未知类型'<br /><br /> END AS PaymentDayCn ,<br /><br /> RB_Product_Supplier.QQ ,<br /><br /> RB_Product_Supplier.WangWang ,<br /><br /> ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID ,<br /><br /> RB_Product_Supplier.LoginSupplyType ,<br /><br /> WareHouseName ,<br /><br /> RB_Procurement_List.WareHouseID,<br /><br /> RB_Procurement_List.AOrderCode ,<br /><br /> ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree ,<br /><br /> E_Website.Domain ,<br /><br /> RB_Procurement_List.ID ,<br /><br /> RB_Procurement_List.P_Code ,<br /><br /> RB_Procurement_List.AddTime ,<br /><br /> RB_Procurement_List.PrintTime ,<br /><br /> RB_Procurement_List.FinishTime ,<br /><br /> RB_Procurement_List.ProcPayType ,<br /><br /> RB_Procurement_List.BuyerId ,<br /><br /> RB_Procurement_List.BuyerName ,<br /><br /> RB_Procurement_List.DevelopAdminName ,<br /><br /> RB_Procurement_List.ProcurementListState ,<br /><br /> RB_Procurement_List.FinishStatus ,<br /><br /> RB_Procurement_List.ProcurementLocation ,<br /><br /> RB_Procurement_List.SupplierName ,<br /><br /> RB_Procurement_List.ExpectedTimeOfDelivery ,<br /><br /> RB_Procurement_List.IsUrgent ,<br /><br /> RB_Procurement_List.IsFirstOrder ,<br /><br /> RB_Procurement_List.IsFirstSupplierOrder ,<br /><br /> RB_Procurement_List.IsFirstOrderWithinYear ,<br /><br /> ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus ,<br /><br /> '' AS SingleInfo ,<br /><br /> RB_Product_Supplier.NetFromType,<br /><br /> RB_Product_Supplier.IsFBABarCode,<br /><br /> 0 AS StillNeedNum, --还需<br /><br /> 0 AS DemandNum,--需求数量<br /><br /> 0 AS ActualBuyNum,--销单数量<br /><br /> 0 AS SingleNum, --下单数量<br /><br /> 0 AS PutNum, --入库数量<br /><br /> 0.0000 AS EstimatedAmount, --预计金额<br /><br /> 0.0000 AS ActualProductPrice,--实际金额<br /><br /> '' AS LastSingleTime,--最后下单实际<br /><br /> RB_OrderInfo.ClientOrderCode, --客户订单号<br /><br /> RB_Procurement_List.AutomaticOrderResult,--自动下单结果<br /><br /> RB_Procurement_List.IsAutomaticOrder,--是否自动下单<br /><br /> RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注<br /><br /> RB_Procurement_List.IsSample, --样品<br /><br /> RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝<br /><br /> ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrder<br /><br />FROM RB_Procurement_List (NOLOCK)<br /><br /> LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID<br /><br /> LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID<br /><br /> LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID<br /><br /> LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID<br /><br /> AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode<br /><br /> <br /><br /><br /><br />WHERE ( RB_Procurement_List.CustomerID = 1 )<br /><br /> AND RB_Procurement_List.FinishStatus=0 AND (<br /><br /> RB_Procurement_List.P_Code IN (<br /><br /> SELECT P_Code<br /><br /> FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK )<br /><br /> WHERE StepState IN ( 0, -1 )<br /><br /> AND IsDelete IS NULL<br /><br /> AND CustomerID = 1 ) ) AND RB_Procurement_List.AddTime &gt;= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime &lt;= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;<br /><br />PARAMS:@stringSku = null ,@listIds = null ,<br /><br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。<br /><br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)<br /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteScalar()<br /><br /> 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br /> 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /><br /> 在 RB.DAL.DBOperator.QueryTemporaryTablePager(String sqlDeclare, String sqlRecycle, String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32&amp; recordCount, Int32 times, Boolean IsWriteDB, SqlParameter[] cmdParms)<br /><br /> 在 RB.DALExtendV2.RB_Procurement_ListExtendV2.GetProcurementPageList(RB_Procurement_List_PSParametersExtend parameters, Int32&amp; recordCount)<br /><br /> 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.InitData()<br /><br /> 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.Page_Load(Object sender, EventArgs e)<br /><br /> 在 System.Web.UI.Control.OnLoad(EventArgs e)<br /><br /> 在 System.Web.UI.Control.LoadRecursive()<br /><br /> 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /><br /> 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /><br /> 在 System.Web.UI.Page.ProcessRequest()<br /><br /> 在 System.Web.UI.Page.ProcessRequest(HttpContext context)<br /><br /> 在 ASP.irobotbox_procurementv2_procurementlist_new_aspx.ProcessRequest(HttpContext context)<br /><br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /><br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /><br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /><br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /><br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /><br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /></p>
002+ <p>CODE:N1123054<br /><br />Error:11_-2_0_-2146232060<br /><br />SQL:CREATE TABLE #tempSku(item VARCHAR(400));<br /><br />INSERT INTO #tempSku<br /><br />EXEC proc_string_split @stringSku,',';<br /><br />CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (<br /><br />SELECT RB_Product_Supplier.SupplierType ,<br /><br /> RB_Product_Supplier.Remark,<br /><br /> CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款'<br /><br /> ELSE '未知类型'<br /><br /> END AS PaymentDayCn ,<br /><br /> RB_Product_Supplier.QQ ,<br /><br /> RB_Product_Supplier.WangWang ,<br /><br /> ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID ,<br /><br /> RB_Product_Supplier.LoginSupplyType ,<br /><br /> WareHouseName ,<br /><br /> RB_Procurement_List.WareHouseID,<br /><br /> RB_Procurement_List.AOrderCode ,<br /><br /> ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree ,<br /><br /> E_Website.Domain ,<br /><br /> RB_Procurement_List.ID ,<br /><br /> RB_Procurement_List.P_Code ,<br /><br /> RB_Procurement_List.AddTime ,<br /><br /> RB_Procurement_List.PrintTime ,<br /><br /> RB_Procurement_List.FinishTime ,<br /><br /> RB_Procurement_List.ProcPayType ,<br /><br /> RB_Procurement_List.BuyerId ,<br /><br /> RB_Procurement_List.BuyerName ,<br /><br /> RB_Procurement_List.DevelopAdminName ,<br /><br /> RB_Procurement_List.ProcurementListState ,<br /><br /> RB_Procurement_List.FinishStatus ,<br /><br /> RB_Procurement_List.ProcurementLocation ,<br /><br /> RB_Procurement_List.SupplierName ,<br /><br /> RB_Procurement_List.ExpectedTimeOfDelivery ,<br /><br /> RB_Procurement_List.IsUrgent ,<br /><br /> RB_Procurement_List.IsFirstOrder ,<br /><br /> RB_Procurement_List.IsFirstSupplierOrder ,<br /><br /> RB_Procurement_List.IsFirstOrderWithinYear ,<br /><br /> ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus ,<br /><br /> '' AS SingleInfo ,<br /><br /> RB_Product_Supplier.NetFromType,<br /><br /> RB_Product_Supplier.IsFBABarCode,<br /><br /> 0 AS StillNeedNum, --还需<br /><br /> 0 AS DemandNum,--需求数量<br /><br /> 0 AS ActualBuyNum,--销单数量<br /><br /> 0 AS SingleNum, --下单数量<br /><br /> 0 AS PutNum, --入库数量<br /><br /> 0.0000 AS EstimatedAmount, --预计金额<br /><br /> 0.0000 AS ActualProductPrice,--实际金额<br /><br /> '' AS LastSingleTime,--最后下单实际<br /><br /> RB_OrderInfo.ClientOrderCode, --客户订单号<br /><br /> RB_Procurement_List.AutomaticOrderResult,--自动下单结果<br /><br /> RB_Procurement_List.IsAutomaticOrder,--是否自动下单<br /><br /> RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注<br /><br /> RB_Procurement_List.IsSample, --样品<br /><br /> RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝<br /><br /> ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrder<br /><br />FROM RB_Procurement_List (NOLOCK)<br /><br /> LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID<br /><br /> LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID<br /><br /> LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID<br /><br /> LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID<br /><br /> AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode<br /><br /> <br /><br /><br /><br />WHERE ( RB_Procurement_List.CustomerID = 1 )<br /><br /> AND RB_Procurement_List.FinishStatus=0 AND (<br /><br /> RB_Procurement_List.P_Code IN (<br /><br /> SELECT P_Code<br /><br /> FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK )<br /><br /> WHERE StepState IN ( 0, -1 )<br /><br /> AND IsDelete IS NULL<br /><br /> AND CustomerID = 1 ) ) AND RB_Procurement_List.AddTime &gt;= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime &lt;= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;<br /><br />PARAMS:@stringSku = null ,@listIds = null ,<br /><br />MESSAGE:执行超时已过期。完成操作之前已超时或服务器未响应。<br /><br />TRACE: 在 System.Data.SqlClient.SqlConnection.OnError(SqlException exception, Boolean breakConnection, Action`1 wrapCloseInAction)<br /><br /> 在 System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj, Boolean callerHasConnectionLock, Boolean asyncClose)<br /><br /> 在 System.Data.SqlClient.TdsParser.TryRun(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj, Boolean&amp; dataReady)<br /><br /> 在 System.Data.SqlClient.SqlDataReader.TryConsumeMetaData()<br /><br /> 在 System.Data.SqlClient.SqlDataReader.get_MetaData()<br /><br /> 在 System.Data.SqlClient.SqlCommand.FinishExecuteReader(SqlDataReader ds, RunBehavior runBehavior, String resetOptionsString, Boolean isInternal, Boolean forDescribeParameterEncryption, Boolean shouldCacheForAlwaysEncrypted)<br /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReaderTds(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, Boolean async, Int32 timeout, Task&amp; task, Boolean asyncWrite, Boolean inRetry, SqlDataReader ds, Boolean describeParameterEncryptionRequest)<br /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method, TaskCompletionSource`1 completion, Int32 timeout, Task&amp; task, Boolean&amp; usedCache, Boolean asyncWrite, Boolean inRetry)<br /><br /> 在 System.Data.SqlClient.SqlCommand.RunExecuteReader(CommandBehavior cmdBehavior, RunBehavior runBehavior, Boolean returnStream, String method)<br /><br /> 在 System.Data.SqlClient.SqlCommand.ExecuteScalar()<br /><br /> 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB) 在 RB.DAL.DBOperator.toCommonTipException(SqlException ex, String sql, SqlParameter[] cmdParms)<br /><br /> 在 RB.DAL.DBOperator.GetSingle(String SQLString, SqlCommand cmd, Int32 Times, SqlParameter[] cmdParms, Boolean IsWriteDB)<br /><br /> 在 RB.DAL.DBOperator.QueryTemporaryTablePager(String sqlDeclare, String sqlRecycle, String SQLString, String strOrder, Int32 pageIndex, Int32 pageSize, Int32&amp; recordCount, Int32 times, Boolean IsWriteDB, SqlParameter[] cmdParms)<br /><br /> 在 RB.DALExtendV2.RB_Procurement_ListExtendV2.GetProcurementPageList(RB_Procurement_List_PSParametersExtend parameters, Int32&amp; recordCount)<br /><br /> 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.InitData()<br /><br /> 在 PandaBuy.ERP.Web.IrobotBox.ProcurementV2.ProcurementList_New.Page_Load(Object sender, EventArgs e)<br /><br /> 在 System.Web.UI.Control.OnLoad(EventArgs e)<br /><br /> 在 System.Web.UI.Control.LoadRecursive()<br /><br /> 在 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /><br /> 在 System.Web.UI.Page.ProcessRequest(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint)<br /><br /> 在 System.Web.UI.Page.ProcessRequest()<br /><br /> 在 System.Web.UI.Page.ProcessRequest(HttpContext context)<br /><br /> 在 ASP.irobotbox_procurementv2_procurementlist_new_aspx.ProcessRequest(HttpContext context)<br /><br /> 在 System.Web.HttpApplication.CallHandlerExecutionStep.System.Web.HttpApplication.IExecutionStep.Execute()<br /><br /> 在 System.Web.HttpApplication.ExecuteStepImpl(IExecutionStep step)<br /><br /> 在 System.Web.HttpApplication.ExecuteStep(IExecutionStep step, Boolean&amp; completedSynchronously)<br /><br /> 在 System.Web.HttpApplication.PipelineStepManager.ResumeSteps(Exception error)<br /><br /> 在 System.Web.HttpApplication.BeginProcessRequestNotification(HttpContext context, AsyncCallback cb)<br /><br /> 在 System.Web.HttpRuntime.ProcessRequestNotificationPrivate(IIS7WorkerRequest wr, HttpContext context)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.UnsafeIISMethods.MgdIndicateCompletion(IntPtr pHandler, RequestNotificationStatus&amp; notificationStatus)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotificationHelper(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)<br /><br /> 在 System.Web.Hosting.PipelineRuntime.ProcessRequestNotification(IntPtr rootedObjectsPointer, IntPtr nativeRequestContext, IntPtr moduleData, Int32 flags)</p>
005- <p>[期望结果]</p>
005+ <p>[期望结果]</p>
006+ <p><br /></p>
007+ <p>包含有时间条件的情况下 建议 把<br /><br /> SELECT P_Code<br /><br /> FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK )<br /><br /> WHERE StepState IN ( 0, -1 )<br /><br /> AND IsDelete IS NULL</p>
008+ <p><br /><br /> AND CustomerID = 1</p>
009+ <p><br /></p>
010+ <p><span>加入</span><span>AddTime&gt;= '2025-03-07 00:00:00'</span></p>
011+ <p><br /></p>
012+ <p><br /></p>
013+ <p>整体情况</p>
014+ <p>declare @stringSku varchar(200)= '' ,@listIds varchar(200)= ''<br />CREATE TABLE #tempSku(item VARCHAR(400));<br /><br />INSERT INTO #tempSku<br /><br />EXEC proc_string_split @stringSku,',';<br /><br />CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (<br /><br />SELECT RB_Product_Supplier.SupplierType ,<br /><br /> RB_Product_Supplier.Remark,<br /><br /> CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款'<br /><br /> ELSE '未知类型'<br /><br /> END AS PaymentDayCn ,<br /><br /> RB_Product_Supplier.QQ ,<br /><br /> RB_Product_Supplier.WangWang ,<br /><br /> ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID ,<br /><br /> RB_Product_Supplier.LoginSupplyType ,<br /><br /> WareHouseName ,<br /><br /> RB_Procurement_List.WareHouseID,<br /><br /> RB_Procurement_List.AOrderCode ,<br /><br /> ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree ,<br /><br /> E_Website.Domain ,<br /><br /> RB_Procurement_List.ID ,<br /><br /> RB_Procurement_List.P_Code ,<br /><br /> RB_Procurement_List.AddTime ,<br /><br /> RB_Procurement_List.PrintTime ,<br /><br /> RB_Procurement_List.FinishTime ,<br /><br /> RB_Procurement_List.ProcPayType ,<br /><br /> RB_Procurement_List.BuyerId ,<br /><br /> RB_Procurement_List.BuyerName ,<br /><br /> RB_Procurement_List.DevelopAdminName ,<br /><br /> RB_Procurement_List.ProcurementListState ,<br /><br /> RB_Procurement_List.FinishStatus ,<br /><br /> RB_Procurement_List.ProcurementLocation ,<br /><br /> RB_Procurement_List.SupplierName ,<br /><br /> RB_Procurement_List.ExpectedTimeOfDelivery ,<br /><br /> RB_Procurement_List.IsUrgent ,<br /><br /> RB_Procurement_List.IsFirstOrder ,<br /><br /> RB_Procurement_List.IsFirstSupplierOrder ,<br /><br /> RB_Procurement_List.IsFirstOrderWithinYear ,<br /><br /> ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus ,<br /><br /> '' AS SingleInfo ,<br /><br /> RB_Product_Supplier.NetFromType,<br /><br /> RB_Product_Supplier.IsFBABarCode,<br /><br /> 0 AS StillNeedNum, --还需<br /><br /> 0 AS DemandNum,--需求数量<br /><br /> 0 AS ActualBuyNum,--销单数量<br /><br /> 0 AS SingleNum, --下单数量<br /><br /> 0 AS PutNum, --入库数量<br /><br /> 0.0000 AS EstimatedAmount, --预计金额<br /><br /> 0.0000 AS ActualProductPrice,--实际金额<br /><br /> '' AS LastSingleTime,--最后下单实际<br /><br /> RB_OrderInfo.ClientOrderCode, --客户订单号<br /><br /> RB_Procurement_List.AutomaticOrderResult,--自动下单结果<br /><br /> RB_Procurement_List.IsAutomaticOrder,--是否自动下单<br /><br /> RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注<br /><br /> RB_Procurement_List.IsSample, --样品<br /><br /> RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝<br /><br /> ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrder<br /><br />FROM RB_Procurement_List (NOLOCK)<br /><br /> LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID<br /><br /> LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID<br /><br /> LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID<br /><br /> LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID<br /><br /> AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode<br /><br /> <br /><br /><br /><br />WHERE ( RB_Procurement_List.CustomerID = 1 )<br /><br /> AND RB_Procurement_List.FinishStatus=0 AND (<br /><br /> RB_Procurement_List.P_Code IN (<br /><br /> SELECT P_Code<br /><br /> FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK )<br /><br /> WHERE StepState IN ( 0, -1 )<br /><br /> AND IsDelete IS NULL<br /><br /> AND CustomerID = 1<br /><span style="background-color:#E53333;"><strong>and AddTime&gt;= '2025-03-07 00:00:00'</strong></span><br /><span><span> </span>) ) AND RB_Procurement_List.AddTime &gt;= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime &lt;= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;</span><br /><br /></p>

修改了 指派给，旧值为 "liletong"，新值为 "hejianbao"。

修改了 指派给，旧值为 "hejianbao"，新值为 "xujionghua"。

修改了 解决时效，旧值为 "0"，新值为 "NaN"。
修改了 上线时间，旧值为 "0000-00-00 00:00:00"，新值为 "2025-03-07 19:08"。
修改了 上线时效，旧值为 "-1"，新值为 "7.43"。
修改了 重现步骤，区别为：

014- declare @stringSku varchar(200)= '' ,@listIds varchar(200)= ''CREATE TABLE #tempSku(item VARCHAR(400));INSERT INTO #tempSkuEXEC proc_string_split @stringSku,',';CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (SELECT RB_Product_Supplier.SupplierType , RB_Product_Supplier.Remark, CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款' WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款' WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款' WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款' ELSE '未知类型' END AS PaymentDayCn , RB_Product_Supplier.QQ , RB_Product_Supplier.WangWang , ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID , RB_Product_Supplier.LoginSupplyType , WareHouseName , RB_Procurement_List.WareHouseID, RB_Procurement_List.AOrderCode , ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree , E_Website.Domain , RB_Procurement_List.ID , RB_Procurement_List.P_Code , RB_Procurement_List.AddTime , RB_Procurement_List.PrintTime , RB_Procurement_List.FinishTime , RB_Procurement_List.ProcPayType , RB_Procurement_List.BuyerId , RB_Procurement_List.BuyerName , RB_Procurement_List.DevelopAdminName , RB_Procurement_List.ProcurementListState , RB_Procurement_List.FinishStatus , RB_Procurement_List.ProcurementLocation , RB_Procurement_List.SupplierName , RB_Procurement_List.ExpectedTimeOfDelivery , RB_Procurement_List.IsUrgent , RB_Procurement_List.IsFirstOrder , RB_Procurement_List.IsFirstSupplierOrder , RB_Procurement_List.IsFirstOrderWithinYear , ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus , '' AS SingleInfo , RB_Product_Supplier.NetFromType, RB_Product_Supplier.IsFBABarCode, 0 AS StillNeedNum, --还需 0 AS DemandNum,--需求数量 0 AS ActualBuyNum,--销单数量 0 AS SingleNum, --下单数量 0 AS PutNum, --入库数量 0.0000 AS EstimatedAmount, --预计金额 0.0000 AS ActualProductPrice,--实际金额 '' AS LastSingleTime,--最后下单实际 RB_OrderInfo.ClientOrderCode, --客户订单号 RB_Procurement_List.AutomaticOrderResult,--自动下单结果 RB_Procurement_List.IsAutomaticOrder,--是否自动下单 RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注 RB_Procurement_List.IsSample, --样品 RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝 ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrderFROM RB_Procurement_List (NOLOCK) LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode WHERE ( RB_Procurement_List.CustomerID = 1 ) AND RB_Procurement_List.FinishStatus=0 AND ( RB_Procurement_List.P_Code IN ( SELECT P_Code FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK ) WHERE StepState IN ( 0, -1 ) AND IsDelete IS NULL AND CustomerID = 1and AddTime&gt;= '2025-03-07 00:00:00' ) ) AND RB_Procurement_List.AddTime &gt;= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime &lt;= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;
014+ declare @stringSku varchar(200)= '' ,@listIds varchar(200)= ''CREATE TABLE #tempSku(item VARCHAR(400));INSERT INTO #tempSkuEXEC proc_string_split @stringSku,',';CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (SELECT RB_Product_Supplier.SupplierType , RB_Product_Supplier.Remark, CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款' WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款' WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款' WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款' ELSE '未知类型' END AS PaymentDayCn , RB_Product_Supplier.QQ , RB_Product_Supplier.WangWang , ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID , RB_Product_Supplier.LoginSupplyType , WareHouseName , RB_Procurement_List.WareHouseID, RB_Procurement_List.AOrderCode , ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree , E_Website.Domain , RB_Procurement_List.ID , RB_Procurement_List.P_Code , RB_Procurement_List.AddTime , RB_Procurement_List.PrintTime , RB_Procurement_List.FinishTime , RB_Procurement_List.ProcPayType , RB_Procurement_List.BuyerId , RB_Procurement_List.BuyerName , RB_Procurement_List.DevelopAdminName , RB_Procurement_List.ProcurementListState , RB_Procurement_List.FinishStatus , RB_Procurement_List.ProcurementLocation , RB_Procurement_List.SupplierName , RB_Procurement_List.ExpectedTimeOfDelivery , RB_Procurement_List.IsUrgent , RB_Procurement_List.IsFirstOrder , RB_Procurement_List.IsFirstSupplierOrder , RB_Procurement_List.IsFirstOrderWithinYear , ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus , '' AS SingleInfo , RB_Product_Supplier.NetFromType, RB_Product_Supplier.IsFBABarCode, 0 AS StillNeedNum, --还需 0 AS DemandNum,--需求数量 0 AS ActualBuyNum,--销单数量 0 AS SingleNum, --下单数量 0 AS PutNum, --入库数量 0.0000 AS EstimatedAmount, --预计金额 0.0000 AS ActualProductPrice,--实际金额 '' AS LastSingleTime,--最后下单实际 RB_OrderInfo.ClientOrderCode, --客户订单号 RB_Procurement_List.AutomaticOrderResult,--自动下单结果 RB_Procurement_List.IsAutomaticOrder,--是否自动下单 RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注 RB_Procurement_List.IsSample, --样品 RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝 ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrderFROM RB_Procurement_List (NOLOCK) LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode WHERE ( RB_Procurement_List.CustomerID = 1 ) AND RB_Procurement_List.FinishStatus=0 AND ( RB_Procurement_List.P_Code IN ( SELECT P_Code FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK ) WHERE StepState IN ( 0, -1 ) AND IsDelete IS NULL AND CustomerID = 1and AddTime&gt;= '2025-03-07 00:00:00' ) ) AND RB_Procurement_List.AddTime &gt;= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime &lt;= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;

014- <p>declare @stringSku varchar(200)= '' ,@listIds varchar(200)= ''<br />CREATE TABLE #tempSku(item VARCHAR(400));<br /><br />INSERT INTO #tempSku<br /><br />EXEC proc_string_split @stringSku,',';<br /><br />CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (<br /><br />SELECT RB_Product_Supplier.SupplierType ,<br /><br /> RB_Product_Supplier.Remark,<br /><br /> CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款'<br /><br /> ELSE '未知类型'<br /><br /> END AS PaymentDayCn ,<br /><br /> RB_Product_Supplier.QQ ,<br /><br /> RB_Product_Supplier.WangWang ,<br /><br /> ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID ,<br /><br /> RB_Product_Supplier.LoginSupplyType ,<br /><br /> WareHouseName ,<br /><br /> RB_Procurement_List.WareHouseID,<br /><br /> RB_Procurement_List.AOrderCode ,<br /><br /> ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree ,<br /><br /> E_Website.Domain ,<br /><br /> RB_Procurement_List.ID ,<br /><br /> RB_Procurement_List.P_Code ,<br /><br /> RB_Procurement_List.AddTime ,<br /><br /> RB_Procurement_List.PrintTime ,<br /><br /> RB_Procurement_List.FinishTime ,<br /><br /> RB_Procurement_List.ProcPayType ,<br /><br /> RB_Procurement_List.BuyerId ,<br /><br /> RB_Procurement_List.BuyerName ,<br /><br /> RB_Procurement_List.DevelopAdminName ,<br /><br /> RB_Procurement_List.ProcurementListState ,<br /><br /> RB_Procurement_List.FinishStatus ,<br /><br /> RB_Procurement_List.ProcurementLocation ,<br /><br /> RB_Procurement_List.SupplierName ,<br /><br /> RB_Procurement_List.ExpectedTimeOfDelivery ,<br /><br /> RB_Procurement_List.IsUrgent ,<br /><br /> RB_Procurement_List.IsFirstOrder ,<br /><br /> RB_Procurement_List.IsFirstSupplierOrder ,<br /><br /> RB_Procurement_List.IsFirstOrderWithinYear ,<br /><br /> ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus ,<br /><br /> '' AS SingleInfo ,<br /><br /> RB_Product_Supplier.NetFromType,<br /><br /> RB_Product_Supplier.IsFBABarCode,<br /><br /> 0 AS StillNeedNum, --还需<br /><br /> 0 AS DemandNum,--需求数量<br /><br /> 0 AS ActualBuyNum,--销单数量<br /><br /> 0 AS SingleNum, --下单数量<br /><br /> 0 AS PutNum, --入库数量<br /><br /> 0.0000 AS EstimatedAmount, --预计金额<br /><br /> 0.0000 AS ActualProductPrice,--实际金额<br /><br /> '' AS LastSingleTime,--最后下单实际<br /><br /> RB_OrderInfo.ClientOrderCode, --客户订单号<br /><br /> RB_Procurement_List.AutomaticOrderResult,--自动下单结果<br /><br /> RB_Procurement_List.IsAutomaticOrder,--是否自动下单<br /><br /> RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注<br /><br /> RB_Procurement_List.IsSample, --样品<br /><br /> RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝<br /><br /> ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrder<br /><br />FROM RB_Procurement_List (NOLOCK)<br /><br /> LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID<br /><br /> LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID<br /><br /> LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID<br /><br /> LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID<br /><br /> AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode<br /><br /> <br /><br /><br /><br />WHERE ( RB_Procurement_List.CustomerID = 1 )<br /><br /> AND RB_Procurement_List.FinishStatus=0 AND (<br /><br /> RB_Procurement_List.P_Code IN (<br /><br /> SELECT P_Code<br /><br /> FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK )<br /><br /> WHERE StepState IN ( 0, -1 )<br /><br /> AND IsDelete IS NULL<br /><br /> AND CustomerID = 1<br /><span style="background-color:#E53333;"><strong>and AddTime&gt;= '2025-03-07 00:00:00'</strong></span><br /><span><span> </span>) ) AND RB_Procurement_List.AddTime &gt;= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime &lt;= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;</span><br /><br /></p>
014+ <p>declare @stringSku varchar(200)= '' ,@listIds varchar(200)= ''<br />CREATE TABLE #tempSku(item VARCHAR(400));<br /><br />INSERT INTO #tempSku<br /><br />EXEC proc_string_split @stringSku,',';<br /><br />CREATE INDEX idx_item ON #tempSku(item); SELECT COUNT(1) FROM (<br /><br />SELECT RB_Product_Supplier.SupplierType ,<br /><br /> RB_Product_Supplier.Remark,<br /><br /> CASE WHEN RB_Procurement_List.ProcPayType = 1 THEN '现金付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 2 THEN '网络在线付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 3 THEN '转帐付款'<br /><br /> WHEN RB_Procurement_List.ProcPayType = 4 THEN '阿里账期付款'<br /><br /> ELSE '未知类型'<br /><br /> END AS PaymentDayCn ,<br /><br /> RB_Product_Supplier.QQ ,<br /><br /> RB_Product_Supplier.WangWang ,<br /><br /> ISNULL(RB_Product_Supplier.ID, 0) AS SupplierID ,<br /><br /> RB_Product_Supplier.LoginSupplyType ,<br /><br /> WareHouseName ,<br /><br /> RB_Procurement_List.WareHouseID,<br /><br /> RB_Procurement_List.AOrderCode ,<br /><br /> ISNULL(RB_WareHouse.IsTaxFree, 0) AS IsTaxFree ,<br /><br /> E_Website.Domain ,<br /><br /> RB_Procurement_List.ID ,<br /><br /> RB_Procurement_List.P_Code ,<br /><br /> RB_Procurement_List.AddTime ,<br /><br /> RB_Procurement_List.PrintTime ,<br /><br /> RB_Procurement_List.FinishTime ,<br /><br /> RB_Procurement_List.ProcPayType ,<br /><br /> RB_Procurement_List.BuyerId ,<br /><br /> RB_Procurement_List.BuyerName ,<br /><br /> RB_Procurement_List.DevelopAdminName ,<br /><br /> RB_Procurement_List.ProcurementListState ,<br /><br /> RB_Procurement_List.FinishStatus ,<br /><br /> RB_Procurement_List.ProcurementLocation ,<br /><br /> RB_Procurement_List.SupplierName ,<br /><br /> RB_Procurement_List.ExpectedTimeOfDelivery ,<br /><br /> RB_Procurement_List.IsUrgent ,<br /><br /> RB_Procurement_List.IsFirstOrder ,<br /><br /> RB_Procurement_List.IsFirstSupplierOrder ,<br /><br /> RB_Procurement_List.IsFirstOrderWithinYear ,<br /><br /> ISNULL(RB_OrderInfo.OrderStatus, 0) OrderStatus ,<br /><br /> '' AS SingleInfo ,<br /><br /> RB_Product_Supplier.NetFromType,<br /><br /> RB_Product_Supplier.IsFBABarCode,<br /><br /> 0 AS StillNeedNum, --还需<br /><br /> 0 AS DemandNum,--需求数量<br /><br /> 0 AS ActualBuyNum,--销单数量<br /><br /> 0 AS SingleNum, --下单数量<br /><br /> 0 AS PutNum, --入库数量<br /><br /> 0.0000 AS EstimatedAmount, --预计金额<br /><br /> 0.0000 AS ActualProductPrice,--实际金额<br /><br /> '' AS LastSingleTime,--最后下单实际<br /><br /> RB_OrderInfo.ClientOrderCode, --客户订单号<br /><br /> RB_Procurement_List.AutomaticOrderResult,--自动下单结果<br /><br /> RB_Procurement_List.IsAutomaticOrder,--是否自动下单<br /><br /> RB_Procurement_List.AutomaticOrderRemark,--自动下单错误备注<br /><br /> RB_Procurement_List.IsSample, --样品<br /><br /> RB_Procurement_List.SupplierSource,--供应商来源 0:1688 1：淘宝<br /><br /> ISNULL(RB_Procurement_List.IsFactoryDirectDeliveryOrder,0) AS IsFactoryDirectDeliveryOrder<br /><br />FROM RB_Procurement_List (NOLOCK)<br /><br /> LEFT JOIN RB_Product_Supplier (NOLOCK) ON RB_Procurement_List.SupplierID = RB_Product_Supplier.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_Product_Supplier.CustomerID<br /><br /> LEFT JOIN E_Website (NOLOCK) ON E_Website.CustomerID = RB_Procurement_List.CustomerID<br /><br /> LEFT JOIN RB_WareHouse (NOLOCK) ON RB_Procurement_List.WareHouseID = RB_WareHouse.ID<br /><br /> AND RB_Procurement_List.CustomerID = RB_WareHouse.CustomerID<br /><br /> LEFT JOIN RB_OrderInfo (NOLOCK) ON RB_OrderInfo.CustomerID = RB_Procurement_List.CustomerID<br /><br /> AND RB_OrderInfo.OrderCode = RB_Procurement_List.AOrderCode<br /><br /> <br /><br /><br /><br />WHERE ( RB_Procurement_List.CustomerID = 1 )<br /><br /> AND RB_Procurement_List.FinishStatus=0 AND (<br /><br /> RB_Procurement_List.P_Code IN (<br /><br /> SELECT P_Code<br /><br /> FROM RB_Procurement_Detail_SingleList WITH ( NOLOCK )<br /><br /> WHERE StepState IN ( 0, -1 )<br /><br /> AND IsDelete IS NULL<br /><br /> AND CustomerID = 1<br /><span style="background-color:#E53333;"><strong>and AddTime&gt;= '2025-03-07 00:00:00'</strong></span><br /><span><span> </span>) ) AND RB_Procurement_List.AddTime &gt;= '2025-03-07 00:00:00' AND RB_Procurement_List.AddTime &lt;= '2025-03-07 23:59:59' ) AS PagerTable; DROP TABLE IF EXISTS #tempSku;</span></p>

修改了 指派给，旧值为 "xujionghua"，新值为 "ZengXiang"。

修改了 解决方案，旧值为 ""，新值为 "performance"。
修改了 解决版本，旧值为 ""，新值为 "trunk"。
修改了 解决日期，旧值为 ""，新值为 "2025-04-11 15:14:12"。
修改了 指派给 ，旧值为 "ZengXiang"，新值为 "xiayu"。
修改了 Bug状态 ，旧值为 "active"，新值为 "resolved"。
修改了 是否确认，旧值为 "0"，新值为 "1"。
修改了 解决者 ，旧值为 ""，新值为 "ZengXiang"。

修改了 所属模块 ，旧值为 "0"，新值为 "1852"。
修改了 测试责任人，旧值为 ""，新值为 "ZengXiang"。
修改了 解决时效 ，旧值为 "0"，新值为 "579.53"。
修改了 影响环境 ，旧值为 "577"，新值为 "proonline"。

修改了 Bug状态 ，旧值为 "resolved"，新值为 "closed"。
修改了 指派给 ，旧值为 "xiayu"，新值为 "closed"。
修改了 由谁关闭，旧值为 ""，新值为 "xiayu"。
修改了 关闭日期，旧值为 ""，新值为 "2025-04-15 14:04:12"。