editnews.aspx.cs

This is not a very mean things

//-----------------------------------------------------------------------------
//
// WebExpert.NET 1.0 
//
// (c) 2003, www.AspCool.com. All rights reserved.
// ASP酷技术网版权所有
//
// 该源码下载自：http://www.51aspx.com
// 邮箱：[e-mail]
//
// 版权声明：本程序仅供学习使用，你也可以修改后在网站上使用，但使用时必
// 须保留ASP酷技术网(www.AspCool.com)的版权信息和链接。本程序随《ASP.NET
// 网站建设专家》一书赠送，未经作者同意，不得随意修改、传播。
//
// 描述:
//   此文件包含下面的类：
//       EditNews
//
// 作者:     王保健
// 时间:     2003/09/15
//
//-----------------------------------------------------------------------------

using System;
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 AspCool.WebExpert
{
	/// <summary>
	/// Summary description for EditNews.
	/// </summary>
	public class EditNews : System.Web.UI.Page
	{
		int itemId = 0;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator1;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator2;
		protected System.Web.UI.WebControls.LinkButton UpdateButton;
		protected System.Web.UI.WebControls.LinkButton CancelButton;
		protected System.Web.UI.WebControls.LinkButton DeleteButton;
		protected System.Web.UI.WebControls.TextBox Title;
		protected System.Web.UI.WebControls.TextBox Content;
		protected System.Web.UI.WebControls.RequiredFieldValidator RequiredFieldValidator3;
		protected System.Web.UI.WebControls.TextBox ExpireField;
		protected System.Web.UI.WebControls.DropDownList ddlNewsSort;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			
			if (Session["UserName"] == null || (! new AdminDB().IsAdmin(Session["UserName"].ToString())))
			{
				Response.Redirect("~/Admin/AccessDenied.aspx");
			}
			
			// Determine ItemId of News to Update
			if (Request.Params["ItemId"] != null) 
			{
				itemId = Int32.Parse(Request.Params["ItemId"]);
			}

			// If the page is being requested the first time, determine if an
			// News itemId value is specified, and if so populate page
			// contents with the news details

			if (Page.IsPostBack == false) 
			{
				ddlNewsSort.DataSource = new NewsDB().GetNewsSort();
				ddlNewsSort.DataTextField = "SortName";
				ddlNewsSort.DataValueField = "SortID";
				ddlNewsSort.DataBind();

			
				if (itemId != 0) 
				{
					// Obtain a single row of news information
					NewsDB news = new NewsDB();
					SqlDataReader dr = news.GetSingleNews(itemId);
                
					// Read first row from database
					dr.Read();

					Title.Text = (String) dr["Title"];
					Content.Text = (String) dr["Content"];
					ddlNewsSort.SelectedValue = ((int)dr["SortID"]).ToString();
					ExpireField.Text = ((DateTime)dr["ExpireDate"]).ToString("yyyy/MM/dd");

					dr.Close();
				}
				else
				{
					ExpireField.Text = DateTime.Now.AddYears(1).ToString("yyyy/MM/dd");
				}
				
				// Store URL Referrer to return to portal
				ViewState["UrlReferrer"] = Request.UrlReferrer.ToString();
			}
			DeleteButton.Attributes.Add( "onClick", "javascript: return confirm('你确信要删除这条记录吗？?');");
	
		}

		#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.UpdateButton.Click += new System.EventHandler(this.UpdateButton_Click);
			this.CancelButton.Click += new System.EventHandler(this.CancelButton_Click);
			this.DeleteButton.Click += new System.EventHandler(this.DeleteButton_Click);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void UpdateButton_Click(object sender, System.EventArgs e)
		{
			// Only Update if the Entered Data is Valid
			if (Page.IsValid == true) 
			{

				// Create an instance of the news DB component
				NewsDB news = new NewsDB();

				if (itemId == 0) 
				{

					// Add the news within the News table
					news.AddNews(itemId,Title.Text,Convert.ToInt32(ddlNewsSort.SelectedValue),Content.Text,DateTime.Parse(ExpireField.Text));
				}
				else 
				{

					// Update the news within the News table
					news.UpdateNews(itemId,Title.Text,Convert.ToInt32(ddlNewsSort.SelectedValue),Content.Text,DateTime.Parse(ExpireField.Text));
			
				}

				// Redirect back to the portal home page
				Response.Redirect((String) ViewState["UrlReferrer"]);
			}
		}

		private void CancelButton_Click(object sender, System.EventArgs e)
		{
			Response.Redirect((String) ViewState["UrlReferrer"]);
		}

		private void DeleteButton_Click(object sender, System.EventArgs e)
		{
			// Only attempt to delete the item if it is an existing item
			// (new items will have "ItemId" of 0)

			if (itemId != 0) 
			{

				NewsDB news = new NewsDB();
				news.DeleteNews(itemId);
			}

			// Redirect back to the portal home page
			Response.Redirect((String) ViewState["UrlReferrer"]);
		
		}
	}
}