/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.UAVGPSInfor GetModel(DbDataReader dr)
{
Model.UAVGPSInfor model = new Model.UAVGPSInfor();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.UID = DbHelperSQL.GetInt(dr["UID"]);
model.GPSTel = DbHelperSQL.GetString(dr["GPSTel"]);
model.GPSLatitude = DbHelperSQL.GetString(dr["GPSLatitude"]);
model.GPSLongitude = DbHelperSQL.GetString(dr["GPSLongitude"]);
model.GPSTime = DbHelperSQL.GetString(dr["GPSTime"]);
model.Name = DbHelperSQL.GetString(dr["Name"]);
//model.isChecked = DbHelperSQL.GetBool(dr["isChecked"]);
return(model);
}
/// <summary>
/// 得到一个最新的一个对象实体
/// </summary>
public Model.UAVGPSInfor GetTopModel()
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT TOP 1 * FROM V_UAVGPSInfor order by GPSTime desc");
Model.UAVGPSInfor model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.UAVGPSInfor GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM V_UAVGPSInfor ");
strSql.Append(" WHERE ID=" + ID);
Model.UAVGPSInfor model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
