2025/6/23 9:08:36 请求体:[{"SPUId":569116540977221,"BaseInfo":{"Category1":10,"Category2":1006,"Category3":100606,"Category4":10060603,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Botslab R810 全景门铃","ProductShortName":"","ProductEName":"Botslab R810 Video Doorbell","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"

1、180”全景视野|5MP高清图像 |5200mAh锂电池|双重侦测(PIR&5.8G雷达)

\n


2、2.4GHz WIFI|蓝牙配网|人形检测 |逗留报警|IP66|强拆报警

\n


3、雷达+PIR双重检测|远程可视通话|AC功能

\n


4、访客识别|支持云存储|超清夜视|变声对讲|趣味铃音

","EHighlights":"","Specification":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
General\n

Brand: Botslab Pano Video Doorbell 2
Type:Security surveillance 
Model: R810
Color: black 

\n
Specification 
Weight & SizeProduct Weight: 10g
Package Weight: 14g
Product Size(L x W x H): 38*30*37.5
Package Size(L x W x H): 38*31*38
Package Contents\n
    \n
  1. \n
    Doorbell ×1
    \n
  2. \n
  3. \n
    Base Station ×1
    \n
  4. \n
  5. \n
    Tablet Mounting Bracket ×1
    \n
  6. \n
  7. \n
    Charging Cable (Type-C Charging Cable)
    \n
  8. \n
  9. \n
    Power Adapter (UK/EU Standard)
    \n
  10. \n
  11. \n
    User Manual ×1
    \n
  12. \n
  13. \n
    Installation Kit
    \n
      \n
    • \n
      Screws ×8
      \n
    • \n
    • \n
      Wall Plugs ×4
      \n
    • \n
    • \n
      AC Power Cables ×2
      \n
    • \n
    • \n
      AC Cable Caps ×2
      \n
    • \n
    • \n
      AC Cable Mounting Screws (Pre-installed on the doorbell)
      \n
    • \n
    \n
  14. \n
  15. \n
    Disassembly Pin ×1
    \n
  16. \n
  17. \n
    Doorbell Button Sticker ×1
    \n
  18. \n
  19. \n
    Package Sticker ×1
    \n
  20. \n
  21. \n
    Positioning Sticker ×1
    \n
  22. \n
\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Europe","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":66.0,"PurchasePriceCurrency":"0002","MinOrder":50,"DeliveryTime":40,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,ZFEUDF","RStocker":"2406","PStocker":"0211","Supplier":"V5699","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":10.0000,"GrossWeight":14.0000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":38.0,"ProductW":30.6,"ProductH":37.5,"PackgeL":38.0,"PackgeW":31.0,"PackgeH":38.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":569117980115013,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3965","CName":"全景门铃R810 Other","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":true,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":66,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":50,\"DeliveryTime\":40,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF,ZFEUDF\",\"RStocker\":\"2406\",\"PStocker\":\"0211\",\"Supplier\":\"V5699\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":10.0000,\"GrossWeight\":14.0000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":38,\"ProductW\":30.6,\"ProductH\":37.5,\"PackgeL\":38,\"PackgeW\":31,\"PackgeH\":38,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Botslab Video Doorbell - R810\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0001_99999999999_569171402702917.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0007%7e1_99999999999_569171451285573.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0004_99999999999_569171493756997.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0000_99999999999_569171524767813.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0006_99999999999_569171525709893.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0003_99999999999_569171526201414.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0002_99999999999_569171526139973.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0004_99999999999_569171526471750.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0007%7e1_99999999999_569171526885446.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0008_99999999999_569171527336005.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0005_99999999999_569171526950981.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810%e8%8b%b1%e6%96%87_0001_99999999999_569171526471749.jpg"}]},"SKUPictureInfos":[{"SrmSKU":569117980115013,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0007_99999999999_569121569574981.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0008_99999999999_569122196996165.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0006_99999999999_569122248912965.jpg","ImgSort":2}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0000_99999999999_569121625710661.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0001_99999999999_569121626603589.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0007_99999999999_569121626796101.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0002_99999999999_569121626923077.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0003_99999999999_569121626923078.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0008_99999999999_569121626861637.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0005_99999999999_569121653862469.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0006_99999999999_569121654120517.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/r810_0004%7e1_99999999999_569121653993541.jpg","ImgSort":8}]}]},"UserId":"0211"}] 2025/6/23 9:08:36 GetSPUId方法内部,CategoryCode:10,sql: 2025/6/23 9:08:36 GetSPUId获取到结果:SPUId:E002319,CategoryCode:10,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql: declare @CategoryShortCode varchar(5), @Max varchar(6), @NewMax varchar(6) select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%' select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6) select (@CategoryShortCode + @NewMax) SPUId 2025/6/23 9:08:42 响应体:{"Status":200,"Result":",Botslab R810 全景门铃操作成功","SuccessSPUSKUResponse":[{"SrmSPU":569116540977221,"ErpSPU":"E002319","SKURelations":[{"SrmSKU":"569117980115013","ErpSKU":"1293254"}],"Msg":null}],"FailSPUSKUResponse":[]} 2025/6/23 17:08:39 请求体:[{"SPUId":578369183150149,"BaseInfo":{"Category1":10,"Category2":1003,"Category3":100301,"Category4":null,"TemplateId":6,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"欧规ULTIMEA Apollo S90 9.1声霸","ProductShortName":"","ProductEName":"ULTIMEA Apollo S90 9.1 Soundbar","EAN":null,"BrandEName":"Ultimea","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"https://www.ultimea.com/products/apollo-s90-9-1-soundbar","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"

9.1 声道环绕音效: 使用我们先进的 9.1 声道音箱,体验电影般的氛围。通过专门调谐的环绕声扬声器和总共 9 个校准声道,它能营造出令人印象深刻的 360° 音场,准确追踪运动轨迹,并以逼真的清晰度再现电影、游戏和音乐。
2 个采用 SurroundX 技术的后置扬声器: 两个后置扬声器均与重低音扬声器相连,可提供稳定的性能和身临其境的音效。SurroundX 算法可将 2.0 PCM 转换为 9.1 环绕声信号,并以毫秒级的响应时间创造出动态的声音运动--非常适合电影、游戏和音乐欣赏。
采用 BassMX 技术的 6.5 英寸重低音扬声器: 阿波罗 S90 音响系统采用独有的 BassMX 技术进行低频放大。由于采用了调谐磁路和复合音盆,低音炮可提供动态、多层次的低音,使声音不仅可听,而且可触。
三合一设计,可定制音效: 电视 Soundbar 配备了磁解耦语音单元和 20° 波导技术,可将语音清晰度提高 45%,并支持四种声场模式。四种不同的灵活摆放方式使其成为家庭影院或游戏的理想之选。

\n

智能应用程序控制,实现个性化音效: 通过 Ultimea 应用程序,您可以定制自己的声音体验。可通过 “自定义 ”功能对低音、流行、古典或摇滚等类型的 121 种专业均衡器以及 10 段均衡器和 6 种预设(电影、音乐、语音、运动、游戏、夜晚)进行微调。
RGB 灯光与声音相结合: 用于智能电视的阿波罗 S90 条形音箱通过数百万种颜色和 6 种 RGB 模式将环绕声和灯光完美融合。灯光与声音实时同步--在每个电影之夜都能带来强烈的视听体验。

","EHighlights":"
\n
9.1-channel surround sound: Experience a cinematic atmosphere with our advanced 9.1-channel soundbar. With specially tuned surround speakers and a total of 9 calibrated channels, it creates an impressive 360° soundstage that accurately tracks movement and reproduces movies, games and music with lifelike clarity.
\n
2 rear speakers with SurroundX technology: Both rear speakers are wired to the subwoofer and provide stable performance with immersive sound. The SurroundX algorithm converts 2.0 PCM into a 9.1 surround signal and creates dynamic sound movement with millisecond response time - ideal for movies, gaming and music enjoyment.
\n
6.5\" subwoofer with BassMX technology: The Apollo S90 sound system features exclusive BassMX technology for low-frequency amplification. Thanks to a tuned magnetic circuit and composite cone, the subwoofer delivers dynamic, multi-layered bass that makes sound not only audible but also tangible.
\n
Three-in-one design with customizable sound: The TV soundbar is equipped with a magnetically decoupled voice unit and 20° waveguide technology, improves voice clarity by 45% and supports four sound field modes. Flexible placement in four variants makes it ideal for home theater or gaming.
\n
Intelligent app control for personalized sound: With the Ultimea app, you can customize your sound experience. 121 professional EQs for genres such as bass, pop, classical or rock as well as 10-band equalizers and 6 presets (film, music, voice, sport, game, night) can be fine-tuned via “Customize”.
\n
RGB light and sound combined: The Apollo S90 soundbar for Smart TVs brings surround sound and light into harmony with millions of colors and 6 RGB modes. The lighting follows the sound in real time - for an intense audiovisual experience on every movie night.
\n
","Specification":"\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
General\n

Brand: ULTIMEA Apollo S90
Type: 9.1ch Soundbar
Model: U3820
Color: Black

\n
Specification 
Weight & SizeProduct Weight: 10.8 KG
Package Weight: 11.6 KG
Product Size(L x W x H): 105 x 11 x 5.8 cm
Package Size(L x W x H): 51.2 x 49 x31 cm
Package Contents\n

1 x Subwoofer
1 x Left Subunit

\n

1 x Right Subunit

\n

1 x Center unit

\n

1 x Surround Speaker

\n

1 x POWER Adaptor

\n

1 x Subwoofer Power Cable

\n

1 x HDMI Cable 

\n

1 x Digital Optical Cable 

\n

1 x Front Left Cable for Soundbar Connection (2m) 

\n

1 x Front Right Cable for Soundbar Connection (2m) 

\n

1 x Front Left Cable for Soundbar Connection (2m) 

\n

1 x Front Right Cable for Soundbar Connection (100mm)  

\n

1 x Front Left Cable for Soundbar Connection (100mm)  

\n

1 x Rear Left Surround Cable (6m)  

\n

1 x Rear Right Surround Cable (6m)  

\n

12 x Wall Mounting Kit  

\n

6 x Mounting Screw  

\n

6 x Wall Bracket  

\n

1 x Remote Control

\n

2 x  Base 

\n

1 x User Manual 

\n

 

\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Buchenring 57, Hamburg,DE,22359","LimitPriceType":1,"LimitPrice":424.0400,"LimitPriceCurrency":"0002","PurchasePrice":310.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":1,"AfterSaleMethodNote":null,"CertificateIds":"CE","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2406","PStocker":"2364","Supplier":"V6088","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"1 x Subwoofer\n1 x Left Subunit\n1 x Right Subunit\n1 x Center unit\n1 x Surround Speaker\n1 x POWER Adaptor\n1 x Subwoofer Power Cable\n1 x HDMI Cable \n1 x Digital Optical Cable \n1 x Front Left Cable for Soundbar Connection (2m) \n1 x Front Right Cable for Soundbar Connection (2m) \n1 x Front Left Cable for Soundbar Connection (2m) \n1 x Front Right Cable for Soundbar Connection (100mm)  \n1 x Front Left Cable for Soundbar Connection (100mm)  \n1 x Rear Left Surround Cable (6m)  \n1 x Rear Right Surround Ca","WLEmbargoType":100,"Weight":10.8000,"GrossWeight":11.5900,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":105.0,"ProductW":11.0,"ProductH":5.8,"PackgeL":51.2,"PackgeW":49.0,"PackgeH":31.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":578370095702085,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3938","CName":"ULTIMEA Apollo S90 9.1声霸 黑","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":true,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":1,\"LimitPrice\":424.0400,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":310,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":1,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2406\",\"PStocker\":\"2364\",\"Supplier\":\"V6088\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1 x Subwoofer\\n1 x Left Subunit\\n1 x Right Subunit\\n1 x Center unit\\n1 x Surround Speaker\\n1 x POWER Adaptor\\n1 x Subwoofer Power Cable\\n1 x HDMI Cable\\u00A0\\n1 x Digital Optical Cable\\u00A0\\n1 x Front Left Cable for Soundbar Connection (2m)\\u00A0\\n1 x Front Right Cable for Soundbar Connection (2m)\\u00A0\\n1 x Front Left Cable for Soundbar Connection (2m)\\u00A0\\n1 x Front Right Cable for Soundbar Connection (100mm) \\u00A0\\n1 x Front Left Cable for Soundbar Connection (100mm) \\u00A0\\n1 x Rear Left Surround Cable (6m) \\u00A0\\n1 x Rear Right Surround Ca\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":10.8000,\"GrossWeight\":11.5900,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":105,\"ProductW\":11,\"ProductH\":5.8,\"PackgeL\":51.2,\"PackgeW\":49,\"PackgeH\":31,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"U3820\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+178_99999999999_578370134802501.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+179_99999999999_578370149183557.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+816_99999999999_578370162249797.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN-%e5%a5%97%e5%9b%be1600_2000-36-1_99999999999_578371046187077.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN-%e5%a5%97%e5%9b%be1600_2000-36_99999999999_578371046080581.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN-%e5%a5%97%e5%9b%be1600_2000-36-2_99999999999_578371046232133.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN-%e5%a5%97%e5%9b%be1600_2000-36-3_99999999999_578371046260805.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN-%e5%a5%97%e5%9b%be1600_2000-36-5_99999999999_578371046453317.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN-%e5%a5%97%e5%9b%be1600_2000-36-4_99999999999_578371046395973.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN-%e5%a5%97%e5%9b%be1600_2000-36-6_99999999999_578371046674501.jpg"}]},"SKUPictureInfos":[{"SrmSKU":578370095702085,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+178_99999999999_578370134802501.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+179_99999999999_578370149183557.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+816_99999999999_578370162249797.jpg","ImgSort":2}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+178_99999999999_578370517655621.jpg","ImgSort":0}]}]},"UserId":"2364"}] 2025/6/23 17:08:39 GetSPUId方法内部,CategoryCode:10,sql: 2025/6/23 17:08:39 GetSPUId获取到结果:SPUId:E002320,CategoryCode:10,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql: declare @CategoryShortCode varchar(5), @Max varchar(6), @NewMax varchar(6) select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%' select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6) select (@CategoryShortCode + @NewMax) SPUId 2025/6/23 17:08:40 响应体:{"Status":200,"Result":",欧规ULTIMEA Apollo S90 9.1声霸操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578369183150149,"ErpSPU":"E002320","SKURelations":[{"SrmSKU":"578370095702085","ErpSKU":"1293271"}],"Msg":null}],"FailSPUSKUResponse":[]}