public void bind() { courTableID = Request.QueryString["courTableID"]; User user = Session["User"] as User; TeacherBLL teachBLL = new TeacherBLL(); StudentBLL studBLL = new StudentBLL(); CourseTableBLL ctBLL = new CourseTableBLL(); CourseTable ct = ctBLL.get(courTableID); ClassBLL classBll = new ClassBLL(); Class cla = classBll.get(ct.ClassID); className.Text = cla.Name; dt = studBLL.getByClassId(ct.ClassID).Tables[0]; if (Session["attenList"] != null) { attenList = Session["attenList"] as List<Attendance>; } else { attenList = new List<Attendance>(); foreach (DataRow dr in dt.Rows) { Attendance attend = new Attendance(); attend.Status = "正常"; attend.Remark = ""; attend.Recorder = "教师"; attend.RecorderID = teachBLL.getByUserId(user.Id).Id; attend.StudID = dr["ID"].ToString(); attend.CourTableID = courTableID; attenList.Add(attend); } } AspNetPager1.RecordCount = dt.Rows.Count; int from = (AspNetPager1.CurrentPageIndex - 1) * AspNetPager1.PageSize + 1; int to = from + AspNetPager1.PageSize - 1 > AspNetPager1.RecordCount ? AspNetPager1.RecordCount : from + AspNetPager1.PageSize - 1; GridView1.DataSource = PageUtil.resort(PageUtil.getPaged(dt, from, to)); GridView1.DataBind(); initStatusAndRemark(); }
/// <summary> /// 页面数据绑定 /// </summary> private void bind() { CourseTableBLL ctBLL = new CourseTableBLL(); StudentBLL stuBLL = new StudentBLL(); //绑定页面查询条件的数据 DropDownList_student.Items.Clear(); DropDownList_student.DataSource = stuBLL.getByClassId(DropDownList_class.SelectedValue); DropDownList_student.DataTextField = "name"; DropDownList_student.DataValueField = "ID"; DropDownList_student.DataBind(); DropDownList_week.Items.Clear(); string filterWeek = "classID='" + DropDownList_class.SelectedValue + "' and courId='" + DropDownList_course.SelectedValue + "'"; filterWeek += " and teachID='" + DropDownList_teacher.SelectedValue + "'"; DataTable tempDt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filterWeek, null, false); int week_from = tempDt.Rows.Count == 0 ? 0 : tempDt.Select().Min(r => Convert.ToInt32(r["week"].ToString())); int week_to = tempDt.Rows.Count == 0 ? 0 : tempDt.Select().Max(r => Convert.ToInt32(r["week"].ToString())); for (int i = week_from; i <= week_to; i++) { DropDownList_week.Items.Add(i.ToString()); } string preValue = DropDownList_weekDay.SelectedValue; DropDownList_weekDay.Items.Clear(); string filterWeekDay = "week='" + DropDownList_week.SelectedValue + "'"; tempDt = PageUtil.getProcessedDataTable(tempDt, filterWeekDay, "weekDay", false); foreach (DataRow dr in tempDt.Rows) { DropDownList_weekDay.Items.Add(dr["weekDay"].ToString()); } PageUtil.bindDropDownList(DropDownList_weekDay, preValue); DropDownList_courseTime.Items.Clear(); string filterCourTime = "weekDay='" + DropDownList_weekDay.SelectedValue + "'"; tempDt = PageUtil.getProcessedDataTable(tempDt, filterCourTime, "courseTime", false); foreach (DataRow dr in tempDt.Rows) { DropDownList_courseTime.Items.Add(dr["courseTime"].ToString()); } string filterPlace = "courseTime='" + DropDownList_courseTime.SelectedValue + "'"; tempDt = PageUtil.getProcessedDataTable(tempDt, filterPlace, null, false); Label_place.Text = tempDt.Rows.Count == 0 ? "" : tempDt.Rows[0]["place"].ToString(); Label_courTableId.Text = tempDt.Rows.Count == 0 ? "" : tempDt.Rows[0]["ID"].ToString(); }