const string vsKey = "searchCriteria"; //ViewState key /// <summary> /// 页面加载事件 /// </summary> /// <param name="sender"></param> /// <param name="e"></param> protected void Page_Load(object sender, EventArgs e) { if (!IsPostBack) { ddlRoomList.Items.Clear(); ChatRoomDAL rmdal = new ChatRoomDAL(); DataSet ds = new DataSet(); if (Session["strRoleCode"].ToString() == "ADMIN") { ds = rmdal.GetChatRoomList(""); } else { ds = rmdal.GetChatRoomList(" AND SiteCode ='" + Session["strSiteCode"].ToString() + "' "); } DataTable dt = ds.Tables[0]; DataRow dr = ds.Tables[0].NewRow(); dr["ID"] = 0; dr["RoomName"] = "--全部--"; dt.Rows.InsertAt(dr, 0); this.ddlRoomList.DataSource = ds.Tables[0].DefaultView; this.ddlRoomList.DataTextField = "RoomName"; this.ddlRoomList.DataValueField = "ID"; this.ddlRoomList.DataBind(); AspNetPager1.CurrentPageIndex = 1; string s = ""; if (Session["strSiteCode"].ToString() != "ADMIN") { s = " AND c.SiteCode = '" + Session["strSiteCode"].ToString() + "' "; } s = s + " and a.MsgState=0 "; ViewState[vsKey] = s; LoadData(s); } }
/// <summary> /// 加载数据 /// </summary> /// <param name="strWhere">条件</param> void LoadData(string strWhere) { txtName.Text = ""; ChatRoomDAL dal = new ChatRoomDAL(); DataSet ds = dal.GetChatRoomList(strWhere); DataView dv = ds.Tables[0].DefaultView; AspNetPager1.RecordCount = dv.Count; PagedDataSource pds = new PagedDataSource(); pds.DataSource = dv; pds.AllowPaging = true; pds.CurrentPageIndex = AspNetPager1.CurrentPageIndex - 1; pds.PageSize = AspNetPager1.PageSize; Repeater1.DataSource = pds; Repeater1.DataBind(); }