public JsonResult DeleteDataDome()
{
try
{
var url = "http://192.168.3.122:8086/";
var username = "******";
var password = "******";
InfluxDBHelper influxDBHelper = new InfluxDBHelper(url, username, password, "testInfluxdb");
string sql = "delete from cpu_load_short where time=1537261373570440200; ";
var str = influxDBHelper.Query(sql);
return(Json(new
{
success = true,
message = "删除数据成功",
data = str
}));
}
catch (Exception ex)
{
return(Json(new
{
success = false,
message = "删除数据失败" + ex.Message,
}));
}
}
public JsonResult GetDataDome()
{
try
{
var url = "http://192.168.3.122:8086/";
var username = "******";
var password = "******";
InfluxDBHelper influxDBHelper = new InfluxDBHelper(url, username, password, "testInfluxdb");
string sql = "select * from cpu_load_short";
//string sql = "select * from test;select * from test"; 多条
var str = influxDBHelper.Query(sql);
return(Json(new
{
success = true,
message = "读取数据成功",
data = str
}));
}
catch (Exception ex)
{
return(Json(new
{
success = false,
message = "读取数据失败" + ex.Message,
}));
}
}
