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