2025/11/21 13:54:01 Sql:select distinct p.[ProductId] '产品编号',p.[ProductCName] '产品中文名',p.[EAN] 'EAN',p.[Remark] '产品备注',p.[ProductEName] '产品英文名',br.[BrandCName] '产品品牌中文名',p.[EditMark] '活动备注',br.[BrandEName] '产品品牌英文名',c1.[FatherCategoryName] '一级分类',c2.[FatherCategoryName] '二级分类',c3.[FatherCategoryName] '产品三级分类',c4.[FatherCategoryName] '产品四级分类',fs.[SKURegionCode] 'sku区域编码',fs.[DepartureNO] '区域编码',fs.[SettlementPrice] '产品结算价',A.[Inventory] '库存',(case p.[State] when 1 then '暂缺' when 2 then '停产' when 0 then '正常' when 6 then '预售' else '' end) '产品状态',p.[Weight] '产品净重',p.[GrossWeight] '产品毛重',p.[UpdateTime] '产品更新时间',pp.[图片1] '图片1',pp.[图片2] '图片2',pp.[图片3] '图片3',pp.[图片4] '图片4',pp.[图片5] '图片5',pp.[图片6] '图片6',pp.[图片7] '图片7',pp.[图片8] '图片8',sn.[CombinInfoNoHTML] '产品描述无代码',ps.[产品描述图片1] '产品描述图片1',ps.[产品描述图片2] '产品描述图片2',ps.[产品描述图片3] '产品描述图片3',ps.[产品描述图片4] '产品描述图片4',ps.[产品描述图片5] '产品描述图片5',ps.[产品描述图片6] '产品描述图片6',ps.[产品描述图片7] '产品描述图片7',ps.[产品描述图片8] '产品描述图片8',p.[Lengths] '产品长度',p.[widths] '产品宽度',p.[Highs] '产品高度',''''+REPLACE(REPLACE(REPLACE(pr.[ItemCode], CHAR(9),''),CHAR(10),''),CHAR(13),'') '平台产品编号' from pdsys..Fin_SettlementPrice fs  left join pdsys..tProduct p  on fs.SKU=p.ProductId left join ServiceCenter..[Brand] br on br.Id=p.BrandId 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 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 (SELECT * FROM (SELECT '图片' + CAST(ROW_NUMBER() OVER(PARTITION BY ProductId ORDER BY UploadTime DESC) AS VARCHAR(10)) AS num, ProductId, CloudUrl FROM PDSYS.dbo.ProductPicture) tp pivot(MAX(tp.CloudUrl) 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 left join (SELECT * FROM (SELECT '产品描述图片' + CAST(ROW_NUMBER() OVER(PARTITION BY ProductId ORDER BY UploadTime DESC) AS VARCHAR(10)) AS num, ProductId, CloudUrl FROM PDSYS..PictureInProductDesc) tp pivot(MAX(tp.CloudUrl) FOR tp.num IN(产品描述图片1, 产品描述图片2, 产品描述图片3, 产品描述图片4, 产品描述图片5, 产品描述图片6, 产品描述图片7, 产品描述图片8, 产品描述图片9, 产品描述图片10, 产品描述图片11, 产品描述图片12))a) ps on p.ProductId=ps.ProductId left join ServiceCenter..YS_ProductRelation pr  on pr.ProductId=p.ProductId where RecycleBin <> 1 and IsSPU =0 and  (p.ProductId in (1297097,1297067,1296896,1296823,1296822,1296821,1296820,1296819,1296803,1296756,1296755,1296754,1296753,1296752,1296751,1296750,1296749,1296748,1296747,1296746,1296496,1296489,1296418,1296404,1296403,1296402,1296401,1296400,1296399,1296398,1296397,1296396,1296395,1296394,1296393,1296252,1296246,1296245,1296244,1296243,1296237,1296236,1296215,1296214,1296213,1296212,1296184,1296140,1296139,1296138,1296137,1296136,1296132,1296115,1296105,1296056,1295991,1295990,1295989,1295988,1295808,1295770,1295767,1295764,1295682,1295681,1295680,1295679,1295665,1295567,1295555,1295554,1295409,1295365,1295360,1295316,1295271,1295190,1295189,1295188,1295187,1295186,1295185,1295184,1295183,1295182,1295090,1295076,1295075,1295074,1295073,1295018,1294992,1294991,1294952,1294950,1294921,1294916,1294915,1294906,1294904,1294903,1294843,1294785,1294784,1294783,1294707,1294684,1294680,1294675,1294667,1294666,1294665,1294664,1294663,1294659,1294658,1294657,1294656,1294654,1294653,1294632,1294631,1294614,1294612,1294611,1294590,1294564,1294563,1294556,1294555,1294554,1294553,1294552,1294551,1294550,1294549,1294548,1294547,1294505,1294405,1294396,1293362,1293361,1293321,1293233,1293191,1293190,1293185,1293184,1293176,1293148,1293142,1293131,1293130,1293084,1293083,1293082,1293081,1293080,1293072,1293071,1293070,1293051,1293050,1293049,1293048,1293047,1292995,1292989,1292988,1292987,1292986,1292985,1292984,1292983,1292982,1292810,1292748,1292747,1292746,1292745,1292623,1292616,1292613,1292513,1292512,1292511,1292391,1292390,1292291,1292239,1292237,1292193,1292192,1292191,1292190,1292189,1292188,1292187,1291888,1291763,1291685,1291684,1291683,1291682,1291671,1291670,1291663,1291662,1291632,1291522,1291521,1291424,1291423,1291422,1291421,1291410,1291186,1291185,1291148,1291147,1291074,1291073,1290918,1290861,1290748,1290747,1290746,1290745,1290744,1290743,1290734,1290733,1290683,1290682,1290681,1290570,1290561,1290518,1290517,1290347,1290334,1290333,1290332,1290329,1290327,1290326,1290251,1290235,1290220,1290218,1290217,1290215,1290213,1290212,1290211,1290210,1290170,1290092,1290035,1290023,1289998,1289997,1289996,1289995,1289994,1289993,1289992,1289991,1289990,1289989,1289988,1289987,1289986,1289985,1289984,1289980,1289979,1289978,1289970,1289969,1289968,1289967,1289966,1289965,1289964,1289963,1289962,1289961,1289960,1289959,1289958,1289957,1289956,1289955,1289952,1289951,1289906,1289905,1289850,1289809,1289806,1289764,1289722,1289721,1289692,1289677,1289676,1289675,1289674,1289673,1289672,1289659,1289651,1289635,1289631,1289630,1289629,1289627,1289626,1289625,1289598,1289597,1289596,1289570,1289569,1289568,1289551,1289543,1289460,1289387,1288392,1288126,1288043,1286970,1286969,1286576,1286518,1286038,1286036,1285666,1285665,1285644,1285589,1285588,1285226,1285082,1283939,1283931,1283930,1282405,1282360,1280810,1280806,1280805,1280804,1280803,1280621,1280620,1280476,1279618,1279617,1279616,1278479,1278478,1278477,1277798,1277797,1276688,1276687,1274574,1274573,1273375,1273374,1273364,1273363,1273361,1273347,1273346,1273345,1273344,1273343,1273342,1273341,1273335,1273334,1273333,1273332,1273331,1273330,1273329,1273328,1273327,1273326,1271227,1271226,1271225,1271224,1271223,1271222,1270737,1270733,1270322,1270104,1268218,1268217,1267602,1267600,1267008,1265618,1265617,1265611,1265594,1265593,1264551,1264550,1264549,1264548,1264547,1261903,1261899,1261898,1261896,1259933,1259929,1259428,1259427,1257037,1257035,1256359,1255859,1255821,1255030,1254522,1254058,1253659,1252874,1252873,1252862,1252861,1252843,1251645,1251638,1251637,1251027,1251026,1251020,1250999,1250998,1250997,1250717,1250715,1249842,1249839,1248633,1248632,1248603,1246506,1246499,1246488,1246487,1246287,1243983,1243982,1243981,1240649,1240648,1240647,1240646,1240645,1240644,1240643,1240642,1240641,1240640,1240639,1240635,1240634,1238926,1238925,1236276,1233582,1233581,1233580,1233579,1232959,1232958,1232294,1232278,1231903,1230823,1230822,1229101,1227941,1227918,1227795,1227764,1227763,1227762) or exists(select productid from pdsys..product_srm where srmid in(1297097,1297067,1296896,1296823,1296822,1296821,1296820,1296819,1296803,1296756,1296755,1296754,1296753,1296752,1296751,1296750,1296749,1296748,1296747,1296746,1296496,1296489,1296418,1296404,1296403,1296402,1296401,1296400,1296399,1296398,1296397,1296396,1296395,1296394,1296393,1296252,1296246,1296245,1296244,1296243,1296237,1296236,1296215,1296214,1296213,1296212,1296184,1296140,1296139,1296138,1296137,1296136,1296132,1296115,1296105,1296056,1295991,1295990,1295989,1295988,1295808,1295770,1295767,1295764,1295682,1295681,1295680,1295679,1295665,1295567,1295555,1295554,1295409,1295365,1295360,1295316,1295271,1295190,1295189,1295188,1295187,1295186,1295185,1295184,1295183,1295182,1295090,1295076,1295075,1295074,1295073,1295018,1294992,1294991,1294952,1294950,1294921,1294916,1294915,1294906,1294904,1294903,1294843,1294785,1294784,1294783,1294707,1294684,1294680,1294675,1294667,1294666,1294665,1294664,1294663,1294659,1294658,1294657,1294656,1294654,1294653,1294632,1294631,1294614,1294612,1294611,1294590,1294564,1294563,1294556,1294555,1294554,1294553,1294552,1294551,1294550,1294549,1294548,1294547,1294505,1294405,1294396,1293362,1293361,1293321,1293233,1293191,1293190,1293185,1293184,1293176,1293148,1293142,1293131,1293130,1293084,1293083,1293082,1293081,1293080,1293072,1293071,1293070,1293051,1293050,1293049,1293048,1293047,1292995,1292989,1292988,1292987,1292986,1292985,1292984,1292983,1292982,1292810,1292748,1292747,1292746,1292745,1292623,1292616,1292613,1292513,1292512,1292511,1292391,1292390,1292291,1292239,1292237,1292193,1292192,1292191,1292190,1292189,1292188,1292187,1291888,1291763,1291685,1291684,1291683,1291682,1291671,1291670,1291663,1291662,1291632,1291522,1291521,1291424,1291423,1291422,1291421,1291410,1291186,1291185,1291148,1291147,1291074,1291073,1290918,1290861,1290748,1290747,1290746,1290745,1290744,1290743,1290734,1290733,1290683,1290682,1290681,1290570,1290561,1290518,1290517,1290347,1290334,1290333,1290332,1290329,1290327,1290326,1290251,1290235,1290220,1290218,1290217,1290215,1290213,1290212,1290211,1290210,1290170,1290092,1290035,1290023,1289998,1289997,1289996,1289995,1289994,1289993,1289992,1289991,1289990,1289989,1289988,1289987,1289986,1289985,1289984,1289980,1289979,1289978,1289970,1289969,1289968,1289967,1289966,1289965,1289964,1289963,1289962,1289961,1289960,1289959,1289958,1289957,1289956,1289955,1289952,1289951,1289906,1289905,1289850,1289809,1289806,1289764,1289722,1289721,1289692,1289677,1289676,1289675,1289674,1289673,1289672,1289659,1289651,1289635,1289631,1289630,1289629,1289627,1289626,1289625,1289598,1289597,1289596,1289570,1289569,1289568,1289551,1289543,1289460,1289387,1288392,1288126,1288043,1286970,1286969,1286576,1286518,1286038,1286036,1285666,1285665,1285644,1285589,1285588,1285226,1285082,1283939,1283931,1283930,1282405,1282360,1280810,1280806,1280805,1280804,1280803,1280621,1280620,1280476,1279618,1279617,1279616,1278479,1278478,1278477,1277798,1277797,1276688,1276687,1274574,1274573,1273375,1273374,1273364,1273363,1273361,1273347,1273346,1273345,1273344,1273343,1273342,1273341,1273335,1273334,1273333,1273332,1273331,1273330,1273329,1273328,1273327,1273326,1271227,1271226,1271225,1271224,1271223,1271222,1270737,1270733,1270322,1270104,1268218,1268217,1267602,1267600,1267008,1265618,1265617,1265611,1265594,1265593,1264551,1264550,1264549,1264548,1264547,1261903,1261899,1261898,1261896,1259933,1259929,1259428,1259427,1257037,1257035,1256359,1255859,1255821,1255030,1254522,1254058,1253659,1252874,1252873,1252862,1252861,1252843,1251645,1251638,1251637,1251027,1251026,1251020,1250999,1250998,1250997,1250717,1250715,1249842,1249839,1248633,1248632,1248603,1246506,1246499,1246488,1246487,1246287,1243983,1243982,1243981,1240649,1240648,1240647,1240646,1240645,1240644,1240643,1240642,1240641,1240640,1240639,1240635,1240634,1238926,1238925,1236276,1233582,1233581,1233580,1233579,1232959,1232958,1232294,1232278,1231903,1230823,1230822,1229101,1227941,1227918,1227795,1227764,1227763,1227762) 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:行号 867
   在 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