/// <summary> /// 判断文章分类标题是否重复 /// </summary> /// <param name="title">文章分类标题</param> /// <param name="type">文章分类类型</param> /// <returns>重复为true,否则为false</returns> /// <remarks>2013-07-05 杨晗 创建</remarks> public override bool FeArticleCategoryVerify(string title, ForeStatus.文章分类类型 type) { string sql = @"Name=@title and type=@type and status<>@status"; int countBuilder = Context.Select <int>("count(1)") .From("fearticlecategory") .Where(sql) .Parameter("title", title) .Parameter("type", type) .Parameter("status", ForeStatus.文章分类状态.作废) .QuerySingle(); return(countBuilder > 0); }
/// <summary> /// 根据文章类型获取所有文章分类 /// </summary> /// <param name="type">文章分类类型</param> /// <returns>文章分类集合</returns> /// <remarks>2013-06-19 杨晗 创建</remarks> public override IList <FeArticleCategory> GetAll(ForeStatus.文章分类类型 type) { #region sql条件 string sql = @"Type=@Type and Status=@Status"; #endregion var countBuilder = Context.Select <FeArticleCategory>("ft.*") .From("fearticlecategory ft") .Where(sql) .Parameter("Type", (int)type) .Parameter("Status", (int)ForeStatus.文章分类状态.已审) .OrderBy("DISPLAYORDER").QueryMany(); return(countBuilder); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageIndex">起始页</param> /// <param name="type">文章类型</param> /// <param name="searchStaus">状态</param> /// <param name="searchName">分类名称</param> /// <returns>文章类型列表</returns> /// <remarks>2013-06-17 杨晗 创建</remarks> public PagedList <FeArticleCategory> Seach(int?pageIndex, ForeStatus.文章分类类型 type, int?searchStaus, string searchName) { pageIndex = pageIndex ?? 1; searchStaus = searchStaus ?? 0; var model = new PagedList <FeArticleCategory>(); int count; var list = IFeArticleCategoryDao.Instance.Seach((int)pageIndex, model.PageSize, type, (int)searchStaus, searchName, out count); model.TData = list; model.TotalItemCount = count; model.CurrentPageIndex = (int)pageIndex; return(model); }
/// <summary> /// 获取所有文章类别(包含旗下文章) /// </summary> /// <param name="type">文章类型</param> /// <param name="recordNum">记录条数</param> /// <returns>所有文章类别(包含旗下文章)</returns> /// <remarks>2013-08-12 杨晗 创建</remarks> /// <remarks>2013-09-25 邵斌 修改:指定记录条数</remarks> private IList <CBFeArticleCategory> GetAllArticle(ForeStatus.文章分类类型 type, int?recordNum = null) { var list = GetAll(type); IList <CBFeArticleCategory> cbList = new List <CBFeArticleCategory>(); foreach (var item in list) { var model = new CBFeArticleCategory { SysNo = item.SysNo, Type = item.Type, Name = item.Name, Description = item.Description, DisplayOrder = item.DisplayOrder, Status = item.Status, FeArticle = IFeArticleDao.Instance.GetListByCategory(item.SysNo, recordNum) }; cbList.Add(model); } return(cbList); }
/// <summary> /// 分页查询 /// </summary> /// <param name="pageIndex">起始页</param> /// <param name="pageSize">每页数量</param> /// <param name="type">文章类型</param> /// <param name="searchStaus">状态</param> /// <param name="searchName">分类名称</param> /// <param name="count">抛出总条数</param> /// <returns>文章类型列表</returns> /// <remarks>2013-06-17 杨晗 创建</remarks> public override IList <FeArticleCategory> Seach(int pageIndex, int pageSize, ForeStatus.文章分类类型 type, int searchStaus, string searchName, out int count) { #region sql条件 string sql = @"(@Name is null or Name like @Name1) and (@Status=0 or Status =@Status1) and (@Type=0 or Type=@Type1)"; #endregion using (var context = Context.UseSharedConnection(true)) { count = context.Select <int>("count(1)") .From("fearticlecategory ft") .Where(sql) .Parameter("Name", searchName) .Parameter("Name1", "%" + searchName + "%") .Parameter("Status", searchStaus) .Parameter("Status1", searchStaus) .Parameter("Type", (int)type) .Parameter("Type1", (int)type) .QuerySingle(); var countBuilder = context.Select <FeArticleCategory>("ft.*") .From("fearticlecategory ft") .Where(sql) .Parameter("Name", searchName) .Parameter("Name1", "%" + searchName + "%") .Parameter("Status", searchStaus) .Parameter("Status1", searchStaus) .Parameter("Type", (int)type) .Parameter("Type1", (int)type) .Paging(pageIndex, pageSize).OrderBy("DISPLAYORDER desc").QueryMany(); return(countBuilder); } }
/// <summary> /// 根据文章类型获取所有文章分类 /// </summary> /// <param name="type">文章分类类型</param> /// <returns>文章分类集合</returns> /// <remarks>2013-06-19 杨晗 创建</remarks> public abstract IList <FeArticleCategory> GetAll(ForeStatus.文章分类类型 type);
/// <summary> /// 分页查询 /// </summary> /// <param name="pageIndex">起始页</param> /// <param name="pageSize">每页数量</param> /// <param name="type">文章类型</param> /// <param name="searchStaus">状态</param> /// <param name="searchName">分类名称</param> /// <param name="count">抛出总条数</param> /// <returns>文章类型列表</returns> /// <remarks>2013-06-17 杨晗 创建</remarks> public abstract IList <FeArticleCategory> Seach(int pageIndex, int pageSize, ForeStatus.文章分类类型 type, int searchStaus, string searchName, out int count);
/// <summary> /// 判断文章分类标题是否重复 /// </summary> /// <param name="title">文章分类标题</param> /// <param name="type">文章分类类型</param> /// <returns>重复为true,否则为false</returns> /// <remarks>2013-07-05 杨晗 创建</remarks> public abstract bool FeArticleCategoryVerify(string title, ForeStatus.文章分类类型 type);
/// <summary> /// 根据文章类型获取所有文章分类 /// </summary> /// <param name="type">文章分类类型</param> /// <returns>文章分类集合</returns> /// <remarks>2013-06-19 杨晗 创建</remarks> public IList <FeArticleCategory> GetAll(ForeStatus.文章分类类型 type) { return(IFeArticleCategoryDao.Instance.GetAll(type)); }
/// <summary> /// 判断文章分类标题是否重复 /// </summary> /// <param name="title">文章分类标题</param> /// <param name="type">文章分类类型</param> /// <returns>重复为true,否则为false</returns> /// <remarks>2013-07-05 杨晗 创建</remarks> public bool FeArticleCategoryVerify(string title, ForeStatus.文章分类类型 type) { return(IFeArticleCategoryDao.Instance.FeArticleCategoryVerify(title, type)); }