searchstu_name.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>
	/// searchstu_name 的摘要说明。
	/// </summary>
	public class searchstu_name : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Button btnok;
		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 DataGrid1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl edit;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl view;
		protected System.Web.UI.HtmlControls.HtmlGenericControl sel;
		protected System.Web.UI.WebControls.ListBox ListBox1;
		protected System.Web.UI.WebControls.Button btnselok;
		protected System.Web.UI.HtmlControls.HtmlForm Form2;
		protected System.Web.UI.WebControls.TextBox Edname;
		protected System.Web.UI.HtmlControls.HtmlForm Form3;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (!this.IsPostBack)
			{
				this.edit.Visible=true;
				this.sel.Visible=false;
				this.view.Visible=false;
			}
		}

		private string datafile_stumain="stumain.xml";
		private string datafile_stusrc="stusrc.xml";
		private string datafile_stusum="stusum.xml";

		private void create_list()
		{
			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;
				string name=this.Edname.Text;
				for (int i=0;i<count;i++)
				{
					if (Convert.ToString(ds.Tables["stu"].Rows[i]["name"])==name)
					{
						DataRelation rel=ds.Tables["stu"].ParentRelations[0];
						string s=Convert.ToString(Convert.ToDateTime(ds.Tables["stu"].Rows[i].GetParentRow(rel)["schooldate"]).Year)
							+"级"+Convert.ToString(ds.Tables["stu"].Rows[i].GetParentRow(rel)["class"])+"班"+"   "+name;
						ListItem newitem=new ListItem(s,Convert.ToString(ds.Tables["stu"].Rows[i]["stuid"]));
						this.ListBox1.Items.Add(newitem);
					}
				}
			}
			catch (Exception ex)
			{
				this.Response.Write(ex.ToString());
			}
		}

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

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

		}
		#endregion

		private void btnok_Click(object sender, System.EventArgs e)
		{
			this.edit.Visible=false;
			this.sel.Visible=true;
			this.view.Visible=false;
			this.create_list();
		}

		private void btnselok_Click(object sender, System.EventArgs e)
		{
			int stuid=Convert.ToInt32(this.ListBox1.SelectedValue);
			this.edit.Visible=false;
			this.sel.Visible=false;
			this.view.Visible=true;
			this.create_data(stuid);
			this.create_sum(stuid);
			this.lblstuid.Text=Convert.ToString(stuid);
		}
	}
}