internal static int InsertNewJson(OnLineInfo info)
{
string newjosn = GetNewJson();
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
int i = 0;
if (string.IsNullOrEmpty(newjosn))
{
i = cn.Execute(@"insert into " + database1 + @".OnLineInfo values(@CreateTime,@OnLineInfoJson)", new OnLineInfo {
CreateTime = info.CreateTime, OnLineInfoJson = info.OnLineInfoJson
});
}
else
{
i = cn.Execute(@"
insert into " + database1 + @".OnLineInfo values(@CreateTime,@OnLineInfoJson);
delete from " + database1 + @".OnLineInfo where CreateTime!=@CreateTime;
", new OnLineInfo {
CreateTime = info.CreateTime, OnLineInfoJson = info.OnLineInfoJson
});
}
cn.Close();
return(i);
}
}
/// <summary>
/// 设备是否在线
/// </summary>
/// <returns></returns>
public string isOnline()
{
try
{
Dictionary <String, String> parameters = new Dictionary <String, String>();
parameters.Add("t_id", ConfigurationManager.AppSettings["MechineNo"]);
string jsonText = HttpHelper.getHttp(SysConfigHelper.readerNode("findOnlineStatus"), parameters, null);
//反序列化JSON字符串,将JSON字符串转换成LIST列表
OnLineInfo info = JsonConvert.DeserializeObject <OnLineInfo>(jsonText);
if (info != null)
{
if (info.data != null)
{
if (info.data.online)
{
return("在线");
}
}
}
return("离线");
}catch (Exception ex)
{
log.Write("error:isOnline:" + ex.Message);
return("离线");
}
}
internal static string GetNewJson()
{
using (var cn = new MySqlConnection(sqlconnectionString))
{
cn.Open();
IEnumerable <OnLineInfo> i = cn.Query <OnLineInfo>(@"select CreateTime,OnLineInfoJson from " + database1 + @".OnLineInfo order by createTime DESC limit 0,1");
cn.Close();
OnLineInfo o = i.FirstOrDefault();
if (o == null)
{
return("");
}
else
{
return(o.OnLineInfoJson);
}
}
}
public static int InsertNewJson(OnLineInfo info)
{
return(OnLineInfoDAL.InsertNewJson(info));
}
