首页 > 代码库 > 普通分页
普通分页
#region 全局变量 PageIndex PageSize Conntion Count MySqlHelp Sqldb = new MySqlHelp(); QueryHelp db = new QueryHelp(); // 页数 public int PageIndex = 1; //条数 public int PageSize = 1000; //链接语句 public string Conntion = "server=192.168.1.175;user id=root;password=123456;database=txst;"; public int Count { get; set; } #endregion #region 设置按钮首页,尾页,下一页,上一页的可用和不可用属性 /// <summary> ///DownPag.IsEnabled 上一页 ///UpPag.IsEnabled 下一页 ///onePag.IsEnabled 首页 ///Listpag.IsEnabled 尾页 ///<param name="state"></param> void SetState(bool state) { DownPag.IsEnabled = state; UpPag.IsEnabled = state; onePag.IsEnabled = state; Listpag.IsEnabled = state; } #endregion #region 加载 public Selectpag() { InitializeComponent(); string safeSql = "TableTestSelect"; Select_pag_pag.DataContext = db.ToList<tabletset>(safeSql, Conntion); Count = GeiCountPage(); UpPag.IsEnabled = false; onePag.IsEnabled = false; } #endregion #region 首页 private void onePagClick(object sender, RoutedEventArgs e) { PageIndex = 1; List<DbParameter> listpar = new List<DbParameter>{ new MySqlParameter("?pageIndex",PageIndex), new MySqlParameter("?pageSize",PageSize) }; string safeSql = "getpager"; Select_pag_pag.DataContext = db.ToList<tabletset>(safeSql, listpar, Conntion); } #endregion #region 尾页 private void ListpagClick(object sender, RoutedEventArgs e) { PageIndex = GeiCountPage(); List<DbParameter> listpar = new List<DbParameter>{ new MySqlParameter("?pageIndex",PageIndex), new MySqlParameter("?pageSize",PageSize) }; string safeSql = "getpager"; Select_pag_pag.DataContext = db.ToList<tabletset>(safeSql, listpar, Conntion); } #endregion #region 上一页 private void UpPagClick(object sender, RoutedEventArgs e) { SetState(true); PageIndex--; if (PageIndex <= 1) { PageIndex = 1; UpPag.IsEnabled = false; onePag.IsEnabled = false; } List<DbParameter> listpar = new List<DbParameter>{ new MySqlParameter("?pageIndex",PageIndex), new MySqlParameter("?pageSize",PageSize) }; string safeSql = "getpager"; Select_pag_pag.DataContext = db.ToList<tabletset>(safeSql, listpar, Conntion); } #endregion #region 下一页 private void DownPag_Click(object sender, RoutedEventArgs e) { SetState(true); PageIndex++; if (PageIndex >= Count) { PageIndex = Count; DownPag.IsEnabled = false; Listpag.IsEnabled = false; } List<DbParameter> listpar = new List<DbParameter>{ new MySqlParameter("?pageIndex",PageIndex), new MySqlParameter("?pageSize",PageSize) }; string safeSql = "getpager"; Select_pag_pag.DataContext = db.ToList<tabletset>(safeSql, listpar, Conntion); } #endregion #region 测试表 class tabletset { public int ID { get; set; } public string NameTest { get; set; } public string PasswordTset { get; set; } } #endregion #region 总条数 private int GeiCountPage() { string cmdText = "tableByPager"; List<DbParameter> ListPar = new List<DbParameter> { new MySqlParameter("?Count",DbType.Int32){Direction= ParameterDirection.Output} }; Sqldb.ExecuteNonQuery(cmdText, ListPar, Conntion); int PageCount = int.Parse(ListPar[0].Value.ToString()); if (PageCount % PageSize == 0) { PageCount = PageCount / PageSize; } else { PageCount = (PageCount / PageSize) + 1; } return PageCount; } #endregion
声明:以上内容来自用户投稿及互联网公开渠道收集整理发布,本网站不拥有所有权,未作人工编辑处理,也不承担相关法律责任,若内容有误或涉及侵权可进行投诉: 投诉/举报 工作人员会在5个工作日内联系你,一经查实,本站将立刻删除涉嫌侵权内容。