2025/5/8 17:28:15 QueryPromotionOrder:System.Exception: SELECT *,case when ShipDateLimitDays is not null then ShipDateLimitDays when ReviewTimeLimitDays is not null then ReviewTimeLimitDays else 0 end OnlineTimeLimitDays FROM (
	SELECT po.Id,po.OrderNumber,po.NewCOID,po.OrderNo,po.OrderType,po.AccountId,po.[Status],po.[Subject],po.ApplicantId,po.RecruiterId,po.FinishTime,po.ApproverId,po.ApproveTime,po.ReviewInstructions
	,po.CancelOperator,po.CancelTime,po.Creator,po.CreateTime,po.LastModifiedBy,po.LastModifiedTime,po.ReviewType,po.ExpenseDeptReviewerId,po.ExpenseDeptReviewTime,po.FinancialReviewerId,po.FinancialReviewTime,po.SubmitReviewerId,po.SubmitReviewTime
	,po.PlatformId,pa.Accounts AccountName,p.PlatformName,bd.[Key] OrderTypeName,sv.ForwarderByID,po.InfluencerID,po.OnlineStatus,po.OnlineTimeLimit,po.OnlineLink,c.CNDesc CountryCNDesc,po.ShippingWHType,po.WebAddress
	,(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
LEFT JOIN ServiceCenter..Platform p WITH(NOLOCK) ON p.RecordId=po.PlatformId
LEFT JOIN ServiceCenter..BasicDataConfig bd WITH(NOLOCK) ON bd.[Value]=po.OrderType AND bd.[Type]='PromotionOrderType'
LEFT JOIN ServiceCenter..ShipVia sv WITH(NOLOCK) ON sv.Code=po.ShipVia
LEFT JOIN ServiceCenter..Country c WITH(NOLOCK) ON c.Code=po.CCountry
WHERE 1=1 AND CHARINDEX('Kevyn's 3D & TechStuff',po.Subject)>0 and ((po.AccountId>0 and up.UserId='2019') or po.AccountId=0) and ((po.AccountId>0 and pa.TenantCode='JKBY') or po.AccountId=0)
) pro

ORDER BY CreateTime desc
OFFSET 0 ROWS FETCH NEXT 200 ROWS ONLY;“s”附近有语法错误。
字符串 ') or po.AccountId=0)
) pro

ORDER BY CreateTime desc
OFFSET 0 ROWS FETCH NEXT 200 ROWS ONLY;' 后的引号不完整。
   在 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.GetPromotionOrderList(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:行号 454
   在 Vayava.Erp.Bll.PromotionOrderManager.GetPromotionOrderList(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:行号 85
   在 PDSys.Controllers.PromotionManagementController.QueryPromotionOrder() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\PromotionManagementController.cs:行号 173