private void LoadData()
{
try
{
string FulltextSearch = UltilFunc.ReplaceAll(txt_tieude.Text.Trim(), "'", "’");
string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.DAL.TinBaiDAL _NewsDal = new HPCBusinessLogic.DAL.TinBaiDAL();
DataSet _ds;
_ds = _NewsDal.BindGridT_NewsFullTeztSearch(pages.PageIndex, pages.PageSize, BuildSql(sOrder), UltilFunc.SplitString(FulltextSearch));
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 = _NewsDal.BindGridT_NewsFullTeztSearch(pages.PageIndex - 1, pages.PageSize, BuildSql(sOrder), UltilFunc.SplitString(FulltextSearch));
}
DataGrid_tinbai.DataSource = _ds;
DataGrid_tinbai.DataBind();
pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords;
CurrentPage.TotalPages = pages.CalculateTotalPages();
CurrentPage.PageIndex = pages.PageIndex;
}
catch (Exception ex)
{ throw ex; }
}
private void LoadData()
{
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.DAL.TinBaiDAL _T_newsDAL = new HPCBusinessLogic.DAL.TinBaiDAL();
DataSet _ds;
int Vungmien = 0;
if (cboVungmien.SelectedValue != "")
{
Vungmien = int.Parse(cboVungmien.SelectedValue);
}
_ds = _T_newsDAL.Sp_ListThongKeNhuanBut(pages.PageIndex, pages.PageSize, int.Parse(cbo_Anpham.SelectedValue), int.Parse(cboThanhtoan.SelectedValue), txt_tungay.Text.Trim(), txt_denngay.Text.Trim(), int.Parse(cbo_PVCTV.SelectedValue), Vungmien, Global.MaXuatBan);
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.Sp_ListThongKeNhuanBut(pages.PageIndex, pages.PageSize, int.Parse(cbo_Anpham.SelectedValue), int.Parse(cboThanhtoan.SelectedValue), txt_tungay.Text.Trim(), txt_denngay.Text.Trim(), int.Parse(cbo_PVCTV.SelectedValue), Vungmien, Global.MaXuatBan);
}
DataGrid_tinbai.DataSource = _ds;
DataGrid_tinbai.DataBind();
pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords;
CurrentPage.TotalPages = pages.CalculateTotalPages();
CurrentPage.PageIndex = pages.PageIndex;
}
private void LoadData()
{
HPCBusinessLogic.DAL.TinBaiDAL _T_newsDAL = new HPCBusinessLogic.DAL.TinBaiDAL();
DataSet _ds;
_ds = _T_newsDAL.Sp_ListTraCuuNhuanBut(GetWhere());
DataGrid_tinbai.DataSource = _ds;
DataGrid_tinbai.DataBind();
}
private void LoadData()
{
string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
pages.PageSize = Global.MembersPerPage;
HPCBusinessLogic.DAL.TinBaiDAL _T_newsDAL = new HPCBusinessLogic.DAL.TinBaiDAL();
DataSet _ds;
_ds = _T_newsDAL.BindGridT_Tulieu(pages.PageIndex, pages.PageSize, BuildSQL(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_Tulieu(pages.PageIndex - 1, pages.PageSize, BuildSQL(sOrder));
DataGrid_tinbai.DataSource = _ds;
DataGrid_tinbai.DataBind();
pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords;
CurrentPage.TotalPages = pages.CalculateTotalPages();
CurrentPage.PageIndex = pages.PageIndex;
}
private void LoadData()
{
string sOrder = GetOrderString() == "" ? "" : " ORDER BY " + GetOrderString();
pages.PageSize = Global.MembersPerPage;
DataSet _ds;
_ds = _Dal.Sp_ListT_AutoSaveDynamic(pages.PageIndex, pages.PageSize, BuildSQL(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 = _Dal.Sp_ListT_AutoSaveDynamic(pages.PageIndex - 1, pages.PageSize, BuildSQL(sOrder));
}
DataGrid_tinbai.DataSource = _ds;
DataGrid_tinbai.DataBind();
pages.TotalRecords = CurrentPage.TotalRecords = TotalRecords;
CurrentPage.TotalPages = pages.CalculateTotalPages();
CurrentPage.PageIndex = pages.PageIndex;
}
