//
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));
}
