newslist.aspx.cs

1.把"Web"文件夹内的文件拷贝到某个文件夹 2.在IIS中新建站点

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 Huayou.Common;
using Huayou.Hyb2b.BaseClass;
using Huayou.Hyb2b.BN;
using Huayou.Hyb2b.DB;
using Huayou.Hyb2b.STRUCTURE;

namespace Huayou.Hyb2b.WebApp.Manage.NewsqManage
{
	/// <summary>
	/// NewsList 的摘要说明。
	/// </summary>
	public class NewsList : CommonBasePage
	{
		protected System.Web.UI.WebControls.Button bnAdd;
		protected System.Web.UI.WebControls.TextBox txProvince;
		protected System.Web.UI.WebControls.TextBox txEdit;
		protected System.Web.UI.WebControls.TextBox txSid;
		protected System.Web.UI.WebControls.TextBox txName;
		protected System.Web.UI.WebControls.DropDownList dlClass;
		protected System.Web.UI.WebControls.TextBox txtParamstr;
		protected Huayou.Common.DataGridTable dgdList;
		protected System.Web.UI.WebControls.Button bnSave;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			if(!Page.IsPostBack)
			{
				this.GetPClass();
				ParamValue = UnPack();
				txtParamstr.Text = PackPart(ParamValue);
				//设置分页
				string pageno = GetValue("pageno");
				if (pageno != null) 
				{
					dgdList.CurrentPageIndex = Convert.ToInt32(pageno) - 1;
				}
				dgdList.DataBind();
			} 
			else 
			{	
				ParamValue = UnPackPart(txtParamstr.Text);
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.dlClass.SelectedIndexChanged += new System.EventHandler(this.dlClass_SelectedIndexChanged);
			this.dgdList.DataBinding += new System.EventHandler(this.dgdList_DataBinding);
			this.dgdList.PageIndexChanged += new System.Web.UI.WebControls.DataGridPageChangedEventHandler(this.dgdList_PageIndexChanged);
			this.dgdList.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.dgdList_ItemDataBound);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void dgdList_DataBinding(object sender, System.EventArgs e)
		{
			string sql="";
			sql="";
			if(this.dlClass.SelectedValue.Equals("-1"))
				sql="select * from News order by Sid desc";
			else
				sql="select * from News where Newssort="+this.dlClass.SelectedValue+" order by Sid desc";
				
			DataTable dt =SqlHelper.ExecuteDataset(BaseConfManager.GetConnectionStr(),CommandType.Text,sql).Tables[0];
			//判断是否超出最大页和数据绑定
			SetPage(dgdList, dt);

			//传递当前页
			AddValue("pageno",Convert.ToString(dgdList.CurrentPageIndex + 1));
			txtParamstr.Text = PackPart(ParamValue);
		}

		private void dgdList_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			dgdList.CurrentPageIndex = e.NewPageIndex;
			dgdList.DataBind();
		}

		private void dgdList_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			if(e.Item.ItemIndex>-1)
			{
				string key1=e.Item.Cells[2].Text;
				if(key1.Equals("1"))
					key1="已审";
				else
					key1="未审";
				e.Item.Cells[2].Text=key1;
			}
		}

		public void GetPClass()
		{
			NewssortBN bn=new NewssortBN(this.Page);
			DataTable dt=null;
			ListItem item;
			try
			{
				bn.Order=" Sid asc";
				dt=bn.GetList();
				for(int i=0;i<dt.Rows.Count;i++)
				{
					item=new ListItem(dt.Rows[i]["Hy_newssort"].ToString(),dt.Rows[i]["Sid"].ToString());
					this.dlClass.Items.Add(item);
				}
			}
			finally
			{
				bn.Dispose();
				bn=null;
			}
		}

		private void dlClass_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			this.dgdList.DataBind();
		}
	}
}