示例#1
0
        //更新/删除一条分类名称
        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());//刷新当前页
                        }
                    }
                }
            }
        }