public static ResourStateEntity parseState(List <string> devList) { ResourStateEntity stateEntity = null; try { stateEntity = new ResourStateEntity(); #region meta stateEntity.meta.eventType = "MJ_EQUINFO_UE"; stateEntity.meta.msgType = "EQU"; stateEntity.meta.receiver = ""; stateEntity.meta.recvSequence = ""; stateEntity.meta.recvTime = ""; stateEntity.meta.sender = "MJ"; stateEntity.meta.sendTime = DateTime.Now.ToString("yyyyMMddHHmmss"); stateEntity.meta.sequence = ""; #endregion #region body stateEntity.body.equCode = devList[1]; stateEntity.body.equName = devList[2]; stateEntity.body.resClassCode = "RC01"; stateEntity.body.resClassName = "安保资源"; stateEntity.body.airportIata = ConfigWorker.GetConfigValue("airportIata"); stateEntity.body.airportName = ConfigWorker.GetConfigValue("airportName"); #endregion } catch (Exception ex) { FileWorker.LogHelper.WriteLog("解析设备状态失败," + ex.Message); } return(stateEntity); }
/// <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); } }