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 button1_Click(object sender, EventArgs e)
{
DataClasses1DataContext studentinfo = new DataClasses1DataContext();
if (radioButton1.Checked)
{
//判定搜索的对象是否存在
#region
try
{
var test = (from db in studentinfo.student
where db.Student_id == this.textBox1.Text
select db).First();
}
catch
{
MessageBox.Show("没有该同学信息");
return;
}
#endregion
var query = (from db in studentinfo.student
where db.Student_id == this.textBox1.Text
select db).First();
//信息初始化
#region
idbox.Text = query.Student_id;
namebox.Text = query.Student_name;
nationbox.Text = query.Student_nation;
birthday.Value = query.Student_birthday;
entrytime.Value = query.Entry_date;
if (query.Student_sex.Trim() == "男") maleradio.Checked = true;
else femaleradio.Checked = true;
if (query.School_location.Trim() == "东莞") dongguan.Checked = true;
else zhanjiang.Checked = true;
addbox.Text = query.Student_home;
collegebox.Text = query.Student_college;
spebox.Text = query.Student_specialty;
gradebox.Text = query.Student_grade.ToString();
classbox.Text = query.Student_classid;
systembox.Text = query.School_system.ToString();
#endregion
}
if (radioButton2.Checked)
{
//判定搜索的对象是否存在
#region
try
{
var test = (from db in studentinfo.student
where db.Student_name == this.textBox1.Text
select db).First();
}
catch
{
MessageBox.Show("没有该同学信息");
return;
}
#endregion
var query = (from db in studentinfo.student
where db.Student_name == this.textBox1.Text
select db).First();
//信息初始化
#region
idbox.Text = query.Student_id;
namebox.Text = query.Student_name;
nationbox.Text = query.Student_nation;
birthday.Value = query.Student_birthday;
entrytime.Value = query.Entry_date;
if (query.Student_sex.Trim() == "男") maleradio.Checked = true;
else femaleradio.Checked = true;
if (query.School_location.Trim() == "东莞") dongguan.Checked = true;
else zhanjiang.Checked = true;
addbox.Text = query.Student_home;
collegebox.Text = query.Student_college;
spebox.Text = query.Student_specialty;
gradebox.Text = query.Student_grade.ToString();
classbox.Text = query.Student_classid;
systembox.Text = query.School_system.ToString();
#endregion
}
}
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("修改失败"); }
}
