Beispiel #1
0
        //更新dataGridview
        private void RefreshClassTable()
        {
            var       cls   = CourseManager.GetAssociatedClasses(teacher);
            DataTable table = classDataGridView.DataSource as DataTable;

            table.Rows.Clear();
            foreach (var c in cls)
            {
                var r = table.NewRow();
                r.ItemArray = new object[] {
                    c.Id,
                    c.Name,  //=="SB"?"SB!":"!SB"
                    c.Category,
                    c.Time,
                    c.Place,
                    c.Capacity,   //<10?"<10":">=10"
                    c.UsualProportion
                };
                table.Rows.Add(r);
            }
            classDataGridView.DataSource = table;

            //Display all students dataGridView ColumnName
            var dt = GradeManager.AllStudent();

            dt.Columns[0].ColumnName = "学号";
            dt.Columns[1].ColumnName = "姓名";
            dt.Columns[2].ColumnName = "性别";
            dt.Columns[3].ColumnName = "学院";
            dataGridView2.DataSource = dt;

            toolStripComboBox3.Items.Clear();
            toolStripComboBox4.Items.Clear();
            DataTable tab = GradeManager.DisplayCombobox(teacher.Id);
            int       n   = (int)GradeManager.ReturnNum(teacher.Id);

            for (int i = 0; i < n; i++)
            {
                toolStripComboBox3.Items.Add(tab.Rows[i][0].ToString());
                toolStripComboBox4.Items.Add(tab.Rows[i][0].ToString());
            }

            var d = SignManager.DisplaySignUp(teacher.Id);

            d.Columns[0].ColumnName  = "签到编号";
            d.Columns[1].ColumnName  = "学生学号";
            d.Columns[2].ColumnName  = "学生姓名";
            d.Columns[3].ColumnName  = "课程编号";
            d.Columns[4].ColumnName  = "IP地址";
            d.Columns[5].ColumnName  = "签到时间";
            d.Columns[6].ColumnName  = "签到状态";
            dataGridView3.DataSource = d;

            var t = GradeManager.DisplayAllCourse(teacher.Id);

            t.Columns[0].ColumnName  = "学号";
            t.Columns[1].ColumnName  = "姓名";
            t.Columns[2].ColumnName  = "学院";
            t.Columns[3].ColumnName  = "课程编号";
            t.Columns[4].ColumnName  = "平时成绩";
            t.Columns[5].ColumnName  = "期末成绩";
            t.Columns[6].ColumnName  = "总成绩";
            dataGridView1.DataSource = t;

            var ta = MessageManager.DisplayNotice();

            ta.Columns[0].ColumnName = "编号";
            ta.Columns[1].ColumnName = "标题";
            ta.Columns[2].ColumnName = "发布教师";
            ta.Columns[3].ColumnName = "时间";
            dataGridView5.DataSource = ta;
            dataGridView4.DataSource = ta;

            var tabb = MessageManager.DisplayTeaSend(teacher);

            tabb.Columns[0].ColumnName = "编号";
            tabb.Columns[1].ColumnName = "学生ID";
            tabb.Columns[2].ColumnName = "留言内容";
            tabb.Columns[3].ColumnName = "时间";
            dataGridView6.DataSource   = tabb;

            var tta = MessageManager.DisplayTeaRece(teacher);

            tta.Columns[0].ColumnName = "编号";
            tta.Columns[1].ColumnName = "学生ID";
            tta.Columns[2].ColumnName = "留言内容";
            tta.Columns[3].ColumnName = "时间";
            dataGridView7.DataSource  = tta;
        }