using System; using System.Collections.Generic; using System.Linq; using System.Web; using System.Web.UI; using System.Web.UI.WebControls; using CY.BLL; using CY.Model; using CY.Infrastructure.Query; using CY.Infrastructure.Common; using CY.BLL.Sys; using System.Data; namespace CY.WebForm.Pages.front { //吴辉 //前台-帮助中心信息列表 public partial class HelpCenterList : FrontBasePage { Info_ContentBLL bll_Info_ContentBLL = null; Sys_DictionaryBLL bll_Sys_DictionaryBLL = null; Info_SortBLL bll_Info_SortBLL = null; //初始化 public HelpCenterList() { bll_Sys_DictionaryBLL = new Sys_DictionaryBLL(); bll_Info_ContentBLL = new Info_ContentBLL(); bll_Info_SortBLL = new Info_SortBLL(); } protected void Page_Load(object sender, EventArgs e) { UCPager1.AspNetPager.PageChanged += AspNetPager1_PageChanged; if (!IsPostBack) { BindList(); InitialSelectData(); } } //加载查询条件 protected void InitialSelectData() { DataTable ds = bll_Info_SortBLL.SelectList("11111111-1111-1111-1111-111111111111".ToGuid2()); string SortTypeHtml = ""; if (ds != null && ds.Rows.Count > 0) { GetDataByLevel(ref SortTypeHtml, ds, bll_Sys_DictionaryBLL.GetKeyIdByKeyid(2, "网站资讯类型"), 1); } this.InquiryMoney.InnerHtml = SortTypeHtml; } //遍历数据 public void GetDataByLevel(ref string SortTypeHtml, DataTable data, int? parentId, int level) { if (data == null || data.Rows.Count == 0) return; DataRow[] result = data.Select(string.Format("ParentId={0}", parentId)); int i = -1; while (++i < result.Length) { SortTypeHtml += "

" + result[i]["Title"].ToString2() + "

"; } } //绑定数据 private void BindList() { int? sortid = Request["sortid"].ToInt32() ?? bll_Sys_DictionaryBLL.GetKeyIdByKeyid(2, "网站资讯类型").ToInt32(); Pagination pa = new Pagination(); pa.PageSize = UCPager1.AspNetPager.PageSize; pa.PageIndex = UCPager1.AspNetPager.CurrentPageIndex; this.RepClientList.DataSource = bll_Info_ContentBLL.SelectModelPage(pa, "11111111-1111-1111-1111-111111111111".ToGuid2(), bll_Sys_DictionaryBLL.GetKeyIdByKeyid(2, "网站资讯类型").ToInt32(), sortid, this.txtTitle.Value.ToString2(), "OrderNum ASC"); this.RepClientList.DataBind(); UCPager1.AspNetPager.RecordCount = pa.RecordCount; Info_Sort m_Info_Sort = bll_Info_SortBLL.SelectModelByKeyId(sortid); if (m_Info_Sort != null) { this.oneTitle.InnerText = m_Info_Sort.Title; this.twoTitle.InnerText = m_Info_Sort.Title; } } //分页事件 protected void AspNetPager1_PageChanged(object src, EventArgs e) { BindList(); } //查询事件 protected void btn_Search_Click(object sender, EventArgs e) { BindList(); } } }