2025/5/6 9:27:51 请求体：[{"SPUId":560709237424197,"BaseInfo":{"Category1":30,"Category2":3005,"Category3":300503,"Category4":null,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"CATERSIDE K39769 新款复古男士太阳镜欧美潮流朋克风插针脚太阳镜旅游驾驶沙滩太阳镜","ProductShortName":"","ProductEName":"CATERSIDE K39769 New Square Retro Sunglasses Men European And American Trendy Punk Style Core Insert LegSun Glasses Women Travel Driving Beach Eyewear UV400","EAN":null,"BrandEName":"CATERSIDE","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"https://csp.aliexpress.com/m_apps/productManage/list-manage?channelId=68690","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"

插针脚镜腿

\n

 

","EHighlights":"

Core insert leg Mirror leg

\n

 

","Specification":"\n\n\n\n\n\n\n\n\n\n\n
General\n

Brand: CATERSIDE
Type: Fashionable Sunglasses
Model: K39769

\n
Weight & SizeLogistics Weight: 0.08kg/pc

Logistics  Size(L x W x H):17 x 8 x 6 (cm) 
\n

 

","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":" 广东省 广州市 番禺区 广东省 石碁镇 广州市番禺区石碁镇永善村永峰路4号大院之二C栋3楼301单元","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":135.09,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":12,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":6,"AfterSaleMethodNote":null,"CertificateIds":"CE","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"CNDF,ZFCNDF","RStocker":"2518","PStocker":"2054","Supplier":"V6261","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"With label cloth + bag +Cathersized brand paper box","WLEmbargoType":100,"Weight":0.0400,"GrossWeight":0.1100,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":14.4,"ProductW":3.0,"ProductH":4.5,"PackgeL":17.0,"PackgeW":8.0,"PackgeH":6.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":561030066466885,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3948","CName":" CATERSIDE K39769 新款复古男士太阳镜欧美潮流朋克风插针脚太阳镜旅游驾驶沙滩太阳镜 草绿框兰片 C02","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":2,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":135.09,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":12,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":6,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"CNDF,ZFCNDF\",\"RStocker\":\"2518\",\"PStocker\":\"2054\",\"Supplier\":\"V6261\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"With label cloth + bag +Cathersized brand paper box\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0400,\"GrossWeight\":0.1100,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":14.4,\"ProductW\":3,\"ProductH\":4.5,\"PackgeL\":17,\"PackgeW\":8,\"PackgeH\":6,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"K39769\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":561030066516037,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3949","CName":"CATERSIDE K39769 新款复古男士太阳镜欧美潮流朋克风插针脚太阳镜旅游驾驶沙滩太阳镜 草绿渐茶片 C07","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":2,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":135.09,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":12,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":6,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"CNDF,ZFCNDF\",\"RStocker\":\"2518\",\"PStocker\":\"2054\",\"Supplier\":\"V6261\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"With label cloth + bag +Cathersized brand paper box\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0400,\"GrossWeight\":0.1100,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":14.4,\"ProductW\":3,\"ProductH\":4.5,\"PackgeL\":17,\"PackgeW\":8,\"PackgeH\":6,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"K39769\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":561030066548805,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3950","CName":"CATERSIDE K39769 新款复古男士太阳镜欧美潮流朋克风插针脚太阳镜旅游驾驶沙滩太阳镜 黑框灰片 C01 ","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":2,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":135.09,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":12,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":6,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"CNDF,ZFCNDF\",\"RStocker\":\"2518\",\"PStocker\":\"2054\",\"Supplier\":\"V6261\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"With label cloth + bag +Cathersized brand paper box\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0400,\"GrossWeight\":0.1100,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":14.4,\"ProductW\":3,\"ProductH\":4.5,\"PackgeL\":17,\"PackgeW\":8,\"PackgeH\":6,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"K39769\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":561030066585669,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3951","CName":"CATERSIDE K39769 新款复古男士太阳镜欧美潮流朋克风插针脚太阳镜旅游驾驶沙滩太阳镜 姜黄渐绿片 C08 ","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":2,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":135.09,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":12,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":6,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"CNDF,ZFCNDF\",\"RStocker\":\"2518\",\"PStocker\":\"2054\",\"Supplier\":\"V6261\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"With label cloth + bag +Cathersized brand paper box\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0400,\"GrossWeight\":0.1100,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":14.4,\"ProductW\":3,\"ProductH\":4.5,\"PackgeL\":17,\"PackgeW\":8,\"PackgeH\":6,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"K39769\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/002_99999999999_560719595880517.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/07_99999999999_561032749289541.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/01_99999999999_561032808943685.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/08_99999999999_561032830709829.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e7%bb%86%e8%8a%82_99999999999_560720479428677.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e5%b0%ba%e5%af%b8_99999999999_561033326858309.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/11_99999999999_561038409490501.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_561038622535749.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_561038622285893.jpg"}]},"SKUPictureInfos":[{"SrmSKU":561030066466885,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/002_99999999999_560719595880517.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/07_99999999999_561032749289541.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/01_99999999999_561032808943685.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/08_99999999999_561032830709829.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e7%bb%86%e8%8a%82_99999999999_560720479428677.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e5%b0%ba%e5%af%b8_99999999999_561033326858309.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_99999999999_561034129231941.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_561034129236037.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_561034129424453.jpg","ImgSort":4}]},{"SrmSKU":561030066516037,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/002_99999999999_560719595880517.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/07_99999999999_561032749289541.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/01_99999999999_561032808943685.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/08_99999999999_561032830709829.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e7%bb%86%e8%8a%82_99999999999_560720479428677.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e5%b0%ba%e5%af%b8_99999999999_561033326858309.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_561034428276805.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_561034458431557.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_99999999999_561034507804741.jpg","ImgSort":4}]},{"SrmSKU":561030066548805,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/002_99999999999_560719595880517.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/07_99999999999_561032749289541.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/01_99999999999_561032808943685.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/08_99999999999_561032830709829.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e7%bb%86%e8%8a%82_99999999999_560720479428677.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e5%b0%ba%e5%af%b8_99999999999_561033326858309.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_561034428276805.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_561034458431557.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_99999999999_561034507804741.jpg","ImgSort":4}]},{"SrmSKU":561030066585669,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/002_99999999999_560719595880517.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/07_99999999999_561032749289541.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/01_99999999999_561032808943685.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/08_99999999999_561032830709829.jpg","ImgSort":3}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e7%bb%86%e8%8a%82_99999999999_560720479428677.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e5%b0%ba%e5%af%b8_99999999999_561033326858309.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_561034428276805.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_561034458431557.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_99999999999_561034507804741.jpg","ImgSort":4}]}]},"UserId":"2054"}] 2025/5/6 9:27:51 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 9:27:51 GetSPUId获取到结果：SPUId:S008357,CategoryCode:30,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/5/6 9:28:06 响应体：{"Status":200,"Result":",CATERSIDE K39769 新款复古男士太阳镜欧美潮流朋克风插针脚太阳镜旅游驾驶沙滩太阳镜操作成功","SuccessSPUSKUResponse":[{"SrmSPU":560709237424197,"ErpSPU":"S008357","SKURelations":[{"SrmSKU":"561030066466885","ErpSKU":"1291523"},{"SrmSKU":"561030066516037","ErpSKU":"1291524"},{"SrmSKU":"561030066548805","ErpSKU":"1291525"},{"SrmSKU":"561030066585669","ErpSKU":"1291526"}],"Msg":null}],"FailSPUSKUResponse":[]} 2025/5/6 17:39:20 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:20 GetSPUId获取到结果：SPUId:S008361,CategoryCode:30,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/5/6 17:39:21 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:22 GetSPUId获取到结果：SPUId:S008362,CategoryCode:30,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/5/6 17:39:22 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:22 GetSPUId获取到结果：SPUId:S008363,CategoryCode:30,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/5/6 17:39:24 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:24 GetSPUId获取到结果：SPUId:S008364,CategoryCode:30,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/5/6 17:39:25 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:25 GetSPUId获取到结果：SPUId:S008365,CategoryCode:30,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/5/6 17:39:26 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:26 GetSPUId获取到结果：SPUId:S008366,CategoryCode:30,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/5/6 17:39:27 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:27 GetSPUId获取到结果：SPUId:S008367,CategoryCode:30,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/5/6 17:39:27 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:27 GetSPUId获取到结果：SPUId:S008368,CategoryCode:30,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/5/6 17:39:28 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:28 GetSPUId获取到结果：SPUId:S008369,CategoryCode:30,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/5/6 17:39:29 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:29 GetSPUId获取到结果：SPUId:S008370,CategoryCode:30,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/5/6 17:39:30 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:30 GetSPUId获取到结果：SPUId:S008371,CategoryCode:30,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/5/6 17:39:31 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:31 GetSPUId获取到结果：SPUId:S008372,CategoryCode:30,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/5/6 17:39:33 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:33 GetSPUId获取到结果：SPUId:S008373,CategoryCode:30,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/5/6 17:39:34 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:34 GetSPUId获取到结果：SPUId:S008374,CategoryCode:30,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/5/6 17:39:35 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:35 GetSPUId获取到结果：SPUId:S008375,CategoryCode:30,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/5/6 17:39:35 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:35 GetSPUId获取到结果：SPUId:S008376,CategoryCode:30,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/5/6 17:39:38 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:38 GetSPUId获取到结果：SPUId:S008377,CategoryCode:30,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/5/6 17:39:38 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:38 GetSPUId获取到结果：SPUId:S008378,CategoryCode:30,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/5/6 17:39:39 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:39 GetSPUId获取到结果：SPUId:S008379,CategoryCode:30,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/5/6 17:39:40 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:40 GetSPUId获取到结果：SPUId:S008380,CategoryCode:30,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/5/6 17:39:41 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:41 GetSPUId获取到结果：SPUId:S008381,CategoryCode:30,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/5/6 17:39:42 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:42 GetSPUId获取到结果：SPUId:S008382,CategoryCode:30,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/5/6 17:39:43 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:43 GetSPUId获取到结果：SPUId:S008383,CategoryCode:30,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/5/6 17:39:44 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:44 GetSPUId获取到结果：SPUId:S008384,CategoryCode:30,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/5/6 17:39:45 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:45 GetSPUId获取到结果：SPUId:S008385,CategoryCode:30,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/5/6 17:39:46 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:46 GetSPUId获取到结果：SPUId:S008386,CategoryCode:30,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/5/6 17:39:47 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:47 GetSPUId获取到结果：SPUId:S008387,CategoryCode:30,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/5/6 17:39:48 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:48 GetSPUId获取到结果：SPUId:S008388,CategoryCode:30,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/5/6 17:39:50 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:50 GetSPUId获取到结果：SPUId:S008389,CategoryCode:30,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/5/6 17:39:51 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:51 GetSPUId获取到结果：SPUId:S008390,CategoryCode:30,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/5/6 17:39:52 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:52 GetSPUId获取到结果：SPUId:S008391,CategoryCode:30,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/5/6 17:39:53 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:53 GetSPUId获取到结果：SPUId:S008392,CategoryCode:30,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/5/6 17:39:54 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:54 GetSPUId获取到结果：SPUId:S008393,CategoryCode:30,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/5/6 17:39:55 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:55 GetSPUId获取到结果：SPUId:S008394,CategoryCode:30,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/5/6 17:39:55 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:55 GetSPUId获取到结果：SPUId:S008395,CategoryCode:30,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/5/6 17:39:57 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:57 GetSPUId获取到结果：SPUId:S008396,CategoryCode:30,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/5/6 17:39:58 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:58 GetSPUId获取到结果：SPUId:S008397,CategoryCode:30,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/5/6 17:39:59 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:39:59 GetSPUId获取到结果：SPUId:S008398,CategoryCode:30,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/5/6 17:40:00 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:00 GetSPUId获取到结果：SPUId:S008399,CategoryCode:30,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/5/6 17:40:02 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:02 GetSPUId获取到结果：SPUId:S008400,CategoryCode:30,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/5/6 17:40:04 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:04 GetSPUId获取到结果：SPUId:S008401,CategoryCode:30,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/5/6 17:40:05 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:05 GetSPUId获取到结果：SPUId:S008402,CategoryCode:30,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/5/6 17:40:06 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:06 GetSPUId获取到结果：SPUId:S008403,CategoryCode:30,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/5/6 17:40:06 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:06 GetSPUId获取到结果：SPUId:S008404,CategoryCode:30,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/5/6 17:40:07 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:07 GetSPUId获取到结果：SPUId:S008405,CategoryCode:30,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/5/6 17:40:08 订单：KUKIRIN10734 请求报文：{"tdCODetailList":[{"BrandId":1471,"HSCode":null,"Img":null,"PTGAssociatedValue":null,"RowPrice":0.0,"SettlementPrice":0.0,"COSubID":"44677a11-9b6f-4b58-823a-976dd71f9f01","COID":"F20250410613","ProductCode":"1167969","ProductName":"海外仓代发 新款 Kukirin C1 PRO 500W 48V 26Ah 电动滑板车","Unit":"件","COQuantity":1,"Color":"","UnitPrice":584.0000,"Amount":0.0,"TotalPrice":2900.0000,"Remark":".","COSTATE":"False","Id":0,"PProperty":null,"ActualPrice":2900.0000,"OrderWeight":0.0,"IsGift":0,"delayRemark":null,"celltype":null,"dygl":null,"ItemId":null,"MangoFlag":"47","IndividualFreight":0.0,"PreferentialAmount":0.0,"DepartureNO":"EUDF","DepartureName":null,"Weight":36.2500,"IsNewProduct":false,"MainSku":null,"ProductState":null,"ProductStateText":null,"Inventory":0,"weijin":null,"ptg":null,"count":0,"Declare_CName":null,"Declare_EName":null,"IsShowChangeProduct":0,"IsVirtual":0,"CategoryId":0,"AverageFreight":0.0000,"AverageUnitPrice":584.0000,"AverageAmountWithCount":584.0000,"ShippingQuantity":0,"ShippedQuantity":1,"OriginalQuantity":1,"MiddleNumber":0,"MiddleNumberForPack":0,"SalePrice":0.0000,"StandardId":null,"ProductTypeID":null,"SellerSKU":"11308801097934","ReturnMoney":null}],"userID":"2649","tdCOMain":{"WarehouseID":null,"IsRelatedAdditional":false,"MainOrderId":null,"IsSubOrder":false,"FulfillmentChannel":null,"InputUser":null,"Tag":null,"PackageInfos":null,"ShipDate":"0001-01-01T00:00:00","Inprogress":null,"PackageIDs":null,"myPONO":null,"COID":"F20250410613","PONo":"KUKIRIN10734","Oaid":null,"OrderDate":"0001-01-01T00:00:00","ExpectDate":"0001-01-01T00:00:00","Freight":0.0000,"TotalPrice":584.0000,"CurrencyCode":"0004","InputUserID":"2289","Creator":null,"StoreManager":null,"InputTime":"2025-04-10T05:35:35","PARecordID":958,"PlatformAccountName":null,"OrderRemark":null,"COLevel":null,"COState":"Shiped","COStateName":null,"SpecialFlag":null,"PrintFlag":null,"DissensionFlag":null,"CompleteFlag":null,"FormerlyOrder":null,"COType":null,"HaveMend":null,"CustomerID":null,"CCountry":"40","CProvince":"Le mans","CCity":"Le mans","CAddressLineOne":"59 rue des bigarreaux","CAddressLineTwo":"","AddressLine":null,"CPostalCode":"72100","Feedback":"1","Priority":"1","CContact":"Ramine Saidi","Ctel":"0603193789","CFax":null,"ShipVia":null,"Spec":null,"TransactionNumber":null,"MangoFlag":null,"MangoNumber":null,"FreightForwardingNo":null,"StateTime":"0001-01-01T00:00:00","Stock":0,"Itemtype":"Shopify","TotalCost":2900.0000,"ShipCost":1.0000,"TotalWeight":36.2500,"WmsState":null,"Name":"Free Shipping (Over €39.99)","FreightSide":null,"OrderType":"0","OrderTypeName":null,"RAccount":"Ramine Saidi","RPayMethod":null,"ProductBrandStr":null,"CusEmail":"ramine.saidii@gmail.com","BuyerID":null,"CanAutoDownLoad":false,"NewCoustomerId":null,"CurrentRate":0.92105264,"TypeId":0,"TransactionID":null,"OrderSourceType":1,"OrderSourceTypeLabel":null,"LastModifier":null,"CurrencyShorts":"EUR","CNYExchangeRate":7.60000000,"DropShopping":false,"OrderConfirmMode":0,"LocalTime":"2025-04-10T05:35:35","AllotType":0,"VATNO":"","HouseNumber":"","IsVirtual":0,"ShippingWHType":null,"AbnormalFlag":null,"OnLine":0,"OnLineName":null,"ContractNo":null,"GoodsTotalSalesAmount":584.0000,"RelationPoNo":"4497426677966","PlatformChargeRate":0.0650,"CompanyOperatingRates":0.0,"AdjustThePriceOfGoods":0.0000,"AdjustTheShippingFee":0.0000,"HoldOn":0,"HoldOnName":null,"SalesType":0,"CreatedDate":"2025-04-10T05:59:32.25","ApprovalStatus":0,"ApprovalFlag":0,"GrossProfit":0.0,"GrossInterestRate":0.0,"ShippingRemark":null,"WarehouseAddressID":null,"PlatformId":null,"PARecordAccount":null,"PARecordName":null,"InOrUpFlag":0,"ncw":0,"CountDProduct":0,"CNCountry":null,"TotalAllPrice":0.0,"AllNumber":0,"Content":null,"PackageId":null,"payment":null,"isdelay":null,"AutoDownLoadReson":null,"Onsaleflag":null,"CurrencyCNDesc":null,"LastModifyDate":"0001-01-01T00:00:00","Reason_Type":null,"WISHDeliveryConfirmation":null,"affiliatedSource":null,"SalesTypeName":null,"CheckIsPackShipped":null,"HoldonReason":null,"ApprovalStatusName":null,"ReUploadedPackId":null,"CauseOfAuditFailure":null,"ApprovalLevel":null,"PlatformOrderDetails":[{"Id":2528041,"PONo":"KUKIRIN10734","COID":"F20250410613","PlatformName":null,"AccountId":0,"AccountName":null,"ProductId":"1167969","SellerSKU":"11308801097934","SellerSKUName":"KuKirin C1 Pro Electric Scooter (2024 Version)","SellerSKUCount":1,"UnitPrice":0.0,"ErpProductId":null,"ProductCount":0,"DepartureNO":null,"CreateUser":"2289","CreateTime":"2025/4/10 5:59:32","VersionNumber":0,"ChildOrderId":null,"ChildOrderListId":null,"AlreadyTaxed":null,"OrderSortId":0,"AEPlusInfo":null,"ShipmentId":null,"Oaid":null}],"RemoteFee":0.0,"TaxOnAPI":0,"TotalAmountOfTax":0.0,"IsApplyInvoice":0,"IsDateCanBeInvoiced":false,"IsAfterSale":false}} 2025/5/6 17:40:08 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:08 GetSPUId获取到结果：SPUId:S008406,CategoryCode:30,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/5/6 17:40:10 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:10 GetSPUId获取到结果：SPUId:S008407,CategoryCode:30,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/5/6 17:40:10 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:10 GetSPUId获取到结果：SPUId:S008408,CategoryCode:30,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/5/6 17:40:12 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:12 GetSPUId获取到结果：SPUId:S008409,CategoryCode:30,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/5/6 17:40:13 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:13 GetSPUId获取到结果：SPUId:S008410,CategoryCode:30,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/5/6 17:40:16 FetchErpUsers request：https://jkby.acelinkco.com/WebAPI/GetTenantUser?tenantCode=JKBY 2025/5/6 17:40:16 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:16 GetSPUId获取到结果：SPUId:S008411,CategoryCode:30,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/5/6 17:40:18 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:18 GetSPUId获取到结果：SPUId:S008412,CategoryCode:30,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/5/6 17:40:20 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:20 GetSPUId获取到结果：SPUId:S008413,CategoryCode:30,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/5/6 17:40:21 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:21 GetSPUId获取到结果：SPUId:S008414,CategoryCode:30,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/5/6 17:40:21 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:21 GetSPUId获取到结果：SPUId:S008415,CategoryCode:30,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/5/6 17:40:22 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:23 GetSPUId获取到结果：SPUId:S008416,CategoryCode:30,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/5/6 17:40:23 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:23 GetSPUId获取到结果：SPUId:S008417,CategoryCode:30,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/5/6 17:40:24 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:24 GetSPUId获取到结果：SPUId:S008418,CategoryCode:30,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/5/6 17:40:24 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:25 GetSPUId获取到结果：SPUId:S008419,CategoryCode:30,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/5/6 17:40:26 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:26 GetSPUId获取到结果：SPUId:S008420,CategoryCode:30,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/5/6 17:40:29 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/6 17:40:29 GetSPUId获取到结果：SPUId:S008421,CategoryCode:30,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