/// <summary> /// 根据文章ID获取文章实体 /// </summary> /// <param name="id"></param> /// <returns></returns> public static Article GetArticle(int id) { using (var db = new SCenterEntities()) { return db.Articles.Single(a => a.Aid == id); } }
/// <summary> /// 添加人员 /// </summary> /// <param name="name"></param> /// <param name="cid"></param> /// <param name="intro"></param> /// <param name="path">头像</param> /// <returns></returns> public static bool AddBStaff(string name, int cid, string intro, string path) { try { string sql = "insert into Member (Sid,Name,Introduction,Photo) values({0},{1},{2},{3})"; using (var db = new SCenterEntities()) { db.ExecuteStoreCommand(sql, new object[] { cid, name, intro, path }); //Rank初始化 List<Member> list = db.Members.Where(m => m.Rank == null).ToList(); if (list != null && list.Count >0) { foreach (var item in list) { item.Rank = item.Mid; } } db.SaveChanges(); } return true; } catch { return false; } }
/// <summary> /// 根据公告ID获取公告, 或者下载 /// </summary> /// <param name="id"></param> /// <returns></returns> public static ArticleWithAthmt GetBulltin(int id) { using (var db = new SCenterEntities()) { return db.ArticleWithAthmts.Single(a => a.Bid == id); } }
/// <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, DateTime date, string content, bool ispic, bool isloop, string path) { try { string sql = "insert into News (Sid,Title,Source,Author,Content,PostTime,IsPicNews,IsLoopPicNews,PicNewsPath) values({0},{1},{2},{3},{4},{5},{6},{7},{8})"; using (var db = new SCenterEntities()) { db.ExecuteStoreCommand(sql, new object[] {cid, title, source, author, content, date, ispic, isloop, path}); //db.SaveChanges(); //初始化Rank为它的唯一标识 List<News> list = db.News.Where(n => n.Rank == null).ToList(); if (list != null && list.Count >0) { foreach (var item in list) { item.Rank = item.Nid; } } db.SaveChanges(); } return true; } catch { return false; throw; } }
public static Admin GetUser(int id) { try { using (var db = new SCenterEntities()) { return db.Admins.Single(a => a.Userid == id); } } catch { return null; } }
public static List<Admin> GetUserList() { try { using (var db = new SCenterEntities()) { return db.Admins.OrderByDescending(a => a.Userid).ToList(); } } catch { } return null; }
/// <summary> /// 删除公告下载 /// </summary> /// <param name="id">文章ID</param> /// <returns>操作状态</returns> public static bool DelBulletin(int id) { try { using (var db = new SCenterEntities()) { db.ArticleWithAthmts.DeleteObject(db.ArticleWithAthmts.Single(a => a.Bid == id)); db.SaveChanges(); } return true; } catch { return false; } }
/// <summary> /// 删除文章 /// </summary> /// <param name="id">文章ID</param> /// <returns>操作状态</returns> public static bool DelUser(int id) { try { using (var db = new SCenterEntities()) { db.Admins.DeleteObject(db.Admins.Single(a => a.Userid == id)); db.SaveChanges(); } return true; } catch { return false; } }
/// <summary> /// 删除人员 /// </summary> /// <param name="id">人员ID</param> /// <returns>操作状态</returns> public static bool DelStaff(int id) { try { using (var db = new SCenterEntities()) { db.Members.DeleteObject(db.Members.Single(a => a.Mid == id)); db.SaveChanges(); } return true; } catch { return false; } }
/// <summary> /// 删除新闻 /// </summary> /// <param name="id">新闻ID</param> /// <returns>操作状态</returns> public static bool DelNews(int id) { try { using (var db = new SCenterEntities()) { db.News.DeleteObject(db.News.Single(n => n.Nid == id)); db.SaveChanges(); } return true; } catch { return false; } }
protected void Page_Load(object sender, EventArgs e) { int id = Convert.ToInt32(RouteData.Values["id"]); post = BulletinHelper.GetBulltin(id); //bshare需要抓取的两个内容 Page.Header.Title = post.Title; Page.Header.Description = post.Title; //更新统计数据 using (var db = new SCenterEntities()) { post.ClickCount += 1; db.Attach(post); db.ObjectStateManager.ChangeObjectState(post, System.Data.EntityState.Modified); db.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave); } }
protected void btnExec_onClick(object sender, EventArgs e) { string sql = @"alter table Article add Source varchar(255); alter table Article add Author varchar(255); alter table ArticleWithAthmt add Source varchar(255); alter table ArticleWithAthmt add Author varchar(255);"; try { using (var db = new SCenterEntities()) { db.ExecuteStoreCommand(sql, new object[] { }); } this.lbShow.Text = "SUCCESS"; } catch { this.lbShow.Text = "FAILS"; } }
protected void Page_Load(object sender, EventArgs e) { //获取要查看的新闻ID int id = Convert.ToInt32(RouteData.Values["id"]); Msg = ArtiHelper.GetArticle(id); //bshare需要抓取的两个内容 Page.Header.Title = Msg.Title; Page.Header.Description = Msg.Title; //更新统计数据 using (var db = new SCenterEntities()) { Msg.ClickCount += 1; db.Attach(Msg); db.ObjectStateManager.ChangeObjectState(Msg, System.Data.EntityState.Modified); db.SaveChanges(System.Data.Objects.SaveOptions.AcceptAllChangesAfterSave); } }
/// <summary> /// 添加文章 /// </summary> /// <param name="title"></param> /// <param name="password"></param> /// <returns></returns> public static bool AddUser(string username, string password) { try { string sql = "insert into Admin (UserName,Password) values({0},{1})"; using (var db = new SCenterEntities()) { db.ExecuteStoreCommand(sql, new object[] { username, FormsAuthentication.HashPasswordForStoringInConfigFile(password,"md5") }); db.SaveChanges(); } return true; } catch { return false; throw; } }
protected void btnLogin_Click(object sender, EventArgs e) { string username = this.txtUsername.Text; string pwd = FormsAuthentication.HashPasswordForStoringInConfigFile(this.txtPwd.Text, "md5"); //判断用户是否已经登录 if (AmIOnline(username, (Hashtable)Application["Online"])) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "MyScript", "<script>repeat();</script>"); return; } using (var db = new SCenterEntities()) { var usr = db.Admins.SingleOrDefault(u => u.UserName == username); if (usr == null) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "MyScript", "<script>userError();</script>"); return; } else { if (usr.Password != pwd) { ClientScript.RegisterStartupScript(ClientScript.GetType(), "MyScript", "<script>pwdError();</script>"); return; } Hashtable h = (Hashtable)Application["Online"]; if (h == null) { h = new Hashtable(); } h[Session.SessionID] = username; Application["Online"] = h; Session["username"] = username; Response.Redirect("~/Admin/Index.aspx"); } } }
/// <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 author, string source, DateTime date, string attachment, string filename) { 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,Source,Author,PostTime,Attachment,AttachmentName) values({0},{1},{2},{3},{4},{5},{6},{7})"; using (var db = new SCenterEntities()) { db.ExecuteStoreCommand(sql, new object[] { cid, title, content,source, author,Date, attachment, filename }); db.SaveChanges(); } return true; } catch { return false; throw; } }
/// <summary> /// 分页获取公告信息 /// </summary> /// <param name="pid">父类类别ID</param> /// <returns></returns> public static List<ArticleWithAthmt> GetTopItemsByParentId(int pid, int top) { using (var db = new SCenterEntities()) { 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 SCenterEntities()) { if (cid == 0) { news = db.News.Where(n => n.IsPicNews == true).OrderByDescending(n => n.Rank).Take(top).ToList(); } else { news = db.News.Where(n => n.IsLoopPicNews == true).OrderByDescending(n => n.Rank).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 SCenterEntities()) { news = db.News.OrderByDescending(n => n.Rank).Take(top).ToList(); } return news; }
/// <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 Rank desc limit {0} offset {1}"; using (var db = new SCenterEntities()) { count = db.News.Count(); return db.ExecuteStoreQuery<News>(sql, new object[] { pagesize, (index - 1) * pagesize }).OrderByDescending(n => n.Rank).ToList(); } }
/// <summary> /// 根据ID获取新闻实体 /// </summary> /// <param name="id">新闻ID</param> /// <returns></returns> public static News GetNews(int id) { using (var db = new SCenterEntities()) { return db.News.Single(n => n.Nid == id); } }
/// <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 SCenterEntities()) { 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="id"></param> /// <param name="username"></param> /// <param name="password"></param> /// <returns></returns> public static bool UpdateUser(int id, string username, string password) { try { using (var db = new SCenterEntities()) { var user = db.Admins.Single(a => a.Userid == id); user.UserName = username; user.Password = FormsAuthentication.HashPasswordForStoringInConfigFile(password, "md5"); 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 SCenterEntities()) { 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(); } }
public List<Post> GetTopDesc(int cid, int top) { List<Post> posts = new List<Post>(); using (var db = new SCenterEntities()) { 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 Post { Pid = item.Bid, Title = item.Title, PostTime = item.PostTime.ToString("yyyy-MM-dd") }); } } return posts; } }
/// <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, DateTime date, string content, bool ispic, bool isloop, string path) { try { using (var db = new SCenterEntities()) { 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.PostTime = date; news.IsPicNews = ispic; news.IsLoopPicNews = isloop; news.PicNewsPath = path; db.SaveChanges(); } return true; } catch { return false; } }
public List<Post> GetTopDesc(int cid, int top) { List<Post> posts = new List<Post>(); using (var db = new SCenterEntities()) { var list = db.News.Where(n => n.Sid == cid).OrderByDescending(n => n.Rank).Take(top).ToList(); if (list != null && list.Count > 0) { foreach (var item in list) { posts.Add(new Post { Pid = item.Nid, Title = item.Title, PostTime = item.PostTime.ToString("yyyy-MM-dd"), PicPath = item.PicNewsPath }); } } return posts; } }
/// <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 SCenterEntities()) { return db.ArticleWithAthmts.OrderByDescending(a => a.PostTime).Where(a => a.Sid == cid).Take(top).ToList(); } }
/// <summary> /// rank down /// </summary> /// <param name="id">新闻的ID</param> /// <returns>修改是否成功</returns> public static bool DownNews(int id) { try { using (var db = new SCenterEntities()) { var m1 = db.News.Single(a => a.Nid == id); if (m1.Rank == null) //防止没有Rank的条目 { m1.Rank = m1.Nid; } //找出此类列表 List<News> clist = db.News.Where(n => n.Sid == m1.Sid).OrderByDescending(a => a.Rank).ToList(); if (clist != null && clist.Count > 0) { News m2 = null; try { m2 = clist[clist.LastIndexOf(m1) + 1]; } catch { } if (m2 != null) { var tmp = m1.Rank; m1.Rank = m2.Rank; m2.Rank = tmp; } } //var m2 = db.News.SingleOrDefault(a => a.Rank == (m1.Rank - 1)); //if (m2 != null) //{ // m1.Rank -= 1; // m2.Rank += 1; //} db.SaveChanges(); } return true; } catch { return false; } }
/// <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 author, string source, DateTime date, string attachment, string filename) { DateTime Date = Convert.ToDateTime(date.ToString("yyyy-MM-dd") + " " + DateTime.Now.ToString("HH:mm:ss.fff")); try { using (var db = new SCenterEntities()) { var bulletin = db.ArticleWithAthmts.Single(a => a.Bid == id); bulletin.Title = title; bulletin.Content = content; bulletin.Sid = cid; bulletin.Author = author; bulletin.Source = source; bulletin.PostTime = Date; bulletin.Attachment = attachment; bulletin.AttachmentName = filename; db.SaveChanges(); } return true; } catch { return false; } }