private void getTest() { DataSet ds = DbHelperSQL.Query("select *,(select top 1 s.ScorceNub from Scorce s where s.WID=w.WID order by s.ScorceDate desc) ScorceNub from Works w"); ReviewDataWorks.DataSource = ds.Tables[0].DefaultView; ReviewDataWorks.DataBind(); }
//Repeater分页控制显示方法 public void contrlRepeater() { string groupID = ddlt_Area.SelectedValue; string zptypeID = ddlt_T_zptype.SelectedValue; DataTable pageDt = getWorksInfo(groupID, zptypeID); PagedDataSource pds = new PagedDataSource(); pds.DataSource = pageDt.DefaultView; pds.AllowPaging = true; pds.PageSize = 6; pds.CurrentPageIndex = Convert.ToInt32(this.labPage.Text) - 1; ReviewDataWorks.DataSource = pds; LabCountPage.Text = pds.PageCount.ToString(); labPage.Text = (pds.CurrentPageIndex + 1).ToString(); this.lbtnpritPage.Enabled = true; this.lbtnFirstPage.Enabled = true; this.lbtnNextPage.Enabled = true; this.lbtnDownPage.Enabled = true; if (pds.CurrentPageIndex < 1) { this.lbtnpritPage.Enabled = false; this.lbtnFirstPage.Enabled = false; } if (pds.CurrentPageIndex == pds.PageCount - 1) { this.lbtnNextPage.Enabled = false; this.lbtnDownPage.Enabled = false; } ReviewDataWorks.DataBind(); }