//更新/删除一条分类名称 protected void repList_ItemCommand(object source, RepeaterCommandEventArgs e) { if (e.Item.ItemType == ListItemType.Item || e.Item.ItemType == ListItemType.AlternatingItem) { if (e.CommandName == "Update") { string type_id = this.hidUpdateId.Value; //分类ID string type_name = this.hidUpdateTypeName.Value; //分类名称 string type_keyword = this.hidUpdateTypeKeyword.Value; //分类关键词 if (type_id != "" && type_name != "") { string sql = "update t_article_type set type_name='" + type_name + "',type_keyword='" + type_keyword + "' where id=" + type_id; if (artBll.ExecuteSQLNonquery(sql)) { InText.AlertAndRedirect("修改成功!", Request.Url.ToString());//刷新当前页 } } } if (e.CommandName == "Delete") { string sql = "select count(*) from t_article where type=" + e.CommandArgument.ToString(); int totalRecord = Utils.CheckInt(artBll.ExecuteScalar(sql)); if (totalRecord > 0) { InText.AlertAndRedirect("该分类下有文章,请先修改文章分类或删除文章!", Request.Url.ToString());//刷新当前页 } else { sql = "delete from t_article_type where id=" + e.CommandArgument.ToString(); if (artBll.ExecuteSQLNonquery(sql)) { InText.AlertAndRedirect("删除成功!", Request.Url.ToString());//刷新当前页 } } } } }