viewstu.aspx.cs

XStuMan学生管理系统是面向中小学信息化管理的一套学生管理系统

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.IO;
using System.Xml;

namespace stuman
{
	/// <summary>
	/// viewstu 的摘要说明。
	/// </summary>
	public class viewstu : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblstuid;
		protected System.Web.UI.WebControls.Label lblname;
		protected System.Web.UI.WebControls.Label lblschooldate;
		protected System.Web.UI.WebControls.Label lblclass;
		protected System.Web.UI.WebControls.Label lblsex;
		protected System.Web.UI.WebControls.Label lblbirthday;
		protected System.Web.UI.WebControls.Label lbladdress;
		protected System.Web.UI.WebControls.DataGrid DataGrid2;
		protected System.Web.UI.WebControls.DataGrid DataGrid3;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;

		private string datafile_stumain="stumain.xml";
		private string datafile_stusrc="stusrc.xml";
		private string datafile_stusum="stusum.xml";
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (this.Request.QueryString.Count>=1)
			{
				int stuid=Convert.ToInt32(this.Request.QueryString["stuid"]);
				this.create_data(stuid);
				this.create_sum(stuid);
				this.create_event(stuid);
			}
			else
			{
				this.Response.Redirect("searchstu.aspx"+"?geturl="+"viewstu");
			}
		}

		private void create_data(int stuid)
		{
			try
			{
				FileStream xmlfile;
				xmlfile=new FileStream(Server.MapPath(datafile_stusrc),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
				DataSet ds=new DataSet();
				ds.ReadXml(xmlfile,XmlReadMode.ReadSchema);
				xmlfile.Close();
				DataTable dt=new DataTable();
				dt.Columns.Add("subject",typeof(string));
				dt.Columns.Add("sort",typeof(string));
				dt.Columns.Add("date",typeof(DateTime));
				dt.Columns.Add("src",typeof(double));
				int count=ds.Tables["srcmain"].Rows.Count;				
				for (int i=0;i<count;i++)
				{
					if (Convert.ToInt32(ds.Tables["srcmain"].Rows[i]["stuid"])==stuid)
					{
						DataRelation rel=ds.Tables["srcmain"].ChildRelations[0];
						DataRow[] rows=ds.Tables["srcmain"].Rows[i].GetChildRows(rel);
						int c=rows.GetLength(0);
						for (int j=0;j<c;j++)
						{
							DataRow newrow=dt.NewRow();
							newrow["subject"]=this.getsubject(Convert.ToString(rows[j]["subject"]));
							newrow["sort"]=this.getsort(Convert.ToString(rows[j]["sort"]));
							newrow["date"]=Convert.ToDateTime(rows[j]["date"]);
							newrow["src"]=Convert.ToDouble(rows[j]["src"]);
							dt.Rows.Add(newrow);
						}
						break;
					}
				}
				DataView dv=dt.DefaultView;
				dv.Sort="date";
				this.DataGrid1.DataSource=dv;
				this.DataGrid1.DataBind();				
			}
			catch (Exception ex)
			{
				this.Response.Write(ex.ToString());
			}
		}

		private void create_sum(int stuid)
		{
			try
			{
				FileStream xmlfile;
				xmlfile=new FileStream(Server.MapPath(datafile_stumain),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
				DataSet ds=new DataSet();
				ds.ReadXml(xmlfile,XmlReadMode.ReadSchema);
				xmlfile.Close();
				int count=ds.Tables["stu"].Rows.Count;				
				for (int i=0;i<count;i++)
				{
					if (Convert.ToInt32(ds.Tables["stu"].Rows[i]["stuid"])==stuid)
					{
						this.lblname.Text=Convert.ToString(ds.Tables["stu"].Rows[i]["name"]);
						this.lblsex.Text=this.getsex(Convert.ToInt32((ds.Tables["stu"].Rows[i]["sex"])));
						break;
					}
				}
				FileStream xmlfile1;
				xmlfile1=new FileStream(Server.MapPath(datafile_stusum),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
				DataSet dssum=new DataSet();
				dssum.ReadXml(xmlfile1,XmlReadMode.ReadSchema);
				xmlfile1.Close();
				count=dssum.Tables["summain"].Rows.Count;
				for (int i=0;i<count;i++)
				{
					if (Convert.ToInt32(dssum.Tables["summain"].Rows[i]["stuid"])==stuid)
					{
						DataRelation rel=dssum.Tables["summain"].ParentRelations[0];
						this.lblschooldate.Text=Convert.ToString(Convert.ToDateTime(dssum.Tables["summain"].Rows[i].GetParentRow(rel)["schooldate"]).Year);
						this.lblclass.Text=Convert.ToString(dssum.Tables["summain"].Rows[i].GetParentRow(rel)["class"]);
						this.lblbirthday.Text=Convert.ToDateTime(dssum.Tables["summain"].Rows[i]["birthday"]).ToString("d");
						this.lbladdress.Text=Convert.ToString(dssum.Tables["summain"].Rows[i]["address"]);
						break;
					}
				}
			}
			catch (Exception ex)
			{
				this.Response.Write(ex.ToString());
			}
		}

		private string getsex(int n)
		{
			if (n==0)
			{
				return "男";
			}
			else
			{
				return "女";
			}
		}

		private string getsubject(string s)
		{
			switch (s)
			{
				case "ch":return "语文";
					break;
				case "me":return "数学";
					break;
				case "en":return "英语";
					break;
				case "so":return "政治";
					break;
				case "ph":return "物理";
					break;
				case "cm":return "化学";
					break;
				case "ba":return "生物";
					break;
				case "er":return "地理";
					break;
				case "hs":return "历史";
					break;
				case "cp":return "计算机";
					break;
				case "pe":return "体育";
					break;
				default:return "语文";
					break;
			}
		}

		private string getsort(string s)
		{
			switch (s)
			{
				case "mid":return "期中";
					break;
				case "fnl":return "期末";
					break;
				case "nom":return "普通";
					break;
				case "met":return "会考";
					break;
				default:return "期中";
					break;
			}
		}
		
		private void create_event(int stuid)
		{
			try
			{
				FileStream xmlfile;
				xmlfile=new FileStream(Server.MapPath(datafile_stusum),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
				DataSet ds=new DataSet();
				ds.ReadXml(xmlfile,XmlReadMode.ReadSchema);
				xmlfile.Close();
				int count=ds.Tables["summain"].Rows.Count;
				DataTable dtprace=new DataTable();
				dtprace.Columns.Add("date",typeof(DateTime));
				dtprace.Columns.Add("event",typeof(string));
				DataTable dtmistake=new DataTable();
				dtmistake.Columns.Add("date",typeof(DateTime));
				dtmistake.Columns.Add("event",typeof(string));
				for (int i=0;i<count;i++)
				{
					if (Convert.ToInt32(ds.Tables["summain"].Rows[i]["stuid"])==stuid)
					{
						DataRelation rel1=ds.Tables["summain"].ChildRelations[0];
						DataRelation rel2=ds.Tables["summain"].ChildRelations[1];
						DataRow[] rows1=ds.Tables["summain"].Rows[i].GetChildRows(rel1);
						DataRow[] rows2=ds.Tables["summain"].Rows[i].GetChildRows(rel2);
						int c=rows1.GetLength(0);
						for (int j=0;j<c;j++)
						{
							DataRow newrow=dtprace.NewRow();
							newrow["date"]=Convert.ToDateTime(rows1[j]["date"]);
							newrow["event"]=Convert.ToString(rows1[j]["event"]);
							dtprace.Rows.Add(newrow);
						}
						c=rows2.GetLength(0);
						for (int j=0;j<c;j++)
						{
							DataRow newrow=dtmistake.NewRow();
							newrow["date"]=Convert.ToDateTime(rows2[j]["date"]);
							newrow["event"]=Convert.ToString(rows2[j]["event"]);
							dtmistake.Rows.Add(newrow);
						}
						break;
					}
				}
				this.DataGrid2.DataSource=dtprace.DefaultView;
				this.DataGrid2.DataBind();
				this.DataGrid3.DataSource=dtmistake.DefaultView;
				this.DataGrid3.DataBind();
			}
			catch (Exception ex)
			{
				this.Response.Write(ex.ToString());
			}
		}

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

		}
		#endregion
	}
}