2025/10/13 8:33:04 SearchProductRelationData:System.Exception: select * from (SELECT ROW_NUMBER() OVER(ORDER BY ysp.SaveDate DESC) AS num,ysp.id,a.PlatformId,a.RecordId,a.Accounts,ysp.ItemCode,ysp.SKURegionCode,ysp.ProductId,p.ProductCName,ysp.Counts,CASE p.IsMainSku WHEN 1 THEN '是' ELSE '否' END IsMainSku,ysp.OpUser,ysp.[Description],ysp.SaveDate,d.IsSecondHand,a.IsSecondHand AccountIsSecondHand,p.State,ysp.VersionNumber
from ServiceCenter..YS_ProductRelation ysp WITH(NOLOCK)
LEFT join pdsys..tproduct p WITH(NOLOCK) on ysp.productid=p.productid
LEFT JOIN pdsys..Fin_SettlementPrice f WITH(NOLOCK) ON ysp.SKURegionCode=f.SKURegionCode
LEFT JOIN ServiceCenter..PlatformAccounts a WITH(NOLOCK) ON ysp.PARecordId=a.RecordId
LEFT JOIN ServiceCenter..Depot d on d.Code=f.DepartureNO and d.Valid=1
WHERE 1=1 AND ysp.ItemType<>'pingtai' and d.TenantCode = 'B2B') fms where fms.num between 1 and 10执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435
   在 Vayava.Erp.Dal.YS_ProductRelationService.GetRelationList(RelationQuery query, String tenantCode) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ProductRelationService.cs:行号 593
   在 Vayava.Erp.Bll.YS_ProductRelationManager.GetRelationList(RelationQuery query, String tenantCode) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ProductRelationManager.cs:行号 113
   在 PDSys.Controllers.ProductController.SearchProductRelationData() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\ProductController.cs:行号 1826
2025/10/13 17:05:27 SearchProductRelationData:System.Exception: select * from (SELECT ROW_NUMBER() OVER(ORDER BY ysp.SaveDate DESC) AS num,ysp.id,a.PlatformId,a.RecordId,a.Accounts,ysp.ItemCode,ysp.SKURegionCode,ysp.ProductId,p.ProductCName,ysp.Counts,CASE p.IsMainSku WHEN 1 THEN '是' ELSE '否' END IsMainSku,ysp.OpUser,ysp.[Description],ysp.SaveDate,d.IsSecondHand,a.IsSecondHand AccountIsSecondHand,p.State,ysp.VersionNumber
from ServiceCenter..YS_ProductRelation ysp WITH(NOLOCK)
LEFT join pdsys..tproduct p WITH(NOLOCK) on ysp.productid=p.productid
LEFT JOIN pdsys..Fin_SettlementPrice f WITH(NOLOCK) ON ysp.SKURegionCode=f.SKURegionCode
LEFT JOIN ServiceCenter..PlatformAccounts a WITH(NOLOCK) ON ysp.PARecordId=a.RecordId
LEFT JOIN ServiceCenter..Depot d on d.Code=f.DepartureNO and d.Valid=1
WHERE 1=1 AND ysp.ItemType<>'pingtai' and d.TenantCode = 'JKBY' AND a.PlatformId=12 AND a.RecordId=66 AND CHARINDEX('520548',' 520549',' 520622',' 523920',' 523921',' 523926', ysp.ItemCode) > 0) fms where fms.num between 1 and 10charindex 函数要求有 2 到 3 个参数。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435
   在 Vayava.Erp.Dal.YS_ProductRelationService.GetRelationList(RelationQuery query, String tenantCode) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ProductRelationService.cs:行号 593
   在 Vayava.Erp.Bll.YS_ProductRelationManager.GetRelationList(RelationQuery query, String tenantCode) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ProductRelationManager.cs:行号 113
   在 PDSys.Controllers.ProductController.SearchProductRelationData() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\ProductController.cs:行号 1826
2025/10/13 17:08:38 SearchProductRelationData:System.Exception: select * from (SELECT ROW_NUMBER() OVER(ORDER BY ysp.SaveDate DESC) AS num,ysp.id,a.PlatformId,a.RecordId,a.Accounts,ysp.ItemCode,ysp.SKURegionCode,ysp.ProductId,p.ProductCName,ysp.Counts,CASE p.IsMainSku WHEN 1 THEN '是' ELSE '否' END IsMainSku,ysp.OpUser,ysp.[Description],ysp.SaveDate,d.IsSecondHand,a.IsSecondHand AccountIsSecondHand,p.State,ysp.VersionNumber
from ServiceCenter..YS_ProductRelation ysp WITH(NOLOCK)
LEFT join pdsys..tproduct p WITH(NOLOCK) on ysp.productid=p.productid
LEFT JOIN pdsys..Fin_SettlementPrice f WITH(NOLOCK) ON ysp.SKURegionCode=f.SKURegionCode
LEFT JOIN ServiceCenter..PlatformAccounts a WITH(NOLOCK) ON ysp.PARecordId=a.RecordId
LEFT JOIN ServiceCenter..Depot d on d.Code=f.DepartureNO and d.Valid=1
WHERE 1=1 AND ysp.ItemType<>'pingtai' and d.TenantCode = 'JKBY' AND CHARINDEX('520548',' 520549',' 520622',' 523920', ysp.ItemCode) > 0) fms where fms.num between 1 and 10charindex 函数要求有 2 到 3 个参数。
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 435
   在 Vayava.Erp.Dal.YS_ProductRelationService.GetRelationList(RelationQuery query, String tenantCode) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\System\YS_ProductRelationService.cs:行号 593
   在 Vayava.Erp.Bll.YS_ProductRelationManager.GetRelationList(RelationQuery query, String tenantCode) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Bll\System\YS_ProductRelationManager.cs:行号 113
   在 PDSys.Controllers.ProductController.SearchProductRelationData() 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\PDSys\Controllers\ProductController.cs:行号 1826