2025/11/24 16:51:19 Sql:select distinct fs.[SKURegionCode] 'sku区域编码',p.[ProductCName] '产品中文名',fs.[SettlementPrice] '产品结算价',p.[Remark] '产品备注',p.[EditMark] '活动备注' from pdsys..Fin_SettlementPrice fs  left join pdsys..tProduct p  on fs.SKU=p.ProductId where RecycleBin <> 1 and IsSPU =0 and  (p.ProductId in () or exists(select productid from pdsys..product_srm where srmid in() 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
2025/11/24 18:46:24 Sql:select distinct fs.[DepartureNO] '区域编码',p.[ProductId] '产品编号',p.[ProductCName] '产品中文名',p.[ProductEName] '产品英文名',p.[Highlights]+p.[Specification]+p.[InTheBox] '产品描述','<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 '产品描述代码', from pdsys..tProduct p  left join pdsys..Fin_SettlementPrice fs  on fs.SKU=p.ProductId where RecycleBin <> 1 and IsSPU =0 and  (p.ProductId in (1295888,1295727,1295501,1294975,1290445,1264548,1257633) or exists(select productid from pdsys..product_srm where srmid in(1295888,1295727,1295501,1294975,1290445,1264548,1257633) and productid = p.ProductId)) and  1=1
错误信息：System.Exception: 关键字 'from' 附近有语法错误。
“)”附近有语法错误。
   在 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
2025/11/24 18:46:46 Sql:select distinct fs.[DepartureNO] '区域编码',p.[ProductId] '产品编号',p.[ProductCName] '产品中文名',p.[ProductEName] '产品英文名',p.[Highlights]+p.[Specification]+p.[InTheBox] '产品描述','<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 '产品描述代码', from pdsys..tProduct p  left join pdsys..Fin_SettlementPrice fs  on fs.SKU=p.ProductId where RecycleBin <> 1 and IsSPU =0 and  (p.ProductId in (1295888,1295727,1295501,1294975,1290445,1264548,1257633) or exists(select productid from pdsys..product_srm where srmid in(1295888,1295727,1295501,1294975,1290445,1264548,1257633) and productid = p.ProductId)) and  1=1
错误信息：System.Exception: 关键字 'from' 附近有语法错误。
“)”附近有语法错误。
   在 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