/// <summary> /// 定时查询数据 /// </summary> public void cyclicWork() { string strConn = ConfigWorker.GetConfigValue("connectString"); //strConn = "server=127.0.0.1;database=CEMData;uid=sa;pwd=qq.123456"; string tableName = ConfigWorker.GetConfigValue("devTableName"); string sql = string.Format("select DoorID,dev_addr,DoorName from {0} ", tableName); FileWorker.LogHelper.WriteLog("定时查询设备信息"); try { DataSet ds = null; using (SqlDataAdapter da = new SqlDataAdapter(sql, strConn)) { ds = new DataSet(); da.Fill(ds); } foreach (DataRow item in ds.Tables[0].Rows) { List <string> devList = new List <string>(); devList.Add(item.ItemArray[0].ToString()); devList.Add(item.ItemArray[1].ToString()); devList.Add(item.ItemArray[2].ToString()); ResourStateEntity accessEnt = StateParseTool.parseState(devList); string jsonMess = accessEnt.toJson(); KafkaWorker.sendDeviceMessage(jsonMess); } } catch (Exception e) { FileWorker.LogHelper.WriteLog("解析设备信息表失败:" + e.Message); } }