Exemplo n.º 1
0
        /// <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;
            }
        }
Exemplo n.º 2
0
        //绑定搜索的课程信息
        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;
            }
        }
Exemplo n.º 3
0
    //绑定搜索的课程信息
    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;
        }
    }
Exemplo n.º 4
0
    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"));
        }
    }