2025/7/1 10:06:30 请求体:[{"SPUId":580837020545093,"BaseInfo":{"Category1":40,"Category2":4003,"Category3":400301,"Category4":null,"TemplateId":7,"RecommendType":1,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"FIREBAT T8 PLUS 16GB 512GB Mini PC","ProductShortName":"","ProductEName":"FIREBAT T8 PLUS 16GB 512GB MINI PC ","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":false,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
描述
FIREBAT T8 PLUS 迷你电脑
产品配置
英特尔 N100
\n英特尔® UHD 显卡(24EU)
\n16GB LPDDR5
\n512GB M.2 2242(仅支持 M.2 2242)
处理器
英特尔 N100
\n英特尔® UHD 显卡(24EU)
\n16GB LPDDR5
\n512GB M.2 2242(仅支持 M.2 2242)
GPU 显卡
Intel® UHD Graphics(24EU)
\n支持 HDMI 2.0
网络
Wi-Fi 5
无线网卡
Intel Wi-Fi 5 无线网卡支持 802.11ax 协议支持 5GHz 频段蓝牙 4.2 M.2 2230 接口
适配器规格
\n输入:12V 2.5A 30W
丰富接口
-3×USB 3.0
-1个耳机和麦克风 3.5mm 2 合 1 接口
-3 个 HDMI 2.0 接口
-2 个千兆以太网端口
尺寸和重量
89.4mm × 89.4mm × 43.5mm,约重 203.7 克(电源适配器重量和包装重量不包含在内,具体重量以产品交付设置为准)
","EHighlights":"FIREBAT T8 PLUS MINI PC
Product Configuration
\n\n- Intel N100 Processor
\n- Intel UHD Graphics (24EU)
\n- 16GB LPDDR5 RAM
\n- 512GB M.2 2242 SSD (Supports M.2 2242 only)
\n
\nProcessor
\n\n- Intel N100 (4 cores, 4 threads)
\n- Base Frequency: 1.1 GHz, Max Turbo Frequency: 3.4 GHz
\n
\nGPU
\n\n- Intel UHD Graphics (24EU)
\n- Supports HDMI 2.0 output
\n
\nNetworking
\n\n- Wireless: Wi-Fi 5 (802.11ac)
\n- Wireless Card: Intel Wi-Fi 5 (M.2 2230 interface)\n
\n- Supports 5GHz band, Bluetooth 4.2
\n
\n \n
\nAdapter
\n\n- Input: 12V/2.5A (30W power adapter)
\n
\nPorts
\n\n- 3x USB 3.0
\n- 1x 3.5mm Headphone/Microphone Combo Jack
\n- 3x HDMI 2.0
\n- 2x Gigabit Ethernet Ports
\n
\nDimensions & Weight
\n\n- Size: 89.4mm x 89.4mm x 43.5mm
\n- Weight: 203.7g (excluding power adapter and packaging)
\n
","Specification":"\n\n\nGeneral | \nModel: T8 PULS Type: Mini PC | \n
\n\nHardware | \n\n CPU: Intel N100 GPU: Intel UHD Graphics (24EU) RAM: 16GB ROM: 512GB \n | \n
\n\nCommunication | \n\n Wi-Fi: Wi-Fi 5 (802.11ac) Bluetooth: 4.2 \n | \n
\n\nInterface | \n\n\n- 3x USB 3.0
\n- 1x 3.5mm Headphone/Microphone Combo Jack
\n- 3x HDMI 2.0
\n- 2x Gigabit Ethernet Port
\n- 1x DC Adapter Interface (5.5x2.5 mm)
\n- 1x Physical Anti-Theft Lock Hole
\n \n | \n
\n\nOther Features | \n\n Language: English \n | \n
\n\nPower | \n\n Power Supply: DC Power Consumption:12V/2.5A (30W) \n | \n
\n\nDimensiions&Weight | \n\n Product Weight: 203.7g Product Size (L x W x H): 89.4mm x 89.4mm x 43.5mm \n | \n
\n\nPackage Contents | \n\n\n-
\n- 1x mini pc
\n-
\n- 1x Power Adapter
\n- 1x User Manual
\n- 1x HDMI Cable
\n- 1x VESA Mount
\n \n | \n
\n\n
","PropertyValuesDto":[{"Code":1187,"CName":"RAM内存大小","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"16GB","ValueCode":4024,"Color":null}]},{"Code":1249,"CName":"ROM存储大小","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"512GB","ValueCode":1968,"Color":null}]},{"Code":1295,"CName":"类型","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"MINI PC","ValueCode":4615,"Color":null}]},{"Code":1008,"CName":"CPU品牌","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Intel","ValueCode":441,"Color":null}]},{"Code":1048,"CName":"CPU的核数","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Quad Core","ValueCode":382,"Color":null}]},{"Code":1007,"CName":"按功能","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"HDMI","ValueCode":141,"Color":null}]}],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Bat-B,Porte-B,5 Rue de la Fontaine des Bries","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":121.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":2,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":3,"AfterSaleMethodNote":null,"CertificateIds":"CE,FCC","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,ZFEUDF","RStocker":"1939","PStocker":"2054","Supplier":"V6279","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"1 x Adapter\n1 x Product manual\n1 x HDMI cable\n1 x VESA was hung","WLEmbargoType":402,"Weight":0.2037,"GrossWeight":0.5320,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":8.9,"ProductW":8.9,"ProductH":4.3,"PackgeL":13.0,"PackgeW":13.0,"PackgeH":11.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":580851778920517,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"FIREBAT T8 PLUS 16GB 512GB Mini PC 欧规 ","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":1,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":121,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":2,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":3,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE,FCC\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF,ZFEUDF\",\"RStocker\":\"1939\",\"PStocker\":\"2054\",\"Supplier\":\"V6279\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1 x Adapter\\n1 x Product manual\\n1 x HDMI cable\\n1 x VESA was hung\",\"EAN\":null,\"WLEmbargoType\":402,\"Weight\":0.2037,\"GrossWeight\":0.5320,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":8.9,\"ProductW\":8.9,\"ProductH\":4.3,\"PackgeL\":13,\"PackgeW\":13,\"PackgeH\":11,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"T8 PLUS\",\"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/%e4%b8%bb%e5%9b%be_01_99999999999_580853137879109.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%8f%8f%e8%bf%b0%e5%9b%be_01_99999999999_580884581425221.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%8f%8f%e8%bf%b0%e5%9b%be_07_99999999999_580884495478853.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/311335d3bfa1a87916665066152ea2d9_99999999999_580867547344965.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be_06_99999999999_580865654644805.jpg"}]},"SKUPictureInfos":[{"SrmSKU":580851778920517,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be_01_99999999999_580853137879109.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/311335d3bfa1a87916665066152ea2d9_99999999999_580867547344965.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be_06_99999999999_580865654644805.jpg","ImgSort":1}]}]},"UserId":"2054"}]
2025/7/1 10:06:30 GetSPUId方法内部,CategoryCode:40,sql:
2025/7/1 10:06:30 GetSPUId获取到结果:SPUId:N002522,CategoryCode:40,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/7/1 10:06:33 响应体:{"Status":200,"Result":",FIREBAT T8 PLUS 16GB 512GB Mini PC操作成功","SuccessSPUSKUResponse":[{"SrmSPU":580837020545093,"ErpSPU":"N002522","SKURelations":[{"SrmSKU":"580851778920517","ErpSKU":"1294472"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/7/1 10:07:52 请求体:[{"SPUId":580878809284677,"BaseInfo":{"Category1":40,"Category2":4003,"Category3":400301,"Category4":null,"TemplateId":7,"RecommendType":1,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"FIREBAT T2 16GB 512GB Mini PC","ProductShortName":"","ProductEName":"FIREBAT T2 16GB 512GB MINI PC EU","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"描述
FIREBAT T2 迷你电脑
产品配置
英特尔 N150
\n英特尔® UHD 显卡(24EU)
\n16GB SO-DIMM DDR4
\n512GB M.2 2280(仅支持 M.2 2280)
处理器
英特尔 N150
\n英特尔® UHD 显卡(24EU)
\n16GB SO-DIMM DDR4
\n512GB M.2 2280(仅支持 M.2 2280)
GPU 显卡
Intel® UHD Graphics(24EU)
\n支持 HDMI 2.0
网络
Wi-Fi 5
无线网卡
Intel Wi-Fi 5 无线网卡支持 802.11ax 协议支持 5GHz 频段蓝牙 4.2 M.2 2230 接口
适配器规格
\n输入:12V 2.5A 30W
丰富接口
-2×USB 3.2 Gen2(10Gbps)Type-A
-2×USB 2.0 Type-A
-1个耳机和麦克风 3.5mm 2合1接口
-1个HDMI 2.0接口
-1个DP 1.4接口
-1个千兆以太网端口
尺寸和重量
100mm×102mm×36mm,约重285克(电源适配器重量和包装重量不包含在内,具体重量以产品交付设置为准)
","EHighlights":"FIREBAT T2 MINI PC
Product Configuration
\n\n- Intel N150 Processor
\n- Intel UHD Graphics (24EU)
\n- 16GB SO-DIMM DDR4 RAM
\n- 512GB M.2 2280 SSD (Supports M.2 2280 only)
\n
\nProcessor
\n\n- Intel N150 (4 cores, 4 threads)
\n
\nGPU
\n\n- Intel UHD Graphics (24EU)
\n- Supports HDMI 2.0
\n
\nNetworking
\n\n- Wireless: Wi-Fi 5 (802.11ac)
\n- Wireless Card: Intel Wi-Fi 5 (M.2 2230 interface)\n
\n- Supports 5GHz band, Bluetooth 4.2
\n
\n \n
\nAdapter
\n\n- Input: 12V/2.5A (30W power adapter)
\n
\nInterfaces
\n\n- 2x USB 3.2 Gen2 Type-A (10Gbps)
\n- 2x USB 2.0 Type-A
\n- 1x 3.5mm Headphone/Microphone Combo Jack
\n- 1x HDMI 2.0
\n- 1x DisplayPort 1.4
\n- 1x Gigabit Ethernet Port
\n
\nDimensions & Weight
\n\n- Size: 100mm x 102mm x 36mm
\n- Weight: 285g (excluding power adapter and packaging; actual weight may vary based on configuration)
\n
","Specification":"\n\n\nGeneral | \n\n Model: T2 Type: Mini PC \n | \n
\n\nHardware | \n\n CPU: Intel N150 GPU: Intel UHD Graphics (24EU) RAM: 16GB ROM: 512GB \n | \n
\n\nCommunication | \n\n Wi-Fi: Wi-Fi 5 (802.11ac) Bluetooth: 4.2 \n | \n
\n\nInterface | \n\n\n- 2x USB 3.2 Gen2 Type-A (10Gbps)
\n- 2x USB 2.0 Type-A
\n- 1x 3.5mm Headphone/Microphone Combo Jack
\n- 1x HDMI 2.0
\n- 1x DisplayPort 1.4
\n- 1x Gigabit Ethernet Port
\n \n \n | \n
\n\nOther Features | \n\n Language: English \n | \n
\n\nPower | \nPower Type: DC Power Consumption: 12V/2.5A (30W) | \n
\n\nDimensiions&Weight | \nProduct Weight: 285g Product Size (L x W x H): 100mm x 102mm x 36mm | \n
\n\nPackage Contents | \n\n \n \n\n- 1x Mini PC Unit
\n- 1x Power Adapter
\n- 1x User Manual
\n- 1x HDMI Cable
\n- 1x VESA Mount
\n \n | \n
\n\n
","PropertyValuesDto":[{"Code":1187,"CName":"RAM内存大小","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"16GB","ValueCode":4024,"Color":null}]},{"Code":1249,"CName":"ROM存储大小","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"512GB","ValueCode":1968,"Color":null}]},{"Code":1295,"CName":"类型","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"MINI PC","ValueCode":4615,"Color":null}]},{"Code":1008,"CName":"CPU品牌","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Intel","ValueCode":441,"Color":null}]},{"Code":1048,"CName":"CPU的核数","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Quad Core","ValueCode":382,"Color":null}]},{"Code":1007,"CName":"按功能","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"HDMI","ValueCode":141,"Color":null}]}],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Bat-B,Porte-B,5 Rue de la Fontaine des Bries","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":117.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":2,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":3,"AfterSaleMethodNote":null,"CertificateIds":"CE,ROHS","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,ZFEUDF","RStocker":"1939","PStocker":"2219","Supplier":"V6279","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"1 x minipc\n1 x Adapter\n1 x Product manual\n1 x HDMI cable\n1 x VESA was hung","WLEmbargoType":402,"Weight":0.2850,"GrossWeight":0.5980,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":10.0,"ProductW":10.2,"ProductH":3.6,"PackgeL":13.0,"PackgeW":13.0,"PackgeH":11.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":580881506054213,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"FIREBAT T2 16GB 512GB Mini PC 欧规","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":1,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":117,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":2,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":3,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE,ROHS\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF,ZFEUDF\",\"RStocker\":\"1939\",\"PStocker\":\"2219\",\"Supplier\":\"V6279\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1 x minipc\\n1 x Adapter\\n1 x Product manual\\n1 x HDMI cable\\n1 x VESA was hung\",\"EAN\":null,\"WLEmbargoType\":402,\"Weight\":0.2850,\"GrossWeight\":0.5980,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":10,\"ProductW\":10.2,\"ProductH\":3.6,\"PackgeL\":13,\"PackgeW\":13,\"PackgeH\":11,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"T2\",\"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/1_99999999999_580881563070533.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be5_99999999999_580881614467141.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be2_99999999999_580881657937989.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be3_99999999999_580881676718149.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be4_99999999999_580881692758085.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_580881994244165.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be5_99999999999_580881995358277.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be4_99999999999_580881995378757.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be3_99999999999_580881995694149.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be2_99999999999_580881995452485.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_580881994244166.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_580881994383429.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_580881994440773.jpg"}]},"SKUPictureInfos":[{"SrmSKU":580881506054213,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_580881563070533.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be5_99999999999_580881614467141.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be2_99999999999_580881657937989.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be3_99999999999_580881676718149.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be4_99999999999_580881692758085.jpg","ImgSort":4}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_580881994244165.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be5_99999999999_580881995358277.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be4_99999999999_580881995378757.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be3_99999999999_580881995694149.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be2_99999999999_580881995452485.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_580881994244166.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_580881994383429.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_580881994440773.jpg","ImgSort":7}]}]},"UserId":"2054"}]
2025/7/1 10:07:52 GetSPUId方法内部,CategoryCode:40,sql:
2025/7/1 10:07:52 GetSPUId获取到结果:SPUId:N002523,CategoryCode:40,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/7/1 10:07:55 响应体:{"Status":200,"Result":",FIREBAT T2 16GB 512GB Mini PC操作成功","SuccessSPUSKUResponse":[{"SrmSPU":580878809284677,"ErpSPU":"N002523","SKURelations":[{"SrmSKU":"580881506054213","ErpSKU":"1294473"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/7/1 10:10:10 请求体:[{"SPUId":580888419143749,"BaseInfo":{"Category1":40,"Category2":4003,"Category3":400301,"Category4":null,"TemplateId":7,"RecommendType":1,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"FIREBAT AM02 16GB 512GB Mini PC AMD 6600H 处理器","ProductShortName":"","ProductEName":"FIREBAT AM02 16GB 512GB MINI PC EU","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"描述
\nFIREBAT AM02 迷你电脑
\n产品配置
\nAMD Ryzen5 6600H
\n
\nAMD Radeon 660M
\n
\n16GB DDR5 4800MHz
\n
\n512GB M.2 2280(仅支持 M.2 2280)
\n处理器
\nAMD Ryzen5 6600H
\n
\nAMD Radeon 660M
\n
\n16GB DDR5 4800MHz
\n
\n512GB M.2 2280(仅支持M.2 2280)
\nGPU显卡
\nAMD Radeon 660M
\n
\n支持HDMI 2.1
\n网络
\nWi-Fi 6
\n无线网卡
\nIntel Wi-Fi 6无线网卡支持802.11ax协议支持5GHz频段蓝牙5.2 M.2 2230接口
\n适配器规格
\n
\n输入:19V 5A 95W
\n丰富接口
\n-1×USB 3.2 Gen2(10Gbps)TYPE-C(65W单线连接,支持数据传输和DP 2.0视频输出,最高支持4K 60Hz)
\n-3×USB 3.2 Gen2(10Gbps)TYPE-A
\n-1×USB2.0 TYPE-A
\n-1×耳机和麦克风 3.5mm 2 合 1
\n-1×HDMI 2.1 最高支持 4K 60Hz
\n-1×DP 2.0 最高支持 4K 160Hz
\n-2×RJ45 1Gbps 以太网接口
\n尺寸与重量
\n128mm×126mm×51mm,约重 440g(不含电源适配器及包装重量,具体重量以产品出货配置为准)
","EHighlights":"Describe
\nFIREBAT AM02 MINI PC
\nProduct Configuration
\nAMD Ryzen 5 6600H
\n
\nAMD Radeon 660M
\n
\n16GB DDR5 4800MHz
\n
\n512GB M.2 2280 (only supports M.2 2280)
\nProcessor
\nAMD Ryzen 5 6600H
\n
\nAMD Radeon 660M
\n
\n16GB DDR5 4800MHz
\n
\n512GB M.2 2280 (only supports M.2 2280)
\nGraphics Card
\nAMD Radeon 660M
\n
\nSupports HDMI 2.1
\nNetwork
\nWi-Fi 6
\nWireless Network Card
\nIntel Wi-Fi 6 Wireless Adapter Supports 802.11ax Protocol Supports 5GHz Band Bluetooth 5.2 M.2 2230 Interface
\nAdapter Specifications
\n
\nInput: 19V 5A 95W
\nRich interfaces
\n1×USB 3.2 Gen2 (10Gbps) TYPE-C (65W single cable connection, supports data transfer and DP 2.0 video output, supports up to 4K 60Hz)
\n-3 x USB 3.2 Gen2 (10Gbps) TYPE-A
\n-1 x USB 2.0 TYPE-A
\n-1×Headphone and microphone 3.5mm 2 in 1
\n-1×HDMI 2.1 Supports up to 4K 60Hz
\n-1×DP 2.0 supports up to 4K 160Hz
\n-2×RJ45 1Gbps Ethernet interface
\nDimensions and weight
\n128mm×126mm×51mm, approximately 440g (excluding power adapter and packaging weight; actual weight depends on product shipping configuration)
","Specification":"\n\n\nGeneral | \n\n Model:AM02 Type:minipc \n | \n
\n\nHardware | \n\n CPU:AMD Ryzen 5 6600H GPU:AMD Radeon 660M RAM:16GB ROM:512GB \n | \n
\n\nCommunication | \n\n WIFI:Wi-Fi 6 Bluetooth: 5.2 \n | \n
\n\nInterface | \n | \n
\n\nOther Features | \n\n Language: English \n | \n
\n\nNGPower | \nPower Type:DC Power Consumption:19V 5A 95W | \n
\n\nDimensiions&Weight | \nProduct weight: 440g Product size (L x W x H): 128mm×126mm×51mm | \n
\n\nPackage Contents | \n\n 1x Mini Pc 1x Power Adapter 1x User Manual 1x HDMI Cable 1x VESA Mount \n | \n
\n\n
","PropertyValuesDto":[{"Code":1187,"CName":"RAM内存大小","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"16GB","ValueCode":4024,"Color":null}]},{"Code":1249,"CName":"ROM存储大小","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"512GB","ValueCode":1968,"Color":null}]},{"Code":1295,"CName":"类型","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"MINI PC","ValueCode":4615,"Color":null}]},{"Code":1008,"CName":"CPU品牌","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"AMD","ValueCode":4204,"Color":null}]},{"Code":1048,"CName":"CPU的核数","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Hexa Core","ValueCode":3464,"Color":null}]},{"Code":1007,"CName":"按功能","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"HDMI","ValueCode":141,"Color":null}]}],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Bat-B,Porte-B,5 Rue de la Fontaine des Bries","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":211.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":2,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":3,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,ZFEUDF","RStocker":"1939","PStocker":"2219","Supplier":"V6279","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"1x Mini Pc\n1x Power Adapter\n1x User Manual\n1x HDMI Cable\n1x VESA Mount","WLEmbargoType":402,"Weight":0.4400,"GrossWeight":1.0130,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":12.8,"ProductW":12.6,"ProductH":5.1,"PackgeL":20.0,"PackgeW":17.0,"PackgeH":11.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":580890263654469,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"FIREBAT AM02 16GB 512GB Mini PC AMD 6600H 处理器 欧规","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":1,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":211,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":2,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":3,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF,ZFEUDF\",\"RStocker\":\"1939\",\"PStocker\":\"2219\",\"Supplier\":\"V6279\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1x Mini Pc\\n1x Power Adapter\\n1x User Manual\\n1x HDMI Cable\\n1x VESA Mount\",\"EAN\":null,\"WLEmbargoType\":402,\"Weight\":0.4400,\"GrossWeight\":1.0130,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":12.8,\"ProductW\":12.6,\"ProductH\":5.1,\"PackgeL\":20,\"PackgeW\":17,\"PackgeH\":11,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"AM02\",\"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/%e4%b8%bb%e5%9b%be1_99999999999_580890425331781.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be2_99999999999_580890461491269.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be3_99999999999_580890478944325.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be4_99999999999_580890498183237.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be6_99999999999_580890516058181.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be54_99999999999_580890533109829.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e4%b8%bb%e5%9b%be6600_99999999999_581119050387525.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e4%b8%bb%e5%9b%be01_99999999999_581119032012869.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/01_99999999999_581119064801349.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/02_99999999999_581119080222789.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/03_99999999999_581119094976581.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/05_99999999999_581119112290373.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e4%b8%bb%e5%9b%be%e8%93%9d%e7%89%99_99999999999_581119131930693.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e4%b8%bb%e5%9b%be06_99999999999_581119150051397.jpg"}]},"SKUPictureInfos":[{"SrmSKU":580890263654469,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be1_99999999999_580890425331781.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be2_99999999999_580890461491269.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be3_99999999999_580890478944325.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be4_99999999999_580890498183237.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be6_99999999999_580890516058181.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be54_99999999999_580890533109829.jpg","ImgSort":5}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e4%b8%bb%e5%9b%be01_99999999999_581119214702661.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e4%b8%bb%e5%9b%be6600_99999999999_581119235518533.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e4%b8%bb%e5%9b%be%e8%93%9d%e7%89%99_99999999999_581119254921285.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/03_99999999999_581119272411205.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/01_99999999999_581119298125893.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/03_99999999999_581119319519301.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/05_99999999999_581119336050757.jpg","ImgSort":6}]}]},"UserId":"2054"}]
2025/7/1 10:10:10 GetSPUId方法内部,CategoryCode:40,sql:
2025/7/1 10:10:10 GetSPUId获取到结果:SPUId:N002524,CategoryCode:40,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/7/1 10:10:15 响应体:{"Status":200,"Result":",FIREBAT AM02 16GB 512GB Mini PC AMD 6600H 处理器操作成功","SuccessSPUSKUResponse":[{"SrmSPU":580888419143749,"ErpSPU":"N002524","SKURelations":[{"SrmSKU":"580890263654469","ErpSKU":"1294474"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/7/1 18:58:03 请求体:[{"SPUId":581241184981061,"BaseInfo":{"Category1":40,"Category2":4004,"Category3":400401,"Category4":40040112,"TemplateId":46,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"KTC A25Q5 24.5 inch FHD 60Hz 便携屏 support touch","ProductShortName":"","ProductEName":"KTC A25Q5 24.5 inch FHD 60Hz support touch","EAN":null,"BrandEName":"KTC","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"KTC A25Q5 24.5 inch FHD 60Hz 便携屏 support touch
","EHighlights":"KTC A25Q5 24.5 inch FHD 60Hz support touch
","Specification":"\n\n\nGeneral | \n\n Brand: A25Q5 Type: Model: Color: \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: Package Weight: Product Size(L x W x H): Package Size(L x W x H): | \n
\n\nPackage Contents | \n\n 1 x 1 x User Manual \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"惠州康冠","LimitPriceType":1,"LimitPrice":499.9900,"LimitPriceCurrency":"0002","PurchasePrice":228.0,"PurchasePriceCurrency":"0002","MinOrder":500,"DeliveryTime":45,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZDG,ZFSZDG","RStocker":"2228","PStocker":"2219","Supplier":"V5368","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":404,"Weight":5.5000,"GrossWeight":6.3000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":57.0,"ProductW":34.0,"ProductH":4.0,"PackgeL":65.0,"PackgeW":10.0,"PackgeH":49.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":581242947858501,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"KTC A25Q5 24.5 inch FHD 60Hz 便携屏 support touch 欧规","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":\"6921958687973\",\"ShippingAddress\":\"\",\"LimitPriceType\":1,\"LimitPrice\":499.9900,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":228,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":500,\"DeliveryTime\":45,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZDG,ZFSZDG\",\"RStocker\":\"2228\",\"PStocker\":\"2219\",\"Supplier\":\"V5368\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":\"6921958687973\",\"WLEmbargoType\":404,\"Weight\":5.5000,\"GrossWeight\":6.3000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":57,\"ProductW\":34,\"ProductH\":4,\"PackgeL\":65,\"PackgeW\":10,\"PackgeH\":49,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"A25Q5\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/A25Q5_99999999999_581243134677061.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/A25Q5_99999999999_581243144089669.jpg"}]},"SKUPictureInfos":[{"SrmSKU":581242947858501,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/A25Q5_99999999999_581243134677061.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/A25Q5_99999999999_581243144089669.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/7/1 18:58:03 GetSPUId方法内部,CategoryCode:40,sql:
2025/7/1 18:58:03 GetSPUId获取到结果:SPUId:N002527,CategoryCode:40,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/7/1 18:58:03 响应体:{"Status":200,"Result":",KTC A25Q5 24.5 inch FHD 60Hz 便携屏 support touch操作成功","SuccessSPUSKUResponse":[{"SrmSPU":581241184981061,"ErpSPU":"N002527","SKURelations":[{"SrmSKU":"581242947858501","ErpSKU":"1294489"}],"Msg":null}],"FailSPUSKUResponse":[]}