articleview.aspx.cs

ASP.NET的一些开发实例,有论坛管理系统等

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 Service;

namespace PKMS
{
	/// <summary>
	/// ArticleView 的摘要说明。
	/// </summary>
	public class ArticleView : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label Label_Topic;
		protected System.Web.UI.WebControls.Label Label_KeyWords;
		protected System.Web.UI.WebControls.Label Label_Date;
		protected System.Web.UI.WebControls.Label Label_Content;
		protected System.Web.UI.WebControls.Label Label_Previous;
		protected System.Web.UI.WebControls.Label Label_Next;
		protected System.Web.UI.WebControls.Button Button_Edit;
		protected System.Web.UI.WebControls.Button Button_Delete;
		protected System.Web.UI.WebControls.Label Label_Source;
		private string ArticleID
		{
			get
			{
				return this.ViewState["ArticleID"].ToString();
			}
			set
			{
				this.ViewState["ArticleID"] = value;
			}
		}

		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!this.IsPostBack)
			{
				this.Button_Delete.Attributes.Add("onClick","return confirm('确实要删除这篇文档吗？');");
				try
				{
					ArticleID = this.Request.QueryString["ArticleID"];
					Service.DataAccessor da = new DataAccessor();
					DataTable dt = da.ExecuteDataTable("Select Topic, KeyWords, Source, Content, UploadDate, UpdateDate From ARTICLE Where ArticleID=" + ArticleID);
					DataRow dr = dt.Rows[0];
					this.Label_Topic.Text = dr["Topic"].ToString();
					this.Label_KeyWords.Text += dr["KeyWords"].ToString();
					this.Label_Source.Text += dr["Source"].ToString();
					this.Label_Content.Text = Service.TextParser.Parser(dr["Content"].ToString(), true);
					this.Label_Date.Text = "上传日期：" + ((DateTime)(dr["UploadDate"])).ToString("yyyy-MM-dd");
					if(dr["UpdateDate"] != DBNull.Value)
					{
						this.Label_Date.Text += "&nbsp;&nbsp;&nbsp;&nbsp;更新日期：" + ((DateTime)dr["UpdateDate"]).ToString("yyyy-MM-dd");
					}
					this.Label_Previous.Text += this.GetPreviousArticle(da, ArticleID);
					this.Label_Next.Text += this.GetNextArticle(da, ArticleID);
					da.Close();
				}
				catch
				{
					this.Response.Write("<script>alert('该文档不存在，可能已经被删除！');window.close();</script>");
				}
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Button_Edit.Click += new System.EventHandler(this.Button_Edit_Click);
			this.Button_Delete.Click += new System.EventHandler(this.Button_Delete_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion





		/// <summary>
		/// 查找上一篇文档
		/// </summary>
		/// <param name="da">数据访问对象</param>
		/// <param name="ArticleID">文档ID</param>
		/// <returns>html格式化的字符串</returns>	
		private string GetPreviousArticle(DataAccessor da, string ArticleID)
		{
			string sql = "Select top 1 A.ArticleID, A.Topic, A.FolderID, A.UploadDate From Article A, Article B" +
						" Where A.FolderID = B.FolderID And A.UploadDate > B.UploadDate" +
						" And B.ArticleID = " + ArticleID;
			DataTable dt = da.ExecuteDataTable(sql);
			if(dt.Rows.Count != 0)
			{
				return "<a href=\"ArticleView.aspx?ArticleID=" + dt.Rows[0]["ArticleID"].ToString() + "\">" + dt.Rows[0]["Topic"].ToString() + "</a>";
			}
			else
			{
				return "无";
			}
		}



		/// <summary>
		/// 查找下一篇文档
		/// </summary>
		/// <param name="da">数据访问对象</param>
		/// <param name="ArticleID">文档ID</param>
		/// <returns>html格式化的字符串</returns>	
		private string GetNextArticle(DataAccessor da, string ArticleID)
		{
			string sql = "Select top 1 A.ArticleID, A.Topic, A.FolderID, A.UploadDate From Article A, Article B" +
						" Where A.FolderID = B.FolderID And A.UploadDate < B.UploadDate" +
						" And B.ArticleID = " + ArticleID +
						" Order By A.UploadDate Desc";
			DataTable dt = da.ExecuteDataTable(sql);
			if(dt.Rows.Count != 0)
			{
				return "<a href=\"ArticleView.aspx?ArticleID=" + dt.Rows[0]["ArticleID"].ToString() + "\">" + dt.Rows[0]["Topic"].ToString() + "</a>";
			}
			else
			{
				return "无";
			}
		}


		/// <summary>
		/// 编辑
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void Button_Edit_Click(object sender, System.EventArgs e)
		{
			this.Response.Redirect("ArticleEdit.aspx?ArticleID=" + ArticleID);
		}


		/// <summary>
		/// 删除
		/// </summary>
		/// <param name="sender"></param>
		/// <param name="e"></param>
		private void Button_Delete_Click(object sender, System.EventArgs e)
		{
			string sql = "Delete From ARTICLE Where ArticleID = " + ArticleID;
			DataAccessor da = new DataAccessor();
			if(da.ExecuteNonQuery(sql) != -1)
			{
				this.Response.Write("<script>alert('该文档已经被成功删除！');window.close();</script>");
			}
			else
			{
				this.Response.Write("<script>alert('该文档删除失败！');window.close();</script>");
			}

			da.Close();
		}

	}
}