rollpro.aspx.cs

c#做的一个图书管理系统

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 manager_Default : System.Web.UI.Page
{
    
    protected void Page_Init(object sender, EventArgs e)
    {

    }
    
    protected void Page_Load(object sender, EventArgs e)
    {
      //  string role_tobeprovedid = Convert.ToString(operatedb.ExecuteScalar("select RoleId from aspnet_Roles where RoleName='tobeproved'"));
      //  string role_tobeprovedid_nameid = Convert.ToString(operatedb.ExecuteScalar("select UserId from aspnet_UsersInRoles where RoleId='" + role_tobeprovedid + "'"));
        DataTable dt = operatedb.dataTable("select * from viewur");
        GridView1.DataSource = dt;
        GridView1.DataBind();
    

    }
    protected void LoginStatus1_LoggingOut(object sender, LoginCancelEventArgs e)
    {
        Response.Redirect("~/logout.aspx");
    }
    protected void BulletedList1_Click(object sender, BulletedListEventArgs e)
    {

        ListItem li = BulletedList1.Items[e.Index];
        switch (Convert.ToString(li.Text))
        {
            case "本人信息": Server.Transfer("Default.aspx"); break;
            case "读者管理": Server.Transfer("readerm.aspx"); break;
            case "馆员管理": Server.Transfer("librarianm.aspx"); break;
            case "注册受理": Server.Transfer("rollpro.aspx"); break;
            case "规则制定": Server.Transfer("rullestablish.aspx"); break;
            case "密码修改": Server.Transfer("passwordchange.aspx"); break;
            case "使用帮助": Server.Transfer("help.aspx"); break;
            default: Server.Transfer("Default.aspx"); break;
        }
       
    }
  /*  protected void GridView1_RowDataBound(object sender, GridViewRowEventArgs e)
    {
        PostBackOptions myPostBackOptions = new PostBackOptions(this);
        myPostBackOptions.AutoPostBack = false;
        myPostBackOptions.RequiresJavaScriptProtocol = true;
        myPostBackOptions.PerformValidation = false;
        String evt = Page.ClientScript.GetPostBackClientHyperlink(sender as GridView, "Select$" + e.Row.RowIndex.ToString());
        e.Row.Attributes.Add("onclick", evt);
    }
 */
    protected void GridView1_SelectedIndexChanged(object sender, EventArgs e)
    {   string role_librarianid = Convert.ToString(operatedb.ExecuteScalar("select RoleId from aspnet_Roles where RoleName='librarian'"));
        string role_readerid = Convert.ToString(operatedb.ExecuteScalar("select RoleId from aspnet_Roles where RoleName='reader'"));

        GridViewRow row = GridView1.SelectedRow;
        
     //   RadioButton r1 = (RadioButton)row.Cells[2].FindControl("RadioButton1");
    //    RadioButton r2 = (RadioButton)row.Cells[2].FindControl("RadioButton2");
        string UserName = row.Cells[0].Text;
      //  row.Cells[2].Text;
        string selectedValue = Request.Form["MyRadioButton"];
    /*    if (Radio1.Checked)
        {
            string role_tobeprovedid_nameid = Convert.ToString(operatedb.ExecuteScalar("select UserId from aspnet_Users where UserName='" + selectedValue + "'"));
            operatedb.ExecuteSql("update aspnet_UsersInRoles set RoleId='"+role_readerid+ "'where UserId ='"+role_tobeprovedid_nameid+"'");
            Response.Write("<script   language='javascript'   defer>alert('修改成功');</script>");

        }
        else if (Radio2.Checked)
        {
            string role_tobeprovedid_nameid = Convert.ToString(operatedb.ExecuteScalar("select UserId from aspnet_Users where UserName='" + selectedValue + "'"));
            operatedb.ExecuteSql("update aspnet_UsersInRoles set RoleId='" + role_librarianid+ "'where UserId ='" + role_tobeprovedid_nameid + "'");
            Response.Write("<script   language='javascript'   defer>alert('修改成功');</script>");
        }
      //  else
       // {
           // Response.Write("<script   language='javascript'   defer>alert('你没有选择修改为的身份');</script>");
       // }
   */
        Response.Write("<script   language='javascript'   defer>alert('修改成功');</script>");        
    }
     
   /* protected void RadioButton1_CheckedChanged(object sender, EventArgs e)
    {
        if (r1.Checked)
        {
            string role_tobeprovedid_nameid = Convert.ToString(operatedb.ExecuteScalar("select UserId from aspnet_Users where UserName='" + UserName + "'"));
            operatedb.ExecuteSql("update aspnet_UsersInRoles set RoleId='" + role_readerid + "'where UserId ='" + role_tobeprovedid_nameid + "'");
            Response.Write("<script   language='javascript'   defer>alert('修改成功');</script>");

        }
    }
    protected void RadioButton2_CheckedChanged(object sender, EventArgs e)
    {
     if (r2.Checked)
        {
            string role_tobeprovedid_nameid = Convert.ToString(operatedb.ExecuteScalar("select UserId from aspnet_Users where UserName='" + UserName + "'"));
            operatedb.ExecuteSql("update aspnet_UsersInRoles set RoleId='" + role_librarianid+ "'where UserId ='" + role_tobeprovedid_nameid + "'");
            Response.Write("<script   language='javascript'   defer>alert('修改成功');</script>");
        }
    }
   */
}