2025/6/19 9:42:51 请求体：[{"SPUId":576639357227077,"BaseInfo":{"Category1":50,"Category2":5001,"Category3":500102,"Category4":null,"TemplateId":1,"RecommendType":1,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"FOSSiBOT F109S 三防智能手机 6GB RAM 256GB ROM 10600mAh 电池 ","ProductShortName":"","ProductEName":" Fossibot F109s Dual Sim 256 GB ROM Azul 24 GB RAM","EAN":null,"BrandEName":"FOSSiBOT","VideoLink":null,"IsPackage":false,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"内存 RAM：24 GB。
内部存储器：256 GB。
4G Helio G81 处理器 + 24GB RAM (6GB+18GB) +256GB ROM 内存
10600 mAh 电池和反向 OTG 电池
6.7 普尔加达的 HD+ 可视化和 1.32 普尔加达的可视化 trasera
50 MP 的主摄像头和 5 MP 的额摄像头
IP68/IP69K 和 MIL-STD-810H
4G 双 SIM 卡和电话 Android 15
","EHighlights":"\n- Memoria RAM: 24 GB.
\n- Memoria interna: 256 GB.
\n- 4G Helio G81 procesador + y 24GB RAM (6gb+18gb) +256GB ROM Memoria
\n- Batería de 10600 mAh y carga inversa OTG
\n- visualización HD+ de 6.7 pulgadas y visualización trasera de 1.32 pulgadas
\n- Cámara principal de 50 MP y cámara frontal de 5 MP
\n- IP68/IP69K y MIL-STD-810H
\n- 4G Dual SIM y teléfono Android 15
\n
","Specification":"\n\n\n| General | \nBrand:Fossibot
Model:F109S
Color: blue | \n
\n\n| System | \nOperating System: android15.0
CPU:MT6759
RAM:6GM
ROM:256GM
Extended Storage:18GM | \n
\n\n| Display | \nScreen type:In-Cell Touch
Screen size:6.745 HD IPS
Screen resolution:720×1600 | \n
\n\n| Network | \nWireless connectiveity:GSM,GPRS,EDGE,WCDMA,LTE
Frequency:WCDMA:B1B2B4B5B8
Bluetooth:support BT5.0
WiFi:support
GPS:support | \n
\n\n| Camera | \nCamera type:50MP
Back camera: 5MP
Front camera: 8MP | \n
\n\n| Media | \nVideo format:HD
Audio format:microphone
Image format:HD
FM radio:support | \n
\n\n| Additional Features | \nSimple appearance | \n
\n\n| Battery | \nBattery type:
Capacity:10600mAh
Standby time::4h10min
Charger:18W | \n
\n\n| Dimension & Weight (Main Product) | \nDimension:81.7×176.1×18.5MM
Weight:710g | \n
\n\n| Package Contents | \n1 x | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"德国海外仓","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":110.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":3,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,USDF","RStocker":"2228","PStocker":"2054","Supplier":"V5617","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":0.7500,"GrossWeight":0.8000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":10.0,"ProductW":14.0,"ProductH":2.0,"PackgeL":21.0,"PackgeW":17.0,"PackgeH":5.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":576642889035845,"Color":"规格","ColorCode":"1381","ColorValueCode":"4636","CName":"FOSSiBOT F109S 三防智能手机 6GB RAM 256GB ROM 10600mAh 电池 蓝色 美规 ","Size":"颜色","SizeCode":"1339","SizeValueCode":"3931","Option":"AC额定功率","OptionCode":"1383","OptionValueCode":"4660","SampleCount":1,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":true,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":110,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":3,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"USDF\",\"RStocker\":\"2228\",\"PStocker\":\"2054\",\"Supplier\":\"V5617\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.7500,\"GrossWeight\":0.8000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":10,\"ProductW\":14,\"ProductH\":2,\"PackgeL\":21,\"PackgeW\":17,\"PackgeH\":5,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"F109S\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":576642889097285,"Color":"规格","ColorCode":"1381","ColorValueCode":"4635","CName":"FOSSiBOT F109S 三防智能手机 6GB RAM 256GB ROM 10600mAh 电池 蓝色 欧规","Size":"颜色","SizeCode":"1339","SizeValueCode":"3931","Option":"AC额定功率","OptionCode":"1383","OptionValueCode":"4660","SampleCount":1,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":true,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":110,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":3,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2228\",\"PStocker\":\"2054\",\"Supplier\":\"V5617\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.7500,\"GrossWeight\":0.8000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":10,\"ProductW\":14,\"ProductH\":2,\"PackgeL\":21,\"PackgeW\":17,\"PackgeH\":5,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"F109S\",\"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/%e7%94%bb%e6%9d%bf+10_99999999999_576644036857925.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%94%bb%e6%9d%bf+8_99999999999_576644059205701.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%94%bb%e6%9d%bf+1_99999999999_576644388868165.jpg"}]},"SKUPictureInfos":[{"SrmSKU":576642889035845,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%94%bb%e6%9d%bf+10_99999999999_576644036857925.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%94%bb%e6%9d%bf+8_99999999999_576644059205701.jpg","ImgSort":1}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%94%bb%e6%9d%bf+1_99999999999_576644388868165.jpg","ImgSort":0}]},{"SrmSKU":576642889097285,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%94%bb%e6%9d%bf+10_99999999999_576644036857925.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%94%bb%e6%9d%bf+8_99999999999_576644059205701.jpg","ImgSort":1}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/%e7%94%bb%e6%9d%bf+1_99999999999_576644388868165.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/19 9:42:51 GetSPUId方法内部，CategoryCode：50，sql：
2025/6/19 9:42:51 GetSPUId获取到结果：SPUId:P000378,CategoryCode:50,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/19 9:42:52 响应体：{"Status":200,"Result":",FOSSiBOT F109S 三防智能手机 6GB RAM 256GB ROM 10600mAh 电池 操作成功","SuccessSPUSKUResponse":[{"SrmSPU":576639357227077,"ErpSPU":"P000378","SKURelations":[{"SrmSKU":"576642889035845","ErpSKU":"1293215"},{"SrmSKU":"576642889097285","ErpSKU":"1293216"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/19 16:12:54 请求体：[{"SPUId":576962875924549,"BaseInfo":{"Category1":40,"Category2":4004,"Category3":400401,"Category4":40040112,"TemplateId":46,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"KTC H27D9 Flat 16:9 IPS QHD 2560 *1440@100Hz Office monitor Overdrive to 120Hz USA Version","ProductShortName":"","ProductEName":"KTC H27D9 Flat 16:9 IPS QHD 2560 *1440@100Hz Office monitor Overdrive to 120Hz USA Version","EAN":null,"BrandEName":"KTC","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"KTC H27D9 Flat 16:9 IPS QHD 2560 *1440@100Hz Office monitor Overdrive to 120Hz USA Version
","EHighlights":"KTC H27D9 Flat 16:9 IPS QHD 2560 *1440@100Hz Office monitor Overdrive to 120Hz USA Version
","Specification":"\n\n\n| General | \n\n Brand: KTC
Type:
Model: H27D9
Color: \n | \n
\n\n| Specification | \n | \n
\n\n| Weight & Size | \nProduct Weight:
Package Weight:
Product Size(L x W x H):
Package Size(L x W x H): | \n
\n\n| Package 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":129.0000,"LimitPriceCurrency":"0002","PurchasePrice":67.0,"PurchasePriceCurrency":"0002","MinOrder":500,"DeliveryTime":45,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"FCC","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":100,"Weight":3.6000,"GrossWeight":4.6500,"BoxWeight":0.0,"BoxQuantity":1,"ProductL":62.0,"ProductW":45.0,"ProductH":19.0,"PackgeL":69.0,"PackgeW":11.0,"PackgeH":45.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":576967858946117,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"KTC H27D9 Flat 16:9 IPS QHD 2560 *1440 100Hz Overdrive to 120Hz 显示器 美规","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\":\"6921958687881\",\"ShippingAddress\":\"\",\"LimitPriceType\":1,\"LimitPrice\":129.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":67,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":500,\"DeliveryTime\":45,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"FCC\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZDG,ZFSZDG\",\"RStocker\":\"2228\",\"PStocker\":\"2219\",\"Supplier\":\"V5368\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":\"6921958687881\",\"WLEmbargoType\":100,\"Weight\":3.6000,\"GrossWeight\":4.6500,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":62,\"ProductW\":45,\"ProductH\":19,\"PackgeL\":69,\"PackgeW\":11,\"PackgeH\":45,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"H27D9\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":12}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/H27D9_99999999999_576967874003013.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/H27D9_99999999999_576967883333701.jpg"}]},"SKUPictureInfos":[{"SrmSKU":576967858946117,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/H27D9_99999999999_576967874003013.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/H27D9_99999999999_576967883333701.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/19 16:12:54 GetSPUId方法内部，CategoryCode：40，sql：
2025/6/19 16:12:54 GetSPUId获取到结果：SPUId:N002499,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/6/19 16:12:55 响应体：{"Status":200,"Result":",KTC H27D9 Flat 16:9 IPS QHD 2560 *1440@100Hz Office monitor Overdrive to 120Hz USA Version操作成功","SuccessSPUSKUResponse":[{"SrmSPU":576962875924549,"ErpSPU":"N002499","SKURelations":[{"SrmSKU":"576967858946117","ErpSKU":"1293232"}],"Msg":null}],"FailSPUSKUResponse":[]}