/// <summary>
/// 搜索关键字
/// </summary>
/// <returns></returns>
public List <JiaJiNewWebModel.Home.SearchDetails> Select(JiaJiNewWebModel.Home.selectmodel model)
{
try
{
return(idal.Select(model));
}
catch (Exception ex)
{
return(null);
}
}
//public IQueryable<JiaJiNewWebModel.erweima> QueryShowErWeiMa()
//{
// return QueryEntities(m => m.IsShowCaiDan == 1).OrderBy(s => s.ShowCaiDanIndex);
//}
public ActionResult SouSuo(string selName, int pageIndex = 1, int pageSize = 10)
{
JiaJiNewWebModel.Home.selectmodel model = new JiaJiNewWebModel.Home.selectmodel();
model.Activetable.ActiveTitle = selName;
model.Activetable.Datails = selName;
model.Infortable.Title = selName;
model.Infortable.content = selName;
model.Strategytable.StrategyTitle = selName;
model.Strategytable.StrategyContent = selName;
model.Navtable.NavTitleOne = selName;
model.Navtable.NavTitleTwo = selName;
model.Navtable.NavContentOne = selName;
List <JiaJiNewWebModel.Home.SearchDetails> infolist = new JiaJiNewWebBLL.InformationBLL().Select(model);
var count = infolist.Count;
var pageTotal = (int)Math.Ceiling((double)(count) / pageSize);
if (pageIndex < 1)
{
pageIndex = 1;
}
if (pageIndex >= pageTotal)
{
pageIndex = pageTotal;
}
infolist = infolist.Skip((pageIndex - 1) * pageSize).Take(pageSize).ToList();
ViewBag.OptionImage = new JiaJiNewWebBLL.OptionBLL().HotOptionImage();
ViewBag.activelist = new JiaJiNewWebBLL.ActiveBLL().ActiveLsitIndex();//加载活动
ViewBag.optionlist = new JiaJiNewWebBLL.OptionBLL().HotOption();
ViewBag.selName = selName;
if (infolist.Count == 0)
{
return(Content("<script>alert('暂无该搜索结果');location.href='/Home/Index';</script>"));
}
else
{
Models.Pager <JiaJiNewWebModel.Home.SearchDetails> pager = new Models.Pager <JiaJiNewWebModel.Home.SearchDetails>();
pager.PageIndex = pageIndex;
pager.PageSize = pageSize;
pager.PageTotal = pageTotal;
pager.Model = infolist;
return(View(pager));
}
}
/// <summary>
/// 搜索关键字
/// </summary>
/// <returns></returns>
public List <JiaJiNewWebModel.Home.SearchDetails> Select(JiaJiNewWebModel.Home.selectmodel model)
{
try
{
StringBuilder sqlstring = new StringBuilder();
sqlstring.Append(" select ActiveID,ActiveTitle,Datails,'active' as activetable from active where ActiveTitle like '%" + model.Activetable.ActiveTitle + "%' or Datails like '%" + model.Activetable.Datails + "%' ");
sqlstring.Append(" union ALL ");
sqlstring.Append(" select InformationID,Title,Content,'information' as infortable from information where Title like '%" + model.Infortable.Title + "%' or Content like '%" + model.Infortable.content + "%' ");
sqlstring.Append(" union ALL ");
sqlstring.Append(" select StrategyID,StrategyTitle,StrategyProfile,'strategy' as strategytable from strategy where StrategyTitle like '%" + model.Strategytable.StrategyTitle + "%' or StrategyContent like '%" + model.Strategytable.StrategyProfile + "%' ");
sqlstring.Append(" union ALL ");
sqlstring.Append(" select NavID,NavTitleTwo,NavContentOne,'nav' as navtable from navinfo where NavTitleTwo='%" + model.Navtable.NavTitleTwo + "%' or NavContentOne='%" + model.Navtable.NavContentOne + "%' ");
List <JiaJiNewWebModel.Home.SearchDetails> list = MySqlDB.GetList <JiaJiNewWebModel.Home.SearchDetails>(sqlstring.ToString(), System.Data.CommandType.Text, null);
return(list);
}
catch (Exception ex)
{
return(null);
}
}
