admin_viewnews.aspx.cs

一个出售宠物的网站,比较全面

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 System.Data.SqlClient;
using System.Configuration;
namespace hellopet
{
	/// <summary>
	/// WebForm2 的摘要说明。
	/// </summary>
	public class WebForm2 : System.Web.UI.Page
	{
	    protected System.Web.UI.WebControls.Label lblPageCount;
	    protected System.Web.UI.WebControls.Label lblCurrentPage;
	    protected System.Web.UI.WebControls.LinkButton LinkButton1;
	    protected System.Web.UI.WebControls.LinkButton LinkButton2;
	    protected System.Web.UI.WebControls.LinkButton LinkButton4;
	    protected System.Web.UI.WebControls.DataGrid DataGrid1;
	    protected System.Web.UI.WebControls.LinkButton LinkButton3;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
		    if(Session["admin"]==null)
			Response.Redirect("admin_Login.aspx");
		    if (!Page.IsPostBack)
		    {
			BindData();
			showStatus();
			
		    } // 在此处放置用户代码以初始化页面
		}
	    public void  BindData()
	    {
		Admins showNews=new Admins();
		try
		{
		    DataGrid1.DataSource=showNews.queryNews().Tables["news"].DefaultView;
		    DataGrid1.DataBind();
		   
		}
		catch(Exception e)
		{
		  Response.Write(e.ToString());
		}
	    }
	    public void showStatus()
	    {
		lblPageCount.Text="共"+DataGrid1.PageCount.ToString()+"页";
		lblCurrentPage.Text="第"+(DataGrid1.CurrentPageIndex+1).ToString()+"页";
	    }
	    #region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
		    this.DataGrid1.ItemCreated += new System.Web.UI.WebControls.DataGridItemEventHandler(this.changeRowColor);
		    this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
		    this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound_1);
		    this.LinkButton1.Click += new System.EventHandler(this.LinkButton1_Click);
		    this.LinkButton2.Click += new System.EventHandler(this.LinkButton2_Click);
		    this.LinkButton4.Click += new System.EventHandler(this.LinkButton4_Click);
		    this.LinkButton3.Click += new System.EventHandler(this.LinkButton3_Click);
		    this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

	    private void LinkButton1_Click(object sender, System.EventArgs e)
	    {
		    DataGrid1.CurrentPageIndex=0;
		BindData();
		showStatus();
	    }

	    private void LinkButton2_Click(object sender, System.EventArgs e)
	    {
		    DataGrid1.CurrentPageIndex=DataGrid1.PageCount-1;
		BindData();
		showStatus();
	    }

	    private void LinkButton4_Click(object sender, System.EventArgs e)
	    {
		if(DataGrid1.CurrentPageIndex>0)
		{
		    DataGrid1.CurrentPageIndex-=1;
		}
		BindData();
		showStatus();
	    }

	    private void LinkButton3_Click(object sender, System.EventArgs e)
	    {
		if(DataGrid1.CurrentPageIndex<DataGrid1.PageCount-1)
		{
		    DataGrid1.CurrentPageIndex+=1;
		}
		BindData();
		showStatus();
	    }
	    public void changeRowColor(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
	    {
		//如果是数据项并且是交替项
		if(e.Item.ItemType == ListItemType.Item  || e.Item.ItemType == ListItemType.AlternatingItem)
		{
		    //添加自定义属性，当鼠标移过来时设置该行的背景色为"6699ff",并保存原背景色
		    e.Item.Attributes.Add("onmouseover","currentcolor=this.style.backgroundColor;this.style.backgroundColor='#bee7ff'");
		    //添加自定义属性，当鼠标移走时还原该行的背景色
		    e.Item.Attributes.Add("onmouseout","this.style.backgroundColor=currentcolor");
		    //点击删除时提示对话框
		   // ((LinkButton)e.Item.Cells[2].Controls[0]).Attributes.Add("onClick","return confirm('你确定要删除这一项？');");         

		} 
	    }
	   


	    private void DataGrid1_EditCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
	    {
		string ID=DataGrid1.DataKeys[e.Item.ItemIndex].ToString();
		Response.Redirect("admin_updatenews.aspx?id="+ID);
	    }

	    private void DataGrid1_DeleteCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
	    {
		    Admins admin=new Admins();
		    try
		    {
			admin.DelNews(DataGrid1.DataKeys[e.Item.ItemIndex].ToString());
			Response.Redirect("admin_Viewnews.aspx");
		    }
		    catch(Exception err)
		    {
			Response.Write(err.ToString());
		    }
		
	    }

	    private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
	    {
	    
	    }

	    private void DataGrid1_ItemDataBound_1(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
	    {
		    e.Item.Cells[2].Attributes.Add("onClick","return confirm('你确定要删除这一项吗？');"); 
	    }
	}
}