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;
}
/// <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 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 TMyCourse_Load(object sender, EventArgs e)
{
CourseMgrDataContext c = new CourseMgrDataContext();
var q = from t in c.Course where t.Cteacher == User.userid select t;
foreach (var item in q)
{
this.cbCno.Items.Add(item.Cid);
}
this.cbCno.SelectedIndex = 0;
}
void cbCno_SelectedIndexChanged(object sender, EventArgs e)
{
cno = Int32.Parse(this.cbCno.SelectedItem.ToString());
CourseMgrDataContext c = new CourseMgrDataContext();
var q = from t in c.Course where t.Cid == cno select t;
this.labelCname.Text = q.First().Cname;
try
{
this.selectCourseTableAdapter.Fill(this.courseMgrDataSet.SelectCourse, User.userid, cno);
}
catch (System.Exception ex)
{
System.Windows.Forms.MessageBox.Show(ex.Message);
}
}
public static string getUserName()
{
string username = "";
CourseMgrDataContext c = new CourseMgrDataContext();
switch (User.category)
{
case "1":
var q1 = (from t in c.TeacherInfo where t.Tuserid == User.userid select t).Single();
username = q1.Tusername;
break;
case "0":
var q2 = (from t in c.StudentInfo where t.userid == User.userid select t).Single();
username = q2.username;
break;
}
return username;
}
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();
}
}
