2025/5/5 11:43:48 请求体：[{"SPUId":559353339551813,"BaseInfo":{"Category1":60,"Category2":6001,"Category3":600101,"Category4":null,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Anycubic Kobra 3 V2 Combo 3D打印机 欧规","ProductShortName":"","ProductEName":"Kobra 3 V2 Combo 3D Printer","EAN":null,"BrandEName":"Anycubic","VideoLink":null,"IsPackage":false,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"

Kobra 3 V2 Combo

","EHighlights":"

Kobra 3 V2 Combo

","Specification":"\n\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\n\t\t\n\t\t\t\n\t\t\t\n\t\t\n\t\n
\n\t\t\t\tGeneral \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\t\tSpecification \n\t\t\t\n\t\t\t\t \n\t\t\t
\n\t\t\t\tWeight & Size \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\t\tPackage Contents \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
","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":1900.0,"PurchasePriceCurrency":"0001","MinOrder":200,"DeliveryTime":20,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SUJK","RStocker":"2405","PStocker":"2054","Supplier":"V5798","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":true,"TaxRate":0.1300,"TaxAmount":218.58},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"","WLEmbargoType":100,"Weight":14.0000,"GrossWeight":16.4000,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":50.0,"ProductW":48.0,"ProductH":47.0,"PackgeL":54.0,"PackgeW":51.0,"PackgeH":50.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":559355755692101,"Color":null,"ColorCode":"0","ColorValueCode":null,"CName":"Anycubic Kobra 3 V2 Combo 3D打印机 欧规 K3VCBK0A-O","Size":null,"SizeCode":"0","SizeValueCode":null,"Option":null,"OptionCode":"0","OptionValueCode":null,"SampleCount":0,"SupplyInfo":"{\"TaxRate\":0.1300,\"TaxAmount\":218.58,\"IsLastMileFreeShipping\":false,\"SupplyModel\":0,\"IsTaxInclusiveProcurementPrice\":true,\"EAN\":null,\"ShippingAddress\":\"\",\"LimitPriceType\":2,\"LimitPrice\":449.0000,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":1900,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":200,\"DeliveryTime\":20,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SUJK\",\"RStocker\":\"2405\",\"PStocker\":\"2054\",\"Supplier\":\"V5798\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":14.0000,\"GrossWeight\":16.4000,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":50,\"ProductW\":48,\"ProductH\":47,\"PackgeL\":54,\"PackgeW\":51,\"PackgeH\":50,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"Kobra 3 V2 Combo\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/7_99999999999_559355921956933.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/7_99999999999_559356045946949.jpg"}]},"SKUPictureInfos":[{"SrmSKU":559355755692101,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/7_99999999999_559355921956933.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-04/7_99999999999_559356045946949.jpg","ImgSort":0}]}]},"UserId":"2054"}] 2025/5/5 11:43:48 GetSPUId方法内部，CategoryCode：60，sql： 2025/5/5 11:43:48 GetSPUId获取到结果：SPUId:I002827,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/5 11:44:01 响应体：{"Status":200,"Result":",Anycubic Kobra 3 V2 Combo 3D打印机 欧规操作成功","SuccessSPUSKUResponse":[{"SrmSPU":559353339551813,"ErpSPU":"I002827","SKURelations":[{"SrmSKU":"559355755692101","ErpSKU":"1291431"}],"Msg":null}],"FailSPUSKUResponse":[]} 2025/5/5 15:24:29 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:29 GetSPUId获取到结果：SPUId:S008280,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/5 15:24:30 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:30 GetSPUId获取到结果：SPUId:S008281,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/5 15:24:31 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:31 GetSPUId获取到结果：SPUId:S008282,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/5 15:24:32 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:32 GetSPUId获取到结果：SPUId:S008283,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/5 15:24:33 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:33 GetSPUId获取到结果：SPUId:S008284,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/5 15:24:34 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:34 GetSPUId获取到结果：SPUId:S008285,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/5 15:24:34 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:34 GetSPUId获取到结果：SPUId:S008286,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/5 15:24:35 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:35 GetSPUId获取到结果：SPUId:S008287,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/5 15:24:35 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:36 GetSPUId获取到结果：SPUId:S008288,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/5 15:24:36 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:36 GetSPUId获取到结果：SPUId:S008289,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/5 15:24:37 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:37 GetSPUId获取到结果：SPUId:S008290,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/5 15:24:38 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:38 GetSPUId获取到结果：SPUId:S008291,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/5 15:24:39 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:39 GetSPUId获取到结果：SPUId:S008292,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/5 15:24:39 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:39 GetSPUId获取到结果：SPUId:S008293,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/5 15:24:40 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:40 GetSPUId获取到结果：SPUId:S008294,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/5 15:24:41 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:41 GetSPUId获取到结果：SPUId:S008295,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/5 15:24:41 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:41 GetSPUId获取到结果：SPUId:S008296,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/5 15:24:44 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:44 GetSPUId获取到结果：SPUId:S008297,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/5 15:24:45 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:45 GetSPUId获取到结果：SPUId:S008298,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/5 15:24:45 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:45 GetSPUId获取到结果：SPUId:S008299,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/5 15:24:46 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:46 GetSPUId获取到结果：SPUId:S008300,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/5 15:24:47 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:47 GetSPUId获取到结果：SPUId:S008301,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/5 15:24:47 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:47 GetSPUId获取到结果：SPUId:S008302,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/5 15:24:48 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:48 GetSPUId获取到结果：SPUId:S008303,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/5 15:24:48 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:48 GetSPUId获取到结果：SPUId:S008304,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/5 15:24:49 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:49 GetSPUId获取到结果：SPUId:S008305,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/5 15:24:50 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:50 GetSPUId获取到结果：SPUId:S008306,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/5 15:24:51 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:51 GetSPUId获取到结果：SPUId:S008307,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/5 15:24:52 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:52 GetSPUId获取到结果：SPUId:S008308,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/5 15:24:52 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:52 GetSPUId获取到结果：SPUId:S008309,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/5 15:24:53 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:53 GetSPUId获取到结果：SPUId:S008310,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/5 15:24:54 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:54 GetSPUId获取到结果：SPUId:S008311,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/5 15:24:55 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:55 GetSPUId获取到结果：SPUId:S008312,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/5 15:24:56 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:56 GetSPUId获取到结果：SPUId:S008313,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/5 15:24:56 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:56 GetSPUId获取到结果：SPUId:S008314,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/5 15:24:57 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:57 GetSPUId获取到结果：SPUId:S008315,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/5 15:24:57 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:57 GetSPUId获取到结果：SPUId:S008316,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/5 15:24:59 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:59 GetSPUId获取到结果：SPUId:S008317,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/5 15:24:59 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:24:59 GetSPUId获取到结果：SPUId:S008318,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/5 15:25:01 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:01 GetSPUId获取到结果：SPUId:S008319,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/5 15:25:04 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:04 GetSPUId获取到结果：SPUId:S008320,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/5 15:25:06 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:06 GetSPUId获取到结果：SPUId:S008321,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/5 15:25:08 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:08 GetSPUId获取到结果：SPUId:S008322,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/5 15:25:11 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:11 GetSPUId获取到结果：SPUId:S008323,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/5 15:25:12 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:12 GetSPUId获取到结果：SPUId:S008324,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/5 15:25:12 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:12 GetSPUId获取到结果：SPUId:S008325,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/5 15:25:14 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:14 GetSPUId获取到结果：SPUId:S008326,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/5 15:25:16 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:16 GetSPUId获取到结果：SPUId:S008327,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/5 15:25:17 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:17 GetSPUId获取到结果：SPUId:S008328,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/5 15:25:17 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:17 GetSPUId获取到结果：SPUId:S008329,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/5 15:25:18 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:18 GetSPUId获取到结果：SPUId:S008330,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/5 15:25:19 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:19 GetSPUId获取到结果：SPUId:S008331,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/5 15:25:19 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:19 GetSPUId获取到结果：SPUId:S008332,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/5 15:25:20 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:20 GetSPUId获取到结果：SPUId:S008333,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/5 15:25:21 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:21 GetSPUId获取到结果：SPUId:S008334,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/5 15:25:22 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:22 GetSPUId获取到结果：SPUId:S008335,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/5 15:25:23 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:23 GetSPUId获取到结果：SPUId:S008336,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/5 15:25:23 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:23 GetSPUId获取到结果：SPUId:S008337,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/5 15:25:24 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:24 GetSPUId获取到结果：SPUId:S008338,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/5 15:25:24 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:24 GetSPUId获取到结果：SPUId:S008339,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/5 15:25:25 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:25 GetSPUId获取到结果：SPUId:S008340,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/5 15:25:26 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:26 GetSPUId获取到结果：SPUId:S008341,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/5 15:25:26 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:26 GetSPUId获取到结果：SPUId:S008342,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/5 15:25:27 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:27 GetSPUId获取到结果：SPUId:S008343,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/5 15:25:28 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:28 GetSPUId获取到结果：SPUId:S008344,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/5 15:25:29 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:29 GetSPUId获取到结果：SPUId:S008345,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/5 15:25:31 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:31 GetSPUId获取到结果：SPUId:S008346,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/5 15:25:33 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:33 GetSPUId获取到结果：SPUId:S008347,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/5 15:25:35 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:35 GetSPUId获取到结果：SPUId:S008348,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/5 15:25:36 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:36 GetSPUId获取到结果：SPUId:S008349,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/5 15:25:37 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:37 GetSPUId获取到结果：SPUId:S008350,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/5 15:25:38 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:38 GetSPUId获取到结果：SPUId:S008351,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/5 15:25:38 GetSPUId方法内部，CategoryCode：30，sql： 2025/5/5 15:25:38 GetSPUId获取到结果：SPUId:S008352,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