upload.aspx.cs

数字图书馆网站

using System;
using System.Configuration;
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 DigitalLibrary
{
	/// <summary>
	/// Summary description for Upload_aspx.
	/// </summary>
	public class Upload_und_dev : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblPrice;
		protected System.Web.UI.HtmlControls.HtmlGenericControl Div1;
		protected System.Web.UI.WebControls.Button btnUpload;
		protected System.Web.UI.WebControls.TextBox txtAbstract;
		protected System.Web.UI.WebControls.Panel pnlUpload;
		protected System.Web.UI.HtmlControls.HtmlInputFile flUploadFile;
		protected System.Web.UI.WebControls.Image imgImage1;
		protected System.Web.UI.WebControls.Button btnOK;
		protected System.Web.UI.WebControls.Label lblMessage;
		protected System.Web.UI.WebControls.Label lblLogin;
		protected System.Web.UI.WebControls.DropDownList ddlCategory;
		protected System.Web.UI.WebControls.Button btnBack;
		protected System.Web.UI.WebControls.Label lblTitle;

	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// Put user code to initialize the page here
			this.lblLogin.Text = Convert.ToString(Session["Login"]);
			if(!IsPostBack)
			{
				SqlConnection objConnection = new SqlConnection(ConfigurationSettings.AppSettings["DatabaseConnection"]);
				SqlDataAdapter objAdapter = new SqlDataAdapter("SELECT '<Choose a Category>' as Category,0 as CategoryID UNION SELECT Category,CategoryID FROM Category ORDER BY 1",objConnection);
				DataSet objDataSet = new DataSet();
				objAdapter.Fill(objDataSet,"Category");
				objConnection.Close();
				this.ddlCategory.DataSource=objDataSet.Tables["Category"];
				this.ddlCategory.DataTextField="Category";
				this.ddlCategory.DataValueField="CategoryID";
				this.ddlCategory.DataBind();
			}
		}

		#region Web Form Designer generated code
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: This call is required by the ASP.NET Web Form Designer.
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// Required method for Designer support - do not modify
		/// the contents of this method with the code editor.
		/// </summary>
		private void InitializeComponent()
		{    
			this.btnBack.Click += new System.EventHandler(this.btnBack_Click);
			this.btnOK.Click += new System.EventHandler(this.btnOK_Click);
			this.btnUpload.Click += new System.EventHandler(this.btnUpload_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void btnOK_Click(object sender, System.EventArgs e)
		{
			Response.Redirect("Library.aspx");

		}

		private void btnUpload_Click(object sender, System.EventArgs e)
		{
			SqlConnection objConnection = new SqlConnection(ConfigurationSettings.AppSettings["DatabaseConnection"]);		
			SqlDataAdapter objAdapter = new SqlDataAdapter("SELECT ISNULL(MAX(ArticleID),0) FROM Articles",objConnection);
			DataSet objDataSet = new DataSet();
			objAdapter.Fill(objDataSet,"ArticleIDMax");
			objConnection.Open();
			if (flUploadFile.PostedFile != null)
			{
				string[] filepath = flUploadFile.PostedFile.FileName.Split(Convert.ToChar(@"\"));
				try
				{
					SqlCommand objCommand = new SqlCommand("Select CategoryID from Category where Category = '"+ ddlCategory.SelectedItem.Text + "'",objConnection); 
					object obj = new object();
					obj = objCommand.ExecuteScalar();
					//Response.Write(obj.ToString());
					objCommand = new SqlCommand("INSERT INTO Articles (ArticleID, CategoryID, FileName, Abstract, PostedBy) Values ("+(Convert.ToInt32(objDataSet.Tables["ArticleIDMax"].Rows[0][0])+1)+"," +Int32.Parse(obj.ToString())+",'"+filepath[filepath.Length-1]+"','"+this.txtAbstract.Text+"','"+Convert.ToString(Session["Login"])+"')",objConnection);
					objCommand.ExecuteNonQuery();
					objConnection.Close();
					this.flUploadFile.PostedFile.SaveAs(Server.MapPath(ConfigurationSettings.AppSettings["AttachmentsPath"])+filepath[filepath.Length-1]);
					this.lblMessage.Text =  "您的文档已上载!请单击“确定”返回至图书馆";
					this.lblMessage.Visible=true;
					this.btnOK.Visible=true;
				}
				catch (Exception excep)
				{
					Response.Write(excep.Message.ToString());
					this.lblMessage.Text =  "上载文章时出现错误！请单击“确定”进入图书馆并重新尝试";
					this.lblMessage.Visible=true;
					this.btnOK.Visible=true;
				}
			}
		}

		private void btnBack_Click(object sender, System.EventArgs e)
		{
			Session["Login"]=Request.QueryString.Get("LoginID");
			Response.Redirect("Library.aspx");
		}
	}
}