public ActionResult Search(string title) { if (title == null) { return(new HttpStatusCodeResult(HttpStatusCode.BadRequest)); } else { if (db.cktitle(title)) { db.UpdKeyWord(title); } else { CMS_Keyword k = new CMS_Keyword() { keyword = title, ltimes = DateTime.Now, stimes = 1, show = true }; db.AddKeyWord(k); } return(View()); } }
/// <summary> /// 修改关键字状态 /// </summary> /// <param name="k"></param> /// <returns></returns> public int UpdKeyInfo(CMS_Keyword k) { var ls = d1.CMS_Keyword.Find(k.kid); ls.show = k.show; return(d1.SaveChanges()); }
/// <summary> /// 分页查询热搜 /// </summary> /// <param name="keyFilter">对象</param> /// <param name="limit">一页N条数据</param> /// <param name="page">当前第N页</param> /// <returns></returns> public static dynamic Find(CMS_Keyword keyFilter, int limit, int page) { try { using (CMSDatabase_Model cms = new CMSDatabase_Model()) { Pagination pagination = new Pagination(); var list = from data in cms.CMS_Keyword select data; if (keyFilter.kid > 0) { list = list.Where(data => data.kid == keyFilter.kid).Select(data => data); } pagination.total = list.Count(); list = list.OrderByDescending(data => data.kid); list = list.Skip(limit * (page - 1)).Take(limit); pagination.rows = list.ToList(); return(pagination); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加 /// </summary> /// <param name="key">对象</param> /// <returns>int</returns> public static dynamic Add(CMS_Keyword key) { try { return(CMS_Keyword_DAL.Add(key)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查找关键字,有条件 /// </summary> /// <param name="keyFilter">对象</param> /// <returns>list</returns> public static dynamic Find(CMS_Keyword keyFilter) { try { return(CMS_Keyword_DAL.Find(keyFilter)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 分页查询热搜 /// </summary> /// <param name="keyFilter">对象</param> /// <param name="limit">一页N条数据</param> /// <param name="page">当前第N页</param> /// <returns></returns> public static dynamic Find(CMS_Keyword keyFilter, int limit, int page) { try { Pagination pagination = CMS_Keyword_DAL.Find(keyFilter, limit, page); return(pagination); } catch (Exception ex) { throw ex; } }
//查询 public ActionResult Find(int rows, int page) { try { CMS_Keyword keyFilter = new CMS_Keyword(); Pagination pagination = CMS_Keyword_BLL.Find(keyFilter, rows, page); return(Json(pagination, JsonRequestBehavior.AllowGet)); } catch (Exception error) { throw error; } }
/// <summary> /// 修改 /// </summary> /// <param name="key">对象</param> /// <returns>int</returns> public static dynamic Edit(CMS_Keyword keyFilter) { try { using (CMSDatabase_Model cms = new CMSDatabase_Model()) { cms.Entry(keyFilter).State = System.Data.Entity.EntityState.Modified; var count = cms.SaveChanges(); return(count); } } catch (Exception ex) { throw ex; } }
/// <summary> /// 添加 /// </summary> /// <param name="key">对象</param> /// <returns>int</returns> public static dynamic Add(CMS_Keyword key) { try { using (CMSDatabase_Model cms = new CMSDatabase_Model()) { cms.CMS_Keyword.Add(key); var count = cms.SaveChanges(); return(count); } } catch (Exception ex) { throw ex; } }
public ActionResult Edit(int kid) { try { CMS_Keyword keyFilter = new CMS_Keyword(); keyFilter.kid = kid; Pagination pagination = CMS_Keyword_BLL.Find(keyFilter, 10, 1); List <CMS_Keyword> list = pagination.rows as List <CMS_Keyword>; list[0].show = 0; var count = CMS_Keyword_BLL.Edit(list[0]); return(Json(count, JsonRequestBehavior.AllowGet)); } catch (Exception ex) { throw ex; } }
/// <summary> /// 查找关键字,有条件 /// </summary> /// <param name="keyFilter">对象</param> /// <returns>list</returns> public static dynamic Find(CMS_Keyword keyFilter) { try { using (CMSDatabase_Model cms = new CMSDatabase_Model()) { var list = from data in cms.CMS_Keyword select data; if (!string.IsNullOrEmpty(keyFilter.keyword)) { list = list.Where(data => data.keyword.Contains(keyFilter.keyword)).Select(data => data); } return(list.ToList()); } } catch (Exception ex) { throw ex; } }
// 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="k"></param> /// <returns></returns> public int AddKeyWord(CMS_Keyword k) { db.CMS_Keyword.Add(k); return(db.SaveChanges()); }