private void LoadData_Bitralai() { sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString(); Pager7.PageSize = Global.MembersPerPage; DataSet _ds; _ds = _daltinbai.BindGridT_NewsEditor(Pager7.PageIndex, Pager7.PageSize, BuildSQL(3, sOrder)); 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 = _daltinbai.BindGridT_NewsEditor(Pager7.PageIndex - 1, Pager7.PageSize, BuildSQL(3, sOrder)); DataGrid_TinTraLai.DataSource = _ds; DataGrid_TinTraLai.DataBind(); Pager7.TotalRecords = CurrentPage7.TotalRecords = TotalRecords; CurrentPage7.TotalPages = Pager7.CalculateTotalPages(); CurrentPage7.PageIndex = Pager7.PageIndex; Session["PageIndex"] = Pager7.PageIndex; }
private void LoadData_DangXuly() { sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString(); Pager7.PageSize = Global.MembersPerPage; HPCBusinessLogic.DAL.TinBaiDAL _T_newsDAL = new HPCBusinessLogic.DAL.TinBaiDAL(); DataSet _ds; _ds = _T_newsDAL.BindGridT_NewsEditor(Pager7.PageIndex, Pager7.PageSize, BuildSQL(2, sOrder)); 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_NewsEditor(Pager7.PageIndex - 1, Pager7.PageSize, BuildSQL(2, sOrder)); DataGrid_Dangxuly.DataSource = _ds; DataGrid_Dangxuly.DataBind(); Pager7.TotalRecords = CurrentPage7.TotalRecords = TotalRecords; CurrentPage7.TotalPages = Pager7.CalculateTotalPages(); CurrentPage7.PageIndex = Pager7.PageIndex; Session["PageIndex"] = Pager7.PageIndex; }
private void LoadData_Baidaxuly() { sOrder = " ORDER BY NgayTao DESC"; Pager7.PageSize = Global.MembersPerPage; DataSet _ds; _ds = _daltinbai.Bind_PhienBanDynamic(Pager7.PageIndex, Pager7.PageSize, BuildSQL_Phienban(sOrder)); 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 = _daltinbai.Bind_PhienBanDynamic(Pager7.PageIndex - 1, Pager7.PageSize, BuildSQL_Phienban(sOrder)); DataGrid_TinDaXuLy.DataSource = _ds; DataGrid_TinDaXuLy.DataBind(); Pager7.TotalRecords = CurrentPage7.TotalRecords = TotalRecords; CurrentPage7.TotalPages = Pager7.CalculateTotalPages(); CurrentPage7.PageIndex = Pager7.PageIndex; Session["PageIndex"] = Pager7.PageIndex; }