获取SMS输入并从SQL中选择数据 [英] Get SMS input and select data form SQL

问题描述

我有一张这样的桌子。



日期| Traveller_ID |旅行距离

-------------------------------------

2015-12-12 | 34253 | 2344km

2015-12-12 | 32535 | 2344km

2015-12-12 | 35343 | 2344km

2015-12-13 | 34253 | 12km

2015-12-14 | 34253 | 323km

2015-12-15 | 34253 | 244km

I have a table like this.

Date | Traveller_ID | Distance Travelled
-------------------------------------
2015-12-12 | 34253 | 2344km
2015-12-12 | 32535 | 2344km
2015-12-12 | 35343 | 2344km
2015-12-13 | 34253 | 12km
2015-12-14 | 34253 | 323km
2015-12-15 | 34253 | 244km

What I need to do is when I send a SMS saying 'TravellerID<space>date' (eg: 34235 2015-12-12) to the telephone number of the PDU modem connected 
(PDU is used in C#) it should send a reply SMS saying 'Distance is 2344 km' .

How to do this?

推荐答案

使用AT命令通过GSM调制解调器发送和读取SMS [ ^ ]

这篇关于获取SMS输入并从SQL中选择数据的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！