当前文件： FileManageSys/CreateRole_add.aspx.cs[3K，2009-6-12 11:42:32]，打开代码结构图

		            
  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.Data.OleDb;
 12
 13namespace FileManage_Sys
 14...{
 15    /**//// <summary>
 16    /// WebForm1 的摘要说明。
 17    /// </summary>
 18    public class WebForm1 : System.Web.UI.Page
 19    ...{
 20        private void Page_Load(object sender, System.EventArgs e)
 21        ...{
 22            if(!(Request.QueryString["rolename"]==null|Request.QueryString["role"]==null))
 23            ...{
 24                string SqlStr="",Flag;
 25                string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
 26                OleDbConnection AccessConnection = new OleDbConnection(ConnectionStr);
 27                AccessConnection.Open();//打开数据库
 28                Flag = Request.QueryString["flag"].ToString();
 29                OleDbCommand AccessCommand;
 30                OleDbCommand AccessCommand2;
 31                
 32
 33
 34                switch(Flag)
 35                ...{
 36                    case "add":
 37
 38                        SqlStr="Select * From role Where rolename='"+ Request.QueryString["rolename"].ToString().Trim() +"'";
 39                        AccessCommand2 = new OleDbCommand(SqlStr,AccessConnection);
 40                        OleDbDataReader AccessReader = AccessCommand2.ExecuteReader();
 41                        if(AccessReader.Read())
 42                        ...{
 43                            AccessReader.Close();
 44                            AccessCommand2.Dispose();
 45                            Response.Write("<SCRIPT language='JavaScript'>alert('角色名称已经存在');window.location.href='CreateRole.aspx'; </SCRIPT>");
 46
 47                        }
 48                        else
 49                        ...{
 50                            AccessReader.Close();
 51                            AccessCommand2.Dispose();
 52                            SqlStr="Insert Into role(rolename,role) values('"+ Request.QueryString["rolename"].ToString().Trim()+"','"+ Request.QueryString["role"].ToString().Trim() +"') ";
 53                            AccessCommand = new OleDbCommand(SqlStr,AccessConnection);
 54                            AccessCommand.ExecuteNonQuery();
 55                            AccessCommand.Dispose();
 56                            AccessConnection.Close();
 57                            Response.Write("<SCRIPT language='JavaScript'>alert('角色创建成功！');window.location.href='CreateRole.aspx'; </SCRIPT>");
 58
 59                        }
 60                        break;
 61                    case "edit":
 62                        SqlStr="Update role set rolename='"+ Request.QueryString["rolename"].ToString().Trim() +"',role='"+Request.QueryString["role"].ToString().Trim()+"' Where id="+Request.QueryString["roleid"].ToString();
 63                        AccessCommand = new OleDbCommand(SqlStr,AccessConnection);
 64                        AccessCommand.ExecuteNonQuery();
 65                        AccessCommand.Dispose();
 66                        AccessConnection.Close();
 67                        Response.Write("<SCRIPT language='JavaScript'>alert('角色修改成功！');window.location.href='RoleList.aspx'; </SCRIPT>");
 68                        break;
 69                    default:break;
 70                }
 71            }
 72            else
 73            ...{
 74                Response.Write("<SCRIPT language='JavaScript'>alert('非法参数！');window.location.href='CreateRole.aspx'; </SCRIPT>");
 75
 76            }
 77
 78            
 79            // 在此处放置用户代码以初始化页面
 80        
 81        }
 82
 83        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 84        override protected void OnInit(EventArgs e)
 85        ...{
 86            //
 87            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
 88            //
 89            InitializeComponent();
 90            base.OnInit(e);
 91        }
 92        
 93        /**//// <summary>
 94        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
 95        /// 此方法的内容。
 96        /// </summary>
 97        private void InitializeComponent()
 98        ...{    
 99            this.Load += new System.EventHandler(this.Page_Load);
100        }
101        #endregion
102    }
103}
104