2025/6/25 19:21:27 QueryPromotionOrder:System.Exception: select count(0) num from (
    SELECT *,case when ShipDateLimitDays is not null then ShipDateLimitDays when ReviewTimeLimitDays is not null then ReviewTimeLimitDays else 0 end OnlineTimeLimitDays FROM (
        SELECT po.OrderNumber
	    ,(SELECT top 1 DATEDIFF(DAY,sr.ShipDate,GETDATE()) 
		    FROM SinadealTradeDB..FMS_PackageShipRecord sr
		    inner join SinadealTradeDB..FMS_Package p on p.PackageID=sr.PackageID
		    where WmsState=2 and p.Coids=po.NewCOID order by sr.CreateDate desc) ShipDateLimitDays,DATEDIFF(DAY,FinancialReviewTime,GETDATE()) ReviewTimeLimitDays
        FROM SinadealTradeDB..PromotionOrder po
        LEFT JOIN ServiceCenter..PlatformAccounts pa WITH(NOLOCK) ON pa.RecordId=po.AccountId
        LEFT JOIN ServiceCenter..UserPrivilege up WITH(NOLOCK) ON pa.RecordId=up.PARecordId
        WHERE 1=1 AND po.[Status]='Finish' and ((po.AccountId>0 and up.UserId='2718') or po.AccountId=0) AND (po.Creator='2718' or po.ApplicantId='2718' or po.ApproverId='2718' or po.RecruiterId='2718' or exists(select 0 from SinadealTradeDB..PromotionOrderCopyTo where OrderNumber=po.OrderNumber and copyto='2718')) and ((po.AccountId>0 and pa.TenantCode='JKBY') or po.AccountId=0)
    ) pro
    
)a执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 434
   在 Vayava.Erp.Dal.PromotionOrderService.GetPromotionOrderListCount(PromotionOrderQuery query, Boolean isPrivl, String userId, Boolean allPromotionOrderDataPrivl) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\PromotionManagement\PromotionOrderService.cs:行号 776
   在 Vayava.Erp.Bll.PromotionOrderManager.GetPromotionOrderListCount(PromotionOrderQuery query, Boolean isPrivl, String userId, Boolean allPromotionOrderDataPrivl) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\PromotionManagement\PromotionOrderManager.cs:行号 89
   在 PDSys.Controllers.PromotionManagementController.QueryPromotionOrder() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\PromotionManagementController.cs:行号 229