protected void DropDownList_class_SelectedIndexChanged(object sender, EventArgs e) { CourseTableBLL ctBLL = new CourseTableBLL(); CourseBLL courBLL = new CourseBLL(); TeacherBLL teachBLL = new TeacherBLL(); DropDownList_course.Items.Clear(); DropDownList_course.DataSource = courBLL.getByClassId(DropDownList_class.SelectedValue); DropDownList_course.DataTextField = "name"; DropDownList_course.DataValueField = "ID"; DropDownList_course.DataBind(); DropDownList_teacher.Items.Clear(); string filterTeacher = "classID='" + DropDownList_class.SelectedValue + "' and courId='" + DropDownList_course.SelectedValue + "'"; DataTable tempDt = PageUtil.getProcessedDataTable(ctBLL.getAll().Tables[0], filterTeacher, null, false); DataView dv = tempDt.DefaultView; tempDt = dv.ToTable(true, "teachID"); foreach (DataRow dr in tempDt.Rows) { Teacher teacher = teachBLL.get(dr["teachID"].ToString()); DropDownList_teacher.Items.Add(new ListItem(teacher.Name, teacher.Id)); } bind(); }
/// <summary> /// 绑定数据源 /// </summary> private void bind() { string id = Request.QueryString["id"].ToString(); AttendanceBLL attendBLL = new AttendanceBLL(); attend = attendBLL.get(id); CourseTableBLL ctBLL = new CourseTableBLL(); CourseTable ct = ctBLL.get(attend.CourTableID); ClassBLL classBLL = new ClassBLL(); TeacherBLL teacherBLL = new TeacherBLL(); CourseBLL courseBLL = new CourseBLL(); StudentBLL stuBLL = new StudentBLL(); #region 绑定页面数据 Label_class.Text = classBLL.get(ct.ClassID).Name; Label_course.Text = courseBLL.get(ct.CourId).Name; Label_teacher.Text = teacherBLL.get(ct.TeachID).Name; Label_student.Text = stuBLL.get(attend.StudID).Name; Label_oldStatus.Text = attend.Status; Label_week.Text = ct.Week; Label_weekDay.Text = ct.WeekDay; Label_courseTime.Text = ct.CourseTime; Label_place.Text = ct.Place; #endregion }
/// <summary> /// 绑定数据源 /// </summary> private void bind() { string courTableID = Request.QueryString["courTableID"]; CourseTableBLL ctBLL = new CourseTableBLL(); TeacherBLL teacherBLL = new TeacherBLL(); CourseBLL courBLL = new CourseBLL(); ClassBLL classBLL = new ClassBLL(); CourseTable ct = ctBLL.get(courTableID); Class clazz = classBLL.get(ct.ClassID); #region 页面数据绑定 className.Text = clazz.Name; courseName.Text = courBLL.get(ct.CourId).Name; teacherName.Text = teacherBLL.get(ct.TeachID).Name; week.Text = "第" + ct.Week + "周"; weekDay.Text = ct.WeekDay; classtTime.Text = ct.CourseTime; classAddress.Text = ct.Place; CommonBLL commBLL = new CommonBLL(); DataTable dt = commBLL.getAbsentStudent(courTableID,false); 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.getPaged(dt, from, to); GridView1.DataBind(); #endregion }
protected void ImageButton_delete_Click(object sender, ImageClickEventArgs e) { ImageButton imageButton = sender as ImageButton; string id = imageButton.CommandArgument; TeacherBLL teachBLL = new TeacherBLL(); UserBLL userBLL = new UserBLL(); Teacher teacher = teachBLL.get(id); User user = userBLL.get(teacher.UserID); teachBLL.delete(teacher); userBLL.delete(user); Response.Write("<script>alert('删除成功!');location.href='showTeachers.aspx';</script>"); }
private void bind() { string id = Request.QueryString["id"].ToString(); TeacherBLL teachBLL = new TeacherBLL(); teacher = teachBLL.get(id); Label_teachId.Text = teacher.TeacherId; TextBox_name.Text = teacher.Name; if (teacher.Gender.Equals("女")) RadioButton_female.Checked = true; PageUtil.bindDropDownList(DropDownList_yearPart1, teacher.Birth[0].ToString()); PageUtil.bindDropDownList(DropDownList_yearPart2, teacher.Birth[1].ToString()); PageUtil.bindDropDownList(DropDownList_yearPart3, teacher.Birth[2].ToString()); PageUtil.bindDropDownList(DropDownList_yearPart4, teacher.Birth[3].ToString()); PageUtil.bindDropDownList(DropDownList_month, teacher.Birth.Substring(4, 2)); PageUtil.bindDropDownList(DropDownList_title, teacher.Title); TextBox_phone.Text = teacher.Phone; TextBox_email.Text = teacher.Email; }
public void bind() { List<Attendance> attenList = Session["attenList"] as List<Attendance>; CourseTableBLL ctBLL = new CourseTableBLL(); TeacherBLL teachBll = new TeacherBLL(); CourseBLL courBLL = new CourseBLL(); ClassBLL classBLL = new ClassBLL(); CourseTable ct = ctBLL.get(attenList[0].CourTableID); Class clazz = classBLL.get(ct.ClassID); #region 页面数据绑定 className.Text = clazz.Name; courseName.Text = courBLL.get(ct.CourId).Name; teacherName.Text = teachBll.get(ct.TeachID).Name; week.Text = "第" + ct.Week + "周"; weekDay.Text = ct.WeekDay; classtTime.Text = ct.CourseTime; classAddress.Text = ct.Place; lateNumber.Text = attenList.Where(x => x.Status.Equals("迟到")).ToList().Count.ToString(); absences.Text = attenList.Where(x => !x.Status.Equals("正常")).ToList().Count.ToString(); allNumber.Text = clazz.StudCount; attRate.Text = FormatUtil.doubleToPercent(attenList.Where(x => x.Status.Equals("正常")).ToList().Count / Convert.ToDouble(clazz.StudCount)); DataTable dt = transferListToDataTable(attenList); 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(); #endregion }
/// <summary> /// 绑定数据源 /// </summary> private void bind() { string id = Request.QueryString["ID"].ToString(); string week = Request.QueryString["week"].ToString(); CourseBLL courBLL = new CourseBLL(); TeacherBLL teacherBLL = new TeacherBLL(); ClassBLL classBLL = new ClassBLL(); CourseTableBLL ctBLL = new CourseTableBLL(); ct = ctBLL.get(id); #region 页面数据绑定 Label_course.Text = courBLL.get(ct.CourId).Name; Label_teacher.Text = teacherBLL.get(ct.TeachID).Name; Label_class.Text = classBLL.get(ct.ClassID).Name; PageUtil.bindDropDownList(DropDownList_semester_from, ct.Semester.Substring(0, 4)); PageUtil.bindDropDownList(DropDownList_semester_to, ct.Semester.Substring(5, 4)); PageUtil.bindDropDownList(DropDownList_semester_end, ct.Semester.Substring(9, 3)); PageUtil.bindDropDownList(DropDownList_week_from, week.Split('-')[0]); PageUtil.bindDropDownList(DropDownList_week_to, week.Split('-')[1]); PageUtil.bindDropDownList(DropDownList_weekDay, ct.WeekDay); TextBox_place.Text = ct.Place; PageUtil.bindDropDownList(DropDownList_courseTime, ct.CourseTime.Split('节')[0]); #endregion }