protected void add()
{
if (TextBox1.Text.Length < 2 || TextBox1.Text.Length > 10)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('学号为2-10之间！');</script>");
}
else if (TextBox2.Text.Length < 2 || TextBox2.Text.Length > 20)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('姓名应在1-20位之间！');</script>");
}
else
{
DataClassesDataContext db = new DataClassesDataContext();
var bb = from r in db.SGrade where r.userNum == TextBox1.Text && r.courseName == TextBox5.Text && r.term == TextBox4.Text select r;
if (bb.Count() > 0)
{
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('该学生本学期已添加本门课！');</script>");
}
else
{
SGrade aa = new SGrade();
aa.userNum = TextBox1.Text; aa._Name = TextBox2.Text;
aa._class = TextBox3.Text; aa.term = TextBox4.Text;
aa.courseName = TextBox5.Text;
aa.RegularGrade = TextBox6.Text;
aa.MidtermGrade = TextBox7.Text; aa.FinalGrade = TextBox8.Text;
aa.WhetherQualified = DropDownList1.Text;
db.SGrade.InsertOnSubmit(aa);
db.SubmitChanges();
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('添加成功！');</script>");
}
}
}
protected void add()
{
if (Label1.Text == "" || TextBox1.Text == "")
{
Response.Redirect("TLookSGrade.aspx");
}
else
{
DataClassesDataContext db = new DataClassesDataContext();
SGrade aa = new SGrade();
aa.userNum = Label1.Text; aa._Name = Label2.Text;
aa._class = Label3.Text; aa.term = TextBox1.Text;
aa.courseName = TextBox7.Text;
aa.RegularGrade = TextBox3.Text;
aa.MidtermGrade = TextBox4.Text; aa.FinalGrade = TextBox5.Text;
aa.WhetherQualified = DropDownList1.Text;
db.SGrade.InsertOnSubmit(aa);
db.SubmitChanges();
ClientScript.RegisterStartupScript(GetType(), "message", "<script>alert('录入成功！');</script>");
}
}
