private void ShowAllInfo()
{
string className = this.tvwClass.SelectedNode.Text; //获取选中节点的名称（班级名称）
DataView dataview = new DataView(dtClass); //通过班级表new一个DataView
dataview.RowFilter = "className = '" + className + "'"; //根据班级名称筛选数据
DataTable dt = dataview.ToTable(); //获取筛选后的班级表
int classID = int.Parse(dt.Rows[0][0].ToString());
lstViewStudent.Items.Clear();
bllstudent = new BLLStudent();
dtStudent = bllstudent.GetStudentInfoClassID(classID);//查询所在班级的学生信息
if (dtStudent == null)
{
MessageBox.Show("該班級才剛剛建立，還沒有學生！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
for (int i = 0; i < dtStudent.Rows.Count; i++)
{
listview = new ListViewItem();
listview.Text = dtStudent.Rows[i][2].ToString();
listview.SubItems.Add(dtStudent.Rows[i][1].ToString());
listview.SubItems.Add(dtStudent.Rows[i][3].ToString());
listview.SubItems.Add(dtStudent.Rows[i][4].ToString());
listview.SubItems.Add(className);
listview.SubItems.Add(dtStudent.Rows[i][5].ToString());
lstViewStudent.Items.Add(listview);
}
}
tvwCourse.Nodes.Clear();
dtCourse = new DataTable();
bllcourse = new BLLCourse();
dtCourse = bllcourse.GetCourseInfoClassID(classID);//點擊班级列表時顯示課程訊息
if (dtStudent == null)
{
MessageBox.Show("該班級才剛剛建立，還沒有學生！", "提示", MessageBoxButtons.OK, MessageBoxIcon.Exclamation);
}
else
{
for (int i = 0; i < dtCourse.Rows.Count; i++)
{
TreeNode tn = new TreeNode(className + "-" + dtCourse.Rows[i]["CourseName"].ToString());
tvwCourse.Nodes.Add(tn);
}
tvwCourse.SelectedNode = tvwCourse.Nodes[0];
}
}
private void tvwCourse_AfterSelect(object sender, TreeViewEventArgs e)
{
string classCourse = e.Node.Text;
string[] str = classCourse.Split('-');
string className = str[0];
string courseName = str[1];
BLLCourse bco = new BLLCourse();
DataTable dtScore = bco.GetCourseAll();
DataView dvScore = new DataView(dtScore);
dvScore.RowFilter = "className='" + className + "' and courseName = '" + courseName + "'";
dgvScore.DataSource = dvScore;
}
