public override bool StepExecute(int operatorUserID, string param, ref long offset, ref int totalCount, ref int finishedCount, out string title, out bool isLastStep)
{
StringList paramData = StringList.Parse(param);
AdminBlogCategoryFilter filter = AdminBlogCategoryFilter.Parse(paramData[0]);
int stepCount;
if (BlogBO.Instance.DeleteBlogCategoriesForAdmin(operatorUserID, filter, paramData[2] == "1", paramData[1] == "1", stepDeleteCount, out stepCount)) // .DeleteDoingsBySearch(filter, 200);
{
finishedCount += stepCount;
isLastStep = stepCount < stepDeleteCount;
title = "正在删除日志分类，总数 " + totalCount + "，已删 " + finishedCount;
return(true);
}
else
{
isLastStep = true;
title = string.Empty;
}
return(true);
}
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);
}
protected void Page_Load(object sender, EventArgs e)
{
m_AdminForm = AdminBlogCategoryFilter.GetFromFilter("filter");
if (_Request.IsClick("advancedsearch"))
{
SearchCategories();
}
else if (_Request.IsClick("deletechecked"))
{
DeleteChecked();
}
else if (_Request.IsClick("deletesearched"))
{
DeleteSearch();
}
using (ErrorScope es = new ErrorScope())
{
int pageNumber = _Request.Get <int>("page", 0);
m_CategoryListPageSize = m_AdminForm.PageSize;
m_CategoryList = BlogBO.Instance.GetBlogCategoriesForAdmin(MyUserID, m_AdminForm, pageNumber);
if (m_CategoryList != null)
{
m_TotalCategoryCount = m_CategoryList.TotalRecords;
UserBO.Instance.WaitForFillSimpleUsers <BlogCategory>(m_CategoryList);
}
if (es.HasUnCatchedError)
{
es.CatchError <ErrorInfo>(delegate(ErrorInfo error)
{
ShowError(error);
});
}
}
}
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;
}
}
}
private string BuildConditionsByFilter(SqlQuery query, AdminBlogCategoryFilter filter, IEnumerable<Guid> excludeRoleIDs, bool startWithWhere)
{
StringBuffer sqlConditions = new StringBuffer();
if (string.IsNullOrEmpty(filter.SearchKey) == false)
{
sqlConditions += " AND [Name] LIKE '%' + @SearchKey + '%'";
query.CreateParameter<string>("@SearchKey", filter.SearchKey, SqlDbType.NVarChar, 50);
}
if (filter.BeginDate != null)
{
sqlConditions += " AND [CreateDate] >= @BeginDate";
query.CreateParameter<DateTime?>("@BeginDate", filter.EndDate, SqlDbType.DateTime);
}
if (filter.EndDate != null)
{
sqlConditions += " AND [CreateDate] <= @EndDate";
query.CreateParameter<DateTime?>("@EndDate", filter.EndDate, SqlDbType.DateTime);
}
if (string.IsNullOrEmpty(filter.Username) == false)
{
sqlConditions += " AND [UserID] = (SELECT [UserID] FROM [bx_Users] WHERE [Username] = @Username)";
query.CreateParameter<string>("@Username", filter.Username, SqlDbType.NVarChar, 50);
}
string excludeRoleSQL = DaoUtil.GetExcludeRoleSQL("[UserID]", excludeRoleIDs, query);
if (string.IsNullOrEmpty(excludeRoleSQL) == false)
sqlConditions += " AND " + excludeRoleSQL;
sqlConditions += " AND [CategoryID] != 0";
if (sqlConditions.Length > 0)
{
sqlConditions.Remove(0, 5);
if (startWithWhere)
sqlConditions.InnerBuilder.Insert(0, " WHERE ");
}
return sqlConditions.ToString();
}
public override DeleteResult DeleteBlogCategoriesBySearch(AdminBlogCategoryFilter filter, bool deleteArticle, int operatorUserID, IEnumerable<Guid> excludeRoleIDs, int topCount, out int deletedCount)
{
deletedCount = 0;
using (SqlQuery query = new SqlQuery())
{
string conditions = BuildConditionsByFilter(query, filter, excludeRoleIDs, true);
StringBuffer sql = new StringBuffer();
sql += @"
DECLARE @DeleteData table (UserID int, [CategoryID] int, [ArticleCount] int);
INSERT INTO @DeleteData SELECT TOP (@TopCount) [A].[UserID],[A].[CategoryID],(SELECT COUNT(*) FROM [bx_BlogArticles] AS [B] WHERE [B].[CategoryID]=[A].[CategoryID]) FROM [bx_BlogCategories] AS [A] " + conditions + ";";
if (deleteArticle)
{
sql += @"
DELETE [bx_BlogArticles] WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData);";
}
else
{
sql += @"
UPDATE [bx_BlogArticles] SET [CategoryID] = 0 WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData);";
}
sql += @"
DELETE [bx_BlogCategories] WHERE [CategoryID] IN (SELECT [CategoryID] FROM @DeleteData);
SELECT @@ROWCOUNT;
SELECT [UserID],SUM([ArticleCount]) AS [Count] FROM @DeleteData GROUP BY [UserID];";
query.CreateTopParameter("@TopCount", topCount);
query.CommandText = sql.ToString();
using (XSqlDataReader reader = query.ExecuteReader())
{
DeleteResult deleteResult = new DeleteResult();
if (reader.Read())
deletedCount = reader.Get<int>(0);
if (reader.NextResult())
{
while (reader.Read())
{
deleteResult.Add(reader.Get<int>("UserID"), reader.Get<int>("Count"));
}
}
return deleteResult;
}
}
}
/// <summary> /// 删除日志分类 /// </summary> public abstract DeleteResult DeleteBlogCategoriesBySearch(AdminBlogCategoryFilter filter, bool deleteArticle, int operatorUserID, IEnumerable <Guid> excludeRoleIDs, int topCount, out int deletedCount);
/// <summary> /// 搜索博客分类（后台管理用） /// </summary> /// <param name="excludeRoleIDs">在返回结果中要排除哪些用户组成员发布的日志</param> /// <param name="filter">搜索条件</param> /// <param name="pageNumber">数据分页页码</param> /// <param name="pageSize">数据分页每页条数</param> /// <returns></returns> public abstract BlogCategoryCollection GetBlogCategoriesBySearch(Guid[] excludeRoleIDs, AdminBlogCategoryFilter filter, int pageNumber);
private void SearchCategories()
{
AdminBlogCategoryFilter filter = AdminBlogCategoryFilter.GetFromForm();
filter.Apply("filter", "page");
}
