2025/6/30 9:13:15 请求体:[{"SPUId":579721571971141,"BaseInfo":{"Category1":11,"Category2":1101,"Category3":110107,"Category4":null,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"JIMMY BX5 Pro 滚刷组件","ProductShortName":"","ProductEName":"JIMMY BX5 Pro Brushroll","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
JIMMY BX5 Pro滚刷组件
","EHighlights":"JIMMY BX5 Pro Brushroll
","Specification":"\n\n\nGeneral JIMMY BX5 Pro Brushroll | \n\n Brand: 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":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":27.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT,SUJK,ZFSZBT","RStocker":"0638","PStocker":"0211","Supplier":"V4051","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":0.0270,"GrossWeight":0.0290,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":24.0,"ProductW":4.0,"ProductH":0.1,"PackgeL":25.0,"PackgeW":5.0,"PackgeH":0.1,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":579723012681797,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"A13G0060001R JIMMY BX5 Pro滚刷组件","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\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":27,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT,SUJK,ZFSZBT\",\"RStocker\":\"0638\",\"PStocker\":\"0211\",\"Supplier\":\"V4051\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0270,\"GrossWeight\":0.0290,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":24,\"ProductW\":4,\"ProductH\":0.1,\"PackgeL\":25,\"PackgeW\":5,\"PackgeH\":0.1,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"BX5 Pro\",\"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/A13G0060001R_99999999999_580758218129477.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/A13G0060001R_99999999999_580758389555269.jpg"}]},"SKUPictureInfos":[{"SrmSKU":579723012681797,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/A13G0060001R_99999999999_580758218129477.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/A13G0060001R_99999999999_580758389555269.jpg","ImgSort":0}]}]},"UserId":"0211"}]
2025/6/30 9:13:15 GetSPUId方法内部,CategoryCode:11,sql:
2025/6/30 9:13:15 GetSPUId获取到结果:SPUId:O002150,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/30 9:13:19 响应体:{"Status":200,"Result":",JIMMY BX5 Pro 滚刷组件操作成功","SuccessSPUSKUResponse":[{"SrmSPU":579721571971141,"ErpSPU":"O002150","SKURelations":[{"SrmSKU":"579723012681797","ErpSKU":"1294419"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/30 13:53:05 请求体:[{"SPUId":578391795507269,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600201,"Category4":60020101,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"NEJE Max4 V2 E80 20W 激光雕刻机 ","ProductShortName":"","ProductEName":"SR-MAX4V2 E80 Eurometric Machine","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"","EHighlights":"The only module that can realize high-speed cutting and fine carving at the same time.
","Specification":"\n\n\nGeneral | \n\n Brand: NEJE Type: Model: E80 Color: black \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":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":4000.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,USDF","RStocker":"2405","PStocker":"2054","Supplier":"V5934","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":9.6000,"GrossWeight":10.6000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":104.0,"ProductW":26.0,"ProductH":19.0,"PackgeL":104.0,"PackgeW":26.0,"PackgeH":19.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":580797636210757,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3949","CName":"NEJE Max4 V2 E80 20W 激光雕刻机 欧规 NEJE01068","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":4000,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5934\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":9.6000,\"GrossWeight\":10.6000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":104,\"ProductW\":26,\"ProductH\":19,\"PackgeL\":104,\"PackgeW\":26,\"PackgeH\":19,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"E80\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"},{"SrmSKU":580797636251717,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3951","CName":"NEJE Max4 V2 E80 20W 激光雕刻机 美规 NEJE01069","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":4000,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"USDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5934\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":9.6000,\"GrossWeight\":10.6000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":104,\"ProductW\":26,\"ProductH\":19,\"PackgeL\":104,\"PackgeW\":26,\"PackgeH\":19,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"E80\",\"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/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813393190981.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813425725509.jpg"}]},"SKUPictureInfos":[{"SrmSKU":580797636210757,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813393190981.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813425725509.jpg","ImgSort":0}]},{"SrmSKU":580797636251717,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813393190981.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813425725509.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/30 13:53:05 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/30 13:53:05 GetSPUId获取到结果:SPUId:I002942,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/30 13:53:06 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813393190981.jpg,抓取SKU主图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 323
2025/6/30 13:53:06 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813425725509.jpg,抓取SKU描述图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 339
2025/6/30 13:53:06 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813393190981.jpg,抓取SKU主图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 323
2025/6/30 13:53:06 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Max4_v2-1000x1000_1024x1024%402x_99999999999_579813425725509.jpg,抓取SKU描述图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 339
2025/6/30 13:53:06 响应体:{"Status":200,"Result":",NEJE Max4 V2 E80 20W 激光雕刻机 操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578391795507269,"ErpSPU":"I002942","SKURelations":[{"SrmSKU":"580797636210757","ErpSKU":"1294434"},{"SrmSKU":"580797636251717","ErpSKU":"1294435"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/30 14:12:20 请求体:[{"SPUId":578499885047877,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600201,"Category4":60020101,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"NEJE 5 A40630 6.5W 激光雕刻机","ProductShortName":"","ProductEName":"NEJE 5 A40630 engraving machine","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"无线便携式激光切割机和雕刻机
","EHighlights":"
\n\n
\n
\n
\n
Wireless portable laser cutting machine and engraving machine
\n
\n
\n
","Specification":"\n\t\n\t\t\n\t\t\t\n\t\t\t\tGeneral \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tBrand: \nType: \nModel: \nColor: \n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tSpecification \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tWeight & Size \n\t\t\t | \n\t\t\t\n\t\t\t\tProduct Weight: \nPackage Weight: \nProduct Size(L x W x H): \nPackage Size(L x W x H): \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tPackage Contents \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\t1 x \n1 x User Manual\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"欧洲","LimitPriceType":2,"LimitPrice":189.0000,"LimitPriceCurrency":"0002","PurchasePrice":950.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2405","PStocker":"2054","Supplier":"V5934","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":2.5000,"GrossWeight":2.8000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":45.0,"ProductW":36.0,"ProductH":17.0,"PackgeL":45.0,"PackgeW":36.0,"PackgeH":17.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":578502157729861,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"NEJE 5 A40630 6.5W 激光雕刻机 欧规 NEJE00784","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":189.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":950,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5934\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":2.5000,\"GrossWeight\":2.8000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":45,\"ProductW\":36,\"ProductH\":17,\"PackgeL\":45,\"PackgeW\":36,\"PackgeH\":17,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"A40630\",\"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/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812712304709.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812734545989.jpg"}]},"SKUPictureInfos":[{"SrmSKU":578502157729861,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812712304709.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812734545989.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/30 14:12:20 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/30 14:12:20 GetSPUId获取到结果:SPUId:I002943,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/30 14:12:24 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812712304709.jpg,抓取SKU主图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 323
2025/6/30 14:12:24 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812734545989.jpg,抓取SKU描述图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 339
2025/6/30 14:12:24 响应体:{"Status":200,"Result":",NEJE 5 A40630 6.5W 激光雕刻机操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578499885047877,"ErpSPU":"I002943","SKURelations":[{"SrmSKU":"578502157729861","ErpSKU":"1294450"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/30 14:13:25 请求体:[{"SPUId":578503593635909,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600201,"Category4":60020101,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"NEJE 5 E30 7W 激光雕刻机","ProductShortName":"","ProductEName":"NEJE 5 E30","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"无线便携式激光切割机和雕刻机
","EHighlights":"Wireless portable laser cutting machine and engraving machine
","Specification":"\n\t\n\t\t\n\t\t\t\n\t\t\t\tGeneral \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tBrand: \nType: \nModel: \nColor: \n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tSpecification \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tWeight & Size \n\t\t\t | \n\t\t\t\n\t\t\t\tProduct Weight: \nPackage Weight: \nProduct Size(L x W x H): \nPackage Size(L x W x H): \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tPackage Contents \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\t1 x \n1 x User Manual\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"欧洲","LimitPriceType":2,"LimitPrice":229.0000,"LimitPriceCurrency":"0002","PurchasePrice":1150.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2405","PStocker":"2054","Supplier":"V5934","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":2.5000,"GrossWeight":2.8000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":44.0,"ProductW":26.0,"ProductH":17.0,"PackgeL":44.0,"PackgeW":26.0,"PackgeH":17.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":578504312057925,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"NEJE 5 E30 7W 激光雕刻机 欧规 NEJE00840","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":229.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":1150,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5934\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":2.5000,\"GrossWeight\":2.8000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":44,\"ProductW\":26,\"ProductH\":17,\"PackgeL\":44,\"PackgeW\":26,\"PackgeH\":17,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"E30\",\"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/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812496498757.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812526506053.jpg"}]},"SKUPictureInfos":[{"SrmSKU":578504312057925,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812496498757.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812526506053.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/30 14:13:25 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/30 14:13:25 GetSPUId获取到结果:SPUId:I002944,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/30 14:13:25 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812496498757.jpg,抓取SKU主图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 323
2025/6/30 14:13:25 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812526506053.jpg,抓取SKU描述图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 339
2025/6/30 14:13:25 响应体:{"Status":200,"Result":",NEJE 5 E30 7W 激光雕刻机操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578503593635909,"ErpSPU":"I002944","SKURelations":[{"SrmSKU":"578504312057925","ErpSKU":"1294451"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/30 14:14:06 请求体:[{"SPUId":578502697037893,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600201,"Category4":60020101,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"NEJE 5 E40 10W 激光雕刻机","ProductShortName":"","ProductEName":"NEJE 5 E40","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"无线便携式激光切割机和雕刻机
","EHighlights":"Wireless portable laser cutting machine and engraving machine
","Specification":"\n\t\n\t\t\n\t\t\t\n\t\t\t\tGeneral \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tBrand: \nType: \nModel: \nColor: \n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tSpecification \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tWeight & Size \n\t\t\t | \n\t\t\t\n\t\t\t\tProduct Weight: \nPackage Weight: \nProduct Size(L x W x H): \nPackage Size(L x W x H): \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tPackage Contents \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\t1 x \n1 x User Manual\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"欧洲","LimitPriceType":2,"LimitPrice":249.0000,"LimitPriceCurrency":"0002","PurchasePrice":1250.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2405","PStocker":"2054","Supplier":"V5934","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":2.5000,"GrossWeight":2.8000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":45.0,"ProductW":26.0,"ProductH":17.0,"PackgeL":45.0,"PackgeW":26.0,"PackgeH":17.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":578503305486405,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"NEJE 5 E40 10W 激光雕刻机 欧规 NEJE00799 ","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":1,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":249.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":1250,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5934\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":2.5000,\"GrossWeight\":2.8000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":45,\"ProductW\":26,\"ProductH\":17,\"PackgeL\":45,\"PackgeW\":26,\"PackgeH\":17,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"E40\",\"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/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812608839749.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812634042437.jpg"}]},"SKUPictureInfos":[{"SrmSKU":578503305486405,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812608839749.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812634042437.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/30 14:14:06 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/30 14:14:06 GetSPUId获取到结果:SPUId:I002945,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/30 14:14:07 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812608839749.jpg,抓取SKU主图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 323
2025/6/30 14:14:07 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812634042437.jpg,抓取SKU描述图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 339
2025/6/30 14:14:07 响应体:{"Status":200,"Result":",NEJE 5 E40 10W 激光雕刻机操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578502697037893,"ErpSPU":"I002945","SKURelations":[{"SrmSKU":"578503305486405","ErpSKU":"1294452"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/30 14:16:04 请求体:[{"SPUId":578500031135813,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600201,"Category4":60020101,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"NEJE 5 A40640 10W 激光雕刻机","ProductShortName":"","ProductEName":"NEJE 5 A40640 ","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"无线便携式激光切割机和雕刻机
","EHighlights":"
\n\n
\n
\n
\n
Wireless portable laser cutting machine and engraving machine
\n
\n
\n
","Specification":"\n\t\n\t\t\n\t\t\t\n\t\t\t\tGeneral \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tBrand: \nType: \nModel: \nColor: \n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tSpecification \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tWeight & Size \n\t\t\t | \n\t\t\t\n\t\t\t\tProduct Weight: \nPackage Weight: \nProduct Size(L x W x H): \nPackage Size(L x W x H): \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tPackage Contents \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\t1 x \n1 x User Manual\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"欧洲,美国","LimitPriceType":2,"LimitPrice":279.0000,"LimitPriceCurrency":"0002","PurchasePrice":1450.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,USDF","RStocker":"2405","PStocker":"2054","Supplier":"V5934","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":2.5000,"GrossWeight":2.8000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":45.0,"ProductW":36.0,"ProductH":17.0,"PackgeL":45.0,"PackgeW":36.0,"PackgeH":17.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":580797236301893,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3949","CName":"NEJE 5 A40640 10W激光雕刻机 欧规 NEJE00841","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\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":279.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":1450,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5934\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":2.5000,\"GrossWeight\":2.8000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":45,\"ProductW\":36,\"ProductH\":17,\"PackgeL\":45,\"PackgeW\":36,\"PackgeH\":17,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"A40640\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"},{"SrmSKU":580797236367429,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3951","CName":"NEJE 5 A40640 10W激光雕刻机 美规 NEJE00843","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\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":279.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":1450,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"USDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5934\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":2.5000,\"GrossWeight\":2.8000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":45,\"ProductW\":36,\"ProductH\":17,\"PackgeL\":45,\"PackgeW\":36,\"PackgeH\":17,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"A40640\",\"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/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812207370309.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812251459653.jpg"}]},"SKUPictureInfos":[{"SrmSKU":580797236301893,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812207370309.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812251459653.jpg","ImgSort":0}]},{"SrmSKU":580797236367429,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812207370309.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812251459653.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/30 14:16:04 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/30 14:16:04 GetSPUId获取到结果:SPUId:I002946,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/30 14:16:04 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812207370309.jpg,抓取SKU主图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 323
2025/6/30 14:16:04 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812251459653.jpg,抓取SKU描述图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 339
2025/6/30 14:16:04 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812207370309.jpg,抓取SKU主图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 323
2025/6/30 14:16:04 imgUrl:https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/NEJE5_A40640_TREE_jpg_1024x1024%402x_99999999999_579812251459653.jpg,抓取SKU描述图异常:System.ArgumentException: 参数无效。
在 System.Drawing.Image.FromStream(Stream stream, Boolean useEmbeddedColorManagement, Boolean validateImageData)
在 System.Drawing.Image.FromStream(Stream stream)
在 CalculateFreightAPI.Controllers.SRMController.UploadSPU(List`1 requests) 位置 E:\Jenkins\.jenkins\workspace\OMS_Master_WebSite\src\PDSys\WebService\CalculateFreightAPI\Controllers\SRMController.cs:行号 339
2025/6/30 14:16:04 响应体:{"Status":200,"Result":",NEJE 5 A40640 10W 激光雕刻机操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578500031135813,"ErpSPU":"I002946","SKURelations":[{"SrmSKU":"580797236301893","ErpSKU":"1294453"},{"SrmSKU":"580797236367429","ErpSKU":"1294454"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/30 15:12:23 请求体:[{"SPUId":579814030307397,"BaseInfo":{"Category1":60,"Category2":6001,"Category3":600102,"Category4":null,"TemplateId":38,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Phaetus Conweb 磨砂低温板适配拓竹 A1mini 3D打印机","ProductShortName":"","ProductEName":"Phaetus Conweb Cool Plate Compatibility with BambuLab A1mini","EAN":null,"BrandEName":"Phaetus","VideoLink":null,"IsPackage":false,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"\n- 室温打印,超强粘附力
\n- \n
无需加热,节能高效
\n \n- \n
720H连续打印,节省42度电
\n \n- 0秒取板,不止顺手,更懂你的操作逻辑
\n- 侧边手柄,单手取板
\n- 镂空设计,确保取模时手柄保持低温
\n- AR定位码防报错:精准识别打印区域,避免机器报错
\n- 一键弯曲脱模
\n- 双面磨砂,一板抵两板
\n- 专研厚密涂层
\n
\n
\n
\n
","EHighlights":"\n- \n
Room-Temperature Printing with Superior Adhesion
\n \n- \n
No Heating, Energy-Efficient Operation
\n \n- \n
720H non-stop operation | 42 kWh energy saving*
\n \n- \n
0-Second Plate Removal Smart-Adaptive Workflow
\n \n- Side-Mounted Handle One-handed Removal
\n- \n
AR Code for Error-Free Printing
\n \n- Precision AR positioning codes prevent machine errors
\n- \n
Effortless Flex-Release Technology
\n \n- \n
Dual-Sided Textured Finish, Two usable sides double productivity
\n \n- \n
Specialized in High-Density Coating | Extended Service Life
\n \n
","Specification":"\n\n\nGeneral | \n\n Brand: Phaetus Type: Conweb Cool Plate Model: Bambulab A1 mini \nColor: purple \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \n\n Product Weight: 0.2kg \nPackage Weight: 0.1kg \nProduct Size(L x W x H): 20x 22x 0.5cm \nPackage Size(L x W x H): 22x 24x 1cm \n | \n
\n\nPackage Contents | \n\n 1 x \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"江苏省苏州市吴中区木渎镇尧峰路创域智能产业园A栋锐力斯","LimitPriceType":2,"LimitPrice":12.5000,"LimitPriceCurrency":"0002","PurchasePrice":38.5,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"2405","PStocker":"2054","Supplier":"V5237","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":0.2000,"GrossWeight":0.2000,"BoxWeight":0.2000,"BoxQuantity":0,"ProductL":20.0,"ProductW":22.0,"ProductH":0.5,"PackgeL":25.0,"PackgeW":27.0,"PackgeH":1.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":579818568134725,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"Phaetus Conweb 磨砂低温板适配拓竹 A1mini 3D打印机 紫色双面磨砂低温板 R01.00.6577A00.00.00.00.00","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":20,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":\"6973090165567\",\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":12.5000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":38.5,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5237\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":\"6973090165567\",\"WLEmbargoType\":100,\"Weight\":0.2000,\"GrossWeight\":0.2000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":20,\"ProductW\":22,\"ProductH\":0.5,\"PackgeL\":25,\"PackgeW\":27,\"PackgeH\":1,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Phaetus Conweb™Cool Plate184*199mmBambulab\\u00A0A1\\u00A0mini\",\"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/1_99999999999_579823870836805.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_579823886667845.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/3_99999999999_579823900033093.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_579823912222789.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_579823926956101.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/6_99999999999_579823941234757.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_579823965208645.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_579823995367493.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/3_99999999999_579824020262981.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_579824047681605.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_579824074338373.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/6_99999999999_579824093392965.jpg"}]},"SKUPictureInfos":[{"SrmSKU":579818568134725,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_579823870836805.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_579823886667845.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/3_99999999999_579823900033093.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_579823912222789.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_579823926956101.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/6_99999999999_579823941234757.jpg","ImgSort":5}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/1_99999999999_579823965208645.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/2_99999999999_579823995367493.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/3_99999999999_579824020262981.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/4_99999999999_579824047681605.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/5_99999999999_579824074338373.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/6_99999999999_579824093392965.jpg","ImgSort":5}]}]},"UserId":"2054"}]
2025/6/30 15:12:23 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/30 15:12:23 GetSPUId获取到结果:SPUId:I002947,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/30 15:12:25 响应体:{"Status":200,"Result":",Phaetus Conweb 磨砂低温板适配拓竹 A1mini 3D打印机操作成功","SuccessSPUSKUResponse":[{"SrmSPU":579814030307397,"ErpSPU":"I002947","SKURelations":[{"SrmSKU":"579818568134725","ErpSKU":"1294458"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/30 15:21:10 请求体:[{"SPUId":578751037059141,"BaseInfo":{"Category1":10,"Category2":1003,"Category3":100301,"Category4":null,"TemplateId":6,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"欧规 ULTIMEA Skywave F30 3.1.2声霸","ProductShortName":"","ProductEName":"ULTIMEA Skywave F30 3.1.2 Soundbar","EAN":null,"BrandEName":"Ultimea","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"3.1.2 声道环绕声系统: 该系统基于 3.1.2 声道架构,将前置驱动器、上置扬声器和 5.25 英寸重低音扬声器结合在一起,营造出多维音效,无需后置扬声器。感受天籁之音 - 从头顶轰隆隆的雷声到垂直落下的雨滴,体验的不仅仅是环绕在您周围的声音,而是将您包围的声音。
带钕磁芯的上发声驱动器: 上发声声道使用钕内磁铁和 18 芯大型音圈,以提高高度精度和垂直投射。这种航天级配置可确保更好的高频动态,提供集中、高亢的声音图像,释放杜比全景声的真正潜力。
BassMX 技术: 超重低音扬声器采用更大的 23 毫米音圈、16 毫米偏移量和 5.1 升扩充木质箱体,可提供更强劲、更嘹亮的低频。低频响应可扩展至 40Hz,为动作场面、爆炸和音乐节拍增添了更深沉的冲击力和更好的控制力。与传统的紧凑型低音炮相比,更大的声腔能产生更宽广的声场和更强的物理冲击力。
VoiceMX 清晰对话: VoiceMX 技术和 DSP 处理可实现清晰的对话: VoiceMX 可增强任何场景中的人声清晰度。实时 DSP 处理音频可在所有音量下实现更好的声道分离、最小的失真和一致的细节。
\n3.1.2 声道环绕声系统: 该系统基于 3.1.2 声道架构,将前置驱动器、上置扬声器和 5.25 英寸重低音扬声器结合在一起,营造出多维音效,无需后置扬声器。感受天籁之音 - 从头顶轰隆隆的雷声到垂直落下的雨滴,体验的不仅仅是环绕在您周围的声音,而是将您包围的声音。
带钕磁芯的上发声驱动器: 上发声声道使用钕内磁铁和 18 芯大型音圈,以提高高度精度和垂直投射。这种航天级配置可确保更好的高频动态,提供集中、高亢的声音图像,释放杜比全景声的真正潜力。
BassMX 技术: 超重低音扬声器采用更大的 23 毫米音圈、16 毫米偏移量和 5.1 升扩充木质箱体,可提供更强劲、更嘹亮的低频。低频响应可扩展至 40Hz,为动作场面、爆炸和音乐节拍增添了更深沉的冲击力和更好的控制力。与传统的紧凑型低音炮相比,更大的声腔能产生更宽广的声场和更强的物理冲击力。
VoiceMX 清晰对话: VoiceMX 技术和 DSP 处理可实现清晰的对话: VoiceMX 可增强任何场景中的人声清晰度。实时 DSP 处理音频可在所有音量下实现更好的声道分离、最小的失真和一致的细节。
无损音频传输和 CEC 功能: HDMI eARC 支持高达 37Mbps 带宽的无损 3.1.2 声道音频,可释放完整的杜比全景声性能。与普通 ARC 相比,eARC 无需压缩即可提供更丰富的细节和更好的环绕声效果。有了 CEC,电视和 Soundbar 将作为一个整体工作,自动实现功率、音量和输入同步,让控制更加轻松自如。
先进的应用程序控制: 使用 Ultimea 应用程序定制您的音频体验,它具有 10 段图形均衡器和 121 种预设声音设置。享受无缝 OTA 更新,解锁新功能,保持设备的最佳性能。
无线连接: 蓝牙 5.4 提供比蓝牙 5.3 更稳定、更灵敏的连接,设备同步速度更快,抗无线干扰能力更强。享受更流畅的音频流和低延迟性能--最适合电影、音乐和游戏。
","EHighlights":"\n- 3.1.2ch Surround Sound System: Built on 3.1.2-channel architecture, the system combines front-firing drivers, up-firing speakers, and a 5.25\" subwoofer to create multidimensional sound - no rear speakers needed. Feel the Sky Come Alive - Experience sound that doesn't just surround you, but envelops you - from the thunder rumbling overhead to rain falling vertically through your space.
\n- Up-Firing Drivers with Neodymium Core: The up-firing channels use neodymium internal magnets and 18-core large voice coils to enhance height precision and vertical throw. This aerospace-grade configuration ensures better high-frequency dynamics, delivering focused and elevated sound images that unlock the true potential of Dolby Atmos.
\n- BassMX Technology: The subwoofer features a larger 23mm voice coil, 16mm excursion, and an expanded 5.1L wooden cabinet—delivering more powerful and resonant low frequencies. With extended bass response down to 40Hz, it adds deeper punch and better control to action scenes, explosions, and music beats. This larger acoustic chamber produces a broader soundstage and stronger physical impact than traditional compact subwoofers.
\n- Clear Dialogue with VoiceMX: VoiceMX Technology and DSP Processing for Clear Dialogue: VoiceMX enhances vocal clarity in any scene. Real-time DSP processes audio for better channel separation, minimal distortion, and consistent detail at all volumes.
\n- Lossless Audio Transmission and CEC Function: Unlock full Dolby Atmos performance with HDMI eARC, supporting up to 37Mbps bandwidth for lossless 3.1.2-channel audio. Compared to regular ARC, eARC delivers richer detail and better surround effects with no compression. With CEC, your TV and soundbar work as one—power, volume, and input sync automatically for effortless control.
\n- Advanced App Control: Customize your audio experience with the Ultimea app, featuring a 10-band graphic EQ and 121 preset sound settings. Enjoy seamless OTA updates that unlock new features and keep your device performing at its best.
\n- Wireless Connection: Bluetooth 5.4 offers a more stable and responsive connection than Bluetooth 5.3, with faster device syncing and stronger resistance to wireless interference. Enjoy smoother audio streaming and low-latency performance—perfect for movies, music, and gaming.
\n
","Specification":"\n\n\nGeneral | \n\n Brand: ULTIMEA Type: 3.1.2ch Soundbar Model: U392A Color: Black \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: 6 KG Package Weight: 6.5 KG Product Size(L x W x H): 80 x 9 x 4.6 cm Package Size(L x W x H): 44.8 x 33.5 x 19.5 cm | \n
\n\nPackage Contents | \n\n 1 x Soundbar \n1 x Subwoofer \n1 x Power Adaptor \n1 x Sub Power Adaptor \n1 x HDMI Cable \n1 x Digtail Opt Cable \n1 x Remote Conctol \n6 x Wall Bracker \n6 x Mounting Screw \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":208.6800,"LimitPriceCurrency":"0002","PurchasePrice":160.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":1,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":1,"AfterSaleMethodNote":null,"CertificateIds":"CE","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2406","PStocker":"2364","Supplier":"V6088","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"1 x Soundbar\n1 x Subwoofer\n1 x Power Adaptor\n1 x Sub Power Adaptor\n1 x HDMI Cable\n1 x Digtail Opt Cable\n1 x Remote Conctol\n6 x Wall Bracker\n6 x Mounting Screw","WLEmbargoType":100,"Weight":6.0000,"GrossWeight":6.5000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":80.0,"ProductW":4.6,"ProductH":9.0,"PackgeL":44.8,"PackgeW":33.5,"PackgeH":19.5,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":578751615746117,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3938","CName":"ULTIMEA Skywave F30 3.1.2声霸 黑","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\":208.6800,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":160,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":1,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":1,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2406\",\"PStocker\":\"2364\",\"Supplier\":\"V6088\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1 x Soundbar\\n1 x Subwoofer\\n1 x Power Adaptor\\n1 x Sub Power Adaptor\\n1 x HDMI Cable\\n1 x Digtail Opt Cable\\n1 x Remote Conctol\\n6 x Wall Bracker\\n6 x Mounting Screw\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":6.0000,\"GrossWeight\":6.5000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":80,\"ProductW\":4.6,\"ProductH\":9,\"PackgeL\":44.8,\"PackgeW\":33.5,\"PackgeH\":19.5,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"U392A\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+283_99999999999_578752476618821.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+284_99999999999_578752493424709.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+286_99999999999_578752507797573.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN67%e5%a5%97%e5%9b%be1500_1500_99999999999_578752535285829.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN66%e5%a5%97%e5%9b%be1500_1500_99999999999_578752565854277.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN55%e5%a5%97%e5%9b%be1500_1500_99999999999_578752591679557.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN56%e5%a5%97%e5%9b%be1500_1500_99999999999_578752610275397.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN57%e5%a5%97%e5%9b%be1500_1500_99999999999_578752626212933.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN58%e5%a5%97%e5%9b%be1500_1500_99999999999_578752640278597.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN60%e5%a5%97%e5%9b%be1500_1500_99999999999_578752660320325.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN59%e5%a5%97%e5%9b%be1500_1500_99999999999_578752676962373.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN62%e5%a5%97%e5%9b%be1500_1500_99999999999_578752696242245.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN63%e5%a5%97%e5%9b%be1500_1500_99999999999_578752714551365.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN69%e5%a5%97%e5%9b%be1500_1500_99999999999_578752731930693.jpg"}]},"SKUPictureInfos":[{"SrmSKU":578751615746117,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+283_99999999999_578752476618821.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+284_99999999999_578752493424709.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/Frame+286_99999999999_578752507797573.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN67%e5%a5%97%e5%9b%be1500_1500_99999999999_578752535285829.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN66%e5%a5%97%e5%9b%be1500_1500_99999999999_578752565854277.jpg","ImgSort":4}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN55%e5%a5%97%e5%9b%be1500_1500_99999999999_578752591679557.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN56%e5%a5%97%e5%9b%be1500_1500_99999999999_578752610275397.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN57%e5%a5%97%e5%9b%be1500_1500_99999999999_578752626212933.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN58%e5%a5%97%e5%9b%be1500_1500_99999999999_578752640278597.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN60%e5%a5%97%e5%9b%be1500_1500_99999999999_578752660320325.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN59%e5%a5%97%e5%9b%be1500_1500_99999999999_578752676962373.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN62%e5%a5%97%e5%9b%be1500_1500_99999999999_578752696242245.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN63%e5%a5%97%e5%9b%be1500_1500_99999999999_578752714551365.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/EN69%e5%a5%97%e5%9b%be1500_1500_99999999999_578752731930693.jpg","ImgSort":8}]}]},"UserId":"2406"}]
2025/6/30 15:21:10 GetSPUId方法内部,CategoryCode:10,sql:
2025/6/30 15:21:10 GetSPUId获取到结果:SPUId:E002326,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/30 15:21:14 响应体:{"Status":200,"Result":",欧规 ULTIMEA Skywave F30 3.1.2声霸操作成功","SuccessSPUSKUResponse":[{"SrmSPU":578751037059141,"ErpSPU":"E002326","SKURelations":[{"SrmSKU":"578751615746117","ErpSKU":"1294462"}],"Msg":null}],"FailSPUSKUResponse":[]}