stuinfoview.aspx.cs

在线考试系统...asp.net

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.Data.SqlTypes;

namespace TestOnline
{
	/// <summary>
	/// stuInfoViewaspx 的摘要说明。
	/// </summary>
	public class stuInfoView : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DataGrid DataGrid2;
		protected System.Web.UI.WebControls.ImageButton IBtn_addStu;
		protected System.Web.UI.WebControls.ImageButton ImageButton1;
		protected System.Web.UI.WebControls.ImageButton Ibtn_alterStu;
		protected System.Web.UI.WebControls.ImageButton Ibtn_delStu;
		protected System.Web.UI.WebControls.Label lbl_count;
		protected System.Web.UI.WebControls.DropDownList DropDownList1;
		protected System.Web.UI.WebControls.DropDownList DropDownList2;
		protected System.Web.UI.WebControls.ImageButton ImageButton4;
		protected System.Web.UI.WebControls.ImageButton ImageButton5;
		protected System.Web.UI.WebControls.TextBox tbx_query;
		protected System.Web.UI.WebControls.ImageButton Ibtn_query;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Label lbl_noResult;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
		
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			// 在此处放置用户代码以初始化页面
			//Label1.Text="";//此Label的作用是放置用户选择了哪些用户.隐藏看不到
			//Ibtn_delStu.Attributes.Add("OnClick","return confirm('你确定要删除这些用户吗？');");
			//int count=0;
			//count=(new projClass()).getStudentCount();
			//lbl_count.Text=count.ToString();
			if(Session["adminId"]==null)
			{
					Response.Redirect("login.aspx");
			}else
			
			if(!IsPostBack)
			 {
				BindGrid();

			 }
			 DataGrid1.PageIndexChanged+=new DataGridPageChangedEventHandler(DataGrid1_PageIndexChanged);
		
			}

		#region Web 窗体设计器生成的代码
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 该调用是 ASP.NET Web 窗体设计器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 设计器支持所需的方法 - 不要使用代码编辑器修改
		/// 此方法的内容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.IBtn_addStu.Click += new System.Web.UI.ImageClickEventHandler(this.IBtn_addStu_Click);
			this.Ibtn_alterStu.Click += new System.Web.UI.ImageClickEventHandler(this.Ibtn_alterStu_Click);
			this.Ibtn_delStu.Click += new System.Web.UI.ImageClickEventHandler(this.Ibtn_delStu_Click);
			this.ImageButton4.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton4_Click);
			this.ImageButton5.Click += new System.Web.UI.ImageClickEventHandler(this.ImageButton5_Click);
			this.DropDownList1.SelectedIndexChanged += new System.EventHandler(this.DropDownList1_SelectedIndexChanged);
			this.DropDownList2.SelectedIndexChanged += new System.EventHandler(this.DropDownList2_SelectedIndexChanged);
			this.Ibtn_query.Click += new System.Web.UI.ImageClickEventHandler(this.Ibtn_query_Click);
			this.DataGrid1.ItemCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_ItemCommand);
			this.DataGrid1.ItemDataBound += new System.Web.UI.WebControls.DataGridItemEventHandler(this.DataGrid1_ItemDataBound);
			this.DataGrid1.SelectedIndexChanged += new System.EventHandler(this.DataGrid1_SelectedIndexChanged);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		

		
		void BindGrid() 
		{   
			DataSet ds=new DataSet();
			ds=(new projClass()).getStuInfo();
			DataTable dt=ds.Tables["stuInfo"];
			DataView dv=new DataView(dt);
			//DataGrid1.DataSource=ds.Tables["stuInfo"].DefaultView;
			if(DropDownList1.SelectedItem.Value=="stuStatus") 
			dv.RowFilter="stuStatus like '%"+DropDownList2.SelectedItem.Text+"%'";
			//	dv.RowFilter="stuStatus like '没有考试'";
			else dv.RowFilter=""+DropDownList1.SelectedItem.Value.ToString()+" like '%"+tbx_query.Text.Trim()+"%'";
			DataGrid1.DataSource=dv;
			lbl_count.Text=dv.Count.ToString();
			if(dv.Count==0)
			{
				lbl_noResult.Visible=true;
				DataGrid1.Visible=false;
			}
			else
			{
				lbl_noResult.Visible=false;
				DataGrid1.Visible=true;
			}
			DataGrid1.DataBind();
			
		}

		

		private void DataGrid1_PageIndexChanged(object source, System.Web.UI.WebControls.DataGridPageChangedEventArgs e)
		{
			
			string data="";
			int count=0;
			Hashtable ht_stuId;
			//int count=0;
			if(Session["ht_stuId"]!=null)
			{
				//Hashtable
					ht_stuId=(Hashtable)Session["ht_stuId"];

			}
			else
			{
				//	Hashtable 
						ht_stuId=new Hashtable();
				    Session["ht_stuId"]=ht_stuId;
			}
			foreach (DataGridItem item in DataGrid1.Items)
			{ 
				CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
					if(cbx.Checked)
					{
						count++;
						data+="1";
						string id=item.Cells[1].Text.ToString();
						string name=item.Cells[2].Text.ToString();
						if(!ht_stuId.Contains(id))
						ht_stuId.Add(id,name);
					} else data+="0";
			}
		
			if(ViewState["pagedata"]!=null)
			{
				Hashtable ht=(Hashtable)ViewState["pagedata"];
				//Hashtable ht_stuId=(Hashtable)Session["ht_stuId"];
				if(ht.Contains(this.DataGrid1.CurrentPageIndex))                
					ht[this.DataGrid1.CurrentPageIndex]=data;
				else
					ht.Add(this.DataGrid1.CurrentPageIndex,data);
				ViewState["pagedata"]=ht;
			}
			else
			{
				Hashtable ht=new Hashtable();
				//Hashtable ht_stuId=new Hashtable();
				ht.Add(this.DataGrid1.CurrentPageIndex,data);
				ViewState["pagedata"]=ht;
			
			}
           
			DataGrid1.CurrentPageIndex=e.NewPageIndex;
			BindGrid();

		}

		private void IBtn_addStu_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
		Response.Write("<script>window.open('studentAdd.aspx','添加学生记录','height=260,width=400,top=200,left=200,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no, status=no')</script>");
		}

		private void Ibtn_alterStu_Click(object sender, System.Web.UI.ImageClickEventArgs e)
			//修改按钮的事件,通过弹出网页的方式来修改学生信息
		{
			string stuId=getFirstSelected();
			if(!(stuId=="none"))
			{
				Session["stuId"]=stuId;
				Response.Write("<script>window.open('studentUpdate.aspx','修改学生信息','height=260,width=400,top=200,left=200,toolbar=no,menubar=no,scrollbars=no, resizable=no,location=no, status=no')</script>");
			}
			else Response.Write("<script>alert(\"请选择一个学生！\");</script>");//没有选择记录
			
		}

		private void DataGrid1_ItemCommand(object source, System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			
		}

		

		private void DataGrid1_ItemDataBound(object sender, System.Web.UI.WebControls.DataGridItemEventArgs e)
		{
			
			if(e.Item.ItemType==ListItemType.Item||e.Item.ItemType==ListItemType.AlternatingItem)
			{
				if(ViewState["pagedata"]!=null)
				{
					Hashtable ht=(Hashtable)ViewState["pagedata"];
					if(ht.Contains(this.DataGrid1.CurrentPageIndex))
					{
						CheckBox cb=(CheckBox)e.Item.FindControl("cbx_select");
						cb.Checked=ht[this.DataGrid1.CurrentPageIndex].ToString()[e.Item.ItemIndex].ToString()=="1";
					}
				}
				
				
			}
		}

		

		private void ImageButton4_Click(object sender, System.Web.UI.ImageClickEventArgs e)
			//全选
		{
			foreach (DataGridItem item in DataGrid1.Items)
			{
				CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
				cbx.Checked=true;
			}
		
		}

		private void ImageButton5_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		//全不选
		{
			foreach (DataGridItem item in DataGrid1.Items)
			{
				CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
				cbx.Checked=false;
			}
		}

		private void Ibtn_delStu_Click(object sender, System.Web.UI.ImageClickEventArgs e)
		{
			string stuId=getFirstSelected();
			if(!(stuId=="none"))
			{
			Hashtable ht_stuId;
			if(Session["ht_stuId"]!=null)
			{
				//Hashtable
				ht_stuId=(Hashtable)Session["ht_stuId"];

			}
			else
			{
				//	Hashtable 
				ht_stuId=new Hashtable();
				Session["ht_stuId"]=ht_stuId;
			}
				foreach (DataGridItem item in DataGrid1.Items)
				{ 
					CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
					if(cbx.Checked)
					{
					
						string id=item.Cells[1].Text.ToString().Trim();
						string name=item.Cells[2].Text.ToString().Trim();
						if(!ht_stuId.Contains(id))
							ht_stuId.Add(id,name);
					} 
				}
				
				
			
			Response.Write("<script>window.open('studentDel.aspx','添加学生记录','height=260,width=400,top=200,left=200,toolbar=no,menubar=no,scrollbars=yes, resizable=yes,location=no, status=no')</script>");
		
			//if(Session["ht_stuId"]!=null)
			//{Hashtable ht_stuId=(Hashtable)Session["ht_stuId"];
			//	IDictionaryEnumerator myEnumerator = ht_stuId.GetEnumerator();
	      //	while(myEnumerator.MoveNext())
				//	Label2.Text+=myEnumerator.Key+"<br>";

		//	}
		}else Response.Write("<script>alert(\"请选择一个学生！\");</script>");//没有选择记录
		
	}

		private void DropDownList1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
			
			if(DropDownList1.SelectedItem.ToString()=="学生状态")
			DropDownList2.Visible=true;
			else DropDownList2.Visible=false;
		}

		private void Ibtn_query_Click(object sender, System.Web.UI.ImageClickEventArgs e)
			//"查询"按钮的事件
		{
			ViewState.Clear();
			DataGrid1.CurrentPageIndex=0;
			BindGrid();
			
			/*if(DropDownList1.SelectedItem.ToString()=="学号")
			{
				string stuId=tbx_query.Text.Trim();
				DataSet ds;
				if(stuId=="")
					ds=(new projClass()).getStuInfo();
				else
				ds=(new projClass()).getStuInfoAsId(stuId);
				DataView dv=new DataView();
				dv=ds.Tables["stuInfo"].DefaultView;
				DataGrid1.DataSource=dv;
				lbl_count.Text=dv.Count.ToString();
             	DataGrid1.DataBind();
			}*/

		}

		private void DropDownList2_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		private void DataGrid1_SelectedIndexChanged(object sender, System.EventArgs e)
		{
		
		}

		public string getFirstSelected()
		{
			bool selected=false;//判断用户是否选择了一个记录
			string selectedId="";
			foreach (DataGridItem item in DataGrid1.Items)
			{
				if(!selected)
				{
					CheckBox cbx=(CheckBox)item.FindControl("cbx_select");
					if(cbx!=null)
					{
						if(cbx.Checked)
						{
							selectedId=item.Cells[1].Text;
							selected=true;
							return selectedId;
						}
			
					}    
				}
					
			}
			if(!selected)
			{
				//Response.Write("<script>alert(\"请选择一个学生！\");</script>");//没有选择记录
			    selectedId="none";
			}
			return selectedId;
			}

		

	}
}