/// <summary> /// 传入字符串类型的关键字,用来搜索跟标题,概述,网站,类型,时间相关的内容 /// </summary> /// <param name="keyword"></param> /// <returns></returns> public static IQueryable <dynamic> GoSearch(string keyword) { ContentSearch cs = new ContentSearch(); var data = from searching in cs.db.ContentInfo where (string.IsNullOrEmpty(keyword) || searching.title.Contains(keyword) || searching.summary.Contains(keyword) || searching.websitename.Contains(keyword) || searching.type.Contains(keyword) || searching.time.Contains(keyword)) select searching; return(data); }
/// <summary> /// 返回排名的数据 /// </summary> /// <returns></returns> public static IQueryable <dynamic> GetRankingData() { ContentSearch cs = new ContentSearch(); var data = from ranking in cs.db.ContentInfo orderby ranking.hot descending select ranking; return(data); }
/// <summary> /// 返回 Banner 的数据 /// </summary> /// <returns></returns> public static IQueryable <dynamic> GetBannerData() { ContentSearch cs = new ContentSearch(); var data = from banner in cs.db.ContentInfo orderby banner.hot descending select banner; return(data); }
/// <summary> /// 返回普通内容的数据 /// </summary> /// <returns></returns> public static IQueryable <dynamic> GetSubContent() { ContentSearch cs = new ContentSearch(); var data = from subcontent in cs.db.ContentInfo //join j in cs.db.UserInfo on subcontent.id equals j.id into c //from u in c.DefaultIfEmpty() orderby subcontent.id descending select subcontent; return(data); }