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 WantShopList : FrontBasePage { Info_ContentBLL bll_Info_ContentBLL = null; Sys_DictionaryBLL bll_Sys_DictionaryBLL = null; Info_SortBLL bll_Info_SortBLL = null; //初始化 public WantShopList() { 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(1, "网站资讯类型"), 1); } this.InquiryMoney.InnerHtml = SortTypeHtml; } //遍历数据 public static void GetDataByLevel(ref string SortTypeHtml, DataTable data, int? parentId, int level) { DataRow[] result = data.Select(string.Format("ParentId={0}", parentId)); int i = -1; while (++i < result.Length) { SortTypeHtml += "
  • " + result[i]["Title"].ToString2() + "
  • "; GetDataByLevel(ref SortTypeHtml, data, result[i]["Keyid"].ToInt32().Value, level + 1); } } //绑定数据 private void BindList() { int? sortid = Request["sortid"].ToInt32() ?? bll_Sys_DictionaryBLL.GetKeyIdByKeyid(1, "网站资讯类型").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(1, "网站资讯类型").ToInt32(), sortid,"", "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.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(); } } }