2025/5/9 9:39:23 请求体:[{"SPUId":562131543875653,"BaseInfo":{"Category1":40,"Category2":4004,"Category3":400401,"Category4":40040112,"TemplateId":46,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"泰坦军团 P2712V Flat 16:9 Fast IPS UHD 160Hz 双模 FHD 320H 电竞显示器","ProductShortName":"","ProductEName":"TITAN ARMY P2712V Flat 16:9 Fast IPS UHD 160Hz Dual mode FHD 320H Gaming monitors","EAN":null,"BrandEName":"TITAN ARMY","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
产品外观:黑色
产品规格:Flat 16:9 Fast IPS UHD 160Hz 双模 FHD 320H
响应时间:GTG 1ms
色域:高色域滤蓝光
支架底座:升降支架底座
HDR:HDR400
灯效:七彩跑马氛围灯
","EHighlights":"Product appearance: Black
\nProduct Specifications :Flat 16:9 Fast IPS UHD 160Hz Dual-mode FHD 320H
\nResponse time :GTG 1ms
\nColor gamut: High color gamut for blue light filtering
\nBracket base: Lifting bracket base
\nHDR:HDR400
\nLighting effect: Seven-color horse racing atmosphere lights
","Specification":"\n\n\nGeneral | \n\n Brand: TITAN ARMY Type: Gaming monitors Model: P2712V Color: black \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: 4.36kg Package Weight: 5.61kg Product Size(L x W x H): 614.3*510.8*195.5mm Package Size(L x W x H): 861x170x460mm | \n
\n\nPackage Contents | \n\n 1*User Manual 1*DP Cable 1* Power Cable 1*Power adapter \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"南宁市连畴路67号中关村电子信息产业园3#标准厂房","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":1420.0,"PurchasePriceCurrency":"0001","MinOrder":500,"DeliveryTime":50,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"ZFSZDG,SUJK,SZDG","RStocker":"2228","PStocker":"2219","Supplier":"V5761","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.1300,"TaxAmount":163.36},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":101,"Weight":4.3600,"GrossWeight":5.6100,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":61.4,"ProductW":19.5,"ProductH":51.0,"PackgeL":86.1,"PackgeW":17.0,"PackgeH":46.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":562132531699781,"Color":"屏幕尺寸","ColorCode":"1002","ColorValueCode":"4849","CName":"泰坦军团 P2712V Flat 16:9 Fast IPS UHD 160Hz 双模 FHD 320H 电竞显示器 欧规","Size":"最大分辨率","SizeCode":"1004","SizeValueCode":"4609","Option":"刷新率","OptionCode":"1398","OptionValueCode":"4872","SampleCount":1,"SupplyInfo":"{\"TaxRate\":0.1300,\"TaxAmount\":163.36,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":1420,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":500,\"DeliveryTime\":50,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"ZFSZDG,SUJK,SZDG\",\"RStocker\":\"2228\",\"PStocker\":\"2219\",\"Supplier\":\"V5761\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":101,\"Weight\":4.3600,\"GrossWeight\":5.6100,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":61.4,\"ProductW\":19.5,\"ProductH\":51,\"PackgeL\":86.1,\"PackgeW\":17,\"PackgeH\":46,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"P2712V\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2712_99999999999_562133239853125.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2712_99999999999_562133344301125.jpg"}]},"SKUPictureInfos":[{"SrmSKU":562132531699781,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2712_99999999999_562133239853125.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2712_99999999999_562133344301125.jpg","ImgSort":0}]}]},"UserId":"2219"}]
2025/5/9 9:39:23 GetSPUId方法内部,CategoryCode:40,sql:
2025/5/9 9:39:23 GetSPUId获取到结果:SPUId:N002436,CategoryCode:40,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql:
declare @CategoryShortCode varchar(5),
@Max varchar(6),
@NewMax varchar(6)
select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode
select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%'
select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6)
select (@CategoryShortCode + @NewMax) SPUId
2025/5/9 9:39:27 响应体:{"Status":200,"Result":",泰坦军团 P2712V Flat 16:9 Fast IPS UHD 160Hz 双模 FHD 320H 电竞显示器操作成功","SuccessSPUSKUResponse":[{"SrmSPU":562131543875653,"ErpSPU":"N002436","SKURelations":[{"SrmSKU":"562132531699781","ErpSKU":"1291682"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/5/9 10:03:15 请求体:[{"SPUId":562124286111813,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600201,"Category4":60020101,"TemplateId":29,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"TWO TREES TTS-20 Pro 20W激光雕刻机刻字机小型全自动树叶木材切割打标机","ProductShortName":"","ProductEName":"TwoTrees TTS-20 Pro 20W Powerful Laser Engraver CNC With Limit Switch Support Offline Engraving Metal Laser Engraving Machine","EAN":null,"BrandEName":"TWO TREES","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"https://www.aliexpress.com/item/3256805433292175.html?spm=a2g0o.productlist.main.6.86ca44421FLYiR&algo_pvid=6b4c250c-8e08-4b55-95cc-a74d26803c7f&algo_exp_id=6b4c250c-8e08-4b55-95cc-a74d26803c7f-5&pdp_ext_f=%7B%22order%22%3A%2214%22%2C%22eval%22%3A%221%22%7D&pdp_npi=4%40dis%21USD%21873.75%21410.66%21%21%21873.75%21410.66%21%400b5dcc3017466087330623333e7806%2112000042593329061%21sea%21US%212778379770%21ABX&curPageLogUid=KEFmrBmX0Je8&utparam-url=scene%3Asearch%7Cquery_from%3A","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"无
","EHighlights":"\n- \n
Easy Assembly:The TTS 20 Pro 20W comes pre-assembled with a simple setup, making it user-friendly for immediate use.
\n \n- \n
Expansive Engraving Area:A generous 418x418mm engraving area caters to a wide range of projects without limitations.
\n \n- \n
Multiple Control Methods:Featuring USB, APP, and offline engraving, the TTS 20 Pro 20W offers versatile control options.
\n \n- \n
Tts Master|Stronger Laser Head:Equipped with a C20000mW 20W laser, the TTS 20 Pro 20W boasts a more robust cutting ability.
\n \n- \n
High Engraving Speed:With a 30000mm/min speed, the TTS 20 Pro 20W laser engraver increases efficiency by 500mm/s.
\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 \n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\n
","PropertyValuesDto":[{"Code":1380,"CName":"激光雕刻机类型","Style":1,"IsSupportVariant":false,"PropertyValuesDto":[{"Code":0,"EName":"","CName":"Desktop Laser Engravers","ValueCode":4633,"Color":null},{"Code":0,"EName":"","CName":"Portable Laser Engravers","ValueCode":4634,"Color":null}]}],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"美国,欧洲,巴西","LimitPriceType":2,"LimitPrice":410.6600,"LimitPriceCurrency":"0002","PurchasePrice":2580.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF,USDF,BRDF","RStocker":"2405","PStocker":"2054","Supplier":"V4406","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":302,"Weight":4.7500,"GrossWeight":4.7500,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":64.0,"ProductW":20.0,"ProductH":20.0,"PackgeL":64.0,"PackgeW":20.0,"PackgeH":20.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":562124858990661,"Color":"规格","ColorCode":"1381","ColorValueCode":"4635","CName":"TWO TREES TTS-20 Pro 20W激光雕刻机刻字机小型全自动树叶木材切割打标机 欧规(24)","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\":2,\"LimitPrice\":410.6600,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":2250,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V4406\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":302,\"Weight\":4.7500,\"GrossWeight\":4.7500,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":64,\"ProductW\":20,\"ProductH\":20,\"PackgeL\":64,\"PackgeW\":20,\"PackgeH\":20,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"TTS-20 Pro 欧标\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"},{"SrmSKU":562124859031621,"Color":"规格","ColorCode":"1381","ColorValueCode":"4636","CName":"TWO TREES TTS-20 Pro 20W激光雕刻机刻字机小型全自动树叶木材切割打标机 美规(24)","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\":2,\"LimitPrice\":410.6600,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":2280,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"USDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V4406\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":302,\"Weight\":4.7500,\"GrossWeight\":4.7500,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":64,\"ProductW\":20,\"ProductH\":20,\"PackgeL\":64,\"PackgeW\":20,\"PackgeH\":20,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"TTS-20 Pro 美标\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":12}"},{"SrmSKU":562124859076677,"Color":"规格","ColorCode":"1381","ColorValueCode":"4946","CName":"TWO TREES TTS-20 Pro 20W激光雕刻机刻字机小型全自动树叶木材切割打标机 巴西规(24)","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\":2,\"LimitPrice\":410.6600,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":2580,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"BRDF\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V4406\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":302,\"Weight\":4.7500,\"GrossWeight\":4.7500,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":64,\"ProductW\":20,\"ProductH\":20,\"PackgeL\":64,\"PackgeW\":20,\"PackgeH\":20,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\" TTS-20 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-05/%e4%b8%bb%e5%9b%be-2_99999999999_562124910432325.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_99999999999_562124920975429.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_562124931809349.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/3_99999999999_562124941312069.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/4_99999999999_562124950990917.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/5_99999999999_562124975784005.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/6_99999999999_562124990160965.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_562125006815301.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/8_99999999999_562125018845253.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e4%b8%bb%e5%9b%be-1_99999999999_562125085139013.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_01_99999999999_562125113716805.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_02_99999999999_562125123891269.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_03_99999999999_562125133430853.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_04_99999999999_562125148409925.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_05_99999999999_562125173370949.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_07_99999999999_562125186728005.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_08_99999999999_562125199265861.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_09_99999999999_562125215014981.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_10_99999999999_562125225939013.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_11_99999999999_562125235867717.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_12_99999999999_562125246296133.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_13_99999999999_562125258604613.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_14_99999999999_562125274275909.jpg"}]},"SKUPictureInfos":[{"SrmSKU":562124858990661,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e4%b8%bb%e5%9b%be-2_99999999999_562124910432325.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_99999999999_562124920975429.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_562124931809349.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/3_99999999999_562124941312069.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/4_99999999999_562124950990917.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/5_99999999999_562124975784005.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/6_99999999999_562124990160965.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_562125006815301.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/8_99999999999_562125018845253.jpg","ImgSort":8},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e4%b8%bb%e5%9b%be-1_99999999999_562125085139013.jpg","ImgSort":9}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_01_99999999999_562125113716805.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_02_99999999999_562125123891269.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_03_99999999999_562125133430853.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_04_99999999999_562125148409925.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_05_99999999999_562125173370949.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_07_99999999999_562125186728005.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_08_99999999999_562125199265861.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_09_99999999999_562125215014981.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_10_99999999999_562125225939013.jpg","ImgSort":8},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_11_99999999999_562125235867717.jpg","ImgSort":9},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_12_99999999999_562125246296133.jpg","ImgSort":10},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_13_99999999999_562125258604613.jpg","ImgSort":11},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_14_99999999999_562125274275909.jpg","ImgSort":12}]},{"SrmSKU":562124859031621,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e4%b8%bb%e5%9b%be-2_99999999999_562124910432325.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_99999999999_562124920975429.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_562124931809349.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/3_99999999999_562124941312069.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/4_99999999999_562124950990917.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/5_99999999999_562124975784005.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/6_99999999999_562124990160965.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_562125006815301.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/8_99999999999_562125018845253.jpg","ImgSort":8},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e4%b8%bb%e5%9b%be-1_99999999999_562125085139013.jpg","ImgSort":9}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_01_99999999999_562125113716805.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_02_99999999999_562125123891269.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_03_99999999999_562125133430853.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_04_99999999999_562125148409925.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_05_99999999999_562125173370949.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_07_99999999999_562125186728005.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_08_99999999999_562125199265861.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_09_99999999999_562125215014981.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_10_99999999999_562125225939013.jpg","ImgSort":8},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_11_99999999999_562125235867717.jpg","ImgSort":9},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_12_99999999999_562125246296133.jpg","ImgSort":10},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_13_99999999999_562125258604613.jpg","ImgSort":11},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_14_99999999999_562125274275909.jpg","ImgSort":12}]},{"SrmSKU":562124859076677,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e4%b8%bb%e5%9b%be-2_99999999999_562124910432325.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_99999999999_562124920975429.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_99999999999_562124931809349.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/3_99999999999_562124941312069.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/4_99999999999_562124950990917.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/5_99999999999_562124975784005.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/6_99999999999_562124990160965.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_99999999999_562125006815301.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/8_99999999999_562125018845253.jpg","ImgSort":8},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/%e4%b8%bb%e5%9b%be-1_99999999999_562125085139013.jpg","ImgSort":9}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_01_99999999999_562125113716805.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_02_99999999999_562125123891269.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_03_99999999999_562125133430853.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_04_99999999999_562125148409925.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_05_99999999999_562125173370949.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_07_99999999999_562125186728005.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_08_99999999999_562125199265861.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_09_99999999999_562125215014981.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_10_99999999999_562125225939013.jpg","ImgSort":8},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_11_99999999999_562125235867717.jpg","ImgSort":9},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_12_99999999999_562125246296133.jpg","ImgSort":10},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_13_99999999999_562125258604613.jpg","ImgSort":11},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/0_14_99999999999_562125274275909.jpg","ImgSort":12}]}]},"UserId":"2054"}]
2025/5/9 10:03:15 GetSPUId方法内部,CategoryCode:60,sql:
2025/5/9 10:03:15 GetSPUId获取到结果:SPUId:I002836,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/5/9 10:03:25 响应体:{"Status":200,"Result":",TWO TREES TTS-20 Pro 20W激光雕刻机刻字机小型全自动树叶木材切割打标机操作成功","SuccessSPUSKUResponse":[{"SrmSPU":562124286111813,"ErpSPU":"I002836","SKURelations":[{"SrmSKU":"562124858990661","ErpSKU":"1291690"},{"SrmSKU":"562124859031621","ErpSKU":"1291691"},{"SrmSKU":"562124859076677","ErpSKU":"1291692"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/5/9 14:04:15 请求体:[{"SPUId":562424754921541,"BaseInfo":{"Category1":40,"Category2":4003,"Category3":400301,"Category4":null,"TemplateId":7,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"海外代发 SOYO M4 Mini N150 12+512G迷你主机","ProductShortName":"","ProductEName":"SOYO M4 Mini Mini PC Intel Twin Lake N150 Processor LPDDR5 12GB RAM 512GB ROM Windows 11 Pro WiFi 5 BT5.2 Desktop Computer","EAN":null,"BrandEName":"SOYO","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"SOYO M4 Mini Mini PC Intel Twin Lake N150 Processor LPDDR5 12GB RAM 512GB ROM Windows 11 Pro WiFi 5 BT5.2 Desktop Computer
","EHighlights":"SOYO M4 Mini Mini PC Intel Twin Lake N150 Processor LPDDR5 12GB RAM 512GB ROM Windows 11 Pro WiFi 5 BT5.2 Desktop Computer
","Specification":"\n\n\nGeneral | \n\n Model: Type: \n | \n
\n\nHardware | \n\n OS: CPU: GPU: RAM: ROM: \n | \n
\n\nCommunication | \n\n WIFI: Bluetooth: LAN: \n | \n
\n\nMedia | \n\n Decoder Format: Video format: Audio format: Photo Format: Support 5.1 Surround Sound Output: \n | \n
\n\nInterface | \n | \n
\n\nOther Features | \n\n System Bit: Language: Other Functions: External Subtitle Supported: HDMI Version: HDMI Function: Remote Controller Battery: \n | \n
\n\nPower | \nPower Type: Power Supply: Power Consumption: | \n
\n\nDimensiions&Weight | \nProduct weight: kg Package weight: kg Product size (L x W x H): cm / inches Package size (L x W x H): cm / 7 inches | \n
\n\nPackage Contents | \n\n 1 x 1 x 1 x 1 x 1 x \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"Germany","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":1080.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":3,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"1939","PStocker":"2219","Supplier":"V6197","EAN":null,"IsLastMileFreeShipping":true,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":404,"Weight":1.6900,"GrossWeight":1.6900,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":8.7,"ProductW":8.7,"ProductH":3.8,"PackgeL":11.6,"PackgeW":11.6,"PackgeH":8.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":562425532936261,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"海外代发 SOYO M4 Mini N150 12+512G迷你主机","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\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":1080,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":3,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"1939\",\"PStocker\":\"2219\",\"Supplier\":\"V6197\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":404,\"Weight\":1.6900,\"GrossWeight\":1.6900,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":8.7,\"ProductW\":8.7,\"ProductH\":3.8,\"PackgeL\":11.6,\"PackgeW\":11.6,\"PackgeH\":8,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"M4 Mini 12+512\",\"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/M4+Mini_%e5%89%af%e6%9c%ac_99999999999_562425951129669.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-02_%e5%89%af%e6%9c%ac_99999999999_562426381709381.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-03_%e5%89%af%e6%9c%ac_99999999999_562426396581957.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-04_%e5%89%af%e6%9c%ac_99999999999_562426422825029.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-05_%e5%89%af%e6%9c%ac_99999999999_562426467475525.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-06_%e5%89%af%e6%9c%ac_99999999999_562426478305349.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-07_%e5%89%af%e6%9c%ac_99999999999_562426491347013.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-08_%e5%89%af%e6%9c%ac_99999999999_562426500747333.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_%e5%89%af%e6%9c%ac_99999999999_562427098296389.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_%e5%89%af%e6%9c%ac_99999999999_562427111419973.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/3_%e5%89%af%e6%9c%ac_99999999999_562427123990597.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/4_%e5%89%af%e6%9c%ac_99999999999_562427136680005.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/5_%e5%89%af%e6%9c%ac_99999999999_562427148861509.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/6_%e5%89%af%e6%9c%ac_99999999999_562427363090501.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_%e5%89%af%e6%9c%ac_99999999999_562427373150277.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/8_%e5%89%af%e6%9c%ac_99999999999_562427382648901.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/9_%e5%89%af%e6%9c%ac_99999999999_562427393552453.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/10_%e5%89%af%e6%9c%ac_99999999999_562427406057541.jpg"}]},"SKUPictureInfos":[{"SrmSKU":562425532936261,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/M4+Mini_%e5%89%af%e6%9c%ac_99999999999_562425951129669.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-02_%e5%89%af%e6%9c%ac_99999999999_562426381709381.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-03_%e5%89%af%e6%9c%ac_99999999999_562426396581957.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-04_%e5%89%af%e6%9c%ac_99999999999_562426422825029.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-05_%e5%89%af%e6%9c%ac_99999999999_562426467475525.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-06_%e5%89%af%e6%9c%ac_99999999999_562426478305349.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-07_%e5%89%af%e6%9c%ac_99999999999_562426491347013.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/Main-08_%e5%89%af%e6%9c%ac_99999999999_562426500747333.jpg","ImgSort":7}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1_%e5%89%af%e6%9c%ac_99999999999_562427098296389.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2_%e5%89%af%e6%9c%ac_99999999999_562427111419973.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/3_%e5%89%af%e6%9c%ac_99999999999_562427123990597.jpg","ImgSort":2},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/4_%e5%89%af%e6%9c%ac_99999999999_562427136680005.jpg","ImgSort":3},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/5_%e5%89%af%e6%9c%ac_99999999999_562427148861509.jpg","ImgSort":4},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/6_%e5%89%af%e6%9c%ac_99999999999_562427363090501.jpg","ImgSort":5},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/7_%e5%89%af%e6%9c%ac_99999999999_562427373150277.jpg","ImgSort":6},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/8_%e5%89%af%e6%9c%ac_99999999999_562427382648901.jpg","ImgSort":7},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/9_%e5%89%af%e6%9c%ac_99999999999_562427393552453.jpg","ImgSort":8},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/10_%e5%89%af%e6%9c%ac_99999999999_562427406057541.jpg","ImgSort":9}]}]},"UserId":"2219"}]
2025/5/9 14:04:15 GetSPUId方法内部,CategoryCode:40,sql:
2025/5/9 14:04:15 GetSPUId获取到结果:SPUId:N002437,CategoryCode:40,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql:
declare @CategoryShortCode varchar(5),
@Max varchar(6),
@NewMax varchar(6)
select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode
select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%'
select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6)
select (@CategoryShortCode + @NewMax) SPUId
2025/5/9 14:04:18 响应体:{"Status":200,"Result":",海外代发 SOYO M4 Mini N150 12+512G迷你主机操作成功","SuccessSPUSKUResponse":[{"SrmSPU":562424754921541,"ErpSPU":"N002437","SKURelations":[{"SrmSKU":"562425532936261","ErpSKU":"1291695"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/5/9 15:34:59 请求体:[{"SPUId":562431184441413,"BaseInfo":{"Category1":30,"Category2":3003,"Category3":300301,"Category4":null,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"FOSSiBOT SP200+ 200W 太阳能板磁吸把手 绿色 ","ProductShortName":"","ProductEName":"FOSSiBOT SP200+ 200W Solar Panel Magnetic Handle Green","EAN":null,"BrandEName":"FOSSiBOT","VideoLink":null,"IsPackage":true,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"很好的便携性-重量轻,可折叠,便于携带,带有便携式保护箱。带脚架的简易设置-坚固的支架,便于在户外进行太阳能充电设置,23.4%的转换效率--高的太阳能转换效率帮助你捕捉更多的阳光,更快充电耐用和IP67防水-EFTE涂层和IP67防水等级使面板更加耐用。MC4连接器-可与大多数第三方设备配合使用。
","EHighlights":"reat Portability- Light weight and foldable, easy to carry with portableprotectivecase.Easy Setup with Kickstand- Sturdy stand for an easy solar chargingsetupoutdoors,23.4% Conversion Efficiency- High solar conversion efficiencyhelp you capturemore sun and charge faster.
","Specification":"\n\n\nGeneral | \n\n Brand: FOSSiBOT Type: SP200+ solar panel Model: SP200+ solar panel Color: Grey \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \n\n Product Weight: 5.3kg Package Weight: Product Size(L x W x H): Package Size(L x W x H): \n | \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":170.0,"PurchasePriceCurrency":"0002","MinOrder":1,"DeliveryTime":3,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"EUDF","RStocker":"2228","PStocker":"2054","Supplier":"V5617","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":1,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":5.3000,"GrossWeight":6.8400,"BoxWeight":13.6800,"BoxQuantity":2,"ProductL":199.3,"ProductW":61.6,"ProductH":3.0,"PackgeL":69.0,"PackgeW":20.0,"PackgeH":62.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":562433773563973,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"FOSSiBOT SP200+ 200W 太阳能板磁吸把手 绿色 ","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":1,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":170,\"PurchasePriceCurrency\":\"0002\",\"MinOrder\":1,\"DeliveryTime\":3,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"EUDF\",\"RStocker\":\"2228\",\"PStocker\":\"2054\",\"Supplier\":\"V5617\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":5.3000,\"GrossWeight\":6.8400,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":199.3,\"ProductW\":61.6,\"ProductH\":3,\"PackgeL\":69,\"PackgeW\":20,\"PackgeH\":62,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"FOSSIBOT SP200+\",\"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/b1cf3a83c21c5c94e1dd7e32c6ff518_99999999999_562440324550725.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2788a6a760b1d7ca9acbac0517a5e87_99999999999_562440341327941.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/b1cf3a83c21c5c94e1dd7e32c6ff518_99999999999_562440355774533.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/4c840f72428894cca3dd918c0e1f77b_99999999999_562440370761797.jpg"}]},"SKUPictureInfos":[{"SrmSKU":562433773563973,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/b1cf3a83c21c5c94e1dd7e32c6ff518_99999999999_562440324550725.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/2788a6a760b1d7ca9acbac0517a5e87_99999999999_562440341327941.jpg","ImgSort":1},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/b1cf3a83c21c5c94e1dd7e32c6ff518_99999999999_562440355774533.jpg","ImgSort":2}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/4c840f72428894cca3dd918c0e1f77b_99999999999_562440370761797.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/5/9 15:34:59 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 15:34:59 GetSPUId获取到结果:SPUId:S008463,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/9 15:35:02 响应体:{"Status":200,"Result":",FOSSiBOT SP200+ 200W 太阳能板磁吸把手 绿色 操作成功","SuccessSPUSKUResponse":[{"SrmSPU":562431184441413,"ErpSPU":"S008463","SKURelations":[{"SrmSKU":"562433773563973","ErpSKU":"1291699"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/5/9 17:11:42 请求体:[{"SPUId":562431149211717,"BaseInfo":{"Category1":11,"Category2":1101,"Category3":110107,"Category4":null,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"JIGOO V700 植毛滚刷","ProductShortName":"","ProductEName":"JIGOO V700 Big Roller","EAN":null,"BrandEName":"jigoo","VideoLink":null,"IsPackage":false,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"V700 植毛滚刷
","EHighlights":"V700 Big Roller
","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":"苏州市漕湖街道春耀路18号3E产业园4号楼302室","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":28.0,"PurchasePriceCurrency":"0001","MinOrder":50,"DeliveryTime":20,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT,ZFSZBT","RStocker":"0638","PStocker":"0211","Supplier":"V5714","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":0.2500,"GrossWeight":0.2500,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":20.0,"ProductW":10.0,"ProductH":5.0,"PackgeL":20.0,"PackgeW":10.0,"PackgeH":5.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":562432729583685,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"JIGOO V700 植毛滚刷","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":28,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":50,\"DeliveryTime\":20,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT,ZFSZBT\",\"RStocker\":\"0638\",\"PStocker\":\"0211\",\"Supplier\":\"V5714\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.2500,\"GrossWeight\":0.2500,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":20,\"ProductW\":10,\"ProductH\":5,\"PackgeL\":20,\"PackgeW\":10,\"PackgeH\":5,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"V700 植毛滚刷\",\"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/1234_99999999999_562432786735173.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1234_99999999999_562432758730821.jpg"}]},"SKUPictureInfos":[{"SrmSKU":562432729583685,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1234_99999999999_562432786735173.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/1234_99999999999_562432758730821.jpg","ImgSort":0}]}]},"UserId":"0211"}]
2025/5/9 17:11:42 GetSPUId方法内部,CategoryCode:11,sql:
2025/5/9 17:11:42 GetSPUId获取到结果:SPUId:O002087,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/5/9 17:11:44 响应体:{"Status":200,"Result":",JIGOO V700 植毛滚刷操作成功","SuccessSPUSKUResponse":[{"SrmSPU":562431149211717,"ErpSPU":"O002087","SKURelations":[{"SrmSKU":"562432729583685","ErpSKU":"1291703"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/5/9 17:12:36 请求体:[{"SPUId":562433776640069,"BaseInfo":{"Category1":11,"Category2":1101,"Category3":110107,"Category4":null,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"JIGOO V700 V型毛条滚地刷","ProductShortName":"","ProductEName":"JIGOO V700 Innovative Upgraded Brush","EAN":null,"BrandEName":"jigoo","VideoLink":null,"IsPackage":false,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"V700 V型毛条滚地刷
","EHighlights":"V700 Innovative Upgraded Brush
","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":"苏州市漕湖街道春耀路18号3E产业园4号楼302室","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":125.0,"PurchasePriceCurrency":"0001","MinOrder":20,"DeliveryTime":20,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT,ZFSZBT","RStocker":"0638","PStocker":"0211","Supplier":"V5714","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":2.0000,"GrossWeight":2.0000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":30.0,"ProductW":10.0,"ProductH":10.0,"PackgeL":30.0,"PackgeW":10.0,"PackgeH":10.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":562434338226245,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"JIGOO V700 V型毛条滚地刷","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.0000,\"TaxAmount\":0,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":false,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":0,\"LimitPrice\":0,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":125,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":20,\"DeliveryTime\":20,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT,ZFSZBT\",\"RStocker\":\"0638\",\"PStocker\":\"0211\",\"Supplier\":\"V5714\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":2.0000,\"GrossWeight\":2.0000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":30,\"ProductW\":10,\"ProductH\":10,\"PackgeL\":30,\"PackgeW\":10,\"PackgeH\":10,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"V700 V型毛条滚地刷\",\"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/123_99999999999_562434372083781.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/123_99999999999_562434394148933.jpg"}]},"SKUPictureInfos":[{"SrmSKU":562434338226245,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/123_99999999999_562434372083781.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-05/123_99999999999_562434394148933.jpg","ImgSort":0}]}]},"UserId":"0211"}]
2025/5/9 17:12:36 GetSPUId方法内部,CategoryCode:11,sql:
2025/5/9 17:12:36 GetSPUId获取到结果:SPUId:O002088,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/5/9 17:12:37 响应体:{"Status":200,"Result":",JIGOO V700 V型毛条滚地刷操作成功","SuccessSPUSKUResponse":[{"SrmSPU":562433776640069,"ErpSPU":"O002088","SKURelations":[{"SrmSKU":"562434338226245","ErpSKU":"1291704"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/5/9 17:28:36 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:36 GetSPUId获取到结果:SPUId:S008465,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/9 17:28:37 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:37 GetSPUId获取到结果:SPUId:S008466,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/9 17:28:37 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:37 GetSPUId获取到结果:SPUId:S008467,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/9 17:28:39 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:39 GetSPUId获取到结果:SPUId:S008468,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/9 17:28:39 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:39 GetSPUId获取到结果:SPUId:S008469,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/9 17:28:40 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:40 GetSPUId获取到结果:SPUId:S008470,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/9 17:28:40 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:40 GetSPUId获取到结果:SPUId:S008471,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/9 17:28:41 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:41 GetSPUId获取到结果:SPUId:S008472,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/9 17:28:42 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:42 GetSPUId获取到结果:SPUId:S008473,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/9 17:28:43 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:43 GetSPUId获取到结果:SPUId:S008474,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/9 17:28:44 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:44 GetSPUId获取到结果:SPUId:S008475,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/9 17:28:46 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:49 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:49 GetSPUId获取到结果:SPUId:S008477,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/9 17:28:49 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:49 GetSPUId获取到结果:SPUId:S008478,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/9 17:28:50 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:50 GetSPUId获取到结果:SPUId:S008479,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/9 17:28:51 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:51 GetSPUId获取到结果:SPUId:S008480,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/9 17:28:51 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:51 GetSPUId获取到结果:SPUId:S008481,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/9 17:28:53 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:53 GetSPUId获取到结果:SPUId:S008482,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/9 17:28:53 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:53 GetSPUId获取到结果:SPUId:S008483,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/9 17:28:54 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:54 GetSPUId获取到结果:SPUId:S008484,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/9 17:28:54 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:54 GetSPUId获取到结果:SPUId:S008485,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/9 17:28:55 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:55 GetSPUId获取到结果:SPUId:S008486,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/9 17:28:56 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:56 GetSPUId获取到结果:SPUId:S008487,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/9 17:28:57 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:57 GetSPUId获取到结果:SPUId:S008488,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/9 17:28:57 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:57 GetSPUId获取到结果:SPUId:S008489,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/9 17:28:58 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:58 GetSPUId获取到结果:SPUId:S008490,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/9 17:28:59 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:59 GetSPUId获取到结果:SPUId:S008491,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/9 17:28:59 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:28:59 GetSPUId获取到结果:SPUId:S008492,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/9 17:29:00 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:01 GetSPUId获取到结果:SPUId:S008493,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/9 17:29:01 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:01 GetSPUId获取到结果:SPUId:S008494,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/9 17:29:02 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:02 GetSPUId获取到结果:SPUId:S008495,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/9 17:29:03 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:03 GetSPUId获取到结果:SPUId:S008496,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/9 17:29:03 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:03 GetSPUId获取到结果:SPUId:S008497,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/9 17:29:04 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:04 GetSPUId获取到结果:SPUId:S008498,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/9 17:29:05 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:05 GetSPUId获取到结果:SPUId:S008499,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/9 17:29:06 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:06 GetSPUId获取到结果:SPUId:S008500,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/9 17:29:06 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:06 GetSPUId获取到结果:SPUId:S008501,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/9 17:29:07 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:07 GetSPUId获取到结果:SPUId:S008502,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/9 17:29:07 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:07 GetSPUId获取到结果:SPUId:S008503,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/9 17:29:09 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:09 GetSPUId获取到结果:SPUId:S008504,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/9 17:29:09 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:09 GetSPUId获取到结果:SPUId:S008505,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/9 17:29:10 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:10 GetSPUId获取到结果:SPUId:S008506,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/9 17:29:11 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:11 GetSPUId获取到结果:SPUId:S008507,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/9 17:29:13 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:13 GetSPUId获取到结果:SPUId:S008508,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/9 17:29:13 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:13 GetSPUId获取到结果:SPUId:S008509,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/9 17:29:14 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:14 GetSPUId获取到结果:SPUId:S008510,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/9 17:29:15 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:15 GetSPUId获取到结果:SPUId:S008511,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/9 17:29:15 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:15 GetSPUId获取到结果:SPUId:S008512,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/9 17:29:18 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:18 GetSPUId获取到结果:SPUId:S008513,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/9 17:29:18 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:18 GetSPUId获取到结果:SPUId:S008514,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/9 17:29:19 GetSPUId方法内部,CategoryCode:30,sql:
2025/5/9 17:29:19 GetSPUId获取到结果:SPUId:S008515,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