/// <summary> /// 根据分类编号获取特定状态的全部文章列表 /// </summary> /// <param name="categroySysNo">分类编号</param> /// <param name="status">状态</param> /// <returns>文章列表</returns> /// <remarks>2013-09-28 黄波 创建</remarks> /// <remarks>2013-10-28 何方 去除 a inner join syuser b on a.createdby = b.sysno,避免用户被删除后不能显示文章 </remarks> public override IList <CBFeArticle> GetArticle(int categroySysNo, ForeStatus.文章状态 status) { var countBuilder = Context.Select <CBFeArticle>("a.*") .From("fearticle a") .Where("a.categorysysno=@categorysysno and a.status=@status") .Parameter("categorysysno", categroySysNo) .Parameter("status", (int)status) .OrderBy("a.lastupdatedate desc").QueryMany(); return(countBuilder); }
/// <summary> /// 根据分类编号获取特定状态的全部文章列表 /// </summary> /// <param name="categroySysNo">分类编号</param> /// <param name="status">状态</param> /// <returns>文章列表</returns> /// <remarks>2013-09-28 黄波 创建</remarks> public abstract IList <CBFeArticle> GetArticle(int categroySysNo, ForeStatus.文章状态 status);