测试成功,修改能运行代码--待优化
逻辑是怎样的?
主题逻辑是:1 写出一张主表,筛选出我们需要判断的用户。
2陆续添加一些监控字段,写入表内。获取观察
控奶新客
--删除清空表 DELETE FROM `0220数据统计`; --插入需要划分数据口径的主表 INSERT INTO `0220数据统计` ( -- 小票ID, 门店ID, 门店, 会员姓名, 手机号码, 控奶首购时间 ) SELECT * FROM ( SELECT -- A.id AS 小票ID, A.salesdepart_id AS 门店ID, B.`name` AS 门店, C.`name` AS 会员姓名, C.mobile AS 手机号码, MIN(D.create_date) AS 控奶首购时间 FROM arm_changsha.goods_sales AS A LEFT JOIN arm_changsha.sys_office AS B ON B.id = A.salesdepart_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = A.member_id LEFT JOIN arm_changsha.goods_sales_detail AS D ON D.sales_id = A.id LEFT JOIN arm_changsha.goods_base AS E ON E.id = D.goods_id WHERE A.sales_type = '1' AND C.mobile IS NOT NULL AND D.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) AND C.mobile NOT IN ( SELECT mobile FROM `7~9月英克系统消费客户统计` ) AND C.mobile IS NOT NULL GROUP BY C.mobile ) AS L WHERE `控奶首购时间` >= '2018-12-31 00:00:00' AND `控奶首购时间` <= '2019-01-06 23:59:59'; --更新计算字段控奶首购数量 UPDATE `0220数据统计` AS A SET A.`控奶首购数量` = ( SELECT SUM(B.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id LEFT JOIN arm_changsha.goods_base AS E ON E.id = B.goods_id WHERE C.mobile = A.`手机号码` AND B.create_date = A.`控奶首购时间` AND E.kind_id LIKE '01%' AND D.sales_type = '1' AND B.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); -- 更新控奶购买数量 -- 主表用户控奶数量购买 周期检测。 UPDATE `0220数据统计` AS A SET A.`T+7控奶购买数量` = ( SELECT SUM(B.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-01-20 23:59:59' AND D.sales_type = '1' AND B.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); UPDATE `0220数据统计` AS A SET A.`T+14控奶购买数量` = ( SELECT SUM(B.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-01-27 23:59:59' AND D.sales_type = '1' AND B.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); UPDATE `0220数据统计` AS A SET A.`T+21控奶购买数量` = ( SELECT SUM(B.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-02-04 23:59:59' AND D.sales_type = '1' AND B.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); UPDATE `0220数据统计` AS A SET A.`T+30控奶购买数量` = ( SELECT SUM(B.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-02-13 23:59:59' AND D.sales_type = '1' AND B.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); # 重点标注 -- 复购金额统计 -- 主表复购金额周期监控 UPDATE `0220数据统计` AS a SET a.`T+7复购金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = a.`手机号码` AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-01-20 23:59:59' AND b.sales_type = '1' -- GROUP BY -- b.member_id ); UPDATE `0220数据统计` AS a SET a.`T+14复购金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = a.`手机号码` AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-01-27 23:59:59' AND b.sales_type = '1' ); UPDATE `0220数据统计` AS a SET a.`T+21复购金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = a.`手机号码` AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-02-04 23:59:59' AND b.sales_type = '1' ); UPDATE `0220数据统计` AS a SET a.`T+30复购金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = a.`手机号码` AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-02-13 23:59:59' AND b.sales_type = '1' ); -- 小票统计 -- 主表用户小票周期检测,查询 UPDATE `0220数据统计` AS A SET A.`T+7小票数` = ( SELECT COUNT(DISTINCT B.sales_id) FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-01-20 23:59:59' AND D.sales_type = '1' ); UPDATE `0220数据统计` AS A SET A.`T+14小票数` = ( SELECT COUNT(DISTINCT B.sales_id) FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-01-27 23:59:59' AND D.sales_type = '1' ); UPDATE `0220数据统计` AS A SET A.`T+21小票数` = ( SELECT COUNT(DISTINCT B.sales_id) FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-02-04 23:59:59' AND D.sales_type = '1' ); UPDATE `0220数据统计` AS A SET A.`T+30小票数` = ( SELECT COUNT(DISTINCT B.sales_id) FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-02-13 23:59:59' AND D.sales_type = '1' ); -- 充值金额写入更新 UPDATE `0220数据统计` AS A SET A.`近90日充值金额` = ( SELECT ROUND( SUM(B.use_recharge_balance) / 1000, 2 ) AS 充值金额 FROM arm_changsha.ms_member_card_log AS B LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = B.member_id LEFT JOIN arm_changsha.ms_acct_book_def AS D ON D.member_id = B.member_id WHERE C.mobile = A.手机号码 AND D.acct_id IS NOT NULL AND B.oper_type IN ('4', '7', '8') AND B.create_date >= '2018-10-16 00:00:00' AND B.create_date <= '2019-01-13 23:59:59' ); -- 近90 日控奶购买数量更新写入 UPDATE `0220数据统计` AS a SET a.`近90日控奶购买数量` = ( SELECT sum(b.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS b LEFT JOIN arm_changsha.goods_sales AS d ON d.id = b.sales_id LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = d.member_id WHERE c.mobile = a.手机号码 AND b.create_date >= '2018-10-16 00:00:00' AND b.create_date <= '2019-01-13 23:59:59' AND d.sales_type = '1' AND b.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); #判断是否运营门店 UPDATE `0220数据统计` AS a SET a.`是否运营门店` = CASE WHEN a.门店ID IN ( '1008', '1016', '1025', '1026' ) THEN '是' ELSE '否' END; #判断是否稳定 UPDATE `0220数据统计` AS a SET a.`是否稳定` = CASE WHEN a.近90日控奶购买数量 >= '4' OR a.近90日充值金额 >= '500' THEN '是' ELSE '否' END; --查询表内数据,看是否成功 SELECT * FROM `0220数据统计`
控奶复购统计:
其实只要关注两部分, 1 主表是怎么关联的。 2 计算字段怎么添加的。
复购退货金额计算字段:
-- 退货金额 UPDATE `SAKURA-TEST` AS a SET a.`T+31退货金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = '13974182559' AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-02-13 23:59:59' AND b.sales_type = '2' -- 销售类型退货 );
DELETE FROM `0220数据统计复购`; #写入会员基本信息 INSERT INTO `0220数据统计复购` ( 门店ID, 门店, 会员姓名, 手机号码, 控奶首购时间 ) SELECT * FROM ( SELECT a.salesdepart_id AS 门店ID, b.`name` AS 门店, c.`name` AS 会员姓名, c.mobile AS 手机号码, MIN(d.create_date) AS `控奶首购时间` FROM arm_changsha.goods_sales AS a LEFT JOIN arm_changsha.sys_office AS b ON b.id = a.salesdepart_id LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = a.member_id LEFT JOIN arm_changsha.goods_sales_detail AS d ON d.sales_id = a.id LEFT JOIN arm_changsha.goods_base AS e ON e.id = d.goods_id WHERE a.sales_type = '1' AND c.mobile IS NOT NULL AND d.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) GROUP BY c.mobile ) AS L WHERE `控奶首购时间` >= '2018-12-08 00:00:00' AND `控奶首购时间` <= '2019-01-06 23:59:59'; #写入T-37至T-7内购买数量 UPDATE `0220数据统计复购` AS a SET a.`T-37至T-7内购买数量` = ( SELECT sum(b.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS b LEFT JOIN arm_changsha.goods_sales AS d ON d.id = b.sales_id LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = d.member_id WHERE c.mobile = a.手机号码 AND b.create_date >= '2018-12-08 00:00:00' AND b.create_date <= '2019-01-06 23:59:59' AND d.sales_type = '1' AND b.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); #写入T-14至T-7内购买数量 UPDATE `0220数据统计复购` AS a SET a.`T-14至T-7内购买数量` = ( SELECT sum(b.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS b LEFT JOIN arm_changsha.goods_sales AS d ON d.id = b.sales_id LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = d.member_id WHERE c.mobile = a.手机号码 AND b.create_date >= '2018-12-31 00:00:00' AND b.create_date <= '2019-01-06 23:59:59' AND d.sales_type = '1' AND b.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); #删除T-14至T-7期间未购用户 DELETE FROM `0220数据统计复购` WHERE `T-14至T-7内购买数量`IS NULL; #写入T+7控货奶粉购买数量 UPDATE `0220数据统计复购` AS a SET a.`T+7控奶购买数量` = ( SELECT sum(b.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS b LEFT JOIN arm_changsha.goods_sales AS d ON d.id = b.sales_id LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = d.member_id WHERE c.mobile = a.手机号码 AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-01-20 23:59:59' AND d.sales_type = '1' AND b.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); UPDATE `0220数据统计复购` AS A SET A.`T+14控奶购买数量` = ( SELECT SUM(B.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-01-27 23:59:59' AND D.sales_type = '1' AND B.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); UPDATE `0220数据统计复购` AS A SET A.`T+21控奶购买数量` = ( SELECT SUM(B.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-02-04 23:59:59' AND D.sales_type = '1' AND B.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); UPDATE `0220数据统计复购` AS A SET A.`T+30控奶购买数量` = ( SELECT SUM(B.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-02-13 23:59:59' AND D.sales_type = '1' AND B.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); -- 复购金额统计 UPDATE `0220数据统计复购` AS a SET a.`T+7复购金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = a.`手机号码` AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-01-20 23:59:59' AND b.sales_type = '1' -- GROUP BY -- b.member_id ); UPDATE `0220数据统计复购` AS a SET a.`T+14复购金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = a.`手机号码` AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-01-27 23:59:59' AND b.sales_type = '1' ); UPDATE `0220数据统计复购` AS a SET a.`T+21复购金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = a.`手机号码` AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-02-04 23:59:59' AND b.sales_type = '1' ); UPDATE `0220数据统计复购` AS a SET a.`T+30复购金额` = ( SELECT ROUND(SUM(b.real_pay) / 10000, 2) AS 累计消费金额 FROM arm_changsha.goods_sales AS b LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = b.member_id WHERE c.mobile = a.`手机号码` AND b.create_date >= '2019-01-14 00:00:00' AND b.create_date <= '2019-02-13 23:59:59' AND b.sales_type = '1' ); UPDATE `0220数据统计复购` AS A SET A.`T+7小票数` = ( SELECT COUNT(DISTINCT B.sales_id) FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-01-20 23:59:59' AND D.sales_type = '1' ); UPDATE `0220数据统计复购` AS A SET A.`T+14小票数` = ( SELECT COUNT(DISTINCT B.sales_id) FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-01-27 23:59:59' AND D.sales_type = '1' ); UPDATE `0220数据统计复购` AS A SET A.`T+21小票数` = ( SELECT COUNT(DISTINCT B.sales_id) FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-02-04 23:59:59' AND D.sales_type = '1' ); UPDATE `0220数据统计复购` AS A SET A.`T+30小票数` = ( SELECT COUNT(DISTINCT B.sales_id) FROM arm_changsha.goods_sales_detail AS B LEFT JOIN arm_changsha.goods_sales AS D ON D.id = B.sales_id LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = D.member_id WHERE C.mobile = A.`手机号码` AND B.create_date >= '2019-01-14 00:00:00' AND B.create_date <= '2019-02-13 23:59:59' AND D.sales_type = '1' ); UPDATE `0220数据统计复购` AS A SET A.`近90日充值金额` = ( SELECT ROUND( SUM(B.use_recharge_balance) / 1000, 2 ) AS 充值金额 FROM arm_changsha.ms_member_card_log AS B LEFT JOIN arm_changsha.ms_member_def AS C ON C.id = B.member_id LEFT JOIN arm_changsha.ms_acct_book_def AS D ON D.member_id = B.member_id WHERE C.mobile = A.手机号码 AND D.acct_id IS NOT NULL AND B.oper_type IN ('4', '7', '8') AND B.create_date >= '2018-10-16 00:00:00' AND B.create_date <= '2019-01-13 23:59:59' ); UPDATE `0220数据统计复购` AS a SET a.`近90日控奶购买数量` = ( SELECT sum(b.sales_number) AS 购买数量 FROM arm_changsha.goods_sales_detail AS b LEFT JOIN arm_changsha.goods_sales AS d ON d.id = b.sales_id LEFT JOIN arm_changsha.ms_member_def AS c ON c.id = d.member_id WHERE c.mobile = a.手机号码 AND b.create_date >= '2018-10-16 00:00:00' AND b.create_date <= '2019-01-13 23:59:59' AND d.sales_type = '1' AND b.barcode IN ( SELECT 条码 FROM `tmp_通货` WHERE 商品标签 = '非通货' AND 大类 LIKE '01%' ) ); UPDATE `0220数据统计复购` AS a SET a.`是否运营门店` = CASE WHEN a.门店ID IN ( '1008', '1016', '1025', '1026' ) THEN '是' ELSE '否' END; UPDATE `0220数据统计` AS a SET a.`是否稳定` = CASE WHEN a.近90日控奶购买数量 >= '4' OR a.近90日充值金额 >= '500' THEN '是' ELSE '否' END; SELECT * FROM `0220数据统计复购`;
【推荐】编程新体验,更懂你的AI,立即体验豆包MarsCode编程助手
【推荐】凌霞软件回馈社区,博客园 & 1Panel & Halo 联合会员上线
【推荐】抖音旗下AI助手豆包,你的智能百科全书,全免费不限次数
【推荐】轻量又高性能的 SSH 工具 IShell:AI 加持,快人一步
· 智能桌面机器人:用.NET IoT库控制舵机并多方法播放表情
· Linux glibc自带哈希表的用例及性能测试
· 深入理解 Mybatis 分库分表执行原理
· 如何打造一个高并发系统?
· .NET Core GC压缩(compact_phase)底层原理浅谈
· 手把手教你在本地部署DeepSeek R1,搭建web-ui ,建议收藏!
· 新年开篇:在本地部署DeepSeek大模型实现联网增强的AI应用
· Janus Pro:DeepSeek 开源革新,多模态 AI 的未来
· 互联网不景气了那就玩玩嵌入式吧,用纯.NET开发并制作一个智能桌面机器人(三):用.NET IoT库
· 【非技术】说说2024年我都干了些啥