emperverify.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;
using System.Data.SqlClient;

public partial class renshi_EmperVerify : System.Web.UI.Page
{
    public static string  con = ConfigurationManager.AppSettings["MyConnection"].ToString();
    
    protected void Page_Load(object sender, EventArgs e)
    {
        String sqlstr = "select Userid ,name ,DepartId ,UserState  from UserInfo where UserState=0";
        
       SqlConnection MyCon = new SqlConnection(con);
        MyCon.Open();
        SqlDataAdapter dat = new SqlDataAdapter(sqlstr, con);
        DataSet ds = new DataSet();
        dat.Fill(ds);
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
        MyCon.Close();
    }
    protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        if (e.Row.RowType == DataControlRowType.DataRow)
        {
            if (e.Row.Cells[3].Text =="1")
            {

                e.Row.Cells[3].Text = "<font color=red>已通过</font>";
            }
            else
            {
                e.Row.Cells[3].Text = "未通过";
            }
        }
    }
    protected void GridView1_SelectedIndexChanging(object sender, GridViewSelectEventArgs e)
    {
        string sqlstr="update UserInfo  set UserState=1 ";
        SqlConnection mycon = new SqlConnection(con);
        mycon.Open();
        SqlCommand cmd = new SqlCommand(sqlstr, mycon);
        if ((cmd.ExecuteNonQuery()) > 0)
        {
            sqlstr = "select Userid ,name ,DepartId ,UserState  from UserInfo where UserState=0";
            SqlDataAdapter dat = new SqlDataAdapter(sqlstr, con);
            DataSet ds = new DataSet();
            dat.Fill(ds);
            this.GridView1.DataSource = ds;
            this.GridView1.DataBind();

        }
       



        
    }


    protected void GridView1_PageIndexChanging(object sender, GridViewPageEventArgs e)
    {
        this.GridView1.PageIndex = e.NewPageIndex;
        this.GridView1.DataBind();
    }

    //删除指定商品信息
    protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
    {
        SqlConnection myConn =new SqlConnection(con);
        myConn.Open();
        SqlCommand cmd = new SqlCommand("Delete from UserInfo where Userid ='" + GridView1.DataKeys[e.RowIndex].Value + "'", myConn);
        
        cmd.ExecuteNonQuery();
        cmd.Dispose();



        string sqlstr = "select Userid ,name ,DepartId ,UserState  from UserInfo where UserState=0";
        SqlDataAdapter dat = new SqlDataAdapter(sqlstr, con);
        DataSet ds = new DataSet();
        dat.Fill(ds);
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
        myConn.Close();
       
        this.GridView1.DataBind();
    }






    protected void GridView1_RowUpdating(object sender, GridViewCommandEventArgs e)
    {
        SqlConnection myConn = new SqlConnection(con);
        SqlCommand cmd = new SqlCommand("update  UserInfo set UserState=1 where Userid ='" + GridView1.DataKeys[0].Value + "'", myConn);
        myConn.Open();
        cmd.ExecuteNonQuery();
        cmd.Dispose();
        this.Label1.Text = "审核通过！";


        string sqlstr = "select Userid ,name ,DepartId ,UserState  from UserInfo where UserState=0";
        SqlDataAdapter dat = new SqlDataAdapter(sqlstr, con);
        DataSet ds = new DataSet();
        dat.Fill(ds);
        this.GridView1.DataSource = ds;
        this.GridView1.DataBind();
        myConn.Close();

        this.GridView1.DataBind();

    }
}