/// <summary> /// /// </summary> /// <param name="top">top=0取全部,top>0取top条</param> /// <param name="nodecode"></param> /// <param name="isAudit"></param> /// <param name="isIndex"></param> /// <returns></returns> public DataTable GetTopZtNews(int top, int ztId, bool isAudit, bool isIndex) { WhereClipBuilder wcb = new WhereClipBuilder(); if (ztId > 0) { wcb.And(cmsNewsTopicRel._.TopicId == ztId); } if (isAudit) { wcb.And(cmsNews._.IsAudit == 1); // 已审核的 } if (isIndex) { wcb.And(cmsNews._.IsIndex == 1); // 已推荐的 } FromSection fs = GetFromSection(null, null) .InnerJoin <cmsNewsCatalog>(cmsNewsCatalog._.NodeCode == cmsNews._.NodeCode) .InnerJoin <cmsNewsTopicRel>(cmsNews._.Id == cmsNewsTopicRel._.NewsId) .Select(cmsNews._.All, cmsNewsCatalog._.NodeName) .Where(wcb.ToWhereClip()) .OrderBy(cmsNews._.EditTime.Desc); if (top > 0) { fs = fs.Top(top); } return(fs.ToDataTable()); }
/// <summary> /// /// </summary> /// <param name="top"></param> /// <param name="nodecode"></param> /// <param name="isLike"></param> /// <param name="isAudit"></param> /// <param name="isIndex"></param> /// <returns></returns> public DataTable GetTopNews(int top, string nodecode, bool isLike, bool isAudit, bool isIndex) { WhereClipBuilder wcb = new WhereClipBuilder(); if (!string.IsNullOrEmpty(nodecode)) { if (!isLike) { wcb.And(cmsNews._.NodeCode == nodecode); } else { wcb.And(cmsNews._.NodeCode.BeginWith(nodecode)); } } if (isAudit) { wcb.And(cmsNews._.IsAudit == 1); // 已审核的 } if (isIndex) { wcb.And(cmsNews._.IsIndex == 1); // 已推荐的 } FromSection fs = GetFromSection(wcb.ToWhereClip(), null) .InnerJoin <cmsNewsCatalog>(cmsNewsCatalog._.NodeCode == cmsNews._.NodeCode) .Select(cmsNews._.All, cmsNewsCatalog._.NodeName) .OrderBy(cmsNews._.IsTop.Desc && cmsNews._.EditTime.Desc); if (top > 0) { fs = fs.Top(top); } return(fs.ToDataTable()); }
/// <summary> /// 根据栏目编号获取推荐到首页的列表 /// </summary> /// <param name="nodecode"></param> /// <param name="top"></param> /// <param name="isLike"></param> /// <returns></returns> public DataTable GetIndexList(long langId, string nodecode, int top, bool isLike) { if (top <= 0 || top > 10) { top = 10; } WhereClipBuilder wcb = new WhereClipBuilder(); wcb.And(cmsNews._.LangId == langId); if (!string.IsNullOrEmpty(nodecode)) { if (!isLike) { wcb.And(cmsNews._.NodeCode == nodecode); } else { wcb.And(cmsNews._.NodeCode.BeginWith(nodecode)); } } wcb.And(cmsNews._.IsAudit == 1); // 已审核的 wcb.And(cmsNews._.IsIndex == 1); // 推荐到首页的 FromSection fs = GetFromSection(wcb.ToWhereClip(), null) .InnerJoin <cmsNewsCatalog>(cmsNewsCatalog._.NodeCode == cmsNews._.NodeCode) .Select(cmsNews._.All, cmsNewsCatalog._.NodeName) .Top(top) .OrderBy(cmsNews._.IsTop.Desc && cmsNews._.EditTime.Desc); return(fs.ToDataTable()); }
/// <summary> /// 根据栏目类型获取推荐到首页的列表 /// </summary> /// <param name="nodetype"></param> /// <param name="top"></param> /// <returns></returns> public DataTable GetIndexList(long langId, int nodetype, int top) { if (top <= 0 || top > 10) { top = 10; } WhereClipBuilder wcb = new WhereClipBuilder(); wcb.And(cmsNews._.LangId == langId); wcb.And(cmsNewsCatalog._.NodeType == nodetype); wcb.And(cmsNews._.IsAudit == 1); // 已审核的 wcb.And(cmsNews._.IsIndex == 1); // 推荐到首页的 FromSection fs = GetFromSection(wcb.ToWhereClip(), null) .InnerJoin <cmsNewsCatalog>(cmsNewsCatalog._.NodeCode == cmsNews._.NodeCode) .Select(cmsNews._.All, cmsNewsCatalog._.NodeName) .Top(top) .OrderBy(cmsNews._.IsTop.Desc && cmsNews._.EditTime.Desc); return(fs.ToDataTable()); }