public static NewsInfo Populate(IDataReader reader)
{
NewsInfo info = new NewsInfo();
for (int i = 0; i < reader.FieldCount; i++)
{
PropertyInfo property = info.GetType().GetProperty(reader.GetName(i));
Type propType = property.PropertyType;
TypeConverters.ITypeConverter typeConverter =
TypeConverters.TypeConverterFactory.GetConvertType(propType);
property.SetValue(info,
Convert.ChangeType(typeConverter.Convert(reader.GetValue(i)), propType), null);
}
return(info);
}
public List<NewsInfo> GetAllNews()
{
DataTable dt= SqlHelper.ExecuteDataTable("SELECT ID,title,[Date],people FROM dbo.HKSJ_Main", CommandType.Text);
List<NewsInfo> list = new List<NewsInfo>();
for (int i = 0; i < dt.Rows.Count; i++)
{
NewsInfo news = new NewsInfo();
news.ID = (Int32)dt.Rows[i]["ID"];
news.Title = dt.Rows[i]["title"] as string;
news.Date = DateTime.Parse(dt.Rows[i]["Date"].ToString());
news.People = dt.Rows[i]["people"] as string;
list.Add(news);
}
return list;
}
