public void Search()
{
string Str_Search = GetSQLSearch();
if (!string.IsNullOrEmpty(Str_Search))
{
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.DAL.T_NewsDAL _T_newsDAL = new HPCBusinessLogic.DAL.T_NewsDAL();
DataSet _ds;
_ds = _T_newsDAL.BindGridT_NewsSearchEditor(pages.PageIndex, pages.PageSize, Str_Search);
if (_ds != null)
{
try
{
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_NewsSearchEditor(pages.PageIndex - 1, pages.PageSize, Str_Search);
}
if (TotalRecord > 0)
{
dgr_tintuc.DataSource = _ds;
dgr_tintuc.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = TotalRecords;
CurrentPage2.TotalPages = pages.CalculateTotalPages();
CurrentPage2.PageIndex = pages.PageIndex;
Panel_DS_Ketqua.Visible = true;
}
else
{
dgr_tintuc.DataSource = null;
dgr_tintuc.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = 0;
CurrentPage2.TotalPages = 1;
CurrentPage2.PageIndex = 1;
Panel_DS_Ketqua.Visible = false;
}
}
catch
{
dgr_tintuc.DataSource = null;
dgr_tintuc.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = 0;
CurrentPage2.TotalPages = 1;
CurrentPage2.PageIndex = 1;
}
}
else
{
dgr_tintuc.DataSource = null;
dgr_tintuc.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = 0;
CurrentPage2.TotalPages = 1;
CurrentPage2.PageIndex = 1;
Panel_DS_Ketqua.Visible = false;
}
}
else
{
System.Web.UI.ScriptManager.RegisterStartupScript(this, typeof(string), "Message", "alert('" + CommonLib.ReadXML("msgXacnhanngaythang") + "');", true);
}
}
