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