// public ActionResult Add_article() { Member member = Session[CDictionary.SK_Logined_Member] as Member; TicketSysEntities db = new TicketSysEntities(); VMforum_mainblock vMforum_Mainblock = new VMforum_mainblock(); vMforum_Mainblock.activities = db.Activity.Where(n => n.SellerID == member.MemberID).ToList(); vMforum_Mainblock.ArticleCategories = db.ArticleCategories.ToList(); return(View(vMforum_Mainblock)); }
//初次載入調用,之後都用不到惹 public ActionResult forum_mainblock(string searchText) { TicketSysEntities db = new TicketSysEntities(); var q = (from n in db.Article orderby n.Date descending select n).ToList(); var p = db.ArticleCategories.Select(n => n).ToList(); int maxPage = q.Count / 4; var qq = new VMforum_mainblock { Article = q, ArticleCategories = p, page = maxPage, searchWord = searchText }; return(View("forum_mainblock", "_ForumLayout", qq)); }
//文章搜尋 public ActionResult SearchArticle(string searchText = "", int Page = 0, int CategoryID = 0, int searchType = 30) { TicketSysEntities db = new TicketSysEntities(); CForum_ArticleList_Factory al = new CForum_ArticleList_Factory(); List <Article> articles = db.Article.ToList(); //有選擇討論版 if (CategoryID != 0) { articles = al.Article_Category(articles, CategoryID); } //搜尋有文字 if (!string.IsNullOrEmpty(searchText)) { //searchType =2...有勾作者 //searchType =3...有勾標題 //searchType =5...有勾內文 List <Article> q = new List <Article>(); if (searchType % 2 == 0) { q = q.Union(al.Article_Search_Editor(articles, searchText)).ToList(); } if (searchType % 3 == 0) { q = q.Union(al.Article_Search_Title(articles, searchText)).ToList(); } if (searchType % 5 == 0) { q = q.Union(al.Article_Search_Content(articles, searchText)).ToList(); } articles = q; } //todo:按日期檢索 /// int maxPage = (articles.Count() / 4); //第幾頁 articles = articles.OrderByDescending(n => n.Date).Skip(Page * 4).ToList();//這個頁數不能一起算欸!放最後篩好了 var p = db.ArticleCategories.Select(n => n).ToList(); var qq = new VMforum_mainblock { Article = articles, ArticleCategories = p, searchWord = searchText, page = maxPage, ArticleCategoryID = CategoryID }; return(PartialView(qq)); }
public ActionResult Edit_article(int?articleID) { TicketSysEntities db = new TicketSysEntities(); var q = from n in db.Article where n.ArticleID == articleID select n; var p = db.ArticleCategories.Select(n => n); Article article = q.FirstOrDefault(); VMforum_mainblock vMforum_Mainblock = new VMforum_mainblock(); vMforum_Mainblock.Article = new List <Article>(); vMforum_Mainblock.ArticleCategories = new List <ArticleCategories>(); vMforum_Mainblock.Article.Add(article); vMforum_Mainblock.ArticleCategories = p.ToList(); vMforum_Mainblock.activities = db.Activity.Where(n => n.SellerID == article.MemberID).ToList(); return(View(vMforum_Mainblock)); }