Exemplo n.º 1
0
Arquivo: MainForm.cs Projeto: Gqqq/-
        /// <summary>
        /// 刷新
        /// </summary>
        void BindListView()
        {
            this.lvwStudent.Items.Clear();//清空列表
            //获取选中节点的Tag值,即编号
            string id = this.tvwOrg.SelectedNode.Tag.ToString();

            stumodel.StudentClass = id;
            DataTable dt = student.GetStudentByClasses(stumodel);

            if (id.Length == 8)//编号长度为8位,则为班级编号,查询该班所有学生
            {
                stumodel.StudentClass = id;
                dt = student.GetStudentByClasses(stumodel);
            }
            if (id.Length == 4)
            {
                clamodel.Classes_Speciality = id;
                dt = student.GetStudentsBySpec(clamodel);
            }
            if (id.Length == 2)
            {
                specmodel.Speciality_College = id;
                dt = student.GetStudentsByCollege(specmodel);
            }
            foreach (DataRow r in dt.Rows)
            {
                ListViewItem lv = new ListViewItem();   //实例化一个列表项
                lv.Text = r["Student_Name"].ToString(); //项的文本
                lv.Tag  = r["Student_ID"];              //项的关联数据
                if (r["Student_Sex"].ToString() == "男")
                {
                    lv.ImageIndex = 0;
                }
                else
                {
                    lv.ImageIndex = 1;
                }
                //添加子项
                lv.SubItems.Add(r["StudentNum"].ToString());
                lv.SubItems.Add(r["Student_Sex"].ToString());
                lv.SubItems.Add(r["College_Name"].ToString());
                lv.SubItems.Add(r["Speciality_Name"].ToString());
                lv.SubItems.Add(r["StudentEnterYear"].ToString());
                lv.SubItems.Add(r["SpeYears_Name"].ToString());
                lv.SubItems.Add(r["StudentOrigin"].ToString());
                this.lvwStudent.Items.Add(lv);
            }
        }