分页查询

lu

2024-11-25 085fef1f2662c238d56ee0dbaae1e4c777c171e2

 DevApp/Gs.DevApp/bin/Debug/templeEasyCode/category1/category.cs

@@ -24,8 +24,9 @@
            this.toolBarMenu1.btnEscClick += ToolBarMenu1_btnEscClick;
            this.toolBarMenu1.btnQueryClick += ToolBarMenu1_btnQueryClick;
            gcMain.MouseDoubleClick += GcMain_MouseDoubleClick;
            getPageList(1, UtilityHelper.GetPageSize());
          getPageList(1);
            pageBar1.PagerEvent += PageBar1_PagerEvent;
 Gs.DevApp.ToolBox.UtilityHelper.SetGridSear(gridView1);
            gridView1.CustomDrawRowIndicator += (s, e) =>
            {
                if (e.Info.IsRowIndicator && e.RowHandle >= 0)
@@ -41,7 +42,12 @@
                e.Graphics.DrawString(str, f, Brushes.Gray, r);
            };
        }

   private async void GridView1_ColumnFilterChanged(object sender, EventArgs e)
   {
       _filterList = Gs.DevApp.ToolBox.UtilityHelper.GetDilter(gridView1.Columns);
       await Task.Delay(100);
       getPageList(1);
   }
        /// <summary>
        /// 双击事件
        /// </summary>
@@ -60,7 +66,7 @@
        /// <param name="pageSize"></param>
        private void PageBar1_PagerEvent(int curPage, int pageSize)
        {
            getPageList(curPage, pageSize);
            getPageList(curPage);
        }
        /// <summary>
        /// 查询事件
@@ -69,7 +75,10 @@
        /// <param name="e"></param>
        private void ToolBarMenu1_btnQueryClick(object sender, EventArgs e)
        {
            Gs.DevApp.UserControl.ShowFilter frm = new Gs.DevApp.UserControl.ShowFilter(gridView1.Columns, _filterList);
          gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
gridView1.ActiveFilter.Clear();
gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
var frm = new ShowFilter(gridView1.Columns, _filterList);
            frm.UpdateParent += Frm_UpdateParent;
            frm.ShowDialog();
        }
@@ -140,7 +149,16 @@
             if (xtraTabControl1.SelectedTabPageIndex == 1)
      getModel(lbGuid.Text.Trim(), false, 999);
  else
      getPageList(1, UtilityHelper.GetPageSize());
{
    _filterList.Clear();
    if (gridView1.ActiveFilter.Count > 0)
    {
        gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
        gridView1.ActiveFilter.Clear();
        gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
    }
    getPageList(1);
}
        }
        /// <summary>
        /// 修改事件
@@ -212,31 +230,34 @@
        /// </summary>
        /// <param name="curPage">第几页</param>
        /// <param name="pageSize">每页几条</param>
        private void getPageList(int curPage, int pageSize)
        private async void getPageList(int curPage)
        {
            System.Text.StringBuilder _sbSqlWhere = new System.Text.StringBuilder();
            foreach (FilterEntity itm in _filterList)
            {
                _sbSqlWhere.Append(" and " + itm.fileId + itm.fileOper + "'" + itm.fileValue + "'");
            }
            PageQueryModel pgq = new PageQueryModel(curPage, pageSize, "create_date", "asc", "", _sbSqlWhere.ToString());
            string json = JsonConvert.SerializeObject(pgq);
              UcLoading _loading = new UcLoading();
 var _sbSqlWhere = UtilityHelper.GetSearchWhere(_filterList);
 var pgq = new PageQueryModel(curPage, this.pageBar1.RowsCount, "a.create_date",
 "asc", "", _sbSqlWhere.ToString());
 var json = JsonConvert.SerializeObject(pgq);
            try
            {
                string strReturn = UtilityHelper.HttpPost("", _webServiceName + "GetListPage", json);
                ReturnModel<PageListModel> dd = UtilityHelper.ReturnToTablePage(strReturn);
     var strReturn = await UtilityHelper.HttpPostAsync("",
         _webServiceName + "GetListPage", json);
     var dd = UtilityHelper.ReturnToTablePage(strReturn);
              if (dd.rtnCode > 0)
    {
        DataTable dt = dd.rtnData.list;
        gcMain.BindingContext = new BindingContext();
         gridView1.ColumnFilterChanged -= GridView1_ColumnFilterChanged;
         if (dt.Rows.Count > 0)
         {
        gcMain.DataSource = dt;
        gcMain.ForceInitialize();
        int dddd = dd.rtnData.pages;//总页
        pageBar1.TotalPages = dddd;
        pageBar1.RecordCount = dd.rtnData.total;//记录总数
         }
         else
             UtilityHelper.SetDefaultTable(gcMain, gridView1);
         gridView1.ColumnFilterChanged += GridView1_ColumnFilterChanged;
         pageBar1.TotalPages = dd.rtnData.pages;//总页
        pageBar1.CurrentPage = curPage;//当前页
        pageBar1.RowsCount = pageSize;//每页显示
        pageBar1.setTxt();
         pageBar1.RecordCount = dd.rtnData.total;//总记录数
    }
    else
    {
@@ -245,8 +266,9 @@
            }
            catch (Exception ex)
            {
                ToolBox.MsgHelper.Warning("提示：" + ex.Message);
     MsgHelper.Warning("提示：" + ex.Message);
            }
 _loading.Stop();
        }
        /// <summary>
        ///