private void query() { try { pageSize = Int32.Parse(tbxPage.Text.Trim()); StateHandle handle = new StateHandle(); int totalRows = handle.totalRows(dtpStart.Text.Trim(), dtpEnd.Text.Trim(), tbxOrderId.Text.Trim(), tbxPhoneNo.Text.Trim()); int totalPage = totalRows % pageSize >= 1 ? totalRows / pageSize + 1 : totalRows / pageSize; if (pageIndex < 1) { pageIndex = 1; } if (pageIndex > totalPage) { pageIndex = totalPage; } label5.Text = "总条数:" + totalRows; labelPage.Text = pageIndex.ToString() + "/" + totalPage; DataTable dt = handle.selectOrderList(dtpStart.Text.Trim(), dtpEnd.Text.Trim(), tbxOrderId.Text.Trim(), tbxPhoneNo.Text.Trim(), pageIndex, pageSize); dgvOrderShow.DataSource = dt; } catch (Exception ex) { MessageBox.Show("错误", ex.Message); } }