/// <summary>
/// 得到一个对象实体
/// </summary>
public Models.Fingerprint GetModel(int id)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("select top 1 id,coord,memory,flag,addtime");
strSql.Append(" from tb_wifi_fingerprint");
strSql.Append(" where id=@id");
SqlParameter[] parameters =
{
new SqlParameter("@id", SqlDbType.Int, 4)
};
parameters[0].Value = id;
Models.Fingerprint model = new Models.Fingerprint();
DataSet ds = DbHelperSQL.Query(strSql.ToString(), parameters);
if (ds.Tables[0].Rows.Count > 0)
{
return(DataRowToModel(ds.Tables[0].Rows[0]));
}
else
{
return(null);
}
}
///<summary>
/// 将对象转换为实体
/// </summary>
private Models.Fingerprint DataRowToModel(DataRow row)
{
Models.Fingerprint model = new Models.Fingerprint();
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["flag"] != null && row["flag"].ToString() != "")
{
model.flag = Int32.Parse(row["flag"].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();
}
}
return(model);
}
/// <summary>
/// 增加一条数据
/// </summary>
public int Add(Models.Fingerprint model)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("insert into tb_wifi_fingerprint(coord,memory,flag,addtime)");
strSql.Append(" values (@coord,@memory,@flag,@addtime);select @@IDENTITY");
SqlParameter[] parameters =
{
new SqlParameter("@coord", SqlDbType.VarChar, 10),
new SqlParameter("@memory", SqlDbType.VarChar),
new SqlParameter("@flag", SqlDbType.Int),
new SqlParameter("@addtime", SqlDbType.VarChar, 50)
};
parameters[0].Value = model.coord;
parameters[1].Value = model.memory;
parameters[2].Value = model.flag;
parameters[3].Value = model.addtime;
object obj = DbHelperSQL.GetSingle(strSql.ToString(), parameters);
model.id = Convert.ToInt32(obj);
return(model.id);
}
// 处理json数据 执行插入操作
private int addJsonDataToDB(JObject value)
{
int flag = 0;
Models.Fingerprint model_finger = new Models.Fingerprint();
try
{
model_finger.coord = value["coord"].ToString();
model_finger.memory = value["memory"].ToString();
model_finger.addtime = value["addtime"].ToString();
model_finger.flag = Int32.Parse(value["flag"].ToString());
}
catch (Exception e)
{
return(4);
}
int coord_id = db_fingerprint.Add(model_finger);
// 插入各个AP的rssi数据
if (coord_id > 0)
{
Models.Rssi model_rssi = new Models.Rssi();
JToken ap = new JObject();
model_rssi.coord_id = coord_id;
model_rssi.room_id = int.Parse(value["room_id"].ToString());
try
{
model_rssi.mobile_id = Int32.Parse(value["mobile_id"].ToString());
ap = value["ap"];
}
catch (Exception e)
{
return(4);
}
if (ap.Count() > 0)
{
IEnumerable <JToken> temp = ap.Values();
foreach (var item in temp)
{
try
{
model_rssi.rssi = Int32.Parse(item["rssi"].ToString());
model_rssi.mac = item["mac"].ToString();
}
catch (Exception e)
{
return(4);
}
if (!db_rssi.Add(model_rssi))
{
flag = 1;
continue;
}
}
}
else
{
flag = 2;
}
}
else
{
flag = 3;
}
return(flag);
}
/// <summary>
/// 更新一条数据
/// </summary>
public bool Update(Models.Fingerprint model)
{
return(true);
}
