/// <summary> /// 由一行数据得到一个实体 /// </summary> private Model.VolDisaInfo GetModel(DbDataReader dr) { Model.VolDisaInfo model = new Model.VolDisaInfo(); model.ID = DbHelperSQL.GetInt(dr["ID"]); model.TelNum = DbHelperSQL.GetString(dr["TelNum"]); model.VolName = DbHelperSQL.GetString(dr["VolName"]); model.Time = DbHelperSQL.GetDateTime(dr["Time"]); model.DisaType = DbHelperSQL.GetString(dr["DisaType"]); model.Describe = DbHelperSQL.GetString(dr["Describe"]); model.Photo = DbHelperSQL.GetString(dr["Photo"]); model.LAT = DbHelperSQL.GetDouble(dr["LAT"]); model.LON = DbHelperSQL.GetDouble(dr["LON"]); model.Location = DbHelperSQL.GetString(dr["Location"]); return(model); }
/// <summary> /// 得到一个对象实体 /// </summary> public Model.VolDisaInfo GetModel(int ID) { StringBuilder strSql = new StringBuilder(); strSql.Append("SELECT * FROM VolDisaInfo "); strSql.Append(" WHERE ID=" + ID); Model.VolDisaInfo model = null; using (DbDataReader dr = DbHelperSQL.ExecuteReader(strSql.ToString())) { while (dr.Read()) { model = GetModel(dr); } return(model); } }