private void BindData() { DataTable dt = new BLL.common_adR().GetList("ad_group_id = " + (int)EnumCollection.adR_group.梧桐花轮播图 + " order by ad_group_id,ad_sort_id"); this.rptBanner.DataSource = dt; this.rptBanner.DataBind(); BLL.common_article bll = new BLL.common_article(); dt = bll.GetListByPage(" group_id = " + (int)EnumCollection.article_group.我们的服务, "add_time desc", 1, 4); this.rptService.DataSource = dt; this.rptService.DataBind(); dt = bll.GetListByPage(" group_id = " + (int)EnumCollection.article_group.客户案例, "add_time desc", 1, 8); this.rptCase.DataSource = dt; this.rptCase.DataBind(); if (bll.GetRecordCount(" group_id = " + (int)EnumCollection.article_group.客户案例) <= 8) { this.more_i.Visible = false; } dt = bll.GetListByPage(" group_id = " + (int)EnumCollection.article_group.新闻动态, " add_time desc ", 1, 4); this.rptNews.DataSource = dt; this.rptNews.DataBind(); if (bll.GetRecordCount(" group_id = " + (int)EnumCollection.article_group.新闻动态) <= 4) { this.news_more.Visible = false; } }
private void BindData() { #region 组装查询条件 string whereStr = " 1 = 1 "; string _keywords = keywords.Replace("'", ""); if (!string.IsNullOrEmpty(_keywords)) { if (Utils.IsSafeSqlString(_keywords)) { whereStr += " and (Title like '%" + _keywords + "%')"; } else { JscriptMsg("搜索关键词中包含危险字符,检索终止!", Utils.CombUrlTxt("Manage.aspx", "keywords={0}", "")); return; } } #endregion this.page = RequestHelper.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.common_article bll = new BLL.common_article(); this.rptList.DataSource = bll.GetListByPage(whereStr, "ID DESC", this.page, this.pageSize); this.rptList.DataBind(); this.totalCount = bll.GetRecordCount(whereStr); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("Manage.aspx", "keywords={0}&page={1}", this.keywords, "__id__"); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void BindData() { BLL.common_category catebll = new BLL.common_category(); DataTable dt = catebll.GetList(" group_id = " + (int)EnumCollection.category_group.新闻动态 + " order by sort asc "); this.rptCategory.DataSource = dt; this.rptCategory.DataBind(); if (this.cate <= 0) { Model.common_category cateModel = catebll.GetModel(1, " group_id = " + (int)EnumCollection.category_group.新闻动态, " sort asc "); if (cateModel != null) { this.cate = cateModel.id; } } this.pageIndex = RequestHelper.GetQueryInt("page", 1); BLL.common_article bll = new BLL.common_article(); string whereStr = " group_id = " + (int)EnumCollection.article_group.新闻动态 + " and category_id = " + this.cate; dt = bll.GetListByPage("*", "View_NewsList", whereStr, " add_time desc ", pageIndex, pageSize); this.rptNews.DataSource = dt; this.rptNews.DataBind(); int totalCount = bll.GetRecordCount("View_NewsList", whereStr); string pageUrl = Utils.CombUrlTxt("news_list.aspx", "page={0}", "__id__"); PageContent.InnerHtml = PageListHelper.OutPageList(totalCount, pageIndex, pageSize, pageUrl); }
private void BindData() { #region 组装查询条件 string whereStr = " group_id = " + (int)EnumCollection.article_group.我们的服务; string _keywords = keywords.Replace("'", ""); if (!string.IsNullOrEmpty(_keywords)) { if (Utils.IsSafeSqlString(_keywords)) { whereStr += " and ((title like '%" + _keywords + "%') or (content like '%" + _keywords + "%'))"; } else { JscriptMsg("搜索关键词中包含危险字符,检索终止!", Utils.CombUrlTxt("services_list.aspx", "keywords={0}", "")); return; } } #endregion this.page = RequestHelper.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.common_article bll = new BLL.common_article(); this.rptList.DataSource = bll.GetListByPage(whereStr, "add_time desc", this.page, this.pageSize); this.rptList.DataBind(); this.totalCount = bll.GetRecordCount(whereStr); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("services_list.aspx", "keywords={0}&page={1}&cp={2}", this.keywords, "__id__", this.cp + ""); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void BindData() { #region 组装查询条件 string whereStr = " group_id = " + (int)EnumCollection.article_group.精品微课问题讨论 + " and category_id = " + this.chapter; string _keywords = keywords.Replace("'", ""); if (!string.IsNullOrEmpty(_keywords)) { if (Utils.IsSafeSqlString(_keywords)) { whereStr += " and (Title like '%" + _keywords + "%')"; } else { JscriptMsg("搜索关键词中包含危险字符,检索终止!", Utils.CombUrlTxt("discuss_list.aspx", "keywords={0}", "")); return; } } Model.course_chapter ccModel = new BLL.course_chapter().GetModel(chapter); if (ccModel != null) { chapter_name = ccModel.name; Model.course_info course = new BLL.course_info().GetModel(ccModel.course_id); if (course != null) { course_name = course.name; } else { JscriptMsg("传递参数错误", "back"); return; } } else { JscriptMsg("传递参数错误", "back"); return; } #endregion this.page = RequestHelper.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.common_article bll = new BLL.common_article(); this.rptList.DataSource = bll.GetListByPage("*", "View_CourseArticle", whereStr, "add_time desc", this.page, this.pageSize); this.rptList.DataBind(); this.totalCount = bll.GetRecordCount("View_CourseArticle", whereStr); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("discuss_list.aspx", "keywords={0}&page={1}&chapter={2}", this.keywords, "__id__", this.chapter + ""); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }
private void BindData() { #region 组装查询条件 if (this.class_id > 0) { this.ddlClassroom.SelectedValue = this.class_id + ""; } else { this.class_id = Convert.ToInt32(this.ddlClassroom.SelectedValue); } string whereStr = " group_id = " + (int)EnumCollection.article_group.课堂公告 + " and category_id = " + this.class_id; string _keywords = keywords.Replace("'", ""); if (!string.IsNullOrEmpty(_keywords)) { if (Utils.IsSafeSqlString(_keywords)) { whereStr += " and (Title like '%" + _keywords + "%')"; } else { JscriptMsg("搜索关键词中包含危险字符,检索终止!", Utils.CombUrlTxt("notice_list.aspx", "keywords={0}&class_id={1}", "", this.class_id + "")); return; } } #endregion this.page = RequestHelper.GetQueryInt("page", 1); txtKeywords.Text = this.keywords; BLL.common_article bll = new BLL.common_article(); this.rptList.DataSource = bll.GetListByPage("*", "View_ClassroomNotice", whereStr, "ID DESC", this.page, this.pageSize); this.rptList.DataBind(); this.totalCount = bll.GetRecordCount("View_ClassroomNotice", whereStr); //绑定页码 txtPageNum.Text = this.pageSize.ToString(); string pageUrl = Utils.CombUrlTxt("notice_list.aspx", "keywords={0}&page={1}&chass_id={2}", this.keywords, "__id__", this.class_id + ""); PageContent.InnerHtml = Utils.OutPageList(this.pageSize, this.page, this.totalCount, pageUrl, 8); }