private void button1_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); //添加学生-课程关系 #region var query = (from students in db.student where students.Student_classid == classbox.Text select students.Student_id).ToList(); int right = 0; int wrong = 0; int num = 0; foreach (var a in query) { sutdent_course temp = new sutdent_course(); temp.id = a + coursebox.Text; temp.Course_id = coursebox.Text; temp.Student_id = a; db.sutdent_course.InsertOnSubmit(temp); try { db.SubmitChanges(); right++; } catch { wrong++; } } num = query.Count; String text = this.classbox.Text + "班共" + Convert.ToString(num) + "人,提交成功:" + Convert.ToString(right) + "条 ,提交失败:" + Convert.ToString(wrong) + "条"; MessageBox.Show(text); #endregion }
private void ackbtn_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); exam examinfo = new exam(); examinfo.id = idbox.Text; examinfo.course_id = idbox.Text; examinfo.exam_address = addressbox.Text; examinfo.exam_time = datetime.Value.Date; db.exam.InsertOnSubmit(examinfo); try { db.SubmitChanges(); MessageBox.Show("提交成功"); } catch { MessageBox.Show("提交失败"); } }
private void button1_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); //添加教师-课程关系 #region teacher_course teachercourse = new teacher_course(); teachercourse.Teacher_id = teacherbox.Text; teachercourse.Course_id = coursebox.Text; teachercourse.Class_id = classbox.Text; teachercourse.id = teacherbox.Text + classbox.Text + coursebox.Text; db.teacher_course.InsertOnSubmit(teachercourse); try { db.SubmitChanges(); MessageBox.Show("提交成功"); } catch { MessageBox.Show("提交失败"); } #endregion }
private void button1_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); score temp = new score(); temp.Course_id = idbox.Text; temp.Student_id = numbox.Text; temp.Course_score =Convert.ToInt32(scorebox.Text); temp.id = numbox.Text + idbox.Text; db.score.InsertOnSubmit(temp); try { db.SubmitChanges(); MessageBox.Show("提交成功!"); numbox.Text = ""; scorebox.Text = ""; } catch { MessageBox.Show("提交失败"); } }
private void ackbtn_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); var query = from teachername in db.teacher where teachername.Teacher_name == techernamebox.Text select teachername.Teacher_id; try { query.First(); } catch { MessageBox.Show("没有该老师!"); return; } @class a = new @class(); a.Class_id = gradebox.Text + classbox.Text; a.Class_name = classnamebox.Text; a.Class_college = classcollege.Text; a.Class_teacherid = query.First(); [email protected](a); try { db.SubmitChanges(); MessageBox.Show("添加成功!"); } catch { MessageBox.Show("添加失败!"); } }
private void ackbtn_Click(object sender, EventArgs e) { stuobj = new DataClasses1DataContext(); student insertinfo = new student(); insertinfo.Student_id = idbox.Text; insertinfo.Student_name = namebox.Text; if (maleradio.Checked) insertinfo.Student_sex = "男"; else insertinfo.Student_sex = "女"; insertinfo.Student_nation = nationbox.Text; insertinfo.Entry_date = this.entrytime.Value.Date; insertinfo.Student_birthday = birthday.Value.Date; insertinfo.Student_classid =gradebox.Text+classbox.Text; insertinfo.Student_home = addbox.Text; if (dongguan.Checked) insertinfo.School_location = "东莞"; else insertinfo.School_location = "湛江"; insertinfo.Student_college = collegebox.Text; insertinfo.Student_specialty = spebox.Text; insertinfo.School_system =Convert.ToInt32(systembox.Text); insertinfo.Student_grade = Convert.ToInt32(gradebox.Text); stuobj.student.InsertOnSubmit(insertinfo); try { if (MessageBox.Show("确定提交?", "提示", MessageBoxButtons.OKCancel) == DialogResult.OK) { stuobj.SubmitChanges(); MessageBox.Show("添加成功!"); } } catch(Exception ex) { MessageBox.Show("添加失败!"); } }
private void button1_Click(object sender, EventArgs e) { DataClasses1DataContext db = new DataClasses1DataContext(); course xin = new course(); xin.Course_id = courseID.Text; xin.Course_name = namebox.Text; xin.Course_period = Convert.ToInt32(periodbox.Text); xin.Course_credit = Convert.ToInt32(this.creditbox.Text); xin.Course_descible = describebox.Text; if (radioButton1.Checked) xin.Course_kind = radioButton1.Text; if (radioButton2.Checked) xin.Course_kind = radioButton2.Text; if (radioButton3.Checked) xin.Course_kind = radioButton3.Text; db.course.InsertOnSubmit(xin); try { db.SubmitChanges(); MessageBox.Show("添加成功!"); } catch { MessageBox.Show("添加失败!"); } }
private void upload_Click(object sender, EventArgs e) { try { DataClasses1DataContext update = new DataClasses1DataContext(); var query = (from c in update.student where c.Student_id == idbox.Text select c).First(); //更新信息 #region query.Student_id = idbox.Text; query.Student_name = namebox.Text; query.Student_nation = nationbox.Text; query.Student_birthday = birthday.Value.Date; query.Entry_date = entrytime.Value.Date; if (femaleradio.Checked) query.Student_sex = "女"; else query.Student_sex = "男"; if (dongguan.Checked) query.School_location = "东莞"; else query.School_location = "湛江"; query.Student_home = addbox.Text; query.Student_college = collegebox.Text; query.Student_specialty = spebox.Text; query.Student_grade = Convert.ToInt32(gradebox.Text); query.Student_classid = classbox.Text; query.School_system = Convert.ToInt32(systembox.Text); #endregion update.SubmitChanges(); MessageBox.Show("修改成功"); //让文本框不可以修改 #region this.systembox.Enabled = false; this.namebox.Enabled = false; this.addbox.Enabled = false; this.birthday.Enabled = false; this.entrytime.Enabled = false; this.groupBox2.Enabled = false; this.groupBox3.Enabled = false; this.nationbox.Enabled = false; this.collegebox.Enabled = false; this.spebox.Enabled = false; this.gradebox.Enabled = false; this.classbox.Enabled = false; #endregion } catch { MessageBox.Show("修改失败"); } }