2025/7/2 9:18:07 请求体:[{"SPUId":581352212820037,"BaseInfo":{"Category1":10,"Category2":1004,"Category3":100401,"Category4":null,"TemplateId":2,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Xiaomi Mi band 10 中文版","ProductShortName":"","ProductEName":"Xiaomi Mi band 10 CN version","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
小米手环10中文版配备1.72英寸四边等窄AMOLED屏,支持150+种运动模式、21天长续航,搭载HyperOS 2.0系统,新增陶瓷机身及游泳实时心率监测
","EHighlights":"The Xiaomi Smart Band 10 Chinese version features a 1.72-inch AMOLED display with four-side narrow bezels, 150+ workout modes, 21-day battery life, HyperOS 2.0, and optional ceramic body with real-time swim heart rate tracking
","Specification":"\n\n\nGeneral | \nBrand:xiaomi Model:Xiaomi Mi band 10 | \n
\n\nHardware Specification | \nChip:BES2700izMP Bluetooth Version: 5.4 RAM:16MB ROM:256MB Extra Flash:No Water resistance:IP68 System Requirement:Android 8.0+ / iOS 14.0+ Sensor:9-axis motion, optical HR/SpO₂, ambient light | \n
\n\nFunctions | \nHealth tracker:24/7 HR, SpO₂, sleep/stress analysis, PAI score, women’s health Notification Support:Calls, apps, calendar, weather; customizable blocking Alert type:Haptic + visual; idle/heart rate/SpO₂ alerts; hydration/medication reminders Other Function:Music/camera control, Find My Phone, smart home, 200+ watch faces, wireless charging | \n
\n\nScreen | \nScreen:Amoled Screen Size:1.72 inch Shape of the dial:Racetrack-shaped (four-side narrow bezel) Operating mode:Touch controls | \n
\n\nBattery | \nBattery Capacity:233mAh lithium polymer battery Charging Time:60 Mins Standby Time: 21days Use Time:21days | \n
\n\nMaterial | \nCase Material:Aluminum alloy frame Strap Length:Adjustable: 135–210mm Strap With:22.7mm Available Color:Black/White/Pink/Green Band material:TPU | \n
\n\nAPP/Language | \nAPP/APK:Xiaomi Fitness APP/APK Support Language:Xiaomi Fitness Smartband Suppotr Language:Multi-language (English, Chinese, Spanish, German, etc. - varies by region) Smartband Push Texts Language:Multi-language (English, Chinese, Spanish, German, etc. - varies by region) | \n
\n\nWeight & Size | \nPackage Weight: 95g | \n
\n\nPackage Contents | \n\n 1 x Mi band 10 1 x charger 1 x Strap \n | \n
\n\n
","PropertyValuesDto":[{"Code":1007,"CName":"按功能","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Blood Oxygen","ValueCode":3833,"Color":null}]}],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"深圳市龙华区东环二路企生活人工智能华盛园1栋5层","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":265.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"2405","PStocker":"2054","Supplier":"V6122","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":403,"Weight":0.0016,"GrossWeight":0.0085,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":4.7,"ProductW":2.3,"ProductH":1.1,"PackgeL":9.8,"PackgeW":9.8,"PackgeH":6.8,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":581354904358981,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3938","CName":"Xiaomi Mi band 10 中文版 黑 112220250702011 ","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\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":265,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V6122\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":403,\"Weight\":0.0016,\"GrossWeight\":0.0085,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":4.7,\"ProductW\":2.3,\"ProductH\":1.1,\"PackgeL\":9.8,\"PackgeW\":9.8,\"PackgeH\":6.8,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Mi Band 10 CN version \",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":581354904395845,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3939","CName":"Xiaomi Mi band 10 中文版 白 112220250702012","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\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":265,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V6122\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":403,\"Weight\":0.0016,\"GrossWeight\":0.0085,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":4.7,\"ProductW\":2.3,\"ProductH\":1.1,\"PackgeL\":9.8,\"PackgeW\":9.8,\"PackgeH\":6.8,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Mi Band 10 CN version \",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":581354904436805,"Color":"颜色","ColorCode":"1339","ColorValueCode":"4951","CName":"Xiaomi Mi band 10 中文版 粉红色 112220250702013","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\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":265,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V6122\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":403,\"Weight\":0.0016,\"GrossWeight\":0.0085,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":4.7,\"ProductW\":2.3,\"ProductH\":1.1,\"PackgeL\":9.8,\"PackgeW\":9.8,\"PackgeH\":6.8,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Mi Band 10 CN version \",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":581354904473669,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3937","CName":"Xiaomi Mi band 10 中文版 绿 112220250702014","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\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":265,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V6122\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":403,\"Weight\":0.0016,\"GrossWeight\":0.0085,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":4.7,\"ProductW\":2.3,\"ProductH\":1.1,\"PackgeL\":9.8,\"PackgeW\":9.8,\"PackgeH\":6.8,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Mi Band 10 CN version \",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/1_99999999999_581358541819973.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/2_99999999999_581358571266117.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/3_99999999999_581358627749957.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/4_99999999999_581358648475717.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/5_99999999999_581358780227653.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/6_99999999999_581358848041029.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/7_99999999999_581358920347717.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/8_99999999999_581358950924357.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/9_99999999999_581358975643717.jpg"}]},"SKUPictureInfos":[{"SrmSKU":581354904358981,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/1_99999999999_581358541819973.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/2_99999999999_581358571266117.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/3_99999999999_581358627749957.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/4_99999999999_581358648475717.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/5_99999999999_581358780227653.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/6_99999999999_581358848041029.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/7_99999999999_581358920347717.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/8_99999999999_581358950924357.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/9_99999999999_581358975643717.jpg","ImgSort":4}]},{"SrmSKU":581354904395845,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/1_99999999999_581358541819973.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/2_99999999999_581358571266117.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/3_99999999999_581358627749957.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/4_99999999999_581358648475717.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/5_99999999999_581358780227653.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/6_99999999999_581358848041029.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/7_99999999999_581358920347717.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/8_99999999999_581358950924357.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/9_99999999999_581358975643717.jpg","ImgSort":4}]},{"SrmSKU":581354904436805,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/1_99999999999_581358541819973.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/2_99999999999_581358571266117.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/3_99999999999_581358627749957.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/4_99999999999_581358648475717.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/5_99999999999_581358780227653.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/6_99999999999_581358848041029.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/7_99999999999_581358920347717.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/8_99999999999_581358950924357.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/9_99999999999_581358975643717.jpg","ImgSort":4}]},{"SrmSKU":581354904473669,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/1_99999999999_581358541819973.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/2_99999999999_581358571266117.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/3_99999999999_581358627749957.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/4_99999999999_581358648475717.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/5_99999999999_581358780227653.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/6_99999999999_581358848041029.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/7_99999999999_581358920347717.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/8_99999999999_581358950924357.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/9_99999999999_581358975643717.jpg","ImgSort":4}]}]},"UserId":"2054"}]
2025/7/2 9:18:07 GetSPUId方法内部,CategoryCode:10,sql:
2025/7/2 9:18:07 GetSPUId获取到结果:SPUId:E002327,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/7/2 9:18:16 响应体:{"Status":200,"Result":",Xiaomi Mi band 10 中文版操作成功","SuccessSPUSKUResponse":[{"SrmSPU":581352212820037,"ErpSPU":"E002327","SKURelations":[{"SrmSKU":"581354904358981","ErpSKU":"1294490"},{"SrmSKU":"581354904395845","ErpSKU":"1294491"},{"SrmSKU":"581354904436805","ErpSKU":"1294492"},{"SrmSKU":"581354904473669","ErpSKU":"1294493"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/7/2 9:20:33 请求体:[{"SPUId":581362956886085,"BaseInfo":{"Category1":10,"Category2":1003,"Category3":100302,"Category4":10030201,"TemplateId":6,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Redmi Buds 7s 无线耳机 国内版","ProductShortName":"","ProductEName":"Redmi Buds 7s","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"红米Buds 7S搭载12mm镀钛动圈,支持主动降噪(35dB深度)与30小时续航,轻量化设计仅4.3克
","EHighlights":"Redmi Buds 7S feature 12mm titanium-coated drivers, 35dB ANC, 30-hour battery life, and ultra-lightweight 4.3g design.
","Specification":"\n\n\nGeneral | \n\n Brand: Redmi TypeTWS Earphone Model: Buds 7s Color:Black/White/Green \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight:41.4g Package Weight:70g Product Size(L x W x H): 61.0×51.7×24.8mm Package Size(L x W x H): 90.5×70.2×40.3mm | \n
\n\nPackage Contents | \n\n 1 x TWS earphone 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":"深圳市龙华区东环二路企生活人工智能华盛园1栋5层","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":196.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"2405","PStocker":"2219","Supplier":"V6122","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":404,"Weight":0.0414,"GrossWeight":0.0700,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":6.1,"ProductW":5.2,"ProductH":2.5,"PackgeL":9.0,"PackgeW":7.0,"PackgeH":4.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":581364230078533,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3938","CName":"Redmi Buds 7s 无线耳机 国内版 黑 1120250702021","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\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":196,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2219\",\"Supplier\":\"V6122\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":404,\"Weight\":0.0414,\"GrossWeight\":0.0700,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":6.1,\"ProductW\":5.2,\"ProductH\":2.5,\"PackgeL\":9,\"PackgeW\":7,\"PackgeH\":4,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Redmi Buds 7s\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":581364230152261,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3939","CName":"Redmi Buds 7s 无线耳机 国内版 白 1120250702022","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\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":196,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2219\",\"Supplier\":\"V6122\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":404,\"Weight\":0.0414,\"GrossWeight\":0.0700,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":6.1,\"ProductW\":5.2,\"ProductH\":2.5,\"PackgeL\":9,\"PackgeW\":7,\"PackgeH\":4,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Redmi Buds 7s\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":581364230189125,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3937","CName":"Redmi Buds 7s 无线耳机 国内版 绿 1120250702023","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\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":196,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2219\",\"Supplier\":\"V6122\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":404,\"Weight\":0.0414,\"GrossWeight\":0.0700,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":6.1,\"ProductW\":5.2,\"ProductH\":2.5,\"PackgeL\":9,\"PackgeW\":7,\"PackgeH\":4,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Redmi Buds 7s\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/12_99999999999_581367660183621.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/13_99999999999_581367674990661.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/14_99999999999_581367687913541.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/10_99999999999_581367719514181.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/11_99999999999_581367748329541.jpg"}]},"SKUPictureInfos":[{"SrmSKU":581364230078533,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/12_99999999999_581367660183621.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/13_99999999999_581367674990661.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/14_99999999999_581367687913541.jpg","ImgSort":2}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/10_99999999999_581367719514181.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/11_99999999999_581367748329541.jpg","ImgSort":1}]},{"SrmSKU":581364230152261,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/12_99999999999_581367660183621.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/13_99999999999_581367674990661.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/14_99999999999_581367687913541.jpg","ImgSort":2}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/10_99999999999_581367719514181.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/11_99999999999_581367748329541.jpg","ImgSort":1}]},{"SrmSKU":581364230189125,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/12_99999999999_581367660183621.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/13_99999999999_581367674990661.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/14_99999999999_581367687913541.jpg","ImgSort":2}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/10_99999999999_581367719514181.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/11_99999999999_581367748329541.jpg","ImgSort":1}]}]},"UserId":"2054"}]
2025/7/2 9:20:33 GetSPUId方法内部,CategoryCode:10,sql:
2025/7/2 9:20:33 GetSPUId获取到结果:SPUId:E002328,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/7/2 9:20:38 响应体:{"Status":200,"Result":",Redmi Buds 7s 无线耳机 国内版操作成功","SuccessSPUSKUResponse":[{"SrmSPU":581362956886085,"ErpSPU":"E002328","SKURelations":[{"SrmSKU":"581364230078533","ErpSKU":"1294494"},{"SrmSKU":"581364230152261","ErpSKU":"1294495"},{"SrmSKU":"581364230189125","ErpSKU":"1294496"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/7/2 14:00:09 请求体:[{"SPUId":581209044680773,"BaseInfo":{"Category1":40,"Category2":4003,"Category3":400301,"Category4":null,"TemplateId":7,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"MINIX NUC 150 Intel N150 16GB+512GB WiFi 6 Mini PC","ProductShortName":"","ProductEName":"MINIX NUC 150 Intel N150 16GB/512GB Wi-Fi 6","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"1
","EHighlights":"1
","Specification":"\n\n\nGeneral | \n\n Model:NUC150 Type:MiniPC \n | \n
\n\nHardware | \n\n OS:Windows 11 Pro CPU:Intel N150 GPU: RAM:16GB ROM: \n | \n
\n\nCommunication | \n\n WIFI:Wi-Fi 6 Bluetooth:BT5.2 LAN:2.5G \n | \n
\n\nMedia | \n\n Decoder Format: Video format:MP4,AVI,WMV,MKV,MOV,FLV,WEBM,OGG Audio format:WAV,MP3,AAC,FLAC,WMA,M4A Photo Format:JPEG,PNG,GIF,BMP,TIFF,PSD,RAW,HEIF,WebP Support 5.1 Surround Sound Output: \n | \n
\n\nInterface | \n | \n
\n\nOther Features | \n\n System Bit: Language: Support multi-language Other Functions: External Subtitle Supported: HDMI Version:HDMI 2.1 TMDS (4K/60Hz) HDMI Function:Support CEC Remote Controller Battery: \n | \n
\n\nPower | \nPower Type:DC Power Supply:19V 3.42A Power Consumption:65W Max | \n
\n\nDimensiions&Weight | \n | \n
\n\n | \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":279.0000,"LimitPriceCurrency":"0002","PurchasePrice":195.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":5,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"CE,FCC,ROHS","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"USWDX,USEDX,USMDX,PLDX,PLFLYDX","RStocker":"1939","PStocker":"2219","Supplier":"V6101","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":2,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":0.3700,"GrossWeight":1.2100,"BoxWeight":6.7000,"BoxQuantity":0,"ProductL":11.7,"ProductW":11.1,"ProductH":3.6,"PackgeL":59.0,"PackgeW":20.5,"PackgeH":20.5,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":581216719069253,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"MINIX NUC 150 Intel N150 16GB+512GB WiFi 6 Mini PC 三规插头 银色","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":2,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":\"4897016413117\",\"ShippingAddress\":\"\",\"LimitPriceType\":1,\"LimitPrice\":279.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":195,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":5,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE,FCC,ROHS\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"USWDX,USEDX,USMDX,PLDX,PLFLYDX\",\"RStocker\":\"1939\",\"PStocker\":\"2219\",\"Supplier\":\"V6101\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":\"4897016413117\",\"WLEmbargoType\":100,\"Weight\":0.3700,\"GrossWeight\":1.2100,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":11.7,\"ProductW\":11.1,\"ProductH\":3.6,\"PackgeL\":59,\"PackgeW\":20.5,\"PackgeH\":20.5,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"MINIX NUC150 \",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":12}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e5%be%ae%e4%bf%a1%e5%9b%be%e7%89%87_20250701162317_99999999999_581218316517445.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e5%be%ae%e4%bf%a1%e5%9b%be%e7%89%87_20250701162317_99999999999_581483814031429.jpg"}]},"SKUPictureInfos":[{"SrmSKU":581216719069253,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e5%be%ae%e4%bf%a1%e5%9b%be%e7%89%87_20250701162317_99999999999_581218316517445.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/%e5%be%ae%e4%bf%a1%e5%9b%be%e7%89%87_20250701162317_99999999999_581218326298693.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/7/2 14:00:09 GetSPUId方法内部,CategoryCode:40,sql:
2025/7/2 14:00:09 GetSPUId获取到结果:SPUId:N002528,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/2 14:00:45 响应体:{"Status":200,"Result":",MINIX NUC 150 Intel N150 16GB+512GB WiFi 6 Mini PC操作成功","SuccessSPUSKUResponse":[{"SrmSPU":581209044680773,"ErpSPU":"N002528","SKURelations":[{"SrmSKU":"581216719069253","ErpSKU":"1294505"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/7/2 15:18:14 请求体:[{"SPUId":581165052391493,"BaseInfo":{"Category1":10,"Category2":1002,"Category3":100201,"Category4":null,"TemplateId":20,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"预售 7月底发货 欧规ULTIMEA Poseidon E100 1800 ANSI 投影仪","ProductShortName":"","ProductEName":"ULTIMEA Poseidon E100 1800 ANSI Projector","EAN":null,"BrandEName":"Ultimea","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"通过真正的 1080P 分辨率提供锐利、细腻的视觉效果,并通过 4K 解码增强清晰度。
120% DCI-P3 色彩范围带来更丰富、更生动的视觉效果--提供逼真的色调和增强的图像深度,带来更身临其境的观看体验。
USPAA™ 是 Ultimea 专有的智能图像优化系统,旨在自动提升您的投影体验。它能提供流畅、即时的调整,不会出现模糊的瞬间--因此您永远不会感觉在等待焦点跟上。
更响亮、更环绕、更多细节
采用运动插值技术,减少模糊和抖动,尤其是在快速移动的场景中,真实再现肉眼的视觉奇观。让您沉浸在体育赛事中。
使用 3D 眼镜体验电影世界,每个场景都充满深度和真实感。您的家庭影院体验将从此与众不同。
","EHighlights":"Delivers sharp, detailed visuals with true 1080P resolution and enhanced clarity through 4K decoding.
Enjoy richer, more vibrant visuals with 120% DCI-P3 color range—delivering true-to-life tones and enhanced image depth for a more immersive viewing experience.
USPAA™ is Ultimea’s proprietary intelligent image optimization system, designed to automate and elevate your projection experience. It delivers smooth, instant adjustments with no blurry moments—so you’ll never feel like you’re waiting for the focus to catch up.
Louder, More Surround and More Details
With Motion Interpolation Technology, reducing blur and jitter, especially in fast-moving scenes, to authentically replicate the visual wonders of the naked eye. Immerse yourself in the sports event.
Experience a cinematic world with 3D glasses, where every scene comes alive with depth and realism. Your home theater experience will never be the same.
","Specification":"\n\n\nBasic Information | \nBand: ULTIMEA Model: U0840 Type: Projector Color: Silver | \n
\n\nOptical Parameters | \nTechnology Type: DLP Physical Resolution: 1920×1080 Support Max Resolution: 4k Brightness: 1800 ANSI Contrast Ratio: 2000:1 Aspect Ratio: 1.2:1 | \n
\n\nOptical Elements | \nImage Size: 20''-300'' | \n
\n\nSystem | \nOS: Google TV 11.0 RAM: 2GB ROM: 8GB WIFI: 2.4GHz+5GHz Bluetooth: 5.3 OSD Menu Language: English | \n
\n\nInput/Output | \nPort: HDMI,AUX,USB Speaker: 2x 15W | \n
\n\nMEMC | \nYes | \n
\n\nSize & Weight | \nProjector Size: 30 x 30 x 20 cm Product Weight: 3.45KG Packing Size: 24.5 x 24.5 x 23 cm Gross Weight: 2.45KG | \n
\n\nPackage Contents | \n\n 1 x Projector \n1 x Remote Conctrl \n1 x User Manual \n1 x HDMI Cable \n1 x Power Cable \n | \n
\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":1060.0000,"LimitPriceCurrency":"0002","PurchasePrice":700.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":"1x Projector\n1x Remote Conctrl\n1x User Manual\n1x HDMI Cable\n1x Power Cable\n","WLEmbargoType":100,"Weight":2.4500,"GrossWeight":3.4500,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":20.0,"ProductW":30.0,"ProductH":30.0,"PackgeL":24.5,"PackgeW":24.5,"PackgeH":23.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":581166346055749,"Color":"规格","ColorCode":"1381","ColorValueCode":"4635","CName":"ULTIMEA Poseidon E100 1800 ANSI 投影仪 欧规","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\":1060.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":700,\"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\":\"1x Projector\\n1x Remote Conctrl\\n1x User Manual\\n1x HDMI Cable\\n1x Power Cable\\n\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":2.4500,\"GrossWeight\":3.4500,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":20,\"ProductW\":30,\"ProductH\":30,\"PackgeL\":24.5,\"PackgeW\":24.5,\"PackgeH\":23,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"U0840\",\"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/1_99999999999_581166435065925.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/2_99999999999_581166462836805.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/3_99999999999_581166476841029.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/4_99999999999_581166490865733.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/5_99999999999_581166508617797.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/6_99999999999_581166523584581.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/7_99999999999_581166536859717.jpg"}]},"SKUPictureInfos":[{"SrmSKU":581166346055749,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/1_99999999999_581166435065925.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/2_99999999999_581166462836805.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/3_99999999999_581166476841029.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/4_99999999999_581166490865733.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/5_99999999999_581166508617797.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/6_99999999999_581166523584581.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-07/7_99999999999_581166536859717.jpg","ImgSort":5}]}]},"UserId":"2364"}]
2025/7/2 15:18:14 GetSPUId方法内部,CategoryCode:10,sql:
2025/7/2 15:18:14 GetSPUId获取到结果:SPUId:E002329,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/7/2 15:18:17 响应体:{"Status":200,"Result":",预售 7月底发货 欧规ULTIMEA Poseidon E100 1800 ANSI 投影仪操作成功","SuccessSPUSKUResponse":[{"SrmSPU":581165052391493,"ErpSPU":"E002329","SKURelations":[{"SrmSKU":"581166346055749","ErpSKU":"1294507"}],"Msg":null}],"FailSPUSKUResponse":[]}