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>
	/// index 的摘要說(shuō)明。
	/// </summary>
	public class index : System.Web.UI.Page
	{
		protected System.Web.UI.WebControls.Label lblgrade;
		protected System.Web.UI.WebControls.Label lblclass;
		protected System.Web.UI.WebControls.Label lblstu;
		protected System.Web.UI.WebControls.Label lblteach;
		protected System.Web.UI.WebControls.Label lblnow;
		protected System.Web.UI.WebControls.Label lblterm;

		private string datafile_stumain="stumain.xml";
		private string datafile_stusrc="stusrc.xml";
		private string datafile_stusum="stusum.xml";
		private string datafile_class="class.xml";
		private string datafile_teach="teacher.xml";

		private void create_data()
		{
			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["Tbstumain"].Rows.Count;
				int gcount=0;
				int cgrade=0;
				for (int i=0;i<count;i++)
				{
					if (Convert.ToDateTime(ds.Tables["Tbstumain"].Rows[i]["schooldate"]).Year!=cgrade)
					{
						cgrade=Convert.ToDateTime(ds.Tables["Tbstumain"].Rows[i]["schooldate"]).Year;
						gcount++;
					}
				}
				int ccount=ds.Tables["Tbstumain"].Rows.Count;
				int stucount=ds.Tables["stu"].Rows.Count;
				this.lblgrade.Text=Convert.ToString(gcount);
				this.lblclass.Text=Convert.ToString(ccount);
				this.lblstu.Text=Convert.ToString(stucount);
				this.lblnow.Text=DateTime.Now.ToString("d");
			}
			catch (Exception ex)
			{
				this.Response.Write(ex.ToString());
			}
		}

		private void create_teach()
		{
			FileStream xmlfile;
			xmlfile=new FileStream(Server.MapPath(datafile_teach),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
			DataSet ds=new DataSet();
			ds.ReadXml(xmlfile,XmlReadMode.ReadSchema);
			xmlfile.Close();
			int count=ds.Tables["Tbteacher"].Rows.Count;
			this.lblteach.Text=Convert.ToString(count);
		}

		private void getterm()
		{
			DateTime date=DateTime.Now;
			if (date.Month>=9)
			{
				this.lblterm.Text="現(xiàn)在是"+Convert.ToString(date.Year)+"-"+Convert.ToString(date.Year+1)+"學(xué)年"+"第一學(xué)期";
			}
			else
			{
				if (date.Month<=2)
				{
					this.lblterm.Text="現(xiàn)在是"+Convert.ToString(date.Year-1)+"-"+Convert.ToString(date.Year)+"學(xué)年"+"第一學(xué)期";
				}
				else
				{
					this.lblterm.Text="現(xiàn)在是"+Convert.ToString(date.Year-1)+"-"+Convert.ToString(date.Year)+"學(xué)年"+"第二學(xué)期";
				}
			}
		}
					
		private void Page_Load(object sender, System.EventArgs e)
		{
			this.create_data();
			this.getterm();
			this.create_teach();
		}

		#region Web 窗體設(shè)計(jì)器生成的代碼
		override protected void OnInit(EventArgs e)
		{
			//
			// CODEGEN: 該調(diào)用是 ASP.NET Web 窗體設(shè)計(jì)器所必需的。
			//
			InitializeComponent();
			base.OnInit(e);
		}
		
		/// <summary>
		/// 設(shè)計(jì)器支持所需的方法 - 不要使用代碼編輯器修改
		/// 此方法的內(nèi)容。
		/// </summary>
		private void InitializeComponent()
		{    
			this.Load += new System.EventHandler(this.Page_Load);

		}
		#endregion
	}
}