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

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

"; } } } } //获取隔位符 public static string GetSplitChar(int level) { string res = ""; //level.ToString2(); for (int i = 0; i < level; i++) { res += ".."; } return res; } //绑定数据 private void BindList(int? sortid) { 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(3, "网站资讯类型").ToInt32(), sortid, this.txtTitle.Value.ToString2(), "OrderNum ASC"); this.RepClientList.DataBind(); int? sortid_old = Request["sortid"].ToInt32() ?? bll_Sys_DictionaryBLL.GetKeyIdByKeyid(3, "网站资讯类型").ToInt32(); Info_Sort m_Info_Sort = bll_Info_SortBLL.SelectModelByKeyId(sortid_old); Info_Sort m_Info_SortParent = new Info_Sort(); if (m_Info_Sort != null) { m_Info_SortParent = bll_Info_SortBLL.SelectModelByKeyId(m_Info_Sort.ParentId); if (m_Info_SortParent != null) { this.oneTitle.InnerText = m_Info_SortParent.Title; } else { this.oneTitle.InnerText = m_Info_Sort.Title; } this.twoTitle.InnerText = m_Info_Sort.Title; } UCPager1.AspNetPager.RecordCount = pa.RecordCount; } //分页事件 protected void AspNetPager1_PageChanged(object src, EventArgs e) { int? sortid = Request["sortid"].ToInt32() ?? bll_Sys_DictionaryBLL.GetKeyIdByKeyid(3, "网站资讯类型").ToInt32(); Info_Sort m_Info_Sort = bll_Info_SortBLL.SelectModelByKeyId(sortid); Info_Sort m_Info_SortParent = new Info_Sort(); if (m_Info_Sort != null) { m_Info_SortParent = bll_Info_SortBLL.SelectModelByKeyId(m_Info_Sort.ParentId); } BindList(sortid); } //查询事件 protected void btn_Search_Click(object sender, EventArgs e) { int? sortid = Request["sortid"].ToInt32() ?? bll_Sys_DictionaryBLL.GetKeyIdByKeyid(3, "网站资讯类型").ToInt32(); Info_Sort m_Info_Sort = bll_Info_SortBLL.SelectModelByKeyId(sortid); Info_Sort m_Info_SortParent = new Info_Sort(); if (m_Info_Sort != null) { m_Info_SortParent = bll_Info_SortBLL.SelectModelByKeyId(m_Info_Sort.ParentId); } BindList(m_Info_SortParent.Keyid); } } }