/// <summary> /// 获取泛型数据列表 /// </summary> public List <Model.UAVRoadAcc> GetList() { StringBuilder strSql = new StringBuilder("SELECT * FROM V_UAVRoadAcc"); using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { List <Model.UAVRoadAcc> lst = new List <Model.UAVRoadAcc>(); while (dr.Read()) { Model.UAVRoadAcc model = new Model.UAVRoadAcc(); model.ID = DbHelperSQL.GetInt(dr["ID"]); model.UID = DbHelperSQL.GetInt(dr["UID"]); model.UAVTel = DbHelperSQL.GetString(dr["UAVTel"]); model.TypeID = DbHelperSQL.GetString(dr["TypeID"]); model.UAVRepair = DbHelperSQL.GetString(dr["UAVRepair"]); model.UAVDescribe = DbHelperSQL.GetString(dr["UAVDescribe"]); model.UAVTime = DbHelperSQL.GetString(dr["UAVTime"]); model.isChecked = DbHelperSQL.GetBool(dr["isChecked"]); model.LAT = DbHelperSQL.GetDouble(dr["Latitude"]); model.LON = DbHelperSQL.GetDouble(dr["Longitude"]); model.UAVName = DbHelperSQL.GetString(dr["UAVName"]); model.Destination = DbHelperSQL.GetString(dr["TID"]); model.Time = DbHelperSQL.GetString(dr["Time"]); model.PID = DbHelperSQL.GetInt(dr["PID"]); model.isHandled = DbHelperSQL.GetBool(dr["isHandled"]); lst.Add(model); } return(lst); } }
/// <summary> /// 得到最新的一个对象 /// </summary> public Model.UAVRoadAcc GetTopModel(int DID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT TOP 1 * FROM [V_UAVRoadAcc] WHERE DID=" + DID + " ORDER BY UAVTime DESC "); Model.UAVRoadAcc model = null; using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr); } return(model); } }
/// <summary> /// 获取最近两条数据 /// </summary> public List <Model.UAVRoadAcc> GetTopList(int uid) { StringBuilder strSql = new StringBuilder("select top 1 [TID] from [dbo].[UAVRoadAcc] where UID=" + uid + " order by UAVTime desc"); using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { List <Model.UAVRoadAcc> lst = new List <Model.UAVRoadAcc>(); while (dr.Read()) { Model.UAVRoadAcc model = new Model.UAVRoadAcc(); model.Destination = DbHelperSQL.GetString(dr["TID"]); lst.Add(model); } return(lst); } }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.UAVRoadAcc GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM UAVRoadAcc "); strSql.Append(" WHERE ID=" + ID); Model.UAVRoadAcc model = null; using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr); } return(model); } }
/// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.UAVRoadAcc GetModel(DbDataReader dr) { Model.UAVRoadAcc model = new Model.UAVRoadAcc(); model.ID = DbHelperSQL.GetInt(dr["ID"]); model.UID = DbHelperSQL.GetInt(dr["UID"]); model.UAVTel = DbHelperSQL.GetString(dr["UAVTel"]); model.TypeID = DbHelperSQL.GetString(dr["TypeID"]); model.UAVRepair = DbHelperSQL.GetString(dr["UAVRepair"]); model.UAVDescribe = DbHelperSQL.GetString(dr["UAVDescribe"]); model.UAVTime = DbHelperSQL.GetString(dr["UAVTime"]); model.isChecked = DbHelperSQL.GetBool(dr["isChecked"]); model.LAT = DbHelperSQL.GetDouble(dr["Latitude"]); model.LON = DbHelperSQL.GetDouble(dr["Longitude"]); model.Destination = DbHelperSQL.GetString(dr["TID"]); model.Time = DbHelperSQL.GetString(dr["Time"]); model.PID = DbHelperSQL.GetInt(dr["PID"]); model.isHandled = DbHelperSQL.GetBool(dr["isHandled"]); return(model); }