1using System;
  2using System.Collections;
  3using System.ComponentModel;
  4using System.Data;
  5using System.Drawing;
  6using System.Web;
  7using System.Web.SessionState;
  8using System.Web.UI;
  9using System.Web.UI.WebControls;
 10using System.Web.UI.HtmlControls;
 11using System.Text;
 12using System.Data.OleDb;
 13
 14namespace FileManage_Sys
 15...{
 16    /**//// <summary>
 17    /// EditUser 的摘要说明。
 18    /// </summary>
 19    public class EditUser : System.Web.UI.Page
 20    ...{
 21        protected System.Web.UI.WebControls.TextBox username;
 22        protected System.Web.UI.WebControls.TextBox password;
 23        protected System.Web.UI.WebControls.TextBox password2;
 24        protected System.Web.UI.WebControls.ListBox selrole;
 25        protected System.Web.UI.WebControls.Button adduser;
 26        protected System.Web.UI.WebControls.Button deluser;
 27        protected string UserPwd;
 28    
 29        private void Page_Load(object sender, System.EventArgs e)
 30        ...{
 31            deluser.Attributes.Add("onclick","javascript :return confirm('你确定删除吗？')");
 32
 33            if(!Page.IsPostBack)
 34            ...{
 35                string SqlStr="";
 36                string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
 37                OleDbConnection AccessConnection = new OleDbConnection(ConnectionStr);
 38                AccessConnection.Open();//打开数据库
 39                SqlStr="Select * From Role  Order By Id DESC";
 40                OleDbCommand AccessCommand = new OleDbCommand(SqlStr,AccessConnection);
 41
 42                OleDbDataReader AccessReader = AccessCommand.ExecuteReader();
 43                int i=0;
 44                ListItem AddItem ;
 45                while(AccessReader.Read())
 46                ...{
 47                    AddItem = new ListItem(AccessReader["rolename"].ToString(),AccessReader["role"].ToString()+"|"+AccessReader["rolename"].ToString());
 48                    selrole.Items.Add(AddItem);
 49                    i++;
 50
 51                }
 52                if(i==0)
 53                ...{
 54                    AddItem = new ListItem("尚未创建角色","0");
 55                    selrole.Items.Add(AddItem);
 56                }
 57                AccessReader.Close();
 58
 59                AccessCommand.Dispose();
 60                SqlStr = "Select * From users Where id="+Request.QueryString["userid"].ToString();
 61                OleDbCommand AccessCommand2 = new OleDbCommand(SqlStr,AccessConnection);
 62                AccessReader = AccessCommand2.ExecuteReader();
 63                if(AccessReader.Read())
 64                ...{
 65                    username.Text = AccessReader["username"].ToString();
 66                    //UserPwd = AccessReader["pwd"].ToString();
 67
 68                }
 69                AccessReader.Close();
 70                AccessCommand2.Dispose();
 71
 72                AccessConnection.Close();
 73            }
 74            // 在此处放置用户代码以初始化页面
 75        }
 76
 77        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 78        override protected void OnInit(EventArgs e)
 79        ...{
 80            //
 81            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 82            //
 83            InitializeComponent();
 84            base.OnInit(e);
 85        }
 86        
 87        /**//// <summary>
 88        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 89        /// 此方法的内容。
 90        /// </summary>
 91        private void InitializeComponent()
 92        ...{    
 93            this.adduser.Click += new System.EventHandler(this.adduser_Click);
 94            this.deluser.Click += new System.EventHandler(this.deluser_Click);
 95            this.Load += new System.EventHandler(this.Page_Load);
 96
 97        }
 98        #endregion
 99
100        private void adduser_Click(object sender, System.EventArgs e)
101        ...{
102            string SqlStr="";
103            string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
104            OleDbConnection AccessConnection = new OleDbConnection(ConnectionStr);
105            AccessConnection.Open();//打开数据库
106            SqlStr = "Select * From users Where id="+Request.QueryString["userid"].ToString();
107            OleDbCommand AccessCommand2 = new OleDbCommand(SqlStr,AccessConnection);
108            OleDbDataReader AccessReader = AccessCommand2.ExecuteReader();
109            if(AccessReader.Read())
110            ...{
111                //username.Text = AccessReader["username"].ToString();
112                UserPwd = AccessReader["pwd"].ToString();
113
114            }
115            AccessReader.Close();
116            AccessCommand2.Dispose();
117
118
119
120            if(password.Text.Trim().ToString()==UserPwd)
121            ...{//输入原密码正确
122                string[] RoleArray;
123                RoleArray = selrole.SelectedValue.ToString().Split('|');
124                SqlStr="Update users Set username='"+ username.Text.Trim().ToString() +"',pwd='"+password2.Text.Trim().ToString()+"',rolename='"+ RoleArray[1].ToString() +"',role='"+ RoleArray[0].ToString() +"' Where id="+Request.QueryString["userid"].ToString();
125                OleDbCommand AccessCommand = new OleDbCommand(SqlStr,AccessConnection);
126                AccessCommand.ExecuteNonQuery();
127                AccessCommand.Dispose();
128                AccessConnection.Close();
129                Response.Write("<SCRIPT language='JavaScript'>alert('帐户修改成功');</SCRIPT>");
130            }
131            else
132            ...{
133                Response.Write("<SCRIPT language='JavaScript'>alert('原密码输入错误');</SCRIPT>");
134            }
135        
136        }
137
138        private void deluser_Click(object sender, System.EventArgs e)
139        ...{
140            
141                string SqlStr="";
142                string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
143                OleDbConnection AccessConnection = new OleDbConnection(ConnectionStr);
144                AccessConnection.Open();//打开数据库
145
146                SqlStr = "Delete * From users Where id="+Request.QueryString["userid"].ToString();
147                OleDbCommand AccessCommand2 = new OleDbCommand(SqlStr,AccessConnection);
148                AccessCommand2.ExecuteNonQuery();
149                AccessCommand2.Dispose();
150                AccessConnection.Close();
151                Response.Write("<SCRIPT language='JavaScript'>alert('删除成功');window.location.href='UserList.aspx';</SCRIPT>");
152        }
153    }
154}
155