/// <summary>
/// 由一行数据得到一个实体
/// </summary>
private Model.UAVTaskApply GetModel(DbDataReader dr)
{
Model.UAVTaskApply model = new Model.UAVTaskApply();
model.ID = DbHelperSQL.GetInt(dr["ID"]);
model.UID = DbHelperSQL.GetInt(dr["UID"]);
model.TID = DbHelperSQL.GetInt(dr["TID"]);
model.PID = DbHelperSQL.GetInt(dr["PID"]);
model.Describe = DbHelperSQL.GetString(dr["Describe"]);
model.TypeID = DbHelperSQL.GetString(dr["TypeID"]);
model.isHandled = DbHelperSQL.GetBool(dr["isHandled"]);
model.UAVTime = DbHelperSQL.GetString(dr["UAVTime"]);
return(model);
}
/// <summary>
/// 得到一个对象实体
/// </summary>
public Model.UAVTaskApply GetModel(int ID)
{
StringBuilder strSql = new StringBuilder();
strSql.Append("SELECT * FROM UAVTaskApply ");
strSql.Append(" WHERE ID=" + ID);
Model.UAVTaskApply model = null;
using (SqlDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString()))
{
while (dr.Read())
{
model = GetModel(dr);
}
return(model);
}
}
