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    /// RoleList 的摘要说明。
 18    /// </summary>
 19    public class RoleList : System.Web.UI.Page
 20    ...{
 21        protected System.Web.UI.WebControls.Label roleliststr;
 22    
 23        private void Page_Load(object sender, System.EventArgs e)
 24        ...{
 25            if(Request.Cookies["UserCookie"]["role"]!=null)
 26            ...{
 27                if(Request.Cookies["UserCookie"]["role"].ToString().Length!=9)
 28                ...{
 29                    Response.Write("<SCRIPT language='JavaScript'>alert('您不是管理员！');window.parent.location.href='Login.aspx'; </SCRIPT>");
 30                }
 31            }
 32
 33            StringBuilder RoleList_Builder= new StringBuilder();//记录查询结果
 34            string RoleListString = "";
 35
 36            string SqlStr="";
 37            string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
 38            OleDbConnection AccessConnection = new OleDbConnection(ConnectionStr);
 39            AccessConnection.Open();//打开数据库
 40
 41            SqlStr="Select * From Role Where id>0";
 42
 43            OleDbCommand AccessCommand = new OleDbCommand(SqlStr,AccessConnection);
 44
 45            OleDbDataReader AccessReader = AccessCommand.ExecuteReader();
 46            
 47            int Rownum=0;
 48            string RoledetailStr="可查看：";
 49            string[] Rolearray;
 50            while(AccessReader.Read())
 51            ...{//提取信息
 52                Rolearray = AccessReader["role"].ToString().Split(',');
 53                for(int i=0;i<Rolearray.Length;i++)
 54                ...{
 55                    switch(Rolearray[i].ToString())
 56                    ...{
 57                        case "P":
 58                            RoledetailStr = RoledetailStr + "PDF文件 ";
 59                            break;
 60                        case "W":
 61                            RoledetailStr = RoledetailStr + "WORD文件 ";
 62                            break;
 63                        case "E":
 64                            RoledetailStr = RoledetailStr + "EXCEL文件 ";
 65                            break;
 66                        case "J":
 67                            RoledetailStr = RoledetailStr + "JPG文件 ";
 68                            break;
 69                        case "D":
 70                            RoledetailStr = RoledetailStr + "DWG文件 ";
 71                            break;
 72                        default:break;
 73                    }
 74                }
 75
 76
 77                if(Rownum==0)
 78                    RoleListString = RoleListString +"<TR bgcolor='#E4E4E4' height=30><TD style='FONT-SIZE: 12px' align='left' width='100%' height='7'><table width='100%'><tr><td width='20%' align='center'><font class='font_12px'>"+AccessReader["rolename"].ToString()+"</font></td><td width='50%' align='center'><font class='font_12px'>"+RoledetailStr+"</font></td><td width='20%' align='center' valign='bottom'><input type='button' class='textinput' style='FONT-SIZE:12px' value='编 辑' onclick=window.document.location.href='EditRole.aspx?roleid="+AccessReader["id"].ToString()+"'  style='Cursor:hand;'></td></tr></table></TD></TR>";
 79                else
 80                    RoleListString = RoleListString +"<TR bgcolor='#FFFFFF' height=30><TD style='FONT-SIZE: 12px' align='left' width='100%' height='7'><table width='100%'><tr><td width='20%' align='center'><font class='font_12px'>"+AccessReader["rolename"].ToString()+"</font></td><td width='50%' align='center'><font class='font_12px'>"+RoledetailStr+"</font></td><td width='20%' align='center' valign='bottom'><input type='button' class='textinput' style='FONT-SIZE:12px' value='编 辑' onclick=window.document.location.href='EditRole.aspx?roleid="+AccessReader["id"].ToString()+"'  style='Cursor:hand;'></td></tr></table></TD></TR>";
 81
 82                Rownum++;
 83                if(Rownum==2) Rownum=0;
 84                RoledetailStr="可查看：";
 85
 86            }
 87            RoleList_Builder.Append(RoleListString);
 88            roleliststr.Text = RoleList_Builder.ToString(); 
 89
 90            AccessReader.Close();
 91            AccessCommand.Dispose();
 92            AccessConnection.Close();
 93            // 在此处放置用户代码以初始化页面
 94        }
 95
 96        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
 97        override protected void OnInit(EventArgs e)
 98        ...{
 99            //
100            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
101            //
102            InitializeComponent();
103            base.OnInit(e);
104        }
105        
106        /**//// <summary>
107        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
108        /// 此方法的内容。
109        /// </summary>
110        private void InitializeComponent()
111        ...{    
112            this.Load += new System.EventHandler(this.Page_Load);
113
114        }
115        #endregion
116    }
117}
118