news.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
// 网站建设专家》一书赠送，未经作者同意，不得随意修改、传播。
//
// 描述:
//   此文件包含下面的类：
//       News
//
// 作者:     王保健
// 时间:     2003/09/15
//
//************************************************************************

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;


namespace AspCool.WebExpert
{
	/// <summary>
	/// Summary description for News.
	/// </summary>
	public class News : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.HyperLink hlPrev;
		protected System.Web.UI.WebControls.HyperLink hlNext;
		protected System.Web.UI.WebControls.HyperLink hlPrev2;
		protected System.Web.UI.WebControls.HyperLink hlNext2;
		protected System.Web.UI.WebControls.HyperLink hlAdd;
		protected System.Web.UI.WebControls.Label lblPage;
		protected System.Web.UI.WebControls.Label lblRecord2;
		protected System.Web.UI.WebControls.Label lblRecord;
		protected System.Web.UI.WebControls.Label lblPage2;
		protected System.Web.UI.WebControls.DataList myDataList;
	
		[Browsable(false),DesignerSerializationVisibility(DesignerSerializationVisibility.Hidden)]
		public bool IsEditable 
		{
            
			get 
			{
				if (Session["UserName"] == null)
				{
					return false;
				}
				else
				{
					if (new AdminDB().IsAdmin(Session["UserName"].ToString()))
						return true;
					else
						return false;
				}
			}
		}
		private void Page_Load(object sender, System.EventArgs e)
		{
			
			if (! this.IsPostBack)
			{				
				NewsDB news = new NewsDB();
				
				int TotalPage;
				int records;
				int page;

				if (Request["page"] ==null)
				{
					page =1;
				}
				else
				{
					try
					{
						page = Convert.ToInt32(Request["page"]);
					}
					catch
					{
						page =1;
					}
				}

				DataSet ds;

				if (Request["SortID"]==null)
				{
					ds = news.CurrentPageNews(page,12,0,out TotalPage,out records);
				}
				else
				{
					ds = news.CurrentPageNews(page,12,Convert.ToInt32(Request["SortID"]),out TotalPage,out records);
				}
				lblPage.Text  = lblPage2.Text = page + "/" +TotalPage;
				lblRecord.Text = lblRecord2.Text = records.ToString();

				string sUrl = Request.Url.ToString();

				int start = sUrl.LastIndexOf("&page");

				if (start != -1)
					sUrl = sUrl.Remove(start,sUrl.Length - start);


				if (page<=1)
				{
					hlPrev.NavigateUrl =sUrl+"&page=1";
					hlPrev2.NavigateUrl =sUrl+"&page=1";
				}
				else
				{
					hlPrev.NavigateUrl = sUrl+"&page=" + (page-1) ;
					hlPrev2.NavigateUrl = sUrl+"&page=" + (page-1) ;
				}

				if (page < TotalPage)
				{
					hlNext.NavigateUrl =sUrl+"&page=" + (page+1);
					hlNext2.NavigateUrl =sUrl+"&page=" + (page+1);
				}
				else
				{
					hlNext.NavigateUrl =sUrl+"&page=" +page;
					hlNext2.NavigateUrl =sUrl+"&page=" +page;
				}

				myDataList.DataSource = ds;
				myDataList.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.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}