protected void BindData(int pageindex, int parentId) { try { string where = GetAdvSearchWhereOption(); DataTable dt = new DataTable(); string allTiaoshu = dtrowsHidden.Value.ToString(); //获取到所有的条数 int alltiaoshuInt = int.Parse(allTiaoshu); dt = pageControl.GetList_FenYe_Common(where, pageindex, GridView1.PageSize, alltiaoshuInt, "vBudget_Department_List", "PARENTID").Tables[0]; pageindex = pageControl.pageindex(pageindex, GridView1.PageSize, alltiaoshuInt); //获取当前要显示的页码数【如果最后一页的最后一条记录被删除后,还能正常显示】 if (dt.Rows.Count > 0) { GridView1.Visible = true; GridView1.DataSource = dt; //指定GridView1的数据是dv GridView1.DataBind(); //将上面指定的信息绑定到GridView1上 notice.Text = ""; int parentBudgetNameIndex = 5, parentBalanceIndex = 6, parentYEBalanceIndex = 7; common.GroupRows(GridView1, parentBudgetNameIndex, parentBudgetNameIndex); common.GroupRows(GridView1, parentBudgetNameIndex, parentBalanceIndex); common.GroupRows(GridView1, parentBudgetNameIndex, parentYEBalanceIndex); pageControl.SetSelectPage(pageindex, int.Parse(dtrowsHidden.Value.ToString()), DropDownList2, GridView1.PageSize, FirstPage, NextPage, PreviousPage, LastPage, Label_showInfo); //加载通用组件里面的分页函数 pageControlShow.Visible = true; //如果记录集不为空,则显示分页控件 } else { //Button_sumbit.Enabled = false; //Button_modify.Enabled = false; //Button_check.Enabled = false; //div_total.Visible = false; // Button_reset.Enabled = false; GridView1.Visible = false; notice.Text = "*没有符合条件的结果!"; pageControlShow.Visible = false; //如果记录集为空,则不显示分页控件 if (alltiaoshuInt > 0) { BindData(pageindex - 1, parentId); } } } catch (Exception e) { } }
protected void BindData(int pageIndex = 1) { try { string allTiaoshu = dtrowsHidden.Value.ToString(); //获取到所有的条数 int alltiaoshuInt = int.Parse(allTiaoshu); string swhere = " 1=1 "; if (!string.IsNullOrEmpty(txtJF.Text)) { swhere += string.Format(" and BudgetName like '%{0}%'", txtJF.Text); } DataTable dt = new DataTable(); dt = pageControl.GetList_FenYe_Common(swhere, pageIndex, GridView2.PageSize, alltiaoshuInt, "vBudget_Department_Statistical", "ParentId").Tables[0]; pageIndex = pageControl.pageindex(pageIndex, GridView2.PageSize, alltiaoshuInt); //获取当前要显示的页码数【如果最后一页的最后一条记录被删除后,还能正常显示】 if (dt.Rows.Count > 0) { string rowNumberCol = "PX"; dt.Columns.Add(rowNumberCol, typeof(string)); for (int i = 0; i < dt.Rows.Count; i++) { dt.Rows[i][rowNumberCol] = i + 1; } GridView2.Visible = true; GridView2.DataSource = dt; GridView2.DataBind(); LB_MSG.Text = ""; common.GroupRows(GridView2, 10, 10); common.GroupRows(GridView2, 10, 11); common.GroupRows(GridView2, 10, 12); pageControl.SetSelectPage(pageIndex, int.Parse(dtrowsHidden.Value.ToString()), DDL_ToPage, GridView2.PageSize, FirstPage, NextPage, PreviousPage, LastPage, Label_showInfo); //加载通用组件里面的分页函数 pageControlShow.Visible = true; //如果记录集不为空,则显示分页控件 } } catch (Exception e) { } }