2025/4/29 16:51:58 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 ysp.ProductId in('14539101304')) fms where fms.num between 1 and 10转换 varchar 值 '14539101304' 时溢出了整数列。
   在 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.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:行号 1811