public override bool BeforeExecute(int operatorUserID, string param, ref long offset, ref int totalCount, out string title) { StringList paramData = StringList.Parse(param); AdminBlogCategoryFilter filter = AdminBlogCategoryFilter.Parse(paramData[0]); BlogCategoryCollection categories = BlogBO.Instance.GetBlogCategoriesForAdmin(operatorUserID, filter, 1); if (categories == null || categories.Count == 0) { title = "没有数据可以删除"; return(true); } totalCount = categories.TotalRecords; title = "将删除 " + totalCount + " 个日志分类"; return(true); }
public override BlogCategoryCollection GetBlogCategoriesBySearch(Guid[] excludeRoleIDs, AdminBlogCategoryFilter filter, int pageNumber) { using (SqlQuery query = new SqlQuery()) { string conditions = BuildConditionsByFilter(query, filter, excludeRoleIDs, false); query.Pager.TableName = "[bx_BlogCategories]"; query.Pager.SortField = filter.Order.ToString(); query.Pager.IsDesc = filter.IsDesc; query.Pager.PageNumber = pageNumber; query.Pager.PageSize = filter.PageSize; query.Pager.SelectCount = true; query.Pager.Condition = conditions.ToString(); using (XSqlDataReader reader = query.ExecuteReader()) { BlogCategoryCollection categories = new BlogCategoryCollection(reader); if (reader.NextResult()) { if (reader.Read()) { categories.TotalRecords = reader.Get<int>(0); } } return categories; } } }