fenzhu.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>
	/// Fenzhu 的摘要说明。
	/// </summary>
	public class Fenzhu : DataPage.DataPage
	{
		protected SqlConnection sqlconn;
		protected SqlDataAdapter sqladapter;
		protected System.Web.UI.WebControls.DropDownList ddlTeams;
		protected System.Web.UI.WebControls.Label lblTeamsState;
		protected System.Web.UI.WebControls.Label lblStoredMessage;
		protected System.Web.UI.WebControls.Button btnCancel;
		protected System.Web.UI.HtmlControls.HtmlGenericControl window;
		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;
			SqlCommand cmd;
			int iSouthTeamsCount;
			int iBenbuTeamsCount;
	
			iSouthTeamsCount=int.Parse(System.Configuration.ConfigurationSettings.AppSettings["SouthTeamsCount"]);
			iBenbuTeamsCount=int.Parse(System.Configuration.ConfigurationSettings.AppSettings["BenbuTeamsCount"]);
			CmdText=this.BuildCmdText("SELECT ID,NewID,Name,sex,Class,PhoneNumber FROM EnterPerson WHERE Team='FF'");
			
			DataPage.DataPage.DataPageDeclare(this.Session,"Fenzhu.aspx");
			sqlconn=new SqlConnection(System.Configuration.ConfigurationSettings.AppSettings["ConnString"]);
			sqladapter=new SqlDataAdapter(CmdText,sqlconn);
			ds=new DataSet();
			sqladapter.Fill(ds,"EnterPerson");
			DataGrid1.DataSource=ds.Tables["EnterPerson"].DefaultView;
			cmd=new SqlCommand("",sqlconn);

			if(!IsPostBack)
			{
				DataGrid1.DataBind();
				PageIndex.Text=(DataGrid1.CurrentPageIndex+1).ToString();
				PageCount.Text=(DataGrid1.PageCount).ToString();
				ChangeState();
				int j;
				for(j=1;j<=DataGrid1.PageCount;j++)
				{
					ChangeIndex.Items.Add(j.ToString());
				}
				lblTeamsState.Text="当前分组情况：<br>";
				lblTeamsState.Text+="&nbsp;&nbsp;&nbsp;&nbsp;本部<br><table cellspacing=\"0\" cellpadding=\"0\">";
				sqlconn.Open();
				for(int i=1;i<=iBenbuTeamsCount;i++)
				{
					cmd.CommandText="SELECT COUNT(*) FROM EnterPerson WHERE Team='A"+i.ToString()+"'";

					lblTeamsState.Text+="<tr><td width=50>A"+i.ToString()+"</td><td>"+cmd.ExecuteScalar().ToString()+"</td></tr>";
					ddlTeams.Items.Add(new ListItem("A"+i.ToString()));
				}

				lblTeamsState.Text+="</table>&nbsp;&nbsp;&nbsp;&nbsp;南校区<br><table cellspacing=\"0\" cellpadding=\"0\">";
				for(int i=1;i<=iSouthTeamsCount;i++)
				{
					cmd.CommandText="SELECT COUNT(*) FROM EnterPerson WHERE Team='B"+i.ToString()+"'";

					lblTeamsState.Text+="<tr><td width=50>B"+i.ToString()+"</td><td>"+cmd.ExecuteScalar().ToString()+"</td></tr>";
					ddlTeams.Items.Add(new ListItem("B"+i.ToString()));
				}
				lblTeamsState.Text+="</table>";
			
				sqlconn.Close();
				
			}
			
			

			
		}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.ddlTeams.SelectedIndexChanged += new System.EventHandler(this.ddlTeams_SelectedIndexChanged);
			this.btnCancel.Click += new System.EventHandler(this.btnCancel_Click);
			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 Item_Bound(Object sender, DataGridItemEventArgs e)
		{
			if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
			{
				e.Item.Cells[2].Text=(e.Item.Cells[2].Text.Trim().Equals("M"))?"男":"女";
				e.Item .Cells[5].Text="<a href=ShowDetailInformation.aspx?ID="+e.Item.Cells[5].Text.Trim()+"&Type=2>详细信息</a>";
			}
		}

		private void DataGrid1_DeleteCommand(object source, DataGridCommandEventArgs e)
		{
			lblStoredMessage.Text=e.Item.Cells[0].Text.Trim();
			window.Style["VISIBILITY"]="visible";
			
		}

		private void ddlTeams_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			SqlCommand cmd;
			string  strIndex;
			string strTeam;

			if(!(strTeam=(((DropDownList)sender).SelectedValue.Trim())).Equals("F"))
			{
				cmd=new SqlCommand("SELECT COUNT(*) FROM EnterPerson WHERE Team='"+strTeam+"'",sqlconn);
				sqlconn.Open();
				strIndex=cmd.ExecuteScalar().ToString();
				if(strIndex.Length==1)
				{
					strIndex="0"+strIndex;
				}
				else if(strIndex.Length>2)
				{
					Response.Redirect("Result.aspx?Message=一组中最多只能100人&URL=Fenzhu.aspx");
				}

				cmd.CommandText="UPDATE EnterPerson SET Team='"+strTeam+"',NewID='"+strTeam+strIndex+"' WHERE ID="+lblStoredMessage.Text;
				cmd.ExecuteNonQuery();
				ds.Tables["EnterPerson"].DefaultView.Sort="ID";
				ds.Tables["EnterPerson"].DefaultView.Delete(ds.Tables["EnterPerson"].DefaultView.Find(int.Parse(lblStoredMessage.Text)));
				DataGrid1.DataBind();

				sqlconn.Close();

				lblTeamsState_ChangeState();
				window.Style["VISIBILITY"]="hidden";
			}

		}

		private void lblTeamsState_ChangeState()
		{
			SqlCommand cmd;
			int iSouthTeamsCount;
			int iBenbuTeamsCount;
	
			cmd=new SqlCommand("",sqlconn);
			iSouthTeamsCount=int.Parse(System.Configuration.ConfigurationSettings.AppSettings["SouthTeamsCount"]);
			iBenbuTeamsCount=int.Parse(System.Configuration.ConfigurationSettings.AppSettings["BenbuTeamsCount"]);

			lblTeamsState.Text="当前分组情况：<br>";
			lblTeamsState.Text+="&nbsp;&nbsp;&nbsp;&nbsp;本部<br><table cellspacing=\"0\" cellpadding=\"0\">";
			sqlconn.Open();
			for(int i=1;i<=iBenbuTeamsCount;i++)
			{
				cmd.CommandText="SELECT COUNT(*) FROM EnterPerson WHERE Team='A"+i.ToString()+"'";
				lblTeamsState.Text+="<tr><td width=50>A"+i.ToString()+"</td><td>"+cmd.ExecuteScalar().ToString()+"</td></tr>";
			}

			lblTeamsState.Text+="</table>&nbsp;&nbsp;&nbsp;&nbsp;南校区<br><table cellspacing=\"0\" cellpadding=\"0\">";
			for(int i=1;i<=iSouthTeamsCount;i++)
			{
				cmd.CommandText="SELECT COUNT(*) FROM EnterPerson WHERE Team='B"+i.ToString()+"'";
				lblTeamsState.Text+="<tr><td width=50>B"+i.ToString()+"</td><td>"+cmd.ExecuteScalar().ToString()+"</td></tr>";
			}
			lblTeamsState.Text+="</table>";
			
			sqlconn.Close();
		}

		private void btnCancel_Click(object sender, System.EventArgs e)
		{
			window.Style["VISIBILITY"]="hidden";
		}

	}
}