2025/4/29 13:00:00 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 po.ApplicantId='2519' AND CHARINDEX('Zick'Family en camping-car',po.Subject)>0 AND po.[Status]='Finish' and ((po.AccountId>0 and up.UserId='2021') or po.AccountId=0) and ((po.AccountId>0 and pa.TenantCode='JKBY') or po.AccountId=0)
) pro

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

ORDER BY FinishTime desc
OFFSET 0 ROWS FETCH NEXT 50 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
2025/4/29 13:00:04 获取用户权限，userId：2021，请求URL：https://jkby.acelinkco.com/WebAPI/GetPermissonByUser，请求参数：userCode=2021&apiKey=o447OHPrrAODuq6!NUA$FMLMIZHGAyDA&MenuID=
返回信息：{"Code":200,"Message":"Success!","Data":[{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadAttachment","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SubmitReview","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SubmitReview","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/CancelOrder","FunctionFromSystem":"1","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB市场推广高级管理","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/AllData","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadProductRelation","FunctionFromSystem":"PDSY","FunctionFromSystemID":441},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/RefreshRules","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/NewEdit","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/FrozenOrder","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"样品订单-敏感数据","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SensitiveData","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SensitiveData","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB市场推广高级管理","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/UpdateCreator","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"WMS","MenuFromSystemID":0,"FunctionCode":"PiiPackageInfo","FunctionFromSystem":"WMS","FunctionFromSystemID":0},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"WMS","MenuFromSystemID":0,"FunctionCode":"PiiPackageInfo","FunctionFromSystem":"WMS","FunctionFromSystemID":0},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/AuditSubmitReviewInfo","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingReviewByExpenseDept","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadProductInfo","FunctionFromSystem":"PDSY","FunctionFromSystemID":439}]}
2025/4/29 13:00:04 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 po.ApplicantId='2519' AND CHARINDEX('Zick'Family en camping-car',po.Subject)>0 AND po.[Status]='Finish' and ((po.AccountId>0 and up.UserId='2021') or po.AccountId=0) and ((po.AccountId>0 and pa.TenantCode='JKBY') or po.AccountId=0)
) pro

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

ORDER BY FinishTime desc
OFFSET 0 ROWS FETCH NEXT 50 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
2025/4/29 13:00:22 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('Zick'Family en camping-car',po.Subject)>0 AND po.[Status]='Finish' and ((po.AccountId>0 and up.UserId='2021') or po.AccountId=0) and ((po.AccountId>0 and pa.TenantCode='JKBY') or po.AccountId=0)
) pro

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

ORDER BY FinishTime desc
OFFSET 0 ROWS FETCH NEXT 50 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
2025/4/29 13:00:24 获取用户权限，userId：2021，请求URL：https://jkby.acelinkco.com/WebAPI/GetPermissonByUser，请求参数：userCode=2021&apiKey=o447OHPrrAODuq6!NUA$FMLMIZHGAyDA&MenuID=
返回信息：{"Code":200,"Message":"Success!","Data":[{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadAttachment","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SubmitReview","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SubmitReview","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/CancelOrder","FunctionFromSystem":"1","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB市场推广高级管理","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/AllData","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadProductRelation","FunctionFromSystem":"PDSY","FunctionFromSystemID":441},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/RefreshRules","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/NewEdit","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/FrozenOrder","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"样品订单-敏感数据","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SensitiveData","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SensitiveData","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB市场推广高级管理","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/UpdateCreator","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"WMS","MenuFromSystemID":0,"FunctionCode":"PiiPackageInfo","FunctionFromSystem":"WMS","FunctionFromSystemID":0},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"WMS","MenuFromSystemID":0,"FunctionCode":"PiiPackageInfo","FunctionFromSystem":"WMS","FunctionFromSystemID":0},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/AuditSubmitReviewInfo","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingReviewByExpenseDept","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadProductInfo","FunctionFromSystem":"PDSY","FunctionFromSystemID":439}]}
2025/4/29 13:00:24 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('Zick'Family en camping-car',po.Subject)>0 AND po.[Status]='Finish' and ((po.AccountId>0 and up.UserId='2021') or po.AccountId=0) and ((po.AccountId>0 and pa.TenantCode='JKBY') or po.AccountId=0)
) pro

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

ORDER BY FinishTime desc
OFFSET 0 ROWS FETCH NEXT 50 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
2025/4/29 13:00:25 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('Zick'Family en camping-car',po.Subject)>0 AND po.[Status]='Finish' and ((po.AccountId>0 and up.UserId='2021') or po.AccountId=0) and ((po.AccountId>0 and pa.TenantCode='JKBY') or po.AccountId=0)
) pro

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

ORDER BY FinishTime desc
OFFSET 0 ROWS FETCH NEXT 50 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
2025/4/29 13:00:26 获取用户权限，userId：2021，请求URL：https://jkby.acelinkco.com/WebAPI/GetPermissonByUser，请求参数：userCode=2021&apiKey=o447OHPrrAODuq6!NUA$FMLMIZHGAyDA&MenuID=
返回信息：{"Code":200,"Message":"Success!","Data":[{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadAttachment","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SubmitReview","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SubmitReview","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/CancelOrder","FunctionFromSystem":"1","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/ViewDetail","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB市场推广高级管理","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/AllData","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadProductRelation","FunctionFromSystem":"PDSY","FunctionFromSystemID":441},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/RefreshRules","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/NewEdit","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Order/FrozenOrder","FunctionFromSystem":"PDSY","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"样品订单-敏感数据","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SensitiveData","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/SensitiveData","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB市场推广高级管理","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/UpdateCreator","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"WMS","MenuFromSystemID":0,"FunctionCode":"PiiPackageInfo","FunctionFromSystem":"WMS","FunctionFromSystemID":0},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"WMS","MenuFromSystemID":0,"FunctionCode":"PiiPackageInfo","FunctionFromSystem":"WMS","FunctionFromSystemID":0},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/AuditSubmitReviewInfo","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"GKB样品申请","RoleFromSystem":"ERP","RoleFromSystemID":0,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/CreatePromotionOrder","FunctionFromSystem":"PDSYD","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)GKB市场部主管","RoleFromSystem":"WMS","RoleFromSystemID":22,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/PromotionManagement/PendingReviewByExpenseDept","FunctionFromSystem":"PDSYS","FunctionFromSystemID":1},{"UserCode":"2021","RoleName":"(WMS)市场部人员","RoleFromSystem":"WMS","RoleFromSystemID":23,"MenuFromSystem":"OMS","MenuFromSystemID":0,"FunctionCode":"/Product/DownloadProductInfo","FunctionFromSystem":"PDSY","FunctionFromSystemID":439}]}
2025/4/29 13:00:26 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('Zick'Family en camping-car',po.Subject)>0 AND po.[Status]='Finish' and ((po.AccountId>0 and up.UserId='2021') or po.AccountId=0) and ((po.AccountId>0 and pa.TenantCode='JKBY') or po.AccountId=0)
) pro

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

ORDER BY FinishTime desc
OFFSET 0 ROWS FETCH NEXT 50 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
2025/4/29 14:49:41 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('campermarco',po.Subject)>0 AND po.[Status]='PendingReview' AND po.FinishTime<='https://jkby.acelinkco.com:60011/PromotionManagement/Index?MenuID=efb91490-7b05-4186-8fd0-fd10d24a39ce#tbl 23:59:59' 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 SubmitReviewTime desc
OFFSET 0 ROWS FETCH NEXT 10 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