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);
     }
 }