FileContents.aspx.cs
资源名称:OA_at.rar [点击查看]
上传用户:tree100901
上传日期:2007-06-03
资源大小:2295k
文件大小:3k
源码类别:
OA系统
开发平台:
C#
- using System;
- using System.IO;
- using System.Collections;
- using System.ComponentModel;
- using System.Data;
- using System.Data.SqlClient;
- using System.Drawing;
- using System.Web;
- using System.Web.SessionState;
- using System.Web.UI;
- using System.Web.UI.WebControls;
- using System.Web.UI.HtmlControls;
- namespace OA
- {
- /// <summary>
- /// FileContents 的摘要说明。
- /// </summary>
- public class FileContents : System.Web.UI.Page
- {
- protected System.Data.SqlClient.SqlConnection MyConnection;
- private void Page_Load(object sender, System.EventArgs e)
- {
- MyConnection=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnectionString"]);
- string fid="";
- string [] fileEntries = Directory.GetFiles(Server.MapPath("filestemp"));
- foreach(string fileName0 in fileEntries)
- {
- File.Delete(fileName0);
- }
- if(Request.Params["FileID"]!=null)
- fid=Request.Params["FileID"].ToString();
- else
- if(Session["FileID"]!=null)
- fid=Session["FileID"].ToString();
- SqlCommand MyCommand = new SqlCommand("FileContents",MyConnection);
- MyCommand.CommandType = CommandType.StoredProcedure;
- MyCommand.Parameters.Add(new SqlParameter("@FileID", SqlDbType.Int, 4));
- MyCommand.Parameters["@FileID"].Value = Int32.Parse(fid);
- MyConnection.Open();
- SqlDataReader myReader = MyCommand.ExecuteReader();
- myReader.Read();
- Response.ContentType = myReader["ContentType"].ToString();
- Response.OutputStream.Write((byte[])myReader["Contents"], 0, Int32.Parse(myReader["ByteSize"].ToString()));
- myReader.Close();
- MyConnection.Close();
- Response.End();
- /* string fileName = Path.GetTempFileName();
- int len=fileName.Length-4;
- int len1=fileName.Length-9;
- fileName=fileName.Remove(len,4);
- fileName=fileName.Substring(len1,5);
- string lname;
- switch(myReader["ContentType"].ToString())
- {
- case "application/msword":
- lname=".DOC";
- break;
- case "application/vnd-msexcel":
- lname=".xls";
- break;
- default:
- lname=".txt";
- break;
- }
- string newfile="FilesTemp/"+fileName+lname;
- byte[] bytes = (byte[])myReader["Contents"];
- FileStream fs = new FileStream(Server.MapPath(newfile), FileMode.Create);
- fs.Write((byte[])myReader["Contents"], 0, bytes.Length);
- Response.Redirect("FilesTemp//"+fileName+lname);
- */
- // 在此处放置用户代码以初始化页面
- }
- #region Web 窗体设计器生成的代码
- override protected void OnInit(EventArgs e)
- {
- //
- // CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
- //
- InitializeComponent();
- base.OnInit(e);
- }
- /// <summary>
- /// 设计器支持所需的方法 - 不要使用代码编辑器修改
- /// 此方法的内容。
- /// </summary>
- private void InitializeComponent()
- {
- this.Load += new System.EventHandler(this.Page_Load);
- }
- #endregion
- }
- }