/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.UAVTeam GetModel(DbDataReader dr)
{
Model.UAVTeam model = new Model.UAVTeam();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.ManagerName = DbHelperSQL.GetString(dr["ManagerName"]);
model.CompanyName = DbHelperSQL.GetString(dr["CompanyName"]);
model.TeamName = DbHelperSQL.GetString(dr["TeamName"]);
model.CountNumber = DbHelperSQL.GetInt(dr["CountNumber"]);
model.UAVModel = DbHelperSQL.GetString(dr["UAVModel"]);
model.XLongtitude = DbHelperSQL.GetDouble(dr["XLongtitude"]);
model.YLatitude = DbHelperSQL.GetDouble(dr["YLatitude"]);
model.UpdateTime = DbHelperSQL.GetDateTime(dr["UpdateTime"]);
model.MobileNumber = DbHelperSQL.GetString(dr["MobileNumber"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.UAVTeam GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM UAVTeam ");
strSql.Append(" WHERE ID=" + ID);
Model.UAVTeam model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}