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 aspnet_Users where UserId='" + role_tobeprovedid_nameid + "'");
        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_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;
        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>");

        }
        else 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>");
        }
        else
        {
            Response.Write("<script   language='javascript'   defer>alert('你没有选择修改为的身份');</script>");
        }
    }
}