C# 物联网开发API接口系列(四)
#久爱物联网#MQTT#
【提纲】
1)获取设备列表(某用户的)
2)单独检查设备是否存在合法
【正文】
/// /// 获取设备列表 /// /// 令牌 /// private string getDevList(string _token) { string result = ""; int listnum = 0; StringBuilder sb = new StringBuilder(); try { if (SqlHelper.isConnected) { SqlConnection SqlConn = new SqlConnection(SqlHelper.ConnString); if (SqlConn.State != ConnectionState.Connecting) { SqlConn.Open();// 打开数据库连接 } //注意:参数是token查询用的是 uid 之前有一方法已经调用了 uid = getUidbyToken(token); SqlCommand sqlCmd = new SqlCommand("SELECT * FROM box_List WHERE bForUid=" + uid, SqlConn); SqlDataReader rd = sqlCmd.ExecuteReader();//返回的是记录集 if (rd.HasRows) { while (rd.Read()) { listnum++; sb.AppendFormat("{" + string.Format(""regpacket":"{0}","boxname":"{1}","actived":{2}", rd["bRegpacket"].ToString(), rd["bName"].ToString(),Convert.ToInt16(rd["bStatus"])) + "}");//可继续扩展其他属性 sb.AppendFormat(",");//最后一条需要处理此符