/// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.V_VolLifeLine GetModel(DbDataReader dr) { Model.V_VolLifeLine model = new Model.V_VolLifeLine(); model.ID = DbHelperSQL.GetInt(dr["ID"]); model.Tel = DbHelperSQL.GetString(dr["Tel"]); model.StartStr = DbHelperSQL.GetString(dr["StartStr"]); model.EndStr = DbHelperSQL.GetString(dr["EndStr"]); model.Describe = DbHelperSQL.GetString(dr["Describe"]); model.RoadPoint = DbHelperSQL.GetString(dr["RoadPoint"]); model.IsChecked = DbHelperSQL.GetString(dr["IsChecked"]); model.Type = DbHelperSQL.GetString(dr["Type"]); model.RealName = DbHelperSQL.GetString(dr["RealName"]); model.Time = DbHelperSQL.GetString(dr["Time"]); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.V_VolLifeLine GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM V_VolLifeLine "); strSql.Append(" WHERE ID=" + ID); Model.V_VolLifeLine model = null; using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr); } return(model); } }