public void LoadDataListNews() { string FulltextSearch = UltilFunc.ReplaceAll(_Tieude.Trim(), "'", "’"); string sOrder = " ORDER BY Ngaytao DESC"; try { if (PageIndex == 1 || PageIndex == 0) { PageIndex = 0; } else { PageIndex = PageIndex - 1; } PageSize = Global.MembersPerPage; DataSet _ds; _ds = _Daltinbai.BindGridT_NewsFullTeztSearch(PageIndex, PageSize, GetWhere(sOrder), UltilFunc.SplitString(FulltextSearch)); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); if (TotalRecord == 0 && PageIndex > 0) { _ds = _Daltinbai.BindGridT_NewsFullTeztSearch(PageIndex - 1, PageSize, GetWhere(sOrder), UltilFunc.SplitString(FulltextSearch)); } _dt = _ds.Tables[0]; totalItem1.Value = TotalRecords.ToString(); pagesize1.Value = PageSize.ToString(); currentpage1.Value = (PageIndex + 1).ToString(); } catch (Exception ex) { throw ex; } }
private void LoadData() { try { string FulltextSearch = UltilFunc.ReplaceAll(txt_tieude.Text.Trim(), "'", "’"); string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString(); pages.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.TinBaiDAL _NewsDal = new HPCBusinessLogic.DAL.TinBaiDAL(); DataSet _ds; _ds = _NewsDal.BindGridT_NewsFullTeztSearch(pages.PageIndex, pages.PageSize, BuildSql(sOrder), UltilFunc.SplitString(FulltextSearch)); int TotalRecords = Convert.ToInt32(_ds.Tables[1].Rows[0].ItemArray[0].ToString()); int TotalRecord = Convert.ToInt32(_ds.Tables[0].Rows.Count); if (TotalRecord == 0) { _ds = _NewsDal.BindGridT_NewsFullTeztSearch(pages.PageIndex - 1, pages.PageSize, BuildSql(sOrder), UltilFunc.SplitString(FulltextSearch)); } DataGrid_tinbai.DataSource = _ds; DataGrid_tinbai.DataBind(); pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords; CurrentPage.TotalPages = pages.CalculateTotalPages(); CurrentPage.PageIndex = pages.PageIndex; } catch (Exception ex) { throw ex; } }