Пример #1
0
        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);
            }
        }
Пример #2
0
        /// <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();
        }