public ScoreListExt GetStudentById(int id)
{
string sql = "SELECT ScoreList.Studentid, Students.StudentName ,CSharp,SQLServer,UpdateTime,StudentClass.ClassName FROM ScoreList INNER JOIN Students ON Students.Studentid=ScoreList.Studentid INNER JOIN StudentClass ON StudentClass.Classid=Students.Classid WHERE ScoreList.Studentid=" + id;
SqlDataReader reader = DBHelper.SQLHelper.GetReader(sql);
//string procName = "mohuchaxun";
//SqlParameter[] parameters =
// {
// new SqlParameter("@cid", System.Data.SqlDbType.Int),
// };
//parameters[0].Value = id;
//SqlDataReader reader = DBHelper.SQLHelper.GetReaderByPROC(procName, parameters);
ScoreListExt student = null;
while (reader.Read())
{
student = (new ScoreListExt()
{
Studentid = Convert.ToInt32(reader["Studentid"]),
StudentName = reader["StudentName"].ToString(),
CSharp = Convert.ToInt32(reader["CSharp"]),
ClassName = reader["ClassName"].ToString(),
SQLServer = Convert.ToInt32(reader["SQLServer"]),
UpdateTime = Convert.ToDateTime(reader["UpdateTime"])
});
}
return(student);
}
/// <summary>
/// 删除成绩
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void shan_Click(object sender, RoutedEventArgs e)
{
selectStu = smDgStudentLsit.SelectedItem as ScoreListExt;
if (IdList.Contains(selectStu.Studentid))
{
MessageBox.Show("请关闭正在查看的学员信息界面", "提示");
return;
}
if (selectStu == null)
{
MessageBox.Show("请选择要删除的学员！", "提示");
return;
}
ScoreListExt student = sm.GetStudentById(selectStu.Studentid);
if (student != null)
{
MessageBox.Show("您选择的学员信息已经被删除！", "提示");
return;
}
MessageBoxResult mbr = MessageBox.Show("您确定要删除【" + student.StudentName + "】", "警告", MessageBoxButton.OKCancel, MessageBoxImage.Warning);
if (mbr == MessageBoxResult.OK)
{
if (sm.DeleteStudentById(student.Studentid))
{
MessageBox.Show("删除成功！", "提示");
}
else
{
MessageBox.Show("删除失败请稍后再试！", "提示");
}
}
}
public FrmScoreListinfor(ScoreListExt stu)
{
InitializeComponent();
ScoreList = stu;
textcshap.Text = stu.CSharp.ToString();
textsql.Text = stu.SQLServer.ToString();
}
/// <summary>
/// 成绩录入
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void luruchengji_Click(object sender, RoutedEventArgs e)
{
selectStu = smDgStudentLsit.SelectedItem as ScoreListExt;
ScoreListExt objStu = sm.GetStudentById(selectStu.Studentid);
FrmScoreListinfor updateStuInfor = new FrmScoreListinfor(objStu);
updateStuInfor.ShowDialog();
students = sm.GetScoreList(Convert.ToInt32(smclassCmb.SelectedValue));
smDgStudentLsit.ItemsSource = students;
}
public FrmscorelistAdd(ScoreListExt stu)
{
InitializeComponent();
ScoreList = stu;
textcshap.Text = stu.CSharp.ToString();
textsql.Text = stu.SQLServer.ToString();
time.Text = stu.UpdateTime.ToString("yyyy-MM-dd");
smclassCmb.DisplayMemberPath = "Studentid";
smclassCmb.SelectedIndex = stu.Studentid - 1;
}
/// <summary>
/// 修改成绩
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
public bool UpdateStudentInfor(ScoreListExt student)
{
if (server.UpdateStudentInfor(student) <= 0)
{
return(false);
}
else
{
return(true);
}
}
/// <summary>
/// 修改学员信息
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
public int UpdateStudentInfor(ScoreListExt student)
{
string sql = string.Format("UPDATE ScoreList SET CSharp={0},SQLServer={1} WHERE Studentid={2}", student.CSharp, student.SQLServer, student.Studentid);
return(DBHelper.SQLHelper.ExecuteNonQuery(sql));
//string procName = "xiugaiScore";
//SqlParameter[] parameters =
// {
// new SqlParameter("@id", System.Data.SqlDbType.Int),
// new SqlParameter("@csharp", System.Data.SqlDbType.Int),
// new SqlParameter("@Sql", System.Data.SqlDbType.Int)
// };
//parameters[0].Value = student.Studentid;
//parameters[1].Value = student.CSharp;
//parameters[2].Value = student.SQLServer;
//return DBHelper.SQLHelper.ExecuteNonQueryByPROC(procName, parameters);
}
/// <summary>
/// 修改成绩
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
private void gai_Click(object sender, RoutedEventArgs e)
{
selectStu = smDgStudentLsit.SelectedItem as ScoreListExt;
if (IdList.Contains(selectStu.Studentid))
{
MessageBox.Show("请关闭正在查看的学员成绩信息界面", "提示");
return;
}
if (selectStu == null)
{
MessageBox.Show("请选择要修改的学员成绩！", "提示");
return;
}
ScoreListExt objStu = sm.GetStudentById(selectStu.Studentid);
FrmScoreListinfor updateStuInfor = new FrmScoreListinfor(objStu);
updateStuInfor.ShowDialog();
students = sm.GetScoreList(Convert.ToInt32(smclassCmb.SelectedValue));
smDgStudentLsit.ItemsSource = students;
}
/// <summary>
/// 成绩录入
/// </summary>
/// <param name="student"></param>
/// <returns></returns>
public int Getdaa(ScoreListExt student)
{
string sql = string.Format("INSERT INTO ScoreList VALUES ({0}, {1}, {2}, {3})", student.Studentid, student.CSharp, student.SQLServer, student.UpdateTime);
return(DBHelper.SQLHelper.ExecuteNonQuery(sql));
}
public int Getdaa(ScoreListExt student)
{
return(server.Getdaa(student));
}
