Beispiel #1
0
        //筛选学生签到记录
        private void toolStripButton7_Click(object sender, EventArgs e)
        {
            string option = "";

            if (toolStripComboBox4.Text.Trim() != "")
            {
                option = " AND Sign.classId = " + Convert.ToInt32(toolStripComboBox4.Text.Trim()) +
                         "AND ChooseCls.classId = " + Convert.ToInt32(toolStripComboBox4.Text.Trim());
                DataTable dt = SignManager.DisplayDifferentSignUp(teacher.Id, option);
                dt.Columns[0].ColumnName = "签到编号";
                dt.Columns[1].ColumnName = "学生学号";
                dt.Columns[2].ColumnName = "学生姓名";
                dt.Columns[3].ColumnName = "IP地址";
                dt.Columns[4].ColumnName = "签到时间";
                dt.Columns[5].ColumnName = "签到状态";
                dataGridView3.DataSource = dt;
            }
            else
            {
                RefreshClassTable();
            }
        }