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