2025/6/30 10:21:52 Sql:select distinct fs.[SKURegionCode] 'sku区域编码',fs.[DepartureNO] '区域编码',fs.[SettlementPrice] '产品结算价',A.[Inventory] '库存',c1.[FatherCategoryName] '一级分类',c2.[FatherCategoryName] '二级分类',c3.[FatherCategoryName] '产品三级分类',c4.[FatherCategoryName] '产品四级分类',p.[ProductId] '产品编号',p.[ProductCName] '产品中文名',p.[ProductEName] '产品英文名',(case p.[State] when 1 then '暂缺' when 2 then '停产' when 3 then '停产有库存' when 0 then '正常'  when 4 then '侵权有库存' when 5 then '侵权无库存' when 6 then '预售' when 7  then '到货通知' when 8 then '预售延迟' else '' end) '产品状态',p.[Weight] '产品净重',p.[GrossWeight] '产品毛重',pp.[图片1] '图片1',pp.[图片2] '图片2',pp.[图片3] '图片3',pp.[图片4] '图片4',pp.[图片5] '图片5',pp.[图片6] '图片6',pp.[图片7] '图片7',pp.[图片8] '图片8',pp.[图片9] '图片9',pp.[图片10] '图片10',pp.[图片11] '图片11',pp.[图片12] '图片12','<div id=''description_content''>' + CASE WHEN p.[Highlights] IS NOT NULL THEN '<p><span style=''font-size:x-large''>Highlights</span></p>' + p.[Highlights]
+ '<h2 style=''padding -bottom: 0px; margin: 10px 0px; padding-left: 0px; padding-right: 0px; color: rgb(0,0,0); FONT-SIZE: 14px; padding-top: 0px;''>Specification</h2>' END
+ CASE WHEN p.[Fitment] IS NOT NULL THEN p.[Fitment] ELSE p.[Specification] END
+ CASE WHEN p.[InTheBox] IS NOT NULL THEN '<h2 style=''padding -bottom: 0px; margin: 10px 0px; padding-left: 0px; padding-right: 0px; color: rgb(0,0,0); FONT-SIZE: 14px; padding-top: 0px;''>
What''s in the box </h2>' + p.[InTheBox] END '产品描述代码', p.[Lengths] '产品长度',p.[widths] '产品宽度',p.[Highs] '产品高度',sn.[CombinInfoNoHTML] '产品描述无代码' from pdsys..tProduct p  left join pdsys..Fin_SettlementPrice fs  on fs.SKU=p.ProductId left join (SELECT SKU, DepartureNo, SUM(InventoryRemainQty) + SUM(InPurchases) + SUM(WaitCheckQty) + SUM(WaitOnShelfQty) - SUM(OrderRequireQty) AS Inventory FROM [PDSYS].[dbo].[WMSInventory] WHERE WarehouseID NOT IN('SZ07','SZ88','SZ97','ES09','ES91','ES97') GROUP BY SKU, DepartureNo) A on A.SKU = fs.SKU AND A.DepartureNo = fs.DepartureNO left join ServiceCenter..Category c1 on c1.CategoryID = SUBSTRING(CAST(p.CategoryId AS VARCHAR(10)), 1, 2) AND LEN(p.CategoryId) > 1 left join ServiceCenter..Category c2 on c2.CategoryID = SUBSTRING(CAST(p.CategoryId AS VARCHAR(10)), 1, 4) AND LEN(p.CategoryId) > 3 left join ServiceCenter..Category c3 on c3.CategoryID = SUBSTRING(CAST(p.CategoryId AS VARCHAR(10)), 1, 6) AND LEN(p.CategoryId) > 5 left join ServiceCenter..Category c4 on c4.CategoryID = SUBSTRING(CAST(p.CategoryId AS VARCHAR(10)), 1, 8) AND LEN(p.CategoryId) > 7 left join (SELECT * FROM  (SELECT '图片' + CAST(ROW_NUMBER() OVER(PARTITION BY ProductId ORDER BY UploadTime DESC) AS VARCHAR(10)) AS num, ProductId, 'https://imgout.geekbuying.com' + RelativePath AS RelativePath FROM PDSYS.dbo.ProductPicture) tp pivot(MAX(tp.RelativePath) FOR tp.num IN(图片1, 图片2, 图片3, 图片4, 图片5, 图片6, 图片7, 图片8, 图片9, 图片10, 图片11, 图片12))a) pp on p.ProductId=pp.ProductId left join pdsys..SpecificationsNoHTML sn on p.ProductId=sn.ProductId where RecycleBin <> 1 and IsSPU =0 and  (p.ProductId in (1292481,1292480,1251629,1251627,1251625,1249278,1249276,1249274,1249272,1249270,1249268,1249266,1249264,1232955,1192316,1170516,1131596,1069866,1069864,1069691,1059308,1001415,996932,986738,986737) or exists(select productid from pdsys..product_srm where srmid in(1292481,1292480,1251629,1251627,1251625,1249278,1249276,1249274,1249272,1249270,1249268,1249266,1249264,1232955,1192316,1170516,1131596,1069866,1069864,1069691,1059308,1001415,996932,986738,986737) and productid = p.ProductId)) and  1=1
错误信息：System.Exception: 执行超时已过期。完成操作之前已超时或服务器未响应。 
   在 Vayava.Common.DBUtility.DbHelperSQL.Query(String SQLString, String connStr, SqlParameter[] cmdParms) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\Common\Vayava.Common\DBUtility\DbHelperSQL.cs:行号 868
   在 Vayava.Erp.Dal.Analysis.AnalysisService.ExportProductByWhereWithTemplate(IDictionary`2 param) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\Core\ERP\ERP.Service.DataAccess\Vayava.Erp.Dal\Analysis\AnalysisService.cs:行号 1105