新闻模块之新闻列表-使用datalist 模块获取数据-DAL类（Linq方式）

1 using System.Collections.Generic; 返回所有数据 1 /// <summary>2 /// 返回所有新闻3 /// </summary>4 /// <returns></returns>5 public IList<Article> GetAll()6 {7 DataClassesDataContext db = new DataClassesDataContext();8 return db.Article.ToList();9 }

 2. 通过articleId返回数据

1 /// <summary> 2 /// 根据articleId值返回数据值 3 /// </summary> 4 /// <param name="articleId"></param> 5 /// <returns></returns> 6 public Article GetNewInfo(int articleId) 7 { 8 DataClassesDataContext db = new DataClassesDataContext(); 9 Article art = null;10 try11 {12 art = db.Article.Where(a => a.ArticleId == articleId).First();13 }14 catch15 {16 17 }18 return art;19 }

 3.返回图片新闻

    通过ImgNews判断是否有图片新闻

1 /// <summary>2 /// 返回图片新闻3 /// </summary>4 /// <returns></returns>5 public IList<Article> GetImgNews()6 {7 DataClassesDataContext db = new DataClassesDataContext();8 return db.Article.Where(a => a.ImgNews == true).ToList();9 }

 4.添加新闻

1 /// <summary> 2 /// 添加新闻 3 /// </summary> 4 /// <param name="art"></param> 5 public void Add(Article art) 6 { 7 DataClassesDataContext db = new DataClassesDataContext(); 8 try 9 {10 art.RemarkNum = 0; //评论初始化为011 art.DateTime = DateTime.Now; //初始化当前时间12 db.Article.InsertOnSubmit(art);13 db.SubmitChanges();14 }15 catch { }16 }

 5.删除新闻

1 /// <summary> 2 /// 删除新闻 3 /// </summary> 4 /// <param name="id"></param> 5 public void Delete(int id) 6 { 7 DataClassesDataContext db = new DataClassesDataContext(); 8 try 9 {10 Article art = db.Article.Where(a => a.ArticleId == id).First();11 db.Article.DeleteOnSubmit(art);12 db.SubmitChanges();13 }14 catch15 {16 }17 }

6 修改新闻

1 /// <summary> 2 /// 修改新闻 3 /// </summary> 4 /// <param name="artdata"></param> 5 public void Edit(Article artdata) 6 { 7 DataClassesDataContext db = new DataClassesDataContext(); 8 try 9 {10 Article art = db.Article.Where(a => a.ArticleId == artdata.ArticleId).First();11 art.Content = artdata.Content;12 db.SubmitChanges();13 }14 catch { }15 }

--------查询新闻列表的页面表示层------------

--------查询单条新闻的页面表示层------------

--------查询图片新闻列表的页面表示层--------

--------添加新闻的页面表示层----------------

----------转到BLL层-------------

转载于:https://www.cnblogs.com/dzj007/archive/2012/01/22/2328715.html