public void Search()
{
string Str_Search = "";
string Str_SearchPic = "", Str_SearchVideo = "", Str_SearchAnhTS = "";
int SearchPic = 0, SearchVideo = 0, SearchTinbai = 0, SearchAnhTS = 0;
type = int.Parse(cbo_types.SelectedValue);
if (type == 1)
{
SearchTinbai = 1;
Str_Search = GetSQLSearch();
}
if (type == 2)
{
SearchPic = 1;
Str_SearchPic = GetSQLSearchPic();
}
if (type == 3)
{
SearchVideo = 1;
Str_SearchVideo = GetSQLSearchVideo();
}
if (type == 4)
{
SearchAnhTS = 1;
Str_SearchAnhTS = GetSQLSearchAnhTS();
}
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.DAL.T_NewsDAL _T_newsDAL = new HPCBusinessLogic.DAL.T_NewsDAL();
DataSet _ds;
_ds = _T_newsDAL.Search_All_News_Nhanbut(pages.PageIndex, pages.PageSize, SearchTinbai, SearchPic, SearchVideo, SearchAnhTS, Str_Search, Str_SearchPic, Str_SearchVideo, Str_SearchAnhTS);
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.Search_All_News_Nhanbut(pages.PageIndex - 1, pages.PageSize, SearchTinbai, SearchPic, SearchVideo, SearchAnhTS, Str_Search, Str_SearchPic, Str_SearchVideo, Str_SearchAnhTS);
}
if (TotalRecord > 0)
{
dgr_tintuc.DataSource = _ds.Tables[0];
dgr_tintuc.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = TotalRecords;
CurrentPage2.TotalPages = pages.CalculateTotalPages();
CurrentPage2.PageIndex = pages.PageIndex;
dgr_tintuc.Columns[8].Visible = true;
cmd_Chamnhanbut.Visible = true;
foreach (DataGridItem item in dgr_tintuc.Items)
{
item.Attributes.Add("onmouseover", "currColor=this.style.backgroundColor;this.style.backgroundColor='" + CommonLib.HPCOnmouseoverGrid() + "'");
item.Attributes.Add("onmouseout", "this.style.backgroundColor=currColor");
TextBox txt_tien = (TextBox)item.FindControl("txt_tien");
double _money = 0;
try
{
_money = double.Parse(txt_tien.Text);
}
catch
{ _money = 0; }
txt_tien.Text = string.Format("{0:#,#}", _money).Replace(".", ",");
}
Panel_DS_Ketqua.Visible = true;
}
else
{
dgr_tintuc.DataSource = null;
dgr_tintuc.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = 0;
CurrentPage2.TotalPages = 1;
CurrentPage2.PageIndex = 1;
cmd_Chamnhanbut.Visible = false;
Panel_DS_Ketqua.Visible = false;
}
}
catch
{
dgr_tintuc.DataSource = null;
dgr_tintuc.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = 0;
CurrentPage2.TotalPages = 1;
CurrentPage2.PageIndex = 1;
cmd_Chamnhanbut.Visible = false;
Panel_DS_Ketqua.Visible = false;
}
}
else
{
dgr_tintuc.DataSource = null;
dgr_tintuc.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = 0;
CurrentPage2.TotalPages = 1;
CurrentPage2.PageIndex = 1;
cmd_Chamnhanbut.Visible = false;
Panel_DS_Ketqua.Visible = false;
}
}
