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    /// CreatUser 的摘要说明。
 18    /// </summary>
 19    public class CreatUser : 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.Button adduser;
 24        protected System.Web.UI.WebControls.ListBox selrole;
 25        protected System.Web.UI.WebControls.TextBox password2;
 26    
 27        private void Page_Load(object sender, System.EventArgs e)
 28        ...{
 29            if(Request.Cookies["UserCookie"]["role"]!=null)
 30            ...{
 31                if(Request.Cookies["UserCookie"]["role"].ToString().Length!=9)
 32                ...{
 33                    Response.Write("<SCRIPT language='JavaScript'>alert('您不是管理员！');window.parent.location.href='Login.aspx'; </SCRIPT>");
 34                }
 35            }
 36
 37            if(!Page.IsPostBack)
 38            ...{
 39                string SqlStr="";
 40                string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
 41                OleDbConnection AccessConnection = new OleDbConnection(ConnectionStr);
 42                AccessConnection.Open();//打开数据库
 43                SqlStr="Select * From Role  Order By Id DESC";
 44                OleDbCommand AccessCommand = new OleDbCommand(SqlStr,AccessConnection);
 45
 46                OleDbDataReader AccessReader = AccessCommand.ExecuteReader();
 47                int i=0;
 48                ListItem AddItem ;
 49                while(AccessReader.Read())
 50                ...{
 51                    AddItem = new ListItem(AccessReader["rolename"].ToString(),AccessReader["role"].ToString()+"|"+AccessReader["rolename"].ToString());
 52                    selrole.Items.Add(AddItem);
 53                    i++;
 54
 55                }
 56                if(i==0)
 57                ...{
 58                    AddItem = new ListItem("尚未创建角色","0");
 59                    selrole.Items.Add(AddItem);
 60                }
 61            
 62
 63                AccessReader.Close();
 64
 65                AccessCommand.Dispose();
 66
 67                AccessConnection.Close();
 68            }
 69
 70
 71            // 在此处放置用户代码以初始化页面
 72        }
 73
 74        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 75        override protected void OnInit(EventArgs e)
 76        ...{
 77            //
 78            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 79            //
 80            InitializeComponent();
 81            base.OnInit(e);
 82        }
 83        
 84        /**//// <summary>
 85        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 86        /// 此方法的内容。
 87        /// </summary>
 88        private void InitializeComponent()
 89        ...{    
 90            this.adduser.Click += new System.EventHandler(this.adduser_Click);
 91            this.Load += new System.EventHandler(this.Page_Load);
 92
 93        }
 94        #endregion
 95
 96        private void adduser_Click(object sender, System.EventArgs e)
 97        ...{
 98            if(username.Text=="")
 99            ...{
100                Response.Write("<SCRIPT language='JavaScript'>alert('请填写用户名');window.location.href='CreateUser.aspx'; </SCRIPT>");
101
102            }
103            else
104            ...{
105                string SqlStr;
106                string[] Selrole_Array;
107                string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
108                OleDbConnection AccessConnection1 = new OleDbConnection(ConnectionStr);
109                AccessConnection1.Open();//打开数据库
110
111                SqlStr = "Select * From Users Where username='"+ username.Text +"'";
112                OleDbCommand AccessCommand = new OleDbCommand(SqlStr,AccessConnection1);;
113                
114                OleDbDataReader AccessReader = AccessCommand.ExecuteReader();
115                if(AccessReader.Read())
116                ...{
117                    AccessReader.Close();
118                    AccessCommand.Dispose();
119                    Response.Write("<SCRIPT language='JavaScript'>alert('用户名称已经存在');window.location.href='CreateRole.aspx'; </SCRIPT>");
120
121                }
122                else
123                ...{
124                    if(password.Text!=password2.Text)
125                    ...{
126                        Response.Write("<SCRIPT language='JavaScript'>alert('两次输入的密码不一致');window.location.href='CreateUser.aspx'; </SCRIPT>");
127                    }
128                    else
129                    ...{
130                        
131                        OleDbCommand AccessCommand1;
132                        Selrole_Array = selrole.SelectedValue.ToString().Split('|');
133            
134                        SqlStr = "Insert Into users(username,pwd,rolename,role,addtime) values('"+username.Text.ToString()+"','"+password.Text.ToString()+"','"+Selrole_Array[1].ToString()+"','"+Selrole_Array[0].ToString()+"','"+System.DateTime.Now.ToString()+"')";
135            
136                        AccessCommand1 = new OleDbCommand(SqlStr,AccessConnection1);
137                        AccessCommand1.ExecuteNonQuery();
138            
139                        AccessCommand1.Dispose();
140                        AccessConnection1.Close();
141                        Response.Write("<SCRIPT language='JavaScript'>alert('帐户创建成功！');window.location.href='CreateUser.aspx'; </SCRIPT>");
142                    }
143                }
144            }
145        }
146    }
147}
148