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) { ddlHolidayList.Items.Clear(); HoliDayDAL Holdaydal = new HoliDayDAL(); DataSet ds = new DataSet(); if (Session["strRoleCode"].ToString() == "ADMIN") { ds = Holdaydal.GetHoliDayList(""); } else { ds = Holdaydal.GetHoliDayList(" AND SiteCode ='" + Session["strSiteCode"].ToString() + "' "); } DataTable dt = ds.Tables[0]; DataRow dr = ds.Tables[0].NewRow(); dr["ID"] = 0; dr["Htitle"] = "--全部--"; dt.Rows.InsertAt(dr, 0); ddlHolidayList.DataSource = ds.Tables[0].DefaultView; ddlHolidayList.DataTextField = "Htitle"; ddlHolidayList.DataValueField = "ID"; ddlHolidayList.DataBind(); AspNetPager1.CurrentPageIndex = 1; string s = ""; if (Session["strRoleCode"].ToString() != "ADMIN") { s = " AND b.SiteCode = '" + Session["strSiteCode"].ToString() + "' "; } ViewState[vsKey] = s; LoadData(s); } }
/// <summary> /// 加载数据 /// </summary> /// <param name="strWhere">条件</param> void LoadData(string strWhere) { HoliDayDAL holidayDal = new HoliDayDAL(); DataSet ds = holidayDal.GetHoliDayList(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(); }