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