当前文件： FileManageSys/FileList_m.aspx.cs[5K，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.Text;
 12using System.Data.OleDb;
 13
 14namespace FileManage_Sys
 15...{
 16    /**//// <summary>
 17    /// FileList_m 的摘要说明。
 18    /// </summary>
 19    public class FileList_m : System.Web.UI.Page
 20    ...{
 21        protected System.Web.UI.WebControls.Label zu_file;
 22        protected System.Web.UI.WebControls.Label fileliststr;
 23    
 24        private void Page_Load(object sender, System.EventArgs e)
 25        ...{
 26            if(Request.Cookies["UserCookie"]["role"]!=null)
 27            ...{
 28                if(Request.Cookies["UserCookie"]["role"].ToString().Length!=9)
 29                ...{
 30                    Response.Write("<SCRIPT language='JavaScript'>alert('您不是管理员！');window.parent.location.href='Login.aspx'; </SCRIPT>");
 31                }
 32            }
 33            string SqlStr="";
 34            string ConnectionStr = "PROVIDER=Microsoft.Jet.OLEDB.4.0;DATA Source="+Server.MapPath(System.Configuration.ConfigurationSettings.AppSettings["ConnectionStr"].ToString());//从Web.config文件中获取数据库连接字符串
 35            OleDbConnection AccessConnection = new OleDbConnection(ConnectionStr);
 36            AccessConnection.Open();//打开数据库
 37
 38            if(Request.QueryString["fileid"]!=null)
 39            ...{//删除文件
 40                SqlStr="Delete * From files Where id="+ Request.QueryString["fileid"].ToString();
 41                OleDbCommand AccessCommand = new OleDbCommand(SqlStr,AccessConnection);
 42                AccessCommand.ExecuteNonQuery();
 43                AccessCommand.Dispose();
 44                Response.Write("<SCRIPT language='JavaScript'>alert('删除成功');window.location.href='FileList_m.aspx?zu="+ Request.QueryString["zu"].ToString() +"'; </SCRIPT>");
 45
 46            }
 47            else
 48            ...{
 49                if(Request.QueryString["zu"]!=null)
 50                ...{
 51                    zu_file.Text = Request.QueryString["zu"].ToString();
 52                    string File_Zu;
 53                    File_Zu = Request.QueryString["zu"].ToString();//文件组
 54
 55                    StringBuilder FileList_Builder= new StringBuilder();//记录查询结果
 56                    string FileListString = "";
 57
 58                    SqlStr="Select * From files Where filearea='"+ File_Zu +"' Order By Id DESC";
 59
 60                    OleDbCommand AccessCommand = new OleDbCommand(SqlStr,AccessConnection);
 61
 62                    OleDbDataReader AccessReader = AccessCommand.ExecuteReader();
 63            
 64                    int Rownum=0;
 65
 66                    string FileType="";//文件类型
 67                    while(AccessReader.Read())
 68                    ...{//提取信息
 69                    
 70                        switch(AccessReader["fileexe"].ToString())
 71                        ...{
 72                            case ".pdf":
 73                                FileType = "PDF文件";
 74                                break;
 75                            case ".doc":
 76                                FileType = "WORD文件";
 77                                break;
 78                            case ".xls":
 79                                FileType = "EXCEL文件";
 80                                break;
 81                            case ".jpg":
 82                                FileType = "JPG文件";
 83                                break;
 84                            case ".dwg":
 85                                FileType = "DWG文件";
 86                                break;
 87                            case ".PDF":
 88                                FileType = "PDF文件";
 89                                break;
 90                            case ".DOC":
 91                                FileType = "WORD文件";
 92                                break;
 93                            case ".Xls":
 94                                FileType = "EXCEL文件";
 95                                break;
 96                            case ".JPG":
 97                                FileType = "JPG文件";
 98                                break;
 99                            case ".DWG":
100                                FileType = "DWG文件";
101                                break;
102                            default:break;
103                        }
104
105
106                        if(Rownum==0)
107                            FileListString = FileListString +"<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'><a href='"+ AccessReader["filepath"].ToString()+AccessReader["filename"].ToString() +"' target='_blank'>"+AccessReader["filename"].ToString()+"</a></font></td><td width='20%' align='center'><font class='font_12px'>"+File_Zu+"类文件组</font></td><td width='20%' align='center'><font class='font_12px'>"+ FileType +"</font></td><td width='20%' align='center'><font class='font_12px'>"+ AccessReader["addtime"].ToString() +"</font></td><td width='20%' align='center' valign='bottom'><input type='button' class='textinput' style='FONT-SIZE:12px' value='删 除' onclick= window.document.location.href='FileList_m.aspx?fileid="+AccessReader["id"].ToString()+"&zu="+ Request.QueryString["zu"].ToString() +"' style='Cursor:hand;'></td></tr></table></TD></TR>";
108                        else
109                            FileListString = FileListString +"<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'><a href='"+ AccessReader["filepath"].ToString()+AccessReader["filename"].ToString() +"' target='_blank'>"+AccessReader["filename"].ToString()+"</a></font></td><td width='20%' align='center'><font class='font_12px'>"+File_Zu+"类文件组</font></td><td width='20%' align='center'><font class='font_12px'>"+ FileType +"</font></td><td width='20%' align='center'><font class='font_12px'>"+ AccessReader["addtime"].ToString() +"</font></td><td width='20%' align='center' valign='bottom'><input type='button' class='textinput' style='FONT-SIZE:12px' value='删 除' onclick=window.document.location.href='FileList_m.aspx?fileid="+AccessReader["id"].ToString()+"&zu="+ Request.QueryString["zu"].ToString() +"' style='Cursor:hand;'></td></tr></table></TD></TR>";
110
111                        Rownum++;
112                        if(Rownum==2) Rownum=0;
113
114                    }
115                    if(FileListString =="")
116                    ...{
117                        FileListString ="<TR bgcolor='#FFFFFF' height=30><TD style='FONT-SIZE: 12px' align='center' width='100%' height='7'>此文件组暂无文件</TD></TR>";
118                    }
119                    FileList_Builder.Append(FileListString);
120                    fileliststr.Text =FileList_Builder.ToString(); 
121
122                    AccessReader.Close();
123                    AccessCommand.Dispose();
124                    AccessConnection.Close();
125                }
126            }
127            // 在此处放置用户代码以初始化页面
128        }
129
130        Web 窗体设计器生成的代码#region Web 窗体设计器生成的代码
131        override protected void OnInit(EventArgs e)
132        ...{
133            //
134            // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
135            //
136            InitializeComponent();
137            base.OnInit(e);
138        }
139        
140        /**//// <summary>
141        /// 设计器支持所需的方法 - 不要使用代码编辑器修改
142        /// 此方法的内容。
143        /// </summary>
144        private void InitializeComponent()
145        ...{    
146            this.Load += new System.EventHandler(this.Page_Load);
147
148        }
149        #endregion
150    }
151}
152