/// <summary> /// 获得数据列表 /// </summary> /// <param name="strWhere">条件</param> /// <returns>News集合</returns> public List <ClassLibrary.Model.News> GetModelList(DataTable dt) { List <ClassLibrary.Model.News> modelList = new List <ClassLibrary.Model.News>(); int rowsCount = dt.Rows.Count; if (rowsCount > 0) { ClassLibrary.Model.News model; for (int n = 0; n < rowsCount; n++) { model = new ClassLibrary.Model.News(); if (dt.Rows[n]["ID"] != DBNull.Value) { model.ID = Convert.ToInt32(dt.Rows[n]["ID"]); } if (dt.Rows[n]["newsClassID"] != DBNull.Value) { model.newsClassID = Convert.ToInt32(dt.Rows[n]["newsClassID"]); } if (dt.Rows[n]["routeClassID"] != DBNull.Value) { model.routeClassID = Convert.ToString(dt.Rows[n]["routeClassID"]); } if (dt.Rows[n]["Title"] != DBNull.Value) { model.Title = Convert.ToString(dt.Rows[n]["Title"]); } if (dt.Rows[n]["Editor"] != DBNull.Value) { model.Editor = Convert.ToString(dt.Rows[n]["Editor"]); } if (dt.Rows[n]["Source"] != DBNull.Value) { model.Source = Convert.ToString(dt.Rows[n]["Source"]); } if (dt.Rows[n]["ViewCount"] != DBNull.Value) { model.ViewCount = Convert.ToInt32(dt.Rows[n]["ViewCount"]); } if (dt.Rows[n]["Image"] != DBNull.Value) { model.Image = Convert.ToString(dt.Rows[n]["Image"]); } if (dt.Rows[n]["Content"] != DBNull.Value) { model.Content = Convert.ToString(dt.Rows[n]["Content"]); } if (dt.Rows[n]["CreatedTime"] != DBNull.Value) { model.CreatedTime = Convert.ToDateTime(dt.Rows[n]["CreatedTime"]); } if (dt.Rows[n]["Ntag"] != DBNull.Value) { model.Ntag = Convert.ToString(dt.Rows[n]["Ntag"]); } if (dt.Rows[n]["seoKeyword"] != DBNull.Value) { model.Keywords = Convert.ToString(dt.Rows[n]["seoKeyword"]); } if (dt.Rows[n]["seoDescription"] != DBNull.Value) { model.Description = Convert.ToString(dt.Rows[n]["seoDescription"]); } if (dt.Rows[n]["IsDisplay"] != DBNull.Value) { model.Display = Convert.ToBoolean(dt.Rows[n]["IsDisplay"]); } if (dt.Rows[n]["LocationID"] != DBNull.Value) { model.LocationID = Convert.ToInt32(dt.Rows[n]["LocationID"]); } if (dt.Rows[n]["IsSanxia"] != DBNull.Value) { model.IsSanxia = Convert.ToBoolean(dt.Rows[n]["IsSanxia"]); } if (dt.Rows[n]["ZanCount"] != DBNull.Value) { model.ZanCount = Convert.ToInt32(dt.Rows[n]["ZanCount"]); } modelList.Add(model); } } return(modelList); }
/// <summary> /// 增加一条数据 /// </summary> /// <param name="model">model对象</param> public int Add(ClassLibrary.Model.News model) { return(dal.Add(model)); }
/// <summary> /// 更新一条数据 /// </summary> /// <param name="model">model对象</param> /// <returns>影响行数</returns> public int Update(ClassLibrary.Model.News model) { return(dal.Update(model)); }