private void LoadData_DangXuly()
{
string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
pages.PageSize = 15;
HPCBusinessLogic.DAL.T_NewsDAL _T_newsDAL = new HPCBusinessLogic.DAL.T_NewsDAL();
string tieude = txt_tieude.Text.Trim();
Session["searchvalueroot"] = null;
if (tieude != "")
{
Session["searchvalueroot"] = UltilFunc.SplitString(tieude);
}
DataSet _ds;
_ds = _T_newsDAL.BindGridT_NewsDynamic(pages.PageIndex, pages.PageSize, BuildSQL(6, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"));
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 = _T_newsDAL.BindGridT_NewsDynamic(pages.PageIndex, pages.PageSize, BuildSQL(6, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"));
}
dgr_tintuc1.DataSource = _ds;
dgr_tintuc1.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = TotalRecords;
CurrentPage2.TotalPages = pages.CalculateTotalPages();
CurrentPage2.PageIndex = pages.PageIndex;
}
