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