/// <summary>
 /// 增加主题分类
 /// </summary>
 /// <param name="category">主题分类实体</param>
 public bool AddCategory(ThemeCategory category)
 {
     string cmdText = @"
     insert into ThemeCategory
         (CategoryName,ParentId,CategoryIcon,SortNumber,BindTagCategories)
     values
         (@CategoryName,@ParentId,@CategoryIcon,@SortNumber,@BindTagCategories);SELECT @@IDENTITY
     ";
     SqlParameter[] parameters = new SqlParameter[]
     {
         SqlParameterHelper.BuildInputParameter("@CategoryName",SqlDbType.NVarChar, 300, category.CategoryName),
         SqlParameterHelper.BuildInputParameter("@ParentId",SqlDbType.Int, 4, category.ParentId),
         SqlParameterHelper.BuildInputParameter("@CategoryIcon",SqlDbType.NVarChar, 300, category.CategoryIcon),
         SqlParameterHelper.BuildInputParameter("@SortNumber",SqlDbType.Int, 4, category.SortNumber),
         SqlParameterHelper.BuildInputParameter("@BindTagCategories",SqlDbType.NVarChar, 500, category.BindTagCategories)
     };
     category.CategoryId = Convert.ToInt32(SqlHelper.ExecuteScalar(_connectionProvider.GetWriteConnectionString(), CommandType.Text, cmdText, parameters));
     return category.CategoryId > 0;
 }
        }

        /// <summary>
        /// 更新主题分类
        /// </summary>
        /// <param name="category">主题分类实体</param>
        public bool UpdateCategory(ThemeCategory category)
        {
            string cmdText = @"
            update ThemeCategory set
                CategoryName=@CategoryName,
                ParentId=@ParentId,
                CategoryIcon=@CategoryIcon,
                SortNumber=@SortNumber,
                BindTagCategories=@BindTagCategories
            where
                CategoryId=@CategoryId
            ";
            SqlParameter[] parameters = new SqlParameter[]
            {
                SqlParameterHelper.BuildInputParameter("@CategoryId", SqlDbType.Int, 4, category.CategoryId),
                SqlParameterHelper.BuildInputParameter("@CategoryName", SqlDbType.NVarChar, 300, category.CategoryName),
                SqlParameterHelper.BuildInputParameter("@ParentId", SqlDbType.Int, 4, category.ParentId),
                SqlParameterHelper.BuildInputParameter("@CategoryIcon", SqlDbType.NVarChar, 300, category.CategoryIcon),
                SqlParameterHelper.BuildInputParameter("@SortNumber", SqlDbType.Int, 4, category.SortNumber),
                SqlParameterHelper.BuildInputParameter("@BindTagCategories", SqlDbType.NVarChar, 500, category.BindTagCategories)
            };