editstusrc.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>
	/// editstusrc 的摘要说明。
	/// </summary>
	public class editstusrc : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.DropDownList Edschooldate;
		protected System.Web.UI.WebControls.TextBox Edclass;
		protected System.Web.UI.WebControls.DropDownList Edsubject;
		protected System.Web.UI.WebControls.DropDownList Edsort;
		protected System.Web.UI.WebControls.Button btnok;
		protected System.Web.UI.HtmlControls.HtmlGenericControl main;
		protected System.Web.UI.HtmlControls.HtmlForm Form1;
		protected System.Web.UI.HtmlControls.HtmlGenericControl edit;
		protected System.Web.UI.HtmlControls.HtmlForm Form2;
		protected System.Web.UI.WebControls.Label lblclass;
		protected System.Web.UI.WebControls.Button btnupdata;
		protected System.Web.UI.WebControls.Label Label1;
		protected System.Web.UI.WebControls.Calendar EdDate;
		protected System.Web.UI.WebControls.DataGrid DataGrid1;
	
		private void Page_Load(object sender, System.EventArgs e)
		{
			if (!this.IsPostBack)
			{
				this.main.Visible=true;
				this.edit.Visible=false;				
			}
		}

		#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.btnupdata.Click += new System.EventHandler(this.btnupdata_Click);
			this.DataGrid1.EditCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_EditCommand);
			this.DataGrid1.UpdateCommand += new System.Web.UI.WebControls.DataGridCommandEventHandler(this.DataGrid1_UpdateCommand);
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion

		private string datafile_stumain="stumain.xml";
		private string datafile_stusrc="stusrc.xml";
		private string datafile_class="class.xml";

		private DataTable dtedit;

		private void create_data()
		{
			try
			{
				FileStream xmlfile;
				xmlfile=new FileStream(Server.MapPath(datafile_stumain),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
				DataSet dsmain=new DataSet();
				dsmain.ReadXml(xmlfile,XmlReadMode.ReadSchema);
				xmlfile.Close();
				DateTime schooldate=new DateTime(Convert.ToInt32(this.Edschooldate.SelectedValue),9,1);
				int classnum=Convert.ToInt32(this.Edclass.Text);
				DataTable dt=new DataTable();
				dt.Columns.Add("stuid",typeof(int));
				dt.Columns.Add("name",typeof(string));
				dt.Columns.Add("src",typeof(double));
				int count=dsmain.Tables["Tbstumain"].Rows.Count;
				for (int i=0;i<count;i++)
				{
					if (Convert.ToDateTime(dsmain.Tables["Tbstumain"].Rows[i]["schooldate"]).Year==schooldate.Year)
					{
						if (Convert.ToInt32(dsmain.Tables["Tbstumain"].Rows[i]["class"])==classnum)
						{
							DataRelation rel=dsmain.Tables["Tbstumain"].ChildRelations[0];
							DataRow[] rows=dsmain.Tables["Tbstumain"].Rows[i].GetChildRows(rel);
                            int c=rows.GetLength(0);
							for (int j=0;j<c;j++)
							{
								DataRow r=dt.NewRow();
								r["stuid"]=Convert.ToInt32(rows[j]["stuid"]);
								r["name"]=Convert.ToString(rows[j]["name"]);
								dt.Rows.Add(r);
							}
							break;
						}
					}
				}
				Session["srcdata"]=(object)dt;
				this.DataGrid1.DataSource=dt.DefaultView;
				this.DataGrid1.DataBind();
			}
			catch (Exception ex)
			{
				this.Response.Write(ex.ToString());
			}
		}

		private void btnok_Click(object sender, System.EventArgs e)
		{
			this.main.Visible=false;
			this.edit.Visible=true;
			Session["subject"]=this.Edsubject.SelectedValue;
			Session["sort"]=this.Edsort.SelectedValue;
			Session["date"]=this.EdDate.SelectedDate;
			this.create_data();
			this.lblclass.Text=this.Edschooldate.SelectedValue+"级"+this.Edclass.Text+"班"+this.Edsubject.SelectedItem.Text
				+this.Edsort.SelectedItem.Text+"考试成绩"+"   "+"日期："+this.EdDate.SelectedDate.ToString("d");
		}

		private void DataGrid1_EditCommand(object source, 
			System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			this.DataGrid1.EditItemIndex = e.Item.ItemIndex;
			DataTable dt=(DataTable)Session["srcdata"];
			this.DataGrid1.DataSource=dt.DefaultView;
			this.DataGrid1.DataBind();
		}

		private void DataGrid1_UpdateCommand(object source, 
			System.Web.UI.WebControls.DataGridCommandEventArgs e)
		{
			TableCell quantityCell = e.Item.Cells[0];
			int stuid=Convert.ToInt32(quantityCell.Text);
			DataTable dt=(DataTable)Session["srcdata"];
			int count=dt.Rows.Count;
			for (int i=0;i<count;i++)
			{
				if (Convert.ToInt32(dt.Rows[i]["stuid"])==stuid)
				{
					TableCell tc=e.Item.Cells[2];
					TextBox bxsrc=(TextBox)tc.Controls[0];
					dt.Rows[i]["src"]=Convert.ToDouble(bxsrc.Text);
					break;
				}
			}
			//FileStream xmlfilein;
			//xmlfilein=new FileStream(Server.MapPath(datafile_stusrc),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
			//DataSet ds=new DataSet();
			//ds.ReadXml(xmlfilein,XmlReadMode.ReadSchema);
			//xmlfilein.Close();
			//int count=ds.Tables["srcmain"].Rows.Count;
			//for (int i=0;i<count;i++)
			//{
			//	if (Convert.ToInt32(ds.Tables["srcmain"].Rows[i]["stuid"])==stuid)
			//	{
			//		DataRow newrow=ds.Tables["src"].NewRow();
			//		TableCell tc=e.Item.Cells[2];
			//		TextBox bxsrc=(TextBox)tc.Controls[0];
			//		newrow["src"]=Convert.ToDouble(bxsrc.Text);
			//		ds.Tables["src"].Rows.Add(newrow);
			//		newrow.SetParentRow(ds.Tables["srcmain"].Rows[i]);
			//		break;
			//	}
			//}
			//FileStream xmlfileout;
			//xmlfileout=new FileStream(Server.MapPath(datafile_stusrc),FileMode.Open,FileAccess.Write,FileShare.ReadWrite);
			//ds.WriteXml(xmlfileout,XmlWriteMode.WriteSchema);
			//xmlfileout.Close();
			DataGrid1.EditItemIndex = -1;
			Session["srcdata"]=(object)dt;
			dt=(DataTable)Session["srcdata"];
			this.DataGrid1.DataSource=dt.DefaultView;
			this.DataGrid1.DataBind();
		}

		private void btnupdata_Click(object sender, System.EventArgs e)
		{
			try
			{
				FileStream xmlfilein;
				xmlfilein=new FileStream(Server.MapPath(datafile_stusrc),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
				DataSet ds=new DataSet();
				ds.ReadXml(xmlfilein);
				xmlfilein.Close();
				DataTable dt=(DataTable)Session["srcdata"];
				int count=dt.Rows.Count;
				int c=ds.Tables["srcmain"].Rows.Count;
				for (int i=0;i<count;i++)
				{
					for (int j=0;j<c;j++)
					{
						if (Convert.ToInt32(dt.Rows[i]["stuid"])==Convert.ToInt32(ds.Tables["srcmain"].Rows[j]["stuid"]))
						{
							DataRow r=ds.Tables["src"].NewRow();
							r["subject"]=(string)Session["subject"];
							r["sort"]=(string)Session["sort"];
							r["date"]=(DateTime)Session["date"];
							r["src"]=Convert.ToDouble(dt.Rows[i]["src"]);
							ds.Tables["src"].Rows.Add(r);
							r.SetParentRow(ds.Tables["srcmain"].Rows[j]);
							break;
						}
					}
				}
				FileStream xmlfileout;
				xmlfileout=new FileStream(Server.MapPath(datafile_stusrc),FileMode.Open,FileAccess.Write,FileShare.ReadWrite);
				ds.WriteXml(xmlfileout,XmlWriteMode.WriteSchema);
				xmlfileout.Close();
			}
			catch (Exception ex)
			{
				this.Response.Write(ex.ToString());
			}
		}


	}
}