Web/Admin/AdminTeamRule.aspx.cs

微信扫码关注公众号，代码整理好后第一时间通知你。

using System;
using System.Data;
using System.Configuration;
using System.Collections;
using System.Web;
using System.Web.Security;
using System.Web.UI;
using System.Web.UI.WebControls;
using System.Web.UI.WebControls.WebParts;
using System.Web.UI.HtmlControls;

public partial class Web_Admin_AdminTeamRule : System.Web.UI.Page
{
    Dbhelp dh = new Dbhelp();
    protected void Page_Load(object sender, EventArgs e)
    {
        if (Session["UserPower"] == null)
        {
            Response.Redirect("Admin.aspx");
            return;
        }
        DataBinit();
    }
    #region 数据邦定
    protected void DataBinit()
    {
        string sql = "select distinct Name,ID,Rules from LeagueRule";
        GVRules.DataSource = dh.GetData(sql);
        
        GVRules.DataBind();
    }
    #endregion
    protected void GVRules_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        string id = GVRules.DataKeys[e.RowIndex].Value.ToString();
        string sql = "update LeagueLogin_Table set IntRule=0 where LeagueName='"+GVRules.Rows[e.RowIndex].Cells[0].Text.ToString()+"'";
        if (dh.Exucte(sql) > 0)
        {
           sql = "delete LeagueRule where Id='" + id + "'";
            if (dh.Exucte(sql) > 0)
            {
                DataBinit();
            }
            else
            {
                dh.MessageShowBox("删除失败！");
            }
        }
        else
        {
            dh.MessageShowBox("删除失败！");
        }
    }
    protected void GVRules_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        GVRules.PageIndex = e.NewPageIndex;
        GVRules.DataBind();
    }
}