2025/6/26 9:41:32 请求体:[{"SPUId":574524168654917,"BaseInfo":{"Category1":11,"Category2":1101,"Category3":110101,"Category4":null,"TemplateId":18,"RecommendType":3,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Teendow V08 Pro 无线吸尘器","ProductShortName":"","ProductEName":"Teendow V08 Pro Cordless Vacuum","EAN":null,"BrandEName":"Teendow","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
\n- 先进过滤系统:5级全密封过滤,能有效收集99.9%的灰尘,防止二次污染,保持室内空气清新。
\n- 强大电池性能:2200mAh电池,充电仅需4小时,标准模式下可持续清洁35分钟,满足日常清洁需求。
\n- 可调吸力:提供两种速度选项,高档模式下吸力强劲,达到25KPA,轻松应对各种清洁任务。
\n- 用户友好设计:轻便易操作,适合单手使用,特别适合力量有限的用户,降低清洁负担。
\n- 可伸缩设计:带灯的可伸缩吸头,便于清理难以触及的角落,提升清洁效率。
\n
","EHighlights":"\n- Advanced Filtration System: 5-stage fully sealed filtration captures 99.9% of dust, preventing secondary pollution and keeping indoor air fresh.
\n- Powerful Battery Performance: 2200mAh battery charges in just 4 hours, providing 35 minutes of continuous cleaning on standard mode, perfect for everyday cleaning needs.
\n- Adjustable Suction Power: Two speed options available, with high mode offering a strong 25KPA suction to tackle various cleaning tasks easily.
\n- User-Friendly Design: Lightweight and easy to operate, suitable for one-handed use, especially designed for users with limited strength, reducing cleaning fatigue.
\n- Retractable Design: Equipped with a light and retractable nozzle for easy access to hard-to-reach corners, enhancing cleaning efficiency.
\n
","Specification":"\n\n\nGeneral | \n\n Brand: Teendow Type: Cordless Model: Teendow V08 Pro Color: White \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: 2.6KG Package Weight: 3.29KG Product Size(L x W x H): 1145*235*230mm Package Size(L x W x H): 430*255*180mm | \n
\n\nPackage Contents | \n\n 1 x Machine 1 x User Manual \n | \n
\n\n
","PropertyValuesDto":[{"Code":1343,"CName":"电池容量","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"2000mAh-3000mAh","ValueCode":4318,"Color":null}]},{"Code":1360,"CName":"尘盒容量","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"≥700ml","ValueCode":4310,"Color":null}]},{"Code":1348,"CName":"电机额定功率","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"100W-250W","ValueCode":4240,"Color":null}]},{"Code":1354,"CName":"运作时间","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"15-30 mins","ValueCode":4270,"Color":null}]},{"Code":1359,"CName":"吸力","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"20000-30000 Pa","ValueCode":4302,"Color":null}]},{"Code":1362,"CName":"充电时间","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"4.5h","ValueCode":4326,"Color":null}]},{"Code":1049,"CName":"充电输出规格","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"220V-240V","ValueCode":4225,"Color":null}]},{"Code":1350,"CName":"电机类型","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Brushless Motor","ValueCode":4330,"Color":null}]},{"Code":1369,"CName":"家用吸尘器功能","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Cyclonic","ValueCode":4430,"Color":null}]},{"Code":1358,"CName":"清洁功能","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Vacuum","ValueCode":4293,"Color":null}]},{"Code":1295,"CName":"类型","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"无线吸尘器","ValueCode":4218,"Color":null}]}],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Germany","LimitPriceType":1,"LimitPrice":119.0000,"LimitPriceCurrency":"0002","PurchasePrice":72.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":2,"AfterSaleMethodNote":null,"CertificateIds":"CE,UL,FCC,WEEE,ROHS,UN38.3","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,ZFEUDF","RStocker":"2406","PStocker":"0211","Supplier":"V6227","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"1.Long flat suction\n2.2-in-1 brush\n3.Wall mount\n4.Adapter\n ","WLEmbargoType":404,"Weight":2.8500,"GrossWeight":3.2900,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":114.5,"ProductW":23.5,"ProductH":23.0,"PackgeL":43.0,"PackgeW":25.5,"PackgeH":18.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":574525772300357,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"Teendow V08 Pro 无线吸尘器 欧规 白色","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":500,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":1,\"LimitPrice\":119.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":72,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":2,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE,UL,FCC,WEEE,ROHS,UN38.3\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF,ZFEUDF\",\"RStocker\":\"2406\",\"PStocker\":\"0211\",\"Supplier\":\"V6227\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1.Long flat suction\\n2.2-in-1 brush\\n3.Wall mount\\n4.Adapter\\n \",\"EAN\":null,\"WLEmbargoType\":404,\"Weight\":2.8500,\"GrossWeight\":3.2900,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":114.5,\"ProductW\":23.5,\"ProductH\":23,\"PackgeL\":43,\"PackgeW\":25.5,\"PackgeH\":18,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"V08 Pro\",\"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-2_99999999999_574530648272965.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1-1_99999999999_574530660732997.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/9_99999999999_574530634563653.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_574530480263237.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/3_99999999999_574530491543621.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_574530508472389.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/6_99999999999_574530530332741.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_574530518728773.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/7_99999999999_574530544070725.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/8_99999999999_574530554245189.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/10_99999999999_574530567311429.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/11_99999999999_574530582265925.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/12_99999999999_574530594570309.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/V08+Pro%e4%b8%bb%e5%9b%be_99999999999_574526021886021.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/9_99999999999_574526334226501.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1-1_99999999999_574526363402309.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1-2_99999999999_574526363672645.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/6_99999999999_574530770841671.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_574530770571333.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_574530770841670.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_574530770513989.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/3_99999999999_574530770509893.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/8_99999999999_574530773504070.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/7_99999999999_574530770841669.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/10_99999999999_574530773504069.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/11_99999999999_574530773827653.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/12_99999999999_574530773954629.jpg"}]},"SKUPictureInfos":[{"SrmSKU":574525772300357,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/V08+Pro%e4%b8%bb%e5%9b%be_99999999999_574525997948997.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/V08+Pro%e4%b8%bb%e5%9b%be_99999999999_574526021886021.jpg","ImgSort":0}]}]},"UserId":"0211"}]
2025/6/26 9:41:32 GetSPUId方法内部,CategoryCode:11,sql:
2025/6/26 9:41:32 GetSPUId获取到结果:SPUId:O002148,CategoryCode:11,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/26 9:41:38 响应体:{"Status":200,"Result":",Teendow V08 Pro 无线吸尘器操作成功","SuccessSPUSKUResponse":[{"SrmSPU":574524168654917,"ErpSPU":"O002148","SKURelations":[{"SrmSKU":"574525772300357","ErpSKU":"1294379"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/26 9:42:52 请求体:[{"SPUId":576900122955845,"BaseInfo":{"Category1":10,"Category2":1004,"Category3":100402,"Category4":null,"TemplateId":4,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Zeblaze Stratos 4 智能手表","ProductShortName":"","ProductEName":"Zeblaze Stratos 4 ","EAN":null,"BrandEName":"Zeblaze","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
\n6 个卫星定位系统
\nAMOLED 显示屏和内置手电筒
\n170+ 运动模式和智能识别
\n接听/拨打蓝牙电话
","EHighlights":"6 Satellite Positioning Systems
AMOLED Dispiay & Built-in Flashlight
170+ Sports Modes& Smart Recognition
Answer /Make Bluetooth Phone Calls
","Specification":"\n\n\n General | \nBrand:Zeblaze Model:Stratos 4 | \n
\n\nHardware | \nBuilt-in chip type: Bluetooth Version:5.3 Memory:<128MB Water Resistant:5 ATM System Requirement: Camera: WIFI: | \n
\n\nNetwork | \nWireless Connectivity: Network type: Frequency: | \n
\n\nFunctions | \nHealth tracker:Wrist Heart Rate Monitor, Pulse Ox Blood Oxygen Saturation Monitor Bluetooth sync: Alert type: Vibration:Yes Sim card: Speaker:Yes Other Function: | \n
\n\nMedia Formats | \nPicture format: Music format: Video format: | \n
\n\nScreen | \nScreen:AMOLED Screen size:1.43'' Shape of the dial:Round Operating mode:Touch screen+buttons | \n
\n\nBattery | \nBattery Capacity:500 mAh Charging Time:About 1.5 hours Other: Standby time: | \n
\n\nMaterial | \nCase material:Metal Bezel+Drilling Carbon Coating + 316L Stainless Steel Band material:silicone strap | \n
\n\nAPP/Language | \nAPP/APK Name:GloryFitPro APP/APK Support Language: Smartband Suppotr Language:English, Portuguese, Russian, Polish, Spanish, French, Italian, German, Dutch, Turkish, Bengali, Indonesian, Thai, Czech, Hebrew, Hungarian, Romanian, Vietnamese, Finnish, Norwegian, Swedish, Danish, New Zealand, Greek, Arabic, Ukrainian, Korean, Japanese, Simplified Chinese, Traditional Chinese Smartband Push Texts Language:English, Portuguese, Russian, Polish, Spanish, French, Italian, German, Dutch, Turkish, Bengali, Indonesian, Thai, Czech, Hebrew, Hungarian, Romanian, Vietnamese, Finnish, Norwegian, Swedish, Danish, New Zealand, Greek, Arabic, Ukrainian, Korean, Japanese, Simplified Chinese, Traditional Chinese | \n
\n\nPackage Contents | \n\n 1 x Smartwatch \n1 x Charging Cable 1 x User Maual \n | \n
\n\nNote/Warning | \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"深圳市龙华新区龙华街道油松社区利金城工业区4栋(西座) 601 ","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":299.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":6,"AfterSaleMethodNote":"手表进水不在保修范围内,只有提供图片和视频证明是产品本身质量问题才可以换新。","CertificateIds":"CE,FCC,ROHS,MSDS,UN38.3","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"2406","PStocker":"2219","Supplier":"V5114","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":401,"Weight":0.0630,"GrossWeight":0.2220,"BoxWeight":11.9000,"BoxQuantity":50,"ProductL":4.9,"ProductW":4.9,"ProductH":1.4,"PackgeL":10.5,"PackgeW":10.5,"PackgeH":7.0,"BoxL":55.0,"BoxW":24.0,"BoxH":38.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":576904416038981,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3938","CName":"Zeblaze Stratos 4 智能手表 黑","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\":\"6946639813847\",\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":299,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":6,\"AfterSaleMethodNote\":\"手表进水不在保修范围内,只有提供图片和视频证明是产品本身质量问题才可以换新。\",\"CertificateIds\":\"CE,FCC,ROHS,MSDS,UN38.3\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2406\",\"PStocker\":\"2219\",\"Supplier\":\"V5114\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":\"6946639813847\",\"WLEmbargoType\":401,\"Weight\":0.0630,\"GrossWeight\":0.2220,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":4.9,\"ProductW\":4.9,\"ProductH\":1.4,\"PackgeL\":10.5,\"PackgeW\":10.5,\"PackgeH\":7,\"BoxL\":55,\"BoxW\":24,\"BoxH\":38,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Stratos 4\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":576904416088133,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3932","CName":"Zeblaze Stratos 4 智能手表 橙","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\":\"6946639813854\",\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":299,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":6,\"AfterSaleMethodNote\":\"手表进水不在保修范围内,只有提供图片和视频证明是产品本身质量问题才可以换新。\",\"CertificateIds\":\"CE,FCC,ROHS,MSDS,UN38.3\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2406\",\"PStocker\":\"2219\",\"Supplier\":\"V5114\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":\"6946639813854\",\"WLEmbargoType\":401,\"Weight\":0.0630,\"GrossWeight\":0.2220,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":4.9,\"ProductW\":4.9,\"ProductH\":1.4,\"PackgeL\":10.5,\"PackgeW\":10.5,\"PackgeH\":7,\"BoxL\":55,\"BoxW\":24,\"BoxH\":38,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Stratos 4\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e9%bb%91%e8%89%b2_99999999999_576956445114437.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%a9%99%e8%89%b2_99999999999_576956462862405.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_576957906407493.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_576961921753157.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/3_99999999999_576961937498181.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_576961967063109.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_576962025570373.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/6_99999999999_576962048122949.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/7_99999999999_576962073608261.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/8_99999999999_576962098229317.jpg"}]},"SKUPictureInfos":[{"SrmSKU":576904416038981,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%a9%b1%e7%aa%973_99999999999_576904575066181.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_576904595402821.jpg","ImgSort":0}]},{"SrmSKU":576904416088133,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%a9%b1%e7%aa%973_99999999999_576904575066181.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_576904595402821.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/26 9:42:52 GetSPUId方法内部,CategoryCode:10,sql:
2025/6/26 9:42:52 GetSPUId获取到结果:SPUId:E002324,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/26 9:42:54 响应体:{"Status":200,"Result":",Zeblaze Stratos 4 智能手表操作成功","SuccessSPUSKUResponse":[{"SrmSPU":576900122955845,"ErpSPU":"E002324","SKURelations":[{"SrmSKU":"576904416038981","ErpSKU":"1294380"},{"SrmSKU":"576904416088133","ErpSKU":"1294381"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/26 10:05:43 请求体:[{"SPUId":579343985172549,"BaseInfo":{"Category1":60,"Category2":6001,"Category3":600102,"Category4":null,"TemplateId":38,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"WISEPRO 3D打印耗材缓冲器","ProductShortName":"","ProductEName":"WISEPRO 3D Printer Filament Buffer","EAN":null,"BrandEName":"WISEPRO","VideoLink":"https://youtu.be/oH6nFpOvIEk","IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":" 3D 打印耗材缓冲器
\n1、WISEPRO 耗材缓冲器专为远程进料而设计,可确保在打印过程中稳定、低阻力地进料,从而提高精度并减轻挤出机的负载。
\n
\n2、缓冲器会自动提前将一段灯丝送向热端,有效降低挤出机对耗材的拉力,保持稳定的推力,从而提高打印质量的稳定性。
\n
\n3、当耗材用完时,备用灯丝会在一分钟后自动送料,无需手动更换,也不会中断打印。非常适合长时间或无人值守的打印作业。
\n
\n4、实现不同灯丝颜色之间的平滑切换,为生动、多色的 3D 打印开辟更多创意可能性。
\n
\n5、安装快捷、使用简单——对于业余爱好者和专业 3D 打印用户来说都是理想的升级。
","EHighlights":" WISEPRO 3D Printer Filament Buffer
\n🎯 Smooth Remote Feeding for 1.75mm Filament
\nDesigned specifically for remote filament feeding, the WISEPRO 3D Printer Filament Buffer
\nensures stable, low-resistance filament delivery during printing—enhancing print accuracy
\nand reducing strain on the extruder.
\n
\n🔄 Automatic Filament Buffering
\nThe buffer automatically preloads a section of filament to the hot end. This reduces the
\npulling force required by the extruder, maintains consistent pushing pressure, and enhances
\noverall print quality stability.
\n
\n♻ Auto Filament Refill
\nWhen the primary filament runs out, the backup filament automatically feeds in after 1
\nminute—no manual intervention and no interruption to your print. Ideal for extended or
\nunattended print jobs.
\n
\n🎨 Multi-Color Filaments Switching
\nEnables smooth switching between different filament colors, opening up more creative
\npossibilities for vivid, multi-color 3D prints.
\n
\n🛠 Easy Setup & Broad Compatibility
\nQuick to install and simple to use—an ideal upgrade for both hobbyists and professional 3D
\nprinting users.
\n
","Specification":"\n\n\nGeneral | \n\n Brand: WISEPRO Type: Extruder Model: FB-1 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 \n | \n
\n\n
","PropertyValuesDto":[{"Code":1282,"CName":"配件类型","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"耗材传感器","ValueCode":4689,"Color":null}]}],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"深圳市龙华区民治街道蓝坤大厦1611","LimitPriceType":1,"LimitPrice":50.0000,"LimitPriceCurrency":"0002","PurchasePrice":228.0,"PurchasePriceCurrency":"0001","MinOrder":20,"DeliveryTime":3,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"2405","PStocker":"2054","Supplier":"V5933","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":0.1600,"GrossWeight":0.2900,"BoxWeight":0.0,"BoxQuantity":20,"ProductL":11.0,"ProductW":7.5,"ProductH":4.6,"PackgeL":2.0,"PackgeW":1.6,"PackgeH":6.4,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":579346171748421,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"WISEPRO 3D打印耗材缓冲器","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":1,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":1,\"LimitPrice\":50.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":228,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":20,\"DeliveryTime\":3,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5933\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.1600,\"GrossWeight\":0.2900,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":11,\"ProductW\":7.5,\"ProductH\":4.6,\"PackgeL\":2,\"PackgeW\":1.6,\"PackgeH\":6.4,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"FB-1\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be1(1)_99999999999_579346220093509.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e5%8a%9f%e8%83%bd%e7%89%b9%e5%be%81%e5%9b%be_99999999999_579346266845253.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%b8%85%e5%8d%95%e5%b0%ba%e5%af%b8%e5%9b%be_99999999999_579346267033669.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e5%9c%ba%e6%99%af%e5%9b%be_99999999999_579346267021381.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e9%80%82%e7%94%a8%e8%80%97%e6%9d%90%e5%9b%be_99999999999_579346267172933.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e5%85%bc%e5%ae%b9%e6%80%a7%e5%88%a4%e6%96%ad%e5%9b%be_99999999999_579346267115589.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%bb%86%e8%8a%82%e5%9b%be_99999999999_579346267115590.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%95%88%e6%9e%9c%e5%af%b9%e6%af%94%e5%9b%be_99999999999_579346267557957.jpg"}]},"SKUPictureInfos":[{"SrmSKU":579346171748421,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e4%b8%bb%e5%9b%be1(1)_99999999999_579346220093509.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e5%8a%9f%e8%83%bd%e7%89%b9%e5%be%81%e5%9b%be_99999999999_579346266845253.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%b8%85%e5%8d%95%e5%b0%ba%e5%af%b8%e5%9b%be_99999999999_579346267033669.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e5%9c%ba%e6%99%af%e5%9b%be_99999999999_579346267021381.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e9%80%82%e7%94%a8%e8%80%97%e6%9d%90%e5%9b%be_99999999999_579346267172933.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e5%85%bc%e5%ae%b9%e6%80%a7%e5%88%a4%e6%96%ad%e5%9b%be_99999999999_579346267115589.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%bb%86%e8%8a%82%e5%9b%be_99999999999_579346267115590.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e6%95%88%e6%9e%9c%e5%af%b9%e6%af%94%e5%9b%be_99999999999_579346267557957.jpg","ImgSort":6}]}]},"UserId":"2054"}]
2025/6/26 10:05:43 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/26 10:05:43 GetSPUId获取到结果:SPUId:I002935,CategoryCode:60,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/26 10:05:45 响应体:{"Status":200,"Result":",WISEPRO 3D打印耗材缓冲器操作成功","SuccessSPUSKUResponse":[{"SrmSPU":579343985172549,"ErpSPU":"I002935","SKURelations":[{"SrmSKU":"579346171748421","ErpSKU":"1294382"}],"Msg":null}],"FailSPUSKUResponse":[]}