/// <summary> /// 绑定搜索的课程信息 /// </summary> public void DataBindSearchCourse() { DalOperationAboutCourses doac = new DalOperationAboutCourses(); for (int i = 0; i < ddlTermTags.Items.Count; i++) { if (ddlTermTags.Items[i].Value == termTag) { ddlTermTags.SelectedIndex = i; } } for (int i = 0; i < ddlPlace.Items.Count; i++) { if (ddlPlace.Items[i].Value == locale) { ddlPlace.SelectedIndex = i; } } DataView dv; if (!string.IsNullOrEmpty(termTag) && !string.IsNullOrEmpty(locale) && !string.IsNullOrEmpty(keyword)) { dv = doac.SearchCourses(termTag, keyword, locale).Tables[0].DefaultView; } else { dv = doac.SearchCourses(ddlTermTags.SelectedValue, txtKeyword.Text.Trim(), ddlPlace.SelectedValue).Tables[0].DefaultView; } AspNetPager1.RecordCount = dv.Count; AspNetPager1.PageSize = 2; PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功 pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = pageIndex - 1; pds.PageSize = AspNetPager1.PageSize; this.dlstCourses.DataSource = pds; this.dlstCourses.DataBind(); if (dv.Count == 0) { this.dlstCourses.ShowFooter = true; } else { this.dlstCourses.ShowFooter = false; } }
//绑定搜索的课程信息 public void DataBindSearchCourse() { DalOperationAboutCourses doac = new DalOperationAboutCourses(); DataView dv = doac.SearchCourses(ddlTermTags.SelectedValue, txtGradeCheckCourses.Text.Trim()).Tables[0].DefaultView; this.dlstcourses.DataSource = dv; this.dlstcourses.DataBind(); if (dv.Count > 0) { this.dlstcourses.ShowFooter = false; } }
//绑定搜索的课程信息 public void DataBindSearchCourse() { DalOperationAboutCourses doac = new DalOperationAboutCourses(); DataView dv = doac.SearchCourses(ddlSerachTermTags.SelectedValue, txtKeyword.Text.Trim()).Tables[0].DefaultView; this.AspNetPager2.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); //定义一个PagedDataSource类来执行分页功 pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager2.CurrentPageIndex - 1; pds.PageSize = CommonUtility.pageSize; ; this.dlSearchCourse.DataSource = pds; this.dlSearchCourse.DataBind(); if (pds.Count > 0) { this.dlSearchCourse.ShowFooter = false; } }
protected void ddlBindCourses(bool isAll) { DalOperationAboutCourses doac = new DalOperationAboutCourses(); DataTable dv = doac.SearchCourses(ddlTermTags.SelectedValue, txtCourseName.Text.Trim()).Tables[0]; bool isSearchNoResult = false; while (ddlCourses.Items.Count > 0) { ddlCourses.Items.RemoveAt(0); } if (isAll) { ddlCourses.Items.Add(new ListItem("全部课程", "all")); } if (dv.Rows.Count == 0) { dv = doac.SearchCourses(ddlTermTags.SelectedValue, "").Tables[0]; isSearchNoResult = true; } for (int i = 0; i < dv.Rows.Count; i++) { ddlCourses.Items.Add(new ListItem(dv.Rows[i]["courseName"].ToString().Trim() + "(" + dv.Rows[i]["classID"].ToString().Trim() + ")", dv.Rows[i]["termTag"].ToString().Trim() + dv.Rows[i]["courseNo"].ToString().Trim() + dv.Rows[i]["classID"].ToString().Trim())); } if (isSearchNoResult) { ddlCourses.Items.Add(new ListItem("全部课程", "all")); } }