//绑定用户组下拉列表
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);
}
}
