📄 addstu.aspx.cs
字号:
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>
/// addstu 的摘要说明。
/// </summary>
public class addstu : System.Web.UI.Page
{
protected System.Web.UI.WebControls.TextBox Edstuid;
protected System.Web.UI.WebControls.DropDownList Edschooldate;
protected System.Web.UI.WebControls.TextBox Edclass;
protected System.Web.UI.WebControls.RadioButtonList Edsex;
protected System.Web.UI.WebControls.TextBox Edaddress;
protected System.Web.UI.WebControls.TextBox Edname;
protected System.Web.UI.WebControls.Calendar Calendar1;
protected System.Web.UI.WebControls.Button btnok;
private void Page_Load(object sender, System.EventArgs e)
{
string sdate=this.Request.QueryString["sdate"];
string sclass=this.Request.QueryString["sclass"];
if (this.Request.QueryString.Count>0)
{
this.Edschooldate.Items.FindByValue(sdate).Selected=true;
this.Edclass.Text=sclass;
}
}
#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.Load += new System.EventHandler(this.Page_Load);
}
#endregion
private string datafile_stumain="stumain.xml";
private string datafile_stusum="stusum.xml";
private string datafile_stusrc="stusrc.xml";
private void add_stu()
{
try
{
FileStream xmlfilein;
xmlfilein=new FileStream(Server.MapPath(datafile_stumain),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
DataSet dsmain=new DataSet();
dsmain.ReadXml(xmlfilein,XmlReadMode.ReadSchema);
xmlfilein.Close();
FileStream xmlfilein1;
xmlfilein1=new FileStream(Server.MapPath(datafile_stusum),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
DataSet dssum=new DataSet();
dssum.ReadXml(xmlfilein1,XmlReadMode.ReadSchema);
xmlfilein1.Close();
FileStream xmlfilein2;
xmlfilein2=new FileStream(Server.MapPath(datafile_stusrc),FileMode.Open,FileAccess.Read,FileShare.ReadWrite);
DataSet dssrc=new DataSet();
dssrc.ReadXml(xmlfilein2,XmlReadMode.ReadSchema);
xmlfilein2.Close();
int stuid=Convert.ToInt32(this.Edstuid.Text);
string name=this.Edname.Text;
DateTime schooldate=new DateTime(Convert.ToInt32(this.Edschooldate.SelectedValue),9,1);
int classnum=Convert.ToInt32(this.Edclass.Text);
int sex=this.Edsex.SelectedIndex;
DateTime birthday=this.Calendar1.SelectedDate;
string address=this.Edaddress.Text;
DataRow newrow=dsmain.Tables["stu"].NewRow();
newrow["stuid"]=stuid;
newrow["name"]=name;
newrow["schooldate"]=schooldate;
newrow["class"]=classnum;
newrow["sex"]=sex;
dsmain.Tables["stu"].Rows.Add(newrow);
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];
newrow.SetParentRow(dsmain.Tables["Tbstumain"].Rows[i],rel);
break;
}
}
}
FileStream xmlfileout;
xmlfileout=new FileStream(Server.MapPath(datafile_stumain),FileMode.Open,FileAccess.Write,FileShare.ReadWrite);
dsmain.WriteXml(xmlfileout,XmlWriteMode.WriteSchema);
xmlfileout.Close();
DataRow newrow1=dssum.Tables["summain"].NewRow();
newrow1["stuid"]=stuid;
newrow1["birthday"]=birthday;
newrow1["address"]=address;
dssum.Tables["summain"].Rows.Add(newrow1);
count=dssum.Tables["Tbstusum"].Rows.Count;
for (int i=0;i<count;i++)
{
if (Convert.ToDateTime(dssum.Tables["Tbstusum"].Rows[i]["schooldate"]).Year==schooldate.Year)
{
if (Convert.ToInt32(dssum.Tables["Tbstusum"].Rows[i]["class"])==classnum)
{
DataRelation rel=dssum.Tables["Tbstusum"].ChildRelations[0];
newrow1.SetParentRow(dssum.Tables["Tbstusum"].Rows[i],rel);
break;
}
}
}
FileStream xmlfileout1;
xmlfileout1=new FileStream(Server.MapPath(datafile_stusum),FileMode.Open,FileAccess.Write,FileShare.ReadWrite);
dssum.WriteXml(xmlfileout1,XmlWriteMode.WriteSchema);
xmlfileout1.Close();
DataRow newrow2=dssrc.Tables["srcmain"].NewRow();
newrow2["stuid"]=stuid;
newrow2["name"]=name;
dssrc.Tables["srcmain"].Rows.Add(newrow2);
count=dssrc.Tables["Tbstusrc"].Rows.Count;
for (int i=0;i<count;i++)
{
if (Convert.ToDateTime(dssrc.Tables["Tbstusrc"].Rows[i]["schooldate"]).Year==schooldate.Year)
{
if (Convert.ToInt32(dssrc.Tables["Tbstusrc"].Rows[i]["class"])==classnum)
{
DataRelation rel=dssrc.Tables["Tbstusrc"].ChildRelations[0];
newrow2.SetParentRow(dssrc.Tables["Tbstusrc"].Rows[i],rel);
break;
}
}
}
FileStream xmlfileout2;
xmlfileout2=new FileStream(Server.MapPath(datafile_stusrc),FileMode.Open,FileAccess.Write,FileShare.ReadWrite);
dssrc.WriteXml(xmlfileout2,XmlWriteMode.WriteSchema);
xmlfileout2.Close();
}
catch (Exception ex)
{
this.Response.Write(ex.ToString());
}
}
private void btnok_Click(object sender, System.EventArgs e)
{
this.add_stu();
}
}
}
⌨️ 快捷键说明
复制代码
Ctrl + C
搜索代码
Ctrl + F
全屏模式
F11
切换主题
Ctrl + Shift + D
显示快捷键
?
增大字号
Ctrl + =
减小字号
Ctrl + -