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);
}
}
