数据层的数据处理。调用自定义的分页方法
public static IList<NewsEntity> ShowNewsList(string spname,int pagesize,ref int pagecount,ref int recordcount,SqlParameter[] para)
{
List<NewsEntity> list = new List<NewsEntity>();
DataTable dt = DBHelper.ExecuteReader(spname,pagesize,ref pagecount,ref recordcount,para);
foreach (DataRow dr in dt.Rows)
{
list.Add(ConvertToNewsEntity(dr));
}
return list;
}
实体对象,自行在数据库建立。表结构如下,实际运用。请自行设计数据库。实体信息根据表结构编写
private static NewsEntity ConvertToNewsEntity(DataRow dr)
{
NewsEntity ne = new NewsEntity();
ne.id = (int)dr["id"];
ne.cid=(int)dr["cid"];
ne.fid=(int)dr["fid"];
ne.title = (string)dr["title"];
ne.author = (string)dr["author"];
ne.keyword = (string)dr["keyword"];
ne.keydesc = (string)dr["keydesc"];
ne.content = (string)dr["content"];
ne.updatetimes = dr["updatetimes"].ToString();
ne.hits = (int)dr["hits"];
return ne;
}