新闻模块之新闻列表-使用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 try
11 {
12 art = db.Article.Where(a => a.ArticleId == articleId).First();
13 }
14 catch
15 {
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; //评论初始化为0
11 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 catch
15 {
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层-------------