interviewpersonmanage.aspx.cs

网络学生家教招聘系统.使用ASP.NET环境+C#开发。功能完备。代码扩展方便。

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

namespace PeopleInfo
{
	/// <summary>
	/// InterviewPersonManage 的摘要说明。
	/// </summary>
	public class InterviewPersonManage : DataPage.DataPage
	{
		protected SqlConnection sqlconn;
		protected SqlDataAdapter sqladapter;
		protected DataSet ds;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			
			if(Session["User"]==null)
			{
				Response.Redirect("Result.aspx?Succeed=false&Message=未登录&URL=Enter.aspx");
			}

			string CmdText;

			CmdText=this.BuildCmdText("SELECT ID,Name,sex,Class,PhoneNumber FROM RegisterPerson WHERE JoinInterview='T' AND IfEnter='F'");
			sqlconn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnString"]);
			sqladapter=new SqlDataAdapter(CmdText,sqlconn);
			ds=new DataSet();
			sqladapter.Fill(ds,"RegisterPerson");
			DataGrid1.DataSource=ds.Tables["RegisterPerson"].DefaultView;
			DataPage.DataPage.DataPageDeclare(this.Session,"InterviewPersonManage.aspx");

			if(!IsPostBack)
			{
				DataGrid1.DataBind();
				PageIndex.Text=(DataGrid1.CurrentPageIndex+1).ToString();
				PageCount.Text=(DataGrid1.PageCount).ToString();
				ChangeState();
				int i;
				for(i=1;i<=DataGrid1.PageCount;i++)
				{
					ChangeIndex.Items.Add(i.ToString());
				}
			}
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.DataGrid1.DeleteCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_DeleteCommand);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.Item_Bound);
			this.First.Click += new System.EventHandler(this.First_Click);
			this.Pre.Click += new System.EventHandler(this.Pre_Click);
			this.Next.Click += new System.EventHandler(this.Next_Click);
			this.Last.Click += new System.EventHandler(this.Last_Click);
			this.ChangeIndex.SelectedIndexChanged += new System.EventHandler(this.ChangeIndex_SelectedIndexChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private void ChangeIndex_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			DataGrid1.CurrentPageIndex=((DropDownList)sender).SelectedIndex;
			PageIndex.Text=(DataGrid1.CurrentPageIndex+1).ToString();
			ChangeState();
		}

		private void Next_Click(object sender, System.EventArgs e)
		{
			if(DataGrid1.CurrentPageIndex<DataGrid1.PageCount-1)
			{
				DataGrid1.CurrentPageIndex++;
				ChangeState();
			}
		}

		private void First_Click(object sender, System.EventArgs e)
		{
			if(DataGrid1.CurrentPageIndex>0)
			{
				DataGrid1.CurrentPageIndex=0;
				ChangeState();
			}
		
		}

		private void Last_Click(object sender, System.EventArgs e)
		{
			if(DataGrid1.CurrentPageIndex<DataGrid1.PageCount-1)
			{
				DataGrid1.CurrentPageIndex=DataGrid1.PageCount-1;
				ChangeState();
			}
		
		}

		private void Pre_Click(object sender, System.EventArgs e)
		{
			if(DataGrid1.CurrentPageIndex>0)
			{
				DataGrid1.CurrentPageIndex--;
				ChangeState();
			}
		}

		private void ChangeState()
		{
			PageIndex.Text=(DataGrid1.CurrentPageIndex+1).ToString();
			ChangeIndex.SelectedIndex=DataGrid1.CurrentPageIndex;
			First.Enabled=true;
			Pre.Enabled=true;
			Last.Enabled=true;
			Next.Enabled=true;
			if(DataGrid1.CurrentPageIndex==0)
			{
				First.Enabled=false;
				Pre.Enabled=false;

				if(DataGrid1.CurrentPageIndex>=DataGrid1.PageCount-1)
				{
					Last.Enabled=false;
					Next.Enabled=false;
				}
			}
			else  if(DataGrid1.CurrentPageIndex>=DataGrid1.PageCount-1)
			{
				Last.Enabled=false;
				Next.Enabled=false;
			}
			DataGrid1.DataBind();
		}

		private void Item_Bound(Object sender, DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
			{
				string zero="0";
				for(int i=0;i<3-e.Item.Cells[0].Text.Trim().Length;i++)
				{
					zero+="0";
				}
				e.Item.Cells[0].Text=zero+e.Item.Cells[0].Text;
				e.Item.Cells[2].Text=(e.Item.Cells[2].Text.Trim().Equals("M"))?"男":"女";
			}
		}

		private void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
		{
			SqlCommand cmd;
			cmd=new SqlCommand("DELETE  FROM RegisterPerson WHERE ID="+int.Parse(e.Item.Cells[0].Text),sqlconn);
			
			sqlconn.Open();
			cmd.ExecuteNonQuery();
			sqlconn.Close();

			ds.Tables["RegisterPerson"].DefaultView.Sort="ID";
			ds.Tables["RegisterPerson"].DefaultView.Delete(ds.Tables["RegisterPerson"].DefaultView.Find(int.Parse(e.Item.Cells[0].Text)));
			DataGrid1.DataBind();
		}
	}
}