public bool AddScore(ScoreMsg score)
{
_DBMySchool.ScoreMsg.InsertOnSubmit(score);
try
{
_DBMySchool.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
ScoreMsg score = GetScore();
if (score != null)
{
if (_ViewModel.UpdateScore(score))
{
MessageBox.Show("更新成功", "消息", MessageBoxButtons.OK);
}
else
{
MessageBox.Show("更新失败，请选择添加", "消息", MessageBoxButtons.OK);
}
}
}
public bool DeleteScore(ScoreMsg score)
{
var query = from q in _DBMySchool.ScoreMsg
where score.CourseId == q.CourseId && score.StudentNo == q.StudentNo
select q;
_DBMySchool.ScoreMsg.DeleteAllOnSubmit(query);
try
{
_DBMySchool.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private ScoreMsg GetScore()
{
ScoreMsg score = new ScoreMsg();
Debug.WriteLine(RegularExpressions.IsNumeric(tbScore.Text));
if (tbStuName.Text.Equals("") || tbCourseName.Text.Equals("") || tbScore.Text.Equals(""))
{
MessageBox.Show("请确保输入数据正确", "错误", MessageBoxButtons.OK);
return(null);
}
else
{
score.CourseId = Convert.ToInt32(tbCourseNo.Text);
score.StudentNo = Convert.ToInt32(tbStuNo.Text);
score.Score = Convert.ToInt32(tbScore.Text);
}
return(score);
}
public bool UpdateScore(ScoreMsg score)
{
var query = _DBMySchool.ScoreMsg.Where(x => x.CourseId == score.CourseId && x.StudentNo == score.StudentNo);
foreach (var item in query)
{
item.Score = score.Score;
}
try
{
_DBMySchool.SubmitChanges();
return(true);
}
catch (Exception ex)
{
return(false);
}
}
private void btnAdd_Click(object sender, EventArgs e)
{
ScoreMsg score = GetScore();
if (score != null)
{
if (_ViewModel.AddScore(score))
{
MessageBox.Show("添加成功", "消息", MessageBoxButtons.OK);
_ScoreList = _ViewModel.LoadScores().ToList();
_Current = _ScoreList.Count;
ShowData();
}
else
{
MessageBox.Show("添加失败", "消息", MessageBoxButtons.OK);
}
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
ScoreMsg score = GetScore();
if (score != null)
{
if (_ViewModel.DeleteScore(score))
{
MessageBox.Show("删除成功", "消息", MessageBoxButtons.OK);
_ScoreList = _ViewModel.LoadScores().ToList();
_Current = _Current > 0 ? _Current - 1 : 0;
ShowData();
}
else
{
MessageBox.Show("删除失败", "消息", MessageBoxButtons.OK);
}
}
}
