//绑定用户组下拉列表 public void DataBindGroupUsers() { DalOperationUsers dou = new DalOperationUsers(); DataTable dt = null; if (ddlUserGroup.SelectedValue == "3") { dt = dou.SearchStudentByCourseNo(ddlCourses.SelectedValue.Trim()).Tables[0]; dt.Columns["studentNo"].ColumnName = "userNo"; dt.Columns["studentName"].ColumnName = "userName"; } else { dt = dou.FindUserByTypeAndKeywod(ReturnUserGroup(), ""); } if (dt.Rows.Count > 0) { EmailCounts.Visible = true; } else { EmailCounts.Visible = false; } this.dlSearchUserGroup.DataSource = dt.DefaultView; this.dlSearchUserGroup.DataBind(); int recordCount = dt.Rows.Count; if (recordCount == 0) { this.dlSearchUserGroup.ShowFooter = true; } else { this.dlSearchUserGroup.ShowFooter = false; } if (dt.Rows.Count > 0) { ltlSelectAllUser.Text = "<input id=\"dzxBtnSelectAll\" name=\"dzxBtnSelectAll\" type=\"button\" value=\"全选\" onclick=\"selectAll();\" /> "; } }
protected void btnExamSeatArrange_Click(object sender, EventArgs e) { List<string> listStudent = new List<string>(); if (ddlCourses.SelectedValue != "-1") { DalOperationUsers dou = new DalOperationUsers(); DataTable dt1 = dou.SearchStudentByCourseNo(ddlCourses.SelectedValue.Trim()).Tables[0]; Session["examSeatArrange_dt1"] = dt1; for (int i = 0; i < dt1.Rows.Count;i++ ) { listStudent.Add(dt1.Rows[i]["studentNo"].ToString().Trim() + "_" + dt1.Rows[i]["studentName"].ToString().Trim()); } DalOperationAboutGradeCheck dal = new DalOperationAboutGradeCheck(); DataTable dt2 = dal.GetStudentGradeCheckApplyAccordByCourse(ddlCourses.SelectedValue).Tables[0]; Session["examSeatArrange_dt2"] = dt2; for (int j = 0; j < dt2.Rows.Count; j++) { listStudent.Add(dt2.Rows[j]["studentNo"].ToString().Trim() + "_" + dt2.Rows[j]["studentName"].ToString().Trim()); } //总学生人数 int studentsNum = dt1.Rows.Count + dt2.Rows.Count; //座位行数 int rows = int.Parse(txtRows.Text.Trim()); //座位列数 int cols = -1; if (studentsNum % rows == 0) { cols = studentsNum / rows; } else { cols = (studentsNum / rows) + 1; } Table tb = new Table(); tb.CssClass = "datagrid2"; tb.Width = Unit.Percentage(100); TableRow tr1 = new TableRow(); TableHeaderCell th = new TableHeaderCell(); th.Style["text-align"] = "center"; th.ColumnSpan = cols; th.Text = ddlCourses.SelectedItem.Text + "(当前共" + rows.ToString() + "行" + cols.ToString() + "列" + studentsNum + "名学生)"; tr1.Cells.Add(th); tb.Rows.Add(tr1); for (int x = 0; x < rows; x++) { TableRow tr = new TableRow(); for (int k = 0; k < cols; k++) { TableCell td = new TableCell(); td.HorizontalAlign = HorizontalAlign.Center; if (studentsNum > 0) { List<string> listStudentCopy = listStudent; List<string> newList = new List<string>(); while (listStudentCopy.Count > 0) { Random random = new Random(); int _index = random.Next(listStudentCopy.Count); newList.Insert(0, listStudentCopy[_index]); listStudentCopy.RemoveAt(_index); } listStudent = newList; int _rdm = GenerateRandom(studentsNum); string _studentNo = listStudent[_rdm].Split("_".ToCharArray())[0]; string _studentName = listStudent[_rdm].Split("_".ToCharArray())[1]; td.Text = _studentName + "<br />(" + _studentNo + ")"; listStudent.RemoveAt(_rdm); studentsNum--; } tr.Cells.Add(td); } tb.Rows.Add(tr); } phExamSeats.Controls.Add(tb); outputExcel.Visible = true; } else { Javascript.GoHistory(-1, "请选择课程:)", Page); } }