/// <summary>
/// 根据ID获取新闻实体
/// </summary>
/// <param name="id">新闻ID</param>
/// <returns></returns>
public static News GetNews(int id)
{
using (var db = new en_scEntities())
{
return db.News.Single(n => n.Nid == id);
}
}
/// <summary>
/// 根据公告ID获取公告， 或者下载
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static ArticleWithAthmt GetBulltin(int id)
{
using (var db = new en_scEntities())
{
return db.ArticleWithAthmts.Single(a => a.Bid == id);
}
}
/// <summary>
/// 根据文章ID获取文章实体
/// </summary>
/// <param name="id"></param>
/// <returns></returns>
public static Article GetArticle(int id)
{
using (var db = new en_scEntities())
{
return db.Articles.Single(a => a.Aid == id);
}
}
/// <summary>
/// 删除新闻
/// </summary>
/// <param name="id">新闻ID</param>
/// <returns>操作状态</returns>
public static bool DelNews(int id)
{
try
{
using (var db = new en_scEntities())
{
db.News.DeleteObject(db.News.Single(n => n.Nid == id));
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 删除公告下载
/// </summary>
/// <param name="id">文章ID</param>
/// <returns>操作状态</returns>
public static bool DelBulletin(int id)
{
try
{
using (var db = new en_scEntities())
{
db.ArticleWithAthmts.DeleteObject(db.ArticleWithAthmts.Single(a => a.Bid == id));
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 添加新闻
/// </summary>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <returns></returns>
public static bool AddNews(string title, int cid, string author, string source, string content, bool ispic, bool isloop, string path, DateTime date)
{
DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff"));
try
{
string sql = "insert into News (Sid,Title,Author,Source,Content,PostTime,IsPicNews,IsLoopPicNews,PicNewsPath) values({0},{1},{2},{3},{4},{5},{6},{7},{8})";
using (var db = new en_scEntities())
{
db.ExecuteStoreCommand(sql, new object[] {cid, title, author, source, content, Date, ispic, isloop, path});
db.SaveChanges();
}
return true;
}
catch
{
return false;
throw;
}
}
/// <summary>
/// 添加公告、下载
/// </summary>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <returns></returns>
public static bool AddBulletin(string title, int cid, string content, string attachment, string filename, DateTime date)
{
DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff"));
try
{
string sql = "insert into ArticleWithAthmt (Sid,Title,Content,PostTime,Attachment,AttachmentName) values({0},{1},{2},{3},{4},{5})";
using (var db = new en_scEntities())
{
db.ExecuteStoreCommand(sql, new object[] { cid, title, content, Date, attachment, filename });
db.SaveChanges();
}
return true;
}
catch
{
return false;
throw;
}
}
/// <summary>
/// 分页获取总文章信息
/// </summary>
/// <param name="index">页码</param>
/// <param name="pagesize">页面大小</param>
/// <param name="count">总条目</param>
/// <returns></returns>
public static List<Article> GetPagedItems(int index, int pagesize, ref int count)
{
string sql = "select * from Article order by PostTIme desc limit {0} offset {1}";
using (var db = new en_scEntities())
{
count = db.Articles.Count();
return db.ExecuteStoreQuery<Article>(sql, new object[] { pagesize, (index - 1) * pagesize }).ToList();
}
}
/// <summary>
/// 通过分类ID与读取条数去取数据
/// </summary>
/// <param name="cid">分类ID,枚举Category</param>
/// <param name="top">条目</param>
/// <returns></returns>
public static List<ArticleWithAthmt> SelectArticleAttached(int cid, int top)
{
using (var db = new en_scEntities())
{
return db.ArticleWithAthmts.OrderByDescending(a => a.PostTime).Where(a => a.Sid == cid).Take(top).ToList();
}
}
/// <summary>
/// 修改文章
/// </summary>
/// <param name="id"></param>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <param name="attachment"></param>
/// <returns></returns>
public static bool UpdateBulletin(int id, string title, int cid, string content, string attachment, string filename, DateTime date)
{
DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff"));
try
{
using (var db = new en_scEntities())
{
var bulletin = db.ArticleWithAthmts.Single(a => a.Bid == id);
bulletin.Title = title;
bulletin.Content = content;
bulletin.Sid = cid;
bulletin.Attachment = attachment;
bulletin.AttachmentName = filename;
bulletin.PostTime = Date;
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 分页获取公告信息
/// </summary>
/// <param name="index">页码</param>
/// <param name="pagesize">页面大小</param>
/// <param name="pid">父类类别ID</param>
/// <param name="count">总条目</param>
/// <returns></returns>
public static List<ArticleWithAthmt> GetPagedItemsUsingParentType(int index, int pagesize, int pid, ref int count)
{
using (var db = new en_scEntities())
{
string strcid = "";
var list = db.SystemCategories.Where(s => s.ParentNo == pid).ToList();
if (list.Count > 0)
{
foreach (var item in list)
{
strcid += item.Sid + ",";
count += db.ArticleWithAthmts.Where(a => a.Sid == item.Sid).Count();
}
}
if (strcid.Length > 0)
{
strcid = strcid.Substring(0, strcid.Length - 1);
}
string sql = "select * from ArticleWithAthmt where Sid in (" + strcid +") order by PostTIme desc limit {0} offset {1}";
return db.ExecuteStoreQuery<ArticleWithAthmt>(sql, new object[] { pagesize, (index - 1) * pagesize }).OrderByDescending(n => n.PostTime).ToList();
}
}
/// <summary>
/// 分页获取公告信息
/// </summary>
/// <param name="pid">父类类别ID</param>
/// <returns></returns>
public static List<ArticleWithAthmt> GetTopItemsByParentId(int pid, int top)
{
using (var db = new en_scEntities())
{
string strcid = "";
var list = db.SystemCategories.Where(s => s.ParentNo == pid).ToList();
if (list.Count > 0)
{
foreach (var item in list)
{
strcid += item.Sid + ",";
}
}
if (strcid.Length > 0)
{
strcid = strcid.Substring(0, strcid.Length - 1);
}
string sql = "select * from ArticleWithAthmt where Sid in (" + strcid + ") order by PostTIme desc";
return db.ExecuteStoreQuery<ArticleWithAthmt>(sql, new object[] { }).Take(top).OrderByDescending(n => n.PostTime).ToList();
}
}
/// <summary>
/// 所有新闻中，筛选出焦点图新闻、一般图片新闻
/// </summary>
/// <param name="cid">分类:0->焦点图新闻; other->图片新闻</param>
/// <param name="top">选出的数目</param>
/// <returns></returns>
public static List<News> GetTopPicNews(int cid, int top)
{
List<News> news = new List<News>();
using (var db = new en_scEntities())
{
if (cid == 0)
{
news = db.News.Where(n => n.IsPicNews == true).OrderByDescending(n => n.PostTime).Take(top).ToList();
}
else
{
news = db.News.Where(n => n.IsLoopPicNews == true).OrderByDescending(n => n.PostTime).Take(top).ToList();
}
}
return news;
}
/// <summary>
/// 所有新闻中，筛选出焦点图新闻、一般图片新闻
/// </summary>
/// <param name="top">选出的数目</param>
/// <returns></returns>
public static List<News> GetTopPicNews(int top)
{
List<News> news = new List<News>();
using (var db = new en_scEntities())
{
news = db.News.OrderByDescending(n => n.PostTime).Take(top).ToList();
}
return news;
}
/// <summary>
/// 修改新闻
/// </summary>
/// <param name="id"></param>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <param name="ispic"></param>
/// <param name="isloop"></param>
/// <param name="path"></param>
/// <returns></returns>
public static bool UpdateNews(int id, string title, int cid, string author, string source, string content, bool ispic, bool isloop, string path, DateTime date)
{
DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff"));
try
{
using (var db = new en_scEntities())
{
var news = db.News.Single(n => n.Nid == id);
news.Title = title;
news.Content = content;
news.Sid = cid;
news.Author = author;
news.Source = source;
news.IsPicNews = ispic;
news.IsLoopPicNews = isloop;
news.PicNewsPath = path;
news.PostTime = Date;
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
public List<CenterPortal.Model.Post> GetTopDesc(int cid, int top)
{
List<CenterPortal.Model.Post> posts = new List<CenterPortal.Model.Post>();
using (var db = new en_scEntities())
{
var list = db.ArticleWithAthmts.Where(a => a.Sid == cid).OrderByDescending(n => n.PostTime).Take(top).ToList();
if (list != null && list.Count > 0)
{
foreach (var item in list)
{
posts.Add(new CenterPortal.Model.Post
{
Pid = item.Bid,
Title = item.Title,
PostTime = item.PostTime.ToString("yyyy-MM-dd")
});
}
}
return posts;
}
}
public List<CenterPortal.Model.Post> GetTop(int cid, int top)
{
List<CenterPortal.Model.Post> posts = new List<CenterPortal.Model.Post>();
using (var db = new en_scEntities())
{
var list = db.News.Where(n => n.Sid == cid).Take(top).ToList();
if (list != null && list.Count > 0)
{
foreach (var item in list)
{
posts.Add(new CenterPortal.Model.Post{
Pid = item.Nid,
Title = item.Title,
PostTime = item.PostTime.ToString("yyyy-MM-dd"),
PicPath = item.PicNewsPath
});
}
}
return posts;
}
}
/// <summary>
/// 通过文章分类，获取最新一篇
/// </summary>
/// <param name="cid">分类ID</param>
/// <returns></returns>
public static Article GetSingleArticle(int cid)
{
using (var db = new en_scEntities())
{
try
{
return db.Articles.Where(a => a.Sid == cid).OrderByDescending(a => a.PostTime).ToList()[0];
}
catch
{
return null;
}
}
}
/// <summary>
/// 修改文章
/// </summary>
/// <param name="id"></param>
/// <param name="title"></param>
/// <param name="cid"></param>
/// <param name="content"></param>
/// <returns></returns>
public static bool UpdateArticle(int id, string title, int cid, string content, DateTime date)
{
DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff"));
try
{
using (var db = new en_scEntities())
{
var news = db.Articles.Single(a => a.Aid == id);
news.Title = title;
news.Content = content;
news.Sid = cid;
news.PostTime = Date;
db.SaveChanges();
}
return true;
}
catch
{
return false;
}
}
/// <summary>
/// 分页获取公告信息
/// </summary>
/// <param name="index">页码</param>
/// <param name="pagesize">页面大小</param>
/// <param name="cid">类别ID</param>
/// <param name="count">总条目</param>
/// <returns></returns>
public static List<ArticleWithAthmt> GetPagedItems(int index, int pagesize, int cid, ref int count)
{
string sql = "select * from ArticleWithAthmt where Sid={0} order by PostTIme desc limit {1} offset {2}";
using (var db = new en_scEntities())
{
count = db.ArticleWithAthmts.Where(n => n.Sid == cid).Count();
return db.ExecuteStoreQuery<ArticleWithAthmt>(sql, new object[] { cid, pagesize, (index - 1) * pagesize }).OrderByDescending(n => n.PostTime).ToList();
}
}
/// <summary>
/// 分页获取新闻信息
/// </summary>
/// <param name="index">页码</param>
/// <param name="pagesize">页面大小</param>
/// <param name="count">总条目</param>
/// <returns></returns>
public static List<News> GetPagedNews(int index, int pagesize, ref int count)
{
string sql = "select * from News order by PostTIme desc limit {0} offset {1}";
using (var db = new en_scEntities())
{
count = db.News.Count();
return db.ExecuteStoreQuery<News>(sql, new object[] { pagesize, (index - 1) * pagesize }).OrderByDescending(n => n.PostTime).ToList();
}
}
