protected void LoadData_UnPublisher()
{
string sOrder = " Order by News_DateSend DESC ";
PagerUnPublish.PageSize = Global.MembersPerPage;
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(PagerUnPublish.PageIndex, PagerUnPublish.PageSize, BuildSQL(ConstNews.NewsUnPublishing, 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)
{
for (int i = 1; i <= TotalRecords; i++)
{
_ds = _T_newsDAL.BindGridT_NewsDynamic(PagerUnPublish.PageIndex - i, PagerUnPublish.PageSize, BuildSQL(ConstNews.NewsUnPublishing, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"));
if (_ds.Tables[0].Rows.Count > 0)
{
break;
}
}
}
this.dgListNewsUnPublish.DataSource = _ds;
this.dgListNewsUnPublish.DataBind();
this.PagerUnPublish.TotalRecords = this.CurrentPageUnPublish.TotalRecords = TotalRecords;
this.CurrentPageUnPublish.TotalPages = this.PagerUnPublish.CalculateTotalPages();
this.CurrentPageUnPublish.PageIndex = this.PagerUnPublish.PageIndex;
GetTotal();
_ds.Clear();
}
private void LoadData_DangXuly()
{
string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
pages.PageSize = Global.MembersPerPage;
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)
{
for (int i = 1; i <= TotalRecords; i++)
{
_ds = _T_newsDAL.BindGridT_NewsDynamic(pages.PageIndex - i, pages.PageSize, BuildSQL(6, sOrder), UltilFunc.ReplaceAll(UltilFunc.SplitString(tieude), "'", "’"));
if (_ds.Tables[0].Rows.Count > 0)
{
break;
}
}
}
dgr_tintuc1.DataSource = _ds;
dgr_tintuc1.DataBind();
pages.TotalRecords = CurrentPage2.TotalRecords = TotalRecords;
CurrentPage2.TotalPages = pages.CalculateTotalPages();
CurrentPage2.PageIndex = pages.PageIndex;
GetTotal();
_ds.Clear();
}
