ASP.NET文件上传与数据库存储-优快云博客

上传文件，图片代码 CS 类

using System;

using System.Data;

using System.Data.SqlClient;

using System.Configuration;

using System.Text;

namespace OA.Components

{

/// <summary>

/// Ducument 的摘要说明。

/// </summary>

public class DocumentDB

{

//<summary>

//添加新的文档 AddDocument

//</summary>

//<return> DocumnetID</return>

public int AddDocument(string _Title,string _Content,int _UserID,string _DuUrl,string _Author,string _FromSource)

{

Database db = new Database();

SqlParameter [] param = {

db.CreateInParam("@Title",SqlDbType.VarChar,200,_Title),

db.CreateInParam("@Content",SqlDbType.Text,8000,_Content),

db.CreateInParam("@UserID",SqlDbType.Int,4,_UserID),

db.CreateInParam("@DocUrl",SqlDbType.VarChar,200,_DuUrl),

db.CreateInParam("@Author",SqlDbType.VarChar,200,_Author),

db.CreateInParam("@FromSource",SqlDbType.VarChar,200,_FromSource)

};

return (db.RunProc("Pr_AddDocument",param));

}

应用

ASPX 页 HTML代码

<%@ Page language="c#" Codebehind="AddDocument.aspx.cs" AutoEventWireup="false" Inherits="OA.DesktopModules.Document.AddDocument" %>

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN" >

<HTML>

<HEAD>

<title>AddDocument</title>

</HEAD>

<body>

<asp:RequiredFieldValidator id="rvTitle" runat="server" ErrorMessage="请填写主题" Display="Dynamic" ControlToValidate="Title"></asp:RequiredFieldValidator></DIV>

<asp:Button id="btAdd" runat="server" Text=" 提交 "></asp:Button>  

<asp:Button id="btClear" runat="server" Text=" 返回 "></asp:Button></FONT></DIV>

</form>

</body>

</HTML>

using System;

using System.Collections;

using System.ComponentModel;

using System.Data;

using System.Drawing;

using System.Web;

using System.Web.SessionState;

using System.Web.UI;

using System.Web.UI.WebControls;

using System.Web.UI.HtmlControls;

using System.Text;

using System.IO;

using OA.Components;

namespace OA.DesktopModules.Document

{

/// <summary>

/// AddDocument 的摘要说明。

/// </summary>

public class AddDocument : System.Web.UI.Page

{

protected System.Web.UI.HtmlControls.HtmlInputText Title;

protected System.Web.UI.HtmlControls.HtmlInputText Content;

protected System.Web.UI.HtmlControls.HtmlInputText Author;

protected System.Web.UI.HtmlControls.HtmlInputText From;

protected System.Web.UI.HtmlControls.HtmlInputFile FileDir;

protected System.Web.UI.WebControls.Button btAdd;

protected System.Web.UI.WebControls.RequiredFieldValidator rvTitle;

protected System.Web.UI.WebControls.Button btClear;

private static string FILEDIR = "/DesktopModules/Document/FileLoad";

private void Page_Load(object sender, System.EventArgs e)

{

// 在此处放置用户代码以初始化页面

if (Session["UserID"] == null)

{

// SystemTools.Encrypt("请先登录!");

Response.Redirect("~/home.aspx");

}

Web 窗体设计器生成的代码

private string FileUpload(HtmlInputFile inputFile) //上传文件

{

string fileName="";

if ((inputFile.PostedFile.ContentLength > 0) &&(inputFile.Value.ToString() != ""))

{

string fileTaiName =""; //文件后缀

fileTaiName = inputFile.PostedFile.FileName.Substring(inputFile.PostedFile.FileName.LastIndexOf("."));

fileName = inputFile.PostedFile.FileName.Substring(

inputFile.PostedFile.FileName.LastIndexOf("/"),

inputFile.PostedFile.FileName.Length - inputFile.PostedFile.FileName.LastIndexOf("/"));

string fileTime = DateTime.Now.Year.ToString() + DateTime.Now.Month.ToString() + DateTime.Now.Day.ToString() +

DateTime.Now.Hour.ToString() + DateTime.Now.Second.ToString() + DateTime.Now.Minute.ToString() +

DateTime.Now.Millisecond.ToString();

fileName = "/" + fileTime + GetRandomint() + fileName.Substring(fileName.IndexOf("."),fileName.Length - fileName.IndexOf("."));

}

if (File.Exists(Server.MapPath(Request.ApplicationPath) + FILEDIR + fileName) == false)

{

try

{

if(Directory.Exists(Server.MapPath(Request.ApplicationPath) + FILEDIR) == false )

Directory.CreateDirectory(Server.MapPath(Request.ApplicationPath) + FILEDIR);

inputFile.PostedFile.SaveAs(Server.MapPath(Request.ApplicationPath) + FILEDIR + fileName);

}

catch (Exception ex)

{

throw new Exception(ex.Message,ex);

}

if (fileName == ""){return (null);}

else {return (FILEDIR + fileName);}

}

private string GetRandomint()

{

Random random = new Random();

return (random.Next(10000).ToString());

}

private void btAdd_Click(object sender, System.EventArgs e)

{

if (Title.Value.ToString().Trim().Length > 0)

{

string docUrl = FileUpload(FileDir);

DocumentDB doc = new DocumentDB();

int docID = doc.AddDocument(Title.Value.ToString(),Content.Value.ToString(),

Int32.Parse(Session["UserID"].ToString()),docUrl,Author.Value.ToString(),From.Value.ToString());

if (docID > 0)

{

SystemTools.AlertMsg("上传成功！");

}

else

{

if (File.Exists(Server.MapPath(Request.ApplicationPath)+docUrl) == true)

{

File.Delete(docUrl);

}

SystemTools.AlertMsg("上传失败！");

}

ClearInfo();

}

private void ClearInfo()

{

Title.Value = "";

Content.Value ="";

Author.Value = "";

From.Value = "";

}