2025/6/28 15:47:42 请求体:[{"SPUId":577028807684165,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600205,"Category4":60020502,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Waveshare ESP32-S3 1.85 寸圆形 LCD 屏开发板 360×360 分辨率 支持 Wi-Fi/蓝牙 BLE 5 AI 语音 智能音箱","ProductShortName":"","ProductEName":"Waveshare ESP32-S3 1.85inch Round LCD Development Board, 360×360, Supports Wi-Fi & Bluetooth BLE 5, AI Speech, Smart Speaker Box, ESP32 With Display","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"https://www.waveshare.com/esp32-s3-touch-lcd-1.85c.htm?sku=30683","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
产品特性
\n\n
本产品是一款支持 2.4GHz Wi-Fi 和蓝牙 BLE 5 的微控制器开发板。集成大容量 Flash 和 PSRAM,板载 1.85 英寸 LCD 屏,可流畅运行 LVGL 等 GUI 界面程序,结合多种外设接口,可快速开发 ESP32-S3 的 HMI 等应用。
\n
\n
\n- 搭载高性能 Xtensa 32 位 LX7 双核处理器,主频高达 240MHz
\n- 支持 2.4 GHz Wi-Fi (802.11 b/g/n) 和 Bluetooth 5 (LE),板载天线
\n- 内置 512KB SRAM、384KB ROM、16MB Flash 和 8MB PSRAM
\n- 板载 1.85 英寸 LCD 屏,360 × 360 分辨率,262K 彩色
\n- 支持通过 I2C 接口控制触摸,支持中断
\n- 引出 UART、I2C 以及部分 IO 接口
\n- 板载音频解码芯片、MIC、RTC 时钟传感器、Micro SD 卡槽和电池充电管理模块等资源
\n- 支持灵活时钟、多种电源模式等准确控制,实现多场景低功耗模式
\n
\n
\n
","EHighlights":"Features
\n\n
ESP32-S3-Touch-LCD-1.85C is a microcontroller development board with 2.4GHz Wi-Fi and Bluetooth BLE 5 support, integrates high-capacity Flash and PSRAM. Onboard 1.85inch LCD display which can smoothly run GUI programs such as LVGL. Combined with various peripheral interfaces, it is suitable for the quick development of the HMI and other ESP32-S3 applications.
\n
\n- Equipped with high-performance Xtensa 32-bit LX7 dual-core processor, up to 240MHz main frequency
\n- Supports 2.4GHz Wi-Fi (802.11 b/g/n) and Bluetooth 5 (LE), with onboard antenna
\n- Built-in 512KB SRAM and 384KB ROM, with onboard 16MB Flash and 8MB PSRAM
\n- Onboard 1.85inch LCD display, 360×360 resolution, 262K color
\n- Supports capacitive touch controlled via I2C interface, with interrupt support
\n- Adapting UART, I2C and some IO interfaces
\n- Onboard audio decoder, Microphone, RTC sensor, TF card slot and battery recharge management module, etc.
\n- Supports accurate control such as flexible clock and multiple power modes to realize low power consumption in different scenarios
\n
\n
","Specification":"\n\n\nGeneral | \n\n Brand: Waveshare Type: Development Board Model: ESP32-S3-Touch-LCD-1.85C Color: black \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: 0.043 Package Weight: 0.043 Product Size(L x W x H): 5.8x5.8x1.7 Package Size(L x W x H): 11x8x7 | \n
\n\nPackage Contents | \n\n 1 x ESP32-S3-Touch-LCD-1.85C 1 x User Manual \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"深圳","LimitPriceType":1,"LimitPrice":31.9900,"LimitPriceCurrency":"0002","PurchasePrice":147.0,"PurchasePriceCurrency":"0001","MinOrder":10,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"1939","PStocker":"2054","Supplier":"V2487","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"1. ESP32-S3-Touch-LCD-1.85C × 1\n2. SH1.0 4PIN 连接线约 100mm × 2\n3. 8Ω 2W 喇叭 × 1","WLEmbargoType":100,"Weight":0.0430,"GrossWeight":0.0430,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":5.8,"ProductW":5.8,"ProductH":1.7,"PackgeL":11.0,"PackgeW":8.0,"PackgeH":7.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":580137299161157,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3948","CName":"ESP32-S3 1.85 寸圆形 LCD 屏开发板 360×360 分辨率 支持 Wi-Fi/蓝牙 BLE 5 AI 语音 ","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\":1,\"LimitPrice\":31.9900,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":147,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":10,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"1939\",\"PStocker\":\"2054\",\"Supplier\":\"V2487\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1. ESP32-S3-Touch-LCD-1.85C × 1\\n2. SH1.0 4PIN 连接线约 100mm × 2\\n3. 8Ω 2W 喇叭 × 1\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0430,\"GrossWeight\":0.0430,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":5.8,\"ProductW\":5.8,\"ProductH\":5.1,\"PackgeL\":11,\"PackgeW\":8,\"PackgeH\":7,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"ESP32-S3-Touch-LCD-1.85C\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":580137299206213,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3949","CName":"ESP32-S3 1.85 寸圆形 LCD 屏开发板带音箱版本不带锂电池 360×360 分辨率 支持 Wi-Fi/蓝牙 BLE 5 AI 语音 智能音箱","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\":1,\"LimitPrice\":33.9900,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":156,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":10,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"1939\",\"PStocker\":\"2054\",\"Supplier\":\"V2487\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1. ESP32-S3-Touch-LCD-1.85C-BOX 主机 × 1\\n2. SH1.0 4PIN 连接线约 100mm × 2\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0940,\"GrossWeight\":0.0940,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":5.8,\"ProductW\":5.8,\"ProductH\":5.1,\"PackgeL\":11,\"PackgeW\":8,\"PackgeH\":7,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"ESP32-S3-Touch-LCD-1.85C-BOX-EN\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":580137299243077,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3950","CName":"ESP32-S3 1.85 寸圆形 LCD 屏开发板带音箱版本 360×360 分辨率 支持 Wi-Fi/蓝牙 BLE 5 AI 语音 智能音箱/带音箱带电池版本","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\":1,\"LimitPrice\":35.9900,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":161,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":10,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"1939\",\"PStocker\":\"2054\",\"Supplier\":\"V2487\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1. ESP32-S3-Touch-LCD-1.85C-BOX 主机 × 1\\n2. SH1.0 4PIN 连接线约 100mm × 2\\n3. 锂电池 × 1\\n\",\"EAN\":null,\"WLEmbargoType\":40401,\"Weight\":0.1310,\"GrossWeight\":0.1310,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":5.8,\"ProductW\":5.8,\"ProductH\":5.1,\"PackgeL\":11,\"PackgeW\":8,\"PackgeH\":7,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"ESP32-S3-Touch-LCD-1.85C-BOX\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C+(8)_99999999999_579504407068741.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C-BOX-1_99999999999_580137600999493.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/06_99999999999_579512176054341.jpg"},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C-BOX-1_99999999999_580137626222661.jpg"}]},"SKUPictureInfos":[{"SrmSKU":580137299161157,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C+(8)_99999999999_579504407068741.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C-BOX-1_99999999999_580137600999493.jpg","ImgSort":1}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/06_99999999999_579512176054341.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C-BOX-1_99999999999_580137626222661.jpg","ImgSort":1}]},{"SrmSKU":580137299206213,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C+(8)_99999999999_579504407068741.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C-BOX-1_99999999999_580137600999493.jpg","ImgSort":1}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/06_99999999999_579512176054341.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C-BOX-1_99999999999_580137626222661.jpg","ImgSort":1}]},{"SrmSKU":580137299243077,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C+(8)_99999999999_579504407068741.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C-BOX-1_99999999999_580137600999493.jpg","ImgSort":1}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/06_99999999999_579512176054341.jpg","ImgSort":0},{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-LCD-1.85C-BOX-1_99999999999_580137626222661.jpg","ImgSort":1}]}]},"UserId":"2054"}]
2025/6/28 15:47:42 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/28 15:47:42 GetSPUId获取到结果:SPUId:I002940,CategoryCode:60,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql:
declare @CategoryShortCode varchar(5),
@Max varchar(6),
@NewMax varchar(6)
select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode
select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%'
select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6)
select (@CategoryShortCode + @NewMax) SPUId
2025/6/28 15:47:44 响应体:{"Status":200,"Result":",Waveshare ESP32-S3 1.85 寸圆形 LCD 屏开发板 360×360 分辨率 支持 Wi-Fi/蓝牙 BLE 5 AI 语音 智能音箱操作成功","SuccessSPUSKUResponse":[{"SrmSPU":577028807684165,"ErpSPU":"I002940","SKURelations":[{"SrmSKU":"580137299161157","ErpSKU":"1294411"},{"SrmSKU":"580137299206213","ErpSKU":"1294412"},{"SrmSKU":"580137299243077","ErpSKU":"1294413"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/28 15:56:25 请求体:[{"SPUId":577044046008389,"BaseInfo":{"Category1":60,"Category2":6002,"Category3":600205,"Category4":60020502,"TemplateId":5,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"Waveshare ESP32-S3 1.8寸 AMOLED 触摸屏开发板 LX7 双核处理器 368×448 像素开发板 板载加速度与陀螺仪传感器 小智 AI 语音","ProductShortName":"","ProductEName":"Waveshare ESP32-S3 1.8inch AMOLED Touch Display Development Board, 32-bit LX7 Dual-core Processor, 368×448 Pixels, Accelerometer And Gyroscope Sensor, ESP32 With Display","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":true,"OtherPlatformLink":"https://www.waveshare.com/esp32-s3-touch-amoled-1.8.htm?sku=29958","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"
产品特性
\n\n
ESP32-S3-Touch-AMOLED-1.8 是一款微雪 (Waveshare) 设计的高性能、高集成的微控制器开发板。在较小的板型下,板载了 1.8 英寸电容高清 AMOLED 屏、高度集成的电源管理芯片、六轴传感器 (三轴加速度计与三轴陀螺仪)、RTC、低功耗音频编解码芯片等外设,方便开发并嵌入应用到产品中。
主要功能特性有:
\n
\n
\n- 搭载 ESP32-S3R8 高性能 Xtensa 32 位 LX7 双核处理器,主频高达 240MHz
\n- 支持 2.4 GHz Wi-Fi (802.11 b/g/n) 和 Bluetooth 5 (LE),板载天线
\n- 内置 512 KB 的 SRAM 和 384 KB ROM,叠封 8 MB PSRAM 和外接 16 MB Flash
\n- 采用 Type-C 接口,提高了用户的使用便捷性和设备的兼容性
\n- 板载 1.8 英寸电容触摸高清 AMOLED 屏,368 × 448 分辨率,16.7 M 彩色,能清晰地显示彩色图片
\n- 内置 SH8601 驱动芯片和 FT3168 电容触控芯片,分别使用 QSPI 和 I2C 接口通信,不占用过多接口引脚资源
\n- 板载 QMI8658 六轴惯性测量单元 (3 轴加速度、3 轴陀螺仪),可检测运动姿态、计步等功能
\n- 板载 PCF85063 RTC 芯片,通过 AXP2101 接入电池,实现不间断供电,并预留备用电池焊盘,确保更换主电池时 RTC 功能持续工作
\n- 板载 PWR、BOOT 两个可自定义功能的侧边按钮,方便使用按钮进行自定义功能开发
\n- 板载 3.7V MX1.25 锂电池充放电接口
\n- 引出 7 个 GPIO、1 路 I2C、1 路 UART 和 1 路 USB 焊盘,可供外接设备和调试使用,灵活配置外设功能
\n- 板载 Micro SD 卡槽,提供扩展存储、快速数据传输和灵活性,适用于数据记录和媒体播放,简化了电路设计
\n- 使用 AXP2101 的好处包括高效的电源管理、支持多种输出电压、充电和电池管理功能以及对电池寿命的优化
\n- 使用 AMOLED 屏幕,具有更高的对比度、广视角、丰富的色彩、快速响应时间、纤薄设计、低功耗和灵活性等优点
\n
\n
\n
","EHighlights":"Features
\n\n
ESP32-S3-Touch-AMOLED-1.8 is a low-cost, high-performance MCU board designed by Waveshare, tiny size, with onboard 1.8inch AMOLED display, power management IC, 6-axis sensor (3-axis accelerometer and 3-axis gyroscope), RTC, low power audio codec, and so on, which makes it easy for you to develop and integrate it into the products quickly.
\n
Key features include:
\n
\n- Equipped with ESP32-S3R8 Xtensa 32-bit LX7 dual-core processor, up to 240MHz main frequency
\n- Supports 2.4GHz Wi-Fi (802.11 b/g/n) and Bluetooth 5 (LE), with onboard antenna
\n- Built in 512KB of SRAM and 384KB ROM, with onboard 8MB PSRAM and an external 16MB Flash memory
\n- Type-C connector, improving device compatibility, easier to use
\n- Onboard 1.8inch AMOLED display for clear color picture display, 368 × 448 resolution, 16.7M color
\n- Built-in SH8601 display driver and FT3168 capacitive touch chip, using QSPI and I2C communication respectively, effectively saving the IO resources
\n- Onboard QMI8658 6-axis IMU (3-axis accelerometer and 3-axis gyroscope) for detecting motion gesture, counting steps, etc.
\n- Onboard PCF85063 RTC chip, powered by main Lithium battery through AXP2101 chip, with reserved RTC battery pads for connecting a backup battery, ensuring RTC function during the replacement of the main battery
\n- Onboard PWR and BOOT programmable buttons for easy custom function development
\n- Onboard 3.7V MX1.25 Lithium battery recharge/discharge header, optional for 3.7V Lithium battery
\n- Reserved pads of 7 × GPIO, 1 × I2C, 1 × UART, and 1 × USB interface, for connecting peripherals and debugging
\n- Onboard TF card slot for extended storage and fast data transfer, suitable for applications such as data recording and media playback, simplifying circuit design
\n- Adopts AXP2101 IC for efficient power management, supports multiple voltage outputs, battery charging, battery management, and battery life optimization, etc.
\n- Adopts AMOLED screen, featuring advantages of high contrast, wide viewing angle, rich colors, fast response, thinner design, and low power consumption, etc.
\n
\n
","Specification":"\n\n\nGeneral | \n\n Brand: Waveshare Type: Development Board Model: ESP32-S3-Touch-AMOLED-1.8-EN Color: black \n | \n
\n\nSpecification | \n | \n
\n\nWeight & Size | \nProduct Weight: 0.024 kg Package Weight: 0.024 kg Product Size(L x W x H): 3.76x4.52x1.5 Package Size(L x W x H): 10.6x8x2.2 | \n
\n\nPackage Contents | \n\n 1 x ESP32-S3-Touch-AMOLED-1.8-EN 1 x User Manual \n | \n
\n\n
","PropertyValuesDto":[],"Other":"","Remark":"","EditMark":"","StockCheck":0,"ArtistCheck":0,"IsVirtual":0,"IsGraphs":0,"IsWeight":0,"IsScanSerialNumberCode":0},"SupplyInfo":{"ShippingAddress":"深圳","LimitPriceType":1,"LimitPrice":27.9900,"LimitPriceCurrency":"0002","PurchasePrice":131.0,"PurchasePriceCurrency":"0001","MinOrder":10,"DeliveryTime":7,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"1939","PStocker":"2054","Supplier":"V2487","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"ESP32-S3-Touch-AMOLED-1.8-EN × 1","WLEmbargoType":100,"Weight":0.0240,"GrossWeight":0.0240,"BoxWeight":0.0,"BoxQuantity":0,"ProductL":3.8,"ProductW":4.5,"ProductH":1.5,"PackgeL":10.6,"PackgeW":8.0,"PackgeH":2.2,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":580141362946117,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3948","CName":"Waveshare ESP32-S3 1.8寸 AMOLED 触摸屏开发板 LX7 双核处理器 368×448 像素开发板 板载加速度与陀螺仪传感器 小智 AI 语音","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\":1,\"LimitPrice\":27.9900,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":131,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":10,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"1939\",\"PStocker\":\"2054\",\"Supplier\":\"V2487\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"ESP32-S3-Touch-AMOLED-1.8-EN × 1\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.0240,\"GrossWeight\":0.0240,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":3.8,\"ProductW\":4.5,\"ProductH\":1.5,\"PackgeL\":10.6,\"PackgeW\":8,\"PackgeH\":2.2,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"ESP32-S3-Touch-AMOLED-1.8-EN\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"},{"SrmSKU":580141362987077,"Color":"尺寸","ColorCode":"1267","ColorValueCode":"3949","CName":"Waveshare ESP32-S3 1.8寸 AMOLED 触摸屏开发板 LX7 双核处理器 368×448 像素开发板 板载加速度与陀螺仪传感器 小智 AI 语音 带电池","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\":1,\"LimitPrice\":31.9900,\"LimitPriceCurrency\":\"0002\",\"PurchasePrice\":139,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":10,\"DeliveryTime\":7,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"1939\",\"PStocker\":\"2054\",\"Supplier\":\"V2487\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"1. ESP32-S3-Touch-AMOLED-1.8 × 1\\n2. 锂电池 × 1\",\"EAN\":null,\"WLEmbargoType\":40401,\"Weight\":0.0290,\"GrossWeight\":0.0290,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":3.8,\"ProductW\":4.5,\"ProductH\":1.5,\"PackgeL\":10.6,\"PackgeW\":8,\"PackgeH\":2.2,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"ESP32-S3-Touch-AMOLED-1.8\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":1,\"PTGAssociatedValue\":0}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-AMOLED-1.8-1_99999999999_579500763013189.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-AMOLED-1.8-1_99999999999_579500782198853.jpg"}]},"SKUPictureInfos":[{"SrmSKU":580141362946117,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-AMOLED-1.8-1_99999999999_579500763013189.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-AMOLED-1.8-1_99999999999_579500782198853.jpg","ImgSort":0}]},{"SrmSKU":580141362987077,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-AMOLED-1.8-1_99999999999_579500763013189.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/ESP32-S3-Touch-AMOLED-1.8-1_99999999999_579500782198853.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/28 15:56:25 GetSPUId方法内部,CategoryCode:60,sql:
2025/6/28 15:56:25 GetSPUId获取到结果:SPUId:I002941,CategoryCode:60,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql:
declare @CategoryShortCode varchar(5),
@Max varchar(6),
@NewMax varchar(6)
select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode
select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%'
select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6)
select (@CategoryShortCode + @NewMax) SPUId
2025/6/28 15:56:26 响应体:{"Status":200,"Result":",Waveshare ESP32-S3 1.8寸 AMOLED 触摸屏开发板 LX7 双核处理器 368×448 像素开发板 板载加速度与陀螺仪传感器 小智 AI 语音操作成功","SuccessSPUSKUResponse":[{"SrmSPU":577044046008389,"ErpSPU":"I002941","SKURelations":[{"SrmSKU":"580141362946117","ErpSKU":"1294414"},{"SrmSKU":"580141362987077","ErpSKU":"1294415"}],"Msg":null}],"FailSPUSKUResponse":[]}
2025/6/28 16:42:14 请求体:[{"SPUId":579772602642501,"BaseInfo":{"Category1":10,"Category2":1001,"Category3":100101,"Category4":null,"TemplateId":7,"RecommendType":0,"RecommendTypePresaleStart":null,"RecommendTypePresaleEnd":null,"RecommendTypeFirstLaunch":0,"ProductCName":"H96Max M1plus RK3528 安卓14 机顶盒","ProductShortName":"","ProductEName":"H96Max M1plus RK3528 Andriod 14 tv box","EAN":null,"BrandEName":null,"VideoLink":null,"IsPackage":false,"OtherPlatformLink":"","RecommendationGrade":0,"IsImitationBrand":0,"IsStandard":0,"CHighlights":"1
","EHighlights":"1
","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\tModel: \nType:\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tHardware \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tOS: \nCPU: \nGPU: \nRAM: \nROM:\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tCommunication \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tWIFI: \nBluetooth: \nLAN:\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tMedia \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tDecoder Format: \nVideo format: \nAudio format: \nPhoto Format: \nSupport 5.1 Surround Sound Output:\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tInterface \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\tOther Features \n\t\t\t | \n\t\t\t\n\t\t\t\t \n\t\t\t\t\tSystem Bit: \nLanguage: \nOther Functions: \nExternal Subtitle Supported: \nHDMI Version: \nHDMI Function: \nRemote Controller Battery:\n\t\t\t\t \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tPower \n\t\t\t | \n\t\t\t\n\t\t\t\tPower Type: \nPower Supply: \nPower Consumption: \n\t\t\t | \n\t\t
\n\t\t\n\t\t\t\n\t\t\t\tDimensiions&Weight \n\t\t\t | \n\t\t\t\n\t\t\t\tProduct weight: kg \nPackage weight: kg \nProduct size (L x W x H): cm / inches \nPackage size (L x W x H): cm / 7 inches\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 \n1 x \n1 x \n1 x\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":"深圳市龙华区大浪街道丽荣路1号国乐科技园6栋11楼","LimitPriceType":0,"LimitPrice":0.0,"LimitPriceCurrency":"0002","PurchasePrice":155.0,"PurchasePriceCurrency":"0001","MinOrder":1,"DeliveryTime":5,"WarrantyPeriod":0,"WarrantyNote":"","AfterSaleMethodId":0,"AfterSaleMethodNote":null,"CertificateIds":"CE,FCC,UL,ROHS","QualityInspectionMethod":"","PurchasePriceType":0,"PurchasePriceDeparture":"SZBT","RStocker":"1939","PStocker":"2219","Supplier":"V2540","EAN":null,"IsLastMileFreeShipping":false,"SupplyModel":0,"IsTaxInclusiveProcurementPrice":false,"TaxRate":0.0000,"TaxAmount":0.0},"ShipInfo":{"IsInsteadOfShipping":false,"PackageList":"机顶盒*1,高清线*1,蓝牙遥控器*1,说明书*1,适配器*1","WLEmbargoType":100,"Weight":0.1200,"GrossWeight":0.3300,"BoxWeight":13.8000,"BoxQuantity":40,"ProductL":9.6,"ProductW":9.6,"ProductH":2.0,"PackgeL":17.5,"PackgeW":10.0,"PackgeH":5.0,"BoxL":0.0,"BoxW":0.0,"BoxH":0.0,"HSCode":"","DeclareCName":"","DeclareEName":"","ProModel":"","ProMaterial":"","DeclareElement":"","DeclareApplication":""},"SkuInfos":[{"SrmSKU":580119941419077,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3931","CName":"H96Max M1plus RK3528 安卓14 机顶盒 2G+16G 欧规","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\":95,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":5,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE,FCC,UL,ROHS\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"1939\",\"PStocker\":\"2219\",\"Supplier\":\"V2540\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"机顶盒*1,高清线*1,蓝牙遥控器*1,说明书*1,适配器*1\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.1200,\"GrossWeight\":0.3300,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":9.6,\"ProductW\":9.6,\"ProductH\":2,\"PackgeL\":17.5,\"PackgeW\":10,\"PackgeH\":5,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"H96Max M1 Plus\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"},{"SrmSKU":580119941464133,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3932","CName":"H96Max M1plus RK3528 安卓14 机顶盒 4G+32G 欧规 ","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\":112,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":5,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE,FCC,UL,ROHS\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"1939\",\"PStocker\":\"2219\",\"Supplier\":\"V2540\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"机顶盒*1,高清线*1,蓝牙遥控器*1,说明书*1,适配器*1\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.1200,\"GrossWeight\":0.3300,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":9.6,\"ProductW\":9.6,\"ProductH\":2,\"PackgeL\":17.5,\"PackgeW\":10,\"PackgeH\":5,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"H96Max M1 Plus\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"},{"SrmSKU":580119941505093,"Color":"颜色","ColorCode":"1339","ColorValueCode":"3933","CName":"H96Max M1plus RK3528 安卓14 机顶盒 4G+128G 欧规","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\":155,\"PurchasePriceCurrency\":\"0001\",\"MinOrder\":1,\"DeliveryTime\":5,\"WarrantyPeriod\":0,\"WarrantyNote\":\"\",\"AfterSaleMethodId\":0,\"AfterSaleMethodNote\":null,\"CertificateIds\":\"CE,FCC,UL,ROHS\",\"QualityInspectionMethod\":\"\",\"PurchasePriceType\":0,\"PurchasePriceDeparture\":\"SZBT\",\"RStocker\":\"1939\",\"PStocker\":\"2219\",\"Supplier\":\"V2540\"}","ShipInfo":"{\"IsInsteadOfShipping\":false,\"PackageList\":\"机顶盒*1,高清线*1,蓝牙遥控器*1,说明书*1,适配器*1\",\"EAN\":null,\"WLEmbargoType\":100,\"Weight\":0.1200,\"GrossWeight\":0.3300,\"BoxWeight\":0,\"BoxQuantity\":0,\"ProductL\":9.6,\"ProductW\":9.6,\"ProductH\":2,\"PackgeL\":17.5,\"PackgeW\":10,\"PackgeH\":5,\"BoxL\":0,\"BoxW\":0,\"BoxH\":0,\"HSCode\":\"\",\"DeclareCName\":\"\",\"DeclareEName\":\"\",\"ProModel\":\"H96Max M1 Plus\",\"ProMaterial\":\"\",\"DeclareElement\":\"\",\"DeclareApplication\":\"\",\"ProductTypes\":2,\"PTGAssociatedValue\":11}"}],"SPUSKUPictureInfo":{"SPUPictureInfo":{"SPUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/07_99999999999_580131039072325.jpg"}],"SPUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/08(1)_99999999999_580131052765253.jpg"}]},"SKUPictureInfos":[{"SrmSKU":580119941419077,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/07_99999999999_580131039072325.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/08(1)_99999999999_580131052765253.jpg","ImgSort":0}]},{"SrmSKU":580119941464133,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/07_99999999999_580131039072325.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/08(1)_99999999999_580131052765253.jpg","ImgSort":0}]},{"SrmSKU":580119941505093,"SKUPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/07_99999999999_580131039072325.jpg","ImgSort":0}],"SKUDescriptionPictures":[{"PictureUrl":"https://gkb-erp-files.obs.cn-south-1.myhuaweicloud.com/srm/srmfiles/2025-06/08(1)_99999999999_580131052765253.jpg","ImgSort":0}]}]},"UserId":"2054"}]
2025/6/28 16:42:14 GetSPUId方法内部,CategoryCode:10,sql:
2025/6/28 16:42:14 GetSPUId获取到结果:SPUId:E002325,CategoryCode:10,connectionString:server=192.168.0.104,20190;database=PDSys;uid=prdproduser;pwd=Kamda@9091xmm;Max Pool Size=10000;Timeout=9999;Connect Timeout=9999,sql:
declare @CategoryShortCode varchar(5),
@Max varchar(6),
@NewMax varchar(6)
select @CategoryShortCode = CategoryShortCode from ServiceCenter.dbo.Category with(nolock) where CategoryID=@CategoryCode
select @Max=(case when MAX(SUBSTRING(SPUId,2,7)) is null then '000000' else MAX(SUBSTRING(SPUId,2,7)) end) from PDSYS.dbo.SPUBaseInfoV1 where SPUId like @CategoryShortCode+'%'
select @NewMax = right ( ('000000' + ltrim(rtrim(str(convert(int,@Max)+1))) ),6)
select (@CategoryShortCode + @NewMax) SPUId
2025/6/28 16:42:20 响应体:{"Status":200,"Result":",H96Max M1plus RK3528 安卓14 机顶盒操作成功","SuccessSPUSKUResponse":[{"SrmSPU":579772602642501,"ErpSPU":"E002325","SKURelations":[{"SrmSKU":"580119941419077","ErpSKU":"1294416"},{"SrmSKU":"580119941464133","ErpSKU":"1294417"},{"SrmSKU":"580119941505093","ErpSKU":"1294418"}],"Msg":null}],"FailSPUSKUResponse":[]}