/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Models.data_test model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_sensor_wifi_test(coord,memory,addtime,rssi,flag)");
strSql.Append(" values (@coord,@memory,@addtime,@rssi,@flag)");
SqlParameter[] parameters =
{
new SqlParameter("@coord", SqlDbType.VarChar),
new SqlParameter("@memory", SqlDbType.VarChar),
new SqlParameter("@addtime", SqlDbType.VarChar, 50),
new SqlParameter("@rssi", SqlDbType.Int, 4),
new SqlParameter("@flag", SqlDbType.Int, 4)
};
parameters[0].Value = model.coord;
parameters[1].Value = model.memory;
parameters[2].Value = model.addtime;
parameters[3].Value = model.rssi;
parameters[4].Value = model.flag;
object obj = DbHelperSQL.ExecuteSql(strSql.ToString(), parameters);
model.id = Convert.ToInt32(obj);
return(model.id);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.data_test GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,coord,actual_coord,memory,addtime,rssi,flag");
strSql.Append(" from tb_sensor_wifi_test");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Models.data_test model = new Models.data_test();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
public Models.data_test GetById(int id)
{
Models.data_test model = db.GetModel(id);
var response = Request.CreateResponse();
if (model != null)
{
response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent(model.ToString(), Encoding.Unicode);
}
else
{
response = Request.CreateResponse(HttpStatusCode.NotFound);
response.Content = new StringContent("{\"message\":\"无该资源\"}", Encoding.Unicode);
}
return(model);
}
///<summary>
/// 将对象转换为实体
/// </summary>
private Models.data_test DataRowToModel(DataRow row)
{
Models.data_test model = new Models.data_test();
if (row != null)
{
if (row["id"] != null && row["id"].ToString() != "")
{
model.id = int.Parse(row["id"].ToString());
}
if (row["coord"] != null && row["coord"].ToString() != "")
{
model.coord = row["coord"].ToString();
}
if (row["actual_coord"] != null && row["actual_coord"].ToString() != "")
{
model.coord = row["actual_coord"].ToString();
}
if (row["memory"] != null && row["memory"].ToString() != "")
{
model.memory = row["memory"].ToString();
}
if (row["addtime"] != null && row["addtime"].ToString() != "")
{
model.addtime = row["addtime"].ToString();
}
if (row["rssi"] != null && row["rssi"].ToString() != "")
{
model.rssi = Int32.Parse(row["rssi"].ToString());
}
if (row["flag"] != null && row["flag"].ToString() != "")
{
model.flag = Int32.Parse(row["flag"].ToString());
}
}
return(model);
}
// POST /api/DataTest/
public HttpResponseMessage Post([FromBody] Models.data_test model)
{
var response = Request.CreateResponse();
if (model != null)
{
if (db.Add(model) > 0)
{
response = Request.CreateResponse(HttpStatusCode.OK);
response.Content = new StringContent("{\"message\":\"添加成功\"}", Encoding.UTF8);
}
else
{
response = Request.CreateResponse(HttpStatusCode.InternalServerError);
response.Content = new StringContent("{\"message\":\"发生未知错误\"}", Encoding.UTF8);
}
}
else
{
response = Request.CreateResponse(HttpStatusCode.BadRequest);
response.Content = new StringContent("{\"message\":\"post数据为空\"}", Encoding.Unicode);
}
return(response);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Models.data_test model)
{
return(true);
}
