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