//删除成绩
private void btnDeleteStu_Click(object sender, RoutedEventArgs e)
{
selesco = smDgScoreLsit.SelectedItem as StuCoreExt;
if (selesco == null)
{
System.Windows.Forms.MessageBox.Show("请选择要删除的学员!", "提示");
return;
}
StuCoreExt scorE = scoreManager.GetStudentById(selesco.StudentID);
if (scorE != null)
{
System.Windows.Forms.MessageBox.Show("您选择的学员信息已删除", "提示");
}
MessageBoxResult mbox = MessageBox.Show("您确定要删除【" + scorE.StudentName + "】", "警告", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
if (mbox == MessageBoxResult.OK)
{
if (scoreManager.DeleScore(scorE.StudentID))
{
MessageBox.Show("删除成功");
RefreshDG();
}
else
{
MessageBox.Show("删除失败");
}
}
}
//输入学号失焦事件
private void textstuId_LostFocus(object sender, RoutedEventArgs e)
{
if (string.IsNullOrEmpty(textstuId.Text))
{
System.Windows.Forms.MessageBox.Show("学号不能为空！！！", "提示");
textstuId.Focus();
}
else
{
int stuId = Convert.ToInt32(textstuId.Text.Trim());
//先判断是否存在此学生，再判断是否存在成绩
stuexe = stumanage.GetStudentById(stuId); //获取到学生信息
scoexe = scomanage.GetStudentById(stuId); //获取学生的成绩信息
//1.判断是否存在此学生，存在的话，再判断是否已经存储成绩
if (stuexe != null)
{
//2.判断是否已有成绩
if (scoexe == null) //如果没有成绩
{
labStuName.Content = stuexe.StudentName; //姓名显示
labStuClass.Content = stuexe.ClassName; //学号显示
}
else
{
System.Windows.Forms.MessageBox.Show("已有成绩，请重新输入！！！", "友情提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
textstuId.Focus();
}
}
else
{
System.Windows.Forms.MessageBox.Show("不存在此学生，请重新输入！！！", "友情提示", System.Windows.Forms.MessageBoxButtons.OK, System.Windows.Forms.MessageBoxIcon.Information);
textstuId.Focus();
}
}
}
public FrmUpdateScoreInfo(StuCoreExt scorexe)
{
score = scorexe;
InitializeComponent();
labStuName.Content = scorexe.StudentName;
labStuID.Content = scorexe.StudentID;
textCsharpScore.Text = scorexe.CSharp.ToString();
textSqlScore.Text = scorexe.SQLServerDB.ToString();
}
/// <summary>
/// 修改学员成绩
/// </summary>
/// <param name="score">学员对象</param>
/// <returns></returns>
public bool UpScore(StuCoreExt score)
{
if (scoserver.UpScore(score) <= 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 添加学员
/// </summary>
/// <param name="sco"></param>
/// <returns></returns>
public bool AddScore(StuCoreExt sco)
{
int addsc = scoserver.AddScore(sco);
if (addsc <= 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 通过学号查询成绩信息
/// </summary>
/// <param name="id">学号</param>
/// <returns></returns>
public StuCoreExt GetScoreById(int id)
{
string sql = "SELECT ScoreList.StudentID, StudentName,StudentClass.ClassName,CSharp,SQLServerDB,ScoreUpdateTime FROM ScoreList JOIN Students ON ScoreList.StudentID=Students.StudentID JOIN StudentClass ON Students.ClassID=StudentClass.ClassID WHERE ScoreList.StudentID=" + id + "";
SqlDataReader reader = DBHelper.SQLHelper.DataReader(sql);
StuCoreExt score = null;
while (reader.Read())
{
score = new StuCoreExt()
{
StudentID = Convert.ToInt32(reader["StudentID"]),
StudentName = reader["StudentName"].ToString(),
ClassName = reader["ClassName"].ToString(),
CSharp = Convert.ToInt32(reader["CSharp"]),
SQLServerDB = Convert.ToInt32(reader["SQLServerDB"]),
ScoreUpdateTime = Convert.ToDateTime(reader["ScoreUpdateTime"])
};
}
return(score);
}
//修改成绩
private void btnUpdateStu_Click(object sender, RoutedEventArgs e)
{
selesco = smDgScoreLsit.SelectedItem as StuCoreExt;
try
{
if (selesco == null)
{
MessageBox.Show("请选择要修改的学员！", "提示");
return;
}
}
catch (Exception)
{
System.Windows.Forms.MessageBox.Show("请选定学员！");
return;
}
StuCoreExt objscor = scoreManager.GetStudentById(selesco.StudentID);
FrmUpdateScoreInfo updateScoreInfo = new FrmUpdateScoreInfo(objscor);
updateScoreInfo.ShowDialog();
//刷新DG中学员信息
RefreshDG();
}
/// <summary>
/// 修改学员成绩
/// </summary>
/// <param name="scor">成绩对象</param>
/// <returns></returns>
public int UpScore(StuCoreExt scor)
{
string sql = string.Format("UPDATE ScoreList SET CSharp={0},SQLServerDB={1} WHERE StudentID={2}", scor.CSharp, scor.SQLServerDB, scor.StudentID);
return(DBHelper.SQLHelper.ExecuteNonQurey(sql));
}
/// <summary>
/// 添加学员成绩
/// </summary>
/// <param name="sco"></param>
/// <returns></returns>
public int AddScore(StuCoreExt sco)
{
string sql = string.Format("INSERT ScoreList VALUES ({0},{1},{2},'{3}')", sco.StudentID, sco.CSharp, sco.SQLServerDB, sco.ScoreUpdateTime);
return(DBHelper.SQLHelper.ExecuteNonQurey(sql));
}
