- post提交 curl -X POST http://localhost:59190/Caiot/System -d "{\"FAction\": \"QueryUKnowledgeBase\", \"FTitle\": \"变压器通讯中断\", \"FTokenID\": \"90b23c7f-74de-4910-8386-b9e0908b7d73\", \"FVersion\": \"1.0.0\", \"ProjectID\": 1}" -H "Content-Type: application/json"
-
sql 查询拼接命令 SELECT CONCAT('curl -X POST http://localhost:59190/Caiot/System -d ','"{\"FAction\": \"QueryUKnowledgeBase\", \"FTitle\": \"',CONCAT(DeviceTypeName,AlarmTypeName),'\", \"FTokenID\": \"90b23c7f-74de-4910-8386-b9e0908b7d73\", \"FVersion\": \"1.0.0\", \"ProjectID\": 1}"',' -H "Content-Type: application/json"') FROM dbo.SDeviceType
LEFT JOIN dbo.SAlarmType ON 1=1 - cmd 复制命令执行