/// <summary> /// 更新个人信息 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> void btnCommit_Click(object sender, EventArgs e) { this.Validate(); try { CourseMgrDataContext c = new CourseMgrDataContext(); var q = (from t in c.StudentInfo where t.userid == User.userid select t).Single(); q.username = this.usernameTextBox.Text.Trim(); q.sex = this.sexTextBox.Text.Trim(); q.politics = this.politicsTextBox.Text.Trim(); q.nation = this.nationTextBox.Text.Trim(); q.birthday = this.birthdayDateTimePicker.Value; q.phone = this.phoneTextBox.Text.Trim(); q.idcard = this.idcardTextBox.Text.Trim(); c.SubmitChanges(); string sql = "update StudentInfo set photo=@Photo where userid = '" + User.userid + "'"; SaveImage(this.photoPictureBox, sql); ShowMessage("保存成功"); } catch (Exception ex) { ShowMessage("保存失败:" + ex.Message); } }
void btnAdd_Click(object sender, EventArgs e) { foreach (Control item in this.Controls) { TextBox tb = null; if (item is TextBox) { tb = item as TextBox; if (string.IsNullOrEmpty(tb.Text.Trim())) { ShowMessage(tb.Tag + "不能为空"); return; } } } int credit = 0; bool b = Int32.TryParse(this.tbCcredit.Text.Trim(), out credit); if (!b) { ShowMessage("学分只能为数字,请重新输入!"); return; } CourseMgrDataContext c = new CourseMgrDataContext(); Course course = new Course(); course.Cname = this.tbCname.Text.Trim(); course.Cmajorname = this.tbCmajorname.Text.Trim(); course.Cinfo = this.tbCinfo.Text.Trim(); course.Cteacher = this.tbCteacher.Text.Trim(); course.Ctime = this.tbCtime.Text.Trim(); course.Ccredit = credit; c.Course.InsertOnSubmit(course); c.SubmitChanges(); ShowMessage("添加新课程成功"); this.DialogResult = DialogResult.OK; }
void btnDeleteCourse_Click(object sender, EventArgs e) { if (courseDataGridView.SelectedRows.Count <= 0) { ShowMessage("请选择要删除的课程"); return; } string cTeacher = this.courseDataGridView.SelectedRows[0].Cells[5].Value.ToString(); if (cTeacher != User.userid) { ShowMessage("无法删除不是自己的课程"); return; } DialogResult dr = MessageBox.Show("确定删除选中的课程?", "提示!", MessageBoxButtons.OKCancel, MessageBoxIcon.Information); if (dr == DialogResult.OK) { string scno = this.courseDataGridView.SelectedRows[0].Cells[0].Value.ToString(); int cno = Int32.Parse(scno); CourseMgrDataContext c = new CourseMgrDataContext(); var q = from t in c.Course where t.Cid == cno select t; if (q.Count()>0) { var q1 = q.First(); c.Course.DeleteOnSubmit(q1); c.SubmitChanges(); ShowMessage("删除成功"); this.courseTableAdapter.Fill(this.courseMgrDataSet.Course); this.courseDataGridView.Refresh(); } } }
void btnOK_Click(object sender, EventArgs e) { int grade = 0; bool b = Int32.TryParse(this.fenshuTextBox.Text.Trim(), out grade); if (!b) { ShowMessage("分数只能为数字,请重新输入!"); return; } CourseMgrDataContext c = new CourseMgrDataContext(); var q = from t in c.SC where t.Cno == cno where t.Sno == this.useridTextBox.Text select t; if (q.Count() > 0) { var q1 = q.First(); q1.Grade = grade; c.SubmitChanges(); ShowMessage("登记分数成功"); this.selectCourseTableAdapter.Fill(this.courseMgrDataSet.SelectCourse, User.userid, cno); this.selectCourseDataGridView.Refresh(); } }