/// <summary> /// 查找全部文章并分页 /// </summary> /// <param name="artFilter">Model对象</param> /// <param name="limit">一页显示的内容数量</param> /// <param name="page">当前是多少页</param> /// <returns>pagination</returns> public static dynamic Find(ArticleMain_View artFilter, int limit, int page) { using (CMSDatabase_Model cms = new CMSDatabase_Model()) { try { Pagination pagination = new Pagination(); var list = from data in cms.ArticleMain_View select data; if (artFilter.cid > 0) { list = list.Where(data => data.cid == artFilter.cid).Select(data => data); } if (!string.IsNullOrEmpty(artFilter.title)) { list = list.Where(data => data.title.Contains(artFilter.title)).Select(data => data); } if (!string.IsNullOrEmpty(artFilter.author)) { list = list.Where(data => data.author.Contains(artFilter.author)).Select(data => data); } pagination.total = list.Count(); list = list.OrderByDescending(data => data.aid); list = list.Skip(limit * (page - 1)).Take(limit); pagination.rows = list.ToList(); return(pagination); } catch (Exception error) { throw error; } } }
/// <summary> /// 查找文章前六条数据 /// </summary> /// <param name="artFilter">条件</param> /// <returns>list</returns> public static dynamic Find(ArticleMain_View artFilter) { using (CMSDatabase_Model cms = new CMSDatabase_Model()) { try { var list = from data in cms.ArticleMain_View select data; if (artFilter.cid > 0) { list = list.Where(data => data.cid == artFilter.cid).Select(data => data); } if (artFilter.aid > 0) { list = list.Where(data => data.aid == artFilter.aid).Select(data => data); } list = list.OrderByDescending(data => data.ptime); list = list.Take(6); return(list.ToList()); } catch (Exception error) { throw error; } } }
// GET: Front/Home public ActionResult Index() { ArticleMain_View artFilter = new ArticleMain_View(); //置顶项 var listIsTop = CMS_Article_BLL.FindIsTop(); ViewBag.listIsTop = listIsTop; //网站公告 artFilter.cid = 1; var listNotice = CMS_Article_BLL.Find(artFilter); ViewBag.NoticeList = listNotice; //产品定制 artFilter.cid = 2; var listProduct = CMS_Article_BLL.Find(artFilter); ViewBag.ProductList = listProduct; //定制服务 artFilter.cid = 3; var listService = CMS_Article_BLL.Find(artFilter); ViewBag.ServiceList = listService; //成功案例 artFilter.cid = 4; var listCase = CMS_Article_BLL.Find(artFilter); ViewBag.CaseList = listCase; return(View()); }
/// <summary> /// 查找全部文章并分页 /// </summary> /// <param name="artFilter">Model对象</param> /// <param name="limit">一页显示的内容数量</param> /// <param name="page">当前是多少页</param> /// <returns>pagination</returns> public static dynamic Find(ArticleMain_View artFilter, int limit, int page) { try { Pagination pagination = CMS_Article_DAL.Find(artFilter, limit, page); return(pagination); } catch (Exception error) { throw error; } }
public ActionResult Find(int aid) { try { ArticleMain_View artFilter = new ArticleMain_View(); artFilter.aid = aid; var list = CMS_Article_BLL.Find(artFilter); return(Json(list, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
//文章内容 public ActionResult LaceMian(int id = 0) { try { if (id == 0) { Response.Redirect("/Front/Home/Index"); } else { //查找文章 ArticleMain_View artFilter = new ArticleMain_View(); artFilter.aid = id; var listArticle = CMS_Article_BLL.Find(artFilter); ViewBag.articleList = listArticle; //查账该文章的评论数 CMS_Comment comFilter = new CMS_Comment(); comFilter.aid = id; var countCommentSum = CMS_Comment_BLL.FindCommentSum(comFilter); if (countCommentSum == 0) { ViewBag.commentSumCount = 0; } else { ViewBag.commentSumCount = countCommentSum; } //查找该文章的评论 CommentMain_View comView = new CommentMain_View(); comView.aid = id; var listComment = CMS_Comment_BLL.Find(comView); ViewBag.commentList = listComment; if (Session["userID"] != null) { ViewBag.userID = Session["userID"].ToString(); } else { ViewBag.userID = "0"; } } } catch (Exception error) { throw error; } return(View()); }
public ActionResult EditCid(int aid, int cid) { try { ArticleMain_View artFilter = new ArticleMain_View(); artFilter.aid = aid; var list = CMS_Article_BLL.Find(artFilter); list[0].cid = cid; var count = CMS_Article_BLL.Edit(list[0]); return(Json(count, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
//按栏目查找 public ActionResult AritcleList(int id = 0, int limit = 10, int page = 1) { if (id == 0) { Response.Redirect("/Front/Home/Index"); } ArticleMain_View artFilter = new ArticleMain_View(); artFilter.cid = id; Pagination pagination = CMS_Article_BLL.Find(artFilter, limit, page); ViewBag.pageList = pagination.rows; ViewBag.pageSum = pagination.total; return(View()); }
public ActionResult FindArticle(int rows, int page, string title, string author, int cid = 0) { try { ArticleMain_View artFilter = new ArticleMain_View(); artFilter.title = title; artFilter.author = author; artFilter.cid = cid; Pagination pagination = new Pagination(); pagination = CMS_Article_BLL.Find(artFilter, rows, page); return(Json(pagination, JsonRequestBehavior.AllowGet)); } catch (Exception error) { throw error; } }
// GET: Front/Find public ActionResult Search(string tlti, int limit = 10, int page = 1) { ArticleMain_View artFilter = new ArticleMain_View(); artFilter.title = tlti; //取出到搜索内容 //查询热词 CMS_Keyword keyFilter = new CMS_Keyword(); keyFilter.keyword = tlti; var list = CMS_Keyword_BLL.Find(keyFilter); if (list.Count > 0) //查到了便修改次数 { list[0].stimes = Convert.ToInt32(list[0].stimes) + 1; list[0].ltimes = DateTime.Now; CMS_Keyword_BLL.Edit(list[0]); } else { //没查到便添加 CMS_Keyword key = new CMS_Keyword(); key.keyword = tlti; key.stimes = 1; key.ltimes = DateTime.Now; key.show = 1; CMS_Keyword_BLL.Add(key); } //赋值到页面 Pagination pagination = CMS_Article_BLL.Find(artFilter, limit, page); ViewBag.pageList = pagination.rows; ViewBag.pageSum = pagination.total; return(View()); }
/// <summary> /// 查找文章前六条数据 /// </summary> /// <param name="artFilter">条件</param> /// <returns>list</returns> public static dynamic Find(ArticleMain_View artFilter) { var list = CMS_Article_DAL.Find(artFilter); return(list); }